A Complete Code for Class File Can be Use in ASP.Net Project Directaly

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Net.Mail;
using System.Security.Cryptography;
using System.IO;
/// <summary>
/// Summary description for Vapsoft
/// </summary>

namespace DBhandler
{
    public class Vapsoft
    {
        public SqlConnection con = new SqlConnection();
        public SqlDataAdapter da = new SqlDataAdapter();
        public SqlCommand cmd = new SqlCommand();
        public SqlDataReader my;
        public DataSet ds = new DataSet();

        public Vapsoft()
        {
            con.ConnectionString = ConfigurationManager.ConnectionStrings["Con"].ConnectionString;
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
        }

        public void Update(String Procedurename)
        {
            cmd.CommandText = Procedurename;
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.ExecuteNonQuery();
        }
        public DataSet GetData(String Procedurename)
        {
            cmd.CommandText = Procedurename;
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            da.SelectCommand = cmd;
            da.Fill(ds);
            return ds;
        }
        //======================Method Defination===================================
        public void Insert_Data(String Query)
        {
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
        }
        public void Update_Data(String Query)
        {
            cmd.CommandText = Query;
            //if (cmd.Connection != con)
            // {
            cmd.Connection = con;
            // }          
            cmd.ExecuteNonQuery();
        }
        public void Delete_Data(String Query)
        {
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
        }
        public DataSet Get_Data(String Query)
        {
            cmd.CommandText = Query;
            cmd.Connection = con;
            da.SelectCommand = cmd;
            da.Fill(ds);
            return ds;
        }
        public Int64 Sno(String Query)
        {
            Int64 id = 0;
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                id = my.GetInt64(0);
            }
            id = id + id;
            my.Close();

            return id;
        }
        public Int64 Count(String Query)
        {
            Int64 id = 0;
            cmd.CommandText = Query;
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                id = id + 1;
            }
            my.Close();
            return id;
        }
        public bool Check_Username(string Value, String Query)
        {
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            Boolean Check = false;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                if (Value.Trim() == Convert.ToString(my.GetSqlString(0)).Trim())
                {
                    Check = true;
                    break;
                }
                else
                    Check = false;
            }
            my.Close();
            return Check;
        }
        public bool Login_Check(string Username, String Password, String Query)
        {
            cmd.CommandText = Query;
            cmd.Connection = con;
            Boolean Check = false;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                if (Username.Trim() == Convert.ToString(my.GetSqlString(1)) && Password.Trim() == Convert.ToString(my.GetSqlString(2)))
                {
                    System.Web.HttpContext.Current.Session["Username"] = Convert.ToString(my.GetSqlString(1));
                    System.Web.HttpContext.Current.Session["ProfileId"] = Convert.ToString(my.GetSqlString(3));
                    // Sno = Convert.ToString(my.GetInt64(0));

                    Check = true;
                    break;
                }
                else
                    Check = false;
            }
            my.Close();
            return Check;
        }
        public String GetField(String Query)
        {
            String Value = "";
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                Value = my.GetString(0);
             
            }
            my.Close();

            return Value.Trim();
        }
       
        public byte[] GetPassword(String Query)
        {
            cmd.CommandText =Query ;
            da.SelectCommand = cmd;
            cmd.Connection = con;
            SqlCommandBuilder MyCB = new SqlCommandBuilder(da);
            DataSet ds = new DataSet("test");

            byte[] MyData = new byte[0];

            da.Fill(ds, "test");
            DataRow myRow;
            myRow = ds.Tables["test"].Rows[0];

            MyData = (byte[])myRow["Password"];
            return MyData ;
        }

        public Decimal GetDecimal(String Query)
        {
            Decimal Value = 0;
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {

                Value = my.GetDecimal(0);
            }
            my.Close();

            return Value;
        }
        public Int32 GetInt(String Query)
        {
            Int32 Value = 0;
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                Value = my.GetInt32(0);            
               
            }
            my.Close();

            return Value;
        }
        public Int64 GetSno(String Query)
        {
            Int64 Value = 0;
            cmd.CommandText = Query.Trim();
            cmd.Connection = con;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                Value = my.GetInt64(0);
            }
            my.Close();

            return Value;
        }
        public void SendMail(String To, String From, String Subject, String Body)
        {
            SmtpClient Smtp = new SmtpClient("WebMail.marriage.nainipublicschool.com");
            MailMessage message = new MailMessage(From, To);

            message.IsBodyHtml = true;
            message.Subject = Subject;
            message.Body = Body;
            Smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
            Smtp.Host = "127.0.0.1";
            Smtp.Port = 25;
            Smtp.UseDefaultCredentials = true;
            Smtp.Send(message);
        }
        public String GetHtmlFormate(String Msg)
        {
            int i = 0;
            Char b = 'R';
            int a = (int)b;
            String Space = "", NewLine = "";
            String GetHtml = "";
            for (i = 0; i <= Msg.Length - 1; i++)
            {


                Space = Msg.Substring(i, 1);
                GetHtml = GetHtml + Msg.Substring(i, 1);
                if (Space == " ")
                {
                    GetHtml = GetHtml + "&nbsp;";
                }
                NewLine = Msg.Substring(i, 1);
                if (NewLine == "\n")
                {
                    GetHtml = GetHtml + "<BR>";
                }
            }
            return GetHtml;

        }
        public bool Listselect(String BaseString, String lblSource)
        {
            bool check = false;
            String[] SplitChar = lblSource.Split(',');
            foreach (string s in SplitChar)
            {
                if (s == BaseString.Trim())
                {
                    check = true;
                    break;
                }
                else
                    check = false;
            }
            return check;
        }
        public int Index(string s, DropDownList d)
        {
            int i = 0;


            foreach (ListItem l in d.Items)
            {

                if (l.Text == s)
                    break;
                i++;
            }
            return i;
        }
        public int IndexValue(string s, DropDownList d)
        {
            int i = 0;


            foreach (ListItem l in d.Items)
            {

                if (l.Value == s)
                    break;
                i++;
            }
            return i;
        }
        public DataSet GetList(String Query)
        {
            ds.Clear();
            cmd.CommandText = Query;
            cmd.Connection = con;
            da.SelectCommand = cmd;
            da.Fill(ds);
            return ds;
        }
        //===============================================================================
      public bool Check_ID(String ProfileID)
        {
            cmd.CommandText = "SELECT ProfileId from SignUP";
            cmd.Connection = con;
            Boolean Check = false;
            my = cmd.ExecuteReader();
            while (my.Read())
            {
                if (ProfileID.Trim() == Convert.ToString(my.GetSqlString(0)).Trim())
                {

                    Check = true;
                    break;
                }
                else
                    Check = false;
            }
            my.Close();
            return Check;

        }
        public  byte[] Encrypt(string PlainText, SymmetricAlgorithm key)
        {
            // Create a memory stream.
            MemoryStream ms = new MemoryStream();

            // Create a CryptoStream using the memory stream and the
            // CSP DES key. 
            CryptoStream encStream = new CryptoStream(ms, key.CreateEncryptor(), CryptoStreamMode.Write);

            // Create a StreamWriter to write a string
            // to the stream.
            StreamWriter sw = new StreamWriter(encStream);

            // Write the plaintext to the stream.
            sw.WriteLine(PlainText);

            // Close the StreamWriter and CryptoStream.
            sw.Close();
            encStream.Close();

            // Get an array of bytes that represents
            // the memory stream.
            byte[] buffer = ms.ToArray();
            //String txt = (String)buffer;
            // Close the memory stream.
            ms.Close();

            // Return the encrypted byte array.
            return buffer;
        }
        // Decrypt the byte array.
        public string Decrypt(byte[] CypherText, SymmetricAlgorithm key)
        {
            // Create a memory stream to the passed buffer.
            MemoryStream ms = new MemoryStream(CypherText);

            // Create a CryptoStream using the memory stream and the
            // CSP DES key.
            CryptoStream encStream = new CryptoStream(ms, key.CreateDecryptor(), CryptoStreamMode.Read);

            // Create a StreamReader for reading the stream.
            StreamReader sr = new StreamReader(encStream);

            // Read the stream as a string.
            string val = sr.ReadLine();

            // Close the streams.
            sr.Close();
            encStream.Close();
            ms.Close();

            return val;
        }

        //================================Second method to Encrypt/Decrypt=========================
        public static byte[] Encrypt(byte[] data, RSAParameters parameters)
        {
            RSACryptoServiceProvider provider = new RSACryptoServiceProvider();
            provider.ImportParameters(parameters);
            return provider.Encrypt(data, false);
        }
        public static byte[] Decrypt(byte[] data, RSAParameters parameters)
        {
            RSACryptoServiceProvider provider = new RSACryptoServiceProvider();
            provider.ImportParameters(parameters);
            return provider.Decrypt(data, false);
        }
        public string GetEncrypted(string StringToEncrypt)
        {
            byte[] rawstring = System.Text.Encoding.Unicode.GetBytes(StringToEncrypt);
            RSACryptoServiceProvider rsa = new RSACryptoServiceProvider();
            rsa.FromXmlString("<RSAKeyValue><Modulus>utGSipw48ogwIj3ppSYk2N1YQI3k6It1/rGASJGT743JrIp7DZTso+TG5eBIw228MW/E4kkcTZ3YUP1BcDvJB/NQN5YeL0x0cUKjK4hx7LvipKxEnsnGf5qBTKH6Ft4oqSr40NcVu8cWLH8laDvlPXuL4TjOpr1AwGjWPvmhnCU=</Modulus><Exponent>AQAB</Exponent><P>7KInvhD/9tmSjyx3Po5Z4lTx54pIqzzR4da/AJmksjFNOE4jkpKMuNIUKwbhNF14kiLKhByRlZITnBBoXH9dvw==</P><Q>yhu3/+MBBMQvGAI8TLlBiV7U5RPOU8skk7mPiiTXLqfeohq8zRiZ4Q+BsLBUBQ5GxEQiqAFPas7w/1xTmP2HGw==</Q><DP>cXc7uU6rffFL7m0y7IMTpIx4xj6vo7RxK2pugdoqd+teDK6jLggphAHv+8W7vQFI7EHUe867HE5EKuRPNnM4Pw==</DP><DQ>kQaQ4wJOcdAhBvZbtKZeu6cb14F91az4gzRtJrDG5Ai7fdD316gmi1PoORReRf53k1BdGfdOuJLkZiknJ6oNLw==</DQ><InverseQ>N9YVHvP4aaqojXtSt6LKGzWSwSIMYVLU1y8w4S2WDHjtc6vnTZz6jVnshCCRoo+O0+5wBt8rGLTxl9Sw38Vrfg==</InverseQ><D>ZkPAhxXbapA4YRYpJxlJRFluLPA/pThqYACEa7UdGR4xjrzDfXzPSSw74Kw0yJ3yTdGUIhbJYoeMWVE5GBnyAfL4XRPcizv/OWPMjr5MAvT0osoB3AWU5XgOX9kR7NbLQ5rtIEIOWxjC188gzNWG8hGdN+cWgTfR9XkNUAXdn2U=</D></RSAKeyValue>");
            byte[] encrypted = Encrypt(rawstring, rsa.ExportParameters(true));
            string EncryptedString = Convert.ToBase64String(encrypted); //For passing to another page

            return EncryptedString;
        }
        public string GetDecrypted(string StringToDecrypt)
        {
            RSACryptoServiceProvider rsa = new RSACryptoServiceProvider();
            rsa.FromXmlString("<RSAKeyValue><Modulus>utGSipw48ogwIj3ppSYk2N1YQI3k6It1/rGASJGT743JrIp7DZTso+TG5eBIw228MW/E4kkcTZ3YUP1BcDvJB/NQN5YeL0x0cUKjK4hx7LvipKxEnsnGf5qBTKH6Ft4oqSr40NcVu8cWLH8laDvlPXuL4TjOpr1AwGjWPvmhnCU=</Modulus><Exponent>AQAB</Exponent><P>7KInvhD/9tmSjyx3Po5Z4lTx54pIqzzR4da/AJmksjFNOE4jkpKMuNIUKwbhNF14kiLKhByRlZITnBBoXH9dvw==</P><Q>yhu3/+MBBMQvGAI8TLlBiV7U5RPOU8skk7mPiiTXLqfeohq8zRiZ4Q+BsLBUBQ5GxEQiqAFPas7w/1xTmP2HGw==</Q><DP>cXc7uU6rffFL7m0y7IMTpIx4xj6vo7RxK2pugdoqd+teDK6jLggphAHv+8W7vQFI7EHUe867HE5EKuRPNnM4Pw==</DP><DQ>kQaQ4wJOcdAhBvZbtKZeu6cb14F91az4gzRtJrDG5Ai7fdD316gmi1PoORReRf53k1BdGfdOuJLkZiknJ6oNLw==</DQ><InverseQ>N9YVHvP4aaqojXtSt6LKGzWSwSIMYVLU1y8w4S2WDHjtc6vnTZz6jVnshCCRoo+O0+5wBt8rGLTxl9Sw38Vrfg==</InverseQ><D>ZkPAhxXbapA4YRYpJxlJRFluLPA/pThqYACEa7UdGR4xjrzDfXzPSSw74Kw0yJ3yTdGUIhbJYoeMWVE5GBnyAfL4XRPcizv/OWPMjr5MAvT0osoB3AWU5XgOX9kR7NbLQ5rtIEIOWxjC188gzNWG8hGdN+cWgTfR9XkNUAXdn2U=</D></RSAKeyValue>");
            byte[] todecrypt = Convert.FromBase64String(StringToDecrypt);
            byte[] decrypted = Decrypt(todecrypt, rsa.ExportParameters(true));
            string decryptedstring = System.Text.Encoding.Unicode.GetString(decrypted);

            return decryptedstring;
        }
        //==================================Sedcond Class================================
    }
        public class Items
        {
            Vapsoft v = new Vapsoft();
            public Items()
            {
                Vapsoft v = new Vapsoft();
            }
            public DataSet List_BodyType()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Body_type from Body_type";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Community()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Community from Community";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Complexion()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Complexion from Complexion";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Country()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Sno,Country,Code,nick from countrylist";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;

            }
            public DataSet List_City(String Country)
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT City from City Where Nick='" + Country.ToString() + "'";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_FamilyValues()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Family_values from Family_values";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Height()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Height,Hvalue    decimal from Height";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Mtongue()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Mtongue from Mtongue";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Profession()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Profession from Profession";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Education()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Education from Education";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Religion()
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Religion from Religion";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
            public DataSet List_Caste(String Religion)
            {
                v.ds.Clear();
                v.cmd.CommandText = "SELECT Caste,Religion from Caste Where Religion='" + Religion.Trim() + "'";
                v.cmd.Connection = v.con;
                v.da.SelectCommand = v.cmd;
                v.da.Fill(v.ds);
                return v.ds;
            }
        }
   
}