public bool AddCreditCardPaymentDetailsOtherInvoice(CCardDetail Obj)
{
try
{
int status = 0;
using (SqlConnection connection = DataAccess.CreateConnection())
{
SqlCommand command = DataAccess.CreateCommand(connection);
DataAccess.CreateStoredprocedure(command, "AddCreditCardPaymentDetailsOtherInvoice_SP");
DataAccess.AddInParameter(command, "@Notes", SqlDbType.VarChar, Obj.Notes);
DataAccess.AddInParameter(command, "@Amount", SqlDbType.Float, Obj.Amount);
DataAccess.AddInParameter(command, "@InvoiceId", SqlDbType.Int, Obj.InvoiceId);
DataAccess.AddInParameter(command, "@BankAccountId", SqlDbType.Int, Obj.BankAccountId);
DataAccess.AddInParameter(command, "@CardNo", SqlDbType.VarChar, Obj.CardNo);
DataAccess.AddInParameter(command, "@CardHolder", SqlDbType.VarChar, Obj.CardHolder);
DataAccess.AddInParameter(command, "@ExtraAmount", SqlDbType.VarChar, Obj.ExtraAmount);
DataAccess.AddInParameter(command, "@BankDate", SqlDbType.VarChar, Obj.BankDate);
DataAccess.AddInParameter(command, "@UserId", SqlDbType.VarChar, Obj.UserId);
status = DataAccess.ExecuteNonQuery(command);
if (status < 0)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult AgtCustTransaction(FormCollection form)
{
int InvoiceId = (string.IsNullOrEmpty(form["InvoiceId"])) ? 0 : Convert.ToInt32(form["InvoiceId"]);
try
{
int TransactionMethod = (string.IsNullOrEmpty(form["TransactionMethod"])) ? 0 : Convert.ToInt32(form["TransactionMethod"]);
#region Payment by Cash
if (TransactionMethod == 1)
{
CashTransaction Obj = new CashTransaction();
Obj.Amount = (string.IsNullOrEmpty(form["PaymentAmount"])) ? 0 : Convert.ToDouble(form["PaymentAmount"]);
Obj.Remarks = (string.IsNullOrEmpty(form["PaymentRemarks"])) ? string.Empty : Convert.ToString(form["PaymentRemarks"]);
Obj.UserId = User.Identity.GetUserId();
Obj.InvoiceId = InvoiceId;
new OtherInvoiceDA().OtherInvoicePaymentCashVoucher(Obj);
}
#endregion
#region Payment by Bank Cheque
else if (TransactionMethod == 2)
{
ChequeDetails Obj = new ChequeDetails();
Obj.AccountNo = (string.IsNullOrEmpty(form["AccountNo"])) ? string.Empty : Convert.ToString(form["AccountNo"]);
Obj.Amount = (string.IsNullOrEmpty(form["PaymentAmount"])) ? 0 : Convert.ToDouble(form["PaymentAmount"]);
Obj.BankNames = (BankName)Convert.ToInt32(((string.IsNullOrEmpty(form["BankId"])) ? "0" : Convert.ToString(form["BankId"])).Replace(",", ""));
Obj.ChequeNo = (string.IsNullOrEmpty(form["ChequeNo"])) ? string.Empty : Convert.ToString(form["ChequeNo"]);
Obj.InvoiceId = InvoiceId;
Obj.Remarks = (string.IsNullOrEmpty(form["PaymentRemarks"])) ? string.Empty : Convert.ToString(form["PaymentRemarks"]);
Obj.SortCode = (string.IsNullOrEmpty(form["SortCode"])) ? string.Empty : Convert.ToString(form["SortCode"]);
this.chequeTransaction(Obj);
}
#endregion
#region Payment By Credit Card
else if (TransactionMethod == 3)
{
CCardDetail Obj = new CCardDetail();
Obj.Amount = (string.IsNullOrEmpty(form["PaymentAmount"])) ? 0 : Convert.ToDouble(form["PaymentAmount"]);
Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountId"])) ? 0 : Convert.ToInt32(form["BankAccountId"]);
Obj.BankDate = (string.IsNullOrEmpty(form["BankDate"])) ? string.Empty : Convert.ToString(form["BankDate"]);
Obj.CardHolder = (string.IsNullOrEmpty(form["CardHolderName"])) ? string.Empty : Convert.ToString(form["CardHolderName"]);
Obj.CardNo = (string.IsNullOrEmpty(form["CreditCardNo"])) ? string.Empty : Convert.ToString(form["CreditCardNo"]);
Obj.ExtraAmount = (string.IsNullOrEmpty(form["ExtraAmount"])) ? string.Empty : Convert.ToString(form["ExtraAmount"]);
Obj.InvoiceId = InvoiceId;
Obj.Notes = String.Format("Credit Card Invoice Payment by {0}. - {1}", User.Identity.GetDisplayName(), (string.IsNullOrEmpty(form["PaymentRemarks"])) ? string.Empty : Convert.ToString(form["PaymentRemarks"]));
Obj.UserId = User.Identity.GetUserId();
new OtherInvoiceDA().AddCreditCardPaymentDetailsOtherInvoice(Obj);
}
#endregion
#region Payment by Debit Card
else if (TransactionMethod == 4)
{
DCardDetail Obj = new DCardDetail();
Obj.Amount = (string.IsNullOrEmpty(form["PaymentAmount"])) ? 0 : Convert.ToDouble(form["PaymentAmount"]);
Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountId"])) ? 0 : Convert.ToInt32(form["BankAccountId"]);
Obj.BankDate = (string.IsNullOrEmpty(form["BankDateDebitCard"])) ? string.Empty : Convert.ToString(form["BankDateDebitCard"]);
Obj.CardHolder = (string.IsNullOrEmpty(form["CardHolderNameDebitCard"])) ? string.Empty : Convert.ToString(form["CardHolderNameDebitCard"]);
Obj.CardNo = (string.IsNullOrEmpty(form["DebitCardNo"])) ? string.Empty : Convert.ToString(form["DebitCardNo"]);
Obj.ExtraAmount = (string.IsNullOrEmpty(form["ExtraAmountDebitCard"])) ? string.Empty : Convert.ToString(form["ExtraAmountDebitCard"]);
Obj.InvoiceId = InvoiceId;
Obj.Notes = String.Format("Debit Card Invoice Payment by {0}. - {1}", User.Identity.GetDisplayName(), (string.IsNullOrEmpty(form["PaymentRemarks"])) ? string.Empty : Convert.ToString(form["PaymentRemarks"]));
Obj.UserId = User.Identity.GetUserId();
new OtherInvoiceDA().AddDebitCardPaymentDetailsOtherInvoice(Obj);
}
#endregion
#region Payment by Bank Deposit
else if (TransactionMethod == 5)
{
BankPaymentDetail Obj = new BankPaymentDetail();
Obj.Amount = (string.IsNullOrEmpty(form["PaymentAmount"])) ? 0 : Convert.ToDouble(form["PaymentAmount"]);
Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountId"])) ? 0 : Convert.ToInt32(form["BankAccountId"]);
Obj.BankDate = (string.IsNullOrEmpty(form["BankDateBankDeposit"])) ? string.Empty : Convert.ToString(form["BankDateBankDeposit"]);
Obj.InvoiceId = InvoiceId;
Obj.Notes = String.Format("Bank Deposit/Transfer Invoice Payment by {0}. - {1}", User.Identity.GetDisplayName(), (string.IsNullOrEmpty(form["PaymentRemarks"])) ? string.Empty : Convert.ToString(form["PaymentRemarks"]));
Obj.UserId = User.Identity.GetUserId();
new OtherInvoiceDA().AddBankDepositPaymentDetailsOtherInvoice(Obj);
}
#endregion
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
catch (Exception ex)
{
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
}
