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; } }