public FrayteResult SendLabelEmail(ExpressEmailModel emailModel) { FrayteResult result = new FrayteResult(); emailModel.ImageHeader = "FrayteLogo"; try { var operationzone = UtilityRepository.GetOperationZone(); var result1 = (from s in dbContext.Expresses join Usr in dbContext.Users on s.CustomerId equals Usr.UserId join Rl in dbContext.UserRoles on Usr.UserId equals Rl.UserId join UA in dbContext.UserAdditionals on Usr.UserId equals UA.UserId join OU in dbContext.Users on UA.OperationUserId equals OU.UserId join OUA in dbContext.UserAdditionals on OU.UserId equals OUA.UserId where Usr.UserId == emailModel.ShipmentDetail.CustomerId select new { UserName = OU.ContactName, Name = Usr.ContactName, UserEmail = OU.Email, UserPosition = OU.Position, CutomerCompany = Usr.CompanyName }).FirstOrDefault(); var detail = dbContext.CustomerCompanyDetails.Where(p => p.UserId == emailModel.ShipmentDetail.CustomerId).FirstOrDefault(); if (detail != null) { emailModel.StaffUserEmail = detail.OperationStaffEmail; emailModel.UserPosition = detail.UserPosition; emailModel.StaffUserName = detail.OperationStaff; emailModel.CompanyName = detail.CompanyName; emailModel.UserPhone = detail.OperationStaffPhone; emailModel.SiteAddress = detail.SiteAddress; emailModel.TrackingWebsite = detail.TrackingUrl + "/#/tracking/" + emailModel.ShipmentDetail.AWBNumber.Replace(" ", ""); emailModel.TrackingURL = detail.TrackingUrl + "/#/tracking/" + emailModel.ShipmentDetail.TrackingNumber.Replace("Order_", ""); } else { emailModel.UserEmail = result1.UserEmail; emailModel.UserName = result1.UserName; emailModel.UserPosition = result1.UserPosition; emailModel.SiteCompany = "FRAYTE GLOBAL"; emailModel.UserPhone = UtilityRepository.GetOperationZone().OperationZoneId == 1 ? "(+852) 2148 4880" : "(+44) 01792 277295"; emailModel.SiteAddress = UtilityRepository.GetOperationZone().OperationZoneId == 1 ? "www.FRAYTE.com" : "www.FRAYTE.co.uk"; emailModel.TrackingWebsite = UtilityRepository.GetOperationZone().OperationZoneId == 1 ? "https://frayte.com/tracking-detail/" + emailModel.ShipmentDetail.AWBNumber.Replace(" ", "") : "https://frayte.co.uk/tracking-detail/" + emailModel.ShipmentDetail.AWBNumber.Replace(" ", ""); emailModel.TrackingURL = AppSettings.TrackingUrl + "/tracking-detail/" + emailModel.ShipmentDetail.TrackingNumber.Replace("Order_", "");; } emailModel.TotalCarton = emailModel.ShipmentDetail.Packages.Sum(p => p.CartonValue); emailModel.TotalWeight = emailModel.ShipmentDetail.Packages.Sum(p => p.CartonValue * p.Weight); emailModel.CreatedOn = emailModel.ShipmentDetail.CreatedOnUtc != null?emailModel.ShipmentDetail.CreatedOnUtc.ToString("dd-MMM-yyyy hh:mm") : ""; emailModel.CustomerName = result1.Name; string template = File.ReadAllText(AppSettings.EmailServicePath + "/EmailTeamplate/Express/EXS_E1_3.cshtml"); var templateService = new TemplateService(); var EmailBody = templateService.Parse(template, emailModel, null, null); string EmailSubject = string.Empty; EmailSubject = result1.CutomerCompany + " - Shipment Detail with Label - " + emailModel.ShipmentDetail.AWBNumber; var To = emailModel.To; var Status = ""; #region Attach Labels string Attachment = PackageLabelPath_EXS_E1(emailModel.ShipmentDetail.ExpressId); #endregion Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception("Customer Email " + emailModel.ShipmentDetail.FrayteNumber)); //Send mail to Customer Send_FrayteEmail(To, AppSettings.TOCC, "FRAYTE - Booking (" + UtilityRepository.OperationZoneName(operationzone.OperationZoneId) + ")", EmailSubject, EmailBody, Attachment, Status, emailModel.ShipmentDetail.CustomerId); result.Status = true; Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception(EmailBody)); } catch (Exception ex) { result.Status = false; } return(result); }
public FrayteResult SendExportManifest(ExpressEmailModel emailModel, string FilePath, int UserId) { FrayteResult result = new FrayteResult(); emailModel.ImageHeader = "FrayteLogo"; try { var operationzone = UtilityRepository.GetOperationZone(); var result1 = (from Usr in dbContext.Users join Rl in dbContext.UserRoles on Usr.UserId equals Rl.UserId join UA in dbContext.UserAdditionals on Usr.UserId equals UA.UserId into UAA from UA in UAA.DefaultIfEmpty() join OU in dbContext.Users on UA.OperationUserId equals OU.UserId into OUU from OU in OUU.DefaultIfEmpty() where Usr.UserId == emailModel.ManifestDetail.CustomerId select new { UserName = OU.ContactName, CustomerName = Usr.ContactName, StaffEmail = OU.Email, UserEmail = Rl.RoleId == 3 ? Usr.UserEmail : Usr.Email, UserPosition = OU.Position, CutomerCompany = Usr.CompanyName }).FirstOrDefault(); var result2 = (from Usr in dbContext.Users join Rl in dbContext.UserRoles on Usr.UserId equals Rl.UserId join UA in dbContext.UserAdditionals on Usr.UserId equals UA.UserId into UAA from UA in UAA.DefaultIfEmpty() join OU in dbContext.Users on UA.OperationUserId equals OU.UserId into OUU from OU in OUU.DefaultIfEmpty() where Usr.UserId == UserId select new { UserName = Usr.ContactName, StaffEmail = OU.Email, UserEmail = Rl.RoleId == 3 ? Usr.UserEmail : Usr.Email, UserPosition = OU.Position, CutomerCompany = Usr.CompanyName }).FirstOrDefault(); if (operationzone.OperationZoneId == 1) { emailModel.UserEmail = result1.StaffEmail; emailModel.UserName = result1.UserName; emailModel.UserPosition = result1.UserPosition; emailModel.UserPhone = "(+852) 2148 4880"; //Res.SiteAddress = AppSettings.TrackingUrl; emailModel.SiteCompany = "FRAYTE GLOBAL"; emailModel.SiteAddress = "www.FRAYTE.com"; } if (operationzone.OperationZoneId == 2) { emailModel.UserEmail = result1.StaffEmail; emailModel.UserName = result1.UserName; emailModel.UserPosition = result1.UserPosition; emailModel.SiteCompany = "FRAYTE GLOBAL"; emailModel.UserPhone = "(+44) 01792 277295"; // Res.SiteAddress = AppSettings.TrackingUrl; emailModel.SiteAddress = "www.FRAYTE.co.uk"; } emailModel.CreatedOn = emailModel.ManifestDetail.CreatedOn != null?emailModel.ManifestDetail.CreatedOn.Value.ToString("dd-MMM-yyyy hh:mm") : ""; emailModel.CustomerName = result2.UserName; string template = File.ReadAllText(AppSettings.EmailServicePath + "/EmailTeamplate/Express/EXS_E5.cshtml"); var templateService = new TemplateService(); var EmailBody = templateService.Parse(template, emailModel, null, null); string EmailSubject = string.Empty; EmailSubject = result1.CutomerCompany + " - Origin Manifest - " + emailModel.ManifestDetail.MAWB; var To = result2.UserEmail; var Status = ""; #region Attach Labels string Attachment = FilePath; //string Attachment = ""; #endregion //Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception("Customer Email " + emailModel.ShipmentDetail.FrayteNumber)); //Send mail to Customer Send_FrayteEmail(To, AppSettings.TOCC, "FRAYTE - Booking (" + UtilityRepository.OperationZoneName(operationzone.OperationZoneId) + ")", EmailSubject, EmailBody, Attachment, Status, emailModel.ManifestDetail.CustomerId); result.Status = true; Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception(EmailBody)); } catch (Exception ex) { result.Status = false; } return(result); }