public HostOrderDetail(string InOrderID, int InOrderLine) { using (WMSEntities wms = new WMSEntities()) { var data = from HOD in wms.HOST_ORDER_DETAIL where HOD.EIS_ORDER_ID == InOrderID && HOD.EIS_ORDER_LINE == InOrderLine select HOD; foreach (var Detail in data) { EISOrderID = Detail.EIS_ORDER_ID; EISOrderLine = Detail.EIS_ORDER_LINE; Type = Detail.TYPE; ProductID = Detail.PRODUCT_ID; QCCategory = Detail.QC_CATEGORY; OrderedUnits = Detail.ORDERED_UNITS; UnitOfMesure = Detail.UOM; ScheduledDate = Detail.SCHEDULED_DATE; Notes = Detail.NOTES; EISOrderLinePrice = Detail.EIS_ORDLINE_PRICE; EISUnitPrice = Detail.EIS_UNIT_PRICE; LastUpdated = Detail.C_LAST_UPDATED_; LastUser = Detail.C_LAST_USER_; LastModule = LastModule; } } }
public void AddToDatabase() { var wms = new WMSEntities(); var HO = new HOST_ORDERS() { EIS_ORDER_ID = EisOrderId, STATUS = status, TYPE = Type, ORDER_DATE = OrderDate, CUSTOMER_ID = CustomerID, NAME = Name, ADDRESS_1 = Address1, ADDRESS_2 = Address2, ADDRESS_3 = Address3, CITY = City, STATE = State, ZIP = Zip, PHONE = Phone, PURCHASE_ORDER = PurchasOrder, ORIGINAL_SHIP_MODE = OrigionalShipMode, TERMS = Terms, COD_INDICATOR = CODIndicator, EST_NUM_BOXES = EstNumBoxes, CARRIER_ID = CarrierID, FREIGHT = Freight, DEPOSIT_AMOUNT = DepositAmount, FREIGHT_BILLING_OPTION = FreightBIllingOptions, EXPEDITE_IND = ExpediteIndicator, NOTES = Notes, IMPORT_TIME = ImportTime, FREIGHT_BILL_TO_ACCOUNT = FreightBillToAccount, FREIGHT_BILL_TO_NAME = FreightBillToName, FREIGHT_BILL_TO_ADDRESS_1 = FreightBillToAddress1, FREIGHT_BILL_TO_ADDRESS_2 = FreightBillToAddress2, FREIGHT_BILL_TO_ADDRESS_3 = FreightBillToAddress3, FREIGHT_BILL_TO_CITY = FreightBillToCity, FREIGHT_BILL_TO_STATE = FreightBillToState, FREIGHT_BILL_TO_ZIP = FreightBillToZip, C_LAST_UPDATED_ = LastUpdated, C_LAST_USER_ = LastUser, C_LAST_MODULE_ = LastModule, QC_CODES = QcCodes, DELIVER_BY_DATE = DeliverByDate, QC_REQUIRED = QcRequired, EXTERNAL_CARTONIZED = ExternalCartonized, FIRSTBOXSHIPPED = FirstBoxShipped }; wms.HOST_ORDERS.Add(HO); wms.SaveChanges(); }
public HostOrder(string InEISOrderID) { using (WMSEntities wms = new WMSEntities()) { var data = from HO in wms.HOST_ORDERS where HO.EIS_ORDER_ID == InEISOrderID select HO; foreach (var Order in data) { EisOrderId = Order.EIS_ORDER_ID; status = Order.STATUS; Type = Order.TYPE; OrderDate = Order.ORDER_DATE; CustomerID = Order.CUSTOMER_ID; Name = Order.NAME; Address1 = Order.ADDRESS_1; Address2 = Order.ADDRESS_2; Address3 = Order.ADDRESS_3; City = Order.CITY; State = Order.STATE; Zip = Order.ZIP; Phone = Order.PHONE; PurchasOrder = Order.PURCHASE_ORDER; OrigionalShipMode = Order.ORIGINAL_SHIP_MODE; Terms = Order.TERMS; CODIndicator = Order.COD_INDICATOR; EstNumBoxes = Order.EST_NUM_BOXES; CarrierID = Order.CARRIER_ID; Freight = Order.FREIGHT; DepositAmount = Order.DEPOSIT_AMOUNT; FreightBIllingOptions = Order.FREIGHT_BILLING_OPTION; ExpediteIndicator = Order.EXPEDITE_IND; Notes = Order.NOTES; ImportTime = Order.IMPORT_TIME; FreightBillToAccount = Order.FREIGHT_BILL_TO_ACCOUNT; FreightBillToAddress1 = Order.FREIGHT_BILL_TO_ADDRESS_1; FreightBillToAddress2 = Order.FREIGHT_BILL_TO_ADDRESS_2; FreightBillToAddress3 = Order.FREIGHT_BILL_TO_ADDRESS_3; FreightBillToCity = Order.FREIGHT_BILL_TO_CITY; FreightBillToName = Order.FREIGHT_BILL_TO_NAME; FreightBillToState = Order.FREIGHT_BILL_TO_STATE; FreightBillToZip = Order.FREIGHT_BILL_TO_ZIP; LastUpdated = Order.C_LAST_UPDATED_; LastUser = Order.C_LAST_USER_; LastModule = Order.C_LAST_MODULE_; QcCodes = Order.QC_CODES; DeliverByDate = Order.DELIVER_BY_DATE; QcRequired = Order.QC_REQUIRED; ExternalCartonized = Order.EXTERNAL_CARTONIZED; FirstBoxShipped = Order.FIRSTBOXSHIPPED; } } }
internal void UpdateLastUpdates() { { LastUpdated = DateTime.Now; using (WMSEntities wms = new WMSEntities()) { IQueryable <HOST_ORDERS> Data = from HO in wms.HOST_ORDERS where HO.EIS_ORDER_ID == EisOrderId select HO; foreach (HOST_ORDERS HOData in Data) { HOData.C_LAST_UPDATED_ = LastUpdated; } wms.SaveChanges(); } } }
internal void UpdateLastUser(string Value) { if (LastUser != Value) { LastUser = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <HOST_ORDERS> Data = from HO in wms.HOST_ORDERS where HO.EIS_ORDER_ID == EisOrderId select HO; foreach (HOST_ORDERS HOData in Data) { HOData.C_LAST_USER_ = Value; } wms.SaveChanges(); } } }
internal void UpdateStatus(string Value) { if (status != Value) { status = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <HOST_ORDERS> Data = from HO in wms.HOST_ORDERS where HO.EIS_ORDER_ID == EisOrderId select HO; foreach (HOST_ORDERS HOData in Data) { HOData.STATUS = Value; } wms.SaveChanges(); } } }
public void AddToDatabase() { var wms = new WMSEntities(); var HOD = new HOST_ORDER_DETAIL { EIS_ORDER_ID = EISOrderID, EIS_ORDER_LINE = EISOrderLine, TYPE = Type, PRODUCT_ID = ProductID, QC_CATEGORY = QCCategory, ORDERED_UNITS = OrderedUnits, UOM = UnitOfMesure, SCHEDULED_DATE = ScheduledDate, NOTES = Notes, EIS_ORDLINE_PRICE = EISOrderLinePrice, EIS_UNIT_PRICE = EISUnitPrice, C_LAST_UPDATED_ = LastUpdated, C_LAST_USER_ = LastUser, C_LAST_MODULE_ = LastModule }; wms.HOST_ORDER_DETAIL.Add(HOD); wms.SaveChanges(); }