//To add data to the Invoice Table public bool InsertPaymentDetails(PaymentDetailsEntity objPay) { objCommand.Parameters.Clear(); bool ii = false; try { objCommand.CommandText = "sp_InsertPaymentRecord"; objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.Add("@transactionId", SqlDbType.VarChar).Value = objPay.TransactionId; objCommand.Parameters.Add("@invoiceId", SqlDbType.Int).Value = objPay.InvoiceId; objCommand.Parameters.Add("@clientName", SqlDbType.VarChar).Value = objPay.ClientName; objCommand.Parameters.Add("@paymentType", SqlDbType.VarChar).Value = objPay.PaymentType; objCommand.Parameters.Add("@currencyType", SqlDbType.VarChar).Value = objPay.CurrencyType; objCommand.Parameters.Add("@amount", SqlDbType.Decimal).Value = objPay.Amount; objCommand.Parameters.Add("@paymentStatus", SqlDbType.VarChar).Value =objPay.PaymentStatus; DLConfig = new ConfigSettings(Globals.DBConnString, objCommand, DataProviderType.Sql); ii = DLCommand.ExecuteNonQuery(DLConfig); } catch (Exception) { throw; } return ii; }
public void UpdateOfflinePaymentTransaction() { bool upsertStatus = false; PaymentDetailsEntity objPay = new PaymentDetailsEntity(); invoiceItems = (DataTable)Session["InvoiceItems"]; foreach (DataRow dr in invoiceItems.Rows) { invoiceId = Convert.ToInt32(dr["InvoiceId"].ToString()); cName = dr["ClientName"].ToString(); if (txtCashCredit.Text != "") objPay.CreditCash = Convert.ToDouble(txtCashCredit.Text); if (txtAmount.Text != "") objPay.AmountForOffline = Convert.ToDouble(txtAmount.Text); if (txtChequeNumber.Text != "") objPay.CheckNumber = txtChequeNumber.Text; if (txtDrawnBank.Text != "") objPay.DrawnBank = txtDrawnBank.Text; if (txtMemo.Text != "") objPay.Memo = txtMemo.Text; objPay.TransactionId_Offline = GetRandomNumber(); objPay.InvoiceId = invoiceId; objPay.ClientName = cName; objPay.PaymentType = "Offline"; bool insertStatus = objPayment.InsertOfflinePaymentDetails(objPay); upsertStatus = (insertStatus == true) ? objBlAdminInvoice.UpdateInvoiceRec(invoiceId) : false; } if (upsertStatus == true) Response.Redirect("~/adminpages/AdminBManageInvoice.aspx?ClientName=" + cName); }
public void UpdatePaymentTransaction(int x) { bool upsertStatus = false; PaymentDetailsEntity objPay = new PaymentDetailsEntity(); invoiceItems = (DataTable)Session["InvoiceItems"]; if (x == 1) { foreach (DataRow dr in invoiceItems.Rows) { //amount = Convert.ToDouble(dr["Amount"].ToString().Remove(0, 1).ToString()); invoiceId = Convert.ToInt32(dr["InvoiceId"].ToString()); cName = dr["ClientName"].ToString(); transactionId = Request.QueryString["tx"].ToString(); status = Request.QueryString["st"].ToString(); amount = Convert.ToDouble(Request.QueryString["amt"].ToString()); currentyType = Request.QueryString["cc"].ToString(); objPay.TransactionId = transactionId; objPay.InvoiceId = invoiceId; objPay.ClientName = cName; objPay.PaymentType = "PayPal"; objPay.CurrencyType = currentyType; objPay.Amount = Convert.ToDouble(amount); objPay.PaymentStatus = status; bool insertStatus = objPayment.InsertPaymentDetails(objPay); upsertStatus = (insertStatus == true) ? objBlAdminInvoice.UpdateInvoiceRec(invoiceId) : false; //bool upsertStatus = objBlAdminInvoice.UpdateInvoiceRec(invoiceId); } if (upsertStatus == true) Response.Redirect("~/pages/ClientInvoices.aspx?ClientName=" + cName); } else if (x == 2) { objPay.InvoiceId = invoiceId; objPay.ClientName = cName; objPay.PaymentType = "Online"; objPay.Amount = Convert.ToDouble(amount); objPay.PaymentStatus = Request.QueryString["status"].ToString(); ; bool insertStatus = objPayment.InsertPaymentDetails(objPay); } }
public void UpdateATNPaymentTransaction(string[] paymentDetails) { lblMessage.Visible = true; bool upsertStatus = false; PaymentDetailsEntity objPay = new PaymentDetailsEntity(); invoiceItems = (DataTable)Session["InvoiceItems"]; if (paymentDetails!=null && paymentDetails[0] == "1") { foreach (DataRow dr in invoiceItems.Rows) { //amount = Convert.ToDouble(dr["Amount"].ToString().Remove(0, 1).ToString()); invoiceId = Convert.ToInt32(paymentDetails[7]); cName = dr["ClientName"].ToString(); transactionId = paymentDetails[6]; status = "Completed"; amount = Convert.ToDouble(paymentDetails[9]); currentyType = paymentDetails[10]; objPay.TransactionId = transactionId; objPay.InvoiceId =Convert.ToInt32(paymentDetails[7]); objPay.ClientName = cName; objPay.PaymentType = "AuthorizeNet"; objPay.CurrencyType = currentyType; objPay.Amount = Convert.ToDouble(amount); objPay.PaymentStatus = status; bool insertStatus = objPayment.InsertPaymentDetails(objPay); upsertStatus = (insertStatus == true) ? objBlAdminInvoice.UpdateInvoiceRec(invoiceId) : false; //bool upsertStatus = objBlAdminInvoice.UpdateInvoiceRec(invoiceId); } } if (((string[])(paymentDetails))[0] == "2") { objPay.InvoiceId = Convert.ToInt32(paymentDetails[7]); objPay.ClientName = cName; objPay.PaymentType = "Online"; objPay.Amount = Convert.ToDouble(amount); status = "cancelled"; bool insertStatus = objPayment.InsertPaymentDetails(objPay); } if (((string[])(paymentDetails))[0] == "3") { lblMessage.Text = "There has been an error processing this transaction."; lblMessage.Text = "This transaction has been declined."; objPay.InvoiceId = Convert.ToInt32(paymentDetails[7]); objPay.ClientName = cName; objPay.PaymentType = "Online"; objPay.Amount = Convert.ToDouble(amount); status = "cancelled"; } if (((string[])(paymentDetails))[0] == "4") { lblMessage.Text = "This transaction is being held for review."; lblMessage.Text = "This transaction has been declined."; objPay.InvoiceId = Convert.ToInt32(paymentDetails[7]); objPay.ClientName = cName; objPay.PaymentType = "Online"; objPay.Amount = Convert.ToDouble(amount); status = "cancelled"; } }
public bool InsertPaymentDetails(PaymentDetailsEntity objPay) { return payment.InsertPaymentDetails(objPay); }