public IHttpActionResult BGAutoReminderForVendor()
{
YSCMEntities db = new YSCMEntities();
VSCMEntities vscm = new VSCMEntities();
var bgList = db.BankGuarantees.Where(li => li.BGExpiryDate != null && (li.BGStatus == "Verified" || li.BGStatus == "Expired")).ToList();
foreach (var item in bgList)
{
//if bg expiry date- one month == current date && bg expiry date & warranty Expirydate difference should be greater than 6 months
DateTime bgExpiryDate = Convert.ToDateTime(item.BGExpiryDate);
DateTime WarrantyExpiryDate = Convert.ToDateTime(item.WarrantyExpiryDate);
var autoDate = bgExpiryDate.AddMonths(-1).ToShortDateString();
var currentDate = DateTime.Now.ToShortDateString();
var months = (WarrantyExpiryDate.Month - bgExpiryDate.Month) + 12 * (WarrantyExpiryDate.Year - bgExpiryDate.Year);
if (autoDate == currentDate && months > 1)
{
if (item.BGId != null)
{
var RemoteBankGuarantee = vscm.RemoteBankGuarantees.Where(li => li.BGId == item.BGId).FirstOrDefault();
RemoteBankGuarantee.IsBGRevised = false;
vscm.SaveChanges();
}
//local
var LocalBG = db.BankGuarantees.Where(li => li.BGId == item.BGId).FirstOrDefault();
if (LocalBG != null)
{
LocalBG.IsBGRevised = false;
db.SaveChanges();
}
var Remarks = "Your BG is Expiring Soon, Please Re submit the revised BG for BG No: " + item.BGNo + "; PO No:" + item.PONo + " ";
this.emailTemplateDA.sendBGInitiationmail(item.BGId, item.CreatedBy, Remarks, "ReSubmit");
}
//BG Expired when vendor not submit documents
int cmp = bgExpiryDate.AddDays(1).CompareTo(DateTime.Now); // if cmp value < 0 means bgexpiry date is less than current date, current date is greater means bgExpiryDate is comes after current date
if (item.IsBGRevised == false && cmp < 0 && item.BGStatus != "Expired")
{
//update BG status track status track
BGStatusTrack bgst = new BGStatusTrack();
bgst.BGId = item.BGId;
bgst.Status = "Expired";
bgst.UpdatedBy = item.CreatedBy;
this._mprBusenessAcess.updateBGStatus(bgst);
}
if (WarrantyExpiryDate.ToShortDateString() == currentDate && item.BGStatus != "Closed")
{
//update BG status track status track
BGStatusTrack bgst = new BGStatusTrack();
bgst.BGId = item.BGId;
bgst.Status = "Closed";
bgst.UpdatedBy = item.CreatedBy;
this._mprBusenessAcess.updateBGStatus(bgst);
}
}
return(Ok(true));
}
public BankGuarantee updateBGStatus(BGStatusTrack bgsttrack)
{
return(this._mprDataAcess.updateBGStatus(bgsttrack));
}
public IHttpActionResult updateBGStatus(BGStatusTrack bgsttrack)
{
return(Ok(this._mprBusenessAcess.updateBGStatus(bgsttrack)));
}
