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