//Update Password
public bool UpdatePassword(Models.LoginModel login)
{
List <SqlParameter> changepwd = new List <SqlParameter>();
changepwd.Add(new SqlParameter("@Password", login.Password));
changepwd.Add(new SqlParameter("@UserId", login.UserId));
int rows = DAL.SQLHelp.ExecuteNonQuery("SP_ChangePwd ", changepwd);
return(true);
}
public DataTable checkUser(Models.LoginModel loginModel)
{
List <SqlParameter> sqParam = new List <SqlParameter>();
sqParam.Add(new SqlParameter("@UserName", loginModel.Username));
sqParam.Add(new SqlParameter("@Password", loginModel.Password));
DataTable dt = DAL.SQLHelp.ExecuteReader("Usp_AuthenticateUser", sqParam);
return(dt);
}
//Check Pwd Exist
public DataSet CheckPassword(Models.LoginModel login)
{
DataSet ds = new DataSet();
SqlParameter[] sp =
{
new SqlParameter("@UserId", SqlDbType.Int)
{
Value = login.UserId
},
};
ds = DAL.SQLHelp.DSExecuteQuery1("SP_Chkpwdexist", CommandType.StoredProcedure, sp);
return(ds);
}