//public int insert_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("@Password", profile.Password);
// 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("@SeqQues", profile.SeqQues);
// db.AddParameter("@SeqAns", profile.SeqAns);
// db.AddParameter("@NewsLetter", profile.NewsLetter);
// db.AddParameter("@Offers", profile.Offers);
// return db.ExecuteNonQuery("SP_TBL_CLIENT_PROFILE_INSERT_V2");
//}
public int Load_User_Email_Count_By_Text(string Email)
{
dbAccess db = new dbAccess();
db.AddParameter("@Email", Email);
return Convert.ToInt32(db.ExecuteScalar("SP_TBL_LOGIN_V2_LOAD_EMAIL_COUNT_BY_TEXT"));
}
public int Load_User_Username_Count_By_Text(string Username)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", Username);
return Convert.ToInt32(db.ExecuteScalar("sp_checkuser"));
}
public int Load_Client_Username_Count_By_Text(string Username)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", Username);
return Convert.ToInt32(db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_USERNAME_COUNT_BY_TEXT"));
}
public string Load_User_Current_Username_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Usernmae", client.User_Name);
return db.ExecuteScalar("SP_UsernamebyId").ToString();
}
public string Load_Client_Current_Username_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Usernmae", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_CURRENT_USERNAME_BY_ID").ToString();
}
public string Load_Client_Current_Email_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Client_Id", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_CURRENT_EMAIL_BY_ID").ToString();
}
public string Load_Password_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_PASSWORD_BY_ID").ToString();
}