public static bool AddOrderMaterial(Guid orderID, OrderMaterialItem itm, ref SQLWrapper sw)
{
bool returnValue = false;
SqlParameter[] param = prepareParams(orderID, itm);
returnValue = sw.ExecuteStoredProcedureInTransaction("ORD_AddUpdateOrderMaterial",param);
return returnValue;
}
private static OrderMaterialItem loadOrderMaterialItem(DataRow dr)
{
OrderMaterialItem itm = null;
if (dr != null)
{
itm = new OrderMaterialItem();
itm.AssignedTailor = TailorDAL.GetTailorByID(Convert.ToInt32(dr["TailorID"]));
itm.ItemDescription = new ItemDescriptions();
itm.ItemDescription.OrderItemQuantity = Convert.ToInt32(dr["Quantity"]);
itm.ItemDescription.OrderItemType = CommonDAL.GetItemDescriptionTypeByID(Convert.ToInt32(dr["ItemType"]));
itm.MaterialDescription = dr["MaterialDescription"].ToString();
itm.MaterialName = dr["MaterialName"].ToString();
itm.Sequence = getCharacterSequence(Convert.ToInt32(dr["Sequence"]));
itm.SubItem1 = dr["SubItem1Name"].ToString();
itm.SubItem1Price = Convert.ToDecimal(dr["SubItem1Price"]);
itm.SubItem1Qty = Convert.ToInt32(dr["SubItem1Qty"]);
itm.SubItem1Type = (SuitSubItemTypes)dr["SubItem1Type"];
itm.SubItem2 = dr["SubItem2Name"].ToString();
itm.SubItem2Price = Convert.ToDecimal(dr["SubItem2Price"]);
itm.SubItem2Qty = Convert.ToInt32(dr["SubItem2Qty"]);
itm.SubItem2Type = (SuitSubItemTypes)dr["SubItem2Type"];
itm.UnitPrice = Convert.ToDecimal(dr["Price"]);
itm.Yardage = Convert.ToDecimal(dr["Yardage"]);
itm.MaterialColor = CommonDAL.GetColorByID(Convert.ToInt32(dr["Color"]));
itm.MaterialPattern = CommonDAL.GetPatternByID(Convert.ToInt32(dr["Pattern"]));
itm.MaterialCategory = CommonDAL.GetCategoryByID(Convert.ToInt32(dr["Category"]));
itm.FabricWidth = (FabricWidths)Convert.ToInt32(dr["FabricWidth"]);
itm.IncludeSlackHalfLining = Convert.ToBoolean(dr["IncludeSlackHalfLining"]);
itm.IncludeSlackFullLining = Convert.ToBoolean(dr["IncludeSlackFullLining"]);
itm.IncludeRBHole = Convert.ToBoolean(dr["IncludeRBHole"]);
itm.IncludeHSEdges = Convert.ToBoolean(dr["IncludeHSEdges"]);
itm.IncludeMono = Convert.ToBoolean(dr["IncludeMono"]);
itm.IncludePB = Convert.ToBoolean(dr["IncludePB"]);
itm.IncludeWCC = Convert.ToBoolean(dr["IncludeWCC"]);
itm.IncludeWC = Convert.ToBoolean(dr["IncludeWC"]);
itm.IncludeSS = Convert.ToBoolean(dr["IncludeSS"]);
itm.IncludeFT = Convert.ToBoolean(dr["IncludeFT"]);
}
return itm;
}
private static SqlParameter[] prepareParams(Guid orderID, OrderMaterialItem itm)
{
SqlParameter[] param =
{
new SqlParameter("OrderID",typeof(Guid )),
new SqlParameter("Sequence",typeof(Int32)),
new SqlParameter("MaterialName",typeof(string)),
new SqlParameter("MaterialDescription",typeof(string)),
new SqlParameter("ItemType",typeof(Int32)),
new SqlParameter("Quantity",typeof(Int32)),
new SqlParameter("Price", typeof(decimal)),
new SqlParameter("SubItem1Type",typeof(Int32)),
new SqlParameter("SubItem1Name",typeof(string)),
new SqlParameter("SubItem1Qty",typeof(Int32)),
new SqlParameter("SubItem1Price", typeof(decimal)),
new SqlParameter("SubItem2Type",typeof(Int32)),
new SqlParameter("SubItem2Name",typeof(string)),
new SqlParameter("SubItem2Qty",typeof(Int32)),
new SqlParameter("SubItem2Price", typeof(decimal)),
new SqlParameter("Yardage", typeof(decimal)),
new SqlParameter("TailorID",typeof(Int32)),
new SqlParameter("Color",typeof(string)),
new SqlParameter("Pattern",typeof(string)),
new SqlParameter("Category",typeof(string)),
new SqlParameter("FabricWidth",typeof(Int32)),
new SqlParameter("IncludeSlackHalfLining",typeof(bool)),
new SqlParameter("IncludeSlackFullLining",typeof(bool)),
new SqlParameter("IncludeRBHole",typeof(bool)),
new SqlParameter("IncludeHSEdges",typeof(bool)),
new SqlParameter("IncludeMono",typeof(bool)),
new SqlParameter("IncludePB",typeof(bool)),
new SqlParameter("IncludeWCC",typeof(bool)),
new SqlParameter("IncludeWC",typeof(bool)),
new SqlParameter("IncludeSS",typeof(bool)),
new SqlParameter("IncludeFT",typeof(bool))
};
param[0].Value = orderID;
param[1].Value = itm.Sequence;
param[2].Value = itm.MaterialName;
param[3].Value = itm.MaterialDescription;
param[4].Value = Convert.ToInt32(itm.ItemDescription.OrderItemType);
param[5].Value = itm.ItemDescription.OrderItemQuantity;
param[6].Value = itm.UnitPrice;
param[7].Value = Convert.ToInt32(itm.SubItem1Type);
param[8].Value = itm.SubItem1;
param[9].Value = Convert.ToInt32(itm.SubItem1Qty);
param[10].Value = Convert.ToDecimal(itm.SubItem1Price);
param[11].Value = Convert.ToInt32(itm.SubItem2Type);
param[12].Value = itm.SubItem2;
param[13].Value = Convert.ToInt32(itm.SubItem2Qty);
param[14].Value = Convert.ToDecimal(itm.SubItem2Price);
param[15].Value = Convert.ToDecimal(itm.Yardage);
param[16].Value = itm.AssignedTailor.TailorID;
param[17].Value = itm.MaterialColor.ColorID;
param[18].Value = itm.MaterialPattern.PatternID;
param[19].Value = itm.MaterialCategory.CategoryID;
param[20].Value = Convert.ToInt32(itm.FabricWidth);
param[21].Value = Convert.ToBoolean(itm.IncludeSlackHalfLining);
param[22].Value = Convert.ToBoolean(itm.IncludeSlackFullLining);
param[23].Value = Convert.ToBoolean(itm.IncludeRBHole);
param[24].Value = Convert.ToBoolean(itm.IncludeHSEdges);
param[25].Value = Convert.ToBoolean(itm.IncludeMono);
param[26].Value = Convert.ToBoolean(itm.IncludePB);
param[27].Value = Convert.ToBoolean(itm.IncludeWCC);
param[28].Value = Convert.ToBoolean(itm.IncludeWC);
param[29].Value = Convert.ToBoolean(itm.IncludeSS);
param[30].Value = Convert.ToBoolean(itm.IncludeFT);
return param;
}
