void CreateEmployee(Employee employee, Log log)
{
using (var context = new SMCContext())
{
var emp = new Employee
{
FirstName = employee.FirstName,
MiddleName = employee.MiddleName,
LastName = employee.LastName,
Email = employee.Email,
Department = context.Departments.Find(keyValues: employee.Department.DepartmentId)
};
log.FirstName = employee.FirstName;
log.MiddleName = employee.MiddleName;
log.LastName = employee.LastName;
log.Email = employee.Email;
log.Department = employee.Department.DepartmentTitle;
log.Organization = employee.Department.Organization.OrganizationTitle;
log.dateTime = DateTime.Now;
log.LogType = context.LogTypes.FirstOrDefault(x => x.Type == "добавлен новый сотрудник");
context.Employes.Add(emp);
context.Logs.Add(log);
context.SaveChanges();
}
}
public IEnumerable <Organization> Organizations()
{
using (var context = new SMCContext())
{
var res = context.Organizations.ToList();
return(res);
};
}
public IEnumerable <Department> Departments()
{
using (var context = new SMCContext())
{
var res = context.Departments
.Include("Organization").ToList();
return(res);
};
}
public IEnumerable <Log> Logs()
{
using (var context = new SMCContext())
{
var res = context.Logs.Include("LogType")
.Include("Employee").Include("Employee.Department")
.Include("Employee.Department.Organization").ToList();
return(res);
};
}
public IEnumerable <Employee> Employers()
{
using (var context = new SMCContext())
{
var res = context.Employes
.Include("Department")
.Include("Department.Organization").ToList();
return(res);
};
}
public void EditEmployer(Employee employee)
{
using (var context = new SMCContext())
{
var emp = context.Employes.
Include("Department").Include("Department.Organization").
FirstOrDefault(x => x.EmployeeId == employee.EmployeeId);
Log log = new Log();
if (emp == null)
{
CreateEmployee(employee, log);
}
if (emp != null)
{
if (emp.FirstName != employee.FirstName)
{
log.FirstName = $"{emp.FirstName}=>{employee.FirstName}";
emp.FirstName = employee.FirstName;
}
else
{
log.FirstName = employee.FirstName;
}
if (emp.MiddleName != employee.MiddleName)
{
log.MiddleName = $"{emp.MiddleName}=>{employee.MiddleName}";
emp.MiddleName = employee.MiddleName;
}
else
{
log.MiddleName = employee.MiddleName;
}
if (emp.LastName != employee.LastName)
{
log.LastName = $"{emp.LastName}=>{employee.LastName}";
emp.LastName = employee.LastName;
}
else
{
log.LastName = employee.LastName;
}
if (emp.Email != employee.Email)
{
log.Email = $"{emp.Email}=>{employee.Email}";
emp.Email = employee.Email;
}
else
{
log.Email = employee.Email;
}
if (emp.Department.DepartmentId != employee.Department.DepartmentId)
{
log.Department = $"{emp.Department.DepartmentTitle}=>{employee.Department.DepartmentTitle}";
if (emp.Department.Organization.OrganizationID != employee.Department.
Organization.OrganizationID)
{
log.Organization = $"{emp.Department.Organization.OrganizationTitle}=>{employee.Department.Organization.OrganizationTitle}";
}
else
{
log.Organization = emp.Department.Organization.OrganizationTitle;
}
emp.Department = context.Departments
.Find(keyValues: employee.Department.DepartmentId);
}
else
{
log.Department = employee.Department.DepartmentTitle;
log.Organization = emp.Department.Organization.OrganizationTitle;
}
if (log.FirstName != emp.FirstName || log.MiddleName != emp.MiddleName ||
log.LastName != emp.LastName ||
log.Email != emp.Email ||
log.Department != emp.Department.DepartmentTitle)
{
log.dateTime = DateTime.Now;
log.Employee = emp;
log.LogType = context.LogTypes
.FirstOrDefault(x => x.Type == "редактирование данных сотрудника");
context.Logs.Add(log);
}
context.SaveChanges();
}
}
}
