public void ShowShareDWReviewReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtpFrom.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtpTO.Value.ToShortDateString()); ShareDWReviewBAL shareDwReviewBal = new ShareDWReviewBAL(); DataTable dtShareDWReview = new DataTable(); crShareDWReview crShareDwReview = new crShareDWReview(); frmShareDWReviewReportViewer shareDWReportViewer = new frmShareDWReviewReportViewer(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); dtShareDWReview = shareDwReviewBal.GetShareDWReview(_fromDate, _toDate); //_filterdColumnName = dtShareDWReview.Columns[1].ToString(); //RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtShareDWReview, _filterdColumnName, ResourceName.Review_Report_Share_DW_Review); //dtShareDWReview = obj.GetRecordLevelFilteredData(); crShareDwReview.SetDataSource(dtShareDWReview); ///// Load Company Name ((TextObject)crShareDwReview.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crShareDwReview.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); ////Load Date if (_fromDate != null && _toDate != null) { ((TextObject)crShareDwReview.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "From " + _fromDate.ToShortDateString() + " To " + _toDate.ToShortDateString(); } shareDWReportViewer.crvShareReview.ReportSource = crShareDwReview; shareDWReportViewer.Show(); }
public void ShowPaymentReviewReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtpFrom.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtpTO.Value.ToShortDateString()); PaymentReviewBAL paymentBAL = new PaymentReviewBAL(); DataTable dtPaymentReview = new DataTable(); crPaymentReview1 crPayment = new crPaymentReview1(); frmPaymenrReportViewer paymentViewer = new frmPaymenrReportViewer(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); dtPaymentReview = paymentBAL.GneratePaymentReview(_fromDate, _toDate); //_filterdColumnName = dtPaymentReview.Columns[1].ToString(); //RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.Review_Report_Payment_Review); //dtPaymentReview = obj.GetRecordLevelFilteredData(); crPayment.SetDataSource(dtPaymentReview); ///// Load Company Name ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); ////Load Date if (_fromDate != null && _toDate != null) { ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "From " + _fromDate.ToShortDateString() + " To " + _toDate.ToShortDateString(); } paymentViewer.crvPaymentReview.ReportSource = crPayment; paymentViewer.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(); }
public void ShowCustMoneyLedgerReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; IPOCustomerSummeryLedgerBAL moneyLedgerReportBal = new IPOCustomerSummeryLedgerBAL(); DataTable dtCustmoneyLedger = new DataTable(); DataTable dtCustBasicInfo = new DataTable(); DataTable dtopenClose = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); crIPOCustomerSummery crCustMoneyledger = new crIPOCustomerSummery(); frmIPOReportViewer viewer = new frmIPOReportViewer(); dtCustmoneyLedger = moneyLedgerReportBal.GetIPOCustSummeryLedger(_custCode, _fromDate, _toDate); dtCustBasicInfo = moneyLedgerReportBal.GetIpoCustSummaryBasicInfo(_custCode); dtopenClose = moneyLedgerReportBal.IpoOpenCloseWithdrawDepost(_custCode, _fromDate, _toDate); crCustMoneyledger.SetDataSource(dtCustmoneyLedger); if (dtopenClose.Rows.Count > 0) { ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtopeningBalance"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Open_Balance"]); //((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtCloseBalance"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Close_Balance"]); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtDepost"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["total_Deposit"]); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[4].ReportObjects["txtWithdraw"]).Text = String.Format("{0:0.##}", dtopenClose.Rows[0]["Toatal_Withdraw"]); } 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["txtboid"]).Text = dtCustBasicInfo.Rows[0]["BO_ID"].ToString(); ((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 = // "IPO Customer Money Ledger"; } GetCommonInfo(); ((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; viewer.crystalReportViewer1.ReportSource = crCustMoneyledger; viewer.Show(); }
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 ShowReport() { _branchId = GlobalVariableBO._branchId; _paymentDate = Convert.ToDateTime(dtPaymentDate.Value.ToShortDateString()); _clientVoucher = rdoClinetVoucher.Checked; _officevoucher = rdoOfficevoucher.Checked; VoucherPrintingBAL voucherPrintingBal = new VoucherPrintingBAL(); DataTable dtVoucherPrint = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); if (_clientVoucher) { crClientVoucher crClientvoucher = new crClientVoucher(); ClientVoucherPrintingViewer clientVoucherPrintingViewer = new ClientVoucherPrintingViewer(); dtVoucherPrint = voucherPrintingBal.GetClientVoucher(_paymentDate); crClientvoucher.SetDataSource(dtVoucherPrint); ///// Load Company Name ((TextObject)crClientvoucher.ReportDefinition.Sections[3].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crClientvoucher.ReportDefinition.Sections[3].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); clientVoucherPrintingViewer.crvClientVoucherViewer.ReportSource = crClientvoucher; clientVoucherPrintingViewer.Show(); } else if (_officevoucher) { crOfficeVoucher crOfficevoucher = new crOfficeVoucher(); OfficeVoucherPrintingViewer officeVoucherPrintingViewer = new OfficeVoucherPrintingViewer(); dtVoucherPrint = voucherPrintingBal.GetClientVoucher(_paymentDate); crOfficevoucher.SetDataSource(dtVoucherPrint); ///// Load Company Name ((TextObject)crOfficevoucher.ReportDefinition.Sections[3].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crOfficevoucher.ReportDefinition.Sections[3].ReportObjects["txtBranchName"]).Text = CmmInfo.BranchDetails(_branchId); officeVoucherPrintingViewer.crvOfficeVoucherViewer.ReportSource = crOfficevoucher; officeVoucherPrintingViewer.Show(); } else { MessageBox.Show("Please Select the report category first."); } }
public void ShowCustMoneyLedgerReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; IPOReportBAL moneyLedgerReportBal = new IPOReportBAL(); DataTable dtCustmoneyLedger = new DataTable(); DataTable dtCustBasicInfo = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); crIPOCustMoneyLedger crCustMoneyledger = new crIPOCustMoneyLedger(); frmIPOReportViewer viewer = new frmIPOReportViewer(); dtCustmoneyLedger = moneyLedgerReportBal.GetIPOCustMoneyLedger(_custCode, _fromDate, _toDate); dtCustBasicInfo = moneyLedgerReportBal.GetIpoCustBasicInfo(_custCode); crCustMoneyledger.SetDataSource(dtCustmoneyLedger); 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 = "IPO Customer Money Ledger"; } GetCommonInfo(); ((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; viewer.crystalReportViewer1.ReportSource = crCustMoneyledger; viewer.Show(); }
private void ReportView() { try { CompanyBAL objCompanyBal = new CompanyBAL(); PaymentReviewBAL paymentBAL = new PaymentReviewBAL(); DataTable dtPaymentReview = new DataTable(); crPaymentReview1 crPayment = new crPaymentReview1(); frmPaymenrReportViewer paymentViewer = new frmPaymenrReportViewer(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); BranchManagementBAL objBranchManagement = new BranchManagementBAL(); dtPaymentReview = paymentBAL.GneratePaymentReviewByBranchWise(dtpFromDate.Value, dtpToDate.Value); //_filterdColumnName = dtPaymentReview.Columns[1].ToString(); //RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.Branch_wise_Payment_Review); //dtPaymentReview = obj.GetRecordLevelFilteredData(); crPayment.SetDataSource(dtPaymentReview); ///// Load Company Name ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ///// Load Branch Name ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = objCompanyBal.GetHeadofficeInfo(); ////Load Date ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Review Duration: " + dtpFromDate.Value.ToString("dd-MM-yyyy") + " " + dtpToDate.Value.ToString("dd-MM-yyyy"); ((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtBranch"]).Text = "Branch : " + objBranchManagement.GetBranchName(); paymentViewer.crvPaymentReview.ReportSource = crPayment; paymentViewer.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ReportView() { if (ddlCompanyShortCode.Text == string.Empty) { MessageBox.Show("Please Select Instrument Short Code"); return; } DataTable dt = new DataTable(); ShareBalanceBAL reportBAL = new ShareBalanceBAL(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); CompanyBAL objCompanyBal = new CompanyBAL(); string compShortCode = ddlCompanyShortCode.Text; DateTime fromDate = dtStartDate.Value; DateTime toDate = dtEndDate.Value; dt = reportBAL.GetCompanyWiseShareTradeList(compShortCode, fromDate, toDate); crInstruwiseShareTradeList reportFile = new crInstruwiseShareTradeList(); reportFile.SetDataSource(dt); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName(); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = objCompanyBal.GetHeadofficeInfo(); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtReportDate"]).Text = "From " + fromDate.ToShortDateString() + " To " + toDate.ToShortDateString(); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruName"]).Text = Convert.ToString(dt.Rows[0][2]); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruCode"]).Text = Convert.ToString(dt.Rows[0][1]); ((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruGroup"]).Text = Convert.ToString(dt.Rows[0][3]); frmInstruwiseShareTradeListViewer reportViewer = new frmInstruwiseShareTradeListViewer(); reportViewer.crvInstruWiseShareTradeList.ReportSource = reportFile; reportViewer.Show(); }
private void GetNRBPaymentReview() { IPOReportBAL bal = new IPOReportBAL(); DataTable dtPaymentReview_NRB = new DataTable(); crIPONRBPayementReview crPayment = new crIPONRBPayementReview(); frmIPOReportViewer paymentViewer = new frmIPOReportViewer(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); int selected_BranchID = Convert.ToInt32(cmb_Branch_Name.SelectedValue); dtPaymentReview_NRB = bal.GETIPONRBPaymentReview(selected_BranchID, dtpFromDate.Value, dtpToDate.Value); crPayment.SetDataSource(dtPaymentReview_NRB); 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.crystalReportViewer1.ReportSource = crPayment; paymentViewer.Show(); }
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 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); } }
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 string GetStudioGrouping(LoadCommonInfo loadCommonInfo) { return(loadCommonInfo.bundlePath); }
public void ShowBuyReport() { _branchId = GlobalVariableBO._branchId; _transDate = Convert.ToDateTime(dtTransactionDate.Value.ToShortDateString()); _CustWise = rdoCustwise.Checked; _InstruWise = rdoInstruWise.Checked; BuyShareListReviewBAL buyShareListReviewBal = new BuyShareListReviewBAL(); DataTable dtBuyShareListReview = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); if (_CustWise) { crCustWiseBuyShareList crBuyShareListReview = new crCustWiseBuyShareList(); CustWiseBuyShareListReportViewer buyShareListReportViewer = new CustWiseBuyShareListReportViewer(); dtBuyShareListReview = buyShareListReviewBal.GetCustWiseBuyShareList(_transDate); _filterdColumnName = dtBuyShareListReview.Columns[0].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtBuyShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List); dtBuyShareListReview = obj.GetRecordLevelFilteredData(); crBuyShareListReview.SetDataSource(dtBuyShareListReview); GetCommonInfo(); ((TextObject)crBuyShareListReview.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crBuyShareListReview.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; if (_transDate != null) { ((TextObject)crBuyShareListReview.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd MMMM,yyyy"); } buyShareListReportViewer.crvBuyShareList.ReportSource = crBuyShareListReview; buyShareListReportViewer.Show(); } else if (_InstruWise) { crInstruWiseBuyList crInstruWiseBuylist = new crInstruWiseBuyList(); InstruWiseBuyReportViewer instruWiseBuyReportViewer = new InstruWiseBuyReportViewer(); dtBuyShareListReview = buyShareListReviewBal.GetInstruWiseBuyShareList(_transDate); _filterdColumnName = dtBuyShareListReview.Columns[2].ToString(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtBuyShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List); dtBuyShareListReview = obj.GetRecordLevelFilteredData(); crInstruWiseBuylist.SetDataSource(dtBuyShareListReview); GetCommonInfo(); ((TextObject)crInstruWiseBuylist.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)crInstruWiseBuylist.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; if (_transDate != null) { ((TextObject)crInstruWiseBuylist.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd MMMM,yyyy"); } instruWiseBuyReportViewer.crvInstruWiseBuyList.ReportSource = crInstruWiseBuylist; instruWiseBuyReportViewer.Show(); } else { MessageBox.Show("Please Select the report category first."); } }