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 btnNewPortfolioReport_Click(object sender, EventArgs e)
{
//if (ValidationCheck())
// return;
ShareDWBAL shareDwbal = new ShareDWBAL();
ShareLedgerBAL bal = new ShareLedgerBAL();
MoneyLadgerReportBAL moneyLedgerReportBal = new MoneyLadgerReportBAL();
DataTable dtPort = new DataTable();
frmReportViewer viewer = new frmReportViewer();
cr_NewPortfolioWithGL rpt = new cr_NewPortfolioWithGL();
DataTable dtCommission = shareDwbal.GetCommissionRate(txtCustCode.Text.Trim());
double CommissionRate = Convert.ToDouble(dtCommission.Rows[0][0].ToString());
//string AsOnDateeeeee=Convert.ToString
dtPort = bal.PortfolioWithActualBEPRealizeGL(txtCustCode.Text.Trim(), CommissionRate, dtToDate.Value);
DataTable dtCustBasicInfo = moneyLedgerReportBal.GetCustBasicInfo(txtCustCode.Text.Trim());
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCustCode"]).Text =
"Cust. Code: " + dtCustBasicInfo.Rows[0]["Cust_Code"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtBOID"]).Text =
"Cust. BO ID: " + dtCustBasicInfo.Rows[0]["BO_ID"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCustName"]).Text =
"Cust. Name: " + dtCustBasicInfo.Rows[0]["Cust_Name"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["AsOnDate"]).Text =
"As On: " + dtToDate.Value.ToString("dd MMMM yyyy") + "";
GetCommonInfo();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text =
_branchName + ", " + _branchAddress + ", " + "Phone: " + _branchContactNumber;
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtReportName"]).Text = "Portfolio Statement";
rpt.SetDataSource(dtPort);
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;
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();
}
}