/// <summary>
/// Invoice reader.
/// </summary>
public void InvoiceReader()
{
StringBuilder sb = new StringBuilder();
InvoiceDataObj = InvoiceDAL.InvoiceDataList();
if (InvoiceDataObj.GenerateDate.Day == DateTime.Today.Day)
{
List<DataRow> emailAccountList = InvoiceDAL.EmailAccountList();
foreach (DataRow dr in emailAccountList)
{
List<DataRow> vendorList = InvoiceDAL.VendorList();
SewbieAdminID = InvoiceDAL.SewbieAdminID();
foreach (DataRow drVendor in vendorList)
{
Amount = InvoiceDAL.InvoiceAmount(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
if (Amount > 0)
{
string strHeaderContent = "<html><body> <div style='color: #003399;'>Dear " + drVendor["CompanyName"].ToString() + ", <br /><br />"
+ "Invoice <br /><br /><br /> "
+ "</div> </body></html> ";
sb.Append(strHeaderContent);
sb.Append("<table border='1' bordercolor='#2f2c63'>");
sb.Append("<tr>");
sb.Append("<th style='width: 200px; color: #000066'>Date </th><th style='width: 200px; color: #000066'> Due Date</th> <th style='width: 200px; color: #000066'> Amount </th> <th style='width: 200px; color: #000066'> Pay Now </th> ");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td style='color: #000066; text-align:center '>" + InvoiceDataObj.GenerateDate.ToShortDateString() + "</td>");
sb.Append("<td style='width: 500px; color: #000066; text-align:center'>" + InvoiceDataObj.DueDate.ToShortDateString() + "</td>");
sb.Append("<td style='width: 200px; color: #000066; text-align:right'>" + Amount + "</td>");
sb.Append("<td style='width: 500px; color: #000066; text-align:center'>" + "<a href='http://www.sewbie.com/default.aspx'>Pay Now</a>" + "</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("<br /><br /><br /><br /> *This is a system generated email, please do not reply to this message.");
SendMail(dr["Email"].ToString().Trim(), dr["DisplayName"].ToString().Trim(), drVendor["Email"].ToString().Trim(), "Invoice", sb.ToString(), Convert.ToBoolean(dr["UseDefaultCredentials"].ToString().Trim()), dr["Host"].ToString().Trim(), Convert.ToInt16(dr["Port"].ToString().Trim()), Convert.ToBoolean(dr["EnableSsl"].ToString().Trim()), dr["Username"].ToString().Trim(), dr["Password"].ToString().Trim());
InvoiceId = InvoiceDAL.AddInvoice(Convert.ToInt16(drVendor["VendorID"]), InvoiceDataObj.StartDate, InvoiceDataObj.EndDate, Amount);
List<DataRow> receivablesChargeList = InvoiceDAL.ReceivablesChargeList(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
foreach (DataRow drReceivablesCharge in receivablesChargeList)
{
InvoiceDAL.AddInvoiceCharges(InvoiceId, Convert.ToInt16(drReceivablesCharge["ChargeID"]), Convert.ToDecimal(drReceivablesCharge["Amount"]));
}
List<DataRow> payablesChargeList = InvoiceDAL.PayablesChargeList(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
foreach (DataRow drPayablesCharge in payablesChargeList)
{
InvoiceDAL.AddInvoiceCharges(InvoiceId, Convert.ToInt16(drPayablesCharge["ChargeID"]), -Convert.ToDecimal(drPayablesCharge["Amount"]));
}
sb = new StringBuilder();
}
}
}
}
}
public void InvoiceReaderMailSendTrowInvoiceTemplete()
{
StringBuilder sb = new StringBuilder();
InvoiceTemplateObj = InvoiceDAL.InvoiceTemplateList();
InvoiceDataObj = InvoiceDAL.InvoiceDataList();
if (InvoiceDataObj.GenerateDate.Day == DateTime.Today.Day)
{
List<DataRow> emailAccountList = InvoiceDAL.EmailAccountList();
foreach (DataRow dr in emailAccountList)
{
List<DataRow> vendorList = InvoiceDAL.VendorList();
SewbieAdminID = InvoiceDAL.SewbieAdminID();
foreach (DataRow drVendor in vendorList)
{
Amount = InvoiceDAL.InvoiceAmount(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
if (Amount > 0)
{
string body = "<b>Dear " + drVendor["CompanyName"].ToString() + ",<b><br><br>";
body = body+"<b>Invoice<b><br>";
body = body+InvoiceTemplateObj.Body;
body = body.Replace("%Date%", InvoiceDataObj.GenerateDate.ToShortDateString());
body = body.Replace("%Duedate%", InvoiceDataObj.DueDate.ToShortDateString());
body = body.Replace("%Amount%", Convert.ToString(Amount));
body = body.Replace("%PayNow%", "<a>PayNow</a>");
SendMail(dr["Email"].ToString().Trim(), dr["DisplayName"].ToString().Trim(), drVendor["Email"].ToString().Trim(), InvoiceTemplateObj.Subject, body, Convert.ToBoolean(dr["UseDefaultCredentials"].ToString().Trim()), dr["Host"].ToString().Trim(), Convert.ToInt16(dr["Port"].ToString().Trim()), Convert.ToBoolean(dr["EnableSsl"].ToString().Trim()), dr["Username"].ToString().Trim(), dr["Password"].ToString().Trim());
InvoiceId = InvoiceDAL.AddInvoice(Convert.ToInt16(drVendor["VendorID"]), InvoiceDataObj.StartDate, InvoiceDataObj.EndDate, Amount);
List<DataRow> receivablesChargeList = InvoiceDAL.ReceivablesChargeList(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
foreach (DataRow drReceivablesCharge in receivablesChargeList)
{
InvoiceDAL.AddInvoiceCharges(InvoiceId, Convert.ToInt16(drReceivablesCharge["ChargeID"]), Convert.ToDecimal(drReceivablesCharge["Amount"]));
}
List<DataRow> payablesChargeList = InvoiceDAL.PayablesChargeList(Convert.ToInt16(drVendor["VendorID"]), SewbieAdminID, InvoiceDataObj.StartDate, InvoiceDataObj.EndDate);
foreach (DataRow drPayablesCharge in payablesChargeList)
{
InvoiceDAL.AddInvoiceCharges(InvoiceId, Convert.ToInt16(drPayablesCharge["ChargeID"]), -Convert.ToDecimal(drPayablesCharge["Amount"]));
}
sb = new StringBuilder();
}
}
}
}
}
/// <summary>
/// Gets Invoicedata.
/// </summary>
/// <returns></returns>
public static InvoiceData InvoiceDataList()
{
using (SqlConnection Con = new SqlConnection(connString))
{
InvoiceData InvoiceDataObj = new InvoiceData();
string sqlStmt = "Select VALUE AS StartDate,(Select VALUE AS EndDate from Nop_Setting where name ='Invoice.EndDate')AS EndDate,(SELECT CAST( cast(YEAR(GETDATE()) AS VARCHAR)+'-'+ cast(MONTH(GETDATE())AS VARCHAR)+'-'+(Select VALUE AS GenerateDate from Nop_Setting where name ='Invoice.GenerateDate') AS DATE))AS GenerateDate from Nop_Setting where name ='Invoice.StartDate'";
using (SqlDataAdapter dAd = new SqlDataAdapter(sqlStmt, Con))
{
DataTable dTable = new DataTable();
dAd.Fill(dTable);
foreach (DataRow row in dTable.Rows)
{
InvoiceDataObj.StartDate = Convert.ToDateTime(row["StartDate"].ToString());
InvoiceDataObj.EndDate = Convert.ToDateTime(row["EndDate"].ToString());
InvoiceDataObj.GenerateDate = Convert.ToDateTime(row["GenerateDate"].ToString());
InvoiceDataObj.DueDate = InvoiceDataObj.GenerateDate.AddDays(15);
}
return InvoiceDataObj;
}
}
}
