public static bool UpdateOrderFinishedSizes(Guid orderID, OrderFinishedSize itm, ref SQLWrapper sw) { bool returnValue = false; SqlParameter[] param = { new SqlParameter("OrderID",typeof(Guid)) }; param[0].Value = orderID; sw.ExecuteStoredProcedureInTransaction("ORD_DeleteOrderFinishedSizes", param); if (itm.OrderFSJacketSize != null) { for (int i = 0; i <= itm.OrderFSJacketSize.Count - 1; i++) { param = prepareParams(orderID, 4, itm.OrderFSJacketSize[i]); sw.ExecuteStoredProcedureInTransaction("ORD_AddOrderSize", param); } } if (itm.OrderFSSlackVestTopCoatSize != null) { for (int i = 0; i <= itm.OrderFSSlackVestTopCoatSize.Count - 1; i++) { param = prepareParams(orderID, 5, itm.OrderFSSlackVestTopCoatSize[i]); sw.ExecuteStoredProcedureInTransaction("ORD_AddOrderSize", param); } } if (itm.OrderFSShirtSize != null) { for (int i = 0; i <= itm.OrderFSShirtSize.Count - 1; i++) { param = prepareParams(orderID, 6, itm.OrderFSShirtSize[i]); sw.ExecuteStoredProcedureInTransaction("ORD_AddOrderSize", param); } } return returnValue; }
public static bool UpdateOrderFinishedSizes(Guid orderID, OrderFinishedSize itm) { bool returnValue = false; SQLWrapper sw = new SQLWrapper(); sw.BeginTransaction(); try { UpdateOrderFinishedSizes(orderID, itm, ref sw); sw.CommitTransaction(); returnValue = true; } catch { sw.RollBackTransaction(); } finally { sw = null; } return returnValue; }
private static OrderFinishedSize loadOrderFinishedSize(DataTable dtFS) { OrderFinishedSize fs = new OrderFinishedSize(); fs.OrderFSJacketSize = getOrderSizes(dtFS, Convert.ToInt32(TypeOfSizes.OrderFinishedJacketSize)); fs.OrderFSShirtSize = getOrderSizes(dtFS, Convert.ToInt32(TypeOfSizes.OrderFinishedShirtSize)); fs.OrderFSSlackVestTopCoatSize = getOrderSizes(dtFS, Convert.ToInt32(TypeOfSizes.OrderFinishedSlackVestTopCoatSize)); return fs; }