private void ShowCreditNoteReport(int id) { var creditNoteDataSet = new CreditNoteDataSet(); var firmTable = creditNoteDataSet.Tables["FirmMaster"]; var otherInfo = creditNoteDataSet.Tables["OtherInfo"]; _dataSetProvider.GetFirmDataTable(firmTable); var crn = _transactionService.GetCreditNotes().Single(x => x.Id == id); var customer = (Customer)cboCustomer.SelectedItem; var otherRow = otherInfo.NewRow(); otherRow["InvoiceNo"] = crn.InvoiceNo; otherRow["TransactionDate"] = crn.TransactionDate; otherRow["ContactName"] = customer.ContactName; otherRow["ContactNo"] = customer.Address.Phone; otherRow["Address"] = customer.Address.ToString(); otherRow["Particulars"] = crn.Description; otherRow["TotalAmount"] = crn.Amount; otherRow["VATNumber"] = customer.VATNumber; otherRow["CSTNumber"] = customer.CSTNumber; otherRow["AmountInWords"] = SpellNumber.SpellInWord(crn.Amount); otherInfo.Rows.Add(otherRow); var orderReport = new frmReport { ReportPath = ReportUtility.ResolveReportPath(ReportConstants.CreditNoteReport), ReportDataSet = creditNoteDataSet }; orderReport.Show(); }
private void btnShowReport_Click(object sender, EventArgs e) { if (IsValid == false) { MessageBox.Show(AllErrors.ErrorMessageString(), Constants.ALERTMESSAGEHEADER); return; } var transactionType = (TransactionType)Enum.Parse(typeof(TransactionType), cboTransactionType.SelectedItem.ToString()); var request = new TaxInvoiceReportRequest { TransactionNumber = txtInvoiceNo.Text, TransactionType = transactionType }; var response = new TaxInvoiceReportResponse(); var reportDocument = new ReportDocument(); if (rdoDetail.Checked) { response = _reportService.GetTransactionDetailReport(request); reportDocument.Load(ReportUtility.GetTaxInvoiceDetailReportPath(transactionType)); } else if (rdoSummary.Checked) { response = _reportService.GetTransactionSumaryReport(request); reportDocument.Load(ReportUtility.GetTaxInvoiceSummaryReportPath(transactionType)); } if (false == response.IsValid) { MessageBox.Show(response.AllErrors.ErrorMessageString(), Constants.ALERTMESSAGEHEADER); crystalReportViewer.ReportSource = null; return; } if (rdoDetail.Checked) { reportDocument.SetDataSource(response.TaxInvoiceDetailDataSet); } else if (rdoSummary.Checked) { reportDocument.SetDataSource(response.TaxInvoiceSummaryDataSet); } crystalReportViewer.ReportSource = reportDocument; crystalReportViewer.Refresh(); }
private void btnShowReport_Click(object sender, EventArgs e) { var reportDataSet = GetJewelTransactionReport(); if (reportDataSet == null) { return; } var reportDocument = new ReportDocument(); reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.JEWELTRANSACTIONREPORTPATH)); crystalReportViewer1.ReportSource = reportDocument; reportDocument.SetDataSource(reportDataSet); crystalReportViewer1.Refresh(); }
private void ShowSummartyReport(int id) { var lookup = _transactionService.GetJewelTransactionsLookUpById(id); TransactionType transactionType = lookup.TransactionType; var request = new TaxInvoiceReportRequest { TransactionNumber = lookup.MemoNumber, TransactionType = transactionType }; var response = _reportService.GetTransactionSumaryReport(request); var orderReport = new frmReport { ReportPath = ReportUtility.GetTaxInvoiceSummaryReportPath(transactionType), ReportDataSet = response.TaxInvoiceSummaryDataSet }; orderReport.Show(); }
private void frmBarcodePrinter_Load(object sender, EventArgs e) { var jewels = FormData as TransactionLookup; var jewelMasterDataSet = new JewelMasterDataSet(); var barcode = new BarcodeUtility(); foreach (var jewel in jewels.JewelTransactions) { var jewelImage = barcode.MakeBarcodeImage(jewel.JewelNumber); var jewelMasterRow = jewelMasterDataSet.Tables["JewelMaster"].NewRow(); jewelMasterRow["JewelNo"] = jewel.JewelNumber; jewelMasterRow["CertificateNo"] = jewel.CertificateNumber; jewelMasterRow["StyleNo"] = jewel.DesignCode; jewelMasterRow["JewelDescription"] = jewel.JewelType; jewelMasterRow["MetalColor"] = jewel.MetalColor; jewelMasterRow["ImagePath"] = ImageExtension.GetImageName(jewel.DesignCode); jewelMasterRow["DiamondPcs"] = Convert.ToString(jewel.StonePcs); jewelMasterRow["DiamondWt"] = Convert.ToString(jewel.StoneWeight); jewelMasterRow["GrsWt"] = Convert.ToString(jewel.TotalWeight); jewelMasterRow["NetWt"] = Convert.ToString(jewel.MetalWeight); jewelMasterRow["JewelImage"] = ImageConverterHelper.ImageToByteArray(jewelImage); jewelMasterDataSet.Tables["JewelMaster"].Rows.Add(jewelMasterRow); } if (File.Exists(ReportUtility.ResolveReportPath(ReportConstants.JEWELMASTERREPORTPATH))) { var reportDocument = new ReportDocument(); reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.JEWELMASTERREPORTPATH)); crystalReportViewer.ReportSource = null; crystalReportViewer.ReportSource = reportDocument; reportDocument.SetDataSource(jewelMasterDataSet); crystalReportViewer.Refresh(); } }
private void btnShowReport_Click(object sender, EventArgs e) { var reportDocument = new ReportDocument(); var reportType = ((LocalStore.MasterReportItems)(cboMasterReportType.SelectedItem)).ReportType; DataSet reportDataSet; switch (reportType) { case ReportType.Configuration: reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.CONFIGURATIONREPORTPATH)); reportDataSet = GetConfigurationsReport(); break; case ReportType.Customer: reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.CUSTOMERSREPORTPATH)); reportDataSet = GetCustomersReport(((CustomerItem)(cboSelectedReport.SelectedItem)).CustomerCode); break; case ReportType.Supplier: reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.SUPPLIERSREPORTPATH)); reportDataSet = GetSuppliersReport(((SupplierItem)(cboSelectedReport.SelectedItem)).SupplierCode); break; case ReportType.User: reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.USERSREPORTPATH)); reportDataSet = GetUsersReport(); break; default: throw new NotImplementedException(); } crystalReportViewer1.ReportSource = reportDocument; reportDocument.SetDataSource(reportDataSet); crystalReportViewer1.Refresh(); }
private void btnShowReport_Click(object sender, EventArgs e) { var jewelStockDataSet = new JewelStockDataSet(); var jewelStockDataTable = jewelStockDataSet.Tables["JewelStockLedger"]; var firmDataTable = jewelStockDataSet.Tables["FirmMaster"]; var jewelStockSummaryDataTable = jewelStockDataSet.Tables["JewelStockSummary"]; _firmDataSetService.GetFirmDataTable(firmDataTable); IQueryable <JewelStockLedger> jewelStockList; JewelItemCategory metalType; var stoneType = cboStoneType.SelectedItem.ToString(); Enum.TryParse(cboKT.SelectedItem.ToString(), out metalType); if (metalType == JewelItemCategory.NotSet && cboStoneType.SelectedItem.ToString() == ALL) { jewelStockList = _transactionsServices.GetJewelStockLedgers(); } else if (metalType != JewelItemCategory.NotSet && cboStoneType.SelectedItem.ToString() == ALL) { jewelStockList = _transactionsServices.GetJewelStockLedgers() .Where(tr => tr.JewelItemCategory_Enum == (int)metalType); } else { jewelStockList = _transactionsServices.GetJewelStockLedgers() .Where(tr => tr.JewelItemCategory_Enum == (short)metalType && tr.JewelType == stoneType); } int counter = 1; var list = jewelStockList.Where(x => x.StockStatus_Enum == (short)StockStatus.ItemIsInStock).ToList(); foreach (var jewel in list) { var jewelRow = jewelStockDataTable.NewRow(); jewelRow["SrNo"] = counter; jewelRow["JewelStockMasterId"] = jewel.JewelStockMasterId; jewelRow["JewelNumber"] = jewel.JewelNumber; jewelRow["DesignCode"] = jewel.DesignCode; jewelRow["TotalWeight"] = jewel.TotalWeight; jewelRow["MetalType"] = jewel.JewelItemCategory; jewelRow["KT"] = jewel.KT; jewelRow["StoneType"] = jewel.JewelType; jewelRow["MetalWeight"] = jewel.MetalWeight; jewelRow["StoneWeight"] = jewel.StoneWeight; jewelRow["StonePcs"] = jewel.StonePcs; jewelRow["ColorStonePcs"] = jewel.CStonePcs; jewelRow["ColorStoneWt"] = jewel.CStoneWeight; jewelStockDataTable.Rows.Add(jewelRow); counter = counter + 1; } var summaryRow = jewelStockSummaryDataTable.NewRow(); summaryRow["TotalInStock"] = jewelStockList.Count(x => x.StockStatus_Enum == (short)StockStatus.ItemIsInStock); summaryRow["TotalOutOfStock"] = jewelStockList.Count(x => x.JewelState_Enum == (short)JewelState.OnMarketing && x.StockStatus_Enum == (short)StockStatus.ItemLockedInStock); summaryRow["TotalOnApproval"] = jewelStockList.Count(x => x.JewelState_Enum == (short)JewelState.OnApproval && x.StockStatus_Enum == (short)StockStatus.ItemOutOfStock); jewelStockSummaryDataTable.Rows.Add(summaryRow); var reportDocument = new ReportDocument(); reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.JEWELSTOCKREPORTPATH)); crystalReportViewer1.ReportSource = reportDocument; reportDocument.SetDataSource(jewelStockDataSet); crystalReportViewer1.Refresh(); }