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();
}
private void btnShow_Click(object sender, EventArgs e)
{
crToday_Transactions_Customer_List objRPT = new crToday_Transactions_Customer_List();
frmPaymenrReportViewer paymentViewer = new frmPaymenrReportViewer();
DataTable dt = new DataTable();
dt = objBAL.Today_Transactions_Customer(dtpToday.Value);
objRPT.SetDataSource(dt);
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchName + "," + _branchAddress + ",Phone: " + _branchContactNumber;
((TextObject)objRPT.ReportDefinition.Sections[2].ReportObjects["txtTradeDate"]).Text = dtpToday.Value.ToString("dd-MMM-yyyy");
paymentViewer.crvPaymentReview.ReportSource = objRPT;
paymentViewer.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 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);
}
}