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);
}
}
}
