internal string updatePassword(DAO.Login aLogin, string newPassword)
        {
            try
            {
                aSqlConnection.Open();
                SqlCommand command = new SqlCommand("USPPasswordUpdation", aSqlConnection);
                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue("@password", newPassword);
                command.Parameters.AddWithValue("@userName", aLogin.userName);

                int effectedRows = command.ExecuteNonQuery();
                if (effectedRows > 0)
                {
                    return("Password is updated");
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
                {
                    aSqlConnection.Close();
                }
            }
            return("Error while updating password.");
        }
 public string login(DAO.Login aLogin)
 {
     try
     {
         {
             aSqlConnection.Open();
             SqlCommand cmd = new SqlCommand("uspLogin", aSqlConnection);
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@userName", aLogin.userName);
             cmd.Parameters.AddWithValue("@password", aLogin.password);
             SqlDataReader sdr = cmd.ExecuteReader();
             if (sdr.Read())
             {
                 return("Yes");
             }
         }
     }
     catch (Exception e)
     {
         throw  new Exception(e.Message);
     }
     finally
     {
         if (aSqlConnection != null && aSqlConnection.State == ConnectionState.Open)
         {
             aSqlConnection.Close();
         }
     }
     return("Sorry,try again");
 }
Esempio n. 3
0
 public Tuple <DataTable, int> checkLogin(string tendangnhap, string matkhau)
 {
     DAO.Login dao = new DAO.Login();
     return(dao.checkLogin(tendangnhap, matkhau));
 }
Esempio n. 4
0
 public int checkUsername(string tendangnhap)
 {
     DAO.Login dao = new DAO.Login();
     return(dao.checkUsername(tendangnhap));
 }