private void taxInvoiceToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
LogoBind(dt);
if (dgvSalesInvoice.CurrentRow != null)
{
DataTable dtTNC = new DataTable();
NameValueCollection para2 = new NameValueCollection();
para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString());
para2.Add("@i_TNC_Sub", "SALES");
dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_SalesInvoice", para, "SalesInvoice - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptSalesInvoice.rpt"))
{
//dtReport.TableName = "PurchaseOrder";
//dtReport.WriteXmlSchema(@"D:\PurchaseOrder.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptSalesInvoice.rpt");
rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "Tax Invoice", true, true, true, true, true, true, true, true, true, true, true);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Sales Invoice - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
public void RPT_Sub(Int64 QuotationID, string Code, Boolean _IsList)
{
DataTable dt = new DataTable();
LogoBind(dt);
mpdfFile = CurrentUser.DocumentPath + @"pdf\Quotation.pdf";
DataTable dtReport = new DataTable();
dtReport = CommSelect.SelectRecord(QuotationID, "rpt_Quotation", "Quotation - Report");
DataTable dtTNC = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_Code", Code);
para.Add("@i_TNC_Sub", "Quotation");
dtTNC = objDA.ExecuteDataTableSP("rpt_Quotation_TNC", para, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtCompany = new DataTable();
dtCompany = objDA.ExecuteDataTableSP("rpt_Company", null, false, ref mException, ref mErrorMsg, "Quotation TNC");
//dtReport.TableName = "Quotation";
//dtReport.WriteXmlSchema(@"D:\Quotation.xsd");
if (CommSelect.Exception == null)
{
//if (TypeOFSale == "AMC")
//{
// if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation_AMC.rpt"))
// {
// CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
// rptDoc.Load(CurrentUser.ReportPath + "rptQuotation_AMC.rpt");
// //rptDoc.SetDatabaseLogon("sa", "Un!ek3RP");
// CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false);
// rptDoc.Database.Tables[1].SetDataSource(dtCompany);
// rptDoc.Subreports[0].DataSourceConnections.Clear();
// rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
// rptDoc.Refresh();
// Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
// fRptView.Text = "Quotation - [Page Size: A4]";
// fRptView.crViewer.ReportSource = rptDoc;
// if (_IsList == true)
// {
// fRptView.ShowDialog();
// }
// else if (_IsList == false)
// {
// ExportOptions CrExportOptions;
// DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
// PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
// CrDiskFileDestinationOptions.DiskFileName = mpdfFile;
// CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here
// CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
// CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
// CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
// CrExportOptions.FormatOptions = CrFormatTypeOptions;
// rptDoc.Export();
// }
// }
// else
// {
// MessageBox.Show("File is not exist...");
// }
//}
//else if (TypeOFSale != "AMC")
//{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation.rpt"))
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptQuotation.rpt");
//rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dtCompany);
rptDoc.Database.Tables[2].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false);
CurrentUser.AddExtraParameter(rptDoc);
if (CurrentCompany.Com_Profile != null || CurrentCompany.Com_Profile.Trim() != "")
{
rptDoc.SetParameterValue("pCompanyProfile", CurrentCompany.Com_Profile);
}
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Quotation - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
if (_IsList == true)
{
fRptView.ShowDialog();
}
else if (_IsList == false)
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = mpdfFile;
CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rptDoc.Export();
}
}
else
{
MessageBox.Show("File is not exist...");
}
//}
}
}
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbreports.SelectedIndex == 1)
{
try
{
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_FYID", CurrentUser.FYID.ToString());
dtReport = objList.ListOfRecord("rpt_SalesInvoiceRegister", para, "SalesInvoice - Report");
DataView DVReport;
DVReport = dtReport.DefaultView;
DVReport.RowFilter = StrFilter;
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptSalesInvoiceRegister.rpt"))
{
//dtblSalesInvoice .TableName = "PORegister";
//dtblSalesInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptSalesInvoiceRegister.rpt");
//rptDoc.BlankRecords.Height -= (ds.tblItems.Count * 136);
CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Sales Invoice Register", true, true, true, true, false, true, true, false, false, false, true);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Sales Invoice Register - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice - Register Report", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
else if (cmbreports.SelectedIndex == 2)
{
rptSalesInvoice_Click(sender, e);
}
else if (cmbreports.SelectedIndex == 3)
{
if (dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString().Substring(0, 2) == "RI")
{
salesInvoiceToolStripMenuItem_Click(sender, e);
}
else
{
MessageBox.Show("Retail Invoice not generated for this sale.");
}
}
else if (cmbreports.SelectedIndex == 4)
{
if (dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString().Substring(0, 2) == "TI")
{
taxInvoiceToolStripMenuItem_Click(sender, e);
}
else
{
MessageBox.Show("Tax Invoice not generated for this sale.");
}
}
////////////////////////
else if (cmbreports.SelectedIndex == 5)
{
if (dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString().Substring(0, 2) == "ES")
{
try
{
DataTable dt = new DataTable();
LogoBind(dt);
if (dgvSalesInvoice.CurrentRow != null)
{
DataTable dtTNC = new DataTable();
NameValueCollection para2 = new NameValueCollection();
para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString());
para2.Add("@i_TNC_Sub", "SALES");
dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_SalesInvoice", para, "SalesInvoice - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptSalesInvoice.rpt"))
{
//dtReport.TableName = "PurchaseOrder";
//dtReport.WriteXmlSchema(@"D:\PurchaseOrder.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptSalesInvoice.rpt");
rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "Estimate", true, true, true, true, true, true, true, true, true, true, true);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Estimate - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
else
{
MessageBox.Show("Estimate not generated for this sale.");
}
}
///////////////////
//else if (cmbreports.SelectedIndex == 6)
//{
// try
// {
// DataTable dt = new DataTable();
// LogoBind(dt);
// if (dgvSalesInvoice.CurrentRow != null)
// {
// DataTable dtTNC = new DataTable();
// NameValueCollection para2 = new NameValueCollection();
// para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString());
// para2.Add("@i_TNC_Sub", "SALES");
// dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
// DataTable dtReport = new DataTable();
// NameValueCollection para = new NameValueCollection();
// para.Add("@i_RecID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString());
// dtReport = objList.ListOfRecord("rpt_SalesInvoice", para, "SalesInvoice - Report");
// if (objList.Exception == null)
// {
// if (System.IO.File.Exists(CurrentUser.ReportPath + "rptDeliveryChallan.rpt"))
// {
// //dtReport.TableName = "Logo";
// //dtReport.WriteXmlSchema(@"D:\ERP-CRM\CRM_ICON\Logo.xsd");
// CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
// rptDoc.Load(CurrentUser.ReportPath + "rptDeliveryChallan.rpt");
// rptDoc.Subreports[0].DataSourceConnections.Clear();
// rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
// //rptDoc.Refresh();
// rptDoc.Database.Tables[1].SetDataSource(dt);
// rptDoc.Refresh();
// CurrentUser.AddReportParameters(rptDoc, dtReport, "Delivery Challan", true, true, true, true, true, true, true, true, true, true, true);
// CurrentUser.AddExtraParameter(rptDoc);
// Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
// fRptView.Text = "Delivery Challan - [Page Size: A4]";
// fRptView.crViewer.ReportSource = rptDoc;
// fRptView.ShowDialog();
// }
// else
// {
// MessageBox.Show("File is not exist...");
// }
// }
// else
// {
// MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
// }
// }
// catch (Exception exc)
// {
// Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
// MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
// }
//}
else if (cmbreports.SelectedIndex == 6)
{
try
{
DataTable dt = new DataTable();
LogoBind(dt);
if (dgvSalesInvoice.CurrentRow != null)
{
DataTable dtTNC = new DataTable();
NameValueCollection para2 = new NameValueCollection();
para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString());
para2.Add("@i_TNC_Sub", "SALES");
dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_SalesInvoice", para, "SalesInvoice - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptSalesInvoice.rpt"))
{
//dtReport.TableName = "PurchaseOrder";
//dtReport.WriteXmlSchema(@"D:\PurchaseOrder.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptSalesInvoice.rpt");
rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "Proforma Invoice", true, true, true, true, true, true, true, true, true, true, true);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Proforma Invoice - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
else if (cmbreports.SelectedIndex == 7)
{
try
{
if (dgvSalesInvoice.CurrentRow != null)
{
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_ChallanCumTaxInvoice", para, "SalesInvoice - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptChallanCumTaxInvoice.rpt"))
{
//dtReport.TableName = "ChallanCumTaxInvoice";
//dtReport.WriteXmlSchema(@"D:\ChallanCumTaxInvoice.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptChallanCumTaxInvoice.rpt");
CurrentUser.AddReportParameters(rptDoc, dtReport, "Challan Cum Tax Invoice", true, true, true, true, true, true, true, true, true, true, true);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Challan Cum Tax Invoice - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
cmbreports.SelectedIndex = 0;
}
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbreports.SelectedIndex == 1)
{
try
{
if (dgvServiceModule.CurrentRow == null)
{
return;
}
DataTable dtReport = new DataTable();
NameValueCollection Paralist = new NameValueCollection();
Paralist.Add("@i_ServiceId", dgvServiceModule.CurrentRow.Cells["ServiceId"].Value.ToString());
dtReport = objList.ListOfRecord("rpt_ServiceModule", Paralist, "ServiceModule - Report");
//if (objList.Exception == null)
//{
//dtReport.TableName = "ServiceModuleRegister";
//dtReport.WriteXmlSchema(@"D:\ServiceModuleRegister.xsd");
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptServiceModuleRegister.rpt"))
{
DataView DVReport;
DVReport = dtblItem.DefaultView;
DVReport.RowFilter = StrFilter;
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptServiceModuleRegister.rpt");
CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Service Module", true, true, true, true, false, true, true, false, false, false, true);
//CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Service Module - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("Please check Company Details,\n Go to the Master->Edit->Company Details->ReportPath/DocPath.");
}
//}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Service Module", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
else if (cmbreports.SelectedIndex == 2)
{
try
{
if (dgvServiceModule.CurrentRow == null)
{
return;
}
DataTable dt = new DataTable();
// LogoBind(dt);
DataSet dtReport = new DataSet();
NameValueCollection Paralist = new NameValueCollection();
Paralist.Add("@i_RecID", dgvServiceModule.CurrentRow.Cells["ServiceId"].Value.ToString());
dtReport = objList.ListOfDataSetRecordwithPara("rpt_Service_Order", Paralist, "Service Invoice - Report");
if (objList.Exception == null)
{
//dtReport.Tables[0].TableName = "ServiceOrder";
//dtReport.Tables[0].WriteXmlSchema(@"D:\ServiceOrder.xsd");
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptServiceOrder.rpt"))
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptServiceOrder.rpt");
// rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport.Tables[0], "Service Order", true, true, true, true, false, true, true, false, false, false, true);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Service Order - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("Please check Company Details,\n Go to the Master->Edit->Company Details->ReportPath/DocPath.");
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Service Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception");
}
}
else if (cmbreports.SelectedIndex == 3)
{
try
{
DataTable dt = new DataTable();
LogoBind(dt);
if (dgvServiceModule.CurrentRow != null)
{
DataTable dtTNC = new DataTable();
NameValueCollection para2 = new NameValueCollection();
para2.Add("@i_Code", dgvServiceModule.CurrentRow.Cells["RequestNo"].Value.ToString());
para2.Add("@i_TNC_Sub", "SERVICE");
para2.Add("@i_CompId", CurrentCompany.CompId.ToString());
dtTNC = objDA.ExecuteDataTableSP("rpt_Service_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvServiceModule.CurrentRow.Cells["ServiceId"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_ServiceInvoice", para, "ServiceInvoice - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptServiceInvoice.rpt"))
{
//dtReport.TableName = "ServiceInvoice";
//dtReport.WriteXmlSchema(@"D:\ServiceInvoice.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptServiceInvoice.rpt");
rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "Service Invoice", true, true, true, true, true, true, true, true, true, true, true);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Labour Invoice - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("Please check Company Details,\n Go to the Master->Edit->Company Details->ReportPath/DocPath.");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception");
}
}
else if (cmbreports.SelectedIndex == 4)
{
try
{
if (dgvServiceModule.CurrentRow == null)
{
return;
}
DataTable dtReport = new DataTable();
NameValueCollection Paralist = new NameValueCollection();
Paralist.Add("@i_ServiceId", dgvServiceModule.CurrentRow.Cells["ServiceId"].Value.ToString());
dtReport = objList.ListOfRecord("rpt_ServiceModule", Paralist, "ServiceModule - Report");
//if (objList.Exception == null)
//{
//dtReport.TableName = "ServiceModuleRegister";
//dtReport.WriteXmlSchema(@"D:\ServiceModuleRegister.xsd");
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptServiceVouchar.rpt"))
{
DataView DVReport;
DVReport = dtblItem.DefaultView;
DVReport.RowFilter = StrFilter;
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptServiceVouchar.rpt");
CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Service Module", true, true, true, true, false, true, true, false, false, false, true);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Service Module - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("File is not exist...");
}
//}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Service Module", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
cmbreports.SelectedIndex = 0;
}
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbreports.SelectedIndex == 1)
{
DataTable dt = new DataTable();
LogoBind(dt);
if (dgvDebitNote.CurrentRow != null)
{
DataTable dtTNC = new DataTable();
//NameValueCollection para2 = new NameValueCollection();
//para2.Add("@i_Code", dgvSalesInvoice.CurrentRow.Cells["SalesCode"].Value.ToString());
//para2.Add("@i_TNC_Sub", "SALES");
//dtTNC = objDA.ExecuteDataTableSP("rpt_Sales_TNC", para2, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtReport = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_RecID", Convert.ToInt64(dgvDebitNote.CurrentRow.Cells["DNID"].Value).ToString());
dtReport = objList.ListOfRecord("rpt_DebitNote", para, "DebitNote - Report");
//NameValueCollection para2 = new NameValueCollection();
//_CompId = CurrentCompany.CompId;
//para2.Add("@i_CompId", _CompId.ToString());
//dtCompany = objList.ListOfRecord("rpt_Company", para2, "Quotation - Report");
dtReport.TableName = "DebitNote";
dtReport.WriteXmlSchema(@"D:\DebitNote.xsd");
dtReport = objList.ListOfRecord("rpt_DebitNote", para, "DebitNote - Report");
if (objList.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptDebitNote.rpt"))
{
//dtReport.TableName = "PurchaseOrder";
//dtReport.WriteXmlSchema(@"D:\PurchaseOrder.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptDebitNote.rpt");
rptDoc.Subreports[0].DataSourceConnections.Clear();
//rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
//rptDoc.Database.Tables[2].SetDataSource(dtCompany);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "", true, false, false, false, false, false, false, false, false, false, false);
CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Debit Note - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
fRptView.ShowDialog();
}
else
{
MessageBox.Show("Please check Company Details,\n Go to the Master->Edit->Company Details->ReportPath/DocPath.");
}
}
else
{
MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception");
}
}