public async Task <IEnumerable <ProjectDTO> > Create(ProjectDTO projectDTO)
{
Project project = CreateByMapper.CreateProjectByMapper(projectDTO);
await database.Projects.Create(project);
await database.Save();
IEnumerable <Project> projects = database.Projects.Find(p =>
p.Name == project.Name &&
p.Customer == project.Customer &&
p.Priority == project.Priority &&
p.Performer == project.Performer &&
p.StartDate == project.StartDate &&
p.FinishDate == project.FinishDate &&
p.LeadId == project.LeadId
);
if (projects == null)
{
return(null);
}
IEnumerable <ProjectDTO> projectDTOs = CreateByMapper.CreateProjectDTOByMapper(projects);
return(projectDTOs);
}
public async Task Edit(ProjectsEmployeesDTO source, ProjectsEmployeesDTO dest)
{
await database.ProjectsEmployees
.Update(CreateByMapper.CreateProjectEmployeeByMapper(source),
CreateByMapper.CreateProjectEmployeeByMapper(dest));
await database.Save();
}
public async Task <IEnumerable <EmployeeDTO> > Create(EmployeeDTO emp)
{
await database.Employees.Create(CreateByMapper.CreateEmployeeByMapper(emp));
await database.Save();
return(null);
}
public async Task <IEnumerable <ProjectsEmployeesDTO> > Create(ProjectsEmployeesDTO projectsEmployeesDTO)
{
ProjectsEmployees pe = CreateByMapper.CreateProjectEmployeeByMapper(projectsEmployeesDTO);
IEnumerable <Employee> emps = database.Employees.Find(e => e.EmployeeId == pe.EmployeeId);
IEnumerable <Project> ps = database.Projects.Find(p => p.ProjectId == pe.ProjectId);
if (emps != null && ps != null)
{
await database.ProjectsEmployees.Create(pe);
await database.Save();
}
return(null);
}
public async Task Delete(ProjectDTO projectDTO)
{
Project p = CreateByMapper.CreateProjectByMapper(projectDTO);
await database.Projects.Delete(p);
IEnumerable <ProjectsEmployees> projectsEmployees = database.ProjectsEmployees.Find(pe => pe.ProjectId == p.ProjectId);
if (projectsEmployees != null)
{
foreach (var pes in projectsEmployees)
{
await database.ProjectsEmployees.Delete(pes);
}
}
await database.Save();
}
public async Task Delete(EmployeeDTO emp)
{
Employee e = CreateByMapper.CreateEmployeeByMapper(emp);
await database.Employees.Delete(e);
IEnumerable <ProjectsEmployees> projectsEmployees = database.ProjectsEmployees.Find(pe => pe.EmployeeId == e.EmployeeId);
if (projectsEmployees != null)
{
foreach (var pes in projectsEmployees)
{
await database.ProjectsEmployees.Delete(pes);
}
}
await database.Save();
}
public async Task <IEnumerable <ProjectsEmployeesDTO> > Find(int?projectId)
{
return(CreateByMapper.CreateProjectEmployeeDTOByMapper(database.ProjectsEmployees.Find(pe => pe.ProjectId == projectId)));
}
public async Task Delete(ProjectsEmployeesDTO projectsEmployeesDTO)
{
await database.ProjectsEmployees.Delete(CreateByMapper.CreateProjectEmployeeByMapper(projectsEmployeesDTO));
await database.Save();
}
public async Task <IEnumerable <EmployeeDTO> > Find(string name)
{
IEnumerable <Employee> emps = database.Employees.Find(e => e.SurName.ToLower().StartsWith(name) || e.Name.ToLower().StartsWith(name) || e.Patronymic.ToLower().StartsWith(name));
return(CreateByMapper.CreateEmployeeDTOByMapper(emps));
}
public async Task Edit(EmployeeDTO source, EmployeeDTO dest)
{
await database.Employees.Update(CreateByMapper.CreateEmployeeByMapper(source), CreateByMapper.CreateEmployeeByMapper(dest));
await database.Save();
}