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 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); } }