private void GenerateReport(string strRptName, string spname)
{
try
{
FormHelpers.CursorWait(true);
if (strRptName == "")
{
MessageBox.Show("No Report Available!");
}
else
{
frm_ReportViewer frv = new frm_ReportViewer();
frv.report = new ReportTable();
frv.report.ReportName = strRptName;
frv.report.ReportPath = ObjectFinder.ReportPath;
frv.report.SourceTable = rptdetails.SP_dtComponent(spname, UserSettings.LogInYear);
if (frv.report.SourceTable == null || frv.report.SourceTable.Rows.Count == 0)
{
throw new Exception("Report no Data!");
}
frv.Text = "Components Report";
frv.StartPosition = FormStartPosition.CenterScreen;
frv.Show();
}
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void PreviewComparison(string strRptName)
{
try
{
FormHelpers.CursorWait(true);
frm_ReportViewer frv = new frm_ReportViewer();
frv.report = new ReportTable();
frv.report.ReportName = strRptName;
frv.report.ReportPath = ObjectFinder.ReportPath;
frv.report.SourceTable = rptdetails.SP_GeneratePriceListComparison(Convert.ToInt32(mcbofrstYear.SelectedValue), Convert.ToInt32(mcboscndYear.SelectedValue), BPSUtilitiesV1.NZ(mcboCategory.SelectedValue, "").ToString());
if (frv.report.SourceTable == null || frv.report.SourceTable.Rows.Count == 0)
{
throw new Exception("Report no Data");
}
frv.Text = "Price List Comparison Report";
frv.StartPosition = FormStartPosition.CenterScreen;
frv.Show();
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void PreviewReportSummary(string strRptName)
{
try
{
FormHelpers.CursorWait(true);
frm_ReportViewer frv = new frm_ReportViewer();
frv.report = new ReportTable();
frv.report.ReportName = strRptName;
frv.report.ReportPath = ObjectFinder.ReportPath;
frv.report.SourceTable = rptdetails.SP_GeneratePriceList(UserSettings.LogInYear, BPSolutionsTools.BPSUtilitiesV1.NZ(mcboCategory.SelectedValue, "").ToString());
if (frv.report.SourceTable == null || frv.report.SourceTable.Rows.Count == 0)
{
throw new Exception("Report no Data!");
}
frv.Text = "Price List Report";
frv.StartPosition = FormStartPosition.CenterScreen;
frv.Show();
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void PreviewReportSummaryWDetails(string spname, string strRptName)
{
try
{
FormHelpers.CursorWait(true);
frm_ReportViewer frv = new frm_ReportViewer();
frv.report = new ReportTable();
frv.report.ReportName = strRptName;
frv.report.ReportPath = ObjectFinder.ReportPath;
frv.report.SourceTable = rptdetails.SP_GeneratePriceListWDetails(spname, UserSettings.LogInYear);
if (frv.report.SourceTable == null || frv.report.SourceTable.Rows.Count == 0)
{
throw new Exception("Report no Data");
}
frv.Text = "Price List Report with Details";
frv.StartPosition = FormStartPosition.CenterScreen;
frv.Show();
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void Preview(string strRptName)
{
try
{
FormHelpers.CursorWait(true);
frm_ReportViewer frv1 = new frm_ReportViewer();
frv1.report = new ReportTable();
frv1.report.ReportName = strRptName;
frv1.report.ReportPath = ObjectFinder.ReportPath;
frv1.report.SourceTable = rptdetails.SP_GenerateVariance(mcboMonth.SelectedIndex + 1, Convert.ToInt16(mtxtYear.Text));
if (frv1.report.SourceTable == null || frv1.report.SourceTable.Rows.Count == 0)
{
throw new Exception("Report no Data!");
}
frv1.Text = "Variance Costing Report";
frv1.StartPosition = FormStartPosition.CenterScreen;
frv1.Show();
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void bttn_monthwiseReport_Click(object sender, EventArgs e)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
foreach (DataRow dtr in _objCommon.DataGridView2DataTableSelected(dgv_SixMonthReport, "table").Rows)
{
try
{
frm_ReportViewer _objfrm_ReportViewer = new frm_ReportViewer();
SendDataNotice _obj = new SendDataNotice(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dtr["GirviRecordNo"].ToString(), dtr["KhatawaniNo"].ToString().Trim(), "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (rbt_threemonths.Checked == true)
{
ThreeMonths();
}
else if (rbt_sixmonth.Checked == true)
{
fillgrid();
}
else if (rbt_ninemonths.Checked == true)
{
NineMonths();
}
else
{
twelthMonths();
}
}
else
{
}
}
