/// <summary> /// This method adds managers to DbSet and then save changes to database. /// </summary> /// <param name="managerToAdd">Employee.</param> public void AddManager(vwManager managerToAdd) { try { using (Data_RecordsEntities context = new Data_RecordsEntities()) { tblEmployee employee = new tblEmployee { Name = managerToAdd.Name, Surname = managerToAdd.Surname, DateOfBirth = managerToAdd.DateOfBirth, JMBG = managerToAdd.JMBG, BankAccountNumber = managerToAdd.BankAccountNumber, Email = managerToAdd.Email, Salary = managerToAdd.Salary, Position = managerToAdd.Position, Username = managerToAdd.Username, Password = managerToAdd.Password, Sector = managerToAdd.Sector, AccessLevel = managerToAdd.AccessLevel }; context.tblEmployees.Add(employee); context.SaveChanges(); managerToAdd.EmployeeID = employee.EmployeeID; LogAction("Manager " + managerToAdd.Name + " " + managerToAdd.Surname + " created. Date of birth: " + managerToAdd.DateOfBirth + ", Position: " + managerToAdd.Position + ", Email: " + managerToAdd.Email + ", Sector: " + managerToAdd.Sector); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
/// <summary> /// This method creates a list of employees of forwarded manager. /// </summary> /// <param name="manager">manager.</param> /// <returns>List of employees.</returns> public List <vwEmployee> GetEmployees(vwManager manager) { try { using (HotelEntities context = new HotelEntities()) { return(context.vwEmployees.Where(x => x.HotelFloor == manager.HotelFloor).ToList()); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// This method adds managers to DbSet and then save changes to database. /// </summary> /// <param name="managerToAdd">Manager.</param> /// <returns>True if added, false if not.</returns> public bool AddManager(vwManager managerToAdd) { try { using (HotelEntities context = new HotelEntities()) { tblUser user = new tblUser { DateOfBirth = managerToAdd.DateOfBirth, Email = managerToAdd.Email, Name = managerToAdd.Name, Password = managerToAdd.Password, Surname = managerToAdd.Surname, Username = managerToAdd.Username }; context.tblUsers.Add(user); context.SaveChanges(); managerToAdd.UserId = user.UserId; tblManager manager = new tblManager { UserId = managerToAdd.UserId, ExperienceWorkingInHotels = managerToAdd.ExperienceWorkingInHotels, HotelFloor = managerToAdd.HotelFloor, ProfessionalQualifications = managerToAdd.ProfessionalQualifications }; context.tblManagers.Add(manager); context.SaveChanges(); managerToAdd.ManagerId = manager.ManagerId; return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }