public static bool AddEmployee(Employee employee) { try { using (VodovozContext data = new VodovozContext()) { data.Employees.Add(employee); data.SaveChanges(); } return(true); } catch { return(false); } }
public static bool AddOrder(Order order) { try { using (VodovozContext data = new VodovozContext()) { data.Orders.Add(order); data.SaveChanges(); } return(true); } catch { return(false); } }
public static bool AddDepartment(string name) { try { using (VodovozContext data = new VodovozContext()) { Department dpt = new Department(); dpt.Name = name; data.Departments.Add(dpt); data.SaveChanges(); } return(true); } catch { return(false); } }
public static bool DeleteEmployee(string surname) { try { using (VodovozContext data = new VodovozContext()) { var employees = data.Employees.ToList().Where <Employee>(e => e.Surname == surname); foreach (var v in employees) { data.Employees.Remove(v); data.SaveChanges(); } } return(true); } catch { return(false); } }
public static bool AddLeader(string surname) { Employee employee = ConnectToDB.GetEmployee(surname); Department dpt = new Department(); try { using (VodovozContext data = new VodovozContext()) { var department = data.Departments.ToList().Where <Department>(d => d.Id == employee.DepartmentId); foreach (var v in department) { v.LeaderId = employee.Id; } data.SaveChanges(); } return(true); } catch { return(false); } }