private void btnShowReport_Click(object sender, EventArgs e)
{
if (int.TryParse(Convert.ToString(cmbSession.SelectedValue), out tryparse))
{
sessionID = tryparse;
}
dt = bal.GetIPORequestToBlockIPOAmount(sessionID);
crIPORequestToBlockIPOAmount cr = new crIPORequestToBlockIPOAmount();
frmReportViewer view = new frmReportViewer();
cr.SetDataSource(dt);
view.crvReportViewer.ReportSource = cr;
view.Show();
}
private void ShowReport()
{
SpotMarketShareBuySellBAL objBAL = new SpotMarketShareBuySellBAL();
DataTable data = new DataTable();
frmReportViewer rptviewer = new frmReportViewer();
crSpotMarketShareBuySellReport objrpt = new crSpotMarketShareBuySellReport();
data = objBAL.GetSpotMarketcShareBuySellReport(dtpStartDate.Value, dtpEndDate.Value);
objrpt.SetDataSource(data);
((TextObject)objrpt.Section2.ReportObjects["txtFromDate"]).Text = dtpStartDate.Value.ToString("dd/MM/yyyy");
((TextObject)objrpt.Section2.ReportObjects["txtToDate"]).Text = dtpEndDate.Value.ToString("dd/MM/yyyy");
rptviewer.crvReportViewer.ReportSource = objrpt;
rptviewer.Text = "Spot Market Share Buy/Sell Report";
rptviewer.Show();
}
private void btnPDF_Click(object sender, EventArgs e)
{
if (ultraGrid1.ActiveRow != null)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
int id = int.Parse(this.ultraGrid1.ActiveRow.Cells["ID"].Value.ToString());
frmReportViewer frm = new frmReportViewer();
frm.ShowPDF(id, fileName);
frm.ShowDialog();
}
}
private void btnShow_Click(object sender, EventArgs e)
{
IPOReportBAL bal = new IPOReportBAL();
DataTable dt = new DataTable();
int Session_Id = (int)cmbsessionName.SelectedValue;
dt = bal.GetIpoSummaryOfApplicationBySessionId(Session_Id);
crIPOSummaryOfTheApplications crRpt = new crIPOSummaryOfTheApplications();
frmReportViewer viewer = new frmReportViewer();
crRpt.SetDataSource(dt);
viewer.crvReportViewer.ReportSource = crRpt;
viewer.Show();
}
private void ShowReport()
{
ZgroupBuySellReportBAL objBAL = new ZgroupBuySellReportBAL();
DataTable data = new DataTable();
frmReportViewer rptviewer = new frmReportViewer();
crZ_groupBuySellReport objrpt = new crZ_groupBuySellReport();
int zgroupId;
zgroupId = objBAL.GetZgroupCompanyId();
data = objBAL.GetZgroupShareBuySellReport(zgroupId, dtpStartDate.Value, dtpEndDate.Value);
objrpt.SetDataSource(data);
((TextObject)objrpt.Section2.ReportObjects["txtFromDate"]).Text = dtpStartDate.Value.ToString("dd/MM/yyyy");
((TextObject)objrpt.Section2.ReportObjects["txtToDate"]).Text = dtpEndDate.Value.ToString("dd/MM/yyyy");
rptviewer.crvReportViewer.ReportSource = objrpt;
rptviewer.Text = "Z-group share Buy/Sell Report";
rptviewer.Show();
}
private void btnShowReport_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string App_ID = txtAppliationNo.Text;
int Session_Id = Convert.ToInt32(cmbSessionName.SelectedValue);
crIPOForwardingLetterAfterResult crobj = new crIPOForwardingLetterAfterResult();
frmReportViewer view = new frmReportViewer();
dt = R_Bal.GetIPOForwardingLetterDataAfterResult(Session_Id, App_ID);
string Add = dt.Rows[0]["Company_Addr"].ToString();
Add.Replace("\n", "Dhaka");
dt.Rows.Add("Add");
crobj.SetDataSource(dt);
view.crvReportViewer.ReportSource = crobj;
view.Show();
}
private void button1_Click(object sender, EventArgs e)
{
string ParentChildGroupCode = TxtCustCode.Text;
//string NonParentChildCode = cmbnonGroupCode.Text;
DataTable dt = new DataTable();
CrParentChildInfo rpt = new CrParentChildInfo();
frmReportViewer view = new frmReportViewer();
dt = bal.GetAllChild_ShareAndMoney_Information(ParentChildGroupCode);
rpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchAddress;
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtReportName"]).Text = "All Account Information";
view.crvReportViewer.ReportSource = rpt;
view.Show();
}
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 btnViewReport_Click(object sender, EventArgs e)
{
if (ultraGrid2.ActiveRow != null)
{
int id = int.Parse(this.ultraGrid2.ActiveRow.Cells["ID"].Value.ToString());
frmReportViewer frm = new frmReportViewer();
frm.View(id);
frm.ShowDialog();
LoadData();
foreach (UltraGridRow row in this.ultraGrid2.Rows)
{
if (row.Cells["ID"].Value.ToString() == id.ToString())
{
row.Activate();
break;
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="ExpenseOrPayment"></param>
/// <param name="sorting">NEW added Sorting</param>
private void MonthlyexpenseReport(string ExpenseOrPayment, string sorting)
{
ExpenseEntryBAL bal = new ExpenseEntryBAL();
DataTable dt = new DataTable();
dt = bal.GetMonthlyExpenseReport((DateTime)dt_FromDate.Value, (DateTime)dt_ToDate.Value, ExpenseOrPayment);
crExpenseMonthly cr = new crExpenseMonthly();
frmReportViewer objreportviewer = new frmReportViewer();
cr.SetDataSource(dt);
GetCommonInfo();
((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName;
((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;;
((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtfromDate"]).Text = dt_FromDate.Value.Date.ToShortDateString();
((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = dt_ToDate.Value.Date.ToShortDateString();
((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["Sorting"]).Text = sorting;
objreportviewer.crvReportViewer.ReportSource = cr;
objreportviewer.Show();
}
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 ParentChildGroupReport()
{
try
{
ParentAndChildBAL bal = new ParentAndChildBAL();
DataTable dt = new DataTable();
CrParentChildInfo rpt = new CrParentChildInfo();
frmReportViewer view = new frmReportViewer();
dt = bal.GetAllChild_ShareAndMoney_Information(_custCode);
rpt.SetDataSource(dt);
GetCommonInfo();
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = _branchAddress;
((TextObject)rpt.ReportDefinition.Sections[2].ReportObjects["txtReportName"]).Text = "All Account Information";
view.crvReportViewer.ReportSource = rpt;
view.Show();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnNewPortfolioReport_Click(object sender, EventArgs e)
{
//if (ValidationCheck())
// return;
ShareDWBAL shareDwbal = new ShareDWBAL();
ShareLedgerBAL bal = new ShareLedgerBAL();
MoneyLadgerReportBAL moneyLedgerReportBal = new MoneyLadgerReportBAL();
DataTable dtPort = new DataTable();
frmReportViewer viewer = new frmReportViewer();
cr_NewPortfolioWithGL rpt = new cr_NewPortfolioWithGL();
DataTable dtCommission = shareDwbal.GetCommissionRate(txtCustCode.Text.Trim());
double CommissionRate = Convert.ToDouble(dtCommission.Rows[0][0].ToString());
//string AsOnDateeeeee=Convert.ToString
dtPort = bal.PortfolioWithActualBEPRealizeGL(txtCustCode.Text.Trim(), CommissionRate, dtToDate.Value);
DataTable dtCustBasicInfo = moneyLedgerReportBal.GetCustBasicInfo(txtCustCode.Text.Trim());
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCustCode"]).Text =
"Cust. Code: " + dtCustBasicInfo.Rows[0]["Cust_Code"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtBOID"]).Text =
"Cust. BO ID: " + dtCustBasicInfo.Rows[0]["BO_ID"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCustName"]).Text =
"Cust. Name: " + dtCustBasicInfo.Rows[0]["Cust_Name"].ToString();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["AsOnDate"]).Text =
"As On: " + dtToDate.Value.ToString("dd MMMM yyyy") + "";
GetCommonInfo();
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text =
_branchName + ", " + _branchAddress + ", " + "Phone: " + _branchContactNumber;
((TextObject)rpt.ReportDefinition.Sections[1].ReportObjects["txtReportName"]).Text = "Portfolio Statement";
rpt.SetDataSource(dtPort);
viewer.crvReportViewer.ReportSource = rpt;
viewer.Show();
}
private void label1_DoubleClick(object sender, EventArgs e)
{
frmReportViewer frm = new frmReportViewer(((Label)sender).Text);
frm.ShowDialog();
}
private void btnViewReportSet_Click(object sender, EventArgs e)
{
SetReportOrder();
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
bool isReports = false;
int nViewWaste = 0;
this.Cursor = Cursors.WaitCursor;
bool isWeekly = false;
//get the count of selected rows and drop each starting at the dropIndex
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
isWeekly = Regex.IsMatch(aRow.Cells["SerieName"].Value.ToString(), "weekly", RegexOptions.IgnoreCase);
if (aRow.Band.Key == "ReportSet")
{
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, isWeekly);
isReports = true;
}
}
else
{
DataView view = _ReportSeries.Tables["ReportSet"].DefaultView;
view.RowFilter = "ReportSeries.ID = " + aRow.Cells["ID"].Value;
view.Sort = "Order";
foreach (DataRowView viewRow in view)
{
if (viewRow["ReportMemorized.ID"].ToString() != "")
{
int id = int.Parse(viewRow["ReportMemorized.ID"].ToString());
if (viewRow["ReportType"].ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, isWeekly);
isReports = true;
}
}
}
}
}
this.Cursor = Cursors.Default;
if (isReports)
{
frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
frmReports.View();
frmReports.Show();
}
if (nViewWaste > 0)
{
if (nViewWaste > 1)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
frmViewWaste.ShowPDF(fileName);
}
else
{
frmViewWaste.View();
frmViewWaste.Show();
}
}
// set task checkboxes
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "reviewreports");
}
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;
}
}
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 btnPrintReportSet_Click(object sender, EventArgs e)
{
VWA4Common.GlobalSettings.PrintViewReportsProgressCancelled = false;
//get the count of selected rows and drop each starting at the dropIndex
//this.Cursor = Cursors.WaitCursor;
try
{
//pf = new VWA4Common.ProgressForm();
//pf.SetupAndShow(this.ParentForm, "Printing Reports", "Creating Report List...", true, true);
int pd_left = (this.Left + ParentForm.Left) + this.Width / 2;
int pd_top = (this.Top + ParentForm.Top) + this.Height / 2;
VWA4Common.ProgressDialog.ShowProgressDialog("Looking for Reports' Names.", "", "", pd_left, pd_top);
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
VWA4Common.ProgressDialog.SetLeadin("Report List created");
VWA4Common.ProgressDialog.SetLeadin("Report List inited");
bool isViewWaste = false, isReports = false;
btnPrintReportSet.Enabled = false;
int nRows = 0, nReports = 1;
if (ultraGrid1.Selected.Rows.Count > 0)
{
nRows = ultraGrid1.Selected.Rows.Count;
}
else
{
nRows = ultraGrid1.Rows.Count;
}
double progressTick = (nRows > 0 ? 100 / nRows : 1);
VWA4Common.ProgressDialog.SetLeadin("Generating Reports");
try
{
if (ultraGrid1.Selected.Rows.Count > 0)
{
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPrintReportSet.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPrint(id);
isViewWaste = true;
}
else
{
frmReports.AddPrint(id, true);
isReports = true;
}
nReports++;
}
}
else
{
foreach (UltraGridRow aRow in ultraGrid1.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPrintReportSet.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPrint(id);
isViewWaste = true;
}
else
{
frmReports.AddPrint(id, true);
isReports = true;
}
nReports++;
}
}
//FinishProgress();
}
finally
{
FinishProgress();
btnPrintReportSet.Enabled = true;
}
//this.Cursor = Cursors.Default;
if (isReports)
{
frmReports.Print();
}
if (isViewWaste)
{
frmViewWaste.Print();
}
if (_IsWeekly)
{
//set checkbox in task
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "printweeklyreports");
}
}
catch (Exception ex)
{
//Note cancellation throws an exception
MessageBox.Show(ex.Message);
}
}
private void btnPDF_Click(object sender, EventArgs e)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
try
{
//pf = new VWA4Common.ProgressForm();
//pf.SetupAndShow(this.ParentForm, "Converting Reports to PDF", "Creating Report List...", true, true);
int pd_left = (this.Left + ParentForm.Left) + this.Width / 2;
int pd_top = (this.Top + ParentForm.Top) + this.Height / 2;
VWA4Common.ProgressDialog.ShowProgressDialog("Looking for Reports' Names.", "", "", pd_left, pd_top);
VWA4Common.ProgressDialog.SetLeadin("Report List created");
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
bool isViewWaste = false, isReports = false;
//this.Cursor = Cursors.WaitCursor;
btnPDF.Enabled = false;
int nRows = 0, nReports = 1;
if (ultraGrid1.Selected.Rows.Count > 0)
{
nRows = ultraGrid1.Selected.Rows.Count;
}
else
{
nRows = ultraGrid1.Rows.Count;
}
double progressTick = (nRows > 0 ? 100 / nRows : 1);
VWA4Common.ProgressDialog.SetLeadin("Generating Reports");
try
{
//get the count of selected rows and drop each starting at the dropIndex
if (ultraGrid1.Selected.Rows.Count > 0)
{
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPDF.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
isViewWaste = true;
}
else
{
frmReports.AddPDF(id, true);
isReports = true;
}
nReports++;
}
}
else
{
foreach (UltraGridRow aRow in ultraGrid1.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPDF.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
isViewWaste = true;
}
else
{
frmReports.AddPDF(id, true);
isReports = true;
}
nReports++;
}
}
}
finally
{
FinishProgress();
btnPDF.Enabled = true;
}
//this.Cursor = Cursors.Default;
//FinishProgress();
//btnPDF.Enabled = true;
if (isViewWaste)
{
if (isReports)
{
result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
}
frmViewWaste.ShowPDF(this.saveFileDialog1.FileName);
}
if (isReports)
{
frmReports.ShowPDF(fileName);
}
}
catch (Exception ex)
{
//Note cancellation throws an exception
MessageBox.Show(ex.Message);
}
}
//private void GenerateViewReports()
//{
// frmReportViewer frmReports = new frmReportViewer();
// frmReportViewer frmViewWaste = new frmReportViewer();
// bool isReports = false;
// int nViewWaste = 0;
// pf.Visible = true;
// pf.Value = 0;
// //get the count of selected rows and drop each starting at the dropIndex
// if (ultraGrid1.Selected.Rows.Count > 0)
// {
// pf.Maximum = ultraGrid1.Selected.Rows.Count;
// foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
// {
// int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
// if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
// {
// frmViewWaste.AddPDF(id);
// nViewWaste++;
// }
// else
// {
// frmReports.AddLoadParameters(id, true);
// isReports = true;
// }
// pf.PerformStep();
// }
// }
// else
// {
// pf.Maximum = ultraGrid1.Rows.Count;
// foreach (UltraGridRow aRow in ultraGrid1.Rows)
// {
// int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
// if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
// {
// frmViewWaste.AddPDF(id);
// nViewWaste++;
// }
// else
// {
// frmReports.AddLoadParameters(id, true);
// isReports = true;
// }
// pf.PerformStep();
// }
// }
// if (isReports)
// {
// frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
// frmReports.View();
// frmReports.Show();
// }
// if (nViewWaste > 0)
// {
// if (nViewWaste > 1)
// {
// DialogResult result = ShowSavePDF();
// if (result == DialogResult.Cancel)
// return;
// string fileName = this.saveFileDialog1.FileName;
// frmViewWaste.ShowPDF(fileName);
// }
// else
// {
// frmViewWaste.View();
// frmViewWaste.Show();
// }
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
//}
private void btnViewReportSet_Click(object sender, EventArgs e)
{
VWA4Common.GlobalSettings.PrintViewReportsProgressCancelled = false;
try
{
//pf = new VWA4Common.ProgressForm();
//pf.SetupAndShow(this.ParentForm, "Showing Reports", "Creating Report List...", true, true);
int pd_left = (this.Left + ParentForm.Left) + this.Width / 2;
int pd_top = (this.Top + ParentForm.Top) + this.Height / 2;
VWA4Common.ProgressDialog.ShowProgressDialog("Looking for Reports' Names.", "", "", pd_left, pd_top);
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
int nRows = 0, nReports = 1;
if (ultraGrid1.Selected.Rows.Count > 0)
{
nRows = ultraGrid1.Selected.Rows.Count;
}
else
{
nRows = ultraGrid1.Rows.Count;
}
btnViewReportSet.Enabled = false;
VWA4Common.ProgressDialog.SetLeadin("Report List created");
VWA4Common.ProgressDialog.SetLeadin("Report List created");
bool isReports = false;
int nViewWaste = 0;
double progressTick = (nRows > 0 ? 100 / nRows : 1);
VWA4Common.ProgressDialog.SetLeadin("Generating Reports");
try
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
//get the count of selected rows and drop each starting at the dropIndex
if (ultraGrid1.Selected.Rows.Count > 0)
{
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
if (_progressCancelled)
{
btnViewReportSet.Enabled = true;
return;
}
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, true);
isReports = true;
}
nReports++;
}
}
else
{
foreach (UltraGridRow aRow in ultraGrid1.Rows)
{
if (_progressCancelled)
{
btnViewReportSet.Enabled = true;
return;
}
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, true);
isReports = true;
}
nReports++;
}
}
}
finally
{
FinishProgress();
btnViewReportSet.Enabled = true;
}
//FinishProgress();
//btnViewReportSet.Enabled = true;
if (isReports)
{
frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
frmReports.View();
frmReports.Show();
}
if (nViewWaste > 0)
{
if (nViewWaste > 1)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
frmViewWaste.ShowPDF(fileName);
}
else
{
frmViewWaste.View();
frmViewWaste.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (!_IsWeekly)
{
//set checkbox in task
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "reviewreports");
}
}
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 btnPDF_Click(object sender, EventArgs e)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
SetReportOrder();
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
bool isViewWaste = false, isReports = false;
this.Cursor = Cursors.WaitCursor;
//get the count of selected rows and drop each starting at the dropIndex
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
if (aRow.Band.Key == "ReportSet")
{
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
isViewWaste = true;
}
else
{
frmReports.AddPDF(id);
isReports = true;
}
}
else
{
DataView view = _ReportSeries.Tables["ReportSet"].DefaultView;
view.RowFilter = "ReportSeries.ID = " + aRow.Cells["ID"].Value;
view.Sort = "Order";
foreach (DataRowView viewRow in view)
{
int id = int.Parse(viewRow["ReportMemorized.ID"].ToString());
if (viewRow["ReportType"].ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
isViewWaste = true;
}
else
{
frmReports.AddPDF(id);
isReports = true;
}
}
}
}
this.Cursor = Cursors.Default;
if (isViewWaste)
{
if (isReports)
{
result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
}
frmViewWaste.ShowPDF(this.saveFileDialog1.FileName);
}
if (isReports)
{
frmReports.ShowPDF(fileName);
}
}
private void button1_Click(object sender, EventArgs e)
{
frmReportViewer frm = new frmReportViewer(_SelectedLabelText);
frm.ShowDialog();
}
//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;
}
}
