public void Execute(NotificationSchedulerVO vo) { sd = new SAPDAO("US"); try { var currentList = sd.GetAccountForRenewalData(MonthPeroid.CURRENT_MONTH); var currentFileHelper = new FileHelper <AccountForRenewalVO>(); var currentStageFileInfo = currentFileHelper.CreateCvsFileAtStage(currentList, FILE_SHOT_NAME_CURRENT_MONTH); var lastList = sd.GetAccountForRenewalData(MonthPeroid.LAST_MONTH); var lastFileHelper = new FileHelper <AccountForRenewalVO>(); var lastStageFileInfo = currentFileHelper.CreateCvsFileAtStage(lastList, FILE_SHOT_NAME_LAST_MONTH); var nextList = sd.GetAccountForRenewalData(MonthPeroid.NEXT_MONTH); var nextFileHelper = new FileHelper <AccountForRenewalVO>(); var nextStageFileInfo = currentFileHelper.CreateCvsFileAtStage(nextList, FILE_SHOT_NAME_NEXT_MONTH); var fileList = new List <CreatedFileInfoVO> { currentStageFileInfo, lastStageFileInfo, nextStageFileInfo }; MailHelper.Sendmail(vo, fileList); currentFileHelper.moveCompleteDirectory(currentStageFileInfo); currentFileHelper.moveCompleteDirectory(lastStageFileInfo); currentFileHelper.moveCompleteDirectory(nextStageFileInfo); } catch (Exception e) { log.Error(e); MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } finally { sd.closeConnection(); }; }
public void Execute(NotificationSchedulerVO vo) { try { if (ShipConfirmEmailUS == "Y") { sdUS = new SAPDAO("US"); var shipmentInfoList_US = sdUS.GetShipmentInfoData(); shipmentInfoList_US.ForEach(x => { MailHelper.SendShipEmailToCustomer(x); sdUS.UpdateIsShipped(x.DocEntry); }); } if (ShipConfirmEmailCA == "Y") { sdCA = new SAPDAO("CA"); var shipmentInfoList_CA = sdCA.GetShipmentInfoData(); shipmentInfoList_CA.ForEach(x => { MailHelper.SendShipEmailToCustomer(x); sdCA.UpdateIsShipped(x.DocEntry); }); } } catch (Exception e) { log.Error(e); MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } finally { sdUS.closeConnection(); sdCA.closeConnection(); }; }
public void Execute(NotificationSchedulerVO vo) { sd = new SAPDAO("CA"); try { var list = sd.GetValidToShipData(); var fileHelper = new FileHelper <ValidToShipVO>(); var stageFileInfo = fileHelper.CreateCvsFileAtStage(list, FILE_SHOT_NAME); MailHelper.Sendmail(vo, stageFileInfo); fileHelper.moveCompleteDirectory(stageFileInfo); } catch (Exception e) { log.Error(e); MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } finally { sd.closeConnection(); }; }
public void Execute(NotificationSchedulerVO vo) { sd = new SAPDAO("CA"); try { var list = sd.getTestNoti(); var fileHelper = new FileHelper <TestNotiVO>(); var stageFileInfo = fileHelper.CreateCvsFileAtStage(list, FILE_SHOT_NAME); MailHelper.Sendmail(vo, stageFileInfo); //MailHelper.SendmailAdmin("test", "test", MailHelper.SERVERTYPE_INTERNAL, Path.Combine(stageFileInfo.path, stageFileInfo.fileName)); fileHelper.moveCompleteDirectory(stageFileInfo); } catch (Exception e) { log.Error(e); MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } finally { sd.closeConnection(); }; }
public List <NotificationSchedulerVO> GetValidTaskQueue() { sdUP = new SAPDAO("UP"); var resultQueue = new List <NotificationSchedulerVO>(); try { var list = sdUP.getScheduler(); list.ForEach(x => { Console.WriteLine("=========="); Console.WriteLine("Id ->" + x.Id + " "); Console.WriteLine("Department ->" + x.Department + " "); Console.WriteLine("Cycle ->" + x.Cycle + " "); Console.WriteLine("CycleDate ->" + x.CycleDate + " "); Console.WriteLine("CycleDay ->" + x.CycleDay + " "); Console.WriteLine("CycleTime ->" + x.CycleTime + " "); Console.WriteLine("EmailServer ->" + x.EmailServer + " "); Console.WriteLine("EmailTitle ->" + x.EmailTitle + " "); Console.WriteLine("EmailContent ->" + x.EmailContent + " "); Console.WriteLine("ReceiverEmail ->" + x.ReceiverEmail + " "); Console.WriteLine("SenderName ->" + x.SenderName + " "); Console.WriteLine("SenderEmail ->" + x.SenderEmail + " "); Console.WriteLine("CcEmail ->" + x.CcEmail + " "); Console.WriteLine("BccEmail ->" + x.BccEmail + " "); Console.WriteLine("ProgramClass ->" + x.ProgramClass + " "); Console.WriteLine("FisrtRunDate ->" + x.FirstRunDate + " "); Console.WriteLine("LastRunDate ->" + x.LastRunDate + " "); Console.WriteLine("CreateDate ->" + x.CreateDate + " "); Console.WriteLine("ModifiedDate ->" + x.ModifiedDate + " "); Console.WriteLine("=========="); if (x.Active == 1) { try { switch (x.Cycle) { case CYCLE.ANY: { Console.WriteLine("INSERT QUEUE ============"); resultQueue.Add(x); if (x.LastRunDate == new DateTime(1900, 01, 01)) // if first run { sdUP.UpdateFirstRunDate(x.Id, DateTime.Now); sdUP.UpdateLastRunDate(x.Id, DateTime.Now); } else { sdUP.UpdateLastRunDate(x.Id, DateTime.Now); } break; } case CYCLE.HOURLY: { Console.WriteLine("HOURLY ============"); if (TimeValidationAndInsert(x, CYCLE.HOURLY)) { resultQueue.Add(x); } break; } case CYCLE.DAILY: { Console.WriteLine("DAILY ============"); if (TimeValidationAndInsert(x, CYCLE.DAILY)) { resultQueue.Add(x); } break; } case CYCLE.WEEKLY: { if (x.CycleDay == TODAY.DAYOFWEEK) { Console.WriteLine("WEEKLY PASS ============"); if (TimeValidationAndInsert(x, CYCLE.WEEKLY)) { resultQueue.Add(x); } } else { Console.WriteLine("WEEKLY NOT PASS ============"); } break; } case CYCLE.MONTHLY: { if (TODAY.DATE == x.CycleDate) { Console.WriteLine("MONTHLY PASS ============"); if (TimeValidationAndInsert(x, CYCLE.MONTHLY)) { resultQueue.Add(x); } } else { Console.WriteLine("MONTHLY NOT PASS ============"); } break; } } } catch (Exception e) { MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } } else { Console.WriteLine("NOT ACTIVE ============"); } }); } catch (Exception e) { log.Error(e); MailHelper.AddSystemIssueString(GetType().Name, e.ToString()); } finally { sdUP.closeConnection(); }; return(resultQueue); }