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 DeleteOrder(OrderHeader orderID) { bool returnValue = false; SQLWrapper sw = new SQLWrapper(); sw.BeginTransaction(); try { SqlParameter[] param = { new SqlParameter("OrderID",typeof(Guid)) }; param[0].Value = orderID; sw.ExecuteStoredProcedureInTransaction("ORD_DeleteOrder", param); sw.CommitTransaction(); returnValue = true; } catch { sw.RollBackTransaction(); } finally { sw = null; } return returnValue; }
public static bool AddOrder(OrderHeader order) { bool returnValue = false; SqlParameter[] param; SQLWrapper sw = new SQLWrapper(); sw.BeginTransaction(); try { param = prepareSQLParameters(order, true); sw.ExecuteStoredProcedureInTransaction("ORD_AddOrderHeader", param); order.OrderID = (Guid)param[0].Value; addUpdateChildTablesForOrder(order, ref sw); sw.CommitTransaction(); returnValue = true; } catch { sw.RollBackTransaction(); } finally { sw = null; } return returnValue; }
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; }
public static bool DeleteRestOfTheOrderPayments(Guid orderID, string otherThanSequenceNumbers, ref SQLWrapper sw) { SqlParameter[] param = { new SqlParameter("OrderID",typeof(Guid )), new SqlParameter("Sequences",typeof(string )), }; param[0].Value = orderID; param[1].Value = otherThanSequenceNumbers; return sw.ExecuteStoredProcedureInTransaction("ORD_DeleteOrderPayments", param); }
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; }
public static bool AddUpdateOrderPayment(Guid orderID, IOrderPaymentItem paymentItem,ref SQLWrapper sw) { SqlParameter[] param = prepareParameters(orderID,paymentItem); return sw.ExecuteStoredProcedureInTransaction("ORD_AddUpdateOrderPayment", param); }
private static void addUpdateChildTablesForOrder(OrderHeader order, ref SQLWrapper sw) { string sequences = ""; // payments if (order.Payments != null) { if (order.Payments.PaymentDetails != null) { for (int i = 0; i <= order.Payments.PaymentDetails.Count - 1; i++) { if (!sequences.Trim().Equals("")) { sequences += ","; } sequences += order.Payments.PaymentDetails[i].Sequence.ToString(); PaymentsDAL.AddUpdateOrderPayment(order.OrderID, order.Payments.PaymentDetails[i], ref sw); } } } PaymentsDAL.DeleteRestOfTheOrderPayments(order.OrderID, sequences, ref sw); sequences = ""; // finished sizes if (order.FinishedSize != null) { OrderSizeDAL.UpdateOrderFinishedSizes(order.OrderID, order.FinishedSize, ref sw); } // measurement sizes if (order.MeasurementDetails != null) { OrderSizeDAL.UpdateOrderMeasurementSizes(order.OrderID, order.MeasurementDetails, ref sw); } // material details if (order.OrderMaterials != null) { sequences = ""; for (int i = 0; i <= order.OrderMaterials.Count; i++) { if (!sequences.Trim().Equals("")) { sequences += ","; } sequences += order.OrderMaterials[i].Sequence.ToString(); OrderMaterialsDAL.AddOrderMaterial(order.OrderID, order.OrderMaterials[i], ref sw); } } OrderMaterialsDAL.DeleteRestOfTheOrderMaterials(order.OrderID, sequences, ref sw); }