Beispiel #1
0
 internal bool TryAddNewManager(tblManager manager)
 {
     try
     {
         using (var conn = new HotelManagementEntities())
         {
             conn.tblManagers.Add(manager);
             conn.SaveChanges();
             return(true);
         }
     }
     catch (Exception)
     {
         return(false);
     }
 }
Beispiel #2
0
 internal bool TryAddNewEmployee(tblEmployee employee)
 {
     try
     {
         using (var conn = new HotelManagementEntities())
         {
             conn.tblEmployees.Add(employee);
             conn.SaveChanges();
             return(true);
         }
     }
     catch (Exception)
     {
         return(false);
     }
 }
Beispiel #3
0
 internal bool TryAddNewUserData(tblUserData userData)
 {
     try
     {
         using (var conn = new HotelManagementEntities())
         {
             conn.tblUserDatas.Add(userData);
             conn.SaveChanges();
             return(true);
         }
     }
     catch (Exception)
     {
         return(false);
     }
 }
Beispiel #4
0
 internal bool TryUpdateEmloyeeSalary(int employeeId, string salary)
 {
     try
     {
         using (var conn = new HotelManagementEntities())
         {
             var user = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeId);
             if (user != null)
             {
                 user.Salary = salary;
                 conn.SaveChanges();
                 return(true);
             }
             return(false);
         }
     }
     catch (Exception)
     {
         return(false);
     }
 }
Beispiel #5
0
        internal bool TryRemoveUserData(int userId)
        {
            try
            {
                using (var conn = new HotelManagementEntities())
                {
                    var userToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == userId);

                    if (userToRemove != null)
                    {
                        conn.tblUserDatas.Remove(userToRemove);
                        conn.SaveChanges();
                        return(true);
                    }
                    return(false);
                }
            }
            catch (Exception)
            {
                return(false);
            }
        }