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);
}
}
}
}
}
