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);
     }
 }
Example #2
0
 /// <summary>
 /// This method deletes employee from DbSet and then saves changes to database.
 /// </summary>
 /// <param name="employeeID">Employee id.</param>
 /// <returns>True if deleted, false if not.</returns>
 public bool DeleteEmployee(int employeeID)
 {
     try
     {
         using (Employee_DataEntities context = new Employee_DataEntities())
         {
             //creating a list of employees for this manager
             var employeeOfThisManager = context.tblEmployees.Where(x => x.Manager == employeeID).ToList();
             //if the list is not empty, setting manager id to null for every employee in that list
             if (employeeOfThisManager.Count() > 0)
             {
                 foreach (var employee in employeeOfThisManager)
                 {
                     employee.Manager = null;
                     logger.LogAction("Employee with JMBG " + employee.JMBG + " updated so he has no manager.");
                 }
             }
             //finding employee with forwarded id
             tblEmployee employeeToDelete = context.tblEmployees.Where(x => x.EmployeeId == employeeID).FirstOrDefault();
             //if that employee was the only in the sector, deleting sector
             var peopleInSector = context.tblEmployees.Where(x => x.Sector == employeeToDelete.Sector).ToList();
             //removing employee from DbSet and saving changes to database
             context.tblEmployees.Remove(employeeToDelete);
             context.SaveChanges();
             logger.LogAction("Employee with JMBG " + employeeToDelete.JMBG + " deleted.");
             if (peopleInSector.Count() == 1)
             {
                 var sector = context.tblSectors.Where(x => x.SectorId == employeeToDelete.Sector).FirstOrDefault();
                 context.tblSectors.Remove(sector);
                 context.SaveChanges();
                 logger.LogAction("Sector " + sector.SectorName + " with ID: " + sector.SectorId + " deleted.");
             }
             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);
     }
 }