private void PrintSOA()
{
Cursor.Current = Cursors.WaitCursor;
try
{
CRSReports.SOA rpt = new CRSReports.SOA();
AceSoft.RetailPlus.Client.ReportDataset rptds = new AceSoft.RetailPlus.Client.ReportDataset();
System.Data.DataRow drNew;
/****************************report logo *****************************/
try
{
System.IO.FileStream fs = new System.IO.FileStream(Application.StartupPath + "/images/ReportLogo.jpg", System.IO.FileMode.Open, System.IO.FileAccess.Read);
System.IO.FileInfo fi = new System.IO.FileInfo(Application.StartupPath + "/images/ReportLogo.jpg");
byte[] propimg = new byte[fi.Length];
fs.Read(propimg, 0, Convert.ToInt32(fs.Length));
fs.Close();
drNew = rptds.CompanyLogo.NewRow(); drNew["Picture"] = propimg;
rptds.CompanyLogo.Rows.Add(drNew);
}
catch { }
/****************************datatable*****************************/
Data.Contacts clsContacts = new Data.Contacts();
System.Data.DataTable dt = clsContacts.ListAsDataTable(ContactID: mclsCustomerDetails.ContactID);
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.Customer.NewRow();
foreach (System.Data.DataColumn dc in rptds.Customer.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Customer.Rows.Add(drNew);
}
dt = (System.Data.DataTable) dgvItems.DataSource;
foreach (System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.CustomerCredit.NewRow();
foreach (System.Data.DataColumn dc in rptds.CustomerCredit.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CustomerCredit.Rows.Add(drNew);
}
rpt.SetDataSource(rptds);
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition paramField;
CrystalDecisions.Shared.ParameterValues currentValues;
CrystalDecisions.Shared.ParameterDiscreteValue discreteParam;
paramField = rpt.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["PrintedBy"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CashierName;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["PackedBy"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CashierName;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CompanyAddress"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.Address1 +
((!string.IsNullOrEmpty(CompanyDetails.Address2) ? Environment.NewLine + CompanyDetails.Address2 + ", " : " ")) +
CompanyDetails.City + " " + CompanyDetails.Country +
((!string.IsNullOrEmpty(CompanyDetails.OfficePhone) ? Environment.NewLine + "Tel #: " + CompanyDetails.OfficePhone + " " : " ")) +
((!string.IsNullOrEmpty(CompanyDetails.OfficePhone) ? Environment.NewLine + "FaxPhone #: " + CompanyDetails.FaxPhone + " " : " "));
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["BIRInfo"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = "";
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
//foreach (CrystalDecisions.CrystalReports.Engine.ReportObject objPic in rpt.Section1.ReportObjects)
//{
// if (objPic.Name.ToUpper() == "PICLOGO1")
// {
// objPic = new Bitmap(Application.StartupPath + "/images/ReportLogo.jpg");
// }
//}
//CRViewer.Visible = true;
//CRViewer.ReportSource = rpt;
//CRViewer.Show();
try
{
DateTime logdate = DateTime.Now;
string logsdir = System.Configuration.ConfigurationManager.AppSettings["logsdir"].ToString();
if (!Directory.Exists(logsdir + logdate.ToString("MMM")))
{
Directory.CreateDirectory(logsdir + logdate.ToString("MMM"));
}
string logFile = logsdir + logdate.ToString("MMM") + "/SOA_" + logdate.ToString("yyyyMMddhhmmss") + ".doc";
rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, logFile);
}
catch { }
if (isPrinterOnline(TerminalDetails.SalesInvoicePrinterName))
{
rpt.PrintOptions.PrinterName = TerminalDetails.SalesInvoicePrinterName;
rpt.PrintToPrinter(1, false, 0, 0);
rpt.Close();
rpt.Dispose();
Cursor.Current = Cursors.Default;
MessageBox.Show("Statement Of Account for " + mclsCustomerDetails.ContactName + " has been printed.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
rpt.Close();
rpt.Dispose();
Cursor.Current = Cursors.Default;
MessageBox.Show("Sorry, will not print sales invoice. printer is offline.", "RetailPlus");
}
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show("Sorry an error was encountered during printing, please reprint again." + Environment.NewLine + "Details: " + ex.Message, "RetailPlus");
}
}
