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