internal static itemSize getSize(string stockCode)
{
string sql = @"SELECT imposition.sizex As ""SizeX"", imposition.sizey As ""SizeY"" FROM imposition " +
"LEFT JOIN productgroup " +
"ON imposition.id = productgroup.impid " +
"LEFT JOIN productgroupmembers " +
"ON productgroup.id = productgroupmembers.groupid " +
"WHERE stockcode = :item_code " +
"LIMIT 1; ";
string[] parameterNames = { "item_code" };
string[] parameterVals = { stockCode };
DataTable rtTable;
try
{
rtTable = AWFPostgresDataLayer.GetDataTable(sql, parameterNames, parameterVals);
}
catch
{
throw;
}
if (rtTable.Rows.Count == 1)
{
return(new itemSize {
width = new Size(Convert.ToInt32((rtTable.Rows[0]["SizeX"]))), height = new Size(Convert.ToInt32((rtTable.Rows[0]["SizeY"])))
});
}
else
{
throw new Exception(String.Format("No Sizes found for the item: {0}", stockCode));
}
}
private static asset getAsset(AWF myAWF, int itemSequence, RBA_Variables variables)
{
string sql = string.Empty;
string itemCode = string.Format("%{0}%", myAWF.Products.Item[itemSequence].ItemCode);
string PDNumber = string.Format("{0}%", variables.VASSET_PREFIX + myAWF.Products.Item[itemSequence].SourcePDNumber);
string[] parameterNames = new string[1];
string[] parameterVals = new string[1];
switch (getProductType(myAWF, itemSequence, variables))
{
case productType.Static:
sql = "SELECT id, name "
+ "FROM asset "
+ "WHERE name LIKE :stock_code "
+ "LIMIT 1";
parameterNames = new string[] { "stock_code" };
parameterVals = new string[] { itemCode };
break;
case productType.Variable:
sql = "SELECT id, name "
+ "FROM asset "
+ "WHERE name LIKE :printdirect_number "
+ "AND name LIKE :stock_code "
+ "LIMIT 1";
parameterNames = new string[] { "printdirect_number", "stock_code" };
parameterVals = new string[] { PDNumber, itemCode };
break;
}
DataTable rtTable = AWFPostgresDataLayer.GetDataTable(sql, parameterNames, parameterVals);
if (rtTable.Rows.Count == 1)
{
return(new asset {
Id = Convert.ToString(rtTable.Rows[0]["id"]), Name = Convert.ToString(rtTable.Rows[0]["name"])
});
}
else
{
throw new Exception("Asset not found in Asset Table");
}
}
