public void ShowCustMoneyBalanceReport() { _branchId = GlobalVariableBO._branchId; SummeryReportBAL summeryReportBal = new SummeryReportBAL(); DataTable dtCustMoneybalance = new DataTable(); crCustTodayMoneyBalance crCustMoneyBalance = new crCustTodayMoneyBalance(); CustMoneyBalanceViewer custMoneyBalance = new CustMoneyBalanceViewer(); //dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(GlobalVariableBO._currentServerDate); dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(); _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(); ((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 = GlobalVariableBO._currentServerDate.ToString("dd-MMM-yyyy"); custMoneyBalance.crvCustMoneyBalanceReportViewer.ReportSource = crCustMoneyBalance; custMoneyBalance.Show(); }
private void ShowToadysCustBalanceReport() { _branchId = GlobalVariableBO._branchId; SummeryReportBAL summeryReportBal = new SummeryReportBAL(); DataTable dtCustToadysCustBal = new DataTable(); crTodayCustBalance crTodayCustBal = new crTodayCustBalance(); TodayCustBalanceViewer todayCustBalanceViewer = new TodayCustBalanceViewer(); dtCustToadysCustBal = summeryReportBal.GetTodaysCustBalance(); _filterdColumnName = dtCustToadysCustBal.Columns[0].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustToadysCustBal, _filterdColumnName, ResourceName.Todays_Summery_Report_Cust_Balance); dtCustToadysCustBal = obj.GetRecordLevelFilteredData(); crTodayCustBal.SetDataSource(dtCustToadysCustBal); GetCommonInfo(); ///// 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 = GlobalVariableBO._currentServerDate.ToString("dd-MMM-yyyy"); todayCustBalanceViewer.crvTodayCustBalanceReportViewer.ReportSource = crTodayCustBal; todayCustBalanceViewer.crvTodayCustBalanceReportViewer.DisplayGroupTree = false; todayCustBalanceViewer.Show(); }
private void GetCommonOpexReport(DateTime fromDate, DateTime toDate) { try { cr_CommonExpenditureReport objcrCommonOpex = new cr_CommonExpenditureReport(); DataTable dataTable = new DataTable(); frmReportViewer objReportviewer = new frmReportViewer(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); int TempBranchId = -2; OpexBAL objOpexBal = new OpexBAL(); int BranchId = Int32.Parse(ddlBranchList.SelectedValue.ToString()); int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Common_Expenditure); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); if (BranchId == 0) { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(BranchId.ToString(), resourceId, criteriaId)); if (TempBranchId == 0) { dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId); } else { dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId); dataTable.Rows.Clear(); } } else { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(BranchId.ToString(), resourceId, criteriaId)); dataTable = objOpexBal.GetCommonOpexReport(fromDate, toDate, TempBranchId); } objcrCommonOpex.SetDataSource(dataTable); GetCommonInfo(); ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtReport"]).Text = "Common Expenditure"; ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtFrom"]).Text = fromDate.ToString("yyyy"); ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtTo"]).Text = toDate.ToString("yyyy"); ((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text; objReportviewer.crvReportViewer.ReportSource = objcrCommonOpex; objReportviewer.crvReportViewer.ShowGroupTreeButton = false; objReportviewer.Text = "Common Expenditure"; objReportviewer.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadReport() { ShareListBAL shareBal = new ShareListBAL(); DataTable dtParticipatoryInfo = new DataTable(); dtParticipatoryInfo = shareBal.GetParticipatoryInfo(); ShareListBO shareListBo = new ShareListBO(); shareListBo.DtTo = dtTo; shareListBo.DtFrom = dtFrom; shareListBo.WorkStation = workStation; DataTable dataTable = new DataTable(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); string TempWorkstation = ""; int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Workstation_wise_Trade_Share_List); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); if (workStation == "All") { TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(workStation, resourceId, criteriaId); if (TempWorkstation == "All") { dataTable = shareBal.GetShareInfo(shareListBo); } else { dataTable = shareBal.GetShareInfo(shareListBo); dataTable.Rows.Clear(); } } else { dataTable = shareBal.GetShareInfo(shareListBo); TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(workStation, resourceId, criteriaId); if (TempWorkstation == "") { dataTable.Rows.Clear(); } } crShareReport crShareListReport = new crShareReport(); ((TextObject)crShareListReport.ReportDefinition.ReportObjects["txtCompanyName"]).Text = dtParticipatoryInfo.Rows[0]["Name"].ToString(); ((TextObject)crShareListReport.ReportDefinition.ReportObjects["txtBranchName"]).Text = dtParticipatoryInfo.Rows[0]["Branch_Name"].ToString() + " Branch" + dtParticipatoryInfo.Rows[0]["Address"].ToString(); if (shareListBo.DtFrom != null && shareListBo.DtTo != null) { ((TextObject)crShareListReport.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "From " + shareListBo.DtFrom.ToShortDateString() + " To " + shareListBo.DtTo.ToShortDateString(); } crShareListReport.SetDataSource(dataTable); CrvShareList.ReportSource = crShareListReport; }
public void ShowSellReport() { _branchId = GlobalVariableBO._branchId; _transDate = Convert.ToDateTime(dtTransactionDate.Value.ToShortDateString()); _CustWise = rdoCustwise.Checked; _InstruWise = rdoInstruWise.Checked; SellShareListReviewBAL sellShareListReviewBal = new SellShareListReviewBAL(); DataTable dtSellShareListReview = new DataTable(); if (_CustWise) { crCustWiseSellShareList crSellShareListReview = new crCustWiseSellShareList(); CustWiseSellShareListReportViewer sellShareListReportViewer = new CustWiseSellShareListReportViewer(); dtSellShareListReview = sellShareListReviewBal.GetCustWiseSellShareList(_transDate); _filterdColumnName = dtSellShareListReview.Columns[0].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtSellShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List); dtSellShareListReview = obj.GetRecordLevelFilteredData(); crSellShareListReview.SetDataSource(dtSellShareListReview); GetCommonInfo(); ((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; if (_transDate != null) { ((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd-MMM-yy"); } sellShareListReportViewer.crvSellShareList.ReportSource = crSellShareListReview; sellShareListReportViewer.Show(); } else if (_InstruWise) { crInstruWiseSellShareList crInstruWiseSellSharelist = new crInstruWiseSellShareList(); InstruWiseSellReportViewer insWiseSellReport = new InstruWiseSellReportViewer(); dtSellShareListReview = sellShareListReviewBal.GetInstruWiseSellShareList(_transDate); _filterdColumnName = dtSellShareListReview.Columns[2].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtSellShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List); dtSellShareListReview = obj.GetRecordLevelFilteredData(); crInstruWiseSellSharelist.SetDataSource(dtSellShareListReview); GetCommonInfo(); ((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; if (_transDate != null) { ((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd-MMM-yy"); } insWiseSellReport.crvInstruWiseSellReportViewer.ReportSource = crInstruWiseSellSharelist; insWiseSellReport.Show(); } else { MessageBox.Show("Please Select the report category first."); } }
public void ShowCustSummeryReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; CustomerSummeryBAL customerSummeryBal = new CustomerSummeryBAL(); crCustomerSummery crCustomerSumm = new crCustomerSummery(); CustomerSummeryViewer custSumViewer = new CustomerSummeryViewer(); DataTable dtCustSummery = new DataTable(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Summery_Ledger); string T_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger); dtCustSummery = customerSummeryBal.GetCustSummery(T_custCode, _fromDate, _toDate); crCustomerSumm.SetDataSource(dtCustSummery); ////Load Summery Data DataTable dtSummeryTrans = new DataTable(); DataTable dtPaymentSummery = new DataTable(); string summerycustCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger); dtSummeryTrans = customerSummeryBal.GetSummeryDataTransaction(summerycustCode, _fromDate, _toDate); string paymentcustCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger); dtPaymentSummery = customerSummeryBal.GetSummeryDataPayment(paymentcustCode, _fromDate, _toDate); if (dtSummeryTrans.Rows.Count > 0) { ((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtBuyAmount"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalBuyAmount"]); ((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtSellAmount"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalSellAmount"]); ((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtCommission"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalCommission"]); } if (dtPaymentSummery.Rows.Count > 0) { ((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtReceived"]).Text = String.Format("{0:0.##}", dtPaymentSummery.Rows[0]["TotalDeposit"]); ((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtWithdraw"]).Text = String.Format("{0:0.##}", dtPaymentSummery.Rows[0]["TotalWithdraw"]); } GetCommonInfo(); ///// Load Company Name ((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ///// Load Branch Name ((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ////Load Date if (_fromDate != null && _toDate != null) { ((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Duration : " + _fromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy"); } custSumViewer.crvCustSummeryReportViewer.ReportSource = crCustomerSumm; custSumViewer.crvCustSummeryReportViewer.DisplayGroupTree = false; custSumViewer.Show(); }
public void ShowCustMoneyLedgerReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; MoneyLadgerReportBAL moneyLedgerReportBal = new MoneyLadgerReportBAL(); DataTable dtAccruedBalance = new DataTable(); DataTable dtCustBasicInfo = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); crAccruedBalance rpt = new crAccruedBalance(); frmReportViewer viewer = new frmReportViewer(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Money_Ledger); string T_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Money_Ledger); dtCustBasicInfo = moneyLedgerReportBal.GetCustBasicInfo(T_custCode); if (dtCustBasicInfo.Rows.Count > 0) { ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = "Cust. Name: " + dtCustBasicInfo.Rows[0]["Cust_Name"].ToString(); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = "Cust. Code: " + dtCustBasicInfo.Rows[0]["Cust_Code"].ToString(); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtBalanceBefore"]).Text = "Balance Before : " + dtFromDate.Value.ToString("dd-MMM-yy"); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text = "Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtToDate.Value.ToString("dd-MMM-yyyy"); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "Accrued Balance Report"; } else { ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text = "Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtToDate.Value.ToString("dd-MMM-yyyy"); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "Accrued Balance Report"; } dtAccruedBalance = moneyLedgerReportBal.GetAccruedBalanceData(T_custCode, _fromDate, _toDate); rpt.SetDataSource(dtAccruedBalance); GetCommonInfo(); ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name: " + _branchName + "," + _branchAddress + ". Phone: " + _branchContactNumber; viewer.crvReportViewer.ReportSource = rpt; viewer.Show(); }
private void SetExistingPrevillizeState() { RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default); criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); isAllLimit = recordLevelFilteringBAL.Check_All_Limit(resourceId, criteriaId); isAllHide = recordLevelFilteringBAL.Check_All_Hide(resourceId, criteriaId); isExistLimit = recordLevelFilteringBAL.isExistLimit(resourceId, criteriaId); isExistHide = recordLevelFilteringBAL.isExistHide(resourceId, criteriaId); }
private void GetNewPaymentReview() { try { PaymentReviewBAL paymentBAL = new PaymentReviewBAL(); 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 (chbOder.Checked) { issorted = 1; } else { issorted = 0; } dtPaymentReview = paymentBAL.GnerateNewPaymentReview(dtpFromDate.Value, dtpToDate.Value, issorted); _filterdColumnName = dtPaymentReview.Columns[1].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.New_Payment_Review); dtPaymentReview = obj.GetRecordLevelFilteredData(); crPayment.SetDataSource(dtPaymentReview); GetCommonInfo(); ///// 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 = dtpFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtpToDate.Value.ToString("dd-MMM-yyyy"); paymentViewer.crvPaymentReview.DisplayGroupTree = false; paymentViewer.crvPaymentReview.ReportSource = crPayment; paymentViewer.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void ShowMonthlyExpenseReport(DateTime FromDate, DateTime ToDate) { try { AssetInformationBAL objAssetInfoBal = new AssetInformationBAL(); DataTable dtMonthlyExpenseInfo = new DataTable(); cr_MonthlyExpenseReport objcrMonthlyExpenseInfo = new cr_MonthlyExpenseReport(); frmReportViewer objfrmMonthlyExpenseInfo = new frmReportViewer(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); int TempBranchId = -2; dtMonthlyExpenseInfo = objAssetInfoBal.GetMonthlyCapexReport(FromDate, ToDate); int branchid = Int32.Parse(dtMonthlyExpenseInfo.Rows[0][10].ToString()); int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Monthly_Expense_List); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId)); if (TempBranchId == -1) { dtMonthlyExpenseInfo.Rows.Clear(); } objcrMonthlyExpenseInfo.SetDataSource(dtMonthlyExpenseInfo); ((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = "Fom: " + dtpFromDate.Value.ToString("MM-dd-yyyy"); ((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = "To: " + dtpToDate.Value.ToString("MM-dd-yyyy"); GetCommonInfo(); ((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; objfrmMonthlyExpenseInfo.Text = "Monthly Expense Report"; objfrmMonthlyExpenseInfo.crvReportViewer.ReportSource = objcrMonthlyExpenseInfo; objfrmMonthlyExpenseInfo.Show(); } catch (Exception) { throw; } }
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_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 GetCurrentAssetList() { try { AssetInformationBAL objAssetInformationBal = new AssetInformationBAL(); DataTable dtCurrentAssetList = new DataTable(); frmReportViewer objfrmReportViewer = new frmReportViewer(); cr_CurrentAssetList objcrCurrentAssetList = new cr_CurrentAssetList(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); dtCurrentAssetList = objAssetInformationBal.GetCurrentAssetInfo(); int TempBranchId = -2; int branchid = Int32.Parse(dtCurrentAssetList.Rows[0][8].ToString()); int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Current_Asset_List); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId)); if (TempBranchId == -1) { dtCurrentAssetList.Rows.Clear(); } objcrCurrentAssetList.SetDataSource(dtCurrentAssetList); GetCommonInfo(); ((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; objfrmReportViewer.crvReportViewer.ReportSource = objcrCurrentAssetList; objfrmReportViewer.crvReportViewer.DisplayGroupTree = false; objfrmReportViewer.Text = "Current Asset List"; objfrmReportViewer.Show(); } catch (Exception) { throw; } }
private void ShowPortFolioReportInvestorWise() { cr_DSE_22_1 objcr_DSE_22_1Report = new cr_DSE_22_1(); DataTable dtProtofolioReportInvestorwise = new DataTable(); DESReportBal objPortfolioBal = new DESReportBal(); CustShareSummeryViewer objfrm_DSE_22_1_Report = new CustShareSummeryViewer(); string deposit = "0.00"; string withdraw = "0.00"; string balance = "0.00"; string accruedbalance = "0.00"; string IPObalance = "0.00"; string availablebalance = "0.00"; string netbalance = "0.00"; try { ShareLedgerBAL shareLedgerBal = new ShareLedgerBAL(); DataTable dtCustSummerybasic = new DataTable(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); string T_Custcode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); if (T_Custcode == "") { MessageBox.Show("You are restricted"); return; } dtCustSummerybasic = shareLedgerBal.GetCustomerSummerBasicInfo(T_Custcode, dtToDate.Value); if (dtCustSummerybasic.Rows.Count != 0) { deposit = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Dep_Amount"]).ToString("N"); withdraw = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Withdraw_Amount"]).ToString("N"); balance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Head_Balance"]).ToString("N"); accruedbalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Accrued_Balance"]).ToString("N"); IPObalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["IPO_Balance"]).ToString("N"); availablebalance = (Convert.ToDecimal(balance) - (Convert.ToDecimal(accruedbalance))).ToString("N"); netbalance = (Convert.ToDecimal(availablebalance) + Convert.ToDecimal(IPObalance)).ToString("N"); } string temp_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); dtProtofolioReportInvestorwise = objPortfolioBal.Get_DSE_22_1_Report(temp_custCode, dtToDate.Value); objcr_DSE_22_1Report.SetDataSource(dtProtofolioReportInvestorwise); GetCommonInfo(); ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBranchInfo"]).Text = _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = txtCustCode.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBOID"]).Text = txtAccountHolderBOId.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = txtAccountHolderName.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtDeposit"]).Text = deposit; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtWithdraw"]).Text = withdraw; //((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBalance"]).Text = // balance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCurrentTradeBalance"]).Text = balance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtTotalAcrudeCharge"]).Text = accruedbalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtAvailableBalance"]).Text = availablebalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtIPOBalance"]).Text = IPObalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtNetBalance"]).Text = netbalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["asOnDate"]).Text = dtToDate.Value.ToString("dd/MMM/yyyy"); objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.ReportSource = objcr_DSE_22_1Report; objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.DisplayGroupTree = false; objfrm_DSE_22_1_Report.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Portfolio Report Investor Wise", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void ShowCustShareLedgerReport() { _branchId = GlobalVariableBO._branchId; _shareSummery = rdoShareSummery.Checked; _Details = rdoDetailShareLedger.Checked; _SpecificPeriod = rdoSpecificPeriodShareLedger.Checked; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; ShareLedgerBAL shareLedgerBal = new ShareLedgerBAL(); _maxPriceDate = shareLedgerBal.GetMaxPriceDate(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); if (_shareSummery) { ShowPortFolioReportInvestorWise(); } else if (_Details) { crShareDetails crShareDetail = new crShareDetails(); ShareDetailsViewer shareDetailViewer = new ShareDetailsViewer(); DataTable dtShareDetails = new DataTable(); string Temp_Custcode = ""; RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Share_Ledger_Share_Portfolio_Details_Specific_Period); Temp_Custcode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Details_Specific_Period); dtShareDetails = shareLedgerBal.GetShareDetails(Temp_Custcode); crShareDetail.SetDataSource(dtShareDetails); ///// Load Company Name ((TextObject)crShareDetail.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crShareDetail.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); shareDetailViewer.crvShareDetailsReportViewer.ReportSource = crShareDetail; shareDetailViewer.Show(); } else if (_SpecificPeriod) { //crSpecificShareLedger crSpecificShare = new crSpecificShareLedger(); crShareDetails crSpecificShare = new crShareDetails(); SpecificShareLedgerViewer specificShareLedgerViewer = new SpecificShareLedgerViewer(); DataTable dtSpecificShareLedger = new DataTable(); string Temp_Custcode = ""; RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Share_Ledger_Share_Portfolio_Details_Specific_Period); Temp_Custcode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Details_Specific_Period); dtSpecificShareLedger = shareLedgerBal.GetSpecificShareLedger(Temp_Custcode, _fromDate, _toDate); crSpecificShare.SetDataSource(dtSpecificShareLedger); ///// Load Company Name ((TextObject)crSpecificShare.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crSpecificShare.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); ((TextObject)crSpecificShare.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text = "Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtToDate.Value.ToString("dd-MMM-yyyy"); specificShareLedgerViewer.crvSpecificShareLedgerReportViewer.ReportSource = crSpecificShare; specificShareLedgerViewer.Show(); } else { MessageBox.Show("Please Select the report category first."); } }
public void ShowTradeSummeryReport() { _workStation = ""; _branchId = GlobalVariableBO._branchId; _FromDate = dtpFrom.Value; _toDate = dtpTo.Value; _marketType = chkMarketType.Checked; _workStation = ddlWorkStation.Text; if (_workStation == "All") { _workStation = "0"; } TradeSummeryBAL tradeSummeryBal = new TradeSummeryBAL(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); GetCommonInfo(); resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default); criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); if (_marketType) { crSpotTradeSummery crSpotTradeSumm = new crSpotTradeSummery(); SpotTradeSummeryReportViewer spotTradeSummeryReport = new SpotTradeSummeryReportViewer(); DataTable dtSpotTradeSummery = new DataTable(); string TempWorkstation = ""; // SetExistingPrevillizeState(); // FilterAllWorkStation if (_workStation == "0") { TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(_workStation, resourceId, criteriaId); if (TempWorkstation != "") { dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate); } //else if (!isAllLimit && !isAllHide && !isExistLimit && !isExistHide) //{ // dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate); //} else { dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate); dtSpotTradeSummery.Rows.Clear(); } } else { dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate); TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(_workStation, resourceId, criteriaId); if (TempWorkstation == "") { dtSpotTradeSummery.Rows.Clear(); } } crSpotTradeSumm.SetDataSource(dtSpotTradeSummery); ((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtDuration"]).Text = "From " + _FromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy"); ((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; spotTradeSummeryReport.crvSpotTradeSummery.ReportSource = crSpotTradeSumm; spotTradeSummeryReport.crvSpotTradeSummery.DisplayGroupTree = false; spotTradeSummeryReport.Show(); } else { crTradeSummery crTradeSumm = new crTradeSummery(); TradeSummeryReportViewer tradeSummeryReport = new TradeSummeryReportViewer(); DataTable dtTradeSummery = new DataTable(); DataTable dtCashFlow = new DataTable(); string TempWorkstation = ""; //int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default); //int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); if (_workStation == "0") { //isAllLimit = recordLevelFilteringBAL.Check_All_Limit(resourceId, criteriaId); //isAllHide = recordLevelFilteringBAL.Check_All_Hide(resourceId, criteriaId); //isExistLimit = recordLevelFilteringBAL.isExistLimit(resourceId, criteriaId); //isExistHide = recordLevelFilteringBAL.isExistHide(resourceId, criteriaId); TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(_workStation, resourceId, criteriaId); if (TempWorkstation != "") { dtTradeSummery = tradeSummeryBal.GetTradeSummery(_workStation, _FromDate, _toDate); dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate); } else { dtTradeSummery = tradeSummeryBal.GetTradeSummery(_workStation, _FromDate, _toDate); dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate); dtTradeSummery.Rows.Clear(); dtCashFlow.Rows.Clear(); } } else { dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate); TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(_workStation, resourceId, criteriaId); if (TempWorkstation == "") { dtCashFlow.Rows.Clear(); } dtTradeSummery = tradeSummeryBal.GetTradeSummery(TempWorkstation, _FromDate, _toDate); } crTradeSumm.SetDataSource(dtTradeSummery); ((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtDuration"]).Text = "From " + _FromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy"); ((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; crTradeSumm.Subreports[0].SetDataSource(dtCashFlow); tradeSummeryReport.crvTradeSummery.ReportSource = crTradeSumm; tradeSummeryReport.Show(); } }
//private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping) //{ // try // { // if (Grouping == Indication_ExpenseReports.Expense_Grouping_Monthly) // { // cr_MonthlyOpex objcrmonthlyopex = new cr_MonthlyOpex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objcrmonthlyopex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name +" Report: Monthly Wise"; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Monthly wise"; // objreportviewer.Show(); // } // else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Daily) // { // cr_DailyOpex objctDailyOpex = new cr_DailyOpex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objctDailyOpex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+" Report: Daily Wise"; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // //((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objctDailyOpex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Daily wise"; // objreportviewer.Show(); // } // else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Yearly) // { // cr_YearlyOPex objctYearlyOpex = new cr_YearlyOPex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objctYearlyOpex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "branch name:" + _branchName + "," + _branchAddress + ". phone:" + _branchContactNumber; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+ " Report: Yearly wise"; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objctYearlyOpex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Yearly wise"; // objreportviewer.Show(); // } // } // catch (Exception) // { // throw; // } //} private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping) { try { cr_ExpenseReport objcrmonthlyopex = new cr_ExpenseReport(); DataTable datatable = new DataTable(); frmReportViewer objreportviewer = new frmReportViewer(); RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); ExpenseEntryBAL exbal = new ExpenseEntryBAL(); bool IsExpensedate = false; int tempbranchid = -2; int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); if (rd_ExpenseDate.Checked) { IsExpensedate = rd_ExpenseDate.Checked; } if (BranchID == Indication_BrokerBranch.HeadOffice_ID) { tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); if (BranchID != tempbranchid) { MessageBox.Show("you are restricted"); return; } else { datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate); } } else { tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); if (BranchID != tempbranchid) { MessageBox.Show("you are restricted"); return; } else { datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate); } } ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = (object)Grouping; objcrmonthlyopex.SetDataSource(datatable); GetCommonInfo(); ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;; ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-MMM-yyyy") + " To " + toDate.ToString("dd-MMM-yyyy"); //((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtDate"]).Text = IsExpensedate ? "Expense Date" : "Payment Date"; objcrmonthlyopex.ParameterFields["GroupingDate"].CurrentValues.Add(pdv); objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex; objreportviewer.Text = "Expense Report "; objreportviewer.Show(); } catch (Exception) { throw; } }
private void GetCustomizedOpexReport(DateTime fromDate, DateTime toDate) { try { cr_CustomizedOpex objcrcustomizedOpex = new cr_CustomizedOpex(); DataTable dataTable = new DataTable(); frmReportViewer objReportviewer = new frmReportViewer(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); OpexBAL objOpexBal = new OpexBAL(); int TempBranchId = -2; int BranchId = Int32.Parse(ddlBranchList.SelectedValue.ToString()); int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Daily_Expenditure_Customized_Opex); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); if (BranchId == 0) { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(BranchId.ToString(), resourceId, criteriaId)); if (BranchId != TempBranchId) { MessageBox.Show("You are restricted"); return; } else { dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId); } } else { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(BranchId.ToString(), resourceId, criteriaId)); if (BranchId != TempBranchId) { MessageBox.Show("You are restricted"); return; } else { dataTable = objOpexBal.GetCustomizedOpexReport(fromDate, toDate, TempBranchId); } } objcrcustomizedOpex.SetDataSource(dataTable); GetCommonInfo(); ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtReport"]).Text = "Daily Opex Report: Customized"; ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtFrom"]).Text = fromDate.ToString("MMMM-yyyy"); ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtTo"]).Text = toDate.ToString("MMMM-yyyy"); ((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text; objReportviewer.crvReportViewer.ReportSource = objcrcustomizedOpex; objReportviewer.crvReportViewer.DisplayGroupTree = true; objReportviewer.Text = "Daily Opex Report: Customized"; objReportviewer.Show(); } catch (Exception) { throw; } }
private void GetDailyDaywiseOpexReport(DateTime fromDate, DateTime toDate) { try { cr_groupByBranchDailyOpexReport objcrDailyOpex = new cr_groupByBranchDailyOpexReport(); DataTable dataTable = new DataTable(); frmReportViewer objReportviewer = new frmReportViewer(); RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL(); OpexBAL objOpexBal = new OpexBAL(); int TempBranchId = -2; int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Daily_Expenditure_group_By_Branch_Daily_Opex_Report); int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId); int branchId = Int32.Parse(ddlBranchList.SelectedValue.ToString()); if (branchId == 0) { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(branchId.ToString(), resourceId, criteriaId)); if (TempBranchId == 0) { dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId); } else { //dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, branchId); //dataTable.Rows.Clear(); MessageBox.Show("You are restricted"); return; } } else if (branchId != 0) { TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchId.ToString(), resourceId, criteriaId)); if (branchId != TempBranchId) { MessageBox.Show("You are restricted"); return; } dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId); } objcrDailyOpex.SetDataSource(dataTable); GetCommonInfo(); ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtReportTitle"]).Text = "Day wise Daily Opex "; ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtFromDate"]).Text = fromDate.ToString("dd-MMM-yyyy"); ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtToDate"]).Text = toDate.ToString("dd-MMM-yyyy"); ((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text; objReportviewer.crvReportViewer.ReportSource = objcrDailyOpex; objReportviewer.Text = "Daily Opex Report : Day wise"; objReportviewer.Show(); } catch (Exception) { throw; } }
public void ShowClientConfirmationReport() { _branchId = GlobalVariableBO._branchId; _viewReport = rdoViewReport.Checked; _printClientCopy = rdoClientCopy.Checked; _printOfficeCopy = rdoOfficeCopy.Checked; _transDate = Convert.ToDateTime(dtTransDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; ClientConfirmationBAL clientConfirmationBal = new ClientConfirmationBAL(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); if (_viewReport) { if (txtCustCode.Text.Trim() == "") { MessageBox.Show("Select a customer first.", "Warning!"); return; } crClientConfirmation crClientConfirm = new crClientConfirmation(); ClientConfirmationViewer clientConfirmation = new ClientConfirmationViewer(); DataTable dtClientBasicData = new DataTable(); DataTable dtClientConfirmation = new DataTable(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Confirmation_default); // _filterdColumnName = obj.GetFilteredColumnName(ResourceName.Customer_Confirmation_default); string T_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Confirmation_default); if (T_custCode == "") { MessageBox.Show("You are restricted "); return; } dtClientBasicData = clientConfirmationBal.GetClientBasicData(T_custCode, _transDate); if (dtClientBasicData.Rows.Count > 0) { ((TextObject)crClientConfirm.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = dtClientBasicData.Rows[0]["Cust_Name"].ToString(); ((TextObject)crClientConfirm.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = dtClientBasicData.Rows[0]["Cust_Code"].ToString(); ((TextObject)crClientConfirm.ReportDefinition.Sections[2].ReportObjects["txtTradeDate"]).Text = dtClientBasicData.Rows[0]["Trade_Date"].ToString(); ((TextObject)crClientConfirm.ReportDefinition.Sections[4].ReportObjects["txtTradeDate2"]).Text = "(" + dtClientBasicData.Rows[0]["Trade_Date"].ToString() + ")"; // ((TextObject) crClientConfirm.ReportDefinition.Sections[4].ReportObjects["txtTradeDate3"]).Text =dtClientBasicData.Rows[0]["Trade_Date"].ToString(); ((TextObject)crClientConfirm.ReportDefinition.Sections[4].ReportObjects["txtInterestCharge"]).Text = dtClientBasicData.Rows[0]["Interest"].ToString(); } string temp_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Confirmation_default); dtClientConfirmation = clientConfirmationBal.GetClientConfirmation(temp_custCode, _transDate); crClientConfirm.SetDataSource(dtClientConfirmation); ///// Load Company Name ((TextObject)crClientConfirm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crClientConfirm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); clientConfirmation.crvClientConfirmationReportViewer.ReportSource = crClientConfirm; clientConfirmation.Show(); } else if (_printClientCopy) { crClientConfirmationClientCopy crClientCopy = new crClientConfirmationClientCopy(); ClientConfirmationClientCopyViewer clientCopyViewer = new ClientConfirmationClientCopyViewer(); DataTable dtClientConfClientCopy = new DataTable(); dtClientConfClientCopy = clientConfirmationBal.getClientConfirmationClientCopy(_transDate); _filterdColumnName = dtClientConfClientCopy.Columns[0].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtClientConfClientCopy, _filterdColumnName, ResourceName.Customer_Confirmation_ClientCopy); dtClientConfClientCopy = obj.GetRecordLevelFilteredData(); crClientCopy.SetDataSource(dtClientConfClientCopy); //Load Trade date ((TextObject)crClientCopy.ReportDefinition.Sections[2].ReportObjects["txtTradeDate"]).Text = dtTransDate.Value.ToShortDateString(); ((TextObject)crClientCopy.ReportDefinition.Sections[3].ReportObjects["txtTradeDate2"]).Text = dtTransDate.Value.ToShortDateString(); ((TextObject)crClientCopy.ReportDefinition.Sections[3].ReportObjects["txtTradeDate3"]).Text = dtTransDate.Value.ToShortDateString(); ///// Load Company Name ((TextObject)crClientCopy.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crClientCopy.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); clientCopyViewer.crvClientConfirmationClientCopyViewer.ReportSource = crClientCopy; clientCopyViewer.Show(); } else if (_printOfficeCopy) { crClientConfirmationOfficeCopy crOfficeCopy = new crClientConfirmationOfficeCopy(); ClientConfirmationOfficeCopyViewer officeCopyViewer = new ClientConfirmationOfficeCopyViewer(); DataTable dtClientConfOfficeCopy = new DataTable(); dtClientConfOfficeCopy = clientConfirmationBal.GetClientConfirmationOfficeCopy(_transDate); _filterdColumnName = dtClientConfOfficeCopy.Columns[0].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtClientConfOfficeCopy, _filterdColumnName, ResourceName.Customer_Confirmation_OfficeCopy); dtClientConfOfficeCopy = obj.GetRecordLevelFilteredData(); crOfficeCopy.SetDataSource(dtClientConfOfficeCopy); //Load Trade date ((TextObject)crOfficeCopy.ReportDefinition.Sections[2].ReportObjects["txtTradeDate"]).Text = dtTransDate.Value.ToShortDateString(); ((TextObject)crOfficeCopy.ReportDefinition.Sections[3].ReportObjects["txtTradeDate2"]).Text = dtTransDate.Value.ToShortDateString(); ((TextObject)crOfficeCopy.ReportDefinition.Sections[3].ReportObjects["txtTradeDate3"]).Text = dtTransDate.Value.ToShortDateString(); ///// Load Company Name ((TextObject)crOfficeCopy.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crOfficeCopy.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); officeCopyViewer.crvClientConfirmationOfficeCopyViewer.ReportSource = crOfficeCopy; officeCopyViewer.Show(); } else { MessageBox.Show("Please Select the report category first."); } }
private void btnGrnerateReport_Click(object sender, EventArgs e) { if (rdbTaxCertificate.Checked == true) { if (txtCustCode.Text.Trim() != "") { if (_reportNo == "1") { ShowCustTaxStatement(); } else { ShowCustMoneyLedgerReport(); } } else { MessageBox.Show("Select a customer first.", "Warning!"); } } if (rdbTaxStatement.Checked == true) { custCode = txtCustCode.Text; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); DataSet TaxDataSet = new DataSet(); DataTable TaxStatement = new DataTable(); DataTable BonusRightIPOSatement = new DataTable(); DataTable TaxStatementSummary = new DataTable(); TaxStatementBAL TaxStatementBAL = new TaxStatementBAL(); crTaxStatement crTaxStatement = new crTaxStatement(); crTaxStatementBonusIPO crTaxStatementBonusRightIPO_Rpt = new crTaxStatementBonusIPO(); crTaxStatementSummarySubReport crTaxStatementSummarySubReport = new crTaxStatementSummarySubReport(); frmPaymentReceiptSummaryViewer ReportViewer = new frmPaymentReceiptSummaryViewer(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Tax_TaxStatement); string T_Custcode = obj.FilterCustCode(_custCode, ResourceName.Tax_TaxStatement); if (T_Custcode == "") { MessageBox.Show("You are restricted"); return; } TaxDataSet = TaxStatementBAL.GetData(custCode, _fromDate, _toDate); if (TaxDataSet.Tables.Count > 3) { TaxStatement = TaxDataSet.Tables[0]; BonusRightIPOSatement = TaxDataSet.Tables[1]; TaxStatementSummary = TaxDataSet.Tables[3]; } crTaxStatement.DataSourceConnections.Clear(); crTaxStatement.SetDataSource(TaxStatement); crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].DataSourceConnections.Clear(); crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].SetDataSource(BonusRightIPOSatement); crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].DataSourceConnections.Clear(); crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].SetDataSource(TaxStatementSummary); GetCommonInfo(); ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = dtFromDate.Value.ToString("dd/MM/yyyy"); ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = dtToDate.Value.ToString("dd/MM/yyyy"); ((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = _fromDate.ToString("dd-MM-yyyy"); ((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = _toDate.ToString("dd-MM-yyyy"); ReportViewer.crystalReportViewer1.DisplayGroupTree = false; ReportViewer.crystalReportViewer1.ReportSource = crTaxStatement; ReportViewer.Show(); } }
public void ShowCustMoneyLedgerReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; MoneyLadgerReportBAL moneyLedgerReportBal = new MoneyLadgerReportBAL(); DataTable dtCustmoneyLedger = new DataTable(); DataTable dtCustBasicInfo = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); crNewCustMoneyLedger crNewCustMoneyledger = new crNewCustMoneyLedger(); crCustMoneyLedger crCustMoneyledger = new crCustMoneyLedger(); CustMoneyLedgerViewer moneyLedgerViewer = new CustMoneyLedgerViewer(); frmReportViewer viewer = new frmReportViewer(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Money_Ledger); if (tempMenuPurpose != newCustomerMoneyBalance) { string T_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Money_Ledger); dtCustBasicInfo = moneyLedgerReportBal.GetCustBasicInfo(T_custCode); } //else if (tempMenuPurpose == newCustomerMoneyBalance) //{ // dtCustBasicInfo = moneyLedgerReportBal.GetCustBasicInfo(_custCode); //} if (dtCustBasicInfo.Rows.Count > 0) { ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = dtCustBasicInfo.Rows[0]["Cust_Name"].ToString(); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = dtCustBasicInfo.Rows[0]["Cust_Code"].ToString(); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["Text6"]).Text = "Balance Before " + dtFromDate.Value.ToString("dd-MMM-yy") + " :"; ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text = "Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtToDate.Value.ToString("dd-MMM-yyyy"); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "Customer Money Ledger"; } if (tempMenuPurpose == newCustomerMoneyBalance) { ((TextObject)crNewCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = txtCustCode.Text; ((TextObject)crNewCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "Customer Money Ledger"; } if (tempMenuPurpose != newCustomerMoneyBalance) { string temp_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Money_Ledger); if (tempMenuPurpose == Interest_Service_Charge) { dtCustmoneyLedger = moneyLedgerReportBal.GetInterestServiceCharge(temp_custCode, _fromDate, _toDate); } else { dtCustmoneyLedger = moneyLedgerReportBal.GetCustMoneyLedger(temp_custCode, _fromDate, _toDate); } } else { dtCustmoneyLedger = moneyLedgerReportBal.GetNewCustMoneyLedger(_custCode, _fromDate, _toDate); } if (tempMenuPurpose == newCustomerMoneyBalance) { crNewCustMoneyledger.SetDataSource(dtCustmoneyLedger); } else { crCustMoneyledger.SetDataSource(dtCustmoneyLedger); } GetCommonInfo(); if (tempMenuPurpose != newCustomerMoneyBalance) { ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ///// Load Branch Name ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; moneyLedgerViewer.crvCustMoneyLedgerReportViewer.DisplayGroupTree = false; } else if (tempMenuPurpose == newCustomerMoneyBalance) { ((TextObject)crNewCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ///// Load Branch Name ((TextObject)crNewCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; } if (tempMenuPurpose == newCustomerMoneyBalance) { viewer.crvReportViewer.ReportSource = crNewCustMoneyledger; viewer.Show(); } else { moneyLedgerViewer.crvCustMoneyLedgerReportViewer.ReportSource = crCustMoneyledger; moneyLedgerViewer.Show(); } }
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); } }