public int update_client(Client profile)
{
dbAccess db = new dbAccess();
db.AddParameter("@First_Name", profile.First_Name);
db.AddParameter("@Last_Name", profile.Last_Name);
db.AddParameter("@User_Name", profile.User_Name);
db.AddParameter("@Email", profile.Email);
db.AddParameter("@Gender", profile.Privilage);
db.AddParameter("@Client_Name", profile.Client_Name);
db.AddParameter("@Description", profile.Description);
db.AddParameter("@Address1", profile.Address1);
db.AddParameter("@Address2", profile.Address2);
db.AddParameter("@City", profile.City);
db.AddParameter("@State", profile.State);
db.AddParameter("@Country", profile.Country);
db.AddParameter("@Region", profile.Region);
db.AddParameter("@Pincode", profile.Pincode);
db.AddParameter("@Phone", profile.Phone);
db.AddParameter("@Mobile", profile.Mobile);
db.AddParameter("@Info_Email", profile.Info_Email);
db.AddParameter("@Website", profile.Website);
db.AddParameter("@Login_Id", profile.Login_Id);
return db.ExecuteNonQuery("SP_TBL_CLIENT_PROFILE_UPDATE_V2");
}
public int Insert_Client_Login_Details(Client profile)
{
dbAccess db = new dbAccess();
db.AddParameter("@FirstName", profile.First_Name);
db.AddParameter("@LastName", profile.Last_Name);
db.AddParameter("@UserName", profile.User_Name);
db.AddParameter("@Password", profile.Password);
db.AddParameter("@Email", profile.Email);
db.AddParameter("@Usergroupid", profile.Privilage);
return db.ExecuteNonQuery("SP_CreateNewUser");
}
