public void Add(Costumer item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Costumers.Add(item); this._costumerList.Add(item); db.SaveChanges(); } }
public void Add(Employee item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Employees.Add(item); this.EmployeeList.Add(item); db.SaveChanges(); } }
public void Update(Project item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Projects.Update(item); this.ProjectList[this.ProjectList.FindIndex(project => project.ProjectId == item.ProjectId)] = item; db.SaveChanges(); } }
public void Add(Project item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Projects.Add(item); this.ProjectList.Add(item); db.SaveChanges(); } }
public void Update(Costumer item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Costumers.Update(item); this.CostumerList[this.CostumerList.FindIndex(costumer => costumer.CostumerId == item.CostumerId)] = item; db.SaveChanges(); } }
public void Update(Employee item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Employees.Update(item); this.EmployeeList[this.EmployeeList.FindIndex(employee => employee.EmployeeId == item.EmployeeId)] = item; db.SaveChanges(); } }
public void Remove(ProjectsForEmployee item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.ProjectsForEmployees.Remove(item); EmployeeCatalog .Instance .EmployeeList[EmployeeCatalog.Instance.EmployeeList.FindIndex( employee => employee.EmployeeId == item.EmployeeId)] .ProjectsForEmployees.Remove(item); db.SaveChanges(); } }
public void Remove(Employee item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Employees.Remove(item); this.EmployeeList.Remove(item); foreach (ProjectsForEmployee project in item.ProjectsForEmployees) { db.ProjectsForEmployees.Remove(project); ProjectForEmployeesCatalog.Instance.ProjectsForEmployeesList.Remove(project); } db.SaveChanges(); } }
public void Remove(Project item) { using (DbContextVisionGroup db = new DbContextVisionGroup()) { db.Projects.Remove(item); this.ProjectList.Remove(item); foreach (ProjectsForEmployee projectforEmployee in ProjectForEmployeesCatalog .Instance.ProjectsForEmployeesList .Where(p => p.ProjectId == item.ProjectId).ToList()) { db.ProjectsForEmployees.Remove(projectforEmployee); ProjectForEmployeesCatalog.Instance.ProjectsForEmployeesList.Remove(projectforEmployee); } db.SaveChanges(); } }
public void Load() { using (DbContextVisionGroup db = new DbContextVisionGroup()) { Task a = Task.Run(new Action(ProjectForEmployeesCatalog.Instance.Load)); this.EmployeeList = db.Employees.ToList(); a.Wait(); foreach (Employee employee in this._employeeList) { foreach (ProjectsForEmployee projectForEmployee in ProjectForEmployeesCatalog .Instance.ProjectsForEmployeesList) { if (employee.EmployeeId == projectForEmployee.EmployeeId) { employee.ProjectsForEmployees.Add(projectForEmployee); } } } } }