//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);
}
