public int Change_User_Password(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", client.User_Name);
db.AddParameter("@newPassword", client.New_Password);
return db.ExecuteNonQuery("SP_updatepassword");
}
public int Change_Password(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", client.User_Name);
db.AddParameter("@Password", client.New_Password);
return db.ExecuteNonQuery("SP_TBL_CLIENT_LOGIN_UPDATE_PASSWORD");
}
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_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();
}
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 DataSet Load_User_Password_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", client.User_Name);
db.AddParameter("@Password", client.Current_Password);
return db.ExecuteDataSet("SP_checklogin");
}
