public DataTable CheckPassword(int Ind, int UserId, string NewPwd)
{
PlChangePwd pl = new PlChangePwd();
pl.Ind = Ind;
pl.UserId = UserId;
pl.NewPwd = NewPwd;
DataTable dt = new DataTable();
dt = objdllogin.CheckPassword(pl);
return(dt);
}
public DataTable SelectOldPwd(int Ind, int UserId, string OldPwd)
{
PlChangePwd pl = new PlChangePwd();
pl.Ind = Ind;
pl.UserId = UserId;
pl.OldPwd = OldPwd;
DataTable dt = new DataTable();
dt = objdllogin.SelectOldPwd(pl);
return(dt);
}
public DataTable InsertPwd(PlChangePwd pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@NewPwd", pl.NewPwd);
dt = new DataTable();
da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public DataTable SelectOldPwd(PlChangePwd pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.OldPwd);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt); //int i = Convert.ToInt32(cmd.ExecuteScalar());
return(dt);
}
public int SelectOldPwd(PlChangePwd pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.OldPwd);
con.Open();
//int i = Convert.ToInt32(cmd.ExecuteScalar());
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
public DataTable InsertPwd(PlChangePwd pl)
{
return(dl.InsertPwd(pl));
}
public DataTable CheckPassword(PlChangePwd pl)
{
return(dl.CheckPassword(pl));
}
public int SelectOldPwd(PlChangePwd pl)
{
return(dl.SelectOldPwd(pl));
}
public int ChangePwd(PlChangePwd pl)
{
return(dl.ChangePwd(pl));
}