public async Task <ActionResult <ProjectManagement> > PostProjectManagement(ProjectManagementDTO projectManagementDTO)
{
var projassigned = _context.ProjectManagements.Where(p => p.EmployeeId == projectManagementDTO.EmployeeId && p.ProjectId == projectManagementDTO.ProjectId).FirstOrDefault();
if (projassigned != null)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "Employee is already assigned to the Project"
}));
}
ProjectManagement projectManagement = new ProjectManagement
{
ProjectId = projectManagementDTO.ProjectId,
EmployeeId = projectManagementDTO.EmployeeId
};
_context.ProjectManagements.Add(projectManagement);
await _context.SaveChangesAsync();
return(Ok(new RespStatus {
Status = "Success", Message = "Employee is assigned to the Project"
}));
}
public async Task <IActionResult> PutProjectManagement(int id, ProjectManagementDTO projectManagementDto)
{
if (id != projectManagementDto.Id)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "Id is invalid"
}));
}
var projMgmt = await _context.ProjectManagements.FindAsync(id);
projMgmt.Id = projectManagementDto.Id;
projMgmt.ProjectId = projectManagementDto.ProjectId;
projMgmt.EmployeeId = projectManagementDto.EmployeeId;
_context.ProjectManagements.Update(projMgmt);
//_context.Entry(projectDto).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(Ok(new RespStatus {
Status = "Success", Message = "Project Management data Updated!"
}));
}
public async Task <IActionResult> PutProjectManagement(int id, ProjectManagementDTO projectManagementDto)
{
if (id != projectManagementDto.Id)
{
return(BadRequest());
}
var projMgmt = await _context.ProjectManagements.FindAsync(id);
projMgmt.Id = projectManagementDto.Id;
projMgmt.ProjectId = projectManagementDto.ProjectId;
projMgmt.EmployeeId = projectManagementDto.EmployeeId;
_context.ProjectManagements.Update(projMgmt);
//_context.Entry(projectDto).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectManagementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <ProjectManagement> > PostProjectManagement(ProjectManagementDTO projectManagementDTO)
{
ProjectManagement projectManagement = new ProjectManagement();
projectManagement.ProjectId = projectManagementDTO.ProjectId;
projectManagement.EmployeeId = projectManagementDTO.EmployeeId;
_context.ProjectManagements.Add(projectManagement);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProjectManagement", new { id = projectManagement.Id }, projectManagement));
}
public async Task <ActionResult <ProjectManagementDTO> > GetProjectManagement(int id)
{
ProjectManagementDTO projManagementDTO = new ProjectManagementDTO();
var projManagement = await _context.ProjectManagements.FindAsync(id);
if (projManagement == null)
{
return(NotFound());
}
projManagementDTO.Id = projManagement.Id;
projManagementDTO.ProjectId = projManagement.ProjectId;
projManagementDTO.EmployeeId = projManagement.EmployeeId;
return(projManagementDTO);
}
public async Task <ActionResult <IEnumerable <ProjectManagementDTO> > > GetProjectManagement()
{
List <ProjectManagementDTO> ListProjectManagementDTO = new List <ProjectManagementDTO>();
var projManagements = await _context.ProjectManagements.ToListAsync();
foreach (ProjectManagement projMgt in projManagements)
{
ProjectManagementDTO projectmgmtDTO = new ProjectManagementDTO();
projectmgmtDTO.Id = projMgt.Id;
projectmgmtDTO.ProjectId = projMgt.ProjectId;
projectmgmtDTO.EmployeeId = projMgt.EmployeeId;
ListProjectManagementDTO.Add(projectmgmtDTO);
}
return(ListProjectManagementDTO);
}
public async Task <ActionResult <ProjectManagementDTO> > GetProjectManagement(int id)
{
ProjectManagementDTO projManagementDTO = new ProjectManagementDTO();
var projManagement = await _context.ProjectManagements.FindAsync(id);
if (projManagement == null)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "PROJ Management Id is Invalid!"
}));
}
projManagementDTO.Id = projManagement.Id;
projManagementDTO.ProjectId = projManagement.ProjectId;
projManagementDTO.EmployeeId = projManagement.EmployeeId;
return(projManagementDTO);
}
public async Task <ActionResult <IEnumerable <ProjectManagementDTO> > > GetProjectManagement()
{
List <ProjectManagementDTO> ListProjectManagementDTO = new List <ProjectManagementDTO>();
var projManagements = await _context.ProjectManagements.ToListAsync();
foreach (ProjectManagement projMgt in projManagements)
{
ProjectManagementDTO projectmgmtDTO = new ProjectManagementDTO
{
Id = projMgt.Id,
ProjectId = projMgt.ProjectId,
ProjectName = _context.Projects.Find(projMgt.ProjectId).ProjectName,
EmployeeId = projMgt.EmployeeId,
EmployeeName = _context.Employees.Find(projMgt.EmployeeId).GetFullName()
};
ListProjectManagementDTO.Add(projectmgmtDTO);
}
return(ListProjectManagementDTO);
}
