private void mnuTaxClass_Click(object sender, EventArgs e) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptTaxClassRegister.rpt")) { //dtblTaxClass.TableName = "TaxClassList"; //dtblTaxClass.WriteXmlSchema(@"\TaxClassList.xsd"); DataView DVReport; DVReport = dtblTaxClass.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptTaxClassRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Tax Class List", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Tax Class List - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist"); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Tax Class", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void mmuMailingLabel_Click(object sender, EventArgs e) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerMailingLabel1.rpt")) { //dtblCustomer.TableName = "CustomerRegister"; //dtblCustomer.WriteXmlSchema(@"D:\report\CustomerRegister.xsd"); //DataView DVReport; //DVReport = dtblCustomer.DefaultView; //DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerMailingLabel1.rpt"); //CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Mailing Label", false, false, false, false, false, false, false, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Mailing Label - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer- Mailing Label", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
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"); } }
private void rptSalesInvoice_Click(object sender, EventArgs e) { try { if (dgvSalesInvoice.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_SIID", Convert.ToInt64(dgvSalesInvoice.CurrentRow.Cells["SIID"].Value).ToString()); dtReport = objList.ListOfRecord("rpt_SalesInvoiceDetail", para, "SalesInvoice - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; dgvSalesInvoice.DataSource = DV.ToTable(); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptSalesInvoiceRegisterwithDetail.rpt")) { //dtblSalesInvoice .TableName = "PORegister"; //dtblSalesInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptSalesInvoiceRegisterwithDetail.rpt"); DataView dvReport = new DataView(); dvReport = dtReport.DefaultView; //if (StrFilter != "") //{ // dvReport.RowFilter = StrFilter; //} CurrentUser.AddReportParameters(rptDoc, dvReport.ToTable(), "Sales Invoice Detail", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Sales Invoice Detail - [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 - Detail Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void rptExpense_Click(object sender, EventArgs e) { try { if (dgvExpense.CurrentRow != null) { DataTable dtReport = new DataTable(); dtReport = CommSelect.SelectRecord(Convert.ToInt64(dgvExpense.CurrentRow.Cells["POID"].Value), "rpt_Expense", "Expense - Report"); if (CommSelect.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptExpense.rpt")) { //dtReport.TableName = "Expense"; //dtReport.WriteXmlSchema(@"D:\Report\Expense.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptExpense.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Expense", true, true, true, true, true, true, true, false, false, false, false); rptDoc.SetParameterValue("pBusinessLine", CurrentCompany.BusinessLine); rptDoc.SetParameterValue("pCST", CurrentCompany.CST); rptDoc.SetParameterValue("pEmail", CurrentCompany.Email); rptDoc.SetParameterValue("pFax", CurrentCompany.Fax); rptDoc.SetParameterValue("pPhone2", CurrentCompany.Phone2); rptDoc.SetParameterValue("PState", CurrentCompany.State); rptDoc.SetParameterValue("pTin", CurrentCompany.TIN); rptDoc.SetParameterValue("pRegAddress1", CurrentCompany.RegAddress1); rptDoc.SetParameterValue("pRegAddress2", CurrentCompany.RegAddress2); rptDoc.SetParameterValue("pRegCity", CurrentCompany.RegCity); rptDoc.SetParameterValue("pRegFax", CurrentCompany.RegFax); rptDoc.SetParameterValue("pRegPhone", CurrentCompany.RegPhone); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Expense - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } else { MessageBox.Show(CommSelect.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Expense - Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void mnuPriceListRegister_Click(object sender, EventArgs e) { try { if (dgvAccount.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_AccountID", dgvAccount.CurrentRow.Cells["AccountID"].Value.ToString()); dtReport = objList.ListOfRecord("rpt_AccountMasterPriceListRegister", para, "AccountMaster - PriceList report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPriceList.rpt")) { //dtReport.TableName = "PriceListRegister"; //dtReport.WriteXmlSchema(@"D:\Report\PriceListRegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPriceList.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Price List Register", true, true, true, false, false, true, true, false, false, false, false); rptDoc.SetParameterValue("pAccountCode", dgvAccount.CurrentRow.Cells["Code"].Value.ToString()); rptDoc.SetParameterValue("pAccountName", dgvAccount.CurrentRow.Cells["Company"].Value.ToString()); rptDoc.SetParameterValue("pAccountCity", dgvAccount.CurrentRow.Cells["City"].Value.ToString()); rptDoc.SetParameterValue("pAccountPhone", dgvAccount.CurrentRow.Cells["Phone1"].Value.ToString()); rptDoc.SetParameterValue("pCST", CurrentCompany.CST); rptDoc.SetParameterValue("pECC", CurrentCompany.ECC); rptDoc.SetParameterValue("pTin", CurrentCompany.TIN); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Price List 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("AccountMaster - PriceList report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { if (cmbreports.SelectedIndex == 1) { try { NameValueCollection para = new NameValueCollection(); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); para.Add("@i_UserID", CurrentUser.UserID.ToString()); DataTable dtReport = new DataTable(); dtReport = objList.ListOfRecord("rpt_VendorPayment", para, "VendorPayment - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptVendorPaymentRegister.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptVendorPaymentRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Vendor Payment Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Vendor Payment 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("Vendor Payment - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } cmbreports.SelectedIndex = 0; }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbreports.SelectedIndex > 0) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_UserID", CurrentUser.UserID.ToString()); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtReport = CommList.ListOfRecord("rpt_CountryStateCityArea", para, "Location - Report"); if (CommList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptLocationReg.rpt")) { //dtReport.TableName = "LocationRegister"; //dtReport.WriteXmlSchema(@"D:\Report\LocationRegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptLocationReg.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Location Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Location Register - [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."); } } } cmbreports.SelectedIndex = 0; } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Location report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void salesInvoiceToolStripMenuItem_Click(object sender, EventArgs e) { 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_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"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Retail Invoice", true, true, true, true, true, true, true, true, true, true, true); 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"); } }
private void rptExpenseRegister_Click(object sender, EventArgs e) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptExpenseRegister.rpt")) { //dtblExpense .TableName = "PORegister"; //dtblExpense.WriteXmlSchema(@"D:\Report\PORegister.xsd"); DataView DVReport; DVReport = dtblExpense.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptExpenseRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Expense Register", true, true, true, true, false, true, true, false, false, false, true); //rptDoc.SetParameterValue("pFromDate", txtFromDate.Text); //rptDoc.SetParameterValue("pToDate", txtTodate.Text); //if (DataValidator.IsDate(txtFromDate.Text.Trim()) && DataValidator.IsDate(txtTodate.Text.Trim())) //{ // rptDoc.SetParameterValue("pPassDate", true); //} //else //{ // rptDoc.SetParameterValue("pPassDate", false); //} Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Expense Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Expense - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbreports.SelectedIndex == 1) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseIndentRegister.rpt")) { //dtblLead.TableName = "LeadRegister"; //dtblLead.WriteXmlSchema(@"E:\SharedFile\LeadRegister.xsd"); DataView DVReport; DVReport = dtblLead.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseIndentRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "rptPurchaseIndent Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "rptPurchaseIndent Register - [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."); } } cmbreports.SelectedIndex = 0; } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("User - Register", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { if (cmbreports.SelectedIndex == 1) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemAdjustmentRegister.rpt")) { //dtblItemAdjustment .TableName = "ItemAdjustmentRegister"; //dtblItemAdjustment.WriteXmlSchema(@"D:\Report\ItemAdjustmentRegister.xsd"); DataView DVReport; DVReport = dtblItemAdjustment.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemAdjustmentRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Adjustment Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Adjustment Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("ItemAdjustment - Register Report", 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 { DataTable dtReport = new DataTable(); dtReport = objList.ListOfRecord("rpt_CustomerReceipt", null, "CustomerPayment - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerPaymentRegister.rpt")) { //ObjDataTable.TableName = "PaymentRegister"; //ObjDataTable.WriteXmlSchema(@"D:\PaymentRegister.xsd"); DataView DVReport; DVReport = ObjDataTable.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerPaymentRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Payment Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Payment 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("Customer Payment - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { DataTable dtReport = new DataTable(); NameValueCollection PARA1 = new NameValueCollection(); PARA1.Add("@i_ReceiptID", dgvCustomerPayment.CurrentRow.Cells["ReceiptID"].Value.ToString()); dtReport = objList.ListOfRecord("rpt_Customer_Payment_Receipt", PARA1, "CustomerPayment - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerPendingPaymentReceipt.rpt")) { //dtReport.TableName = "PaymentReceipt"; //dtReport.WriteXmlSchema(@"D:\PaymentReceipt.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerPendingPaymentReceipt.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Payment Receipt", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Payment Receipt - [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("Customer Payment - Register Report", 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 (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerRegister.rpt")) { //dtblCustomer.TableName = "CustomerRegister"; //dtblCustomer.WriteXmlSchema(@"D:\report\CustomerRegister.xsd"); DataView DVReport; DVReport = dtblLead.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Register", true, true, true, true, false, true, false, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer- Register", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } if (cmbreports.SelectedIndex == 2) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerMailingLabel.rpt")) { //dtblCustomer.TableName = "CustomerRegister"; //dtblCustomer.WriteXmlSchema(@"D:\report\CustomerRegister.xsd"); DataView DVReport; DVReport = dtblLead.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerMailingLabel.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Mailing Label", true, true, true, true, false, true, false, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Mailing Label - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer- Mailing Label", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } //------------------------ //try //{ // if (cmbreports.SelectedIndex > 0) // { // if (System.IO.File.Exists(CurrentUser.ReportPath + "rptLeadRegister.rpt")) // { // //dtblLead.TableName = "LeadRegister"; // //dtblLead.WriteXmlSchema(@"E:\SharedFile\LeadRegister.xsd"); // DataView DVReport; // DVReport = dtblLead.DefaultView; // DVReport.RowFilter = StrFilter; // CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // rptDoc.Load(CurrentUser.ReportPath + "rptLeadRegister.rpt"); // CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Inquiry Register", true, true, true, true, false, true, true, false, false, false, true); // Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); // fRptView.Text = "Inquiry Register - [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."); // } // } // cmbreports.SelectedIndex = 0; //} //catch (Exception exc) //{ // Utill.Common.ExceptionLogger.writeException("User - Register", exc.StackTrace); // MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); //} }
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 (System.IO.File.Exists(CurrentUser.ReportPath + "rptExpenseRegister.rpt")) { //dtblExpense .TableName = "PORegister"; //dtblExpense.WriteXmlSchema(@"D:\Report\PORegister.xsd"); DataView DVReport; DVReport = dtblExpense.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptExpenseRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Expense Register", true, true, true, true, false, true, true, false, false, false, true); //rptDoc.SetParameterValue("pFromDate", txtFromDate.Text); //rptDoc.SetParameterValue("pToDate", txtTodate.Text); //if (DataValidator.IsDate(txtFromDate.Text.Trim()) && DataValidator.IsDate(txtTodate.Text.Trim())) //{ // rptDoc.SetParameterValue("pPassDate", true); //} //else //{ // rptDoc.SetParameterValue("pPassDate", false); //} Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Expense Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Expense - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } if (cmbreports.SelectedIndex == 2) { try { if (dgvExpense.CurrentRow != null) { DataTable dtReport = new DataTable(); dtReport = CommSelect.SelectRecord(Convert.ToInt64(dgvExpense.CurrentRow.Cells["ExpenseID"].Value), "rpt_Expense", "Expense - Report"); if (CommSelect.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptExpense.rpt")) { //dtReport.TableName = "Expense"; //dtReport.WriteXmlSchema(@"D:\Report\Expense.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptExpense.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Expense", true, true, true, true, true, true, true, false, false, false, false); rptDoc.SetParameterValue("pBusinessLine", CurrentCompany.BusinessLine); rptDoc.SetParameterValue("pCST", CurrentCompany.CST); rptDoc.SetParameterValue("pEmail", CurrentCompany.Email); rptDoc.SetParameterValue("pFax", CurrentCompany.Fax); rptDoc.SetParameterValue("pPhone2", CurrentCompany.Phone2); rptDoc.SetParameterValue("PState", CurrentCompany.State); rptDoc.SetParameterValue("pTin", CurrentCompany.TIN); rptDoc.SetParameterValue("pRegAddress1", CurrentCompany.RegAddress1); rptDoc.SetParameterValue("pRegAddress2", CurrentCompany.RegAddress2); rptDoc.SetParameterValue("pRegCity", CurrentCompany.RegCity); rptDoc.SetParameterValue("pRegFax", CurrentCompany.RegFax); rptDoc.SetParameterValue("pRegPhone", CurrentCompany.RegPhone); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Expense - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } else { MessageBox.Show(CommSelect.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Expense - Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { if (cmbreports.SelectedIndex == 1) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptVendorRegister.rpt")) { //dtblVendor.TableName = "VendorRegister"; //dtblVendor.WriteXmlSchema(@"D:\Report\VendorRegister.xsd"); DataView DVReport; DVReport = dtblVendor.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptVendorRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Vendor Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Vendor Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); // DataTable dt = new DataTable(); //// dt = dgvVendor.DataSource(); // for (int i = 0; i < dgvVendor.Rows.Count; i++) // { // DataRow dr = dt.NewRow(); // dr["Col1"] = dgvVendor.rows[i]["Col1"].text; // dt.Rows.Add(dr); // } } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Vendor - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptVendorMailingLabel.rpt")) { //dtblVendor.TableName = "VendorRegister"; //dtblVendor.WriteXmlSchema(@"D:\Report\VendorRegister.xsd"); DataView DVReport; DVReport = dtblVendor.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptVendorMailingLabel.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Vendor Mailing Label", true, true, true, true, false, true, false, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Vendor Mailing Label - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Vendor - Mailing Label Report", 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; }
public void RPT_Sub(Int64 PIID, string PurchaseCode, Boolean _IsList) { mpdfFile = CurrentUser.DocumentPath + @"pdf\Purchase.pdf"; DataTable dt = new DataTable(); LogoBind(dt); //if (dgvPurchaseInvoice.CurrentRow != null) //{ DataTable dtReport = new DataTable(); DataTable dtTNC = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_Code", PurchaseCode); para.Add("@i_TNC_Sub", "Purchase"); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtTNC = objDA.ExecuteDataTableSP("rpt_Purchase_TNC", para, false, ref mException, ref mErrorMsg, "Purchase TNC"); //NameValueCollection para = new NameValueCollection(); //para.Add("@i_RecID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString()); //dtReport = objList.ListOfRecord("rpt_PO", para, "PurchaseInvoice - Report"); dtReport = CommSelect.SelectRecord(PIID, "rpt_PO", "PurchaseInvoice - Report"); if (CommSelect.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt")) { //dtblPurchaseInvoice.TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\ERP-CRM\Reports Project\POL_IGMS_Reports\DataSets\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt"); rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC); rptDoc.Database.Tables[1].SetDataSource(dt); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, dtReport, "Purchase Order", true, true, true, true, true, true, true, true, true, true, false); //CurrentUser.AddExtraParameter(rptDoc); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Purchase Order - [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"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Sales Invoice Register", true, false, false, false, false, false, true, false, false, false, false); 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) { salesInvoiceToolStripMenuItem_Click(sender, e); } else if (cmbreports.SelectedIndex == 4) { taxInvoiceToolStripMenuItem_Click(sender, e); } cmbreports.SelectedIndex = 0; }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { if (cmbreports.SelectedIndex == 1) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemRegister.rpt")) { dtblItem.TableName = "ItemRegister"; dtblItem.WriteXmlSchema(@"D:\ItemRegister.xsd"); DataView DVReport; DVReport = dtblItem.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Register - [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("Item Register", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { DataTable dtReport = new DataTable(); dtReport = objList.ListOfRecord("rpt_Sales_Service_Quotation", null, "Item - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemSales.rpt")) { //dtReport.TableName = "ItemSales"; //dtReport.WriteXmlSchema(@"D:\ItemSales.xsd"); DataView DVReport; //rooja DVReport = dtReport.DefaultView; //rooja if (StrFilter != "") { StrFilter = StrFilter + " And "; StrFilter = StrFilter + " TYPE = 'QUOTATION' And "; if (StrFilter != "") { StrFilter = StrFilter.Substring(0, StrFilter.Length - 4); } DVReport.RowFilter = StrFilter;//rooja CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemSales.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Quotation Report", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Sales Report - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please filter data with Customer name and/or Item name.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); btnfilter.Focus(); } } 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 - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 3) { try { DataTable dtReport = new DataTable(); dtReport = objList.ListOfRecord("rpt_Sales_Service_Quotation", null, "Item - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemSales.rpt")) { //dtReport.TableName = "ItemSales"; //dtReport.WriteXmlSchema(@"D:\ItemSales.xsd"); DataView DVReport; //rooja DVReport = dtReport.DefaultView; //rooja if (StrFilter != "") { StrFilter = StrFilter + " And "; StrFilter = StrFilter + " TYPE = 'Sales' And "; if (StrFilter != "") { StrFilter = StrFilter.Substring(0, StrFilter.Length - 4); } DVReport.RowFilter = StrFilter;//rooja CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemSales.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Quotation Report", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Sales Report - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please filter data with Customer name and/or Item name.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); btnfilter.Focus(); } } 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 - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 4) { try { DataTable dtReport = new DataTable(); dtReport = objList.ListOfRecord("rpt_Sales_Service_Quotation", null, "Item - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemSales.rpt")) { //dtReport.TableName = "ItemSales"; //dtReport.WriteXmlSchema(@"D:\ItemSales.xsd"); DataView DVReport; //rooja DVReport = dtReport.DefaultView; //rooja if (StrFilter != "") { StrFilter = StrFilter + " And "; StrFilter = StrFilter + " TYPE = 'Service' And "; if (StrFilter != "") { StrFilter = StrFilter.Substring(0, StrFilter.Length - 4); } DVReport.RowFilter = StrFilter;//rooja CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemSales.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Quotation Report", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Sales Report - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please filter data with Customer name and/or Item name.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); btnfilter.Focus(); } } 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 - Register Report", 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"); } }
private void btnSaveExit_Click(object sender, EventArgs e) { if (_RptType == 2) { lblErrorMessage.Text = ""; if (System.IO.File.Exists(CurrentUser.ReportPath + "rptProfitnLossStatement.rpt")) { DataTable dt = new DataTable(); NameValueCollection Para = new NameValueCollection(); // Para.Add("@i_AccountID", cmbAccount.SelectedValue.ToString()); Para.Add("@i_FromDate", dtpDate.Value.ToString("MM/dd/yyyy")); Para.Add("@i_ToDate", dtpToDate.Value.ToString("MM/dd/yyyy")); dt = CommList.ListOfRecord("rpt_ProfitLossStatement", Para, "Profit Loss Statement"); //dt.TableName = "ProfitnLossStatement"; //dt.WriteXmlSchema(@"D:\ProfitnLossStatement.xsd"); if (CommList.Exception == null) { CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptProfitnLossStatement.rpt"); CurrentUser.AddReportParameters(rptDoc, dt, "Profit Loss Statement", true, true, true, true, false, true, true, false, false, false, false); rptDoc.SetParameterValue("pFromDate", dtpDate.Value.Date); rptDoc.SetParameterValue("pToDate", dtpToDate.Value.Date); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Profit n Loss Statement - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show(CommList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } //if (cmbAccount.SelectedIndex > 0) //{ // DataTable dt = new DataTable(); // NameValueCollection Para = new NameValueCollection(); // // Para.Add("@i_AccountID", cmbAccount.SelectedValue.ToString()); // Para.Add("@i_FromDate", dtpDate.Value.ToString("MM/dd/yyyy")); // Para.Add("@i_ToDate", dtpToDate.Value.ToString("MM/dd/yyyy")); // dt = CommList.ListOfRecord("rpt_ProfitLossStatement", Para, "Profit Loss Statement"); // //dt.TableName = "ProfitnLossStatement"; // //dt.WriteXmlSchema(@"D:\ProfitnLossStatement.xsd"); // if (CommList.Exception == null) // { // CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // rptDoc.Load(CurrentUser.ReportPath + "rptProfitnLossStatement.rpt"); // CurrentUser.AddReportParameters(rptDoc, dt, "Profit Loss Statement", true, true, true, true, false, true, true, false, false, false, false); // rptDoc.SetParameterValue("pFromDate", dtpDate.Value.Date); // rptDoc.SetParameterValue("pToDate", dtpToDate.Value.Date); // Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); // fRptView.Text = "Profit n Loss Statement - [Page Size: A4]"; // fRptView.crViewer.ReportSource = rptDoc; // fRptView.ShowDialog(); // } // else // { // MessageBox.Show(CommList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} //else //{ // lblErrorMessage.Text = "Please select Account"; // return; //} } else { MessageBox.Show("File is not exist..."); } } else { //--------------------------------------- lblErrorMessage.Text = ""; if (System.IO.File.Exists(CurrentUser.ReportPath + "rptLedger.rpt")) { if (cmbAccount.SelectedIndex > 0) { DataTable dt = new DataTable(); NameValueCollection Para = new NameValueCollection(); Para.Add("@i_AccountID", cmbAccount.SelectedValue.ToString()); Para.Add("@i_FromDate", dtpDate.Value.ToString("MM/dd/yyyy")); Para.Add("@i_ToDate", dtpToDate.Value.ToString("MM/dd/yyyy")); dt = CommList.ListOfRecord("rpt_AccountLedger", Para, "Ledger Report"); if (CommList.Exception == null) { CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptLedger.rpt"); CurrentUser.AddReportParameters(rptDoc, dt, "Ledger Register", true, true, true, true, false, true, true, false, false, false, false); rptDoc.SetParameterValue("pFromDate", dtpDate.Value.Date); rptDoc.SetParameterValue("pToDate", dtpToDate.Value.Date); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Ledger Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show(CommList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { lblErrorMessage.Text = "Please select Account"; return; } } else { MessageBox.Show("File is not exist..."); } } }
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 { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemStockRegister.rpt")) { //dtblItemStock .TableName = "ItemStockRegister"; //dtblItemStock.WriteXmlSchema(@"D:\ItemStockRegister.xsd"); DataView DVReport; DVReport = dtblItemStock.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemStockRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Stock Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Stock Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("ItemStock - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { if (dgvItemStock.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_StockID", dgvItemStock.CurrentRow.Cells["StockID"].Value.ToString()); dtReport = objList.ListOfRecord("rpt_ItemBeanCard", para, "ItemStock - Bean Card report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemBeanCard.rpt")) { //dtReport .TableName = "ItemBeanCard"; //dtReport.WriteXmlSchema(@"D:\Report\ItemBeanCard.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemBeanCard.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Item Bean Card", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Bean Card - [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("ItemStock - Bean Card Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 3) { try { DataTable dt = new DataTable(); LogoBind(dt); if (System.IO.File.Exists(CurrentUser.ReportPath + "rptItemStockValuationRegister.rpt")) { //dtblItemStock .TableName = "ItemStockValuationRegister"; //dtblItemStock.WriteXmlSchema(@"D:\ItemStockValuationRegister.xsd"); DataView DVReport; DVReport = dtblItemStock.DefaultView; DVReport.RowFilter = filter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptItemStockValuationRegister.rpt"); rptDoc.Database.Tables[1].SetDataSource(dt); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Item Stock Valuation Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Item Stock Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("ItemStock - Register Report", 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 { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_FYID", CurrentUser.FYID.ToString()); para.Add("@i_CompId", CurrentUser.CompId.ToString()); dtReport = objList.ListOfRecord("rpt_POGST_Register", para, "PurchaseInvoice - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterGST.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterGST.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Purchase Order Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Purchase Order 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("Purchase Order - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_FYID", CurrentUser.FYID.ToString()); para.Add("@i_CompId", CurrentUser.CompId.ToString()); para.Add("@i_UserId", CurrentUser.UserID.ToString()); dtReport = objList.ListOfRecord("rpt_PORegister", para, "PurchaseInvoice - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (dtReport.Rows.Count > 0) { for (int i = 0; i < dtReport.Rows.Count; i++) { string ItemCode = dtReport.Rows[i]["ItemCode"].ToString(); int OrderBookingID = Convert.ToInt16(dtReport.Rows[i]["PIID"].ToString()); int CompId = Convert.ToInt16(dtReport.Rows[i]["CompId"].ToString()); DataTable dtSQty = new DataTable(); if (ItemCode != "") { NameValueCollection para1 = new NameValueCollection(); para1.Add("@i_ItemCode", ItemCode.ToString()); para1.Add("@i_POID", OrderBookingID.ToString()); para1.Add("@i_CompId", CompId.ToString()); dtSQty = objList.ListOfRecord("rpt_Get_ReceivedQty", para1, "PurchaseInvoice - Reports"); decimal SQty = 0; if (dtSQty.Rows[0][0].ToString().Trim() == "") { SQty = 0; } else { SQty = Convert.ToDecimal(dtSQty.Rows[0][0]); } dtReport.Rows[i]["DQty"] = SQty; dtReport.Rows[i]["Diff"] = Convert.ToDecimal(dtReport.Rows[i]["OQty"]) - SQty; dtReport.Rows[i]["OrdValue"] = Convert.ToDecimal(dtReport.Rows[i]["OQty"]) * Convert.ToDecimal(dtReport.Rows[i]["Rate"]); dtReport.Rows[i]["SupplyValue"] = SQty * Convert.ToDecimal(dtReport.Rows[i]["Rate"]); dtReport.Rows[i]["diff1"] = Convert.ToDecimal(dtReport.Rows[i]["OrdValue"]) - Convert.ToDecimal(dtReport.Rows[i]["SupplyValue"]); string Difference = dtReport.Rows[i]["Diff"].ToString(); } else { } } //StrFilter = " Diff <> 0"; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; } if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterold.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterold.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Purchase Order Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Purchase Order 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("Purchase Order - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 3) { try { if (dgvPurchaseInvoice.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_PIID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString()); dtReport = objList.ListOfRecord("rpt_PODetail", para, "PurchaseInvoice - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterWithDetail.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterWithDetail.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Purchase Order Detail", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Purchase Order Detail - [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("Purchase Invoice - Detail Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 4) { try { RPT_Sub(Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value), dgvPurchaseInvoice.CurrentRow.Cells["PurchaseCode"].Value.ToString(), true); } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Purchase Invoice", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } //else if (cmbreports.SelectedIndex == 4) //{ // try // { // DataTable dtReport = new DataTable(); // NameValueCollection para = new NameValueCollection(); // para.Add("@i_FYID", CurrentUser.FYID.ToString()); // dtReport = objList.ListOfRecord("rpt_POVsGRN_Register", para, "PurchaseInvoice - Report"); // DataView DVReport; // DVReport = dtReport.DefaultView; // DVReport.RowFilter = StrFilter; // if (objList.Exception == null) // { // if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPOVsGRNRegister.rpt")) // { // //dtblPurchaseInvoice .TableName = "PORegister"; // //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); // CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // rptDoc.Load(CurrentUser.ReportPath + "rptPOVsGRNRegister.rpt"); // CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "PO Vs GRN Register", true, true, true, true, false, true, true, false, false, false, false); // Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); // fRptView.Text = "PO Vs GRN 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("Purchase Invoice - Register Report", 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 { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_FYID", CurrentUser.FYID.ToString()); para.Add("@i_UserId", CurrentUser.UserID.ToString()); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtReport = objList.ListOfRecord("rpt_IndentRegister", para, "Indent - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptGRNRegister.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptGRNRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Indent Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Indent 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("Indent - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { if (dgvPurchaseInvoice.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_PIID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString()); dtReport = objList.ListOfRecord("rpt_IndentDetail", para, "Indent - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterWithDetail.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoiceRegisterWithDetail.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Indent Detail", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Indent Detail - [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("Indent - Detail Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 3) { try { DataTable dt = new DataTable(); LogoBind(dt); if (dgvPurchaseInvoice.CurrentRow != null) { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_RecID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString()); dtReport = objList.ListOfRecord("rpt_Indent", para, "Indent - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptIndent.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptIndent.rpt"); rptDoc.Database.Tables[1].SetDataSource(dt); rptDoc.Refresh(); CurrentUser.AddReportParameters(rptDoc, dtReport, "Indent", true, true, true, true, true, true, true, true, true, true, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Indent - [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("Indent", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } else if (cmbreports.SelectedIndex == 4) { try { DataTable dtReport = new DataTable(); NameValueCollection para = new NameValueCollection(); para.Add("@i_FYID", CurrentUser.FYID.ToString()); para.Add("@i_UserId", CurrentUser.UserID.ToString()); para.Add("@i_CompId", CurrentCompany.CompId.ToString()); dtReport = objList.ListOfRecord("rpt_IndentRegister", para, "Indent - Report"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptGRNRegister.rpt")) { //dtblPurchaseInvoice .TableName = "PORegister"; //dtblPurchaseInvoice.WriteXmlSchema(@"D:\Report\PORegister.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptGRNRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Indent Register", true, true, true, true, false, true, true, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Indent 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("Indent - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } } cmbreports.SelectedIndex = 0; }