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