public virtual CloudAccountDA.NewInvoiceEmailTemplateDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
CloudAccountDA.NewInvoiceEmailTemplateDataTable dataTable = new CloudAccountDA.NewInvoiceEmailTemplateDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual int Fill(CloudAccountDA.NewInvoiceEmailTemplateDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
protected void btnSave_Click(object sender, EventArgs e)
{
this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewInvoiceEmailTemplateDT.Rows.Count > 0)
{
this.objNewInvoiceEmailTemplateBll.UpdateInvoiceTemplate(int.Parse(this.hfEmailID.Value), int.Parse(this.hfCompanyID.Value), this.txtSubject.Text, new StringBuilder(this.txtBody.Text).Replace("\n", "<br />").Replace(" ", " ").ToString());
}
else
{
this.objNewInvoiceEmailTemplateBll.AddInvoiceTemplate(int.Parse(this.hfCompanyID.Value), this.txtSubject.Text, new StringBuilder(this.txtBody.Text).Replace("\n", "<br />").Replace(" ", " ").ToString());
}
this.Response.Redirect("NewInvoiceEmailTemplate.aspx");
}
protected void btnRestore_Click(object sender, EventArgs e)
{
this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewInvoiceEmailTemplateDT.Rows.Count > 0)
{
this.objNewInvoiceEmailTemplateBll.UpdateInvoiceTemplate(int.Parse(this.hfEmailID.Value), int.Parse(this.hfCompanyID.Value), "New invoice ##invoiceNumber## from ##companyName## , sent using Bill Transact", this.strBody.ToString());
}
else
{
this.objNewInvoiceEmailTemplateBll.AddInvoiceTemplate(int.Parse(this.hfCompanyID.Value), "New invoice ##invoiceNumber## from ##companyName## , sent using Bill Transact", this.strBody.ToString());
}
this.Response.Redirect("NewInvoiceEmailTemplate.aspx");
}
public virtual CloudAccountDA.NewInvoiceEmailTemplateDataTable DeleteByCompanyID(int?CompanyID)
{
this.Adapter.SelectCommand = this.CommandCollection[1];
if (CompanyID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.NewInvoiceEmailTemplateDataTable dataTable = new CloudAccountDA.NewInvoiceEmailTemplateDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
private void SetCompanyRecords(string companyID)
{
this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(int.Parse(companyID));
if (this.objNewInvoiceEmailTemplateDT.Rows.Count > 0)
{
this.hfEmailID.Value = this.objNewInvoiceEmailTemplateDT.Rows[0]["NewInvoiceEmailTemplateID"].ToString();
this.hfCompanyID.Value = this.objNewInvoiceEmailTemplateDT.Rows[0]["CompanyID"].ToString();
this.txtSubject.Text = this.objNewInvoiceEmailTemplateDT.Rows[0]["EmailSubject"].ToString();
this.txtBody.Text = this.objNewInvoiceEmailTemplateDT.Rows[0]["EmailBody"].ToString();
this.txtBody.Text = this.txtBody.Text.Replace(" ", " ");
this.txtBody.Text = this.txtBody.Text.Replace("<br />", "\n");
}
else
{
this.objNewInvoiceEmailTemplateBll.AddInvoiceTemplate(int.Parse(companyID), "New invoice ##invoiceNumber## from ##companyName## , sent using Bill Transact", this.strBody.ToString());
this.Response.Redirect("NewInvoiceEmailTemplate.aspx");
}
}
private void SendMail(string email, string invoiceNum, int invoiceId, int clientId, int companyID)
{
this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(invoiceId);
string str1 = this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"].ToString();
string s1 = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString();
string s2 = this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString();
Decimal num = Decimal.Parse(s1) - Decimal.Parse(s2);
this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(companyID);
string displayName = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString().ToUpper();
string addresses = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString();
string str2 = string.Empty;
string str3 = string.Empty;
string str4 = string.Empty;
string str5 = string.Empty;
this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(clientId);
if (this.objCompanyClientMasterDT.Rows.Count > 0)
{
string username = this.objCompanyClientMasterDT.Rows[0]["UserName"].ToString();
str3 = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString();
str4 = this.objCompanyClientMasterDT.Rows[0]["FirstName"].ToString();
str5 = this.objCompanyClientMasterDT.Rows[0]["LastName"].ToString();
email = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString();
MembershipUser user = Membership.GetUser(username);
if (user != null)
{
string key1 = MemberArea.GenerateCode();
string str6 = HttpUtility.UrlEncode(this.Encrypt(user.UserName, key1));
string password = user.GetPassword();
string key2 = MemberArea.GenerateCode();
string str7 = HttpUtility.UrlEncode(this.Encrypt(password, key2));
str2 = string.Format("https://www.billtransact.com/CheckClient.aspx?page=invoice&anyId={0}&name={1}&tech={2}&keyname={3}&keytech={4}", (object)invoiceId, (object)str6, (object)str7, (object)key1, (object)key2);
}
}
string str8 = string.Empty;
string str9 = string.Empty;
string address = "*****@*****.**";
this.objSMTPSettingsDT = this.objSMTPSettingsBll.GetDataByCompanyID(companyID);
if (this.objSMTPSettingsDT.Rows.Count > 0)
{
str9 = this.objSMTPSettingsDT.Rows[0]["EmailSignature"].ToString();
address = this.objSMTPSettingsDT.Rows[0]["SMTPFrom"].ToString();
}
this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(companyID);
if (this.objNewInvoiceEmailTemplateDT.Rows.Count > 0)
{
str8 = this.objNewInvoiceEmailTemplateDT.Rows[0]["EmailBody"].ToString();
}
Hashtable Variables = new Hashtable()
{
{
(object)"emailTemplate",
(object)str8
},
{
(object)"companyName",
(object)displayName
},
{
(object)"companyEmail",
(object)("<a href=\"mailto:" + addresses + "\">" + addresses + "</a>")
},
{
(object)"invoiceNumber",
(object)str1
},
{
(object)"amountOwned",
(object)num
},
{
(object)"clientOrgName",
(object)str3
},
{
(object)"firstName",
(object)str4
},
{
(object)"lastName",
(object)str5
},
{
(object)"invoiceAmt",
(object)s1
},
{
(object)"someLink",
(object)str2
},
{
(object)"directLink",
(object)"block"
},
{
(object)"branding",
(object)"block"
},
{
(object)"emailSign",
(object)str9
}
};
Parser parser1 = new Parser(this.Server.MapPath("~/MailTemplate/SendInvoiceNew.html"), Variables);
string path1 = this.Server.MapPath("~\\TempHTMLFiles\\");
File.WriteAllText(Path.Combine(path1, "Invoice.html"), parser1.Parse());
Parser parser2 = new Parser(path1 + "Invoice.html", Variables);
try
{
MailMessage message = new MailMessage()
{
From = new MailAddress(address, displayName)
};
message.To.Add(new MailAddress(email));
message.ReplyToList.Add(addresses);
message.Subject = "New invoice " + invoiceNum + " from " + displayName + ", sent using Bill Transact";
message.BodyEncoding = Encoding.UTF8;
message.Body = parser2.Parse();
message.IsBodyHtml = true;
SmtpClientForCompany.smtpClient(companyID.ToString()).Send(message);
}
catch (Exception ex)
{
}
}
private void SetNewDefaultValues()
{
MembershipUser user = Membership.GetUser();
if (user != null)
{
string str = user.ToString();
if (Roles.IsUserInRole(str, "Admin"))
{
this.objCompanyLoginMasterDT = this.objCompanyLoginMasterBll.GetDataByCompanyLoginName(str);
if (this.objCompanyLoginMasterDT.Rows.Count > 0)
{
this.hfCompanyID.Value = this.objCompanyLoginMasterDT.Rows[0]["CompanyID"].ToString();
}
}
else if (Roles.IsUserInRole(str, "Employee"))
{
this.objStaffMasterDT = this.objStaffMasterBll.GetDataByStaffUserName(str);
if (this.objStaffMasterDT.Rows.Count > 0)
{
this.hfCompanyID.Value = this.objStaffMasterDT.Rows[0]["CompanyID"].ToString();
}
}
}
int num = 30;
this.objFreePackageSettingsDT = this.objFreePackageSettingsBll.GetAllDetail();
if (this.objFreePackageSettingsDT.Rows.Count > 0)
{
num = int.Parse(this.objFreePackageSettingsDT.Rows[0]["FreePackageDays"].ToString());
}
this.objCompanyPackageMasterDT = this.objCompanyPackageMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objCompanyPackageMasterDT.Rows.Count == 0)
{
this.objCompanyPackageMasterBll.AddCompanyPackage(int.Parse(this.hfCompanyID.Value), 0, new DateTime?(DateTime.Now), new DateTime?(DateTime.Now.AddDays((double)num)), "FREE", new Decimal?(new Decimal(0)), "NONE", new DateTime?(), new DateTime?(DateTime.Now), true);
}
this.objAdminPermissionMasterDT = this.objAdminPermissionMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objAdminPermissionMasterDT.Rows.Count == 0)
{
this.objAdminPermissionMasterBll.AddAdminPermission(int.Parse(this.hfCompanyID.Value), true, true, true, false, false);
}
this.objMiscellaneousMasterDT = this.objMiscellaneousMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objMiscellaneousMasterDT.Rows.Count == 0)
{
this.objMiscellaneousMasterBll.AddMiscellaneous(int.Parse(this.hfCompanyID.Value), 15, "MM/dd/yyyy", true, true, true, "", true, false, "Both", "", "", "None", "Read/Write", 30, 10);
}
this.objClientPermissionMasterDT = this.objClientPermissionMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objClientPermissionMasterDT.Rows.Count == 0)
{
this.objClientPermissionMasterBll.AddClientPermission(int.Parse(this.hfCompanyID.Value), true, true, true, false, false, true, true);
}
this.objStaffPermissionMasterDT = this.objStaffPermissionMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objStaffPermissionMasterDT.Rows.Count == 0)
{
this.objStaffPermissionMasterBll.AddStaffPermission(int.Parse(this.hfCompanyID.Value), true, true, true, true, true, false, false, true, true, true, true, true);
}
this.objTemplateSettingsDT = this.objTemplateSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objTemplateSettingsDT.Rows.Count == 0)
{
this.objTemplateSettingsBll.AddTemplateSettings(int.Parse(this.hfCompanyID.Value), 1, "Invoice", "Estimate", "Credit", true);
}
this.objEmailNotificationsDT = this.objEmailNotificationsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objEmailNotificationsDT.Rows.Count == 0)
{
this.objEmailNotificationsBll.AddEmailNotifications(int.Parse(this.hfCompanyID.Value), true, false, false, false);
}
this.objSMTPSettingsDT = this.objSMTPSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objSMTPSettingsDT.Rows.Count == 0)
{
this.objSMTPSettingsBll.AddSMTPSettings(int.Parse(this.hfCompanyID.Value), Common.CommonHandler.BaseMailFrom, Common.CommonHandler.BaseHost, Convert.ToInt32(Common.CommonHandler.BasePort), Common.CommonHandler.BaseEnableSSL, Common.CommonHandler.BasePassword, Common.CommonHandler.BaseUserName, "Best regards,<br />##companyName## (##companyEmail##)");
}
this.objNewClientEmailTemplateDT = this.objNewClientEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewClientEmailTemplateDT.Rows.Count == 0)
{
this.objNewClientEmailTemplateBll.AddClientTemplate(int.Parse(this.hfCompanyID.Value), "##companyName## is now invoicing you with Bill Transact", new StringBuilder("Welcome to ##companyName##'s secure online services. An account has been created for you.<br />To securely access your account, go to:<br />##login link##<br />Login using the following username and password:<br />Username: ##username##<br />Password: ##password##<br />").ToString());
}
this.objNewCreditEmailTemplateDT = this.objNewCreditEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewCreditEmailTemplateDT.Rows.Count == 0)
{
this.objNewCreditEmailTemplateBll.AddCreditTemplate(int.Parse(this.hfCompanyID.Value), "New Credit ##creditNumber## from ##companyName## , sent using Bill Transact", new StringBuilder("You have received credit in the amount of ##paymentAmt##. To view it and download a PDF copy for your records, click the link below.<br /><br />##creditLink##<br />").ToString());
}
this.objNewEstimateEmailTemplateDT = this.objNewEstimateEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewEstimateEmailTemplateDT.Rows.Count == 0)
{
this.objNewEstimateEmailTemplateBll.AddEstimateTemplate(int.Parse(this.hfCompanyID.Value), "New Estimate ##estimateNumber## from ##companyName## , sent using Bill Transact", new StringBuilder("To access your estimate from ##companyName## for ##paymentAmt##, go to:<br /><br /> ##estimateLink##<br />").ToString());
}
this.objNewInvoiceEmailTemplateDT = this.objNewInvoiceEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewInvoiceEmailTemplateDT.Rows.Count == 0)
{
this.objNewInvoiceEmailTemplateBll.AddInvoiceTemplate(int.Parse(this.hfCompanyID.Value), "New invoice ##invoiceNumber## from ##companyName## , sent using Bill Transact", new StringBuilder("To view your invoice from ##companyName## for ##invoiceAmt##, or to download a PDF copy for your records, click the link below:<br /><br />##someLink##<br /><br />").ToString());
}
this.objNewStaffEmailTemplateDT = this.objNewStaffEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objNewStaffEmailTemplateDT.Rows.Count == 0)
{
this.objNewStaffEmailTemplateBll.AddStaffTemplate(int.Parse(this.hfCompanyID.Value), "##companyName## invites you to track time and expenses in Bill Transact", new StringBuilder("You are now part of ##companyName##'s team.<br />Click here to log in to your account:<br />##login link##<br /><br />Username: ##username##<br />Password: ##password##<br />").ToString());
}
this.objNewPaymentEmailTemplateDT = this.objNewPaymentEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "online");
if (this.objNewPaymentEmailTemplateDT.Rows.Count == 0)
{
this.objNewPaymentEmailTemplateBll.AddPaymentTemplate(int.Parse(this.hfCompanyID.Value), "online", true, "##companyName## has received your payment for invoice ##invoiceNumber## in Bill Transact", new StringBuilder("Thank you for your business.<br />We have received your payment in the amount of ##payment amount## for invoice ##invoice number##.<br />To view the paid invoice or download a PDF copy for your records, click the link below:<br /><br />##someLink##<br />").ToString());
}
this.objNewPaymentEmailTemplateDT = this.objNewPaymentEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "other");
if (this.objNewPaymentEmailTemplateDT.Rows.Count == 0)
{
this.objNewPaymentEmailTemplateBll.AddPaymentTemplate(int.Parse(this.hfCompanyID.Value), "other", false, "##companyName## has received your payment for invoice ##invoiceNumber## in Bill Transact", new StringBuilder("Thank you for your business.<br />We have received your payment in the amount of ##payment amount## for invoice ##invoice number##.<br />To view the paid invoice or download a PDF copy for your records, click the link below:<br /><br />##someLink##<br />").ToString());
}
this.objLatePaymentReminderTemplateDT = this.objLatePaymentReminderTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), 1);
if (this.objLatePaymentReminderTemplateDT.Rows.Count == 0)
{
this.objLatePaymentReminderTemplateBll.AddLatePaymentReminder(int.Parse(this.hfCompanyID.Value), 1, false, 30, "Your payment for invoice ##invoiceNumber## is overdue in Bill Transact", new StringBuilder("Your invoice is now 30 days overdue. Please pay your invoice.<br /><br />To access your invoice from ##companyName##, go to:<br /><br />##someLink##<br />").ToString());
}
this.objLatePaymentReminderTemplateDT = this.objLatePaymentReminderTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), 2);
if (this.objLatePaymentReminderTemplateDT.Rows.Count == 0)
{
this.objLatePaymentReminderTemplateBll.AddLatePaymentReminder(int.Parse(this.hfCompanyID.Value), 2, false, 60, "Your payment for invoice ##invoiceNumber## is overdue in Bill Transact", new StringBuilder("Your invoice is now 60 days overdue. Please pay your invoice.<br /><br />To access your invoice from ##companyName##, go to:<br /><br />##someLink##<br />").ToString());
}
this.objLatePaymentReminderTemplateDT = this.objLatePaymentReminderTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), 3);
if (this.objLatePaymentReminderTemplateDT.Rows.Count == 0)
{
this.objLatePaymentReminderTemplateBll.AddLatePaymentReminder(int.Parse(this.hfCompanyID.Value), 3, false, 90, "Your payment for invoice ##invoiceNumber## is overdue in Bill Transact", new StringBuilder("Your invoice is now 90 days overdue. Please pay your invoice.<br /><br />To access your invoice from ##companyName##, go to:<br /><br />##someLink##<br />").ToString());
}
this.objAutoBillEmailTemplateDT = this.objAutoBillEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "Auto-bill");
if (this.objAutoBillEmailTemplateDT.Rows.Count == 0)
{
this.objAutoBillEmailTemplateBll.AddAutoBillEmail(int.Parse(this.hfCompanyID.Value), "Auto-bill", true, "New recurring invoice ##invoiceNumber## from ##companyName##, sent using Bill Transact", this.strBodyBill.ToString());
}
this.objAutoBillEmailTemplateDT = this.objAutoBillEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "Auto-paid");
if (this.objAutoBillEmailTemplateDT.Rows.Count == 0)
{
this.objAutoBillEmailTemplateBll.AddAutoBillEmail(int.Parse(this.hfCompanyID.Value), "Auto-paid", true, "New recurring invoice ##invoiceNumber## from ##companyName##, sent using Bill Transact", this.strBodyPaid.ToString());
}
this.objAutoBillEmailTemplateDT = this.objAutoBillEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "Card Expired");
if (this.objAutoBillEmailTemplateDT.Rows.Count == 0)
{
this.objAutoBillEmailTemplateBll.AddAutoBillEmail(int.Parse(this.hfCompanyID.Value), "Card Expired", true, "Action required: Your credit card on file with ##companyName## is expiring soon in Bill Transact", this.strBodyExpired.ToString());
}
this.objAutoBillEmailTemplateDT = this.objAutoBillEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "Card Failed");
if (this.objAutoBillEmailTemplateDT.Rows.Count != 0)
{
return;
}
this.objAutoBillEmailTemplateBll.AddAutoBillEmail(int.Parse(this.hfCompanyID.Value), "Card Failed", false, "Action required: Your credit card on file for invoice ##invoiceNumber## from ##companyName## needs updating in Bill Transact", this.strBodyFailed.ToString());
}
public virtual int Update(CloudAccountDA.NewInvoiceEmailTemplateDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
