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 AddComponentsDisaptch(DispatchAddComponents request)
{
ResponseMessage response = new ResponseMessage();
response.Message = "Components added succusfully";
// if (request?.ProjectStructureDetail == null)
// throw new ValueNotFoundException ("ProjectStructureDetail Request cannot be empty.");
ProjectStructure projectStructure = _context.ProjectStructure.Where(x => x.Id == _context.DispReqStructure.Where(x => x.Id == request.DispStructureId).FirstOrDefault().ProjStructId&& x.IsDelete == false).FirstOrDefault();
List <dispatchedStrucCount> result = new List <dispatchedStrucCount>();
int count = _context.Component.Where(s => s.ProjStructId == projectStructure.Id).Count();
int Quantity = request.Components.Where(x => x.CompId == null).Count();
int excedCout = count + Quantity;
// int totalcount =_context.ProjectStructure.Single(s =>s.Id==projectStructure.Id).ComponentsCount??0;
if (projectStructure.ComponentsCount < excedCout)
{
throw new ValueNotFoundException("Dispatch Components should match the required quantity.");
}
try {
// using (var transaction = _context.Database.BeginTransaction ())
{
try {
var isUpdate = false;
var projectStructureID = 0;
projectStructure = _context.ProjectStructure.Where(x => x.Id == _context.DispReqStructure.Where(x => x.Id == request.DispStructureId).FirstOrDefault().ProjStructId&& x.IsDelete == false).FirstOrDefault();
if (projectStructure == null)
{
throw new ValueNotFoundException("Project Structure not yet assigned");
}
projectStructureID = projectStructure.Id;
if (request.Components?.Count > 0)
{
List <Component> componentls = new List <Component> ();
List <ComponentHistory> componentHistls = new List <ComponentHistory> ();
foreach (var comp in request.Components)
{
ComponentType compTypeDB = _context.ComponentType.Where(x => x.Name == comp.CompTypeName && x.IsDelete == false).FirstOrDefault();
if (compTypeDB == null)
{
throw new ValueNotFoundException("Component Type Name doesn't exist");
}
}
foreach (var comp in request.Components)
{
var compdb = _context.Component.Where(x => x.CompId == comp.CompId && x.IsDelete == false).FirstOrDefault();
ComponentType compTypeDB = _context.ComponentType.Where(x => x.Name == comp.CompTypeName && x.IsDelete == false).FirstOrDefault();
if (compTypeDB == null)
{
throw new ValueNotFoundException("Component Type Name doesn't exist");
}
if (compdb != null)
{
var dispCompDB = _context.DispStructureComp.Where(x => x.DispCompId == compdb.Id && x.DispStructureId == request.DispStructureId).FirstOrDefault();
if (dispCompDB != null)
{
compdb = ConstructComponent(projectStructureID, comp, compdb, compTypeDB);
// DispStructureComp dsc = new DispStructureComp();
// dsc.DispCompId = compdb.Id;
// dsc.DispStructureId = request.DispStructureId;
// // _context.Add(compdb);
// _context.Add(dsc);
_context.SaveChanges();
}
else
{
throw new ValueNotFoundException("Dispatch Component ID doesnt exists");
}
}
else
{
Component component = null;
comp.CompStatus = "O";
component = ConstructComponent(projectStructureID, comp, component, compTypeDB);
_context.Component.Add(component);
_context.SaveChanges();
DispStructureComp dsc = new DispStructureComp();
dsc.DispCompId = component.Id;
dsc.DispStructureId = request.DispStructureId;
_context.DispStructureComp.Add(dsc);
_context.SaveChanges();
}
}
// projectStructure.ComponentsCount = request.Components.Count ();
// _context.SaveChanges ();
}
return(response);
} catch (Exception ex) {
// transaction.Rollback ();
throw ex;
}
}
} catch (Exception ex) {
throw ex;
}
}
