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