public bool InsertBankDepositDebitCardVoucher(BankDepositDebitCardVoucher model)
{
try
{
int status = 0;
using (SqlConnection connection = DataAccess.CreateConnection())
{
SqlCommand command = DataAccess.CreateCommand(connection);
DataAccess.CreateStoredprocedure(command, "InsertBankDepositDebitCardVoucher_SP");
DataAccess.AddInParameter(command, "@Amount", SqlDbType.Float, model.Amount);
DataAccess.AddInParameter(command, "@Notes", SqlDbType.VarChar, model.Notes);
DataAccess.AddInParameter(command, "@LedgerDate", SqlDbType.VarChar, model.LedgerDate);
DataAccess.AddInParameter(command, "@BankAccountId", SqlDbType.Int, model.BankAccountId);
DataAccess.AddInParameter(command, "@UserID", SqlDbType.VarChar, model.UserID);
DataAccess.AddInParameter(command, "@LedgerHeadId", SqlDbType.Int, model.LedgerHeadId);
DataAccess.AddInParameter(command, "@CardNo", SqlDbType.VarChar, model.CardNo);
DataAccess.AddInParameter(command, "@CardHolder", SqlDbType.VarChar, model.CardHolder);
DataAccess.AddInParameter(command, "@ExtraAmount", SqlDbType.VarChar, model.ExtraAmount);
DataAccess.AddInParameter(command, "@BankDate", SqlDbType.VarChar, model.BankDate);
status = DataAccess.ExecuteNonQuery(command);
return(status < 0 ? false : true);
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult BankDeposit(BankDepositViewModel model)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("BankDeposit", "Banks"));
}
if (model == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
try
{
bool status = false;
int TransactionMethod = (int)model.TransactionMethod;
#region Bank Deposit - Payment Method * Cash
if (TransactionMethod == 1)
{
BankDepositCashVoucher Obj = new BankDepositCashVoucher();
Obj.Amount = model.Amount;
Obj.BankAccountId = model.BankAccountId;
Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId;
Obj.Notes = model.Notes;
Obj.UserID = User.Identity.GetUserId();
Obj.LedgerDate = model.LedgerDate;
status = new BankDA().InsertBankDepositCashVoucher(Obj);
}
#endregion
#region Bank Deposit - Payment Method * Cheque
else if (TransactionMethod == 2)
{
BankDepositChequeVoucher Obj = new BankDepositChequeVoucher();
Obj.Amount = model.Amount;
Obj.BankAccountId = model.BankAccountId;
Obj.BankOfChequeId = (int)model.BankOfChequeId;
Obj.ChequeNo = model.ChequeNo;
Obj.AccountNo = model.AccountNo;
Obj.SortCode = model.SortCode;
Obj.Notes = model.Notes;
Obj.UserID = User.Identity.GetUserId();
Obj.LedgerDate = model.LedgerDate;
Obj.ChequeStauts = (int)ChequeStatus.Floating;
status = new BankDA().InsertBankDepositChequeVoucher(Obj);
}
#endregion
#region Bank Deposit - Payment Method * Credit Card
else if (TransactionMethod == 3)
{
BankDepositCreditCardVoucher Obj = new BankDepositCreditCardVoucher();
Obj.Amount = model.Amount;
Obj.BankAccountId = model.BankAccountId;
Obj.BankDate = model.BankDate;
Obj.CardHolder = model.CardHolderName;
Obj.CardNo = model.CreditCardNo;
Obj.ExtraAmount = model.ExtraAmount;
Obj.LedgerDate = model.LedgerDate;
Obj.LedgerHeadId = model.BankAccountLedgerHeadId;
Obj.Notes = model.Notes;
Obj.UserID = User.Identity.GetUserId();
status = new BankDA().InsertBankDepositCreditCardVoucher(Obj);
}
#endregion
#region Bank Deposit - Payment Method * Debit Card
else if (TransactionMethod == 4)
{
BankDepositDebitCardVoucher Obj = new BankDepositDebitCardVoucher();
Obj.Amount = model.Amount;
Obj.BankAccountId = model.BankAccountId;
Obj.BankDate = model.BankDate;
Obj.CardHolder = model.CardHolderName;
Obj.CardNo = model.CreditCardNo;
Obj.ExtraAmount = model.ExtraAmount;
Obj.LedgerDate = model.LedgerDate;
Obj.LedgerHeadId = model.BankAccountLedgerHeadId;
Obj.Notes = model.Notes;
Obj.UserID = User.Identity.GetUserId();
status = new BankDA().InsertBankDepositDebitCardVoucher(Obj);
}
#endregion
#region Bank Deposit - Payment Method * Direct Deposit
else if (TransactionMethod == 5)
{
BankDepositDirectDepositVoucher Obj = new BankDepositDirectDepositVoucher();
Obj.Amount = model.Amount;
Obj.BankAccountId = model.BankAccountId;
Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId;
Obj.Notes = model.Notes;
Obj.UserID = User.Identity.GetUserId();
Obj.LedgerDate = model.LedgerDate;
status = new BankDA().InsertBankDepositDirectDepositVoucher(Obj);
}
#endregion
return(RedirectToAction("BankLedger", "Banks", new { @id = model.BankAccountId, @BankName = model.BankNames }));
}
catch (Exception ex)
{
return(RedirectToAction("BankDeposit", "Banks"));
}
}
}
