public void SectorsToDB() { List <Sector> existingSectors = GetAllSectors(); List <Sector> newSectors = new List <Sector>(); StreamReader sr = new StreamReader(@".../.../Sectors.txt"); if (!File.Exists(@".../.../Sectors.txt")) { File.Create(@".../.../Sectors.txt").Close(); } string line; while ((line = sr.ReadLine()) != null) { Sector s = new Sector(); s.SectorName = line; newSectors.Add(s); } var sectorsToAdd = newSectors.Where(s => existingSectors.All(s2 => s2.SectorName != s.SectorName)); using (Task_1Entities context = new Task_1Entities()) { foreach (var sec in sectorsToAdd) { context.Sectors.Add(sec); string input = (DateTime.Now + " / Added new location with address " + sec.SectorName + " directly to database"); archive.WriteToFile(input); context.SaveChanges(); } } }
/// <summary> /// Adds and employee to the database /// </summary> /// <param name="employee">Employee to be added to the database</param> /// <returns>An employee that was added to the database</returns> public Employee AddEmployee(Employee employee) { try { using (Task_1Entities context = new Task_1Entities()) { Employee newEmployee = new Employee(); newEmployee.FirstName = employee.FirstName; newEmployee.LastName = employee.LastName; newEmployee.DateOfBirth = employee.DateOfBirth; newEmployee.IDNumber = employee.IDNumber; newEmployee.JMBG = employee.JMBG; newEmployee.Gender = employee.Gender; newEmployee.PhoneNumber = employee.PhoneNumber; newEmployee.SectorID = employee.SectorID; newEmployee.Location = employee.Location; newEmployee.Manager = employee.Manager; context.Employees.Add(newEmployee); context.SaveChanges(); string input = (DateTime.Now + " / Added new Employee named " + newEmployee.FirstName + " " + newEmployee.LastName + " to sector " + newEmployee.Sector.SectorName); archive.WriteToFile(input); return(newEmployee); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(null); } }
public void LocationsToDB() { List <Location> existingLocations = GetAllLocations(); List <Location> newLocations = new List <Location>(); StreamReader sr = new StreamReader(@".../.../Locations.txt"); if (!File.Exists(@".../.../Locations.txt")) { File.Create(@".../.../Locations.txt").Close(); } string line; while ((line = sr.ReadLine()) != null) { Location l = new Location(); l.Address = line; newLocations.Add(l); } var locationsToAdd = newLocations.Where(l => existingLocations.All(l2 => l2.Address != l.Address)); locationsToAdd = locationsToAdd.OrderBy(l => l.Address).ToList(); using (Task_1Entities context = new Task_1Entities()) { foreach (var loc in locationsToAdd) { context.Locations.Add(loc); string input = (DateTime.Now + " / Added new location with address " + loc.Address + " directly to database"); archive.WriteToFile(input); context.SaveChanges(); } } }
/// <summary> /// This method updates an employee from the database /// </summary> /// <param name="employee">Employee that is to be updated</param> /// <returns>A updated employee</returns> public Employee UpdateEmployee(Employee employee) { try { using (Task_1Entities context = new Task_1Entities()) { Employee EmployeeToUpdate = (from e in context.Employees where e.EmployeeID == employee.EmployeeID select e).First(); EmployeeToUpdate.FirstName = employee.FirstName; EmployeeToUpdate.LastName = employee.LastName; EmployeeToUpdate.DateOfBirth = employee.DateOfBirth; EmployeeToUpdate.IDNumber = employee.IDNumber; EmployeeToUpdate.JMBG = employee.JMBG; EmployeeToUpdate.Gender = employee.Gender; EmployeeToUpdate.PhoneNumber = employee.PhoneNumber; EmployeeToUpdate.SectorID = employee.SectorID; EmployeeToUpdate.Location = employee.Location; EmployeeToUpdate.Manager = employee.Manager; context.SaveChanges(); string input = (DateTime.Now + " / Updated Employee named " + EmployeeToUpdate.FirstName + " " + EmployeeToUpdate.LastName + " in sector " + EmployeeToUpdate.Sector.SectorName); archive.WriteToFile(input); return(employee); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(null); } }
/// <summary> /// Adds new location to database /// </summary> /// <param name="L">A location that is to be added</param> public void AddLocation(Location L) { try { using (Task_1Entities context = new Task_1Entities()) { context.Locations.Add(L); context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
public List <Employee> GetAllManagers(Employee updateEmployee) { try { using (Task_1Entities context = new Task_1Entities()) { return((from x in context.Employees where x.EmployeeID != updateEmployee.EmployeeID select x).ToList()); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(null); } }
/// <summary> /// This method gets all the sectors from database and adds them to a list /// </summary> /// <returns>A list of all sectors in DataBase</returns> public List <Sector> GetAllSectors() { try { using (Task_1Entities context = new Task_1Entities()) { List <Sector> list = new List <Sector>(); list = (from x in context.Sectors select x).ToList(); return(list); } } catch (Exception ex) { MessageBox.Show("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// This method gets all the employees from view and adds them to a list /// </summary> /// <returns>A list of all employees in view</returns> public List <EmployeeView> GetEmployeeViews() { try { using (Task_1Entities context = new Task_1Entities()) { List <EmployeeView> list = new List <EmployeeView>(); list = (from x in context.EmployeeViews select x).ToList(); return(list); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(null); } }
/// <summary> /// This method deletes an employee from the database /// </summary> /// <param name="deleteID">ID of employee that is to be deleted</param> public void DeleteEmplyee(int deleteID) { try { using (Task_1Entities context = new Task_1Entities()) { Employee employee = (from e in context.Employees where e.EmployeeID == deleteID select e).FirstOrDefault(); context.Employees.Remove(employee); context.SaveChanges(); string input = (DateTime.Now + " / Deleted Employee named " + employee.FirstName + " " + employee.LastName + " in sector " + employee.Sector.SectorName); archive.WriteToFile(input); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
public Sector AddSector(Sector sector) { try { using (Task_1Entities context = new Task_1Entities()) { Sector newSector = new Sector(); newSector.SectorID = sector.SectorID; newSector.SectorName = sector.SectorName; context.Sectors.Add(newSector); context.SaveChanges(); return(newSector); } } catch (Exception ex) { MessageBox.Show("Exception " + ex.Message.ToString() + "/" + ex.Source + "/" + ex.InnerException); return(null); } }
public void EmployeesToDB() { List <Employee> existingEmployees = GetAllEmployees(); List <Employee> newEmployees = new List <Employee>(); StreamReader sr = new StreamReader(@".../.../Employees.txt"); if (!File.Exists(@".../.../Employees.txt")) { File.Create(@".../.../Employees.txt").Close(); } string line; while ((line = sr.ReadLine()) != null) { string[] employeeData = line.Split(','); Employee e = new Employee(); e.FirstName = employeeData[0]; e.LastName = employeeData[1]; e.DateOfBirth = Convert.ToDateTime(employeeData[2]); e.IDNumber = employeeData[3]; e.JMBG = employeeData[4]; e.Gender = employeeData[5]; e.PhoneNumber = employeeData[6]; e.SectorID = Convert.ToInt32(employeeData[7]); e.LocationID = Convert.ToInt32(employeeData[8]); e.Manager = employeeData[9]; newEmployees.Add(e); } var employeesToAdd = newEmployees.Where(e => existingEmployees.All(e2 => e2.JMBG != e.JMBG)); using (Task_1Entities context = new Task_1Entities()) { foreach (var emp in employeesToAdd) { context.Employees.Add(emp); string input = (DateTime.Now + " / Added new Employee with name " + emp.FirstName + " " + emp.LastName + " directly to database"); archive.WriteToFile(input); context.SaveChanges(); } } }
private void UpdateEmployeeExecute() { try { using (Task_1Entities context = new Task_1Entities()) { int userID = Employee.EmployeeID; Employee e = (from x in context.Employees where x.EmployeeID == userID select x).First(); UpdateEmployeeView updateEmplyee = new UpdateEmployeeView(e); updateEmplyee.ShowDialog(); if ((updateEmplyee.DataContext as UpdateEmployeeViewModel).IsUpdateEmployee == true) { EmpViews = empModel.GetEmployeeViews(); } } } catch (Exception ex) { MessageBox.Show("Exception" + ex.Message.ToString()); } }