public ResponseMessage DeleteWBS(int Id)
{
try {
WorkBreakdown wbData = _context.WorkBreakdown.Where(x => x.Id == Id && x.IsDelete == false).FirstOrDefault();
if (wbData == null)
{
throw new ValueNotFoundException("WBS Id doesn't exist.");
}
wbData.IsDelete = true;
wbData.UpdatedAt = DateTime.Now;
_context.SaveChanges();
AuditLogs audit = new AuditLogs()
{
Action = "WBS Delete",
Message = string.Format("WBS Id: {0}, deleted successfully", wbData.WbsId),
CreatedBy = null //TODO:will get from session
};
_commonRepo.AuditLog(audit);
return(new ResponseMessage()
{
Message = string.Format("WBS Id: {0}, deleted successfully", wbData.WbsId),
});
} catch (Exception ex) {
throw ex;
}
}
public WorkBreakDownDetails GetWBSDetailsById(int Id)
{
try {
WorkBreakdown wbData = _context.WorkBreakdown.Include(c => c.Project).Where(x => x.IsDelete == false && x.Id == Id).FirstOrDefault();
if (wbData == null)
{
throw new ValueNotFoundException("WBS Id doesn't exist.");
}
WorkBreakDownDetails wbsDtl = _mapper.Map <WorkBreakDownDetails> (wbData);
return(wbsDtl);
} catch (Exception ex) {
throw ex;
}
}
public ResponseMessage BulkInsertWBS(List <AddWorkBreakDown> lstWorkBreakDown)
{
try {
foreach (AddWorkBreakDown wbs in lstWorkBreakDown)
{
WorkBreakdown wbData = new WorkBreakdown();
WorkBreakdown wbData1 = _context.WorkBreakdown.Where(x => x.WbsId == wbs.WorkBreakDownCode && x.ProjectId == wbs.ProjectId &&
x.Segment == wbs.Segment && x.SubSegment == wbs.SubSegment && x.Elements == wbs.Element &&
x.IsDelete == false).FirstOrDefault();
if (wbData1 == null)
{
wbData.WbsId = wbs.WorkBreakDownCode;
wbData.Segment = wbs.Segment;
wbData.SubSegment = wbs.SubSegment;
wbData.Elements = wbs.Element;
wbData.ProjectId = wbs.ProjectId;
wbData.CreatedAt = DateTime.Now;
wbData.CreatedBy = 1; //to do
_context.WorkBreakdown.Add(wbData);
_context.SaveChanges();
}
}
AuditLogs audit = new AuditLogs()
{
Action = "WBS Insert",
Message = string.Format("WBS BulkUpload completed Succussfully"),
CreatedBy = null, //TODO:will get from session
};
_commonRepo.AuditLog(audit);
return(new ResponseMessage()
{
Message = "WBS Bulk Upload Completed successfully.",
});
} catch (Exception ex) {
throw ex;
}
}
