public ResponseMessage DispatchTransferPrice(DispatchTransferPrice dispTrnsfer) { // siteDispScan.fromProjId try { ResponseMessage res = new ResponseMessage(); DispatchRequirement dispReq = _context.DispatchRequirement.Include(c => c.Servicetype).Where(x => x.Id == dispTrnsfer.dispReqId).FirstOrDefault(); if (dispReq == null) { throw new ValueNotFoundException("Dispatch ID doesnt exists."); } if (dispReq.Servicetype.Name != commonEnum.ServiceType.Reuse.ToString()) { throw new ValueNotFoundException("Not valid service type"); } if (dispReq.Status != Util.GetDescription(Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED)).ToString()) { throw new ValueNotFoundException("Dispatch not allowed to approve"); } dispReq.TransferPrice = dispTrnsfer.transferPrice; dispReq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.FAAAPPROVED).ToString(); dispReq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.FAAAPPROVED).ToString(); _context.SaveChanges(); res.Message = "Transfer Price updated successfully"; return(res); } catch (Exception ex) { throw ex; } }
public ResponseMessage FBAssignVendor(FBDispatchReqSubCont fBDispatchReqSubCont) { try { ResponseMessage responseMessage = new ResponseMessage(); string[] strAllowedService = { commonEnum.ServiceType.Fabrication.ToString(), commonEnum.ServiceType.OutSourcing.ToString() }; DispatchRequirement dispReq = _context.DispatchRequirement.Include(c => c.Servicetype).Where(x => x.DispatchNo == fBDispatchReqSubCont.DispatchNo).FirstOrDefault(); if (dispReq.StatusInternal != Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString() && !strAllowedService.Contains(dispReq.Servicetype.Name)) { throw new ValueNotFoundException("Assign Vendor not allowed"); } DispatchreqSubcont dispatchreqSubcont = _mapper.Map <DispatchreqSubcont>(fBDispatchReqSubCont); dispatchreqSubcont.CreatedAt = DateTime.Now; dispatchreqSubcont.CreatedBy = 1; //TODO dispatchreqSubcont.Status = "New"; dispatchreqSubcont.StatusInternal = "New"; dispatchreqSubcont.ServicetypeId = 1; //Add the dispatch subcont structure if (fBDispatchReqSubCont.VendorStructures.Any()) { var groupbyVendor = fBDispatchReqSubCont.VendorStructures.GroupBy(c => c.SubContId); foreach (var group in groupbyVendor) { dispatchreqSubcont.SubconId = group.Key; dispatchreqSubcont.Quantity = group.Count(); _context.DispatchreqSubcont.Add(dispatchreqSubcont); _context.SaveChanges(); foreach (var item in group) { DispReqStructure drsDB = _context.DispReqStructure.Where(x => x.ProjStructId == item.ProjStructureId && x.DispreqId == fBDispatchReqSubCont.DispreqId).FirstOrDefault(); if (drsDB == null) { throw new ValueNotFoundException("Dispatch Requirement ID doesn't exists"); } DispSubcontStructure dispSubcontStructure = new DispSubcontStructure(); dispSubcontStructure.ProjStructId = item.ProjStructureId; dispSubcontStructure.DispreqsubcontId = dispatchreqSubcont.Id; dispSubcontStructure.DispStructureId = drsDB.Id; // dispSubcontStructure.FabricationCost = item.FabricationCost; _context.DispSubcontStructure.Add(dispSubcontStructure); _context.SaveChanges(); } } } dispReq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.PROCAPPROVED).ToString(); dispReq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.PROCAPPROVED).ToString(); _context.SaveChanges(); responseMessage.Message = "Vendor is assigned successfully"; return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage UpdatescannedStatus(ReciveUpdateVm input) { try { ResponseMessage responseMessage = new ResponseMessage(); // ProjectStructure ProjectStruct = // _context.ProjectStructure.Single(w => w.Id == input.projectstructreId); // if (ProjectStruct != null) // { // ProjectStruct.StructureStatus =Util.GetDescription(commonEnum.StructureStatus.NOTAVAILABLE).ToString(); // ProjectStruct.CurrentStatus = Util.GetDescription(commonEnum.StructureInternalStatus.INUSE).ToString(); // } // _context.ProjectStructure.Update(ProjectStruct); int dispReqStrlst = _context.DispReqStructure.Where(w => w.DispreqId == input.DispatchRequiremntId && w.DispStructStatus != Util.GetDescription(commonEnum.SiteDispStructureStatus.FROMSITEAPPROVED).ToString()).Count(); DispReqStructure dispReqStr = _context.DispReqStructure.Single(w => w.Id == input.DisptachRequiremntstructureId); if (dispReqStr != null) { dispReqStr.DispStructStatus = Util.GetDescription(commonEnum.SiteDispStructureStatus.FROMSITEAPPROVED).ToString(); // dispReqStr.Location =input.Location; } _context.DispReqStructure.Update(dispReqStr); DispatchRequirement disprequirement = _context.DispatchRequirement.Single(w => w.Id == input.DispatchRequiremntId); if (dispReqStrlst == 0) { if (disprequirement != null) { disprequirement.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.FROMSITEAPPROVED).ToString(); disprequirement.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.FROMSITEAPPROVED).ToString(); } else { disprequirement.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.PARIALLYFROMSITEAPPROVED).ToString(); disprequirement.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.PARIALLYFROMSITEAPPROVED).ToString(); } } _context.DispatchRequirement.Update(disprequirement); _context.SaveChanges(); responseMessage.Message = "Status Updated sucessfully"; return(responseMessage); } catch (Exception ex) { throw ex; } }
public int UpsertProjectStructure(CMPCUpdateStructure request) { ResponseMessage response = new ResponseMessage(); response.Message = "Structure Updated successfully"; // if (request?.ProjectStructureDetail == null) // throw new ValueNotFoundException ("ProjectStructureDetail Request cannot be empty."); try { using (var transaction = _context.Database.BeginTransaction()) { try { var isUpdate = false; var projectStructureID = 0; var projectStructure = _context.ProjectStructure.Where(x => x.Id == request.ProjStructureId && x.IsDelete == false).FirstOrDefault(); projectStructure.DrawingNo = request.DrawingNo; projectStructure.UpdatedAt = DateTime.Now; projectStructure.EstimatedWeight = Convert.ToDecimal(request.EstimatedWeight); projectStructure.ComponentsCount = request.CompCount; _context.SaveChanges(); projectStructureID = projectStructure.Id; DispReqStructure dispStruct = _context.DispReqStructure.Where(x => x.Id == request.dispStructureId).FirstOrDefault(); dispStruct.DispStructStatus = Util.GetDescription(commonEnum.SiteDispStructureStatus.CMPCAPPROVED).ToString(); _context.SaveChanges(); int?dispReqId = dispStruct.DispreqId; DispatchRequirement dispReq = _context.DispatchRequirement.Where(x => x.Id == dispReqId).FirstOrDefault(); var lstDispStruct = _context.DispReqStructure.Where(x => x.DispreqId == dispReqId).ToList(); if (lstDispStruct.Count() == lstDispStruct.Where(x => x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispStructureStatus.CMPCAPPROVED).ToString()).Count()) { dispReq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString(); dispReq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString(); } else { dispReq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); dispReq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); } _context.SaveChanges(); transaction.Commit(); return(projectStructureID); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } catch (Exception ex) { throw ex; } }
public ResponseMessage AddStructurecomponent(ADDStructureComponentDetails input) { try { ResponseMessage responseMessage = new ResponseMessage(); ProjectStructure structid = _context.ProjectStructure.Single(w => w.Id == input.ProjectStructureId); structid.ActualWbs = input.ActualWbs; structid.FabricationYear = input.FabricationYear; structid.ActualWeight = input.ActualWeight; structid.Reusuability = input.Reusuability; structid.ExpReleaseDate = input.ExpReleaseDate; if (input.uploadDocs != null) { foreach (IFormFile file in input.uploadDocs) { Upload_Docs layerDoc = new Upload_Docs(); layerDoc.fileName = file.FileName; layerDoc.filepath = UploadedFile(file); layerDoc.uploadType = "Docs"; layerDoc.fileType = Path.GetExtension(file.FileName); this._repository.StructureDocsUpload(layerDoc, input.ProjectStructureId); // _gridRepo.LayerDocsUpload(layerDoc, layerId); } } RemoveStructureDocs(input.remove_docs_filename); DispatchRequirement DispatchRequirement = _context.DispatchRequirement.Single(w => w.Id == input.DispatchRequirementId); if (DispatchRequirement != null) { DispatchRequirement.Status = Util.GetDescription(commonEnum.SiteDispStructureStatus.FABRICATIONCOMPLETED).ToString(); DispatchRequirement.StatusInternal = Util.GetDescription(commonEnum.SiteDispStructureStatus.FABRICATIONCOMPLETED).ToString(); } _context.ProjectStructure.Update(structid); _context.DispatchRequirement.Update(DispatchRequirement); _context.SaveChanges(); responseMessage.Message = "ProjectStructure Updated sucessfully"; return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage UpdateFabricationStatus(FabricationVm input) { try { ResponseMessage responseMessage = new ResponseMessage(); ProjectStructure ProjectStruct = _context.ProjectStructure.Single(w => w.Id == input.projectstructreId); if (ProjectStruct != null) { ProjectStruct.StructureStatus = Util.GetDescription(commonEnum.StructureStatus.NOTAVAILABLE).ToString(); ProjectStruct.CurrentStatus = Util.GetDescription(commonEnum.StructureInternalStatus.INUSE).ToString(); } _context.ProjectStructure.Update(ProjectStruct); DispReqStructure dispReqStr = _context.DispReqStructure.Single(w => w.Id == input.DisptachRequiremntstructureId); if (dispReqStr != null) { dispReqStr.DispStructStatus = Util.GetDescription(commonEnum.SiteDispStructureStatus.SCANNED).ToString(); dispReqStr.Location = input.Location; } _context.DispReqStructure.Update(dispReqStr); DispatchRequirement disprequirement = _context.DispatchRequirement.Single(w => w.Id == input.DispatchRequiremntId); if (disprequirement != null) { disprequirement.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.PARTIALLYSCANNED).ToString(); disprequirement.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.PARTIALLYSCANNED).ToString(); _context.DispatchRequirement.Update(disprequirement); _context.SaveChanges(); } responseMessage.Message = "Status Updated sucessfully"; return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage CreateDispatch(TWCCDispatchPayload payload) { try { string dispatchNo = string.Empty; string structCode = string.Empty; int dispReuseCount = 0; int projectId = 1; List <dispatchedStrucCount> result = new List <dispatchedStrucCount>(); string count = string.Format("select count(*) as cnt from dispatch_requirement dr inner join disp_req_structure drs on dr.id = drs.dispreq_id inner join project_structure ps on drs.proj_struct_id = ps.id where ps.structure_id = {0} and dr.sitereq_id = {1}", payload.StructureId, payload.siteRequirementId); result = _context.Set <dispatchedStrucCount>().FromSqlRaw(count).ToList(); int dispatchedQuantity = result.FirstOrDefault().cnt; int excedCout = dispatchedQuantity + payload.Quantity; int totalcount = _context.SiteReqStructure.Single(s => s.SiteReqId == payload.siteRequirementId && s.StructId == payload.StructureId).Quantity ?? 0; if (totalcount < excedCout) { throw new ValueNotFoundException("Dispatch quantity should match the required quantity."); } ServiceType servType = _context.ServiceType.Where(x => x.Id == payload.ServiceTypeId).FirstOrDefault(); if (servType.Name == commonEnum.ServiceType.Fabrication.ToString()) { dispReuseCount = _context.DispatchRequirement.Include(m => m.Servicetype).Where(x => x.DispatchNo.Contains("DC")).Count() + 1; } else if (servType.Name == commonEnum.ServiceType.OutSourcing.ToString()) { dispReuseCount = _context.DispatchRequirement.Include(m => m.Servicetype).Where(x => x.DispatchNo.Contains("DC")).Count() + 1; } else if (servType.Name == commonEnum.ServiceType.Reuse.ToString()) { dispReuseCount = _context.DispatchRequirement.Include(m => m.Servicetype).Where(x => x.DispatchNo.Contains("DA")).Count() + 1; } SiteRequirement siteReqr = _context.SiteRequirement.Include(c => c.SiteReqStructure).Where(x => x.Id == payload.siteRequirementId).FirstOrDefault(); // for structure id override in multiple component if (servType.Name == commonEnum.ServiceType.Fabrication.ToString() || servType.Name == commonEnum.ServiceType.OutSourcing.ToString()) { // int structCount = _context.ProjectStructure.Count () + 1; // structCode = constantVal.StructureIdPrefix + structCount.ToString ().PadLeft (6, '0'); dispatchNo = constantVal.DispVendorPrefix + dispReuseCount.ToString().PadLeft(6, '0'); } if (servType.Name == commonEnum.ServiceType.Reuse.ToString()) { dispatchNo = constantVal.DispReusePrefix + dispReuseCount.ToString().PadLeft(6, '0'); } ResponseMessage responseMessage = new ResponseMessage(); using (var transaction = _context.Database.BeginTransaction()) { try { DispatchRequirement dispReq = new DispatchRequirement(); dispReq.CreatedAt = DateTime.Now; dispReq.CreatedBy = payload.CreatedBy; //TODO dispReq.DispatchNo = dispatchNo; dispReq.RoleId = 1; // TODO dispReq.ServicetypeId = payload.ServiceTypeId; dispReq.SitereqId = payload.siteRequirementId; dispReq.SiteReqStructid = _context.SiteReqStructure.Where(x => x.SiteReqId == payload.siteRequirementId && x.StructId == payload.StructureId).FirstOrDefault().Id; dispReq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString(); dispReq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString(); dispReq.ToProjectid = payload.ToProjectId; dispReq.Quantity = payload.Quantity; _context.DispatchRequirement.Add(dispReq); _context.SaveChanges(); int structCountDb = _context.ProjectStructure.Count(); for (int iQty = 1; iQty <= payload.Quantity; iQty++) { if (servType.Name == commonEnum.ServiceType.Fabrication.ToString() || servType.Name == commonEnum.ServiceType.OutSourcing.ToString()) { int structCount = structCountDb + iQty; structCode = constantVal.StructureIdPrefix + structCount.ToString().PadLeft(6, '0'); } ProjectStructure projectStructure = new ProjectStructure(); if (servType.Name == commonEnum.ServiceType.Fabrication.ToString() || servType.Name == commonEnum.ServiceType.OutSourcing.ToString()) { SiteReqStructure siteRequirementStructure = _context.SiteReqStructure.Where(x => x.SiteReqId == payload.siteRequirementId && x.StructId == payload.StructureId).FirstOrDefault(); projectStructure.StructureId = payload.StructureId; projectStructure.StructCode = structCode; projectStructure.ProjectId = payload.ToProjectId; projectStructure.DrawingNo = ""; projectStructure.ComponentsCount = 0; projectStructure.StructureAttributesVal = siteRequirementStructure != null ? siteRequirementStructure.StructureAttributesVal : ""; projectStructure.EstimatedWeight = 0; projectStructure.StructureStatus = Util.GetDescription(commonEnum.StructureStatus.NOTAVAILABLE).ToString(); projectStructure.CurrentStatus = Util.GetDescription(commonEnum.StructureInternalStatus.DISPATCHINPROGRESS).ToString(); projectStructure.IsDelete = false; projectStructure.CreatedBy = payload.CreatedBy; projectStructure.CreatedAt = DateTime.Now; _context.ProjectStructure.Add(projectStructure); _context.SaveChanges(); } else { ProjectStructure structDB = _context.ProjectStructure.Where(x => x.Id == payload.ProjectStructureId).FirstOrDefault(); structDB.CurrentStatus = Util.GetDescription(commonEnum.StructureInternalStatus.DISPATCHINPROGRESS).ToString(); structDB.StructureStatus = Util.GetDescription(commonEnum.StructureStatus.NOTAVAILABLE).ToString(); _context.SaveChanges(); } DispReqStructure dispStrcture = new DispReqStructure(); dispStrcture.ProjStructId = servType.Name == commonEnum.ServiceType.Fabrication.ToString() || servType.Name == commonEnum.ServiceType.OutSourcing.ToString() ? projectStructure.Id : payload.ProjectStructureId; dispStrcture.DispreqId = dispReq.Id; if (servType.Name == commonEnum.ServiceType.Reuse.ToString()) { dispStrcture.FromProjectId = payload.FromProjectId; dispStrcture.SurplusDate = payload.SurplusFromDate; } dispStrcture.DispStructStatus = Util.GetDescription(commonEnum.SiteDispStructureStatus.NEW).ToString(); _context.DispReqStructure.Add(dispStrcture); _context.SaveChanges(); if (servType.Name == commonEnum.ServiceType.Reuse.ToString()) { var componentList = _context.Component.Where(x => x.ProjStructId == payload.ProjectStructureId).ToList(); foreach (Component comp in componentList) { DispStructureComp dsc = new DispStructureComp(); dsc.DispStructureId = dispStrcture.Id; dsc.DispCompId = comp.Id; _context.DispStructureComp.Add(dsc); } _context.SaveChanges(); } } /***update site requirement Structure status ***/ CodeList dispQty = _context.Query <CodeList>().FromSqlRaw(string.Format("select count(*) as Id,'' as Name , 0 as ServiceTypeId from dispatch_requirement dr inner join disp_req_structure drs on dr.id = drs.dispreq_id inner join project_structure ps on drs.proj_struct_id = ps.id where ps.structure_id ={0} and dr.sitereq_id ={1} and drs.disp_struct_status <> '{2}'", payload.StructureId, payload.siteRequirementId, Util.GetDescription(commonEnum.SiteDispStructureStatus.REJECT).ToString())).FirstOrDefault(); var dispatchedStrucCount = dispQty.Id; SiteRequirement dbSiteReq = _context.SiteRequirement.Where(x => x.Id == payload.siteRequirementId).FirstOrDefault(); SiteReqStructure dbSiteReqStructure = _context.SiteReqStructure.Where(x => x.SiteReqId == payload.siteRequirementId && x.StructId == payload.StructureId).FirstOrDefault(); if (dbSiteReqStructure.Quantity > dispatchedStrucCount) { dbSiteReqStructure.Status = Util.GetDescription(commonEnum.SiteRequiremntStatus.PARTIALLYDISPATCHED).ToString(); } else { dbSiteReqStructure.Status = Util.GetDescription(commonEnum.SiteRequiremntStatus.DISPATCHED).ToString(); } _context.SaveChanges(); /***update site requirement status ***/ List <SiteReqStructure> lstReqStructure = _context.SiteReqStructure.Where(x => x.SiteReqId == payload.siteRequirementId).ToList(); if (lstReqStructure.Count() > 0 && lstReqStructure.Where(x => x.Status != Util.GetDescription(commonEnum.SiteRequiremntStatus.DISPATCHED).ToString()).Count() > 0) { dbSiteReq.Status = Util.GetDescription(commonEnum.SiteRequiremntStatus.PARTIALLYDISPATCHED).ToString(); dbSiteReq.StatusInternal = Util.GetDescription(commonEnum.SiteRequiremntStatus.PARTIALLYDISPATCHED).ToString(); } else { dbSiteReq.Status = Util.GetDescription(commonEnum.SiteRequiremntStatus.DISPATCHED).ToString(); dbSiteReq.StatusInternal = Util.GetDescription(commonEnum.SiteRequiremntStatus.DISPATCHED).ToString(); } _context.SaveChanges(); DisreqStatusHistory dispatchReqStatusHistory = new DisreqStatusHistory(); dispatchReqStatusHistory.DispatchNo = dispatchNo; dispatchReqStatusHistory.DispreqId = dispReq.Id; dispatchReqStatusHistory.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString(); dispatchReqStatusHistory.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString(); dispatchReqStatusHistory.Notes = ""; dispatchReqStatusHistory.RoleId = payload.RoleId; dispatchReqStatusHistory.CreatedBy = payload.CreatedBy; dispatchReqStatusHistory.CreatedAt = DateTime.Now; _context.DisreqStatusHistory.Add(dispatchReqStatusHistory); _context.SaveChanges(); transaction.Commit(); responseMessage = new ResponseMessage() { Message = "Saved Successfully" }; } catch (Exception ex) { transaction.Rollback(); responseMessage = new ResponseMessage() { Message = "Error was found. Exception : " + ex.Message }; throw ex; } } return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage SiteDispatchRejection(SiteDispatchApproval dispAppr) { ResponseMessage res = new ResponseMessage(); string status = ""; string internalStatus = ""; ServiceType servType = _context.ServiceType.Where(x => x.Id == dispAppr.serviceTypeId).FirstOrDefault(); Roles roleDB = _context.Roles.Where(x => x.Name == dispAppr.roleName).FirstOrDefault(); DispatchRequirement dispReq = _context.DispatchRequirement.Where(x => x.Id == dispAppr.dispReqId).FirstOrDefault(); if (roleDB == null) { throw new ValueNotFoundException(String.Format("Rolename doesnt exists. {0}", dispAppr.roleName)); } if (dispReq == null) { throw new ValueNotFoundException(String.Format("Dispatch Id doesnt exists")); } if (servType.Name == commonEnum.ServiceType.Reuse.ToString()) { if (dispAppr.roleName == commonEnum.Rolename.SITE.ToString() && dispAppr.roleHierarchy == 3 && dispReq.StatusInternal == Util.GetDescription(commonEnum.SiteDispatchSatus.FAAAPPROVED).ToString()) { status = Util.GetDescription(commonEnum.SiteDispatchSatus.REJECT).ToString(); internalStatus = Util.GetDescription(Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED)).ToString(); } else if (dispAppr.roleName == commonEnum.Rolename.SITE.ToString() && dispAppr.roleHierarchy == 4) { status = Util.GetDescription(commonEnum.SiteDispatchSatus.REJECT).ToString(); internalStatus = Util.GetDescription(Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED)).ToString(); } else { throw new ValueNotFoundException(String.Format("Not allowed to approve for this role:{0}", dispAppr.roleName)); } } else { if (dispAppr.roleName == commonEnum.Rolename.SITE.ToString() && dispAppr.roleHierarchy == 3 && dispReq.StatusInternal == Util.GetDescription(commonEnum.SiteDispatchSatus.PROCAPPROVED).ToString()) { status = Util.GetDescription(commonEnum.SiteDispatchSatus.REJECT).ToString(); internalStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.NEW).ToString(); } else { throw new ValueNotFoundException(String.Format("Not allowed to approve for this role:{0}", dispAppr.roleName)); } } dispReq.Status = status; dispReq.StatusInternal = internalStatus; dispReq.RoleId = 1; //TODO dispReq.UpdatedAt = DateTime.Now; dispReq.UpdatedBy = 1; //TODO DisreqStatusHistory dispStatusHist = new DisreqStatusHistory(); dispStatusHist.DispatchNo = dispReq.DispatchNo; dispStatusHist.DispreqId = dispReq.Id; dispStatusHist.RoleId = dispAppr.roleId; dispStatusHist.Status = status; dispStatusHist.StatusInternal = internalStatus; dispStatusHist.CreatedAt = DateTime.Now; dispStatusHist.CreatedBy = 1; //TODO res.Message = String.Format(" site dispatch {0} Rejected Successfully.", dispReq.DispatchNo); return(res); }
public ResponseMessage UpdatestructureModify(List <DispReqStructureDto> structure) { try { ResponseMessage responseMessage = new ResponseMessage(); structure.ForEach(item => { DispReqStructure structid = _context.DispReqStructure.Single(w => w.ProjStructId == item.ProjStructId && w.DispreqId == item.DispreqId); DispatchRequirement disreq = _context.DispatchRequirement .Single(w => w.Id == item.DispatchRequirementId); if (structid != null && disreq != null) { if (disreq.Status != "NEW") { responseMessage.Message = "Invalid Status"; } else { if (item.IsModification) { structid.IsModification = item.IsModification; structid.DispStructStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString(); } else { structid.IsModification = item.IsModification; structid.DispStructStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); } responseMessage.Message = "Structure Modification status updated"; } } _context.DispReqStructure.Update(structid); _context.SaveChanges(); }); structure.ForEach(item => { DisreqStatusHistory disReqHis = new DisreqStatusHistory(); DispatchRequirement disreq = _context.DispatchRequirement .Single(w => w.Id == item.DispatchRequirementId); var totalCount = _context.DispReqStructure.Where(x => x.DispreqId == item.DispatchRequirementId).Count(); var appCount = _context.DispReqStructure.Where(x => x.DispreqId == item.DispatchRequirementId && x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString()).Count(); var delivCount = _context.DispReqStructure.Where(x => x.DispreqId == item.DispatchRequirementId && x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString()).Count(); if (totalCount != appCount) { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disreq.UpdatedBy = 1; //To DO disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disreq.UpdatedAt = DateTime.Now; disReqHis.DispatchNo = disreq.DispatchNo; disReqHis.RoleId = disreq.RoleId; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } else { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCAPPROVED).ToString(); disreq.UpdatedBy = 1; //To DO disreq.UpdatedAt = DateTime.Now; disReqHis.DispatchNo = disreq.DispatchNo; disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYAPPROVED).ToString(); disReqHis.RoleId = disreq.RoleId; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } if (totalCount == delivCount) { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); disreq.UpdatedBy = 1; //To DO disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); disreq.UpdatedAt = DateTime.Now; disReqHis.DispatchNo = disreq.DispatchNo; disReqHis.RoleId = disreq.RoleId; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } _context.DispatchRequirement.Update(disreq); _context.DisreqStatusHistory.Add(disReqHis); _context.SaveChanges(); }); return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage UpdateComponentHistory(DispComponentDto Component) { using (var transaction = _context.Database.BeginTransaction()) { try { ResponseMessage responseMessage = new ResponseMessage(); List <ComponentDetailsInput> result = new List <ComponentDetailsInput>(); int id = Component.DispStructureId; string strQuery = string.Format("select dsc.id DispstructCompId, dsc.disp_structure_id DispStructureId,c.id DispCompId from disp_structure_comp dsc inner join component c on dsc.disp_comp_id = c.id inner join disp_mod_stage_component dmsc on dmsc.dispstruct_comp_id =dsc.id inner join component_type ct on c.comp_type_id =ct.id where dsc.disp_structure_id ={0}", id); result = _context.Query <ComponentDetailsInput>().FromSqlRaw(strQuery).ToList(); List <DispStructureComp> dispStructureComp = _context.DispStructureComp.Where(w => w.DispStructureId == Component.DispStructureId).ToList(); result.ForEach(item => { Component compDetails = _context.Component.Single(w => w.Id == item.DispCompId); ComponentHistory AddItem = new ComponentHistory(); if (compDetails != null) { AddItem.Weight = compDetails.Weight; AddItem.Leng = compDetails.Leng; AddItem.Breath = compDetails.Breath; AddItem.Height = compDetails.Height; AddItem.Thickness = compDetails.Thickness; //AddItem.MakeType=compDetails.MakeType; AddItem.CreatedAt = DateTime.Now; AddItem.CreatedBy = 1; //To do AddItem.ProjStructId = compDetails.ProjStructId; AddItem.CompId = compDetails.CompId; AddItem.ProjStructId = compDetails.ProjStructId; AddItem.CompTypeId = compDetails.CompTypeId; } _context.ComponentHistory.Add(AddItem); _context.SaveChanges(); DispModStageComponent compModStageDetails = _context.DispModStageComponent.OrderByDescending(o => o.CreatedAt).FirstOrDefault(x => x.DispstructCompId == item.DispstructCompId); compDetails.Weight = compModStageDetails.Weight; compDetails.Leng = compModStageDetails.Leng; compDetails.Breath = compModStageDetails.Breath; compDetails.Height = compModStageDetails.Height; compDetails.Thickness = compModStageDetails.Thickness; compDetails.MakeType = compModStageDetails.MakeType; compDetails.ProjStructId = compDetails.ProjStructId; _context.Component.Update(compDetails); _context.SaveChanges(); }); DispReqStructure structid = _context.DispReqStructure.FirstOrDefault(w => w.ProjStructId == Component.ProjectStructureId && w.Id == Component.DispStructureId); if (Component.IsVendor) { if (structid != null) { { responseMessage = _dispatchReqSubConRepository.OSAssignVendor(Component.OSDispatchReqSubCont); } structid.DispStructStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString(); _context.DispReqStructure.Update(structid); _context.SaveChanges(); } } if (Component.IsSite) { DispReqStructure dispstructid = _context.DispReqStructure.SingleOrDefault(w => w.ProjStructId == Component.ProjectStructureId && w.Id == Component.DispStructureId); if (dispstructid != null) { dispstructid.DispStructStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString(); _context.DispReqStructure.Update(dispstructid); _context.SaveChanges(); } } DisreqStatusHistory disReqHis = new DisreqStatusHistory(); DispatchRequirement disreq = _context.DispatchRequirement .SingleOrDefault(w => w.Id == Component.DispatchRequirementId); var totalCount = _context.DispReqStructure.Where(x => x.DispreqId == Component.DispatchRequirementId).Count(); var appCount = _context.DispReqStructure.Where(x => x.DispreqId == Component.DispatchRequirementId && (x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString() || x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispatchSatus.READYTODELIVER).ToString())).Count(); // if(disreq!=null){ // throw new ValueNotFoundException ("DispatchRequirementId Not Available"); // } if (totalCount != appCount) { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCPARIALLYMODIFYAPRD).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCPARIALLYMODIFYAPRD).ToString(); disreq.UpdatedBy = 1; //To DO disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCPARIALLYMODIFYAPRD).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCPARIALLYMODIFYAPRD).ToString(); disreq.UpdatedAt = DateTime.Now; disReqHis.DispatchNo = disreq.DispatchNo; disReqHis.RoleId = disreq.RoleId; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } else { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString(); disreq.UpdatedBy = 1; //To DO disreq.UpdatedAt = DateTime.Now; disReqHis.DispatchNo = disreq.DispatchNo; disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.TWCCMODIFYAPRD).ToString(); disReqHis.RoleId = disreq.RoleId; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } _context.DispatchRequirement.Update(disreq); _context.DisreqStatusHistory.Add(disReqHis); _context.SaveChanges(); responseMessage.Message = "Component updated"; transaction.Commit(); return(responseMessage); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public ResponseMessage UpdateDispatchComponent(List <DispModStageComponentDto> Component) { try { ResponseMessage responseMessage = new ResponseMessage(); Component.ForEach(item => { DisreqStatusHistory disReqHis = new DisreqStatusHistory(); DispModStageComponent AddItem = new DispModStageComponent(); if (item != null) { AddItem.DispstructCompId = item.DispstructCompId; AddItem.Weight = item.Weight; AddItem.Leng = item.Leng; AddItem.Breath = item.Breath; AddItem.Height = item.Height; AddItem.Thickness = item.Thickness; AddItem.MakeType = item.MakeType; AddItem.Addplate = item.Addplate; AddItem.CreatedAt = DateTime.Now; } DispReqStructure structid = _context.DispReqStructure.Single(w => w.ProjStructId == item.ProjectStructureId && w.Id == item.DispStructureId); if (structid != null) { structid.DispStructStatus = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disReqHis.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disReqHis.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disReqHis.DispatchNo = item.DCNumber; disReqHis.CreatedBy = 1; //To DO disReqHis.CreatedAt = DateTime.Now; } _context.DispReqStructure.Update(structid); _context.DispModStageComponent.Add(AddItem); _context.DisreqStatusHistory.Add(disReqHis); _context.SaveChanges(); DispatchRequirement disreq = _context.DispatchRequirement .Single(w => w.Id == item.DispatchRequirementId); var totalCount = _context.DispReqStructure.Where(x => x.DispreqId == item.DispatchRequirementId).Count(); var appCount = _context.DispReqStructure.Where(x => x.DispreqId == item.DispatchRequirementId && x.DispStructStatus == Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString()).Count(); DisreqStatusHistory disReqHis1 = new DisreqStatusHistory(); if (totalCount != appCount) { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYMODIFIED).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYMODIFIED).ToString(); disreq.UpdatedBy = 1; //To DO disreq.UpdatedAt = DateTime.Now; disReqHis1.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYMODIFIED).ToString(); disReqHis1.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCPARTIALLYMODIFIED).ToString(); disReqHis1.DispatchNo = disreq.DispatchNo; disReqHis1.RoleId = disreq.RoleId; disReqHis1.CreatedBy = 1; //To DO disReqHis1.CreatedAt = DateTime.Now; } else { disreq.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disreq.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disreq.UpdatedBy = 1; //To DO disreq.UpdatedAt = DateTime.Now; disReqHis1.DispatchNo = item.DCNumber; disReqHis1.Status = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disReqHis1.StatusInternal = Util.GetDescription(commonEnum.SiteDispatchSatus.CMPCMODIFIED).ToString(); disReqHis1.RoleId = disreq.RoleId; disReqHis1.CreatedBy = 1; //To DO disReqHis1.CreatedAt = DateTime.Now; disReqHis1.DispreqId = item.DispatchRequirementId; } _context.DispatchRequirement.Update(disreq); _context.DisreqStatusHistory.Add(disReqHis1); _context.SaveChanges(); responseMessage.Message = "Component updated"; }); return(responseMessage); } catch (Exception ex) { throw ex; } }