public virtual CloudAccountDA.PaymentMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.PaymentMasterDataTable dataTable = new CloudAccountDA.PaymentMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
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"); } }
public virtual int Fill(CloudAccountDA.PaymentMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void ViewRecord(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(); }
public virtual CloudAccountDA.PaymentMasterDataTable DeleteByInvoiceID(int?InvoiceID) { this.Adapter.SelectCommand = this.CommandCollection[2]; if (InvoiceID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = InvoiceID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.PaymentMasterDataTable dataTable = new CloudAccountDA.PaymentMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.PaymentMasterDataTable GetDataByPaymentID(int?PaymentID) { this.Adapter.SelectCommand = this.CommandCollection[6]; if (PaymentID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = PaymentID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.PaymentMasterDataTable dataTable = new CloudAccountDA.PaymentMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.PaymentMasterDataTable GetDataByCompanyStaffID(int?CompanyID, int?StaffID) { this.Adapter.SelectCommand = this.CommandCollection[4]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (StaffID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = StaffID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } CloudAccountDA.PaymentMasterDataTable dataTable = new CloudAccountDA.PaymentMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
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())); }
public virtual int Update(CloudAccountDA.PaymentMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }
public virtual CloudAccountDA.PaymentMasterDataTable GetDataByPaymentSearchStaff(int?CompanyID, int?StaffID, string InvoiceNumber, string ClientName, string Notes, string PaymentMethod, DateTime?ToDate, DateTime?FromDate, decimal?AmountTo, decimal?AmountFrom, int?Currency) { this.Adapter.SelectCommand = this.CommandCollection[8]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (StaffID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = StaffID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (InvoiceNumber == null) { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = InvoiceNumber; } if (ClientName == null) { this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = ClientName; } if (Notes == null) { this.Adapter.SelectCommand.Parameters[5].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[5].Value = Notes; } if (PaymentMethod == null) { this.Adapter.SelectCommand.Parameters[6].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[6].Value = PaymentMethod; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[7].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[7].Value = DBNull.Value; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[8].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[8].Value = DBNull.Value; } if (AmountTo.HasValue) { this.Adapter.SelectCommand.Parameters[9].Value = AmountTo.Value; } else { this.Adapter.SelectCommand.Parameters[9].Value = DBNull.Value; } if (AmountFrom.HasValue) { this.Adapter.SelectCommand.Parameters[10].Value = AmountFrom.Value; } else { this.Adapter.SelectCommand.Parameters[10].Value = DBNull.Value; } if (Currency.HasValue) { this.Adapter.SelectCommand.Parameters[11].Value = Currency.Value; } else { this.Adapter.SelectCommand.Parameters[11].Value = DBNull.Value; } CloudAccountDA.PaymentMasterDataTable dataTable = new CloudAccountDA.PaymentMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
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); } }