/// <summary>
 /// This method adds absence to DbSet and then save changes to database.
 /// </summary>
 /// <param name="absence">Absence.</param>
 /// <returns>True if added, false if not.</returns>
 public bool AddAbsence(vwAbsence absence)
 {
     try
     {
         using (HotelEntities context = new HotelEntities())
         {
             tblAbsence newAbsence = new tblAbsence
             {
                 FirstDay = absence.FirstDay,
                 LastDay  = absence.LastDay,
                 Status   = "on hold",
                 Reason   = absence.Reason,
                 UserId   = absence.UserId
             };
             context.tblAbsences.Add(newAbsence);
             context.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         Debug.WriteLine("Exception" + ex.Message.ToString());
         return(false);
     }
 }
 /// <summary>
 /// This method changes status of absence to approved.
 /// </summary>
 /// <param name="request">Request to be approved.</param>
 /// <returns>True if approved, false if not.</returns>
 public bool ApproveRequest(vwAbsence request)
 {
     try
     {
         using (HotelEntities context = new HotelEntities())
         {
             tblAbsence requestToApprove = context.tblAbsences.Where(x => x.AbsenceId == request.AbsenceId).FirstOrDefault();
             requestToApprove.Status = "approved";
             context.SaveChanges();
             context.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         Debug.WriteLine("Exception" + ex.Message.ToString());
         return(false);
     }
 }
 /// <summary>
 /// This method adds employees to DbSet and then save changes to database.
 /// </summary>
 /// <param name="employeeToAdd">Employee.</param>
 /// <returns>True if added, false if not.</returns>
 public bool AddEmployee(vwEmployee employeeToAdd)
 {
     try
     {
         using (HotelEntities context = new HotelEntities())
         {
             tblUser user = new tblUser
             {
                 DateOfBirth = employeeToAdd.DateOfBirth,
                 Email       = employeeToAdd.Email,
                 Name        = employeeToAdd.Name,
                 Password    = employeeToAdd.Password,
                 Surname     = employeeToAdd.Surname,
                 Username    = employeeToAdd.Username
             };
             context.tblUsers.Add(user);
             context.SaveChanges();
             employeeToAdd.UserId = user.UserId;
             tblEmployee employee = new tblEmployee
             {
                 UserId      = user.UserId,
                 Citizenship = employeeToAdd.Citizenship,
                 Engagement  = employeeToAdd.Engagement,
                 Gender      = employeeToAdd.Gender,
                 HotelFloor  = employeeToAdd.HotelFloor,
                 Salary      = null
             };
             context.tblEmployees.Add(employee);
             context.SaveChanges();
             employeeToAdd.EmployeeId = employee.EmployeeId;
             return(true);
         }
     }
     catch (Exception ex)
     {
         Debug.WriteLine("Exception" + ex.Message.ToString());
         return(false);
     }
 }
Beispiel #4
0
 /// <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);
     }
 }
 public bool SetSalary(vwEmployee employee)
 {
     try
     {
         using (HotelEntities context = new HotelEntities())
         {
             tblEmployee employeeToEdit = context.tblEmployees.Where(x => x.EmployeeId == employee.EmployeeId).FirstOrDefault();
             employeeToEdit.Salary = employee.Salary;
             context.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         Debug.WriteLine("Exception" + ex.Message.ToString());
         return(false);
     }
 }