public void Print(Boolean LocalPrint)
{
DataSet ds = new DataSet();
ds.Tables.Add(oMySql.GetDataTable(String.Format("Select *,'Text' From Shortage Where ShortageID='{0}'", ID), "Shortage"));
Product oProduct = new Product(this.CompanyID);
String SchoolName = "";
foreach (DataRow row in ds.Tables["Shortage"].Rows)
{
row["Text"] = Global.ByteToString((Byte[])(row["Detail"]));
row["Address"] = row["Address"].ToString() + row["Address_2"].ToString();
foreach (DataRow drow in Items.Detail.Rows)
{
oProduct.Find(drow["ProductID"].ToString());
row["Text"] += "\n" + oProduct.InvCode + " - " + drow["ProductID"].ToString() + " - " + drow["Description"].ToString() + " - " + drow["Quantity"].ToString();
}
if (row["CustomerID"].ToString().Trim() != "")
{
if (oCustomer.Find(row["CustomerID"].ToString()))
{
SchoolName = oCustomer.Name;
}
}
}
frmViewReport oViewReport = new frmViewReport();
//ds.WriteXml("dataset72.xml", XmlWriteMode.WriteSchema);
ShortageReport oRpt = new ShortageReport();
oRpt.SetDataSource(ds);
oRpt.SetParameterValue("CompanyName", "Signature Fundraising, Inc.");
oRpt.SetParameterValue("SchoolName", SchoolName);
oRpt.SetParameterValue("User", Global.CurrentUser);
oRpt.SetParameterValue("Dates", "");
oRpt.SetParameterValue("Chairperson", "");
oRpt.SetParameterValue("StudentName", "");
String sType = "Not specified";
switch (Type)
{
case "A":
sType = "Add";
break;
case "O":
sType = "0verage";
break;
case "X":
sType = "Delete";
break;
case "M":
sType = "Miscellaneous";
break;
case "R":
sType = "Refund";
break;
case "D":
sType = "Damaged";
break;
case "B":
sType = "Missing";
break;
case "I":
sType = "Internet";
break;
case "E":
sType = "Missing Entire Order";
break;
case "Y":
sType = "Discrepancy";
break;
}
oRpt.SetParameterValue("Type", sType);
oRpt.SetParameterValue("BarCode", (sType != "Add")? "*" + ID + "*":"");
if (OrderID.Trim() != "")
{
if (oCustomer.ShipDate != Global.DNull || oCustomer.DeliveryDate != Global.DNull)
{
String ShipDate = oCustomer.ShipDate == Global.DNull ? " " : oCustomer.ShipDate.ToString("MM/dd/yyyy");
String DeliveryDate = oCustomer.DeliveryDate == Global.DNull ? " " : oCustomer.DeliveryDate.ToString("MM/dd/yyyy");
oRpt.SetParameterValue("Dates", "Ship Date: " + ShipDate + " " + "Delivery Date:" + DeliveryDate);
}
if (oCustomer.Chairperson.Trim() != "")
{
oRpt.SetParameterValue("Chairperson", "Chairperson:" + oCustomer.Chairperson);
}
oOrder = new Order(CompanyID);
oOrder.Find(Convert.ToInt32(OrderID));
oRpt.SetParameterValue("StudentName", "Student: " + oOrder.Student);
}
if (Global.CurrentUser == "JOYCE" || Global.CurrentUser == "ALVARO" || LocalPrint || Type == "R")
{
oViewReport.cReport.ReportSource = oRpt;
oViewReport.cReport.PrintReport();
//oViewReport.ShowDialog();
}
else
{
oRpt.PrintOptions.PrinterName = "\\\\srv1\\Shortage";
oRpt.PrintToPrinter(1, false, 1, 100);
}
ds.Dispose();
oRpt.Dispose();
oViewReport.Dispose();
}
