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);
 }
Example #4
0
        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));
 }