protected void btnDelete_Click(object sender, EventArgs e) { int num = 0; for (int index = 0; index < this.gvPayment.Rows.Count; ++index) { CheckBox checkBox = (CheckBox)this.gvPayment.Rows[index].Cells[0].FindControl("chkID"); if (checkBox.Checked) { ++num; this.objPaymentMasterDT = this.objPaymentMasterBll.GetDataByPaymentID(int.Parse(checkBox.ToolTip)); if (this.objPaymentMasterDT.Rows.Count > 0) { string s1 = this.objPaymentMasterDT.Rows[0]["InvoiceID"].ToString(); string s2 = this.objPaymentMasterDT.Rows[0]["PaymentAmount"].ToString(); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(s1)); if (this.objInvoiceMasterDT.Rows.Count > 0) { this.objInvoiceMasterBll.UpdatePaidToDate(new Decimal?(Decimal.Round(Decimal.Parse(this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString()) - Decimal.Parse(s2), 2)), int.Parse(s1)); } } this.objPaymentMasterBll.DeletePayment(int.Parse(checkBox.ToolTip)); } } if (num == 0) { this.DisplayAlert("No Payments were selected."); } else { this.Response.Redirect("PaymentMaster.aspx"); } }
protected string GetInvoiceNumber(string invoiceid) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(invoiceid)); if (this.objInvoiceMasterDT.Rows.Count > 0) { return("Invoice " + this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"]); } return(""); }
protected string GetCurrency(string invId) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(invId)); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { return("(" + this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"] + ")"); } return(""); }
private void SetInvoiceRecord(string sId) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(sId)); if (this.objInvoiceMasterDT.Rows.Count <= 0) { return; } this.hfInvoiceID.Value = this.objInvoiceMasterDT.Rows[0]["InvoiceID"].ToString(); this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())); if (this.objCurrencyMasterDT.Rows.Count > 0) { this.lblCurrencyCode.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); } this.lblInvoiceAmt.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); Label label1 = this.lblBalance; Label label2 = this.lblInvoiceAmt; Decimal num = Decimal.Round(Decimal.Parse(this.lblInvoiceAmt.Text), 2); string str1; string str2 = str1 = num.ToString(); label2.Text = str1; string str3 = str2; label1.Text = str3; this.gvPaymentOld.DataBind(); this.divOldData.Visible = this.gvPaymentOld.Rows.Count > 0; if (this.gvPaymentOld.Rows.Count > 0) { Decimal d = new Decimal(0); for (int index = 0; index < this.gvPaymentOld.Rows.Count; ++index) { string text = this.gvPaymentOld.Rows[index].Cells[3].Text; d += Decimal.Parse(text); } this.lblTotalPaid.Text = Decimal.Round(d, 2).ToString(); } this.lblBalance.Text = (Decimal.Parse(this.lblInvoiceAmt.Text) - Decimal.Parse(this.lblTotalPaid.Text)).ToString(); this.lblBalance.Text = Decimal.Round(Decimal.Parse(this.lblBalance.Text), 2).ToString(); this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString())); string newValue = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); this.lblPaymentInfo.Text = "Invoice #" + this.GetInvoiceNumber(sId).Replace("Invoice", "") + " for " + newValue; this.chkEmail.Text = this.chkEmail.Text.Replace("company", newValue); }
protected void gvPayment_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(e.Row.Cells[1].Text)); if (this.objInvoiceMasterDT.Rows.Count > 0) { this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString())); e.Row.Cells[1].Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); } } BoundField boundField = ((GridView)sender).Columns[4] as BoundField; if (boundField == null) { return; } boundField.DataFormatString = "{0:" + this.dateFormat + "}"; }
private void SetRecord(string id) { this.objPaymentMasterDT = this.objPaymentMasterBll.GetDataByPaymentID(int.Parse(id)); if (this.objPaymentMasterDT.Rows.Count <= 0) { return; } this.hfPaymentID.Value = this.objPaymentMasterDT.Rows[0]["PaymentID"].ToString(); this.hfCompanyID.Value = this.objPaymentMasterDT.Rows[0]["CompanyID"].ToString(); this.hfInvoiceID.Value = this.objPaymentMasterDT.Rows[0]["InvoiceID"].ToString(); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(this.hfInvoiceID.Value)); if (this.objInvoiceMasterDT.Rows.Count > 0) { this.hfInvoiceID.Value = this.objInvoiceMasterDT.Rows[0]["InvoiceID"].ToString(); this.lblInvoiceAmt.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); this.lblInvoiceAmt.Text = Decimal.Round(Decimal.Parse(this.lblInvoiceAmt.Text), 2).ToString(); } this.txtPayment.Text = this.objPaymentMasterDT.Rows[0]["PaymentAmount"].ToString(); this.txtPayment.Text = Decimal.Round(Decimal.Parse(this.txtPayment.Text), 2).ToString(); this.txtPaymentDate.Text = DateTime.Parse(this.objPaymentMasterDT.Rows[0]["Date"].ToString()).ToString("MM/dd/yyyy"); this.txtPaymentNote.Text = this.objPaymentMasterDT.Rows[0]["Notes"].ToString(); this.ddlMethod.SelectedIndex = this.ddlMethod.Items.IndexOf(this.ddlMethod.Items.FindByText(this.objPaymentMasterDT.Rows[0]["Method"].ToString())); }
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 CallAllRecurringInvoice() { this.objRecurringMasterDT = this.objRecurringMasterBll.GetAllActiveTodayRecurring(); if (this.objRecurringMasterDT.Rows.Count <= 0) { return; } for (int index = 0; index < this.objRecurringMasterDT.Rows.Count; ++index) { int iRecurringID = int.Parse(this.objRecurringMasterDT.Rows[index]["RecurringID"].ToString()); int num1 = int.Parse(this.objRecurringMasterDT.Rows[index]["CompanyID"].ToString()); int num2 = int.Parse(this.objRecurringMasterDT.Rows[index]["ClientID"].ToString()); int iFrequencyID = int.Parse(this.objRecurringMasterDT.Rows[index]["HowOften"].ToString()); DateTime dtNextDate = DateTime.Parse(this.objRecurringMasterDT.Rows[index]["NextDate"].ToString()); string str1 = this.objRecurringMasterDT.Rows[index]["RemainingInvoice"].ToString(); bool bRecurringActive = true; string s; try { s = int.Parse(str1.Trim()).ToString(); } catch (Exception ex) { s = "-1"; } this.objFrequencyMasterDT = this.objFrequencyMasterBll.GetDataByFrequencyID(iFrequencyID); if (this.objFrequencyMasterDT.Rows.Count > 0) { int num3 = int.Parse(this.objFrequencyMasterDT.Rows[0]["NoOfDays"].ToString()); dtNextDate = dtNextDate.AddDays((double)num3); } string sRemainingInvoice; switch (s) { case "-1": sRemainingInvoice = "infinite"; break; default: sRemainingInvoice = (int.Parse(s) - 1).ToString(); if (sRemainingInvoice == "0") { bRecurringActive = false; break; } break; } this.objRecurringMasterBll.UpdateForSentInvoice(iRecurringID, sRemainingInvoice, dtNextDate, bRecurringActive); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByCompanyID(num1); string str2 = this.objInvoiceMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : InvoiceMaster.NextNum(this.objInvoiceMasterDT.Rows[this.objInvoiceMasterDT.Rows.Count - 1]["InvoiceNumber"].ToString()); int num4 = this.objInvoiceMasterBll.AddInvoice(str2, iRecurringID); this.objRecurringItemDetailDT = this.objRecurringItemDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringItemDetailDT.Rows.Count > 0) { this.objInvoiceItemDetailBll.AddInvoiceItem(num4, iRecurringID); } this.objRecurringTaskDetailDT = this.objRecurringTaskDetailBll.GetDataByRecurringID(iRecurringID); if (this.objRecurringTaskDetailDT.Rows.Count > 0) { this.objInvoiceTaskDetailBll.AddInvoiceTask(num4, iRecurringID); } this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(num2); if (this.objCompanyClientMasterDT.Rows.Count > 0) { this.SendMail(this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(), str2, num4, num2, num1); } } }
private void ViewRecord(string id) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(id)); if (this.objInvoiceMasterDT.Rows.Count <= 0) { return; } this.hfCompanyID.Value = this.objInvoiceMasterDT.Rows[0]["CompanyID"].ToString(); this.hfInvoiceID.Value = this.objInvoiceMasterDT.Rows[0]["InvoiceID"].ToString(); this.lblInvoiceNum.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"].ToString(); this.lblTerms.Text = this.objInvoiceMasterDT.Rows[0]["Terms"].ToString(); this.lblNotes.Text = this.objInvoiceMasterDT.Rows[0]["Notes"].ToString(); this.lblInvoiceNumHead.Text = "Invoice: " + this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"]; this.lblInvoiceDate.Text = DateTime.Parse(this.objInvoiceMasterDT.Rows[0]["InvoiceDate"].ToString()).ToString("MMMM dd, yyyy"); this.lblPONumber.Text = this.objInvoiceMasterDT.Rows[0]["PONumber"].ToString(); string s1 = this.objInvoiceMasterDT.Rows[0]["Discount"].ToString(); this.lblDiscout.Text = s1.Length > 0 ? s1 : "0.00"; this.lblInvoiceTotalView.Text = Decimal.Round(Decimal.Parse(this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString()), 2).ToString(); this.lblPaidToDateView.Text = "0";// Decimal.Round(Decimal.Parse(this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString()), 2).ToString(); Label label1 = this.lblInvoiceAmount; Label label2 = this.lblAmountDue; Decimal num1 = Decimal.Parse(this.lblInvoiceTotalView.Text) - Decimal.Parse(this.lblPaidToDateView.Text); string str1; string str2 = str1 = num1.ToString(); label2.Text = str1; string str3 = str2; label1.Text = str3; Label label3 = this.lblInvoiceAmount; Label label4 = this.lblAmountDue; Decimal num2 = Decimal.Round(Decimal.Parse(this.lblAmountDue.Text), 2); string str4; string str5 = str4 = num2.ToString(); label4.Text = str4; string str6 = str5; label3.Text = str6; this.divTaxValueView.Controls.Clear(); this.divTaxView.Controls.Clear(); Hashtable hashtable = new Hashtable(); if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text1 = this.gvTaskView.Rows[index].Cells[2].Text; string text2 = this.gvTaskView.Rows[index].Cells[3].Text; string text3 = this.gvTaskView.Rows[index].Cells[4].Text; string text4 = this.gvTaskView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvTaskView.Rows[index].Cells[4].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvTaskView.Rows[index].Cells[5].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } } } catch (Exception ex) { this.gvTaskView.Rows[index].Cells[4].Text = ""; this.gvTaskView.Rows[index].Cells[5].Text = ""; } } } if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text1 = this.gvItemView.Rows[index].Cells[2].Text; string text2 = this.gvItemView.Rows[index].Cells[3].Text; string text3 = this.gvItemView.Rows[index].Cells[4].Text; string text4 = this.gvItemView.Rows[index].Cells[5].Text; try { if (!string.IsNullOrEmpty(text3) && !text3.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvItemView.Rows[index].Cells[4].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } if (!string.IsNullOrEmpty(text4)) { if (!text4.Contains("&")) { this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4); if (this.objTaxMasterDT.Rows.Count > 0) { string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString(); Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100); Label label5 = new Label() { Text = this.gvItemView.Rows[index].Cells[5].Text + "(" + s2 + ")" }; Label label6 = new Label() { Text = string.Concat((object)Decimal.Round(d, 2)) }; if (hashtable.ContainsKey((object)label5.Text)) { object obj = hashtable[(object)label5.Text]; Decimal num3 = d + Decimal.Parse(obj.ToString()); hashtable.Remove((object)label5.Text); hashtable.Add((object)label5.Text, (object)num3.ToString()); } else { hashtable.Add((object)label5.Text, (object)label6.Text); } } } } } catch (Exception ex) { this.gvItemView.Rows[index].Cells[4].Text = ""; this.gvItemView.Rows[index].Cells[5].Text = ""; } } } if (hashtable.Count > 0) { foreach (string str7 in (IEnumerable)hashtable.Keys) { this.divTaxView.Controls.Add((Control) new Label() { Text = str7 }); this.divTaxView.Controls.Add((Control) new LiteralControl("<br />")); } foreach (object obj in (IEnumerable)hashtable.Values) { this.divTaxValueView.Controls.Add((Control) new Label() { Text = ("+" + (object)Decimal.Round(Decimal.Parse(obj.ToString()), 2)) }); this.divTaxValueView.Controls.Add((Control) new LiteralControl("<br />")); } } Decimal d1 = new Decimal(0); if (this.gvItemView.Rows.Count > 0) { for (int index = 0; index < this.gvItemView.Rows.Count; ++index) { string text = this.gvItemView.Rows[index].Cells[6].Text; d1 += Decimal.Parse(text); } } if (this.gvTaskView.Rows.Count > 0) { for (int index = 0; index < this.gvTaskView.Rows.Count; ++index) { string text = this.gvTaskView.Rows[index].Cells[6].Text; d1 += Decimal.Parse(text); } } Label label7 = this.lblSubTotalView; num2 = Decimal.Round(d1, 2); string str8 = num2.ToString(); label7.Text = str8; Label label8 = this.lblDiscountAmt; num2 = Decimal.Parse(this.lblSubTotalView.Text) * Decimal.Parse(s1) / new Decimal(100); string str9 = num2.ToString(); label8.Text = str9; Label label9 = this.lblDiscountAmt; num2 = Decimal.Round(Decimal.Parse(this.lblDiscountAmt.Text), 2); string str10 = num2.ToString(); label9.Text = str10; this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); this.imgLogo.ImageUrl = "../Handler/CompanyLogoFile.ashx?id=" + this.objCompanyMasterDT.Rows[0]["CompanyID"]; this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString(); string str11 = string.Empty; if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str11 = str11 + this.objCityMasterDT.Rows[0]["CityName"] + " - "; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString())) { str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyZipCode"] + ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str11 = str11 + this.objStateMasterDT.Rows[0]["StateName"] + ",<br />"; } } if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString())); if (this.objCountryMasterDT.Rows.Count > 0) { str11 = str11 + this.objCountryMasterDT.Rows[0]["CountryName"] + ".<br />"; } } this.lblCompanyAddress.Text = str11; Label label10 = this.lblCompanyAddress; string str12 = label10.Text + (object)"Email: <a href=\"mailto:" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "\">" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "</a><br />"; label10.Text = str12; Label label11 = this.lblCompanyAddress; string str13 = label11.Text + (object)"Phone: " + (string)this.objCompanyMasterDT.Rows[0]["CompanyPhone"]; label11.Text = str13; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientId"].ToString())); this.lblClientOrganizationName.Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString(); this.lblClientFullName.Text = (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"]; string str14 = string.Empty + this.objCompanyClientMasterDT.Rows[0]["Address1"] + " "; if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["Address1"].ToString())) { str14 += ",<br />"; } string str15 = str14 + this.objCompanyClientMasterDT.Rows[0]["Address2"] + " "; if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["Address2"].ToString())) { str15 += ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())) { this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString())); if (this.objCityMasterDT.Rows.Count > 0) { str15 = str15 + this.objCityMasterDT.Rows[0]["CityName"] + " - "; } } string str16 = str15 + this.objCompanyClientMasterDT.Rows[0]["ZipCode"].ToString(); if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["ZipCode"].ToString())) { str16 += ",<br />"; } if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())) { this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString())); if (this.objStateMasterDT.Rows.Count > 0) { str16 = str16 + this.objStateMasterDT.Rows[0]["StateName"] + " "; } } if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())) { this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString())); str16 = str16 + this.objCountryMasterDT.Rows[0]["CountryName"] + "."; } this.lblClientAddress.Text = str16; this.divStatus.Attributes.Add("class", "status-" + this.SetStatus(this.objInvoiceMasterDT.Rows[0]["InvoiceStatus"].ToString())); string s3 = this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString(); if (string.IsNullOrEmpty(s3)) { return; } this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s3)); if (this.objCurrencyMasterDT.Rows.Count <= 0) { return; } this.lblCurCodeView1.Text = this.lblCurCodeView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString(); this.lblCurSymbolView1.Text = this.lblCurSymbolView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string invoiceId = InvoiceIOPayment.Decrypt(HttpUtility.UrlDecode(this.Request.QueryString["invoice"]), this.Request.QueryString["val"]); objInvoiceMasterDT = objInvoiceMasterBLL.GetDataByInvoiceID(Convert.ToInt32(invoiceId)); if (objInvoiceMasterDT?.Rows.Count > 0) { var request = (HttpWebRequest)WebRequest.Create("http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx"); string str = Convert.ToString(objInvoiceMasterDT.Rows[0]["CompanyID"]); if (!string.IsNullOrEmpty(str)) { Dbutility objDbutility = new Dbutility(); str = " Select ProductID,MerchantID,MerchantAuthkey,TransactionTypeID,TransactionAuthkey " + "From CompanyIOPayerMaster Where CompanyID=" + str; DataTable dtCompanyIOMaster = objDbutility.BindDataTable(str); if (dtCompanyIOMaster.Rows.Count > 0) { string MerchantID = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantID"]); string ProductID = Convert.ToString(dtCompanyIOMaster.Rows[0]["ProductID"]); string TransactionTypeID = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionTypeID"]); string MerchantAuthKey = Convert.ToString(dtCompanyIOMaster.Rows[0]["MerchantAuthkey"]); string TranAuthKey = Convert.ToString(dtCompanyIOMaster.Rows[0]["TransactionAuthkey"]); string ReturnURL = ConfigurationManager.AppSettings["SuccessClientURL"]; string ExtraParam1 = ""; string ExtraParam2 = ""; string ExtraParam3 = ""; string invoiceno = DateTime.Now.ToString("dd MM yyyy HH:mm:ss"); invoiceno = invoiceno.Replace(":", string.Empty); invoiceno = Regex.Replace(invoiceno, "\\s", string.Empty); invoiceno += Convert.ToString(objInvoiceMasterDT.Rows[0]["InvoiceNumber"]) + "BT"; str = "Update InvoiceMaster Set OrderNo='" + invoiceno + "' Where InvoiceID=" + invoiceId; objDbutility.ExecuteQuery(str); var postData = "MerchantID=" + Uri.EscapeDataString(MerchantID); postData += "&ProductID=" + Uri.EscapeDataString(ProductID); postData += "&TransactionTypeID=" + Uri.EscapeDataString(TransactionTypeID); postData += "&MerchantAuthKey=" + Uri.EscapeDataString(MerchantAuthKey); postData += "&TranAuthKey=" + Uri.EscapeDataString(TranAuthKey); postData += "&OrderAmount=" + Uri.EscapeDataString(Convert.ToString(objInvoiceMasterDT.Rows[0]["InvoiceTotal"])); postData += "&ReturnURL=" + Uri.EscapeDataString(ReturnURL); postData += "&OrderNo=" + Uri.EscapeDataString(invoiceno); postData += "&ExtraParam1=" + Uri.EscapeDataString(ExtraParam1); postData += "&ExtraParam2=" + Uri.EscapeDataString(ExtraParam2); postData += "&ExtraParam3=" + Uri.EscapeDataString(ExtraParam3); var data = Encoding.ASCII.GetBytes(postData); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.ContentLength = data.Length; using (var stream = request.GetRequestStream()) { stream.Write(data, 0, data.Length); } Response.Clear(); var response = (HttpWebResponse)request.GetResponse(); var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd(); string strResultnew = responseString.Replace("./IOPayerPaymentGateway.aspx", "http://www.iopayer.com/iopg/IOPayerPaymentGateway.aspx"); Response.Write(strResultnew); return; } else { Response.Redirect("~/Client/InvoiceNoPayment.aspx?companyid=" + Convert.ToString(objInvoiceMasterDT.Rows[0]["CompanyID"])); } } } else { this.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "<script language=\"JavaScript\">" + "alert('Invoice details not found!');" + "</script>"); } } }
private async Task SendMailNew(int paymentID) { this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); string displayName = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString().ToUpper(); string addresses = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString(); this.objPaymentMasterDT = this.objPaymentMasterBll.GetDataByPaymentID(paymentID); string s1 = this.objPaymentMasterDT.Rows[0]["InvoiceID"].ToString(); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(s1)); string str1 = this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"].ToString(); string s2 = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); //string s3 = this.objInvoiceMasterDT.Rows[0]["PaidToDate"].ToString(); //Decimal num = Decimal.Parse(s2) - Decimal.Parse(s3); Decimal num = Decimal.Parse(s2); string s4 = this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString(); string str2 = string.Empty; string address1 = string.Empty; string str3 = string.Empty; string str4 = string.Empty; string str5 = string.Empty; this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(s4)); 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(); address1 = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString(); MembershipUser user = Membership.GetUser(username); if (user != null) { string key1 = PaymentMaster.GenerateCode(); string str6 = HttpUtility.UrlEncode(this.Encrypt(user.UserName, key1)); string password = user.GetPassword(); string key2 = PaymentMaster.GenerateCode(); string str7 = HttpUtility.UrlEncode(this.Encrypt(password, key2)); str2 = string.Format("{5}/CheckClient.aspx?page=invoice&anyId={0}&name={1}&tech={2}&keyname={3}&keytech={4}", (object)s1, (object)str6, (object)str7, (object)key1, (object)key2, Common.CommonHandler.WebsiteBaseURL); } } string str8 = string.Empty; string str9 = string.Empty; string address2 = "*****@*****.**"; this.objSMTPSettingsDT = this.objSMTPSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); if (this.objSMTPSettingsDT.Rows.Count > 0) { str9 = this.objSMTPSettingsDT.Rows[0]["EmailSignature"].ToString(); address2 = this.objSMTPSettingsDT.Rows[0]["SMTPFrom"].ToString(); } this.objNewPaymentEmailTemplateDT = this.objNewPaymentEmailTemplateBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value), "other"); if (this.objNewPaymentEmailTemplateDT.Rows.Count > 0) { str8 = this.objNewPaymentEmailTemplateDT.Rows[0]["EmailBody"].ToString(); } Hashtable Variables = new Hashtable() { { (object)"company", (object)displayName }, { (object)"companyName", (object)displayName }, { (object)"invoiceNum", (object)str1 }, { (object)"invoiceNumber", (object)str1 }, { (object)"someLink", (object)str2 }, { (object)"emailTemplate", (object)str8 }, { (object)"companyEmail", (object)("<a href=\"mailto:" + addresses + "\">" + addresses + "</a>") }, { (object)"amountOwned", (object)num }, { (object)"clientOrgName", (object)str3 }, { (object)"firstName", (object)str4 }, { (object)"lastName", (object)str5 }, { (object)"invoiceAmt", (object)s2 }, { (object)"directLink", (object)this.directLink }, { (object)"branding", (object)this.branding }, { (object)"emailSign", (object)str9 }, { (object)"loginLink", (object)"<a target=\"_blank\" href=\"http://www.billtransact.com/MemberArea.aspx\">https://www.billtransact.com/MemberArea.aspx</a>" } }; Parser parser1 = new Parser(this.Server.MapPath("~/MailTemplate/PaymentInformationNew.html"), Variables); string path1 = this.Server.MapPath("~\\TempHTMLFiles\\"); File.WriteAllText(Path.Combine(path1, "Payment.html"), parser1.Parse()); Parser parser2 = new Parser(path1 + "Payment.html", Variables); try { //MailMessage message = new MailMessage() //{ // From = new MailAddress(address2, displayName) //}; //message.To.Add(new MailAddress(address1)); //message.ReplyToList.Add(addresses); //message.Subject = displayName + " has received your payment for invoice " + str1 + " in Bill Transact"; //message.BodyEncoding = Encoding.UTF8; //message.Body = parser2.Parse(); //message.IsBodyHtml = true; //Common.CommonHandler.SendSMTPEmail(hfCompanyID.Value, address1, displayName + " has received your payment for invoice " + str1 + " in Bill Transact", parser2.Parse(), true); await Common.CommonHandler.SendMail(hfCompanyID.Value, address1, displayName + " has received your payment for invoice " + str1 + " in Bill Transact", parser2.Parse(), true); //SmtpClientForCompany.smtpClient(this.hfCompanyID.Value).Send(message); } catch (Exception ex) { this.DisplayAlert("Error in sending mail." + (object)ex); } }
protected async void btnSave_Click(object sender, EventArgs e) { if (this.Page.IsValid) { string s = this.txtPaymentDate.Text; //string s = DateTime.ParseExact(this.txtPaymentDate.Text, new string[6] //{ // "MM/dd/yy", // "MM/dd/yyyy", // "dd/MM/yy", // "dd/MM/yyyy", // "yy-MM-dd", // "yyyy-MM-dd" //}, (IFormatProvider) CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("MM/dd/yyyy"); Decimal num11 = 0; if (this.txtPayment.Text.Trim().Length > 0) { num11 = Decimal.Parse(this.txtPayment.Text.Trim()); } if (num11 == Decimal.Parse(this.lblBalance.Text)) { num11 = Decimal.Parse(this.lblBalance.Text); } else if (num11 > Decimal.Parse(this.lblBalance.Text)) { Decimal num2 = num11 - Decimal.Parse(this.lblBalance.Text); num11 = Decimal.Parse(this.lblBalance.Text); this.objCreditMasterDT = this.objCreditMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value)); string sCreditNumber = this.objCreditMasterDT.Rows.Count <= 0 ? ConfigurationManager.AppSettings["InvoiceNoStart"] : PaymentMaster.NextNum(this.objCreditMasterDT.Rows[0]["CreditNumber"].ToString()); this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(this.hfInvoiceID.Value)); this.objCreditMasterBll.AddCredit(int.Parse(this.hfCompanyID.Value), new int?(int.Parse(this.objInvoiceMasterDT.Rows[0]["ClientID"].ToString())), new int?(int.Parse(this.objInvoiceMasterDT.Rows[0]["CurrencyID"].ToString())), sCreditNumber, new DateTime?(DateTime.Parse(s)), "Overpayment from invoice #" + this.objInvoiceMasterDT.Rows[0]["InvoiceNumber"], "", "created", new Decimal?(num2), new Decimal?(num2)); } int a = int.Parse(this.hfCompanyID.Value); int b = int.Parse(this.hfInvoiceID.Value); Decimal? c = new Decimal?(num11); string d = this.ddlMethod.SelectedItem.Value; DateTime?ed = new DateTime?(DateTime.Parse(s)); string f = this.txtPaymentNote.Text.Trim(); //int paymentID = this.objPaymentMasterBll.AddPayment(int.Parse(this.hfCompanyID.Value), int.Parse(this.hfInvoiceID.Value), new Decimal?(num11), this.ddlMethod.SelectedItem.Value, new DateTime?(DateTime.Parse(s)), this.txtPaymentNote.Text.Trim()); int paymentID = this.objPaymentMasterBll.AddPayment(int.Parse(this.hfCompanyID.Value), int.Parse(this.hfInvoiceID.Value), Convert.ToDecimal(txtPayment.Text), this.ddlMethod.SelectedItem.Value, Convert.ToDateTime(s), this.txtPaymentNote.Text.Trim()); if (num11 > new Decimal(0)) { Decimal num2 = Decimal.Round(Decimal.Parse(this.lblTotalPaid.Text) + num11, 2); //this.objInvoiceMasterBll.UpdatePaidToDate(new Decimal?(num2), int.Parse(this.hfInvoiceID.Value)); this.objInvoiceMasterBll.UpdateInvoiceStatus(num2 == Decimal.Parse(this.lblInvoiceAmt.Text) ? "paid" : "partial", int.Parse(this.hfInvoiceID.Value)); } if (paymentID != 0) { this.Session["savePay"] = (object)1; if (true || chkEmail.Checked) { this.objInvoiceMasterDT = this.objInvoiceMasterBll.GetDataByInvoiceID(int.Parse(this.hfInvoiceID.Value)); if (this.objInvoiceMasterDT.Rows.Count > 0) { this.lblInvoiceAmt.Text = this.objInvoiceMasterDT.Rows[0]["InvoiceTotal"].ToString(); this.lblInvoiceAmt.Text = Decimal.Round(Decimal.Parse(this.lblInvoiceAmt.Text), 2).ToString(); await this.SendMailNew(paymentID); } } this.DisplayAlert("Payment Added Successfully"); this.Response.Redirect("PaymentMaster.aspx"); } else { this.DisplayAlert("Problem in Insertion Try After Sometime..!"); } } else { this.DisplayAlert("Please Fill Proper Data..!"); } }