public override ReturnValue GetMailContent(int orderId, int releaseID, TProgram_Email mi)
{
ReturnValue _result = new ReturnValue();
System.Globalization.NumberFormatInfo nfi = Utilities.CurrentNumberFormat;
#region getOrderInfo and Check
TOrderNu _tOrder = new TOrderNu();
_result = _tOrder.getOrderById(orderId);
if (_result.Success == false)
{
return(_result);
}
_tOrder = _result.Object as TOrderNu;
if (_tOrder.OrderId == 0)
{
_result.Success = false;
_result.ErrMessage = "the order doesn't exits";
return(_result);
}
TOrderNu _emailAddress = new TOrderNu();
_result = _emailAddress.getMailAddress(_tOrder.CustomerId);
if (_result.Success == false)
{
return(_result);
}
_emailAddress = _result.Object as TOrderNu;
TOrder_Line_ItemNu _tOrdersDetail = new TOrder_Line_ItemNu();
_result = _tOrdersDetail.getOrdersDetail(orderId);
if (_result.Success == false)
{
return(_result);
}
EntityList _orderDetails = _result.ObjectList;
if (_orderDetails.Count == 0)
{
_result.Success = false;
_result.ErrMessage = "the order doesn't exits";
return(_result);
}
#endregion
try
{
#region setup EmailMessage
EmailMessage _mail = new EmailMessage();
if (_emailAddress.MailBCC.IndexOf(";") > 0)
{
_emailAddress.MailBCC = _emailAddress.MailBCC.Remove(_emailAddress.MailBCC.Length - 1, 1);
}
if (_emailAddress.MailCC.IndexOf(";") > 0)
{
_emailAddress.MailCC = _emailAddress.MailCC.Remove(_emailAddress.MailCC.Length - 1, 1);
}
if (_emailAddress.MailTo.IndexOf(";") > 0)
{
_emailAddress.MailTo = _emailAddress.MailTo.Remove(_emailAddress.MailTo.Length - 1, 1);
}
mi.BccAddress = _emailAddress.MailBCC;
mi.CCAddress = _emailAddress.MailCC;
#region Order Summary
string MailContent = mi.FullText
.Replace("&Firstname", _tOrder.FirstName)
.Replace("&zorderid", _tOrder.OrderId.ToString())
.Replace("&OrderDate", _tOrder.OrderDate.ToString("MM/dd/yyyy"))
.Replace("&ztotalproductamount", _tOrder.TotalProductAmount.ToString("C", nfi))
.Replace("&zTotalShipping", (_tOrder.TotalShipping).ToString("C", nfi))
.Replace("&zTotalTax", _tOrder.TotalTax.ToString("C", nfi))
.Replace("&zTotalOrderAmount", _tOrder.TotalOrderAmount.ToString("C", nfi))
.Replace("&ShippingMethod", _tOrder.ShipMethod)
.Replace("&ShippedDate", _tOrder.ShippedDate.Value.ToString("MM/dd/yyyy"));
#endregion
#region Order Detail
string RepeatTemp = "";
if (MailContent.IndexOf("&orderinfo") > 0)
{
RepeatTemp = " <table width =\"100%\" cellpadding=\"1\"><tr><td >Item No</td><td>Description</td><td >Unit Price</td><td>Quantity</td></tr>";
foreach (TOrder_Line_ItemNu drItem in _orderDetails)
{
RepeatTemp = RepeatTemp + "<tr><td >" + drItem.PartNumber + "</td><td>" + drItem.ProductName
+ "</td><td >" + drItem.Price.ToString("C") + "</td><td>" + drItem.Quantity.ToString() + "</td></tr>";
}
RepeatTemp = RepeatTemp + "</TABLE>";
}
MailContent = MailContent.Replace("&orderinfo", RepeatTemp);
#endregion
#region Shipping Detail
RepeatTemp = "";
if (MailContent.IndexOf("&shipmentnfo") > 0)
{
RepeatTemp = " <table width =\"100%\" cellpadding=\"1\">";
int _packageNumber = 1;
TOrder_Line_Shipment_Carton _tOrder_Line_Shipment_Carton = new TOrder_Line_Shipment_Carton();
_result = _tOrder_Line_Shipment_Carton.getOrderLineShipmentCartonByOrderID(orderId, releaseID);
if (_result.Success == false)
{
return(_result);
}
EntityList cartonList = _result.ObjectList;
TOrder_Line_Shipment_ASN _tOrder_Line_Shipment_ASN = new TOrder_Line_Shipment_ASN();
_result = _tOrder_Line_Shipment_ASN.getOrderLineShipmentASNByOrderID(orderId, releaseID);
if (_result.Success == false)
{
return(_result);
}
EntityList asnList = _result.ObjectList;
foreach (TOrder_Line_Shipment_Carton _carton in cartonList)
{
if (asnList.Count != 0)
{
if (string.IsNullOrEmpty(_carton.PACKAGE_TRACE_ID) == false)
{
RepeatTemp = RepeatTemp + "<tr><td >Package " + _packageNumber.ToString() + " Tracking Number:" + _carton.PACKAGE_TRACE_ID + " " +
"(<a href=\"{0}\">TrackOrder</a>)" + "</td></tr>";
}
else
{
RepeatTemp = RepeatTemp + "<tr><td >Package " + _packageNumber.ToString() + " Tracking Number:N/A</td></tr>";
}
RepeatTemp = RepeatTemp + "<tr><td ><br /> <table width =\"100%\" cellpadding=\"1\"><tr><td > Item No</td>" +
"<td>Description</td><td>Qty in Package</td></tr>";
foreach (TOrder_Line_Shipment_ASN _asn in asnList)
{
TOrder_Line_ItemNu _orderDetail = this.getOrderLine(_orderDetails, _asn);
RepeatTemp = RepeatTemp + " <tr><td >" + _orderDetail.PartNumber + "</td><td>" + _orderDetail.ProductName +
"</td><td>" + Convert.ToInt16(Convert.ToDouble(_asn.PIECES_TO_MOVE)).ToString() + "</td></tr>";
RepeatTemp = RepeatTemp.Replace("{0}", _orderDetail.TrackingURL + _carton.PACKAGE_TRACE_ID);
}
RepeatTemp = RepeatTemp + "</table><br /></td></tr>";
_packageNumber++;
}
}
RepeatTemp = RepeatTemp + "</TABLE>";
}
MailContent = MailContent.Replace("&shipmentnfo", RepeatTemp);
#endregion
_mail.HtmlPart = new HtmlAttachment(MailContent);
_mail.FromAddress = new EmailAddress(mi.RespondTo);
_mail.Subject = mi.Subject;
if (Common.IsTest == true)
{
string[] maillist = Common.TestMailTo.Split(';');
foreach (string _item in maillist)
{
_mail.AddToAddress(new EmailAddress(_item));
}
_result.Table = Common.TestMailTo;
}
else
{
if (string.IsNullOrEmpty(_emailAddress.MailTo) == true)
{
_result.Success = false;
_result.ErrMessage = "Email To Address is empty";
return(_result);
}
else
{
string[] bcclist = _emailAddress.MailTo.Split(';');
foreach (string _item in bcclist)
{
_mail.AddToAddress(new EmailAddress(_item));
}
}
_result.Table = _emailAddress.MailTo;
}
if (string.IsNullOrEmpty(mi.BccAddress) == false)
{
string[] bcclist = mi.BccAddress.Split(';');
foreach (string _item in bcclist)
{
_mail.AddBccAddress(new EmailAddress(_item));
}
}
if (string.IsNullOrEmpty(mi.CCAddress) == false)
{
string[] bcclist = mi.CCAddress.Split(';');
foreach (string _item in bcclist)
{
_mail.AddCcAddress(new EmailAddress(_item));
}
}
_result.ObjectValue = _mail;
#endregion
}
catch (Exception ex)
{
_result.Success = false;
_result.ErrMessage = ex.ToString();
}
return(_result);
}
public override ReturnValue GetMailContent(int orderId, int releaseID, TProgram_Email mi)
{
ReturnValue _result = new ReturnValue();
System.Globalization.NumberFormatInfo nfi = Utilities.CurrentNumberFormat;
#region getCustomerInfo
TOrderTF _tOrder = new TOrderTF();
_result = _tOrder.getOrderById(orderId);
if (!_result.Success)
{
return(_result);
}
_tOrder = _result.Object as TOrderTF;
if (_tOrder.SourceId == 19)
{
_result.Code = 19;
return(_result);
}
TCustomer _tCustomer = new TCustomer();
_result = _tCustomer.getCustomerById(_tOrder.PWPCustomerId);
if (!_result.Success)
{
return(_result);
}
_tCustomer = _result.Object as TCustomer;
TOrder_Line_Item _tOrder_Line_Item = new TOrder_Line_Item();
_result = _tOrder_Line_Item.getOrderDetailsByOrderId(_tOrder.OrderId, releaseID);
if (!_result.Success)
{
return(_result);
}
EntityList _list = _result.ObjectList;
if (_list.Count == 0)
{
return(_result);
}
_tOrder_Line_Item = _list[0] as TOrder_Line_Item;
TShipMethod _tShipMethod = new TShipMethod();
_result = _tShipMethod.getShipMethodById(_tOrder_Line_Item.ShipMethodId);
if (!_result.Success)
{
return(_result);
}
_tShipMethod = _result.Object as TShipMethod;
TAddress _tBillAddress = new TAddress();
_result = _tBillAddress.getAddressById(_tOrder.CustomerAddressId);
if (!_result.Success)
{
return(_result);
}
_tBillAddress = _result.Object as TAddress;
TAddress _tShipAddress = new TAddress();
_result = _tBillAddress.getAddressById(_tOrder.ShipToAddressId);
if (!_result.Success)
{
return(_result);
}
_tShipAddress = _result.Object as TAddress;
TPaymentArrangement _tPaymentArrangement = new TPaymentArrangement();
_result = _tPaymentArrangement.getPaymentArrangementList(orderId);
if (!_result.Success)
{
return(_result);
}
EntityList _paymentList = _result.ObjectList;
double _paymentApplied = 0;
double _estimatedAmountDue = 0;
foreach (TPaymentArrangement _item in _paymentList)
{
if (_item.PayMethodId == 4)
{
_estimatedAmountDue += _item.Amount;
}
else
{
_paymentApplied += _item.Amount;
}
}
#endregion
try
{
#region setup EmailMessage
EmailMessage _mail = new EmailMessage();
string MailContent = HttpUtility.HtmlDecode(mi.FullHtml);
#region filter the email content
MailContent = MailContent.Replace("[CustomerName]", _tCustomer.FirstName == null ? "" : _tCustomer.FirstName.ToString());
MailContent = MailContent.Replace("[OrderDate]", _tOrder.OrderDate.ToString("MM/dd/yyyy"));
string siteURL = "http://admin.tecnifibreusa.com/";
MailContent = MailContent.Replace("[WebSite]", siteURL);
MailContent = MailContent.Replace("[OrderNumber]", _tOrder.AltOrderNum);
MailContent = MailContent.Replace("[PONumber]", _tOrder.PONumber);
MailContent = MailContent.Replace("[CustomerAcct]", _tCustomer.AltCustNum);
MailContent = MailContent.Replace("[ShipMethod]", _tShipMethod.Description);
MailContent = MailContent.Replace("[BillingAddress]", _tBillAddress.Company + "<br> " + _tBillAddress.Address1 + " " + _tBillAddress.Address2 + "<br>" + _tBillAddress.City + ", " + _tBillAddress.StateCode + " " + _tBillAddress.PostalCode);
MailContent = MailContent.Replace("[ShippingAddress]", _tShipAddress.Company + "<br> " + _tShipAddress.Address1 + " " + _tShipAddress.Address2 + "<br>" + _tShipAddress.City + ", " + _tShipAddress.StateCode + " " + _tShipAddress.PostalCode);
MailContent = MailContent.Replace("[SubTotal]", (_tOrder.TotalWholeSaleAmount - _tOrder.CompProductAmount).ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[Tax]", "(" + Utilities.Round(_tOrder.TaxRate * 100, 2).ToString() + "%)" + (_tOrder.TotalTax - _tOrder.CompTax).ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[Shipping]", (_tOrder.TotalShipping - _tOrder.CompShipingCost).ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[Discount]", (_tOrder.TotalDiscountAmount + _tOrder.CompProductAmount).ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[OrderTotal]", _tOrder.TotalOrderAmount.ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[PaymentApplied]", _paymentApplied.ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[EstimatedAmountDue]", _estimatedAmountDue.ToString("C", Utilities.CurrentNumberFormat));
MailContent = MailContent.Replace("[BFirstName]", _tBillAddress.FirstName);
MailContent = MailContent.Replace("[BLastName]", _tBillAddress.LastName);
MailContent = MailContent.Replace("[SFirstName]", _tShipAddress.FirstName);
MailContent = MailContent.Replace("[SLastName]", _tShipAddress.LastName);
StringBuilder OrderItemHTML = new StringBuilder();
foreach (TOrder_Line_Item _item in _list)
{
OrderItemHTML.Append("<tr>");
OrderItemHTML.Append(" <td>" + _item.LineNum + "</td>");
OrderItemHTML.Append("<td>" + _item.PartNumber + "</td>");
OrderItemHTML.Append("<td>" + _item.ProductName + "</td>");
OrderItemHTML.Append("<td>" + _item.Quantity + "</td>");
if (_item.ShippedDate != null)
{
OrderItemHTML.Append("<td>" + _item.ShippedDate.Value.ToString("MM/dd/yyyy") + "</td>");
}
else
{
OrderItemHTML.Append("<td></td>");
}
OrderItemHTML.Append("<td>" + _item.TrackingNumber + "</td>");
OrderItemHTML.Append("<td>" + _item.Price.ToString("C", Utilities.CurrentNumberFormat) + "</td>");
OrderItemHTML.Append("<td>" + (_item.DiscountAmount + _item.ComAmount).ToString("C", Utilities.CurrentNumberFormat) + "</td>");
OrderItemHTML.Append("<td>" + ((_item.ActualPrice - _item.ComAmount) / _item.Quantity).ToString("C", Utilities.CurrentNumberFormat) + "</td>");
OrderItemHTML.Append("<td>" + (_item.ActualPrice - _item.ComAmount).ToString("C", Utilities.CurrentNumberFormat) + "</td>");
OrderItemHTML.Append("</tr>");
}
#endregion
MailContent = MailContent.Replace("[Items]", OrderItemHTML.ToString());
_mail.HtmlPart = new HtmlAttachment(MailContent);
_mail.FromAddress = new EmailAddress(mi.RespondTo);
_mail.Subject = mi.Subject;
if (Common.IsTest == true)
{
string[] maillist = Common.TestMailTo.Split(';');
foreach (string _item in maillist)
{
_mail.AddToAddress(new EmailAddress(_item));
}
_result.Table = Common.TestMailTo;
}
else
{
if (string.IsNullOrEmpty(_tCustomer.Email) == true)
{
_result.Success = false;
_result.ErrMessage = "Email To Address is empty";
return(_result);
}
else
{
_mail.AddToAddress(new EmailAddress(_tCustomer.Email));
}
_result.Table = _tCustomer.Email;
}
if (string.IsNullOrEmpty(mi.BccAddress) == false)
{
string[] bcclist = mi.BccAddress.Split(';');
foreach (string _item in bcclist)
{
if (string.IsNullOrEmpty(_item) == false)
{
_mail.AddBccAddress(new EmailAddress(_item));
}
}
}
if (string.IsNullOrEmpty(mi.CCAddress) == false)
{
string[] bcclist = mi.CCAddress.Split(';');
foreach (string _item in bcclist)
{
if (string.IsNullOrEmpty(_item) == false)
{
_mail.AddCcAddress(new EmailAddress(_item));
}
}
}
if (string.IsNullOrEmpty(_tCustomer.OrderEmail) == false)
{
_mail.AddCcAddress(new EmailAddress(_tCustomer.OrderEmail));
}
if (string.IsNullOrEmpty(_tCustomer.SecondaryEmail) == false)
{
_mail.AddCcAddress(new EmailAddress(_tCustomer.SecondaryEmail));
}
if (string.IsNullOrEmpty(_tCustomer.SalesRepEmail) == false)
{
_mail.AddBccAddress(new EmailAddress(_tCustomer.SalesRepEmail));
}
_result.ObjectValue = _mail;
#endregion
}
catch (Exception ex)
{
_result.Success = false;
_result.ErrMessage = ex.ToString();
}
return(_result);
}
public virtual ReturnValue GetMailContent(int orderId, int releaseID, TProgram_Email mi)
{
ReturnValue _result = new ReturnValue();
System.Globalization.NumberFormatInfo nfi = Utilities.CurrentNumberFormat;
#region getOrderInfo and Check
TOrder _tOrder = new TOrder();
_result = _tOrder.getOrderById(orderId);
if (_result.Success == false)
{
return(_result);
}
_tOrder = _result.Object as TOrder;
if (_tOrder.OrderId == 0)
{
_result.Success = false;
_result.ErrMessage = "the order doesn't exists --getOrderById";
return(_result);
}
TOrder_Line_Item _tOrder_Line_Item = new TOrder_Line_Item();
_result = _tOrder_Line_Item.getOrderDetailsByOrderId(orderId, releaseID);
if (_result.Success == false)
{
return(_result);
}
EntityList _orderDetails = _result.ObjectList;
if (_orderDetails.Count == 0)
{
_result.Success = false;
_result.ErrMessage = "the order doesn't exists---getOrdersDetail";
return(_result);
}
#endregion
try
{
#region generate Email Content
EmailMessage _mail = new EmailMessage();
#region Order Summary
string MailContent = HttpUtility.HtmlDecode(mi.FullHtml);
MailContent = MailContent
.Replace("{orderid}", _tOrder.AltOrderNum)
.Replace("{firstname}", _tOrder.FirstName)
.Replace("{shipmethod}", _tOrder.ShipMethodName)
.Replace("{ShipCarrier}", _tOrder.ShipCarrier)
.Replace("{CustomerName}", _tOrder.FirstName + " " + _tOrder.LastName)
.Replace("{trackingnumber}", _tOrder.TrackingNumber)
.Replace("{ShipDate}", _tOrder.ShippedDate.Value.ToString("MM/dd/yyyy"));
#endregion
TOrder_Line_Item _shipTo = _orderDetails[0] as TOrder_Line_Item;
string shipinfo = _shipTo.ShipToAddress + "<br>" + _shipTo.ShipToCity + "," + _shipTo.ShipToState + " " + _shipTo.ShipToZip;
MailContent = MailContent
.Replace("{shipmentnfo}", shipinfo);
#region Shipping Detail
string RepeatTemp = "";
if (MailContent.IndexOf("{orderLine}") > 0)
{
RepeatTemp = " <table width =\"100%\" cellpadding=\"1\"><tr><td>SKU</td><td>Name</td><td>QTY</td></tr>";
foreach (TOrder_Line_Item _item in _orderDetails)
{
RepeatTemp = RepeatTemp + " <tr><td >" + _item.PartNumber + "</td><td>" + _item.ProductName +
"</td><td>" + _item.Quantity.ToString() + "</td></tr>";
}
RepeatTemp = RepeatTemp + "</table>";
}
MailContent = MailContent.Replace("{orderLine}", RepeatTemp);
#endregion
#endregion
_mail.HtmlPart = new HtmlAttachment(MailContent);
#region setup EmailMessage
_mail.FromAddress = new EmailAddress(mi.RespondTo);
_mail.Subject = mi.Subject.Replace("[Orderid]", _tOrder.AltOrderNum);
if (Common.IsTest == true)
{
string[] maillist = Common.TestMailTo.Split(';');
foreach (string _item in maillist)
{
_mail.AddToAddress(new EmailAddress(_item));
}
_result.Table = Common.TestMailTo;
}
else
{
if (string.IsNullOrEmpty(_tOrder.Email) == true)
{
_result.Success = false;
_result.ErrMessage = "Email To Address is empty";
return(_result);
}
else
{
string[] bcclist = _tOrder.Email.Split(';');
foreach (string _item in bcclist)
{
_mail.AddToAddress(new EmailAddress(_item));
}
}
}
if (string.IsNullOrEmpty(mi.BccAddress) == false)
{
string[] bcclist = mi.BccAddress.Split(';');
foreach (string _item in bcclist)
{
_mail.AddBccAddress(new EmailAddress(_item));
}
}
if (string.IsNullOrEmpty(mi.CCAddress) == false)
{
string[] bcclist = mi.CCAddress.Split(';');
foreach (string _item in bcclist)
{
_mail.AddCcAddress(new EmailAddress(_item));
}
}
#endregion
_result.ObjectValue = _mail;
}
catch (Exception ex)
{
_result.Success = false;
_result.ErrMessage = ex.ToString();
}
return(_result);
}
public static ReturnValue SentEmail(TProgram_Email tProgram_Email, EmailFormat emailFormat, int oId, FileAttachment fileAttachment)
{
ReturnValue _result = new ReturnValue();
bool IsTFTestMode = Convert.ToBoolean(System.Configuration.ConfigurationSettings.AppSettings["IsTFTestMode"].ToString());
if (tProgram_Email.ContentStatusId != 1)
{
return(_result);
}
EmailMessage _mail = new EmailMessage();
if (string.IsNullOrEmpty(tProgram_Email.RespondToName) == true)
{
_mail.FromAddress = new EmailAddress(tProgram_Email.RespondTo);
}
else
{
_mail.FromAddress = new EmailAddress(tProgram_Email.RespondTo, tProgram_Email.RespondToName);
}
_mail.Subject = tProgram_Email.Subject;
if (emailFormat == EmailFormat.Html || emailFormat == EmailFormat.Both)
{
_mail.HtmlPart = new HtmlAttachment(tProgram_Email.FullHtml);
}
if (emailFormat == EmailFormat.Text || emailFormat == EmailFormat.Both)
{
_mail.TextPart = new TextAttachment(tProgram_Email.FullText);
}
string _emailto = tProgram_Email.ToAddress;
if (IsTFTestMode == true)
{
if (string.IsNullOrEmpty(Common.TestMailTo) == false)
{
string[] ccList = Common.TestMailTo.Split(';');
foreach (string ccAddress in ccList)
{
_mail.AddToAddress(new EmailAddress(ccAddress));
}
_emailto = Common.TestMailTo;
}
}
else
{
if (string.IsNullOrEmpty(tProgram_Email.CCAddress) == false)
{
string[] ccList = tProgram_Email.CCAddress.Split(';');
foreach (string ccAddress in ccList)
{
if (string.IsNullOrEmpty(ccAddress.Trim()) == false)
{
_mail.AddCcAddress(new EmailAddress(ccAddress));
}
}
}
if (string.IsNullOrEmpty(tProgram_Email.BccAddress) == false)
{
string[] BccList = tProgram_Email.BccAddress.Split(';');
foreach (string bccAddress in BccList)
{
if (string.IsNullOrEmpty(bccAddress.Trim()) == false)
{
_mail.AddBccAddress(new EmailAddress(bccAddress));
}
}
}
if (string.IsNullOrEmpty(tProgram_Email.ToAddress) == false)
{
string[] ToAddressList = tProgram_Email.ToAddress.Split(';');
foreach (string toAddress in ToAddressList)
{
if (string.IsNullOrEmpty(toAddress.Trim()) == false)
{
_mail.AddToAddress(new EmailAddress(toAddress));
}
}
}
}
if (fileAttachment != null)
{
_mail.AddMixedAttachment(fileAttachment);
}
App_Log_Mail _mailLog = new App_Log_Mail();
try
{
SmtpServer server = new SmtpServer(System.Configuration.ConfigurationSettings.AppSettings["SMTPServer"].ToString(), 25);
DotNetOpenMail.SmtpAuth.SmtpAuthToken SmtpAuthToken =
new DotNetOpenMail.SmtpAuth.SmtpAuthToken(System.Configuration.ConfigurationSettings.AppSettings["SMTPUserName"].ToString(),
System.Configuration.ConfigurationSettings.AppSettings["SMTPPassword"].ToString());
server.SmtpAuthToken = SmtpAuthToken;
bool _success = _mail.Send(server);
_mailLog.Success = _success;
_mailLog.Notes = "";
}
catch (Exception ex)
{
_mailLog.Success = false;
_mailLog.Notes = ex.ToString();
}
finally
{
_mailLog.AddressBcc = "AddressBcc:" + (string.IsNullOrEmpty(tProgram_Email.BccAddress) ? "" : tProgram_Email.BccAddress) + " CCAddress:" + (string.IsNullOrEmpty(tProgram_Email.CCAddress) ? "" : tProgram_Email.CCAddress);
_mailLog.AddressFrom = tProgram_Email.RespondTo;
_mailLog.AddressTo = _emailto;
if (emailFormat == EmailFormat.Html || emailFormat == EmailFormat.Both)
{
_mailLog.Content = tProgram_Email.FullHtml;
}
if (emailFormat == EmailFormat.Text || emailFormat == EmailFormat.Both)
{
_mailLog.Content = tProgram_Email.FullText;
}
_mailLog.CreatedOn = System.DateTime.Now;
_mailLog.Subject = tProgram_Email.Subject;
_mailLog.Type = tProgram_Email.EmailTypeId.ToString();
_mailLog.OId = oId.ToString();
_mailLog.IsTest = IsTFTestMode;
_mailLog.Save();
}
_result.Success = _mailLog.Success.Value;
_result.ErrMessage = _mailLog.Notes;
if (string.IsNullOrEmpty(_mailLog.AddressTo) == true)
{
_result.Success = true;
}
return(_result);
}
public ReturnValue WishList()
{
ReturnValue _result = new ReturnValue();
#region get TProgram_Email
TProgram_EmailTF _tProgram_Email = new TProgram_EmailTF();
_result = _tProgram_Email.getEmailTemplate("WishList");
if (_result.Success == false)
{
Common.Log("getProgram_InfoList---ER \r\n" + _result.ErrMessage);
Common.SentAlterEmail(1, _result.ErrMessage);
return(_result);
}
else
{
Common.Log("getProgram_InfoList---OK");
}
_tProgram_Email = _result.Object as TProgram_EmailTF;
#endregion
#region get WishList
TWishList _tWishList = new TWishList();
_result = _tWishList.getWishList();
if (_result.Success == false)
{
Common.Log("getWishList---ER \r\n" + _result.ErrMessage);
Common.SentAlterEmail(1, _result.ErrMessage);
return(_result);
}
else
{
Common.Log("getWishList---OK");
}
#endregion
EntityList _list = _result.ObjectList;
int _successfulRecord = 0;
int _failedRecord = 0;
string _errorNotes = "";
#region sent email
foreach (TWishList _item in _list)
{
string _content = System.Web.HttpUtility.HtmlDecode(_tProgram_Email.FullHtml);
TProgram_Email _email = _tProgram_Email.Clone() as TProgram_Email;
_content = _content.Replace("[CustomerName]", _item.FirstName + " " + _item.LastName);
_email.ToAddress = _item.Email;
_email.CCAddress = _email.CCAddress + ";" + _item.OrderEmail + ";" + _item.SecondaryEmail;
_email.BccAddress = _email.BccAddress + ";" + _item.SalesRepEmail;
TWishList_Line_Item _tWishList_Line_Item = new TWishList_Line_Item();
_result = _tWishList_Line_Item.getWishListLineItemByWishListId(_item.Id);
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "WishList : " + _item.Id.ToString() + "-getWishListLineItemByWishListId ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("WishList : " + _item.Id.ToString() + "- getWishListLineItemByWishListId ---ER \r\n" + _result.ErrMessage);
continue;
}
EntityList _lineItem = _result.ObjectList;
StringBuilder _sb = new StringBuilder();
foreach (TWishList_Line_Item _line in _lineItem)
{
_sb.Append("<tr><td style=\"border-right:1px solid #000000; border-bottom:1px solid #000000;\">" + _line.PartNumber + "</td>" +
"<td style=\" border-bottom:1px solid #000000;\">" + _line.Name + "</td></tr>");
}
_content = _content.Replace("[ProductList]", _sb.ToString());
_email.FullHtml = _content;
_result = SentEmail(_email, EmailFormat.Html, _item.Id, null);
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "WishList : " + _item.Id.ToString() + "- ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("WishList : " + _item.Id.ToString() + "- ---ER \r\n" + _result.ErrMessage);
continue;
}
_result = _item.updateMailInformedOnByWishListId(_item.Id);
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "WishList : " + _item.Id.ToString() + "- ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("WishList : " + _item.Id.ToString() + "- ---ER \r\n" + _result.ErrMessage);
continue;
}
_successfulRecord++;
Common.Log("WishList : " + _item.Id.ToString() + "- DueInvoices ---OK");
}
#endregion
if (_failedRecord != 0)
{
Common.SentAlterEmail(_failedRecord, _errorNotes);
}
return(_result);
}
public ReturnValue PastDue()
{
ReturnValue _result = new ReturnValue();
#region get TProgram_Email
TProgram_EmailTF _tProgram_Email = new TProgram_EmailTF();
_result = _tProgram_Email.getEmailTemplate("10DaysPastDue");
if (_result.Success == false)
{
Common.Log("getProgram_InfoList---ER \r\n" + _result.ErrMessage);
Common.SentAlterEmail(1, _result.ErrMessage);
return(_result);
}
else
{
Common.Log("getProgram_InfoList---OK");
}
_tProgram_Email = _result.Object as TProgram_EmailTF;
#endregion
#region get Invoices
TInvoice _ttInvoice = new TInvoice();
_result = _ttInvoice.getPastDueInvoiceList();
if (_result.Success == false)
{
Common.Log("getPastDueInvoiceList---ER \r\n" + _result.ErrMessage);
Common.SentAlterEmail(1, _result.ErrMessage);
return(_result);
}
else
{
Common.Log("getPastDueInvoiceList---OK");
}
#endregion
EntityList _list = _result.ObjectList;
int _successfulRecord = 0;
int _failedRecord = 0;
string _errorNotes = "";
#region sent email
foreach (TInvoice _item in _list)
{
string _content = System.Web.HttpUtility.HtmlDecode(_tProgram_Email.FullHtml);
TProgram_Email _email = _tProgram_Email.Clone() as TProgram_Email;
DateTime dt1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
DateTime dt3 = new DateTime(_item.DueDate.Year, _item.DueDate.Month, _item.DueDate.Day);
int _aging = dt1.Subtract(dt3).Days;
_content = _content.Replace("[customeraccount]", _item.CustomerAccount)
.Replace("[OrderDate]", _item.OrderDate.ToString("MM/dd/yyyy"))
.Replace("[aging]", _aging.ToString())
.Replace("[invoiceNo]", _item.InvoiceId.ToString())
.Replace("[duedate]", _item.DueDate.ToString("MM/dd/yyyy"));
_email.ToAddress = _item.Email;
_email.FullHtml = _content;
_email.CCAddress = _email.CCAddress + ";" + _item.InvoiceEmail;
_email.BccAddress = _email.BccAddress + ";" + _item.SalesRepEmail;
#region attached pdf
TecnifibreInvoicePDF TecnifibreInvoicePDF = new TecnifibreInvoicePDF();
_result = TecnifibreInvoicePDF.PrintInvoice(_item.InvoiceId);
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "Invoice : " + _item.InvoiceId.ToString() + "- TFInvoicePDFGenerator ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("Invoice : " + _item.InvoiceId.ToString() + "- TFInvoicePDFGenerator ---ER \r\n" + _result.ErrMessage);
continue;
}
string pdffilename = "Invoice/TFInvoice_" + _item.InvoiceId.ToString() + ".pdf";
FileAttachment fileAttachment = new FileAttachment(new FileInfo(pdffilename));
fileAttachment.ContentType = "application/pdf";
#endregion
_result = SentEmail(_email, EmailFormat.Html, _item.InvoiceId, fileAttachment);
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "Invoice : " + _item.InvoiceId.ToString() + "- PastDue ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("Invoice : " + _item.InvoiceId.ToString() + "- PastDue ---ER \r\n" + _result.ErrMessage);
continue;
}
_item.PastDueEmailOn = System.DateTime.Now;
_result = _item.Update();
if (_result.Success == false)
{
_failedRecord++;
_errorNotes = _errorNotes + "Invoice : " + _item.InvoiceId.ToString() + "- DueInvoices ---ER \r\n" + _result.ErrMessage + "\r\n";
Common.Log("Invoice : " + _item.InvoiceId.ToString() + "- DueInvoices ---ER \r\n" + _result.ErrMessage);
continue;
}
_successfulRecord++;
Common.Log("Invoice : " + _item.InvoiceId.ToString() + "- DueInvoices ---OK");
}
#endregion
if (_failedRecord != 0)
{
Common.SentAlterEmail(_failedRecord, _errorNotes);
}
return(_result);
}