private void InsertLog()
 {
     try
     {
         Admin_Alternative_Report_Bal bal = new Admin_Alternative_Report_Bal();
         CommonBAL comBal = new CommonBAL();
         DateTime  Today  = comBal.GetCurrentServerDate();
         bal.InsertAdminLog(ReportName, txt_Reason.Text.Trim(), Today);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
        private void btn_TodayCustMoneyBalance_Click(object sender, EventArgs e)
        {
            try
            {
                if (txt_Reason.Text == string.Empty)
                {
                    MessageBox.Show("You Should Writed Down The Reason");
                    return;
                }

                _branchId = GlobalVariableBO._branchId;
                Admin_Alternative_Report_Bal summeryReportBal = new Admin_Alternative_Report_Bal();
                DataTable dtCustMoneybalance = new DataTable();
                crCustTodayMoneyBalance crCustMoneyBalance = new crCustTodayMoneyBalance();
                CustMoneyBalanceViewer  custMoneyBalance   = new CustMoneyBalanceViewer();
                //dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(GlobalVariableBO._currentServerDate);
                dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(dtp_TodayBalanceDate.Value);

                _filterdColumnName = dtCustMoneybalance.Columns[0].ToString();
                RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustMoneybalance, _filterdColumnName, ResourceName.Todays_Summery_Report_Money_Balance);
                dtCustMoneybalance = obj.GetRecordLevelFilteredData();

                crCustMoneyBalance.SetDataSource(dtCustMoneybalance);


                ///// Load Company Name
                GetCommonInfo();
                ReportName = "TodayCustomerMoneyBalance";
                ((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;

                ///// Load Branch Name
                ((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
                ((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text  = dtp_TodayBalanceDate.Value.ToString("dd-MMM-yyyy");;
                custMoneyBalance.crvCustMoneyBalanceReportViewer.ReportSource = crCustMoneyBalance;
                custMoneyBalance.Show();
                InsertLog();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btn_TodayCustBalance_Click(object sender, EventArgs e)
        {
            try
            {
                //Validation
                if (txt_Reason.Text == string.Empty)
                {
                    MessageBox.Show("You Should Writed Down The Reason");
                    return;
                }

                _branchId = GlobalVariableBO._branchId;
                Admin_Alternative_Report_Bal summeryReportBal = new Admin_Alternative_Report_Bal();
                DataTable              dtCustToadysCustBal    = new DataTable();
                crTodayCustBalance     crTodayCustBal         = new crTodayCustBalance();
                TodayCustBalanceViewer todayCustBalanceViewer = new TodayCustBalanceViewer();
                dtCustToadysCustBal = summeryReportBal.GetTodaysCustBalance(dtp_TodayBalanceDate.Value);

                _filterdColumnName = dtCustToadysCustBal.Columns[0].ToString();
                RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustToadysCustBal, _filterdColumnName, ResourceName.Todays_Summery_Report_Cust_Balance);
                dtCustToadysCustBal = obj.GetRecordLevelFilteredData();

                crTodayCustBal.SetDataSource(dtCustToadysCustBal);

                GetCommonInfo();
                ReportName = "TodayCustomerTotalBalance";
                ///// Load Company Name
                ((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;

                ///// Load Branch Name
                ((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
                ((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text  = dtp_TodayBalanceDate.Value.ToString("dd-MMM-yyyy");
                todayCustBalanceViewer.crvTodayCustBalanceReportViewer.ReportSource     = crTodayCustBal;
                todayCustBalanceViewer.crvTodayCustBalanceReportViewer.DisplayGroupTree = false;
                todayCustBalanceViewer.Show();
                InsertLog();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btn_PaymentReveiw_Click(object sender, EventArgs e)
        {
            try
            {
                if (txt_Reason.Text == string.Empty)
                {
                    MessageBox.Show("You Should Writed Down The Reason");
                    return;
                }

                Admin_Alternative_Report_Bal paymentBAL = new Admin_Alternative_Report_Bal();
                DataTable              dtPaymentReview  = new DataTable();
                cr_NewPaymentReview    crPayment        = new cr_NewPaymentReview();
                frmPaymenrReportViewer paymentViewer    = new frmPaymenrReportViewer();
                LoadCommonInfo         CmmInfo          = new LoadCommonInfo();

                int issorted       = 0;
                int isAccountsView = 0;

                if (chk_SortedByCustCode.Checked)
                {
                    issorted = 1;
                }
                else
                {
                    issorted = 0;
                }

                if (chk_AccountView.Checked)
                {
                    isAccountsView = 1;
                }
                else
                {
                    isAccountsView = 0;
                }


                dtPaymentReview = paymentBAL.GnerateNewPaymentReview(dtp_PaymentReview_FromDate.Value, dtp_PaymentReveiw_ToDate.Value, issorted, isAccountsView);

                _filterdColumnName = dtPaymentReview.Columns[1].ToString();
                RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.New_Payment_Review);
                dtPaymentReview = obj.GetRecordLevelFilteredData();

                crPayment.SetDataSource(dtPaymentReview);

                GetCommonInfo();
                ReportName = "PaymentReviewSorted";
                ///// Load Company Name
                ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;

                ///// Load Branch Name
                ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchName + "," + _branchAddress + ",Phone: " + _branchContactNumber;

                ////Load Date
                ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = dtp_PaymentReview_FromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtp_PaymentReveiw_ToDate.Value.ToString("dd-MMM-yyyy");

                paymentViewer.crvPaymentReview.DisplayGroupTree = false;
                paymentViewer.crvPaymentReview.ReportSource     = crPayment;
                paymentViewer.Show();
                InsertLog();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }