public string AgentBulkPaymentBankDeposit(AgentBulkPaymentBankDeposit model)
        {
            try
            {
                string status = string.Empty;
                using (SqlConnection connection = DataAccess.CreateConnection())
                {
                    SqlCommand command = DataAccess.CreateCommand(connection);

                    DataAccess.CreateStoredprocedure(command, "InsertBulkPaymentAgentBankDeposit_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, "@UserId", SqlDbType.VarChar, model.UserId);
                    DataAccess.AddInParameter(command, "@AgentId", SqlDbType.Int, model.AgentId);
                    DataAccess.AddInParameter(command, "@BankAccountId", SqlDbType.Int, model.BankAccountId);
                    DataAccess.AddInParameter(command, "@BankDate", SqlDbType.VarChar, model.BankDate);

                    SqlDataReader reader = DataAccess.ExecuteReader(command);
                    if (reader != null)
                    {
                        while (reader.Read())
                        {
                            status = reader["IndentityVals"] is DBNull ? string.Empty : Convert.ToString(reader["IndentityVals"]);
                        }
                    }
                    reader.Close();
                    return(status);
                }
            }
            catch (Exception ex)
            {
                return(string.Empty);
            }
        }
 public ActionResult BulkPayment(FormCollection form)
 {
     try
     {
         string IndetityVals = string.Empty;
         int    AgentId      = (string.IsNullOrEmpty(form["AgentId"])) ? 0 : Convert.ToInt32(form["AgentId"]);
         if (AgentId > 0)
         {
             int InvoiceCount  = (string.IsNullOrEmpty(form["InvoiceCount"])) ? 0 : Convert.ToInt32(form["InvoiceCount"]);
             int PaymentMethod = (string.IsNullOrEmpty(form["PaymentMethod"])) ? 0 : Convert.ToInt32(form["PaymentMethod"]);
             #region Agent Bulk Payment - Payment Method * Cash
             if (PaymentMethod == 1 && InvoiceCount > 0)
             {
                 AgentBulkPaymentCashVoucher Obj = new AgentBulkPaymentCashVoucher();
                 Obj.AgentId    = AgentId;
                 Obj.Amount     = (string.IsNullOrEmpty(form["Amount"])) ? 0 : Convert.ToDouble(form["Amount"]);
                 Obj.LedgerDate = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                 Obj.Notes      = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                 Obj.UserId     = User.Identity.GetUserId();
                 IndetityVals   = new AgentDA().AgentBulkPaymentCashVoucher(Obj);
                 string[] SplitVals = IndetityVals.Split(',');
                 if (SplitVals.Length == 2 && Convert.ToInt32(SplitVals[0]) > 0)
                 {
                     for (int i = 1; i <= InvoiceCount; i++)
                     {
                         BulkPaymentAgentCashInvPaymentInvLog lObj = new BulkPaymentAgentCashInvPaymentInvLog();
                         lObj.AgentId             = AgentId;
                         lObj.AgentLedgerId       = Convert.ToInt32(SplitVals[1]);
                         lObj.Amount              = (string.IsNullOrEmpty(form["PaidAmount" + i])) ? 0 : Convert.ToDouble(form["PaidAmount" + i]);
                         lObj.GeneralLedgerId     = Convert.ToInt32(SplitVals[0]);
                         lObj.InvoiceId           = (string.IsNullOrEmpty(form["InvoiceId" + i])) ? 0 : Convert.ToInt32(form["InvoiceId" + i]);
                         lObj.Notes               = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                         lObj.UserID              = User.Identity.GetUserId();
                         lObj.LedgerDate          = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                         lObj.BankAccountLedgerId = 0;
                         if (lObj.Amount > 0)
                         {
                             new AgentDA().BulkPaymentAgentCashVoucherInvoicePaymentInvoiceLog(lObj);
                         }
                     }
                 }
             }
             #endregion
             #region Agent Bulk Payment - Payment Method * Cheque
             else if (PaymentMethod == 2)
             {
                 AgentBulkPaymentChequeVoucher Obj = new AgentBulkPaymentChequeVoucher();
                 Obj.AccountNo   = (string.IsNullOrEmpty(form["chkAccountNo"])) ? string.Empty : Convert.ToString(form["chkAccountNo"]);
                 Obj.AgentId     = (string.IsNullOrEmpty(form["AgentId"])) ? 0 : Convert.ToInt32(form["AgentId"]);
                 Obj.Amount      = (string.IsNullOrEmpty(form["Amount"])) ? 0 : Convert.ToDouble(form["Amount"]);
                 Obj.BankNames   = (string.IsNullOrEmpty(form["chkBankId"])) ? 0 : Convert.ToInt32(form["chkBankId"]);
                 Obj.ChequeNo    = (string.IsNullOrEmpty(form["chkChequeNo"])) ? string.Empty : Convert.ToString(form["chkChequeNo"]);
                 Obj.LedgerDate  = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                 Obj.Remarks     = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                 Obj.SortCode    = (string.IsNullOrEmpty(form["chkSortCode"])) ? string.Empty : Convert.ToString(form["chkSortCode"]);
                 Obj.UserId      = User.Identity.GetUserId();
                 Obj.BulkPayment = true;
                 new AgentDA().AgentBulkPaymentChequeVoucher(Obj);
             }
             #endregion
             #region Agent Bulk Payment - Payment Method * Credit Card
             else if (PaymentMethod == 3 && InvoiceCount > 0)
             {
                 AgentBulkPaymentCreditCard Obj = new AgentBulkPaymentCreditCard();
                 Obj.AgentId       = (string.IsNullOrEmpty(form["AgentId"])) ? 0 : Convert.ToInt32(form["AgentId"]);
                 Obj.Amount        = (string.IsNullOrEmpty(form["Amount"])) ? 0 : Convert.ToDouble(form["Amount"]);
                 Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountIdCC"])) ? 0 : Convert.ToInt32(form["BankAccountIdCC"]);
                 Obj.LedgerDate    = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                 Obj.Notes         = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                 Obj.UserId        = User.Identity.GetUserId();
                 Obj.CardNo        = (string.IsNullOrEmpty(form["CreditCardNo"])) ? string.Empty : Convert.ToString(form["CreditCardNo"]);
                 Obj.CardHolder    = (string.IsNullOrEmpty(form["CardHolderName"])) ? string.Empty : Convert.ToString(form["CardHolderName"]);
                 Obj.ExtraAmount   = (string.IsNullOrEmpty(form["ExtraAmount"])) ? string.Empty : Convert.ToString(form["ExtraAmount"]);
                 Obj.BankDate      = (string.IsNullOrEmpty(form["BankDate"])) ? string.Empty : Convert.ToString(form["BankDate"]);
                 IndetityVals      = new AgentDA().AgentBulkPaymentCreditCard(Obj);
                 string[] SplitVals = IndetityVals.Split(',');
                 if (SplitVals.Length == 3 && Convert.ToInt32(SplitVals[0]) > 0)
                 {
                     for (int i = 1; i <= InvoiceCount; i++)
                     {
                         BulkPaymentAgentCashInvPaymentInvLog lObj = new BulkPaymentAgentCashInvPaymentInvLog();
                         lObj.AgentId             = AgentId;
                         lObj.AgentLedgerId       = Convert.ToInt32(SplitVals[1]);
                         lObj.Amount              = (string.IsNullOrEmpty(form["PaidAmount" + i])) ? 0 : Convert.ToDouble(form["PaidAmount" + i]);
                         lObj.GeneralLedgerId     = Convert.ToInt32(SplitVals[0]);
                         lObj.InvoiceId           = (string.IsNullOrEmpty(form["InvoiceId" + i])) ? 0 : Convert.ToInt32(form["InvoiceId" + i]);
                         lObj.Notes               = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                         lObj.UserID              = User.Identity.GetUserId();
                         lObj.LedgerDate          = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                         lObj.BankAccountLedgerId = Convert.ToInt32(SplitVals[2]);
                         if (lObj.Amount > 0)
                         {
                             new AgentDA().BulkPaymentAgentCashVoucherInvoicePaymentInvoiceLog(lObj);
                         }
                     }
                 }
             }
             #endregion
             #region Agent Bulk Payment - Payment Method * Debit Card
             else if (PaymentMethod == 4 && InvoiceCount > 0)
             {
                 AgentBulkPaymentDebitCard Obj = new AgentBulkPaymentDebitCard();
                 Obj.AgentId       = (string.IsNullOrEmpty(form["AgentId"])) ? 0 : Convert.ToInt32(form["AgentId"]);
                 Obj.Amount        = (string.IsNullOrEmpty(form["Amount"])) ? 0 : Convert.ToDouble(form["Amount"]);
                 Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountIdDC"])) ? 0 : Convert.ToInt32(form["BankAccountIdDC"]);
                 Obj.LedgerDate    = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                 Obj.Notes         = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                 Obj.UserId        = User.Identity.GetUserId();
                 Obj.CardNo        = (string.IsNullOrEmpty(form["CreditCardNo"])) ? string.Empty : Convert.ToString(form["CreditCardNo"]);
                 Obj.CardHolder    = (string.IsNullOrEmpty(form["CardHolderName"])) ? string.Empty : Convert.ToString(form["CardHolderName"]);
                 Obj.ExtraAmount   = (string.IsNullOrEmpty(form["ExtraAmount"])) ? string.Empty : Convert.ToString(form["ExtraAmount"]);
                 Obj.BankDate      = (string.IsNullOrEmpty(form["BankDate"])) ? string.Empty : Convert.ToString(form["BankDate"]);
                 IndetityVals      = new AgentDA().AgentBulkPaymentDebitCard(Obj);
                 string[] SplitVals = IndetityVals.Split(',');
                 if (SplitVals.Length == 3 && Convert.ToInt32(SplitVals[0]) > 0)
                 {
                     for (int i = 1; i <= InvoiceCount; i++)
                     {
                         BulkPaymentAgentCashInvPaymentInvLog lObj = new BulkPaymentAgentCashInvPaymentInvLog();
                         lObj.AgentId             = AgentId;
                         lObj.AgentLedgerId       = Convert.ToInt32(SplitVals[1]);
                         lObj.Amount              = (string.IsNullOrEmpty(form["PaidAmount" + i])) ? 0 : Convert.ToDouble(form["PaidAmount" + i]);
                         lObj.GeneralLedgerId     = Convert.ToInt32(SplitVals[0]);
                         lObj.InvoiceId           = (string.IsNullOrEmpty(form["InvoiceId" + i])) ? 0 : Convert.ToInt32(form["InvoiceId" + i]);
                         lObj.Notes               = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                         lObj.UserID              = User.Identity.GetUserId();
                         lObj.LedgerDate          = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                         lObj.BankAccountLedgerId = Convert.ToInt32(SplitVals[2]);
                         if (lObj.Amount > 0)
                         {
                             new AgentDA().BulkPaymentAgentCashVoucherInvoicePaymentInvoiceLog(lObj);
                         }
                     }
                 }
             }
             #endregion
             #region Agent Bulk Payment - Payment Method * Bank Deposit
             else if (PaymentMethod == 5 && InvoiceCount > 0)
             {
                 AgentBulkPaymentBankDeposit Obj = new AgentBulkPaymentBankDeposit();
                 Obj.Amount        = (string.IsNullOrEmpty(form["Amount"])) ? 0 : Convert.ToDouble(form["Amount"]);
                 Obj.Notes         = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                 Obj.LedgerDate    = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                 Obj.UserId        = User.Identity.GetUserId();
                 Obj.AgentId       = (string.IsNullOrEmpty(form["AgentId"])) ? 0 : Convert.ToInt32(form["AgentId"]);
                 Obj.BankAccountId = (string.IsNullOrEmpty(form["BankAccountIdBP"])) ? 0 : Convert.ToInt32(form["BankAccountIdBP"]);
                 Obj.BankDate      = (string.IsNullOrEmpty(form["BankDateBankDeposit"])) ? string.Empty : Convert.ToString(form["BankDateBankDeposit"]);
                 IndetityVals      = new AgentDA().AgentBulkPaymentBankDeposit(Obj);
                 string[] SplitVals = IndetityVals.Split(',');
                 if (SplitVals.Length == 3 && Convert.ToInt32(SplitVals[0]) > 0)
                 {
                     for (int i = 1; i <= InvoiceCount; i++)
                     {
                         BulkPaymentAgentCashInvPaymentInvLog lObj = new BulkPaymentAgentCashInvPaymentInvLog();
                         lObj.AgentId             = AgentId;
                         lObj.AgentLedgerId       = Convert.ToInt32(SplitVals[1]);
                         lObj.Amount              = (string.IsNullOrEmpty(form["PaidAmount" + i])) ? 0 : Convert.ToDouble(form["PaidAmount" + i]);
                         lObj.GeneralLedgerId     = Convert.ToInt32(SplitVals[0]);
                         lObj.InvoiceId           = (string.IsNullOrEmpty(form["InvoiceId" + i])) ? 0 : Convert.ToInt32(form["InvoiceId" + i]);
                         lObj.Notes               = (string.IsNullOrEmpty(form["Notes"])) ? String.Format("{0} - Agent Bulk Payment", string.Empty) : String.Format("{0} - Agent Bulk Payment", Convert.ToString(form["Notes"]));
                         lObj.UserID              = User.Identity.GetUserId();
                         lObj.LedgerDate          = (string.IsNullOrEmpty(form["LedgerDate"])) ? string.Empty : Convert.ToString(form["LedgerDate"]);
                         lObj.BankAccountLedgerId = Convert.ToInt32(SplitVals[2]);
                         if (lObj.Amount > 0)
                         {
                             new AgentDA().BulkPaymentAgentCashVoucherInvoicePaymentInvoiceLog(lObj);
                         }
                     }
                 }
             }
             #endregion
         }
         return(RedirectToAction("BulkPayment", "Agent"));
     }
     catch (Exception ex)
     {
         return(RedirectToAction("BulkPayment", "Agent"));
     }
 }