private static string getFilerCode(string filerCode)
{
string returnedFilerCode = "Unknown";
try
{
cbpmqdbEntities1 db = new cbpmqdbEntities1();
var q = from p in db.FilerCodes where p.FilerCode1 == filerCode select p;
return(q.First().FilerName);
}
catch (Exception)
{
return(returnedFilerCode);
}
}
private static string getPortName(string portCode)
{
string returnedPortName = "Unknown";
try
{
cbpmqdbEntities1 db = new cbpmqdbEntities1();
decimal portCodeID = decimal.Parse(portCode);
var q = from p in db.PortCodes where p.PortCodeId == portCodeID select p;
return(q.First().Name);
}
catch (Exception)
{
return(returnedPortName);
}
}
private static string getEntryType(string entryType)
{
string returnedEntryType = "Unknown";
try
{
int entryTypeID = int.Parse(entryType);
cbpmqdbEntities1 db = new cbpmqdbEntities1();
var q = from p in db.EntryTypes where p.EntryTypeId == entryTypeID select p;
return(q.First().Name.Replace(')', ' '));
}
catch (Exception)
{
return(returnedEntryType);
}
}
private static string getBondType(string bondType)
{
string returnedBondType = "Unknown";
try
{
int bondTypeID = int.Parse(bondType);
cbpmqdbEntities1 db = new cbpmqdbEntities1();
var q = from p in db.BondTypes where p.BondTypeId == bondTypeID select p;
return(q.First().Name);
}
catch (Exception)
{
return(returnedBondType);
}
}
static void Main(string[] args)
{
try
{
config();
DateTime dateFrom = DateTime.Now.AddDays(numDays * -1);
cbpmqdbEntities1 db = new cbpmqdbEntities1();
//Find AS records with an entry type of 3
var asr = from p in db.AS_Record.AsNoTracking() where p.file_date >= dateFrom &&
p.entry_type == 3
//&& p.importer_of_record=="59-266395400"
select p;
//if (singleBondToCheck != "")
//{
// q = (from p in db.vType3EntriesWithBO
// where p.file_date >= dateFrom && p.entry_type == 3
// && p.bond_number.Contains(singleBondToCheck)
// select p).Take(1);
//}
logger.Info("Found " + asr.Count() + " AS Records");
//for(int aC=0;aC<asr.Count();aC++)
foreach (AS_Record asRecord in asr.ToList())
{
// AS_Record asRecord = asr.
//get the bond record for this
var bor = from p in db.BO_Record.AsNoTracking() where p.bond_number == asRecord.bond_number orderby p.file_date descending select p;
BO_Record boRecord = bor.First();
logger.Info("Processing Bond Number " + asRecord.bond_number +
", Entry Number " + asRecord.entry_number1 +
", Entry Date " + asRecord.entry_date + ", Effective Date " +
boRecord.bond_effective_date + ", Importer " +
asRecord.importer_of_record + " " + boRecord.importer_name + ", File date " + asRecord.file_date.ToShortDateString());
//See if there's already an email sent for it
var e = from p in db.ASAQEmails.AsNoTracking()
where
p.BondNumber == asRecord.bond_number &&
p.EntryDate == asRecord.entry_date &&
p.EffectiveDate == boRecord.bond_effective_date &&
p.Importer == asRecord.importer_of_record &&
p.EntryNumber == asRecord.entry_number1 &&
(p.FileDate == asRecord.file_date || p.FileDate == null)
select p;
if (e.Count() > 0)
{
logger.Info("Email for Bond Number " + asRecord.bond_number +
", Entry Date " + asRecord.entry_date + ", Effective Date " +
", Entry Number " + asRecord.entry_number1 +
boRecord.bond_effective_date + ", Importer " +
asRecord.importer_of_record + ", File date " + asRecord.file_date.ToShortDateString() + " already sent.");
continue;
}
//Create and send email
logger.Info("Email for Bond Number " + asRecord.bond_number +
", Entry Date " + asRecord.entry_date + ", Effective Date " +
", Entry Number " + asRecord.entry_number1 +
boRecord.bond_effective_date + ", Importer " +
asRecord.importer_of_record + ", File date " +
asRecord.file_date.ToShortDateString() + " has NOT BEEN sent.");
//logger.Info("Sendmail has been commented out!");
Thread.Sleep(3000);
sendMail(asRecord, boRecord, simulateOnly);
if (!simulateOnly)
{
//Add "mail sent" record for this AS record
ASAQEmail asaq = new ASAQEmail();
asaq.BondNumber = asRecord.bond_number;
asaq.EntryDate = asRecord.entry_date;
asaq.EffectiveDate = boRecord.bond_effective_date;
asaq.Importer = asRecord.importer_of_record;
asaq.EmailSentDate = DateTime.Now;
asaq.EntryNumber = asRecord.entry_number1;
asaq.FileDate = asRecord.file_date;
asaq.SentTo = toEmails;
db.ASAQEmails.Add(asaq);
db.SaveChanges();
}
}
}
catch (Exception e)
{
logger.Error(e.Message);
return;
}
}
