internal vwEmployee AddEmployee(vwEmployee employee) { try { using (HotelServiceEntities context = new HotelServiceEntities()) { tblUser newUser = new tblUser { FullName = employee.FullName, DateOfBirth = employee.DateOfBirth, Email = employee.Email, UserName = employee.UserName, Password = employee.Password }; context.tblUsers.Add(newUser); context.SaveChanges(); employee.UserID = newUser.UserID; tblEmployee newEmployee = new tblEmployee { FloorNumber = employee.FloorNumber, Gender = employee.Gender, Citizenship = employee.Citizenship, WorkType = employee.WorkType, UserID = employee.UserID }; context.tblEmployees.Add(newEmployee); context.SaveChanges(); employee.EmployeeID = newEmployee.EmployeeID; return(employee); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwManager AddManager(vwManager manager) { try { using (HotelServiceEntities context = new HotelServiceEntities()) { tblUser newUser = new tblUser { FullName = manager.FullName, DateOfBirth = manager.DateOfBirth, Email = manager.Email, UserName = manager.UserName, Password = manager.Password }; context.tblUsers.Add(newUser); context.SaveChanges(); manager.UserID = newUser.UserID; tblManager newManager = new tblManager { FloorNumber = manager.FloorNumber, WorkExperience = manager.WorkExperience, LevelOfEducation = manager.LevelOfEducation, UserID = manager.UserID }; context.tblManagers.Add(newManager); context.SaveChanges(); manager.ManagerID = newManager.ManagerID; return(manager); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwEmployee EditEmployeeSalary(vwEmployee employee) { try { using (HotelServiceEntities context = new HotelServiceEntities()) { tblEmployee employeeSalaryToEdit = (from e in context.tblEmployees where e.EmployeeID == employee.EmployeeID select e).First(); employeeSalaryToEdit.Salary = employee.Salary; context.SaveChanges(); return(employee); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }