public void ApprovedSingleCheck(PaymentInfoBO paymentInfoBo)// Approved Check
        {
            DataTable dtMaturity   = new DataTable();
            int       maturityDays = 0;

            dtMaturity = GetPaymentMediaMaturityDay(paymentInfoBo.IsMatureToday, paymentInfoBo.PaymentMedia);
            if (dtMaturity.Rows.Count > 0)
            {
                if (dtMaturity.Rows[0][0] != DBNull.Value)
                {
                    maturityDays = Convert.ToInt32(dtMaturity.Rows[0][0]);
                }
            }

            string queryUpdateRequisition = "UPDATE SBP_Check_Requisition SET Is_Approved=1 WHERE Sl_No=" + paymentInfoBo.RequisitionId + "";

            /*string queryInsertPayment = "INSERT INTO SBP_Payment(Cust_code,Amount,Received_Date,Payment_Media,Maturity_Days,Payment_Media_No,Payment_Media_Date,Bank_Name,Bank_Branch,Received_By,Deposit_Withdraw,Voucher_Sl_No,Payment_Approved_By,Payment_Approved_Date,Remarks,Entry_Date,Entry_By,Requisition_ID,Entry_Branch_ID)" +
             * " VALUES('" + paymentInfoBo.CustCode + "'," + paymentInfoBo.Amount + ",(CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)),'" + paymentInfoBo.PaymentMedia + "'," + maturityDays + ",'" + paymentInfoBo.PaymentMediaNo + "','" + paymentInfoBo.PaymentMediaDate.ToShortDateString() + "','" + paymentInfoBo.BankName + "','" + paymentInfoBo.BranchName + "','" + paymentInfoBo.RecievedBy + "','" + paymentInfoBo.DepositWithdraw + "','" + paymentInfoBo.VoucherSlNo + "','" + paymentInfoBo.PaymentApprovedBy + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME),'" + paymentInfoBo.Remarks + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME),'" + GlobalVariableBO._userName + "'," + paymentInfoBo.RequisitionId + "," + GlobalVariableBO._branchId + ")";*/

            string queryInsertPayment = "INSERT INTO dbo.SBP_Payment( Cust_Code , Amount ,Received_Date ,Payment_Media ,Payment_Media_No ,Received_By ,Deposit_Withdraw ,Payment_Approved_By ,Payment_Approved_Date ,Remarks ,Entry_Date ,Entry_By ,Maturity_Days ,Requisition_ID ,Entry_Branch_ID)SELECT  Cust_Code ,Amount ,(CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)) ,'Check' ,'' ,Received_By ,'Withdraw','" + GlobalVariableBO._userName + "',Requisition_Date,Remarks ,Entry_Date ,Entry_By ," + maturityDays + ",Sl_No ,Entry_Branch_ID FROM dbo.SBP_Check_Requisition WHERE Sl_No=" + paymentInfoBo.RequisitionId;


            string queryStringTemp = "INSERT INTO SBP_Money_Balance_Temp(Cust_Code,Sell_Deposit,Buy_Withdraw,Balance,Matured_Balance,Remarks,Rec_Date)"
                                     + " VALUES('" + paymentInfoBo.CustCode + "',0," + paymentInfoBo.Amount + "," + (0 - paymentInfoBo.Amount) + "," + (0 - paymentInfoBo.Amount) + ",'" + paymentInfoBo.PaymentMedia + "',(CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)));";

            try
            {
                _dbConnection.ConnectDatabase();
                _dbConnection.StartTransaction();
                _dbConnection.ExecuteNonQuery(queryUpdateRequisition);
                _dbConnection.ExecuteNonQuery(queryInsertPayment);
                _dbConnection.ExecuteNonQuery(queryStringTemp);
                _dbConnection.Commit();
            }
            catch (Exception)
            {
                _dbConnection.Rollback();
            }
            finally
            {
                _dbConnection.CloseDatabase();
            }
        }
Esempio n. 2
0
        public void InsertintoPaymentPosting(PaymentInfoBO paymentInfoBo, Payment_PostingBO postBo)// For Web
        {
            string queryString        = "";
            string queryDeleteWebData = "";
            Int32  AAA = postBo.OnlineOrderNo;

            CommonBAL             commonBAL = new CommonBAL();
            Web2014DataForwardBAL webBal    = new Web2014DataForwardBAL();

            paymentInfoBo.PaymentId = commonBAL.GenerateID("SBP_Payment_Posting_Request", "Payment_ID");
            DataTable dtMaturity   = new DataTable();
            int       maturityDays = 0;

            //dtMaturity = GetPaymentMediaMaturityDay(paymentInfoBo.IsMatureToday, paymentInfoBo.PaymentMedia);
            if (dtMaturity.Rows.Count > 0)
            {
                if (dtMaturity.Rows[0][0] != DBNull.Value)
                {
                    maturityDays = Convert.ToInt32(dtMaturity.Rows[0][0]);
                }
            }

            {
                queryString = @"INSERT INTO SBP_Payment_Posting_Request(
                                             --Payment_ID
                                            --,
                                            Cust_code
                                            ,Amount
                                            ,Received_Date
                                            ,Payment_Media
                                            ,Maturity_Days
                                            ,Payment_Media_No
                                            ,Payment_Media_Date
                                            ,Bank_ID
                                            ,Bank_Name
                                            ,Branch_ID
                                            ,Bank_Branch 
                                            ,RoutingNo
                                            ,BankAccNo
                                            ,Received_By
                                            ,Deposit_Withdraw
                                            ,Payment_Approved_By
                                            ,Payment_Approved_Date
                                            ,Remarks
                                            ,Entry_Date
                                            ,Entry_By
                                            ,Deposit_Bank_Name
                                            ,Deposit_Branch_Name
                                            ,Approval_Status
                                            ,Vouchar_SN
                                            ,Entry_Branch_ID
                                            ,OnlineOrderNo
                                            ,Channel
                                            ,OnlineEntry_Date                                           
                                            )"
                              +
                              " VALUES("
                              //+ paymentInfoBo.PaymentId
                              //+ ",'"
                              + "'" + paymentInfoBo.CustCode
                              + "'," + paymentInfoBo.Amount
                              + ",'" + paymentInfoBo.RecievedDate.ToString("MM-dd-yyyy")
                              + "','" + paymentInfoBo.PaymentMedia
                              + "'," + maturityDays
                              + ",'" + paymentInfoBo.PaymentMediaNo
                              + "','" + paymentInfoBo.PaymentMediaDate.ToString("MM-dd-yyyy")
                              + "','" + paymentInfoBo.Bank_ID
                              + "','" + paymentInfoBo.BankName
                              + "','" + paymentInfoBo.Branch_ID
                              + "','" + paymentInfoBo.BranchName
                              + "','" + paymentInfoBo.RoutingNo
                              + "','" + paymentInfoBo.BankAccNo
                              + "','" + paymentInfoBo.RecievedBy
                              + "','" + paymentInfoBo.DepositWithdraw
                              + "','" + paymentInfoBo.PaymentApprovedBy
                              + "'," + ((Convert.ToString(paymentInfoBo.PaymentApprovedDate) == string.Empty) ? "null" : "'" + paymentInfoBo.PaymentApprovedDate.Value.ToString("MM-dd-yyyy") + "'")
                              + ",'" + paymentInfoBo.Remarks + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME),'"
                              + GlobalVariableBO._userName
                              + "','" + ""
                              + "','" + ""
                              + "',1,'"
                              + paymentInfoBo.VoucherSlNo
                              + "'," + GlobalVariableBO._branchId
                              + "," + postBo.OnlineOrderNo
                              + ",'" + postBo.Channel
                              + "','" + Convert.ToString(postBo.OnlineEntry_Date.Date.Equals(DateTime.MinValue.Date) ? string.Empty : postBo.OnlineEntry_Date.ToString("MM-dd-yyyy"))
                              + "')";
            }

            if (postBo.OnlineOrderNo != 0 && postBo.OnlineOrderNo != null)
            {
                queryDeleteWebData = webBal.DeleteFrom_Web2014_WithdrawalRequest_Temp(postBo.OnlineOrderNo);
            }
            try
            {
                _dbConnection.ConnectDatabase();
                _dbConnection.StartTransaction();
                _dbConnection.ExecuteNonQuery(queryString);
                if (postBo.OnlineOrderNo != 0 && postBo.OnlineOrderNo != null)
                {
                    _dbConnection.ExecuteNonQuery(queryDeleteWebData);
                }
                _dbConnection.Commit();
            }
            catch (Exception ex)
            {
                _dbConnection.Rollback();
                throw ex;
            }
            finally
            {
                _dbConnection.CloseDatabase();
            }
        }
Esempio n. 3
0
        public void InsertDW_ReturnInfo_IntoPaymentPosting(PaymentInfoBO paymentInfoBo)//, string depositBank, string depositBranch)
        {
            string queryString = "";

            CommonBAL commonBAL = new CommonBAL();

            paymentInfoBo.PaymentId = commonBAL.GenerateID("SBP_Payment_Posting_Request", "Payment_ID");
            #region
            //DataTable dtMaturity = new DataTable();
            //int maturityDays = 0;
            //dtMaturity = GetPaymentMediaMaturityDay(paymentInfoBo.IsMatureToday, paymentInfoBo.PaymentMedia);
            //if (dtMaturity.Rows.Count > 0)
            //{
            //    if (dtMaturity.Rows[0][0] != DBNull.Value)
            //        maturityDays = Convert.ToInt32(dtMaturity.Rows[0][0]);
            //}
            //if (paymentInfoBo.DepositWithdraw == "Withdraw" && paymentInfoBo.PaymentMedia == Indication_PaymentTransaction.Cash)
            //{
            //    queryString = "INSERT INTO SBP_Payment_Posting_Request(     Payment_ID               ,       Cust_code,Amount         ,        Received_Date       ,                  Payment_Media                         ,            Maturity_Days           ,  Payment_Media_No  ,  Payment_Media_Date,           Bank_Name                                ,Bank_Branch ,   RoutingNo ,  BankAccNo ,  Received_By,        Deposit_Withdraw         ,         Payment_Approved_By           ,           Payment_Approved_Date         ,               Remarks                    ,            Entry_Date          ,Entry_By                                         ,           Deposit_Bank_Name,Deposit_Branch_Name,Approval_Status,Vouchar_SN,Entry_Branch_ID)" +
            //        " VALUES(" + paymentInfoBo.PaymentId + ",'" + paymentInfoBo.CustCode + "'," + paymentInfoBo.Amount + ",'" + paymentInfoBo.RecievedDate.ToString("MM-dd-yyyy") + "','" + paymentInfoBo.PaymentMedia + "'," + maturityDays + ",'" + "" + "','" + paymentInfoBo.PaymentMediaDate.ToString("MM-dd-yyyy") + "','" + paymentInfoBo.RoutingNo + "','" + paymentInfoBo.BankAccNo + "','" + "" + "','" + "" + "','" + paymentInfoBo.RecievedBy + "','" + paymentInfoBo.DepositWithdraw + "','" + paymentInfoBo.PaymentApprovedBy + "'," + ((Convert.ToString(paymentInfoBo.PaymentApprovedDate) == string.Empty) ? "null" : "'" + paymentInfoBo.PaymentApprovedDate.Value.ToString("MM-dd-yyyy") + "'") + ",'" + paymentInfoBo.Remarks + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME),'" + GlobalVariableBO._userName + "','" + "" + "','" + "" + "',0,'" + paymentInfoBo.VoucherSlNo + "'," + GlobalVariableBO._branchId + ")";
            //}
            //else
            //{
            //queryString = "INSERT INTO SBP_Payment_Posting_Request(Payment_ID,Cust_code,Amount,Received_Date,Payment_Media,Maturity_Days,Payment_Media_No,Payment_Media_Date,Bank_Name,Bank_Branch,RoutingNo,BankAccNo,Received_By,Deposit_Withdraw,Payment_Approved_By,Payment_Approved_Date,Remarks,Entry_Date,Entry_By,Deposit_Bank_Name,Deposit_Branch_Name,Approval_Status,Vouchar_SN,Entry_Branch_ID)" +
            //    " VALUES(" + paymentInfoBo.PaymentId + ",'" + paymentInfoBo.CustCode + "'," + paymentInfoBo.Amount + ",'" + paymentInfoBo.RecievedDate.ToString("MM-dd-yyyy") + "','" + paymentInfoBo.PaymentMedia + "'," + maturityDays + ",'" + paymentInfoBo.PaymentMediaNo + "','" + paymentInfoBo.PaymentMediaDate.ToString("MM-dd-yyyy") + "','" + paymentInfoBo.BankName + "','" + paymentInfoBo.BranchName + "','" + paymentInfoBo.RoutingNo + "','" + paymentInfoBo.BankAccNo + "','" + paymentInfoBo.RecievedBy + "','" + paymentInfoBo.DepositWithdraw + "','"
            //+ paymentInfoBo.PaymentApprovedBy + "'," + ((Convert.ToString(paymentInfoBo.PaymentApprovedDate) == string.Empty) ? "null" : "'" + paymentInfoBo.PaymentApprovedDate.Value.ToString("MM-dd-yyyy") + "'") + ",'" + paymentInfoBo.Remarks
            //+ "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME),'" + GlobalVariableBO._userName + "','" + paymentInfoBo.BankName + "','" + paymentInfoBo.BranchName + "',0,'" + paymentInfoBo.VoucherSlNo + "'," + GlobalVariableBO._branchId + ")";
//            queryString = @"INSERT INTO SBP_Payment_Posting_Request
//                            (
//                             Payment_ID
//                            ,Cust_code
//                            ,Amount
//                            ,Received_Date
//                            ,Payment_Media
//                            ,Payment_Media_No
//                            ,Payment_Media_Date
//                            ,Bank_Name
//                            ,Bank_Branch
//                            ,RoutingNo
//                            ,BankAccNo
//                            ,Deposit_Withdraw
//                            ,Vouchar_SN
//                            ,Trans_Reason
//                            ,Remarks
//                            ,Entry_Branch_ID
//                            )
//                            VALUES
//                            ( "
//                            + paymentInfoBo.PaymentId
//                            + ",'" + paymentInfoBo.CustCode
//                            + "'," + paymentInfoBo.Amount
//                            + ",'" + paymentInfoBo.RecievedDate.ToString("MM-dd-yyyy")
//                            + "','" + paymentInfoBo.PaymentMedia
//                            + "','" + paymentInfoBo.PaymentMediaNo
//                            + "','" + paymentInfoBo.PaymentMediaDate.ToString("MM-dd-yyyy")
//                            + "','" + paymentInfoBo.BankName
//                            + "','" + paymentInfoBo.BranchName
//                            + "','" + paymentInfoBo.RoutingNo
//                            + "','" + paymentInfoBo.BankAccNo
//                            + "','" + paymentInfoBo.DepositWithdraw
//                            + "','" + paymentInfoBo.VoucherSlNo
//                            + "','" + paymentInfoBo.TransReason
//                            + "','" + paymentInfoBo.Remarks
//                            + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)"
//                            +",'"+ GlobalVariableBO._userName
//                            + "','" + paymentInfoBo.BankName
//                            + "','" + paymentInfoBo.BranchName
//                            + "',0,'"
//                            + "'," + GlobalVariableBO._branchId
            //                            + ")";
            #endregion
            queryString = @"INSERT INTO [SBP_Database].[dbo].[SBP_Payment_Posting_Request]
                            (
                              --[Payment_ID]
                            --, 
                            [Cust_Code]
                            , [Amount]
                            , [Received_Date]
                            , [Payment_Media]
                            , [Payment_Media_No]
                            , [Payment_Media_Date]
                            , [Bank_ID]
                            , [Bank_Name]
                            , [Branch_ID]
                            , [Bank_Branch]
                            , [RoutingNo]
                            , [BankAccNo]
                            , [Received_By]
                            , [Deposit_Withdraw]
                            , [Payment_Approved_By]
                            , [Payment_Approved_Date]
                            , [Vouchar_SN]
                            , [Trans_Reason]
                            , [Remarks]
                            , [Entry_Date]
                            , [Entry_By]
                            , [Maturity_Days]
                            , [Deposit_Bank_Name]
                            , [Deposit_Branch_Name]
                            , [Approval_Status]
                            , [Rejection_Reason]
                            , [Entry_Branch_ID]
                            )
                            VALUES
                            ("

                          //+ paymentInfoBo.PaymentId
                          //+ ",'"
                          + "'" + paymentInfoBo.CustCode
                          + "'," + paymentInfoBo.Amount
                          + ",'" + paymentInfoBo.RecievedDate.ToString("MM-dd-yyyy")
                          + "','" + paymentInfoBo.PaymentMedia
                          + "','" + paymentInfoBo.PaymentMediaNo
                          + "','" + paymentInfoBo.PaymentMediaDate.ToString("MM-dd-yyyy")
                          + "'," + paymentInfoBo.Bank_ID
                          + ",'" + paymentInfoBo.BankName
                          + "'," + paymentInfoBo.Branch_ID
                          + ",'" + paymentInfoBo.BranchName
                          + "','" + paymentInfoBo.RoutingNo
                          + "','" + paymentInfoBo.BankAccNo
                          + "','" + paymentInfoBo.RecievedBy
                          + "','" + paymentInfoBo.DepositWithdraw
                          + "','" + paymentInfoBo.PaymentApprovedBy
                          + "'," + ((Convert.ToString(paymentInfoBo.PaymentApprovedDate) == string.Empty) ? "null" : "'" + paymentInfoBo.PaymentApprovedDate.Value.ToString("MM-dd-yyyy") + "'")
                          + ",'" + paymentInfoBo.VoucherSlNo
                          + "','" + paymentInfoBo.TransReason
                          + "','" + paymentInfoBo.Remarks
                          + "',CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)"
                          + ",'" + GlobalVariableBO._userName
                          + "',0"
                          + ",'" + ""
                          + "','" + ""
                          + "',0"
                          + ",'" + "" + "'"
                          + "," + GlobalVariableBO._branchId
                          + ")";

            //}
            try
            {
                _dbConnection.ConnectDatabase();
                _dbConnection.ExecuteNonQuery(queryString);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                _dbConnection.CloseDatabase();
            }
        }