public void UpdateStatus(WareHouseJPDB db)
{
//ExportGood
var lstEX = db.ExportGoods;
foreach (var item in lstEX)
{
if (db.ExportInvoices.Where(n => n.ExportId == item.Id).Count() > 0)
{
item.StatusId = 5;
}
}
//update StorageJP Status
var lstSJP = db.StorageJPs;
foreach (var item in lstSJP)
{
//check ListIn
int statusId = 2;
if (db.TrackingDetails.ToList().Where(n => n.TrackingSubCode.Substring(0, n.TrackingSubCode.LastIndexOf(" -")).Contains(item.TrackingCode)).Count() > 0)
{
statusId = 3;
}
if (db.ExportGoodDetails.Where(n => n.TrackingCode.Contains(item.TrackingCode)).Count() > 0)
{
statusId = 4;
}
if (db.ExportGoodDetails.Where(n => n.TrackingCode.Contains(item.TrackingCode) && db.ExportInvoices.Where(m => m.ExportGood.Id == n.ExportGoodId).Count() > 0).Count() > 0)
{
statusId = 5;
}
item.StatusId = statusId;
}
//update AgencyPackage
var lstAP = db.AgencyPackages;
foreach (var item in lstAP)
{
if (lstSJP.Where(n => n.TrackingCode.Contains(item.TrackingCode)).Count() > 0)
{
item.TrackingStatusId = lstSJP.Where(n => n.TrackingCode.Contains(item.TrackingCode.Trim())).First().StatusId;
}
}
db.SaveChanges();
db.Dispose();
}
public void Execute(IJobExecutionContext context)
{
try
{
Thread tSendMails;
tSendMails = new System.Threading.Thread(delegate()
{
//get list booking need alert email
WareHouseJPDB db = new WareHouseJPDB();
foreach (var item in db.ExportGoods.Where(n => n.AirId == null))
{
string html = "Body send email";
GMail.Send(item.Agency.Email, "[V/v] Yêu cầu booking " + DateTime.Now.ToString("dd.MM.yyyy"), html);
}
});
tSendMails.IsBackground = true;
tSendMails.Priority = ThreadPriority.Highest;
tSendMails.Start();
}
catch { }
}
