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