private static SqlParameter[] prepareParams(Guid orderID, int typeOfSize, OrderSizeItem itm)
{
SqlParameter[] param =
{
new SqlParameter("OrderID",typeof(Guid)),
new SqlParameter("TypeOfSize",typeof(Int32)),
new SqlParameter("Caption",typeof(string)),
new SqlParameter("Value",typeof(string)),
new SqlParameter("Sequence",typeof(Int32))
};
param[0].Value = orderID;
param[1].Value = typeOfSize;
param[2].Value = itm.Caption;
param[3].Value = itm.Value;
param[4].Value = itm.Sequence;
return param;
}
private static List<OrderSizeItem> getOrderSizes(DataTable dtFS, int sizeType)
{
List<OrderSizeItem> sizeItem = new List<OrderSizeItem>();
DataView dv = dtFS.DefaultView;
dv.RowFilter = "TypeOfSize = " + sizeType.ToString();
dv.Sort = "Sequence";
for (int i = 0; i <= dv.Count - 1; i++)
{
OrderSizeItem itm = new OrderSizeItem();
itm.Sequence = Convert.ToInt32(dv[i]["Sequence"]);
itm.Caption = dv[i]["Caption"].ToString();
itm.Value = dv[i]["Value"].ToString();
sizeItem.Add(itm);
itm = null;
}
return sizeItem;
}
