private void btnGenerateAndEmail_Click(object sender, EventArgs e) { ItemsListSummaryRpt rpt = BuildReport(); string filename = string.Format("{0}\\Emails\\ItemsListSummary[{1}].xls", Application.StartupPath, DateTime.Now.ToString("yyyyMMdd_HHmm")); rpt.WriteExcelReport(filename); mApplicationController.Email(null, null, filename); }
private void btnGenerate_Click(object sender, EventArgs e) { ItemsListSummaryRpt rpt = BuildReport(); string filename = string.Format("{0}\\Reports\\ItemsListSummary.htm", Application.StartupPath); rpt.WriteHtmlReport(filename); RptViewer.Navigate(filename); }
private ItemsListSummaryRpt BuildReport() { ItemsListSummaryRpt rpt = new ItemsListSummaryRpt(mApplicationController.mAccountant); rpt.DisplayItemNumber = chkItemNumber.Checked; rpt.DisplayItemName = chkItemName.Checked; rpt.DisplayBatchNumber = chkBatchNumber.Checked; rpt.DisplaySerialNumber = chkSerialNumber.Checked; rpt.DisplayExpiryDate = chkExpiryDate.Checked; rpt.DisplayBrand = chkBrand.Checked; rpt.DisplayColor = chkColor.Checked; rpt.DisplayGender = chkGender.Checked; rpt.DisplaySize = chkSize.Checked; rpt.DisplaySupplier = chkSupplier.Checked; rpt.DisplayStatus = chkStatus.Checked; rpt.DisplayPriceStatus = chkPriceStatus.Checked; rpt.DisplayTotalValue = chkTotalValue.Checked; rpt.DisplayUnitsOnHand = chkUnitsOnHand.Checked; rpt.DisplayAverageCost = chkAverageCost.Checked; rpt.DisplayItemDescription = chkItemDescription.Checked; rpt.DisplayCurrentPrice = chkCurrentPrice.Checked; rpt.FieldOrder[ItemsListSummaryRpt.FieldName.ItemNumber] = int.Parse(cboItemNumber.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.ItemName] = int.Parse(cboItemName.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.BatchNumber] = int.Parse(cboBatchNumber.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.SerialNumber] = int.Parse(cboSerialNumber.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.ExpiryDate] = int.Parse(cboExpiryDate.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Brand] = int.Parse(cboBrand.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Color] = int.Parse(cboColor.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Gender] = int.Parse(cboGender.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Size] = int.Parse(cboSize.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Supplier] = int.Parse(cboSupplier.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.CurrentPrice] = int.Parse(cboCurrentPrice.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.PriceStatus] = int.Parse(cboPriceStatus.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.ItemDescription] = int.Parse(cboItemDescription.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.UnitsOnHand] = int.Parse(cboUnitsOnHand.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.AverageCost] = int.Parse(cboAverageCost.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.TotalValue] = int.Parse(cboTotalValue.Text); rpt.FieldOrder[ItemsListSummaryRpt.FieldName.Status] = int.Parse(cboStatus.Text); rpt.ItemIsSold = chkItemIsSold.Checked; rpt.ItemIsBought = chkItemIsBought.Checked; rpt.ItemIsInventoried = chkItemIsInventoried.Checked; rpt.ItemKeywords = txtSearchFieldValue.Text; rpt.ItemFieldName = cboSearchFieldName.Text; rpt.IncludeCompanyAddress = chkIncludeCompanyAddress.Checked; rpt.IncludeCompanyName = chkIncludeCompanyName.Checked; rpt.IncludeReportDateAndTime = chkIncludeReportDateAndTime.Checked; return(rpt); }
private void BtnSave_Click(object sender, EventArgs e) { dlgSave.Filter = "Excel Files (*.xls)|*.xls|HTML Files (*.htm)|*.htm|Text Files (*.txt)|*.txt|PDF Files (*.pdf)|*.pdf|Rich Text Files (*.rtf)|*.rtf"; if (dlgSave.ShowDialog() == DialogResult.OK) { string filename = dlgSave.FileName; string ext = System.IO.Path.GetExtension(filename.ToLower()); ItemsListSummaryRpt rpt = BuildReport(); if (ext.Equals(".xls")) { rpt.WriteExcelReport(filename); } else if (ext.Equals(".htm")) { rpt.WriteHtmlReport(filename); } else if (ext.Equals(".txt")) { rpt.WriteDelimitedTextReport(filename); } else if (ext.Equals(".pdf")) { bool landscape = false; if (MessageBox.Show("Do you want to save the PDF in Landscape view?", "PDF Landscape View", MessageBoxButtons.YesNo) == DialogResult.Yes) { landscape = true; } rpt.WritePdfReport(filename, landscape); } else if (ext.Equals(".rtf")) { rpt.WriteRtfReport(filename); } if (MessageBox.Show("Do you want to open the file", "File Saved", MessageBoxButtons.YesNo) == DialogResult.Yes) { System.Diagnostics.Process.Start(filename); } } }