();
oDynamicParam param1 = new oDynamicParam();
param1.paramDisplayName = "ParentSurfaceItemId";
param1.paramObject = Convert.ToString(dt.Rows[0]["itemID"]);
listDevice.Add(param1);
oDynamicParam param2 = new oDynamicParam();
param2.paramDisplayName = "OrderNo";
param2.paramObject = Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]);
listDevice.Add(param2);
oDynamicParam param3 = new oDynamicParam();
param3.paramDisplayName = "SupplyType";
param3.paramObject = Convert.ToInt32(supplyType);
listDevice.Add(param3);
DataTable childData = xData.GetTypedTableByProc("recId", typeof(oSurfaceFieldData), "SP_OrderPDFDetails", listDevice);
StringBuilder sb = new StringBuilder();
decimal totalprice = 0;
switch (supplyType)
{
case "1086": //Fabric
#region
PDFBody = PDFBody.Replace("{FABRICORDER}", "FABRIC ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderFabrics_FabricDetails_", "").ToString();
switch (column.ColumnName)
{
case "SupplierReference":
column.ColumnName = "Supplier Reference";
sb.Append("| " + column.ColumnName + " | ");
break;
case "QualityReference":
column.ColumnName = "Quality Reference";
sb.Append("" + column.ColumnName + " | ");
break;
case "TotalPrice":
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
break;
case "Extra":
column.ColumnName = "Extra %";
sb.Append("" + column.ColumnName + " | ");
break;
case "TotalMeters":
column.ColumnName = "Total Meters";
sb.Append("" + column.ColumnName + " | ");
break;
case "Description":
sb.Append("" + column.ColumnName + " | ");
break;
default:
sb.Append("" + column.ColumnName + " | ");
break;
}
}
sb.Append("
");
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
totalprice += Convert.ToDecimal(row[column.ColumnName]);
if (column.ColumnName == "Supplier Reference" || column.ColumnName == "Quality Reference" || column.ColumnName == "Description"
|| column.ColumnName == "Colour")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
break;
#endregion
case "1083": //Binding
#region Binding
PDFBody = PDFBody.Replace("{FABRICORDER}", "BINDING ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderBinding_BindingDetails_", "").ToString();
if (column.ColumnName == "FabricQualityReference")
{
column.ColumnName = "Fabric Quality Reference";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricDescription")
{
column.ColumnName = "Fabric Description";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricColour")
{
column.ColumnName = "Fabric Colour";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "BindingDescription")
{
column.ColumnName = "Binding Description";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalPrice")
{
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
//Adding DataRow.
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
{
totalprice += Convert.ToDecimal(row[column.ColumnName]);
}
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
break;
#endregion
case "1084": //CMT
#region
PDFBody = PDFBody.Replace("{FABRICORDER}", "CMT ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderCMT_CMTDetails_", "").ToString();
if (column.ColumnName == "StyleDescription")
{
column.ColumnName = "Style Description";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "StyleColour")
{
column.ColumnName = "Style Colour";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "StyleUnits")
{
column.ColumnName = "Style Units";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "OutworkRequired")
{
column.ColumnName = "Outwork Required";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "CMTUnitPrice")
{
column.ColumnName = "CMT Unit Price";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "StandardMinuteValue")
{
column.ColumnName = "SMV";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "CMTUnitPrice")
{
column.ColumnName = "CMT Unit Price";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalPrice")
{
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
//Adding DataRow.
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
totalprice += Convert.ToDecimal(row[column.ColumnName]);
if (column.ColumnName == "Total Price" || column.ColumnName == "SMV" || column.ColumnName == "CMT Unit Price")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
sb.Append("
");
PDFBody += sb.ToString();
StringBuilder intake = new StringBuilder();
intake.Append("");
intake.Append("");
intake.Append("| Intake Year: | ");
intake.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_CMTIntakeYear"]) + " | ");
intake.Append(" Intake Month: | ");
intake.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_CMTIntakeMonth"]) + " | ");
intake.Append("
");
intake.Append("
");
PDFBody += intake.ToString();
break;
#endregion
case "1085": //Cutting
#region Cutting
PDFBody = PDFBody.Replace("{FABRICORDER}", "CUTTING ORDER");
string cutting = $"select OrderCutting_CuttingDetails_FabricQualityReference,OrderCutting_CuttingDetails_FabricDescription," +
$"OrderCutting_CuttingDetails_FabricColour,OrderCutting_CuttingDetails_Width, OrderCutting_CuttingDetails_InternalRating" +
$",OrderCutting_CuttingDetails_MarkerRating from publ_OrderCutting" +
$" where ParentSurfaceItemId= " + Convert.ToString(dt.Rows[0]["itemID"]) + " and " +
$"OrderCutting_OrderDetails_OrderNumber='" + Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]) + "' " +
"and surfaceId = 3080 and isActive = 1";
DataTable dtcuttingdata = xData.GetCustomTypedTable(cutting);
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in dtcuttingdata.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderCutting_CuttingDetails_", "").ToString();
if (column.ColumnName == "FabricQualityReference")
{
column.ColumnName = "Fabric Quality Reference";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricDescription")
{
column.ColumnName = "Fabric Description";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricColour")
{
column.ColumnName = "Fabric Colour";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "InternalRating")
{
column.ColumnName = "Internal Rating";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "MarkerRating")
{
column.ColumnName = "Marker Rating";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
if (dtcuttingdata.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtcuttingdata.Rows)
{
sb.Append("");
foreach (DataColumn column in dtcuttingdata.Columns)
{
if (column.ColumnName == "Fabric Quality Reference" || column.ColumnName == "Fabric Description" || column.ColumnName == "Fabric Colour")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
string cuttingsizequery = $"select OrderCuttingSizes_CuttingSizes_SizeName,OrderCuttingSizes_CuttingSizes_SizeUnits from publ_OrderCuttingSizes" +
$" where ParentSurfaceItemId= " + Convert.ToString(dt.Rows[0]["itemID"]) + " and " +
$"OrderCuttingSizes_OrderDetails_OrderNumber='" + Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]) + "' " +
"and surfaceId = 3081 and isActive = 1";
DataTable dtcuttingsizedata = xData.GetCustomTypedTable(cuttingsizequery);
StringBuilder cuttingsize = new StringBuilder();
//Table start.
cuttingsize.Append("
");
cuttingsize.Append("");
//Adding HeaderRow.
cuttingsize.Append("");
foreach (DataColumn column in dtcuttingsizedata.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderCuttingSizes_CuttingSizes_", "").ToString();
if (column.ColumnName == "SizeName")
{
column.ColumnName = "Size Name";
cuttingsize.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "SizeUnits")
{
column.ColumnName = "Size Units";
cuttingsize.Append("" + column.ColumnName + " | ");
}
}
cuttingsize.Append("
");
if (dtcuttingsizedata.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtcuttingsizedata.Rows)
{
cuttingsize.Append("");
foreach (DataColumn column in dtcuttingsizedata.Columns)
{
if (column.ColumnName == "Size Name")
cuttingsize.Append("| " + row[column.ColumnName].ToString() + " | ");
else
cuttingsize.Append("" + row[column.ColumnName].ToString() + " | ");
}
cuttingsize.Append("
");
}
}
else
{
cuttingsize.Append("");
cuttingsize.Append("| No data available in table | ");
cuttingsize.Append("
");
}
//Table end.
cuttingsize.Append("
");
cuttingsize.Append("
");
PDFBody += cuttingsize.ToString();
StringBuilder cs = new StringBuilder();
cs.Append("");
cs.Append("");
cs.Append("| Master Size: | ");
cs.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_CuttingMasterSize"]) + " | ");
cs.Append("Marker Maker: | ");
cs.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_CuttingMarkerMaker"]) + " | ");
cs.Append("
");
cs.Append("
");
PDFBody += cs.ToString();
break;
#endregion
case "1087": //Outwork
#region Outwork
PDFBody = PDFBody.Replace("{FABRICORDER}", "OUTWORK ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderOutwork_OutworkDetails_", "").ToString();
if (column.ColumnName == "UnitsorMeters")
{
column.ColumnName = "Units or Meters";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalUnitsorMeters")
{
column.ColumnName = "Total Units/Meters";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalPrice")
{
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
totalprice += Convert.ToDecimal(row[column.ColumnName]);
if (column.ColumnName == "Reference" || column.ColumnName == "Description" || column.ColumnName == "Colour")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
break;
#endregion
case "1137": //Reshaping
#region Reshaping
PDFBody = PDFBody.Replace("{FABRICORDER}", "RESHAPING ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderReshaping_ReshapingDetails_", "").ToString();
if (column.ColumnName == "FabricQualityReference")
{
column.ColumnName = "Fabric Quality Reference";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricDescription")
{
column.ColumnName = "Fabric Description";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "FabricColour")
{
column.ColumnName = "Fabric Colour";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "InternalRating")
{
column.ColumnName = "Internal Rating";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "MarkerRating")
{
column.ColumnName = "Marker Rating";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
if (childData.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Fabric Quality Reference" || column.ColumnName == "Fabric Description" || column.ColumnName == "Fabric Colour")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
string reshapingsizequery = $"select OrderReshapingSizes_ReshapingSizes_SizeName,OrderReshapingSizes_ReshapingSizes_SizeUnits from publ_OrderReshapingSizes " +
$" where ParentSurfaceItemId= " + Convert.ToString(dt.Rows[0]["itemID"]) + " and " +
$"OrderReshapingSizes_OrderDetails_OrderNumber='" + Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]) + "' " +
"and surfaceId = 3083 and isActive = 1";
DataTable dtreshapingsizedata = xData.GetCustomTypedTable(reshapingsizequery);
StringBuilder reshapingsize = new StringBuilder();
//Table start.
reshapingsize.Append("
");
reshapingsize.Append("");
//Adding HeaderRow.
reshapingsize.Append("");
foreach (DataColumn column in dtreshapingsizedata.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderReshapingSizes_ReshapingSizes_", "").ToString();
if (column.ColumnName == "SizeName")
{
column.ColumnName = "Size Name";
reshapingsize.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "SizeUnits")
{
column.ColumnName = "Size Units";
reshapingsize.Append("" + column.ColumnName + " | ");
}
}
reshapingsize.Append("
");
if (dtreshapingsizedata.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtreshapingsizedata.Rows)
{
reshapingsize.Append("");
foreach (DataColumn column in dtreshapingsizedata.Columns)
{
if (column.ColumnName == "Size Name")
reshapingsize.Append("| " + row[column.ColumnName].ToString() + " | ");
else
reshapingsize.Append("" + row[column.ColumnName].ToString() + " | ");
}
reshapingsize.Append("
");
}
}
else
{
reshapingsize.Append("");
reshapingsize.Append("| No data available in table | ");
reshapingsize.Append("
");
}
//Table end.
reshapingsize.Append("
");
reshapingsize.Append("
");
PDFBody += reshapingsize.ToString();
StringBuilder rs = new StringBuilder();
rs.Append("");
rs.Append("");
rs.Append("| Master Size: | ");
rs.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_ReshapingMasterSize"]) + " | ");
rs.Append("Marker Maker: | ");
rs.Append("" + Convert.ToString(dt.Rows[0]["Orders_SupplyDetails_ReshapingMarkerMaker"]) + " | ");
rs.Append("
");
rs.Append("
");
PDFBody += rs.ToString();
break;
#endregion
case "1090": //Trim
#region Trim
PDFBody = PDFBody.Replace("{FABRICORDER}", "TRIM ORDER");
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderTrims_TrimDetails_", "").ToString();
if (column.ColumnName == "SupplierReference")
{
column.ColumnName = "Supplier Reference";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "QualityReference")
{
column.ColumnName = "Quality Reference";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalPrice")
{
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TrimColour")
{
column.ColumnName = "Trim Colour";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "UnitsorMetres")
{
column.ColumnName = "Units or Metres";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalUnitsorMeters")
{
column.ColumnName = "Total Units/Meters";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
//Adding DataRow.
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
totalprice += Convert.ToDecimal(row[column.ColumnName]);
if (column.ColumnName == "Total Price" || column.ColumnName == "Total Units/Meters" || column.ColumnName == "Units or Metres"
|| column.ColumnName == "Price")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
break;
#endregion
case "1091": //Zip
#region Zip
//Table start.
sb.Append("");
//Adding HeaderRow.
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderZips_ZipDetails_", "").ToString();
if (column.ColumnName == "SupplierReference")
{
column.ColumnName = "Supplier Reference";
sb.Append("| " + column.ColumnName + " | ");
}
else if (column.ColumnName == "QualityReference")
{
column.ColumnName = "Quality Reference";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalPrice")
{
column.ColumnName = "Total Price";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "TotalUnits")
{
column.ColumnName = "Total Units";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "UnitPrice")
{
column.ColumnName = "Unit Price";
sb.Append("" + column.ColumnName + " | ");
}
else if (column.ColumnName == "ZipColour")
{
column.ColumnName = "Zip Colour";
sb.Append("" + column.ColumnName + " | ");
}
else
{
sb.Append("" + column.ColumnName + " | ");
}
}
sb.Append("
");
//Adding DataRow.
if (childData.Rows.Count > 0)
{
foreach (DataRow row in childData.Rows)
{
sb.Append("");
foreach (DataColumn column in childData.Columns)
{
if (column.ColumnName == "Total Price")
totalprice += Convert.ToDecimal(row[column.ColumnName]);
if (column.ColumnName == "Supplier Reference" || column.ColumnName == "Quality Reference" || column.ColumnName == "Zip Colour"
|| column.ColumnName == "Description")
sb.Append("| " + row[column.ColumnName].ToString() + " | ");
else
sb.Append("" + row[column.ColumnName].ToString() + " | ");
}
sb.Append("
");
}
}
else
{
sb.Append("");
sb.Append("| No data available in table | ");
sb.Append("
");
}
sb.Append("Total Amount (Excl. VAT): R | ");
sb.Append("" + totalprice.ToString() + " | ");
//Table end.
sb.Append("
");
PDFBody += sb.ToString();
string parentId = "0";
string zipsizequery = $"select OrderZipSizes_ZipSizeDetails_ZipSize";
if (Convert.ToInt32(dt.Rows[0]["ParentSurfaceItemId"]) != 0)
{
parentId = Convert.ToString(dt.Rows[0]["itemID"]);
zipsizequery += $",OrderZipSizes_ZipSizeDetails_StyleSize";
}
else
{
parentId = Convert.ToString(childData.Rows[0]["itemID"]);
zipsizequery += $", OrderZipSizes_ZipSizeDetails_Units";
}
zipsizequery += $" from publ_OrderZipSizes where ParentSurfaceItemId= " + parentId + " and " +
$"OrderZipSizes_ZipSizeDetails_OrderNumber='" + Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]) + "' " +
"and surfaceId = 3086 and isActive = 1";
DataTable dtzipsizedata = xData.GetCustomTypedTable(zipsizequery);
StringBuilder zipsize = new StringBuilder();
//Table start.
zipsize.Append("
");
zipsize.Append("");
//Adding HeaderRow.
zipsize.Append("");
foreach (DataColumn column in dtzipsizedata.Columns)
{
column.ColumnName = column.ColumnName.Replace("OrderZipSizes_ZipSizeDetails_", "").ToString();
if (column.ColumnName == "StyleSize")
column.ColumnName = "Style Size";
else if (column.ColumnName == "ZipSize")
column.ColumnName = "Zip Size";
else if (column.ColumnName == "Units")
column.ColumnName = "Units Per Size";
zipsize.Append("| " + column.ColumnName + " | ");
}
zipsize.Append("
");
decimal totalUnits = 0;
if (dtzipsizedata.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtzipsizedata.Rows)
{
zipsize.Append("");
foreach (DataColumn column in dtzipsizedata.Columns)
{
if (column.ColumnName == "Units Per Size")
{
totalUnits += Convert.ToDecimal(row[column.ColumnName]);
}
zipsize.Append("| " + row[column.ColumnName].ToString() + " | ");
}
zipsize.Append("
");
}
}
else
{
zipsize.Append("");
zipsize.Append("| No data available in table | ");
zipsize.Append("
");
}
if (Convert.ToInt32(dt.Rows[0]["ParentSurfaceItemId"]) == 0)
{
zipsize.Append("Total Units : | ");
zipsize.Append("" + totalUnits.ToString() + " | ");
}
//Table end.
zipsize.Append("
");
zipsize.Append("
");
PDFBody += zipsize.ToString();
break;
#endregion
}
string reportBody = PDFBody;
string OrderNumber = Convert.ToString(dt.Rows[0]["Orders_OrderDetails_OrderNumber"]).Replace(":", "-");
string reportFile = "Order_" + OrderNumber + "_" + DateTime.Now.ToString("yyyy-MM-dd-hh-mm") + ".pdf";
string reportPath = HttpContext.Current.Server.MapPath("~/upload/documents/");
utils.validateFolder(reportPath);
utils.ConvertHTMLToPDFFile(reportBody, reportPath + reportFile, true, "", "", false);
pdfFile = reportFile;
}
return pdfFile;
}
#endregion
#region TrimPack PDF Print
public static string TrimPackPDFPrint(int itemId)
{
string PDFBody = string.Empty, pdfFile = string.Empty;
List listDevice = new List();
oDynamicParam param2 = new oDynamicParam();
param2.paramDisplayName = "ParentItemId";
param2.paramObject = itemId;
listDevice.Add(param2);
DataSet childData = xData.GetTypedDataSetByProc("recId", typeof(oSurfaceFieldData), "SP_GetAllTrimPackDetails", listDevice);
DataTable dtStyleTrimPackData = childData.Tables[0];
if (dtStyleTrimPackData.Rows.Count > 0)
{
StringBuilder sbTrimPackLabel = new StringBuilder();
sbTrimPackLabel.Append(""); sbTrimPackLabel.Append("");
sbTrimPackLabel.Append("| Style TrimPack : | ");
sbTrimPackLabel.Append("
"); sbTrimPackLabel.Append("
");
PDFBody += sbTrimPackLabel.ToString();
StringBuilder sbStyleDetail = new StringBuilder();
sbStyleDetail.Append("
"); sbStyleDetail.Append(""); sbStyleDetail.Append("");
sbStyleDetail.Append("| Style ID | ");
sbStyleDetail.Append(" : " + Convert.ToString(dtStyleTrimPackData.Rows[0]["StyleDetails_StyleID"]) + " | ");
sbStyleDetail.Append(" Brand Name | ");
sbStyleDetail.Append(" : " + Convert.ToString(dtStyleTrimPackData.Rows[0]["StyleDetails_BrandName"]) + " | ");
sbStyleDetail.Append("
"); sbStyleDetail.Append("");
sbStyleDetail.Append("| Style Code | ");
sbStyleDetail.Append(" : " + Convert.ToString(dtStyleTrimPackData.Rows[0]["StyleDetails_StyleCode"]) + " | ");
sbStyleDetail.Append(" Colour | ");
sbStyleDetail.Append(" : " + Convert.ToString(dtStyleTrimPackData.Rows[0]["StyleDetails_StyleColour"]) + " | ");
sbStyleDetail.Append("
"); sbStyleDetail.Append("
");
PDFBody += sbStyleDetail.ToString();
#region wash care and general items
StringBuilder sbWashCareLabel = new StringBuilder();
sbWashCareLabel.Append("
"); sbWashCareLabel.Append(""); sbWashCareLabel.Append("");
sbWashCareLabel.Append("| Wash Cares : | ");
sbWashCareLabel.Append(" General Items : | ");
sbWashCareLabel.Append("
"); sbWashCareLabel.Append("
");
PDFBody += sbWashCareLabel.ToString();
StringBuilder sbWashCare = new StringBuilder();
DataTable dtGeneralItem = childData.Tables[2];
DataTable dtWashCaredata = childData.Tables[1];
sbWashCare.Append("
");
sbWashCare.Append("");
sbWashCare.Append("");
sbWashCare.Append("");
#region wash care table
sbWashCare.Append("");
sbWashCare.Append("");
foreach (DataColumn column in dtWashCaredata.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackWashCares_WashCareNumbers_", "").ToString();
if (column.ColumnName == "SizeName")
{
column.ColumnName = "Size Name";
}
sbWashCare.Append("| " + column.ColumnName + " | ");
}
sbWashCare.Append(" ");
if (dtWashCaredata.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtWashCaredata.Rows)
{
sbWashCare.Append("");
foreach (DataColumn column in dtWashCaredata.Columns)
{
sbWashCare.Append("| " + row[column.ColumnName].ToString() + " | ");
}
sbWashCare.Append(" ");
}
}
else
{
sbWashCare.Append("");
sbWashCare.Append("| No data available in table | ");
sbWashCare.Append(" ");
}
sbWashCare.Append(" ");
#endregion
sbWashCare.Append(" | ");
sbWashCare.Append("");
#region general table
sbWashCare.Append("");
sbWashCare.Append("");
foreach (DataColumn column in dtGeneralItem.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackGeneralItems_GeneralItemNumbers_", "").ToString();
sbWashCare.Append("| " + column.ColumnName + " | ");
}
sbWashCare.Append(" ");
if (dtGeneralItem.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow row in dtGeneralItem.Rows)
{
sbWashCare.Append("");
foreach (DataColumn column in dtGeneralItem.Columns)
{
sbWashCare.Append("| " + row[column.ColumnName].ToString() + " | ");
}
sbWashCare.Append(" ");
}
}
else
{
sbWashCare.Append("");
sbWashCare.Append("| No data available in table | ");
sbWashCare.Append(" ");
}
sbWashCare.Append(" ");
#endregion
sbWashCare.Append(" | "); sbWashCare.Append("
");
sbWashCare.Append("
");
PDFBody += sbWashCare.ToString();
#endregion
StringBuilder sbTrimpackData = new StringBuilder();
sbTrimpackData.Append("
"); sbTrimpackData.Append(""); sbTrimpackData.Append("");
sbTrimpackData.Append("| Fabric Content : " + Convert.ToString(dtStyleTrimPackData.Rows[0]["Trimpack_StyleTrimpack_FabricContent"]) + " | ");
sbTrimpackData.Append(" SKU Price: " + Convert.ToString(dtStyleTrimPackData.Rows[0]["Trimpack_StyleTrimpack_SKUPrice"]) + " | ");
sbTrimpackData.Append(" SKU Total Price: " + Convert.ToString(dtStyleTrimPackData.Rows[0]["Trimpack_StyleTrimpack_SKUTotalPrice"]) + " | ");
sbTrimpackData.Append("
"); sbTrimpackData.Append("
");
PDFBody += sbTrimpackData.ToString();
#region Binding
DataTable dtbindingdata = childData.Tables[3];
StringBuilder sbBindingLabel = new StringBuilder();
sbBindingLabel.Append("
");
sbBindingLabel.Append(""); sbBindingLabel.Append("");
sbBindingLabel.Append("| Binding : | ");
sbBindingLabel.Append("
"); sbBindingLabel.Append("
");
PDFBody += sbBindingLabel.ToString();
StringBuilder sbBinding = new StringBuilder();
sbBinding.Append("");
sbBinding.Append("");
foreach (DataColumn column in dtbindingdata.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackBinding_BindingDetails_", "").ToString();
switch (column.ColumnName)
{
case "FabricQualityReference":
column.ColumnName = "Fabric Quality Reference";
sbBinding.Append("| " + column.ColumnName + " | ");
break;
case "FabricDescription":
column.ColumnName = "Fabric Description";
sbBinding.Append("" + column.ColumnName + " | ");
break;
case "FabricColour":
column.ColumnName = "Fabric Colour";
sbBinding.Append("" + column.ColumnName + " | ");
break;
case "BindingDescription":
column.ColumnName = "Binding Description";
sbBinding.Append("" + column.ColumnName + " | ");
break;
default:
sbBinding.Append("" + column.ColumnName + " | ");
break;
}
}
sbBinding.Append("
");
//Adding DataRow.
if (dtbindingdata.Rows.Count > 0)
{
foreach (DataRow row in dtbindingdata.Rows)
{
sbBinding.Append("");
foreach (DataColumn column in dtbindingdata.Columns)
{
sbBinding.Append("| " + row[column.ColumnName].ToString() + " | ");
}
sbBinding.Append("
");
}
}
else
{
sbBinding.Append("");
sbBinding.Append("| No data available in table | ");
sbBinding.Append("
");
}
//Table end.
sbBinding.Append("
");
PDFBody += sbBinding.ToString();
#endregion
#region Trims
DataTable dttrimdata = childData.Tables[4];
StringBuilder sbTrimLabel = new StringBuilder();
sbTrimLabel.Append("
");
sbTrimLabel.Append(""); sbTrimLabel.Append("");
sbTrimLabel.Append("| Trims : | ");
sbTrimLabel.Append("
"); sbTrimLabel.Append("
");
PDFBody += sbTrimLabel.ToString();
StringBuilder sbTrim = new StringBuilder();
//Table start.
sbTrim.Append("");
//Adding HeaderRow.
sbTrim.Append("");
foreach (DataColumn column in dttrimdata.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackTrims_TrimDetails_", "").ToString();
switch (column.ColumnName)
{
case "QualityReference":
column.ColumnName = "Quality Reference";
sbTrim.Append("| " + column.ColumnName + " | ");
break;
case "Description":
sbTrim.Append("" + column.ColumnName + " | ");
break;
case "TrimColour":
column.ColumnName = "Trim Colour";
sbTrim.Append("" + column.ColumnName + " | ");
break;
case "UnitsorMeters":
column.ColumnName = "Units or Metres";
sbTrim.Append("" + column.ColumnName + " | ");
break;
default:
sbTrim.Append("" + column.ColumnName + " | ");
break;
}
}
sbTrim.Append("
");
//Adding DataRow.
if (dttrimdata.Rows.Count > 0)
{
foreach (DataRow row in dttrimdata.Rows)
{
sbTrim.Append("");
foreach (DataColumn column in dttrimdata.Columns)
{
sbTrim.Append("| " + row[column.ColumnName].ToString() + " | ");
}
sbTrim.Append("
");
}
}
else
{
sbTrim.Append("");
sbTrim.Append("| No data available in table | ");
sbTrim.Append("
");
}
//Table end.
sbTrim.Append("
");
PDFBody += sbTrim.ToString();
#endregion
#region Zips and Zip Size
DataTable dtzipdata = childData.Tables[5];
StringBuilder sbZipLabel = new StringBuilder();
sbZipLabel.Append("
");
sbZipLabel.Append(""); sbZipLabel.Append("");
sbZipLabel.Append("| Zips : | ");
sbZipLabel.Append("
"); sbZipLabel.Append("
");
PDFBody += sbZipLabel.ToString();
StringBuilder sbZip = new StringBuilder();
//Table start.
sbZip.Append("");
//Adding HeaderRow.
sbZip.Append("");
foreach (DataColumn column in dtzipdata.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackZips_ZipDetails_", "").ToString();
switch (column.ColumnName)
{
case "QualityReference":
column.ColumnName = "Quality Reference";
sbZip.Append("| " + column.ColumnName + " | ");
break;
case "Description":
sbZip.Append("" + column.ColumnName + " | ");
break;
case "ZipColour":
column.ColumnName = "Zip Colour";
sbZip.Append("" + column.ColumnName + " | ");
break;
case "ZipID":
break;
case "ParentSurfaceItemId":
break;
default:
sbZip.Append("" + column.ColumnName + " | ");
break;
}
}
sbZip.Append("
");
string zipID = string.Empty;
//Adding DataRow.
if (dtzipdata.Rows.Count > 0)
{
foreach (DataRow row in dtzipdata.Rows)
{
sbZip.Append("");
foreach (DataColumn column in dtzipdata.Columns)
{
if (column.ColumnName == "Quality Reference" || column.ColumnName == "Zip Colour"
|| column.ColumnName == "Description")
{
sbZip.Append("| " + row[column.ColumnName].ToString() + " | ");
}
else if (column.ColumnName == "ZipID" || column.ColumnName == "ParentSurfaceItemId")
{
if (column.ColumnName == "ZipID")
zipID = row[column.ColumnName].ToString();
}
else
{
sbZip.Append("" + row[column.ColumnName].ToString() + " | ");
}
}
sbZip.Append("
");
sbZip.Append("");
var trimpackZipSizes = "SELECT TrimpackZipSizes_ZipSizeDetails_StyleSize,TrimpackZipSizes_ZipSizeDetails_ZipSize," +
"TrimpackZipSizes_ZipSizeDetails_Quantity FROM publ_TrimpackZipSizes WHERE ParentSurfaceItemId = '" + Convert.ToString(dtzipdata.Rows[0]["ParentSurfaceItemId"]) + "'" +
"and TrimpackZipSizes_ZipSizeDetails_ZipID ='" + zipID.ToString() + "'";
DataTable dtzipsize = xData.GetCustomTypedTable(trimpackZipSizes);
foreach (DataColumn column in dtzipsize.Columns)
{
column.ColumnName = column.ColumnName.Replace("TrimpackZipSizes_ZipSizeDetails_", "").ToString();
if (column.ColumnName == "StyleSize")
{
column.ColumnName = "Style Size";
}
else if (column.ColumnName == "ZipSize")
{
column.ColumnName = "Zip Size";
}
sbZip.Append("| " + column.ColumnName + " | ");
}
sbZip.Append(" | ");
sbZip.Append("
");
if (dtzipsize.Rows.Count > 0)
{
//Adding DataRow.
foreach (DataRow rW in dtzipsize.Rows)
{
sbZip.Append("");
foreach (DataColumn column in dtzipsize.Columns)
{
sbZip.Append("| " + rW[column.ColumnName].ToString() + " | ");
}
sbZip.Append(" | ");
sbZip.Append("
");
}
}
else
{
sbZip.Append("");
sbZip.Append("| No data available in table | ");
sbZip.Append("
");
}
}
}
else
{
sbZip.Append("");
sbZip.Append("| No data available in table | ");
sbZip.Append("
");
}
//Table end.
sbZip.Append("
");
PDFBody += sbZip.ToString();
#endregion
StringBuilder sbNotes = new StringBuilder();
sbNotes.Append("
");
sbNotes.Append("");
sbNotes.Append("");
sbNotes.Append("| Notes/Instructions : | ");
sbNotes.Append("" + Convert.ToString(childData.Tables[0].Rows[0]["Trimpack_StyleTrimpack_Instructions"]) + " | ");
sbNotes.Append("
");
sbNotes.Append("
");
PDFBody += sbNotes.ToString();
}
string reportBody = PDFBody;
string reportFile = "TrimPack_" + DateTime.Now.ToString("yyyy-MM-dd-hh-mm") + ".pdf";
string reportPath = HttpContext.Current.Server.MapPath("~/upload/documents/");
utils.validateFolder(reportPath);
utils.ConvertHTMLToPDFFile(reportBody, reportPath + reportFile, true, "", "", false);
pdfFile = reportFile;
return pdfFile;
}
#endregion
}
}