public async Task <ActionResult <SubProject> > PostSubProject(SubProjectDTO subProjectDto)
{
var subproject = _context.SubProjects.Where(c => c.SubProjectName == subProjectDto.SubProjectName).FirstOrDefault();
if (subproject != null)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "Sub Project Already Exists"
}));
}
SubProject SubProj = new SubProject
{
ProjectId = subProjectDto.ProjectId,
SubProjectName = subProjectDto.SubProjectName,
SubProjectDesc = subProjectDto.SubProjectDesc
};
_context.SubProjects.Add(SubProj);
await _context.SaveChangesAsync();
return(Ok(new RespStatus {
Status = "Success", Message = "Sub-Project Created!"
}));
}
public async Task <IActionResult> PutSubProject(int id, SubProjectDTO subProjectDto)
{
if (id != subProjectDto.Id)
{
return(BadRequest());
}
var subProj = await _context.SubProjects.FindAsync(id);
subProj.Id = subProjectDto.Id;
subProj.SubProjectName = subProjectDto.SubProjectName;
subProj.SubProjectDesc = subProjectDto.SubProjectDesc;
_context.SubProjects.Update(subProj);
//_context.Entry(SubProjects).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubProjectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutSubProject(int id, SubProjectDTO subProjectDto)
{
if (id != subProjectDto.Id)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "Id is invalid"
}));
}
var subProj = await _context.SubProjects.FindAsync(id);
subProj.Id = subProjectDto.Id;
subProj.SubProjectName = subProjectDto.SubProjectName;
subProj.SubProjectDesc = subProjectDto.SubProjectDesc;
_context.SubProjects.Update(subProj);
//_context.Entry(SubProjects).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(Ok(new RespStatus {
Status = "Success", Message = "Sub Project Updated!"
}));
}
public async Task <ActionResult <SubProject> > PostSubProject(SubProjectDTO subProjectDto)
{
SubProject SubProj = new SubProject();
SubProj.SubProjectName = subProjectDto.SubProjectName;
SubProj.SubProjectDesc = subProjectDto.SubProjectDesc;
_context.SubProjects.Add(SubProj);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSubProject", new { id = SubProj.Id }, SubProj));
}
public async Task <ActionResult <SubProjectDTO> > GetSubProject(int id)
{
SubProjectDTO subProjectDTO = new SubProjectDTO();
var SubProj = await _context.SubProjects.FindAsync(id);
if (SubProj == null)
{
return(NotFound());
}
subProjectDTO.Id = SubProj.Id;
subProjectDTO.SubProjectName = SubProj.SubProjectName;
subProjectDTO.SubProjectDesc = SubProj.SubProjectDesc;
return(subProjectDTO);
}
private void WriteSubProject(ISheet sheet, SubProjectDTO project, int rowIdx)
{
var row = sheet.CreateRow(rowIdx);
var index = 0;
row.CreateCell(index++).SetCellValue(project.Code);
row.CreateCell(index++).SetCellValue(project.Name);
row.CreateCell(index++).SetCellValue(project.State.ToString());
row.CreateCell(index++).SetCellValue(project.StartDate);
row.CreateCell(index++).SetCellValue(project.FinishDate?.ToString() ?? string.Empty);
row.CreateCell(index++).SetCellValue(project is ProjectDTO dto ? string.Join(", ", dto.SubProjects.Select(x => x.Code)) : string.Empty);
foreach (var task in project.Tasks)
{
row = sheet.CreateRow(++rowIdx);
WriteTask(row, task, index, ref rowIdx);
}
}
public async Task <ActionResult <IEnumerable <SubProjectDTO> > > GetSubProjects()
{
List <SubProjectDTO> ListSubProjectDTO = new List <SubProjectDTO>();
var SubProjects = await _context.SubProjects.ToListAsync();
foreach (SubProject SubProj in SubProjects)
{
SubProjectDTO SubProjectDTO = new SubProjectDTO();
SubProjectDTO.Id = SubProj.Id;
SubProjectDTO.SubProjectName = SubProj.SubProjectName;
SubProjectDTO.SubProjectDesc = SubProj.SubProjectDesc;
ListSubProjectDTO.Add(SubProjectDTO);
}
return(ListSubProjectDTO);
}
public async Task <ActionResult <SubProjectDTO> > GetSubProject(int id)
{
SubProjectDTO subProjectDTO = new SubProjectDTO();
var SubProj = await _context.SubProjects.FindAsync(id);
if (SubProj == null)
{
return(Conflict(new RespStatus {
Status = "Failure", Message = "Sub Project Id is Invalid!"
}));
}
subProjectDTO.Id = SubProj.Id;
subProjectDTO.SubProjectName = SubProj.SubProjectName;
subProjectDTO.ProjectId = SubProj.ProjectId;
subProjectDTO.SubProjectDesc = SubProj.SubProjectDesc;
return(subProjectDTO);
}
