DotNET Schools | Blogs & Tutorials for Microsoft.NET and Leading web Technologies

Capture SOAP Request using Fiddler

30. December 2017 Banketeshvar Narayan .NET (0)

Sometimes you are not able to Capture Soap request using fiddler. In that case you have to make some changes in config file.

Add these lines to web.config files:

<system.net>  
   <defaultProxy>  
      <proxy bypassonlocal="False" usesystemdefault="True" proxyaddress="http://127.0.0.1:8888" />  
   </defaultProxy>  
</system.net>  

Using Struct as Directive in C# 6 & C# 7

30. December 2017 Banketeshvar Narayan C#, C# 6.0, C# 7.0 (0)

AS we know that before C# 6 we use to include only namespaces as “using directive” But in C# 6 & C# 7 we can include static classes, enum, non-static classes & structs too as “using directive”.

In this code snippet I am going to show you a sample code for “using Struct as directive” so that you can aware about its syntax and usage. You may be interested in code snippet of,

1. 1. Using Static Classes as directive

2. 2. Using non-Static classes as directive

3. 3. Using Enum as directive

Below is the code snippet of “Using Struct as directive”,

using static System.Drawing.Color; //struct  
using static System.DateTime; //struct  
using static System.Console;  
  
namespace UsingStructAsDirectiveinCSharp6n7  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //you may need to add System.Drawing assembly reference   
            //for "using static System.Drawing.Color"  
            var color =Red; //System.Drawing.Color              
  
            var isLeapyear = IsLeapYear(2016); //System.DateTime  
  
            WriteLine($"Today is: " + Now.DayOfWeek); //System.DateTime            
  
        }  
    }  
}  

Variable.ToString() vs. Convert.ToString(variable)

30. December 2017 Banketeshvar Narayan .NET, C# (0)

variable.ToString() and Convert.ToString(variable) both are used for converting data into string. But the main difference is that Convert.ToString() handles null, while ToString() doesn't handle null value.

Apart from that both works almost same. Let’s take an example to explain it:

double amount = 10000.0;  
Console.WriteLine(amount.ToString());  
Console.WriteLine(Convert.ToString(amount));   

In this case both method will convert “amount” to string and will return the same value but in case of null value variable.ToString() method will throw exception.

Now take another example:

object myObject = null;  
string myString;  
  
//myString = myObject.ToString();  
// System.NullReferenceException : { "Object reference not set to an instance of an object."}  
  
myString = Convert.ToString(myObject);  
//return empty string

Getting More than 2 Values for an Enum Item

30. December 2017 Banketeshvar Narayan .NET, C# (0)

As we know that we can get Enum and it value from an Enum type e.g. I want to create an enum for sorting of article like below:

enum ArticleSortingOptions  
{  
   MostPopularArticle =1,  
   LatestArticles =2,  
   FeaturedArtilces =3,  
   MostLikedArtilces =4,  
   MostCommentedArtilces=5  
}  

And accessing it like

WriteLine(MostPopularArticle.ToString());  
WriteLine((int)MostPopularArticle);  

Output

MostPopularArticle

1

you may be thinking that I am aceesing enum item without enum name. Yes, it is possible in C# 6 & C# 7 that we can acess enum items without enum name for that we have to write enum name in using statement i.e.

using static MultiValuedEnum.ArticleSortingOptions;  

You will never prefer to display the value like “MostPopularArticle” but to be displayed like “Most Popular Article”. As we know that enum will not allow you to write an item with spaces. So we will require 3 types of values

1. Integer value of enum item.

2. 2. Name of enum Item (string Value of enum).

3. 3. Description of Enum (or some other value as per requirement).

We can achieve this by writing and extension method for enum.

public static class ExtendEnum  
{  
   public static string DisplayString<T>(this T enumVal)  
   {  
      FieldInfo fi = enumVal.GetType().GetField(enumVal.ToString());  
      var attrs = fi?.GetCustomAttributes(typeof(DescriptionAttribute), true);  
      if (attrs != null && attrs.Length > 0)  
      {  
         return ((DescriptionAttribute)attrs[0]).Description;  
      }  
      return "No Description found";  
   }  
}  

And access like:

WriteLine(MostPopularArticle.ToString());  
WriteLine((int)MostPopularArticle);  
WriteLine(MostPopularArticle.DisplayString());  

Complete Code:

using System.ComponentModel;  
using System.Reflection;  
using static MultiValuedEnum.ArticleSortingOptions;  
using static System.Console;  
  
namespace MultiValuedEnum  
{  
    enum ArticleSortingOptions  
    {  
        [Description("Most Popular Article")]  
        MostPopularArticle = 1,          
        LatestArticles = 2,  
        FeaturedArtilces = 3,  
        MostLikedArtilces = 4,  
        MostCommentedArtilces = 5  
    }  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            WriteLine(MostPopularArticle.ToString());  
            WriteLine((int)MostPopularArticle);  
            WriteLine(MostPopularArticle.DisplayString());  
        }  
    }  
  
    public static class ExtendEnum  
    {  
        public static string DisplayString<T>(this T enumVal)  
        {  
            FieldInfo fi = enumVal.GetType().GetField(enumVal.ToString());  
            var attrs = fi?.GetCustomAttributes(typeof(DescriptionAttribute), true);  
            if (attrs != null && attrs.Length > 0)  
            {  
                return ((DescriptionAttribute)attrs[0]).Description;  
            }  
            return "No Description found";  
        }  
    }  
}  

Output

MostPopularArticle

1

Most Popular Article

Converting Enum to Different Format

29. December 2017 Banketeshvar Narayan C# (0)

//way 1
Enum MyNewEnum = (MyColors)Enum.Parse(typeof(MyColors), "RED");
//Way 2
Enum MyNewEnum2 = (MyColors)Enum.Parse(typeof(MyColors), "1");
//Way 3
Enum MyNewEnum3 = (MyColors)1;
//Way 4
Enum MyNewEnum4 = (MyColors)Enum.ToObject(typeof(MyColors), 1);
//Way 5
Enum MyNewEnum5 = (MyColors)3;
//Way 6
string myEnumString = ((MyColors)1).ToString("F");
string myEnumString2 = ((MyColors)1).ToString("F");
string myEnumString3 = MyColors.BLUE.ToString("d");
string myEnumString4 = MyColors.BLUE.ToString("D");
string myEnumString5 = MyColors.BLUE.ToString("g");
string myEnumString6 = MyColors.BLUE.ToString("G");
string myEnumString7 = MyColors.BLUE.ToString("x");
string myEnumString8 = MyColors.BLUE.ToString("X");
//Way 7
string[] colorrList = Enum.GetNames(typeof(MyColors));
string myEnumString9 = Enum.GetName(typeof(MyColors), 5);
//way 8
string myFormatEnumString1 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "d");
string myFormatEnumString2 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "D");
string myFormatEnumString3 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "f");
string myFormatEnumString4 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "F");
string myFormatEnumString5 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "g");
string myFormatEnumString6 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "G");
string myFormatEnumString7 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "x");
string myFormatEnumString8 = Enum.Format(typeof(MyColors), MyColors.ORANGE, "X");

Creating Angular 5 App With Visual Studio 2017 - An Easy Way

27. December 2017 Banketeshvar Narayan Angular2+ (0)

There are multiple ways to create an Angular app with Visual Studio and this article explains one of the easiest and the simplest ways to create Angular 5 app with Visual Studio 2017 using a template.

Let’s start creating an Angular 5 app with Visual Studio 2017 step by step.

Step 1
Download and install the latest version of TypeScript. Read More >>

Read and Write XML File using XMLDocument

30. October 2017 Banketeshvar Narayan .NET (0)

Read & Write XML File using XMLDocument

Write XML File Using Xml Writer,

public void WriteXMLFileUsingXmlWriter()  
{  
    List < LumiaMobile > LumiaMobiles = new List < LumiaMobile > ();  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "lumia550",  
            Height = "136.1 mm",  
            Width = "67.8 mm",  
            Thickness = "9.9 mm",  
            Weight = "141.9 g"  
    });  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "lumia950",  
            Height = "145 mm",  
            Width = "73.2 mm",  
            Thickness = "8.2 mm",  
            Weight = "150 g"  
    });  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "Text",  
            Height = "",  
            Width = "",  
            Thickness = "8.2 mm",  
            Weight = "150 g"  
    });  
    using(XmlWriter writer = XmlWriter.Create("LumiaMobiles.xml"))  
    {  
        writer.WriteStartDocument();  
        writer.WriteStartElement("LumiaMobiles");  
        foreach(LumiaMobile lumiaMobile in LumiaMobiles)  
        {  
            writer.WriteStartElement(lumiaMobile.ModelId);  
            writer.WriteElementString("Height", lumiaMobile.Height);  
            writer.WriteElementString("Width", lumiaMobile.Width);  
            writer.WriteElementString("Thickness", lumiaMobile.Thickness);  
            writer.WriteElementString("Weight", lumiaMobile.Weight);  
            writer.WriteEndElement();  
        }  
        writer.WriteEndElement();  
        writer.WriteEndDocument();  
    }  
}  

The above code snippet will write XML file in single line i.e. not formatted, all content in same line.

<?xml version="1.0" encoding="utf-8"?>  
    <LumiaMobiles>  
        <lumia550>  
            <Height>136.1 mm</Height>  
            <Width>67.8 mm</Width>  
            <Thickness>9.9 mm</Thickness>  
            <Weight>141.9 g</Weight>  
        </lumia550>  
        <lumia950>  
            <Height>145 mm</Height>  
            <Width>73.2 mm</Width>  
            <Thickness>8.2 mm</Thickness>  
            <Weight>150 g</Weight>  
        </lumia950>  
        <Text>  
            <Height />  
            <Width />  
            <Thickness>8.2 mm</Thickness>  
            <Weight>150 g</Weight>  
        </Text>  
    </LumiaMobiles>  

So to write formatted XML data we can use XmlTextWriter,

Write XML File Using Xml TextWriter,

public void WriteXMLFileUsingXmlTextWriter()  
{  
    List < LumiaMobile > LumiaMobiles = new List < LumiaMobile > ();  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "lumia550",  
            Height = "136.1 mm",  
            Width = "67.8 mm",  
            Thickness = "9.9 mm",  
            Weight = "141.9 g"  
    });  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "lumia950",  
            Height = "145 mm",  
            Width = "73.2 mm",  
            Thickness = "8.2 mm",  
            Weight = "150 g"  
    });  
    LumiaMobiles.Add(new LumiaMobile  
    {  
        ModelId = "Text",  
            Height = "",  
            Width = "",  
            Thickness = "8.2 mm",  
            Weight = "150 g"  
    });  
    string filename = "LumiaMobiles.xml";  
    using(XmlTextWriter writer = new XmlTextWriter(new StreamWriter(new FileStream(filename, FileMode.Create))))  
    {  
        writer.Formatting = Formatting.Indented;  
        writer.Indentation = 4;  
        writer.WriteStartDocument();  
        writer.WriteStartElement("LumiaMobiles");  
        foreach(LumiaMobile lumiaMobile in LumiaMobiles)  
        {  
            writer.WriteStartElement(lumiaMobile.ModelId);  
            writer.WriteElementString("Height", lumiaMobile.Height);  
            writer.WriteElementString("Width", lumiaMobile.Width);  
            writer.WriteElementString("Thickness", lumiaMobile.Thickness);  
            writer.WriteElementString("Weight", lumiaMobile.Weight);  
            writer.WriteEndElement();  
        }  
        writer.WriteEndElement();  
        writer.WriteEndDocument();  
    }  
}  

It will write XML file as:

<?xml version="1.0" encoding="utf-8"?>  
<LumiaMobiles>  
    <lumia550>  
        <Height>136.1 mm</Height>  
        <Width>67.8 mm</Width>  
        <Thickness>9.9 mm</Thickness>  
        <Weight>141.9 g</Weight>  
    </lumia550>  
    <lumia950>  
        <Height>145 mm</Height>  
        <Width>73.2 mm</Width>  
        <Thickness>8.2 mm</Thickness>  
        <Weight>150 g</Weight>  
    </lumia950>  
    <Text>  
        <Height />  
        <Width />  
        <Thickness>8.2 mm</Thickness>  
        <Weight>150 g</Weight>  
    </Text>  
</LumiaMobiles>   

Now use the below code to Read the above XML File,

public void ReadXMLFile(string xmlFileName)  
{  
    XmlDocument xmlDocument = new XmlDocument();  
    xmlDocument.Load(xmlFileName);  
    XmlNodeList nodeList = xmlDocument.SelectNodes("LumiaMobiles");  
    foreach(XmlNode node in nodeList)  
    {  
        XmlNodeList lumianodes = node.ChildNodes;  
        foreach(XmlNode item in lumianodes)  
        {  
            Console.WriteLine("ModelID : {0}", item.Name);  
            Console.WriteLine("Height: {0}", item.SelectSingleNode("Height").InnerText);  
            Console.WriteLine("Width: {0}", item.SelectSingleNode("Width").InnerText);  
            Console.WriteLine("Thickness: {0}", item.SelectSingleNode("Thickness").InnerText);  
            Console.WriteLine("Weight: {0}", item.SelectSingleNode("Weight").InnerText);  
            Console.WriteLine();  
        }  
    }  
    Console.ReadKey();  
}  

Learn C # 7.x (articles on C# 7.0, C# 7.1 & 7.2 new features)

22. October 2017 Banketeshvar Narayan C#, C# 7.x (0)

Learn C# 7.0, C# 7.1 & C# 7.2 new features by the collection of articles written by Banketeshvar Narayan

1. C# 7.2 New Features with Visual Studio 2017

2. C# 7.0 And C# 7.1 New Features - Part Two

3. Top 10 New Features of C# 7.0 With Visual Studio 2017

4. Installing and Using .NET 4.7.x, .NET Core 2.0, And C# 7.x With VS 2017

5. Expression Bodied Indexers and Operators with C# 7.0

6. Enabling C# 7.0 Compilation with Visual Studio 2017

7. Understanding ref and out With C# 7.0

8. How to Compile & Test C# 7.0 Features

9. Visual Studio 15 Preview First Look & C# 7.0

Find Any String from a Database in SQL Server

30. September 2017 Banketeshvar Narayan SQL Server (0)

In SQL Server sometimes we get some data for which we are not sure that from which table it is coming the we can use the below stored procedure to find it.

It has 3 input parameters:

@DataToSearch: Data which you want to search.
@DataToReplace: Data with which you want to replace.
@IsExactMatch: Search for exact matching or search any mathing data. If you want to search any matching data you can leave it blank.

This stored procedure does not alter any value in database it only displays the list of table with column name which have the specified data. the @DataToReplace has value the it will show you an script to replace the value which you need to execute separately.

CREATE PROCEDURE FindAnyStringFromTheDataBase  
    @DataToSearch NVARCHAR(4000),  
    @DataToReplace NVARCHAR(4000),  
    @IsExactMatch BIT = 0  
AS  
SET NOCOUNT ON  
   
DECLARE @TempTable TABLE(RowId INT IDENTITY(1,1), SchemaName sysname, TableName sysname, ColumnName SysName, DataType VARCHAR(100), IsDataFound BIT)  
   
    INSERT  INTO @TempTable(TableName,SchemaName, ColumnName, DataType)  
    SELECT  Col.Table_Name,Col.TABLE_SCHEMA, Col.Column_Name, Col.Data_Type  
    FROM    Information_Schema.Columns AS Col  
            INNER Join Information_Schema.Tables AS Tbl  
                ON Col.Table_Name = Tbl.Table_Name  
        AND Col.TABLE_SCHEMA = Tbl.TABLE_SCHEMA  
    WHERE   Table_Type = 'Base Table'  
            And Data_Type In ('ntext','text','nvarchar','nchar','varchar','char')  
   
   
DECLARE @i INT  
DECLARE @MAXValue INT  
DECLARE @TableName sysname  
DECLARE @ColumnName sysname  
DECLARE @SchemaName sysname  
DECLARE @SQL NVARCHAR(4000)  
DECLARE @PARAMETERS NVARCHAR(4000)  
DECLARE @IsDataExists BIT  
DECLARE @SQLTemplate NVARCHAR(4000)  
DECLARE @dbName VARCHAR(100)  
   
SELECT  @SQLTemplate = CASE WHEN @IsExactMatch = 1  
                            THEN 'If Exists(Select *  
                                           From   ReplaceTableName  
                                           Where  Convert(nVarChar(4000), [ReplaceColumnName])  
                                                        = ''' + @DataToSearch + '''  
                                           )  
                                      Set @IsDataExists = 1  
                                  Else  
                                      Set @IsDataExists = 0'  
                            ELSE 'If Exists(Select *  
                                           From   ReplaceTableName  
                                           Where  Convert(nVarChar(4000), [ReplaceColumnName])  
                                                        Like ''%' + @DataToSearch + '%''  
                                           )  
                                      Set @IsDataExists = 1  
                                  Else  
                                      Set @IsDataExists = 0'  
                            END,  
        @PARAMETERS = '@IsDataExists Bit OUTPUT',  
        @i = 1  
   
SELECT @i = 1, @MAXValue = MAX(RowId)  
FROM   @TempTable  
   
WHILE @i <= @MAXValue  
    BEGIN  
        SELECT  @SQL = REPLACE(REPLACE(@SQLTemplate, 'ReplaceTableName', QUOTENAME(SchemaName) + '.' + QUOTENAME(TableName)), 'ReplaceColumnName', ColumnName)  
        FROM    @TempTable  
        WHERE   RowId = @i  
   
   
        PRINT @SQL  
        EXEC SP_EXECUTESQL @SQL, @PARAMETERS, @IsDataExists = @IsDataExists OUTPUT  
   
        IF @IsDataExists =1  
            UPDATE @TempTable SET IsDataFound = 1 WHERE RowId = @i  
   
        SET @i = @i + 1  
    END  
   
SET @dbName = DB_NAME()   
   
SELECT  SchemaName,@dbName as DB,TableName, ColumnName,  
        'Update '+ @dbName+'.'+SchemaName+'.'+TableName+ ' SET '+ColumnName+ ' = replace('+ColumnName+','''+ @DataToSearch+''','''+@DataToReplace+''')' as Script  
FROM    @TempTable  
WHERE   IsDataFound = 1  
  
GO  

Learn C# 6

25. September 2017 Banketeshvar Narayan C#, C# 6.0 (0)

Learn C# 6 new features by the dozen of articles written by Banketeshvar Narayan.