internal static void SendPODMail()
{
try
{
var setting = new ReportSettingRepository().GetAllReportSettings().Where(p => p.PODScheduleSetting == FrayteCustomerMailSetting.Scheduled && p.ScheduleSettingType == FrayteCustomerMailSetting.POD).ToList();
if (setting.Count > 0)
{
foreach (FryateReportSetting report in setting)
{
//Get server date in utc standard
DateTime serverdate = UtilityRepository.ConvertDateTimetoUniversalTime(DateTime.Now).Date;
//Get server time in HH:mm format
TimeSpan servertime = TimeSpan.Parse(DateTime.Now.ToString("HH:mm"));
DateTime scheduledate = new DateTime(report.ScheduleDate.Year, report.ScheduleDate.Month, report.ScheduleDate.Day);
if (report.ScheduleTime <= servertime)
{
if (report.UpdatedOn == null || report.UpdatedOn.Value.Date < DateTime.Now.Date)
{
UpdateDirectShipmentPOD(report.UserId);
//Update Customer Setting UpdateOn information
new ReportSettingRepository().UpdateCustomerSettingInformation(report.CustomerPODSettingId, report.UserId);
}
}
}
}
}
catch (Exception ex)
{
Logger _log = Get_Log();
_log.Info("Error due to send customer pod information mail");
_log.Error(ex.Message);
}
}
public ReportLogoControl()
{
InitializeComponent();
_db = new AppContext();
_settingRepository = new ReportSettingRepository(_db);
}
public GenerateReportStatusForm(Controls.GranulometryControl granulometryControl, List<CorrelationMatrix> correlationMatrixList, Controls.KrigingSelectionControl krigingSelectionControl)
{
_granulometryControl = granulometryControl;
_correlationMatrixList = correlationMatrixList;
_krigingSelectionControl = krigingSelectionControl;
InitializeComponent();
_db = new AppContext();
_reportSettingRepository = new ReportSettingRepository(_db);
}
private string GeneratePDF_ShipmentReportDetail(int OperationZoneId)
{
string pageStyleSheet = HttpContext.Current.Server.MapPath("~/Content/") + "confirm.css";
string bootStrapStyleSheet = HttpContext.Current.Server.MapPath("~/Content/") + "bootstrap.css";
string pdfLogo = HttpContext.Current.Server.MapPath("~/Content/") + "FrayteLogo.png";
var detail = new ReportSettingRepository().GetShipmentId(OperationZoneId);
FrayteShipmentReportPDF obj = new FrayteShipmentReportPDF();
obj.ShipmentReportDetail = new List <FrayteShipmentReport>();
obj.ShipmentReportDetail = detail;
obj.PageStyleSheet = pageStyleSheet;
obj.BootStrapStyleSheet = bootStrapStyleSheet;
obj.pdfLogo = pdfLogo;
string template = File.ReadAllText(HttpContext.Current.Server.MapPath("~/Templates/") + "ReportPdf.cshtml");
var EmailBody = Engine.Razor.RunCompile(template, "ShipmentReportPDF", null, obj);
string pdfFileName = "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".html";
string pdfFilePath = HttpContext.Current.Server.MapPath("~/UploadFiles/PDFGenerator/HTMLFile");
string pdfFullPath = pdfFilePath + @"\" + pdfFileName;
using (FileStream fs = new FileStream(pdfFullPath, FileMode.Create))
{
using (StreamWriter w = new StreamWriter(fs, System.Text.Encoding.UTF8))
{
w.WriteLine(EmailBody);
}
}
List <string> lstHtmlFiles = new List <string>();
lstHtmlFiles.Add(pdfFullPath);
//Before creating new PDF file, remove the earlier one.
filename = "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".PDF";
string pdfPath = HttpContext.Current.Server.MapPath("~/UploadFiles/PDFGenerator/") + "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".PDF";
if (File.Exists(pdfPath))
{
File.Delete(pdfPath);
}
string pdfFile = PDFGenerator.HtmlToPdf("~/UploadFiles/PDFGenerator", "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss"), lstHtmlFiles.ToArray(), null);
if (System.IO.File.Exists(pdfFullPath))
{
System.IO.File.Delete(pdfFullPath);
}
return(pdfFile);
}
public static void SendRateCardEmail()
{
try
{
var setting = new ReportSettingRepository().GetAllReportSettings().Where(p => p.ScheduleSettingType == FrayteCustomerMailSetting.RateCard && p.IsPdf == true || p.IsExcel == true).ToList();
foreach (var status in setting)
{
if (status.ScheduleSettingType == FrayteCustomerMailSetting.RateCard)
{
if (status.fryateUserDetail.Count > 0)
{
if (status.CustomerPODSettingId > 0)
{
TimeSpan ts = TimeSpan.Parse(AppSettings.RateCard);
Time = DateTime.Now.TimeOfDay;
current = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.Now.ToString("MM/dd/yyyy"));
Logger _log = Get_Log();
_log.Info(setting.Count.ToString() + "\n " + status.UserId + " " + status.ScheduleSettingType + "\n" + status.fryateUserDetail.Count.ToString() + "\n" + ts + " " + Time + " " + current);
switch (status.PODScheduleSetting)
{
//Check PODScheduleSetting is Scheduled
case FrayteReportSettingDays.Scheduled:
switch (status.ScheduleType)
{
case FrayteReportSettingDays.Daily:
if (status.UpdatedOn != null)
{
Lastdate = Frayte.Services.CommonConversion.ConvertToDateTime(status.UpdatedOn.Value.AddDays(1).ToString("MM/dd/yyyy"));
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
else if (current.Date > status.CreatedOn.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingTime_Date(status.CustomerPODSettingId, current.AddDays(1), ts);
}
}
else if (current.Date > Lastdate.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
}
break;
case FrayteReportSettingDays.Weekly:
if (status.UpdatedOn != null)
{
Lastdate = Frayte.Services.CommonConversion.ConvertToDateTime(status.UpdatedOn.Value.AddDays(7).ToString("MM/dd/yyyy"));
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
else if (current.Date > status.CreatedOn.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingTime_Date(status.CustomerPODSettingId, current.AddDays(7), ts);
}
}
else if (current.Date > status.CreatedOn.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
}
break;
case FrayteReportSettingDays.Monthly:
if (status.UpdatedOn != null)
{
Lastdate = Frayte.Services.CommonConversion.ConvertToDateTime(status.UpdatedOn.Value.AddMonths(1).ToString("MM/dd/yyyyy"));
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
else if (current.Date > status.CreatedOn.Date && Time == status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingTime_Date(status.CustomerPODSettingId, current.AddDays(1), ts);
}
}
else if (current.Date > status.CreatedOn.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
}
break;
case FrayteReportSettingDays.Yearly:
if (status.UpdatedOn != null)
{
Lastdate = Frayte.Services.CommonConversion.ConvertToDateTime(status.UpdatedOn.Value.AddYears(1).ToString("MM/dd/yyyy"));
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (current.Date == Lastdate.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
else if (current.Date > status.CreatedOn.Date && Time == status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingTime_Date(status.CustomerPODSettingId, current.AddDays(1), ts);
}
}
else if (current.Date > status.CreatedOn.Date && Time >= status.ScheduleTime)
{
if (status.IsPdf == true && status.IsExcel == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsExcel == true)
{
SendExcelRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
else if (status.IsPdf == true)
{
SendPdfRateCardMail(status.fryateUserSettingDetail, status.UserId, status.fryateUserDetail[0].UserName, status.fryateUserDetail[0].OperationZoneId);
}
new ReportSettingRepository().UpdateReportSettingDate(status.CustomerPODSettingId, (current.Date > Lastdate ? current.Date : Lastdate));
}
}
break;
default:
break;
}
break;
default:
break;
}
}
}
}
}
}
catch (Exception e)
{
Logger _log = Get_Log();
_log.Info("Error due to send customer rate card pdf and excel");
_log.Error(e.Message);
}
}
public static void SendFuelSurchargeAndCurrencyEmail()
{
try
{
TimeSpan ts = TimeSpan.Parse(AppSettings.FuelSurCharge);
TimeSpan ts1 = TimeSpan.Parse(AppSettings.CustomerCurrency);
Time = TimeSpan.Parse(DateTime.Now.ToString("HH:mm"));
current = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.UtcNow.ToString("MM/dd/yyyy"));
DateTime comparedate = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.UtcNow.Month + "/23/" + DateTime.UtcNow.Year);
for (int i = 1; i < 3; i++)
{
FrayteStatus mailstatus = new FuelSurChargeRepository().GetSendMailStatus(DateTime.UtcNow, i);
var setting = new ReportSettingRepository().GetAllUserDetail();
if (setting != null)
{
foreach (var status in setting)
{
if (status.IsFuelSurCharge == true)
{
if (Time >= ts && comparedate == current)
{
if (mailstatus.FuelMailSentOn != current)
{
if (i == 1)
{
FrayteStatus updatestatus = new FuelSurChargeRepository().UpdateStatus(DateTime.UtcNow, i);
if (updatestatus.IsFuelSurCharge == false)
{
new ReportSettingRepository().FuelSurChargeSendEmail(status.Email, Frayte.Schedular.Utility.AppSettings.HKEmail, status.UserName, "", i);
}
}
else if (i == 2)
{
FrayteStatus updatestatus = new FuelSurChargeRepository().UpdateStatus(DateTime.UtcNow, i);
if (updatestatus.IsFuelSurCharge == false)
{
new ReportSettingRepository().FuelSurChargeSendEmail(status.Email, Frayte.Schedular.Utility.AppSettings.UKEmail, status.UserName, "", i);
}
}
}
}
}
}
}
}
for (int j = 1; j < 3; j++)
{
FrayteStatus mailstatus = new ExchangeRateRepository().GetSendMailStatus(j);
var setting = new ReportSettingRepository().GetAllUserDetail();
if (setting != null)
{
foreach (var status in setting)
{
if (status.IsCurrecy == true)
{
if (Time >= ts1)
{
if (j == 1)
{
if (mailstatus.CurrencyMailSentOn != current)
{
new ReportSettingRepository().ExchangeRateSendEmail(status.Email, "", status.UserName, "", j);
}
}
else if (j == 2)
{
if (mailstatus.CurrencyMailSentOn != current)
{
new ReportSettingRepository().ExchangeRateSendEmail(status.Email, "", status.UserName, "", j);
}
}
}
}
}
}
}
}
catch (Exception ex)
{
Logger _log = Get_Log();
_log.Info("Error due to fuel sur charge and exchange rate");
_log.Error(ex);
}
}
