public tBoxTicketTemplate CreateBoxTicketTemplate(long boxTicketId, string bound)
{
var boxTicketTemplate = new tBoxTicketTemplate();
boxTicketTemplate.BoxTicketID = boxTicketId;
if (bound.ToLower() == "inbound")
{
boxTicketTemplate.TemplateID = 1;
}
else
{
boxTicketTemplate.TemplateID = 2;
}
_context.tBoxTicketTemplate.Add(boxTicketTemplate);
_context.SaveChanges();
return(boxTicketTemplate);
}
public tBoxTicketTemplate CreateBoxTicketTemplate(long boxTicketId, string bound)
{
var boxTicketTemplate = _context.tBoxTicketTemplate.Where(t => t.BoxTicketID == boxTicketId).FirstOrDefault();
if (boxTicketTemplate == null)
{
boxTicketTemplate = new tBoxTicketTemplate();
boxTicketTemplate.BoxTicketID = boxTicketId;
if (bound.ToLower() == "inbound")
{
boxTicketTemplate.TemplateID = 1;
}
else
{
boxTicketTemplate.TemplateID = 2;
}
_context.tBoxTicketTemplate.Add(boxTicketTemplate);
_context.SaveChanges();
}
return(boxTicketTemplate);
}
public tPDFGenerationTasksPackingTicket AddPdfGenerationTaskForBoxTicketTemplate(tBoxTicketTemplate boxTicketTemplate)
{
bool overwriteExisting = true;
var efTask = (from t in _context.tPDFGenerationTasksPackingTicket where t.PDFGenerationJobID == 1 && t.BoxTicketID == boxTicketTemplate.BoxTicketID && t.PackingTemplateID == boxTicketTemplate.TemplateID select t).FirstOrDefault();
if (efTask == null || overwriteExisting)
{
if (overwriteExisting && efTask != null)
{
_context.tPDFGenerationTasksPackingTicket.Remove(efTask);
}
efTask = new tPDFGenerationTasksPackingTicket
{
PDFGenerationJobID = 1,
BoxTicketID = boxTicketTemplate.BoxTicketID,
PackingTemplateID = boxTicketTemplate.TemplateID,
Status = "Ready",
ChiliDocumentID = boxTicketTemplate.ChiliDocumentID,
ChiliError = null,
ChiliPDFURL = null,
ChiliTaskID = null
};
_context.tPDFGenerationTasksPackingTicket.Add(efTask);
_context.SaveChanges();
}
return(efTask);
}
