/// <summary> /// This method edits employee in DbSet and then saves changes to database. /// </summary> /// <param name="employee"></param> /// <returns>True if edited, false if not.</returns> public bool EditEmployee(vwEmployee employee) { try { using (Employee_DataEntities context = new Employee_DataEntities()) { tblEmployee employeeToEdit = context.tblEmployees.Where(x => x.EmployeeId == employee.EmployeeId).FirstOrDefault(); employeeToEdit.NameAndSurname = employee.NameAndSurname; employeeToEdit.DateOfBirth = CalculateDateOfBirth.Calculate(employee.JMBG); employeeToEdit.JMBG = employee.JMBG; employeeToEdit.NumberOfIdentityCard = employee.NumberOfIdentityCard; employeeToEdit.Gender = employee.Gender; employeeToEdit.PhoneNumber = employee.PhoneNumber; employeeToEdit.Sector = employee.Sector; employeeToEdit.LocationId = employee.LocationId; employeeToEdit.Manager = employee.Manager; context.SaveChanges(); logger.LogAction("Employee with JMBG " + employeeToEdit.JMBG + " updated."); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
/// <summary> /// This method adds employee to DbSet and then save changes to database. /// </summary> /// <param name="employeeToAdd">Employee to be added.</param> /// <returns>True if added, false if not.</returns> public bool AddEmployee(vwEmployee employeeToAdd) { try { using (Employee_DataEntities context = new Employee_DataEntities()) { tblEmployee employee = new tblEmployee { NameAndSurname = employeeToAdd.NameAndSurname, DateOfBirth = CalculateDateOfBirth.Calculate(employeeToAdd.JMBG), NumberOfIdentityCard = employeeToAdd.NumberOfIdentityCard, JMBG = employeeToAdd.JMBG, Gender = employeeToAdd.Gender, PhoneNumber = employeeToAdd.PhoneNumber, Sector = employeeToAdd.Sector, LocationId = employeeToAdd.LocationId, Manager = employeeToAdd.Manager }; context.tblEmployees.Add(employee); context.SaveChanges(); employeeToAdd.EmployeeId = employee.EmployeeId; logger.LogAction("Employee " + employeeToAdd.NameAndSurname + " created. ID: " + employeeToAdd.EmployeeId + " JMBG: " + employeeToAdd.JMBG); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }