public static OrderDtlData Load(StringType orderDetailId) { WhereClause w = new WhereClause(); w.And("Order_Detail_Id", orderDetailId.DBValue); SqlDataReader dataReader = GetListReader(DatabaseEnum.ORDERDB, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for OrderDtl."); } OrderDtlData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
public static void Update(OrderDtlData data) { // Create and execute the command OrderDtlData oldData = Load(data.OrderDetailId); string sql = "Update " + TABLE + " set "; if (!oldData.OrderDetailId.Equals(data.OrderDetailId)) { sql = sql + "Order_Detail_Id=@Order_Detail_Id,"; } if (!oldData.OrderNo.Equals(data.OrderNo)) { sql = sql + "Orderno=@Orderno,"; } if (!oldData.TypeOrd.Equals(data.TypeOrd)) { sql = sql + "Type_Ord=@Type_Ord,"; } if (!oldData.ItemId.Equals(data.ItemId)) { sql = sql + "Item_Id=@Item_Id,"; } if (!oldData.ItemDescrip.Equals(data.ItemDescrip)) { sql = sql + "Item_Descrip=@Item_Descrip,"; } if (!oldData.BinNo.Equals(data.BinNo)) { sql = sql + "Bin_No=@Bin_No,"; } if (!oldData.QtyOrdered.Equals(data.QtyOrdered)) { sql = sql + "Qty_Ordered=@Qty_Ordered,"; } if (!oldData.QtyPicked.Equals(data.QtyPicked)) { sql = sql + "Qty_Picked=@Qty_Picked,"; } if (!oldData.QtyShipped.Equals(data.QtyShipped)) { sql = sql + "Qty_Shipped=@Qty_Shipped,"; } if (!oldData.ShippingNo.Equals(data.ShippingNo)) { sql = sql + "Shipping_No=@Shipping_No,"; } if (!oldData.ItemPrice.Equals(data.ItemPrice)) { sql = sql + "Item_Price=@Item_Price,"; } if (!oldData.Subtotal.Equals(data.Subtotal)) { sql = sql + "Subtotal=@Subtotal,"; } if (!oldData.Personal.Equals(data.Personal)) { sql = sql + "Personal=@Personal,"; } if (!oldData.TaxExempt.Equals(data.TaxExempt)) { sql = sql + "Tax_Exempt=@Tax_Exempt,"; } if (!oldData.TaxExemptNo.Equals(data.TaxExemptNo)) { sql = sql + "Tax_Exempt_No=@Tax_Exempt_No,"; } if (!oldData.ShipDate.Equals(data.ShipDate)) { sql = sql + "Ship_Date=@Ship_Date,"; } if (!oldData.Kit.Equals(data.Kit)) { sql = sql + "Kit=@Kit,"; } if (!oldData.GuestIdOld.Equals(data.GuestIdOld)) { sql = sql + "Guest_Id_Old=@Guest_Id_Old,"; } if (!oldData.ComponentId.Equals(data.ComponentId)) { sql = sql + "Component_Id=@Component_Id,"; } if (!oldData.GuestId.Equals(data.GuestId)) { sql = sql + "Guest_Id=@Guest_Id,"; } if (!oldData.Xxxsave.Equals(data.Xxxsave)) { sql = sql + "Xxxsave=@Xxxsave,"; } if (!oldData.StartkitCategory.Equals(data.StartkitCategory)) { sql = sql + "Startkit_Category=@Startkit_Category,"; } if (!oldData.GLPostedDate.Equals(data.GLPostedDate)) { sql = sql + "GLPostedDate=@GLPostedDate,"; } if (!oldData.Revenue.Equals(data.Revenue)) { sql = sql + "Revenue=@Revenue,"; } if (!oldData.DiscountAmount.Equals(data.DiscountAmount)) { sql = sql + "DiscountAmount=@DiscountAmount,"; } if (!oldData.QtyCanceled.Equals(data.QtyCanceled)) { sql = sql + "QtyCanceled=@QtyCanceled,"; } if (!oldData.CanceledDate.Equals(data.CanceledDate)) { sql = sql + "CanceledDate=@CanceledDate,"; } if (!oldData.ChargeForItem.Equals(data.ChargeForItem)) { sql = sql + "ChargeForItem=@ChargeForItem,"; } if (!oldData.ErrorCode.Equals(data.ErrorCode)) { sql = sql + "ErrorCode=@ErrorCode,"; } if (!oldData.ErrorDepartment.Equals(data.ErrorDepartment)) { sql = sql + "ErrorDepartment=@ErrorDepartment,"; } if (!oldData.WaitReturnBeginDate.Equals(data.WaitReturnBeginDate)) { sql = sql + "WaitReturnBeginDate=@WaitReturnBeginDate,"; } if (!oldData.WaitReturnDueDate.Equals(data.WaitReturnDueDate)) { sql = sql + "WaitReturnDueDate=@WaitReturnDueDate,"; } if (!oldData.WaitReturnReceivedDate.Equals(data.WaitReturnReceivedDate)) { sql = sql + "WaitReturnReceivedDate=@WaitReturnReceivedDate,"; } if (!oldData.ItemNotes.Equals(data.ItemNotes)) { sql = sql + "ItemNotes=@ItemNotes,"; } if (!oldData.SaveAsShipped.Equals(data.SaveAsShipped)) { sql = sql + "SaveAsShipped=@SaveAsShipped,"; } if (!oldData.PurchasedDate.Equals(data.PurchasedDate)) { sql = sql + "PurchasedDate=@PurchasedDate,"; } WhereClause w = new WhereClause(); w.And("Order_Detail_Id", data.OrderDetailId.DBValue); sql = sql.Substring(0, sql.Length - 1) + w.FormatSql(); SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object if (!oldData.OrderDetailId.Equals(data.OrderDetailId)) { cmd.Parameters.Add(new SqlParameter("@Order_Detail_Id", SqlDbType.VarChar, 11, ParameterDirection.Input, false, 0, 0, "OrderDetailId", DataRowVersion.Proposed, data.OrderDetailId.DBValue)); } if (!oldData.OrderNo.Equals(data.OrderNo)) { cmd.Parameters.Add(new SqlParameter("@Orderno", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "OrderNo", DataRowVersion.Proposed, data.OrderNo.DBValue)); } if (!oldData.TypeOrd.Equals(data.TypeOrd)) { cmd.Parameters.Add(new SqlParameter("@Type_Ord", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "TypeOrd", DataRowVersion.Proposed, data.TypeOrd.DBValue)); } if (!oldData.ItemId.Equals(data.ItemId)) { cmd.Parameters.Add(new SqlParameter("@Item_Id", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "ItemId", DataRowVersion.Proposed, data.ItemId.DBValue)); } if (!oldData.ItemDescrip.Equals(data.ItemDescrip)) { cmd.Parameters.Add(new SqlParameter("@Item_Descrip", SqlDbType.VarChar, 60, ParameterDirection.Input, false, 0, 0, "ItemDescrip", DataRowVersion.Proposed, data.ItemDescrip.DBValue)); } if (!oldData.BinNo.Equals(data.BinNo)) { cmd.Parameters.Add(new SqlParameter("@Bin_No", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "BinNo", DataRowVersion.Proposed, data.BinNo.DBValue)); } if (!oldData.QtyOrdered.Equals(data.QtyOrdered)) { cmd.Parameters.Add(new SqlParameter("@Qty_Ordered", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyOrdered", DataRowVersion.Proposed, data.QtyOrdered.DBValue)); } if (!oldData.QtyPicked.Equals(data.QtyPicked)) { cmd.Parameters.Add(new SqlParameter("@Qty_Picked", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyPicked", DataRowVersion.Proposed, data.QtyPicked.DBValue)); } if (!oldData.QtyShipped.Equals(data.QtyShipped)) { cmd.Parameters.Add(new SqlParameter("@Qty_Shipped", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyShipped", DataRowVersion.Proposed, data.QtyShipped.DBValue)); } if (!oldData.ShippingNo.Equals(data.ShippingNo)) { cmd.Parameters.Add(new SqlParameter("@Shipping_No", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ShippingNo", DataRowVersion.Proposed, data.ShippingNo.DBValue)); } if (!oldData.ItemPrice.Equals(data.ItemPrice)) { cmd.Parameters.Add(new SqlParameter("@Item_Price", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ItemPrice", DataRowVersion.Proposed, data.ItemPrice.DBValue)); } if (!oldData.Subtotal.Equals(data.Subtotal)) { cmd.Parameters.Add(new SqlParameter("@Subtotal", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "Subtotal", DataRowVersion.Proposed, data.Subtotal.DBValue)); } if (!oldData.Personal.Equals(data.Personal)) { cmd.Parameters.Add(new SqlParameter("@Personal", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Personal", DataRowVersion.Proposed, !data.Personal.IsValid ? data.Personal.DBValue : data.Personal.DBValue.Equals("Y") ? 1 : 0)); } if (!oldData.TaxExempt.Equals(data.TaxExempt)) { cmd.Parameters.Add(new SqlParameter("@Tax_Exempt", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "TaxExempt", DataRowVersion.Proposed, !data.TaxExempt.IsValid ? data.TaxExempt.DBValue : data.TaxExempt.DBValue.Equals("Y") ? 1 : 0)); } if (!oldData.TaxExemptNo.Equals(data.TaxExemptNo)) { cmd.Parameters.Add(new SqlParameter("@Tax_Exempt_No", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "TaxExemptNo", DataRowVersion.Proposed, data.TaxExemptNo.DBValue)); } if (!oldData.ShipDate.Equals(data.ShipDate)) { cmd.Parameters.Add(new SqlParameter("@Ship_Date", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "ShipDate", DataRowVersion.Proposed, data.ShipDate.DBValue)); } if (!oldData.Kit.Equals(data.Kit)) { cmd.Parameters.Add(new SqlParameter("@Kit", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Kit", DataRowVersion.Proposed, data.Kit.DBValue)); } if (!oldData.GuestIdOld.Equals(data.GuestIdOld)) { cmd.Parameters.Add(new SqlParameter("@Guest_Id_Old", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GuestIdOld", DataRowVersion.Proposed, data.GuestIdOld.DBValue)); } if (!oldData.ComponentId.Equals(data.ComponentId)) { cmd.Parameters.Add(new SqlParameter("@Component_Id", SqlDbType.Char, 11, ParameterDirection.Input, false, 0, 0, "ComponentId", DataRowVersion.Proposed, data.ComponentId.DBValue)); } if (!oldData.GuestId.Equals(data.GuestId)) { cmd.Parameters.Add(new SqlParameter("@Guest_Id", SqlDbType.VarChar, 7, ParameterDirection.Input, false, 0, 0, "GuestId", DataRowVersion.Proposed, data.GuestId.DBValue)); } if (!oldData.Xxxsave.Equals(data.Xxxsave)) { cmd.Parameters.Add(new SqlParameter("@Xxxsave", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Xxxsave", DataRowVersion.Proposed, data.Xxxsave.DBValue)); } if (!oldData.StartkitCategory.Equals(data.StartkitCategory)) { cmd.Parameters.Add(new SqlParameter("@Startkit_Category", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "StartkitCategory", DataRowVersion.Proposed, data.StartkitCategory.DBValue)); } if (!oldData.GLPostedDate.Equals(data.GLPostedDate)) { cmd.Parameters.Add(new SqlParameter("@GLPostedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "GLPostedDate", DataRowVersion.Proposed, data.GLPostedDate.DBValue)); } if (!oldData.Revenue.Equals(data.Revenue)) { cmd.Parameters.Add(new SqlParameter("@Revenue", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "Revenue", DataRowVersion.Proposed, data.Revenue.DBValue)); } if (!oldData.DiscountAmount.Equals(data.DiscountAmount)) { cmd.Parameters.Add(new SqlParameter("@DiscountAmount", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "DiscountAmount", DataRowVersion.Proposed, data.DiscountAmount.DBValue)); } if (!oldData.QtyCanceled.Equals(data.QtyCanceled)) { cmd.Parameters.Add(new SqlParameter("@QtyCanceled", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyCanceled", DataRowVersion.Proposed, data.QtyCanceled.DBValue)); } if (!oldData.CanceledDate.Equals(data.CanceledDate)) { cmd.Parameters.Add(new SqlParameter("@CanceledDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CanceledDate", DataRowVersion.Proposed, data.CanceledDate.DBValue)); } if (!oldData.ChargeForItem.Equals(data.ChargeForItem)) { cmd.Parameters.Add(new SqlParameter("@ChargeForItem", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ChargeForItem", DataRowVersion.Proposed, !data.ChargeForItem.IsValid ? data.ChargeForItem.DBValue : data.ChargeForItem.DBValue.Equals("Y") ? 1 : 0)); } if (!oldData.ErrorCode.Equals(data.ErrorCode)) { cmd.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "ErrorCode", DataRowVersion.Proposed, data.ErrorCode.DBValue)); } if (!oldData.ErrorDepartment.Equals(data.ErrorDepartment)) { cmd.Parameters.Add(new SqlParameter("@ErrorDepartment", SqlDbType.VarChar, 3, ParameterDirection.Input, false, 0, 0, "ErrorDepartment", DataRowVersion.Proposed, data.ErrorDepartment.DBValue)); } if (!oldData.WaitReturnBeginDate.Equals(data.WaitReturnBeginDate)) { cmd.Parameters.Add(new SqlParameter("@WaitReturnBeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnBeginDate", DataRowVersion.Proposed, data.WaitReturnBeginDate.DBValue)); } if (!oldData.WaitReturnDueDate.Equals(data.WaitReturnDueDate)) { cmd.Parameters.Add(new SqlParameter("@WaitReturnDueDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnDueDate", DataRowVersion.Proposed, data.WaitReturnDueDate.DBValue)); } if (!oldData.WaitReturnReceivedDate.Equals(data.WaitReturnReceivedDate)) { cmd.Parameters.Add(new SqlParameter("@WaitReturnReceivedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnReceivedDate", DataRowVersion.Proposed, data.WaitReturnReceivedDate.DBValue)); } if (!oldData.ItemNotes.Equals(data.ItemNotes)) { cmd.Parameters.Add(new SqlParameter("@ItemNotes", SqlDbType.VarChar, 8000, ParameterDirection.Input, false, 0, 0, "ItemNotes", DataRowVersion.Proposed, data.ItemNotes.DBValue)); } if (!oldData.SaveAsShipped.Equals(data.SaveAsShipped)) { cmd.Parameters.Add(new SqlParameter("@SaveAsShipped", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "SaveAsShipped", DataRowVersion.Proposed, !data.SaveAsShipped.IsValid ? data.SaveAsShipped.DBValue : data.SaveAsShipped.DBValue.Equals("Y") ? 1 : 0)); } if (!oldData.PurchasedDate.Equals(data.PurchasedDate)) { cmd.Parameters.Add(new SqlParameter("@PurchasedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "PurchasedDate", DataRowVersion.Proposed, data.PurchasedDate.DBValue)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }
public static void Insert(OrderDtlData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "Order_Detail_Id," + "Orderno," + "Type_Ord," + "Item_Id," + "Item_Descrip," + "Bin_No," + "Qty_Ordered," + "Qty_Picked," + "Qty_Shipped," + "Shipping_No," + "Item_Price," + "Subtotal," + "Personal," + "Tax_Exempt," + "Tax_Exempt_No," + "Ship_Date," + "Kit," + "Guest_Id_Old," + "Component_Id," + "Guest_Id," + "Xxxsave," + "Startkit_Category," + "GLPostedDate," + "Revenue," + "DiscountAmount," + "QtyCanceled," + "CanceledDate," + "ChargeForItem," + "ErrorCode," + "ErrorDepartment," + "WaitReturnBeginDate," + "WaitReturnDueDate," + "WaitReturnReceivedDate," + "ItemNotes," + "SaveAsShipped," + "PurchasedDate," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@Order_Detail_Id," + "@Orderno," + "@Type_Ord," + "@Item_Id," + "@Item_Descrip," + "@Bin_No," + "@Qty_Ordered," + "@Qty_Picked," + "@Qty_Shipped," + "@Shipping_No," + "@Item_Price," + "@Subtotal," + "@Personal," + "@Tax_Exempt," + "@Tax_Exempt_No," + "@Ship_Date," + "@Kit," + "@Guest_Id_Old," + "@Component_Id," + "@Guest_Id," + "@Xxxsave," + "@Startkit_Category," + "@GLPostedDate," + "@Revenue," + "@DiscountAmount," + "@QtyCanceled," + "@CanceledDate," + "@ChargeForItem," + "@ErrorCode," + "@ErrorDepartment," + "@WaitReturnBeginDate," + "@WaitReturnDueDate," + "@WaitReturnReceivedDate," + "@ItemNotes," + "@SaveAsShipped," + "@PurchasedDate," ; sql = sql.Substring(0, sql.Length - 1) + ")"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object cmd.Parameters.Add(new SqlParameter("@Order_Detail_Id", SqlDbType.VarChar, 11, ParameterDirection.Input, false, 0, 0, "OrderDetailId", DataRowVersion.Proposed, data.OrderDetailId.DBValue)); cmd.Parameters.Add(new SqlParameter("@Orderno", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "OrderNo", DataRowVersion.Proposed, data.OrderNo.DBValue)); cmd.Parameters.Add(new SqlParameter("@Type_Ord", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "TypeOrd", DataRowVersion.Proposed, data.TypeOrd.DBValue)); cmd.Parameters.Add(new SqlParameter("@Item_Id", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "ItemId", DataRowVersion.Proposed, data.ItemId.DBValue)); cmd.Parameters.Add(new SqlParameter("@Item_Descrip", SqlDbType.VarChar, 60, ParameterDirection.Input, false, 0, 0, "ItemDescrip", DataRowVersion.Proposed, data.ItemDescrip.DBValue)); cmd.Parameters.Add(new SqlParameter("@Bin_No", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "BinNo", DataRowVersion.Proposed, data.BinNo.DBValue)); cmd.Parameters.Add(new SqlParameter("@Qty_Ordered", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyOrdered", DataRowVersion.Proposed, data.QtyOrdered.DBValue)); cmd.Parameters.Add(new SqlParameter("@Qty_Picked", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyPicked", DataRowVersion.Proposed, data.QtyPicked.DBValue)); cmd.Parameters.Add(new SqlParameter("@Qty_Shipped", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyShipped", DataRowVersion.Proposed, data.QtyShipped.DBValue)); cmd.Parameters.Add(new SqlParameter("@Shipping_No", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ShippingNo", DataRowVersion.Proposed, data.ShippingNo.DBValue)); cmd.Parameters.Add(new SqlParameter("@Item_Price", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ItemPrice", DataRowVersion.Proposed, data.ItemPrice.DBValue)); cmd.Parameters.Add(new SqlParameter("@Subtotal", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "Subtotal", DataRowVersion.Proposed, data.Subtotal.DBValue)); cmd.Parameters.Add(new SqlParameter("@Personal", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Personal", DataRowVersion.Proposed, !data.Personal.IsValid ? data.Personal.DBValue : data.Personal.DBValue.Equals("Y") ? 1 : 0)); cmd.Parameters.Add(new SqlParameter("@Tax_Exempt", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "TaxExempt", DataRowVersion.Proposed, !data.TaxExempt.IsValid ? data.TaxExempt.DBValue : data.TaxExempt.DBValue.Equals("Y") ? 1 : 0)); cmd.Parameters.Add(new SqlParameter("@Tax_Exempt_No", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "TaxExemptNo", DataRowVersion.Proposed, data.TaxExemptNo.DBValue)); cmd.Parameters.Add(new SqlParameter("@Ship_Date", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "ShipDate", DataRowVersion.Proposed, data.ShipDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@Kit", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Kit", DataRowVersion.Proposed, data.Kit.DBValue)); cmd.Parameters.Add(new SqlParameter("@Guest_Id_Old", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GuestIdOld", DataRowVersion.Proposed, data.GuestIdOld.DBValue)); cmd.Parameters.Add(new SqlParameter("@Component_Id", SqlDbType.Char, 11, ParameterDirection.Input, false, 0, 0, "ComponentId", DataRowVersion.Proposed, data.ComponentId.DBValue)); cmd.Parameters.Add(new SqlParameter("@Guest_Id", SqlDbType.VarChar, 7, ParameterDirection.Input, false, 0, 0, "GuestId", DataRowVersion.Proposed, data.GuestId.DBValue)); cmd.Parameters.Add(new SqlParameter("@Xxxsave", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Xxxsave", DataRowVersion.Proposed, data.Xxxsave.DBValue)); cmd.Parameters.Add(new SqlParameter("@Startkit_Category", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "StartkitCategory", DataRowVersion.Proposed, data.StartkitCategory.DBValue)); cmd.Parameters.Add(new SqlParameter("@GLPostedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "GLPostedDate", DataRowVersion.Proposed, data.GLPostedDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@Revenue", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "Revenue", DataRowVersion.Proposed, data.Revenue.DBValue)); cmd.Parameters.Add(new SqlParameter("@DiscountAmount", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "DiscountAmount", DataRowVersion.Proposed, data.DiscountAmount.DBValue)); cmd.Parameters.Add(new SqlParameter("@QtyCanceled", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyCanceled", DataRowVersion.Proposed, data.QtyCanceled.DBValue)); cmd.Parameters.Add(new SqlParameter("@CanceledDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CanceledDate", DataRowVersion.Proposed, data.CanceledDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@ChargeForItem", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ChargeForItem", DataRowVersion.Proposed, !data.ChargeForItem.IsValid ? data.ChargeForItem.DBValue : data.ChargeForItem.DBValue.Equals("Y") ? 1 : 0)); cmd.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "ErrorCode", DataRowVersion.Proposed, data.ErrorCode.DBValue)); cmd.Parameters.Add(new SqlParameter("@ErrorDepartment", SqlDbType.VarChar, 3, ParameterDirection.Input, false, 0, 0, "ErrorDepartment", DataRowVersion.Proposed, data.ErrorDepartment.DBValue)); cmd.Parameters.Add(new SqlParameter("@WaitReturnBeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnBeginDate", DataRowVersion.Proposed, data.WaitReturnBeginDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@WaitReturnDueDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnDueDate", DataRowVersion.Proposed, data.WaitReturnDueDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@WaitReturnReceivedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnReceivedDate", DataRowVersion.Proposed, data.WaitReturnReceivedDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@ItemNotes", SqlDbType.VarChar, 8000, ParameterDirection.Input, false, 0, 0, "ItemNotes", DataRowVersion.Proposed, data.ItemNotes.DBValue)); cmd.Parameters.Add(new SqlParameter("@SaveAsShipped", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "SaveAsShipped", DataRowVersion.Proposed, !data.SaveAsShipped.IsValid ? data.SaveAsShipped.DBValue : data.SaveAsShipped.DBValue.Equals("Y") ? 1 : 0)); cmd.Parameters.Add(new SqlParameter("@PurchasedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "PurchasedDate", DataRowVersion.Proposed, data.PurchasedDate.DBValue)); // Execute the query cmd.ExecuteNonQuery(); }
private static OrderDtlData GetDataObjectFromReader(SqlDataReader dataReader) { OrderDtlData data = new OrderDtlData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("Order_Detail_Id"))) { data.OrderDetailId = StringType.UNSET; } else { data.OrderDetailId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Order_Detail_Id"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Orderno"))) { data.OrderNo = StringType.UNSET; } else { data.OrderNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Orderno"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Type_Ord"))) { data.TypeOrd = StringType.UNSET; } else { data.TypeOrd = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Type_Ord"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Id"))) { data.ItemId = StringType.UNSET; } else { data.ItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Item_Id"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Descrip"))) { data.ItemDescrip = StringType.UNSET; } else { data.ItemDescrip = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Item_Descrip"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Bin_No"))) { data.BinNo = StringType.UNSET; } else { data.BinNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Bin_No"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Ordered"))) { data.QtyOrdered = IntegerType.UNSET; } else { data.QtyOrdered = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Ordered"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Picked"))) { data.QtyPicked = IntegerType.UNSET; } else { data.QtyPicked = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Picked"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Shipped"))) { data.QtyShipped = IntegerType.UNSET; } else { data.QtyShipped = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Shipped"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Shipping_No"))) { data.ShippingNo = DecimalType.UNSET; } else { data.ShippingNo = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Shipping_No"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Price"))) { data.ItemPrice = DecimalType.UNSET; } else { data.ItemPrice = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Item_Price"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Subtotal"))) { data.Subtotal = DecimalType.UNSET; } else { data.Subtotal = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Subtotal"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Personal"))) { data.Personal = BooleanType.UNSET; } else { data.Personal = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Personal"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Tax_Exempt"))) { data.TaxExempt = BooleanType.UNSET; } else { data.TaxExempt = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Tax_Exempt"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Tax_Exempt_No"))) { data.TaxExemptNo = StringType.UNSET; } else { data.TaxExemptNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Tax_Exempt_No"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Ship_Date"))) { data.ShipDate = DateType.UNSET; } else { data.ShipDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("Ship_Date"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Kit"))) { data.Kit = IntegerType.UNSET; } else { data.Kit = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Kit"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Guest_Id_Old"))) { data.GuestIdOld = IntegerType.UNSET; } else { data.GuestIdOld = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Guest_Id_Old"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Component_Id"))) { data.ComponentId = StringType.UNSET; } else { data.ComponentId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Component_Id"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Guest_Id"))) { data.GuestId = StringType.UNSET; } else { data.GuestId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Guest_Id"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Xxxsave"))) { data.Xxxsave = IntegerType.UNSET; } else { data.Xxxsave = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Xxxsave"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Startkit_Category"))) { data.StartkitCategory = IntegerType.UNSET; } else { data.StartkitCategory = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Startkit_Category"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("GLPostedDate"))) { data.GLPostedDate = DateType.UNSET; } else { data.GLPostedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("GLPostedDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Revenue"))) { data.Revenue = DecimalType.UNSET; } else { data.Revenue = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("Revenue"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("DiscountAmount"))) { data.DiscountAmount = DecimalType.UNSET; } else { data.DiscountAmount = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("DiscountAmount"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("QtyCanceled"))) { data.QtyCanceled = IntegerType.UNSET; } else { data.QtyCanceled = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("QtyCanceled"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("CanceledDate"))) { data.CanceledDate = DateType.UNSET; } else { data.CanceledDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CanceledDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ChargeForItem"))) { data.ChargeForItem = BooleanType.UNSET; } else { data.ChargeForItem = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("ChargeForItem"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ErrorCode"))) { data.ErrorCode = StringType.UNSET; } else { data.ErrorCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ErrorCode"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ErrorDepartment"))) { data.ErrorDepartment = StringType.UNSET; } else { data.ErrorDepartment = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ErrorDepartment"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnBeginDate"))) { data.WaitReturnBeginDate = DateType.UNSET; } else { data.WaitReturnBeginDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnBeginDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnDueDate"))) { data.WaitReturnDueDate = DateType.UNSET; } else { data.WaitReturnDueDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnDueDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnReceivedDate"))) { data.WaitReturnReceivedDate = DateType.UNSET; } else { data.WaitReturnReceivedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnReceivedDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ItemNotes"))) { data.ItemNotes = StringType.UNSET; } else { data.ItemNotes = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ItemNotes"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("SaveAsShipped"))) { data.SaveAsShipped = BooleanType.UNSET; } else { data.SaveAsShipped = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("SaveAsShipped"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("PurchasedDate"))) { data.PurchasedDate = DateType.UNSET; } else { data.PurchasedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("PurchasedDate"))); } return(data); }