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