My Sample Application

Connection Class:


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;
///

/// Summary description for Connectionclass
///

public class Connectionclass
{
SqlConnection cn;
public Connectionclass()
{
cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["testConnectionString"].ToString());
}
public bool CheckUser(string UserID)
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["testConnectionString"].ToString());
cn.Open();
}
SqlCommand cmdCheck = new SqlCommand();
cmdCheck.Connection = cn;
cmdCheck.CommandText = "usp_CheckUserID";
cmdCheck.CommandType = CommandType.StoredProcedure;
SqlParameter pUserid = cmdCheck.Parameters.Add("@UserID", SqlDbType.VarChar);
pUserid.Value = UserID;
if (Convert.ToInt32(cmdCheck.ExecuteScalar()) > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public bool InsertUser(string UserID, string Password, string Name, string Gender, string City, string Hobbies, string Image, string Yourself, string DateofBirth, string EMailID)
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdinsert = new SqlCommand();
cmdinsert.Connection = cn;
cmdinsert.CommandText = "usp_insertRegistration";
cmdinsert.CommandType = CommandType.StoredProcedure;
SqlParameter pUserid = cmdinsert.Parameters.Add("@UserID", SqlDbType.VarChar);
pUserid.Value = UserID;
SqlParameter pPassword = cmdinsert.Parameters.Add("@Password", SqlDbType.VarChar);
pPassword.Value = Password;
SqlParameter pName = cmdinsert.Parameters.Add("@Name", SqlDbType.VarChar);
pName.Value = Name;
SqlParameter pImage = cmdinsert.Parameters.Add("@Image", SqlDbType.VarChar);
pImage.Value = Image;
if (cmdinsert.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}

}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------


public DataSet GetUserList()
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdlist = new SqlCommand();
cmdlist.Connection = cn;
cmdlist.CommandText = "Sp_Userlist";
cmdlist.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dalist = new SqlDataAdapter();
dalist.SelectCommand = cmdlist;
DataSet ds = new DataSet();
dalist.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------

public DataSet GetUserDetails(string RegesteredID)
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdDetails = new SqlCommand();
cmdDetails.Connection = cn;
cmdDetails.CommandText = "sp_Tbl_getUserupdate";
cmdDetails.CommandType = CommandType.StoredProcedure;
SqlParameter puserid = cmdDetails.Parameters.Add("@RegisteredID", SqlDbType.UniqueIdentifier);
puserid.Value = new Guid(RegesteredID);
SqlDataAdapter daList = new SqlDataAdapter();
daList.SelectCommand = cmdDetails;
DataSet ds = new DataSet();
daList.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------

public bool UpdateUser(string RegesteredID, string UserID, string Name, string Hobbies, string City, string DateofBirth, string Gender, string Yourself, string EMailID, string Image)
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.Connection = cn;
cmdInsert.CommandText = "USP_UPDATEUSER";
cmdInsert.CommandType = CommandType.StoredProcedure;
SqlParameter pRegistered = cmdInsert.Parameters.Add("@RegisteredID", SqlDbType.UniqueIdentifier);
pRegistered.Value = new Guid(RegesteredID);
SqlParameter pUserid = cmdInsert.Parameters.Add("@UserID", SqlDbType.VarChar);
pUserid.Value = UserID;
SqlParameter pName = cmdInsert.Parameters.Add("@Name", SqlDbType.VarChar);
pName.Value = Name;

if (cmdInsert.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}

}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------

public void DeleteUser()
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdDelete = new SqlCommand();
cmdDelete.Connection = cn;
cmdDelete.CommandText = "USP_DELETEUSER";
cmdDelete.CommandType = CommandType.StoredProcedure;
SqlParameter pRegID = cmdDelete.Parameters.Add("@RegisteredID", SqlDbType.UniqueIdentifier);
}
catch (Exception ex)
{
throw ex;
}
}




}

-----------------------------------------------------------------------------------------------------------------------------------

BLL:
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;
///

/// Summary description for Registeration_logic
///

public class Registeration_logic
{
Connectionclass objcnn = new Connectionclass();
private string MID;
private string RegisteredID;
private string UserID;
private string Password;
private string Name;
private string Gender;
private string City;
private string Hobbies;
private string Yourself;
private string EMailID;
private string Image;
private string DateofBirth;

public Registeration_logic()
{
//
// TODO: Add constructor logic here
//
}
#region Properties
public string _RegisteredID
{
get
{
return RegisteredID;
}
set
{
RegisteredID = value;
}
}
public string _MID
{
get
{
return MID;
}
set
{
MID = value;
}
}
public string _UserID
{
get
{
return UserID;
}
set
{
UserID = value;
}
}
public string _Name
{
get
{
return Name;
}
set
{
Name = value;
}
}
public string _Password
{
get
{
return Password;
}
set
{
Password = value;
}
}
public string _Gender
{
get
{
return Gender;
}
set
{
Gender = value;
}
}
public string _City
{
get
{
return City;
}
set
{
City = value;
}
}
public string _Hobbies
{
get
{
return Hobbies;
}
set
{
Hobbies = value;
}
}
public string _Yourself
{
get
{
return Yourself;
}
set
{
Yourself = value;
}
}
public string _Dateofbirth
{
get
{
return DateofBirth;
}
set
{
DateofBirth = value;
}
}
public string _EmailID
{
get
{
return EMailID;
}
set
{
EMailID = value;
}
}
public string _Image
{
get
{
return Image;
}
set
{
Image = value;
}
}
#endregion

-----------------------------------------------------------------------------------------------------------------------------------
public bool CheckUserID()
{
try
{
return objcnn.CheckUser(UserID);
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public bool InsertUserDetails()
{
try
{
return objcnn.InsertUser(UserID, Password, Name, Gender, City, Hobbies, Image, Yourself, DateofBirth, EMailID);
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public DataSet GetUserDetails()
{
try
{
return objcnn.GetUserList();
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public DataSet GetUserInsertDetails()
{
try
{
return objcnn.GetUserDetails(_RegisteredID);
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public bool updateUserDetails()
{
try
{
return objcnn.UpdateUser(RegisteredID,UserID,Name,Hobbies,City,DateofBirth,Gender,Yourself,EMailID,Image);
}
catch (Exception ex)
{
throw ex;
}
}

-----------------------------------------------------------------------------------------------------------------------------------
public void DeleteUser()
{
try
{
objcnn.DeleteUser();
}
catch (Exception ex)
{
throw ex;
}
}
-----------------------------------------------------------------------------------------------------------------------------------


}