public void ShowCustMoneyBalanceReport()
{
_branchId = GlobalVariableBO._branchId;
SummeryReportBAL summeryReportBal = new SummeryReportBAL();
DataTable dtCustMoneybalance = new DataTable();
crCustTodayMoneyBalance crCustMoneyBalance = new crCustTodayMoneyBalance();
CustMoneyBalanceViewer custMoneyBalance = new CustMoneyBalanceViewer();
//dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(GlobalVariableBO._currentServerDate);
dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance();
_filterdColumnName = dtCustMoneybalance.Columns[0].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustMoneybalance, _filterdColumnName, ResourceName.Todays_Summery_Report_Money_Balance);
dtCustMoneybalance = obj.GetRecordLevelFilteredData();
crCustMoneyBalance.SetDataSource(dtCustMoneybalance);
///// Load Company Name
GetCommonInfo();
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text = GlobalVariableBO._currentServerDate.ToString("dd-MMM-yyyy");
custMoneyBalance.crvCustMoneyBalanceReportViewer.ReportSource = crCustMoneyBalance;
custMoneyBalance.Show();
}
private void ShowToadysCustBalanceReport()
{
_branchId = GlobalVariableBO._branchId;
SummeryReportBAL summeryReportBal = new SummeryReportBAL();
DataTable dtCustToadysCustBal = new DataTable();
crTodayCustBalance crTodayCustBal = new crTodayCustBalance();
TodayCustBalanceViewer todayCustBalanceViewer = new TodayCustBalanceViewer();
dtCustToadysCustBal = summeryReportBal.GetTodaysCustBalance();
_filterdColumnName = dtCustToadysCustBal.Columns[0].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustToadysCustBal, _filterdColumnName, ResourceName.Todays_Summery_Report_Cust_Balance);
dtCustToadysCustBal = obj.GetRecordLevelFilteredData();
crTodayCustBal.SetDataSource(dtCustToadysCustBal);
GetCommonInfo();
///// Load Company Name
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text = GlobalVariableBO._currentServerDate.ToString("dd-MMM-yyyy");
todayCustBalanceViewer.crvTodayCustBalanceReportViewer.ReportSource = crTodayCustBal;
todayCustBalanceViewer.crvTodayCustBalanceReportViewer.DisplayGroupTree = false;
todayCustBalanceViewer.Show();
}
private void GetCommonOpexReport(DateTime fromDate, DateTime toDate)
{
try
{
cr_CommonExpenditureReport objcrCommonOpex = new cr_CommonExpenditureReport();
DataTable dataTable = new DataTable();
frmReportViewer objReportviewer = new frmReportViewer();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
int TempBranchId = -2;
OpexBAL objOpexBal = new OpexBAL();
int BranchId = Int32.Parse(ddlBranchList.SelectedValue.ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Common_Expenditure);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
if (BranchId == 0)
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(BranchId.ToString(), resourceId, criteriaId));
if (TempBranchId == 0)
{
dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId);
}
else
{
dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId);
dataTable.Rows.Clear();
}
}
else
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(BranchId.ToString(), resourceId, criteriaId));
dataTable = objOpexBal.GetCommonOpexReport(fromDate, toDate, TempBranchId);
}
objcrCommonOpex.SetDataSource(dataTable);
GetCommonInfo();
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtReport"]).Text = "Common Expenditure";
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtFrom"]).Text = fromDate.ToString("yyyy");
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtTo"]).Text = toDate.ToString("yyyy");
((TextObject)objcrCommonOpex.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text;
objReportviewer.crvReportViewer.ReportSource = objcrCommonOpex;
objReportviewer.crvReportViewer.ShowGroupTreeButton = false;
objReportviewer.Text = "Common Expenditure";
objReportviewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadReport()
{
ShareListBAL shareBal = new ShareListBAL();
DataTable dtParticipatoryInfo = new DataTable();
dtParticipatoryInfo = shareBal.GetParticipatoryInfo();
ShareListBO shareListBo = new ShareListBO();
shareListBo.DtTo = dtTo;
shareListBo.DtFrom = dtFrom;
shareListBo.WorkStation = workStation;
DataTable dataTable = new DataTable();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
string TempWorkstation = "";
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Workstation_wise_Trade_Share_List);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
if (workStation == "All")
{
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(workStation, resourceId, criteriaId);
if (TempWorkstation == "All")
{
dataTable = shareBal.GetShareInfo(shareListBo);
}
else
{
dataTable = shareBal.GetShareInfo(shareListBo);
dataTable.Rows.Clear();
}
}
else
{
dataTable = shareBal.GetShareInfo(shareListBo);
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(workStation, resourceId, criteriaId);
if (TempWorkstation == "")
{
dataTable.Rows.Clear();
}
}
crShareReport crShareListReport = new crShareReport();
((TextObject)crShareListReport.ReportDefinition.ReportObjects["txtCompanyName"]).Text = dtParticipatoryInfo.Rows[0]["Name"].ToString();
((TextObject)crShareListReport.ReportDefinition.ReportObjects["txtBranchName"]).Text = dtParticipatoryInfo.Rows[0]["Branch_Name"].ToString() + " Branch" + dtParticipatoryInfo.Rows[0]["Address"].ToString();
if (shareListBo.DtFrom != null && shareListBo.DtTo != null)
{
((TextObject)crShareListReport.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "From " + shareListBo.DtFrom.ToShortDateString() + " To " + shareListBo.DtTo.ToShortDateString();
}
crShareListReport.SetDataSource(dataTable);
CrvShareList.ReportSource = crShareListReport;
}
public void ShowSellReport()
{
_branchId = GlobalVariableBO._branchId;
_transDate = Convert.ToDateTime(dtTransactionDate.Value.ToShortDateString());
_CustWise = rdoCustwise.Checked;
_InstruWise = rdoInstruWise.Checked;
SellShareListReviewBAL sellShareListReviewBal = new SellShareListReviewBAL();
DataTable dtSellShareListReview = new DataTable();
if (_CustWise)
{
crCustWiseSellShareList crSellShareListReview = new crCustWiseSellShareList();
CustWiseSellShareListReportViewer sellShareListReportViewer = new CustWiseSellShareListReportViewer();
dtSellShareListReview = sellShareListReviewBal.GetCustWiseSellShareList(_transDate);
_filterdColumnName = dtSellShareListReview.Columns[0].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtSellShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List);
dtSellShareListReview = obj.GetRecordLevelFilteredData();
crSellShareListReview.SetDataSource(dtSellShareListReview);
GetCommonInfo();
((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
if (_transDate != null)
{
((TextObject)crSellShareListReview.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd-MMM-yy");
}
sellShareListReportViewer.crvSellShareList.ReportSource = crSellShareListReview;
sellShareListReportViewer.Show();
}
else if (_InstruWise)
{
crInstruWiseSellShareList crInstruWiseSellSharelist = new crInstruWiseSellShareList();
InstruWiseSellReportViewer insWiseSellReport = new InstruWiseSellReportViewer();
dtSellShareListReview = sellShareListReviewBal.GetInstruWiseSellShareList(_transDate);
_filterdColumnName = dtSellShareListReview.Columns[2].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtSellShareListReview, _filterdColumnName, ResourceName.Buy_Sale_Report_Cust_Wise_Buy_Share_List);
dtSellShareListReview = obj.GetRecordLevelFilteredData();
crInstruWiseSellSharelist.SetDataSource(dtSellShareListReview);
GetCommonInfo();
((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
if (_transDate != null)
{
((TextObject)crInstruWiseSellSharelist.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Transaction Date: " + _transDate.ToString("dd-MMM-yy");
}
insWiseSellReport.crvInstruWiseSellReportViewer.ReportSource = crInstruWiseSellSharelist;
insWiseSellReport.Show();
}
else
{
MessageBox.Show("Please Select the report category first.");
}
}
public void ShowCustSummeryReport()
{
_branchId = GlobalVariableBO._branchId;
_fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
_toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
_custCode = txtCustCode.Text;
CustomerSummeryBAL customerSummeryBal = new CustomerSummeryBAL();
crCustomerSummery crCustomerSumm = new crCustomerSummery();
CustomerSummeryViewer custSumViewer = new CustomerSummeryViewer();
DataTable dtCustSummery = new DataTable();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Summery_Ledger);
string T_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger);
dtCustSummery = customerSummeryBal.GetCustSummery(T_custCode, _fromDate, _toDate);
crCustomerSumm.SetDataSource(dtCustSummery);
////Load Summery Data
DataTable dtSummeryTrans = new DataTable();
DataTable dtPaymentSummery = new DataTable();
string summerycustCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger);
dtSummeryTrans = customerSummeryBal.GetSummeryDataTransaction(summerycustCode, _fromDate, _toDate);
string paymentcustCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Summery_Ledger);
dtPaymentSummery = customerSummeryBal.GetSummeryDataPayment(paymentcustCode, _fromDate, _toDate);
if (dtSummeryTrans.Rows.Count > 0)
{
((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtBuyAmount"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalBuyAmount"]);
((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtSellAmount"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalSellAmount"]);
((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtCommission"]).Text = String.Format("{0:0.##}", dtSummeryTrans.Rows[0]["TotalCommission"]);
}
if (dtPaymentSummery.Rows.Count > 0)
{
((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtReceived"]).Text = String.Format("{0:0.##}", dtPaymentSummery.Rows[0]["TotalDeposit"]);
((TextObject)crCustomerSumm.ReportDefinition.Sections[4].ReportObjects["txtWithdraw"]).Text = String.Format("{0:0.##}", dtPaymentSummery.Rows[0]["TotalWithdraw"]);
}
GetCommonInfo();
///// Load Company Name
((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
////Load Date
if (_fromDate != null && _toDate != null)
{
((TextObject)crCustomerSumm.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Duration : " + _fromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy");
}
custSumViewer.crvCustSummeryReportViewer.ReportSource = crCustomerSumm;
custSumViewer.crvCustSummeryReportViewer.DisplayGroupTree = false;
custSumViewer.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();
}
private void SetExistingPrevillizeState()
{
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default);
criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
isAllLimit = recordLevelFilteringBAL.Check_All_Limit(resourceId, criteriaId);
isAllHide = recordLevelFilteringBAL.Check_All_Hide(resourceId, criteriaId);
isExistLimit = recordLevelFilteringBAL.isExistLimit(resourceId, criteriaId);
isExistHide = recordLevelFilteringBAL.isExistHide(resourceId, criteriaId);
}
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 ShowMonthlyExpenseReport(DateTime FromDate, DateTime ToDate)
{
try
{
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
DataTable dtMonthlyExpenseInfo = new DataTable();
cr_MonthlyExpenseReport objcrMonthlyExpenseInfo = new cr_MonthlyExpenseReport();
frmReportViewer objfrmMonthlyExpenseInfo = new frmReportViewer();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
int TempBranchId = -2;
dtMonthlyExpenseInfo = objAssetInfoBal.GetMonthlyCapexReport(FromDate, ToDate);
int branchid = Int32.Parse(dtMonthlyExpenseInfo.Rows[0][10].ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Monthly_Expense_List);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId));
if (TempBranchId == -1)
{
dtMonthlyExpenseInfo.Rows.Clear();
}
objcrMonthlyExpenseInfo.SetDataSource(dtMonthlyExpenseInfo);
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = "Fom: " + dtpFromDate.Value.ToString("MM-dd-yyyy");
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = "To: " + dtpToDate.Value.ToString("MM-dd-yyyy");
GetCommonInfo();
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
objfrmMonthlyExpenseInfo.Text = "Monthly Expense Report";
objfrmMonthlyExpenseInfo.crvReportViewer.ReportSource = objcrMonthlyExpenseInfo;
objfrmMonthlyExpenseInfo.Show();
}
catch (Exception)
{
throw;
}
}
private void btn_TodayCustBalance_Click(object sender, EventArgs e)
{
try
{
//Validation
if (txt_Reason.Text == string.Empty)
{
MessageBox.Show("You Should Writed Down The Reason");
return;
}
_branchId = GlobalVariableBO._branchId;
Admin_Alternative_Report_Bal summeryReportBal = new Admin_Alternative_Report_Bal();
DataTable dtCustToadysCustBal = new DataTable();
crTodayCustBalance crTodayCustBal = new crTodayCustBalance();
TodayCustBalanceViewer todayCustBalanceViewer = new TodayCustBalanceViewer();
dtCustToadysCustBal = summeryReportBal.GetTodaysCustBalance(dtp_TodayBalanceDate.Value);
_filterdColumnName = dtCustToadysCustBal.Columns[0].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustToadysCustBal, _filterdColumnName, ResourceName.Todays_Summery_Report_Cust_Balance);
dtCustToadysCustBal = obj.GetRecordLevelFilteredData();
crTodayCustBal.SetDataSource(dtCustToadysCustBal);
GetCommonInfo();
ReportName = "TodayCustomerTotalBalance";
///// Load Company Name
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)crTodayCustBal.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text = dtp_TodayBalanceDate.Value.ToString("dd-MMM-yyyy");
todayCustBalanceViewer.crvTodayCustBalanceReportViewer.ReportSource = crTodayCustBal;
todayCustBalanceViewer.crvTodayCustBalanceReportViewer.DisplayGroupTree = false;
todayCustBalanceViewer.Show();
InsertLog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_TodayCustMoneyBalance_Click(object sender, EventArgs e)
{
try
{
if (txt_Reason.Text == string.Empty)
{
MessageBox.Show("You Should Writed Down The Reason");
return;
}
_branchId = GlobalVariableBO._branchId;
Admin_Alternative_Report_Bal summeryReportBal = new Admin_Alternative_Report_Bal();
DataTable dtCustMoneybalance = new DataTable();
crCustTodayMoneyBalance crCustMoneyBalance = new crCustTodayMoneyBalance();
CustMoneyBalanceViewer custMoneyBalance = new CustMoneyBalanceViewer();
//dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(GlobalVariableBO._currentServerDate);
dtCustMoneybalance = summeryReportBal.GetCustMoneyBalance(dtp_TodayBalanceDate.Value);
_filterdColumnName = dtCustMoneybalance.Columns[0].ToString();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtCustMoneybalance, _filterdColumnName, ResourceName.Todays_Summery_Report_Money_Balance);
dtCustMoneybalance = obj.GetRecordLevelFilteredData();
crCustMoneyBalance.SetDataSource(dtCustMoneybalance);
///// Load Company Name
GetCommonInfo();
ReportName = "TodayCustomerMoneyBalance";
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
///// Load Branch Name
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)crCustMoneyBalance.ReportDefinition.Sections[2].ReportObjects["txtPrintDate"]).Text = dtp_TodayBalanceDate.Value.ToString("dd-MMM-yyyy");;
custMoneyBalance.crvCustMoneyBalanceReportViewer.ReportSource = crCustMoneyBalance;
custMoneyBalance.Show();
InsertLog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GetCurrentAssetList()
{
try
{
AssetInformationBAL objAssetInformationBal = new AssetInformationBAL();
DataTable dtCurrentAssetList = new DataTable();
frmReportViewer objfrmReportViewer = new frmReportViewer();
cr_CurrentAssetList objcrCurrentAssetList = new cr_CurrentAssetList();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
dtCurrentAssetList = objAssetInformationBal.GetCurrentAssetInfo();
int TempBranchId = -2;
int branchid = Int32.Parse(dtCurrentAssetList.Rows[0][8].ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Current_Asset_List);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId));
if (TempBranchId == -1)
{
dtCurrentAssetList.Rows.Clear();
}
objcrCurrentAssetList.SetDataSource(dtCurrentAssetList);
GetCommonInfo();
((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
objfrmReportViewer.crvReportViewer.ReportSource = objcrCurrentAssetList;
objfrmReportViewer.crvReportViewer.DisplayGroupTree = false;
objfrmReportViewer.Text = "Current Asset List";
objfrmReportViewer.Show();
}
catch (Exception)
{
throw;
}
}
private void ShowPortFolioReportInvestorWise()
{
cr_DSE_22_1 objcr_DSE_22_1Report = new cr_DSE_22_1();
DataTable dtProtofolioReportInvestorwise = new DataTable();
DESReportBal objPortfolioBal = new DESReportBal();
CustShareSummeryViewer objfrm_DSE_22_1_Report = new CustShareSummeryViewer();
string deposit = "0.00";
string withdraw = "0.00";
string balance = "0.00";
string accruedbalance = "0.00";
string IPObalance = "0.00";
string availablebalance = "0.00";
string netbalance = "0.00";
try
{
ShareLedgerBAL shareLedgerBal = new ShareLedgerBAL();
DataTable dtCustSummerybasic = new DataTable();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery);
string T_Custcode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery);
if (T_Custcode == "")
{
MessageBox.Show("You are restricted");
return;
}
dtCustSummerybasic = shareLedgerBal.GetCustomerSummerBasicInfo(T_Custcode, dtToDate.Value);
if (dtCustSummerybasic.Rows.Count != 0)
{
deposit = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Dep_Amount"]).ToString("N");
withdraw = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Withdraw_Amount"]).ToString("N");
balance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Head_Balance"]).ToString("N");
accruedbalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Accrued_Balance"]).ToString("N");
IPObalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["IPO_Balance"]).ToString("N");
availablebalance = (Convert.ToDecimal(balance) - (Convert.ToDecimal(accruedbalance))).ToString("N");
netbalance = (Convert.ToDecimal(availablebalance) + Convert.ToDecimal(IPObalance)).ToString("N");
}
string temp_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery);
dtProtofolioReportInvestorwise = objPortfolioBal.Get_DSE_22_1_Report(temp_custCode, dtToDate.Value);
objcr_DSE_22_1Report.SetDataSource(dtProtofolioReportInvestorwise);
GetCommonInfo();
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text =
_CommpanyName;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBranchInfo"]).Text =
_branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text =
txtCustCode.Text;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBOID"]).Text =
txtAccountHolderBOId.Text;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text =
txtAccountHolderName.Text;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtDeposit"]).Text =
deposit;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtWithdraw"]).Text =
withdraw;
//((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBalance"]).Text =
// balance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCurrentTradeBalance"]).Text =
balance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtTotalAcrudeCharge"]).Text =
accruedbalance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtAvailableBalance"]).Text =
availablebalance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtIPOBalance"]).Text =
IPObalance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtNetBalance"]).Text =
netbalance;
((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["asOnDate"]).Text =
dtToDate.Value.ToString("dd/MMM/yyyy");
objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.ReportSource = objcr_DSE_22_1Report;
objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.DisplayGroupTree = false;
objfrm_DSE_22_1_Report.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Portfolio Report Investor Wise", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
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 ShowTradeSummeryReport()
{
_workStation = "";
_branchId = GlobalVariableBO._branchId;
_FromDate = dtpFrom.Value;
_toDate = dtpTo.Value;
_marketType = chkMarketType.Checked;
_workStation = ddlWorkStation.Text;
if (_workStation == "All")
{
_workStation = "0";
}
TradeSummeryBAL tradeSummeryBal = new TradeSummeryBAL();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
GetCommonInfo();
resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default);
criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
if (_marketType)
{
crSpotTradeSummery crSpotTradeSumm = new crSpotTradeSummery();
SpotTradeSummeryReportViewer spotTradeSummeryReport = new SpotTradeSummeryReportViewer();
DataTable dtSpotTradeSummery = new DataTable();
string TempWorkstation = "";
// SetExistingPrevillizeState();
// FilterAllWorkStation
if (_workStation == "0")
{
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(_workStation, resourceId, criteriaId);
if (TempWorkstation != "")
{
dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate);
}
//else if (!isAllLimit && !isAllHide && !isExistLimit && !isExistHide)
//{
// dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate);
//}
else
{
dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate);
dtSpotTradeSummery.Rows.Clear();
}
}
else
{
dtSpotTradeSummery = tradeSummeryBal.GetSpotTradeSummery(_FromDate, _toDate);
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(_workStation, resourceId, criteriaId);
if (TempWorkstation == "")
{
dtSpotTradeSummery.Rows.Clear();
}
}
crSpotTradeSumm.SetDataSource(dtSpotTradeSummery);
((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtDuration"]).Text = "From " + _FromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy");
((TextObject)crSpotTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
spotTradeSummeryReport.crvSpotTradeSummery.ReportSource = crSpotTradeSumm;
spotTradeSummeryReport.crvSpotTradeSummery.DisplayGroupTree = false;
spotTradeSummeryReport.Show();
}
else
{
crTradeSummery crTradeSumm = new crTradeSummery();
TradeSummeryReportViewer tradeSummeryReport = new TradeSummeryReportViewer();
DataTable dtTradeSummery = new DataTable();
DataTable dtCashFlow = new DataTable();
string TempWorkstation = "";
//int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Trade_Summery_Report_default);
//int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
if (_workStation == "0")
{
//isAllLimit = recordLevelFilteringBAL.Check_All_Limit(resourceId, criteriaId);
//isAllHide = recordLevelFilteringBAL.Check_All_Hide(resourceId, criteriaId);
//isExistLimit = recordLevelFilteringBAL.isExistLimit(resourceId, criteriaId);
//isExistHide = recordLevelFilteringBAL.isExistHide(resourceId, criteriaId);
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation_All(_workStation, resourceId, criteriaId);
if (TempWorkstation != "")
{
dtTradeSummery = tradeSummeryBal.GetTradeSummery(_workStation, _FromDate, _toDate);
dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate);
}
else
{
dtTradeSummery = tradeSummeryBal.GetTradeSummery(_workStation, _FromDate, _toDate);
dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate);
dtTradeSummery.Rows.Clear();
dtCashFlow.Rows.Clear();
}
}
else
{
dtCashFlow = tradeSummeryBal.GetCashflowReport(_FromDate, _toDate);
TempWorkstation = recordLevelFilteringBAL.FilterWorkStation(_workStation, resourceId, criteriaId);
if (TempWorkstation == "")
{
dtCashFlow.Rows.Clear();
}
dtTradeSummery = tradeSummeryBal.GetTradeSummery(TempWorkstation, _FromDate, _toDate);
}
crTradeSumm.SetDataSource(dtTradeSummery);
((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtDuration"]).Text = "From " + _FromDate.ToString("dd-MMM-yyyy") + " To " + _toDate.ToString("dd-MMM-yyyy");
((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)crTradeSumm.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
crTradeSumm.Subreports[0].SetDataSource(dtCashFlow);
tradeSummeryReport.crvTradeSummery.ReportSource = crTradeSumm;
tradeSummeryReport.Show();
}
}
//private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping)
//{
// try
// {
// if (Grouping == Indication_ExpenseReports.Expense_Grouping_Monthly)
// {
// cr_MonthlyOpex objcrmonthlyopex = new cr_MonthlyOpex();
// DataTable datatable = new DataTable();
// frmReportViewer objreportviewer = new frmReportViewer();
// RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL();
// ExpenseEntryBAL exbal = new ExpenseEntryBAL();
// int tempbranchid = -2;
// int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex);
// int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid);
// if (BranchID == Indication_BrokerBranch.HeadOffice_ID)
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// else
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// objcrmonthlyopex.SetDataSource(datatable);
// GetCommonInfo();
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName;
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name +" Report: Monthly Wise";
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy");
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy");
// ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName;
// objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex;
// objreportviewer.Text = Selected_CategoryType_Name + " Report: Monthly wise";
// objreportviewer.Show();
// }
// else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Daily)
// {
// cr_DailyOpex objctDailyOpex = new cr_DailyOpex();
// DataTable datatable = new DataTable();
// frmReportViewer objreportviewer = new frmReportViewer();
// RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL();
// ExpenseEntryBAL exbal = new ExpenseEntryBAL();
// int tempbranchid = -2;
// int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex);
// int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid);
// if (BranchID == Indication_BrokerBranch.HeadOffice_ID)
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// else
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// objctDailyOpex.SetDataSource(datatable);
// GetCommonInfo();
// ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName;
// ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
// ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+" Report: Daily Wise";
// ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy");
// ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy");
// //((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName;
// objreportviewer.crvReportViewer.ReportSource = objctDailyOpex;
// objreportviewer.Text = Selected_CategoryType_Name + " Report: Daily wise";
// objreportviewer.Show();
// }
// else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Yearly)
// {
// cr_YearlyOPex objctYearlyOpex = new cr_YearlyOPex();
// DataTable datatable = new DataTable();
// frmReportViewer objreportviewer = new frmReportViewer();
// RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL();
// ExpenseEntryBAL exbal = new ExpenseEntryBAL();
// int tempbranchid = -2;
// int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex);
// int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid);
// if (BranchID == Indication_BrokerBranch.HeadOffice_ID)
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// else
// {
// tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid));
// if (BranchID != tempbranchid)
// {
// MessageBox.Show("you are restricted");
// return;
// }
// else
// {
// datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate);
// }
// }
// objctYearlyOpex.SetDataSource(datatable);
// GetCommonInfo();
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName;
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "branch name:" + _branchName + "," + _branchAddress + ". phone:" + _branchContactNumber;
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+ " Report: Yearly wise";
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy");
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy");
// ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName;
// objreportviewer.crvReportViewer.ReportSource = objctYearlyOpex;
// objreportviewer.Text = Selected_CategoryType_Name + " Report: Yearly wise";
// objreportviewer.Show();
// }
// }
// catch (Exception)
// {
// throw;
// }
//}
private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping)
{
try
{
cr_ExpenseReport objcrmonthlyopex = new cr_ExpenseReport();
DataTable datatable = new DataTable();
frmReportViewer objreportviewer = new frmReportViewer();
RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL();
ExpenseEntryBAL exbal = new ExpenseEntryBAL();
bool IsExpensedate = false;
int tempbranchid = -2;
int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex);
int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid);
if (rd_ExpenseDate.Checked)
{
IsExpensedate = rd_ExpenseDate.Checked;
}
if (BranchID == Indication_BrokerBranch.HeadOffice_ID)
{
tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid));
if (BranchID != tempbranchid)
{
MessageBox.Show("you are restricted");
return;
}
else
{
datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate);
}
}
else
{
tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid));
if (BranchID != tempbranchid)
{
MessageBox.Show("you are restricted");
return;
}
else
{
datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate);
}
}
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pdv.Value = (object)Grouping;
objcrmonthlyopex.SetDataSource(datatable);
GetCommonInfo();
((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName;
((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;;
((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-MMM-yyyy") + " To " + toDate.ToString("dd-MMM-yyyy");
//((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy");
((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtDate"]).Text = IsExpensedate ? "Expense Date" : "Payment Date";
objcrmonthlyopex.ParameterFields["GroupingDate"].CurrentValues.Add(pdv);
objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex;
objreportviewer.Text = "Expense Report ";
objreportviewer.Show();
}
catch (Exception)
{
throw;
}
}
private void GetCustomizedOpexReport(DateTime fromDate, DateTime toDate)
{
try
{
cr_CustomizedOpex objcrcustomizedOpex = new cr_CustomizedOpex();
DataTable dataTable = new DataTable();
frmReportViewer objReportviewer = new frmReportViewer();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
OpexBAL objOpexBal = new OpexBAL();
int TempBranchId = -2;
int BranchId = Int32.Parse(ddlBranchList.SelectedValue.ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Daily_Expenditure_Customized_Opex);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
if (BranchId == 0)
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(BranchId.ToString(), resourceId, criteriaId));
if (BranchId != TempBranchId)
{
MessageBox.Show("You are restricted");
return;
}
else
{
dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId);
}
}
else
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(BranchId.ToString(), resourceId, criteriaId));
if (BranchId != TempBranchId)
{
MessageBox.Show("You are restricted");
return;
}
else
{
dataTable = objOpexBal.GetCustomizedOpexReport(fromDate, toDate, TempBranchId);
}
}
objcrcustomizedOpex.SetDataSource(dataTable);
GetCommonInfo();
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtReport"]).Text = "Daily Opex Report: Customized";
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtFrom"]).Text = fromDate.ToString("MMMM-yyyy");
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtTo"]).Text = toDate.ToString("MMMM-yyyy");
((TextObject)objcrcustomizedOpex.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text;
objReportviewer.crvReportViewer.ReportSource = objcrcustomizedOpex;
objReportviewer.crvReportViewer.DisplayGroupTree = true;
objReportviewer.Text = "Daily Opex Report: Customized";
objReportviewer.Show();
}
catch (Exception)
{
throw;
}
}
private void GetDailyDaywiseOpexReport(DateTime fromDate, DateTime toDate)
{
try
{
cr_groupByBranchDailyOpexReport objcrDailyOpex = new cr_groupByBranchDailyOpexReport();
DataTable dataTable = new DataTable();
frmReportViewer objReportviewer = new frmReportViewer();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
OpexBAL objOpexBal = new OpexBAL();
int TempBranchId = -2;
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Daily_Expenditure_group_By_Branch_Daily_Opex_Report);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
int branchId = Int32.Parse(ddlBranchList.SelectedValue.ToString());
if (branchId == 0)
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterWorkStation_All(branchId.ToString(), resourceId, criteriaId));
if (TempBranchId == 0)
{
dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId);
}
else
{
//dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, branchId);
//dataTable.Rows.Clear();
MessageBox.Show("You are restricted");
return;
}
}
else if (branchId != 0)
{
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchId.ToString(), resourceId, criteriaId));
if (branchId != TempBranchId)
{
MessageBox.Show("You are restricted");
return;
}
dataTable = objOpexBal.GetAllBranchDailyOpex(fromDate, toDate, TempBranchId);
}
objcrDailyOpex.SetDataSource(dataTable);
GetCommonInfo();
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtReportTitle"]).Text = "Day wise Daily Opex ";
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtFromDate"]).Text = fromDate.ToString("dd-MMM-yyyy");
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtToDate"]).Text = toDate.ToString("dd-MMM-yyyy");
((TextObject)objcrDailyOpex.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = ddlBranchList.Text;
objReportviewer.crvReportViewer.ReportSource = objcrDailyOpex;
objReportviewer.Text = "Daily Opex Report : Day wise";
objReportviewer.Show();
}
catch (Exception)
{
throw;
}
}
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 void btnGrnerateReport_Click(object sender, EventArgs e)
{
if (rdbTaxCertificate.Checked == true)
{
if (txtCustCode.Text.Trim() != "")
{
if (_reportNo == "1")
{
ShowCustTaxStatement();
}
else
{
ShowCustMoneyLedgerReport();
}
}
else
{
MessageBox.Show("Select a customer first.", "Warning!");
}
}
if (rdbTaxStatement.Checked == true)
{
custCode = txtCustCode.Text;
_fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
_toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
DataSet TaxDataSet = new DataSet();
DataTable TaxStatement = new DataTable();
DataTable BonusRightIPOSatement = new DataTable();
DataTable TaxStatementSummary = new DataTable();
TaxStatementBAL TaxStatementBAL = new TaxStatementBAL();
crTaxStatement crTaxStatement = new crTaxStatement();
crTaxStatementBonusIPO crTaxStatementBonusRightIPO_Rpt = new crTaxStatementBonusIPO();
crTaxStatementSummarySubReport crTaxStatementSummarySubReport = new crTaxStatementSummarySubReport();
frmPaymentReceiptSummaryViewer ReportViewer = new frmPaymentReceiptSummaryViewer();
RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Tax_TaxStatement);
string T_Custcode = obj.FilterCustCode(_custCode, ResourceName.Tax_TaxStatement);
if (T_Custcode == "")
{
MessageBox.Show("You are restricted");
return;
}
TaxDataSet = TaxStatementBAL.GetData(custCode, _fromDate, _toDate);
if (TaxDataSet.Tables.Count > 3)
{
TaxStatement = TaxDataSet.Tables[0];
BonusRightIPOSatement = TaxDataSet.Tables[1];
TaxStatementSummary = TaxDataSet.Tables[3];
}
crTaxStatement.DataSourceConnections.Clear();
crTaxStatement.SetDataSource(TaxStatement);
crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].DataSourceConnections.Clear();
crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].SetDataSource(BonusRightIPOSatement);
crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].DataSourceConnections.Clear();
crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].SetDataSource(TaxStatementSummary);
GetCommonInfo();
((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = dtFromDate.Value.ToString("dd/MM/yyyy");
((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = dtToDate.Value.ToString("dd/MM/yyyy");
((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = _fromDate.ToString("dd-MM-yyyy");
((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = _toDate.ToString("dd-MM-yyyy");
ReportViewer.crystalReportViewer1.DisplayGroupTree = false;
ReportViewer.crystalReportViewer1.ReportSource = crTaxStatement;
ReportViewer.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();
}
}
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);
}
}
