internal void AddToDatabase() { var WMS = new WMSEntities(); var OBSD = new OUTBOUND_SHIPMENT_DETAILS() { SHIPMENT_ID = ShipmentID, ORDER_NUMBER = OrderNumber, ORDER_LINE = OrderLine, TYPE = Type, UOM = UnitOfMesure, QC_CATEGORY = QCCategory, SHIPPED_UNITS = ShippedUnits, C_LAST_UPDATED_ = LastUpdated, NOTES = Notes, C_LAST_USER_ = LastUser, C_LAST_MODULE_ = LastModule, PRODUCT_ID = ProductID, UOM_WEIGHT = UOMWeight, UNIT_PRICE_EA = UnitPriceEach, ORDERED_UNITS = OrderedUnits, STATUS = Status, ALLOCATION_STATUS = AllocationStatus, STAGED_UNITS = StagedUnits }; WMS.OUTBOUND_SHIPMENT_DETAILS.Add(OBSD); //Tim Uncomment WMS.SaveChanges(); PrintOutboundShipmentDetail(); }
private void AddToDataBase() { using (WMSEntities wms = new WMSEntities()) { var Outbound = new AUDIT_OUTBOUND { C_RID_ = RID, TRANTYPE = TranType, SUBTYPE = SubType, TRANSACTION_TIME = TransactionTime, APPOINTMENT_TIME = AppointmentTime, APPOINTMENT_TIME_OLD = AppointmentTimeOld, DOOR_ID = DoorID, DOOR_ID_OLD = DoorIDOld, MADE_TIME = MadeTime, MADE_TIME_OLD = MadeTimeOld, DURATION = duration, DURATION_OLD = durationOld, CARRIER_ID = CarrierID, CARRIER_ID_OLD = CarrierIdOld, SHIPMENT_ID = ShipmentID, SHIPMENT_ID_OLD = ShipmentIDOld, ARRIVAL_TIME = ArrivalTime, PICK_ASSIGNED_TIME = PickAssignedTime, PICK_COMPLETE_TIME = PickCompleateTIme, PICK_START_TIME = PickStartTIme, DEPARTURE_TIME = DepartureTime, EXPORTTIME_SYS1 = ExportTimeSys1, EXPORTLOADNUM_SYS1 = ExportLoadNumSys1, EXPORTTIME_SYS2 = ExportTimeSys2, EXPORTLOADNUM_SYS2 = ExportLoadNumSys2, EXPORTTIME_SYS3 = ExportTimeSys3, EXPORTLOADNUM_SYS3 = ExportLoadNumSys3, C_LAST_UPDATED_ = LastUpdated, C_LAST_USER_ = LastUser, C_LAST_MODULE_ = LastModule, ADDRESS_1 = Address1, ADDRESS_1_OLD = Address1Old, ADDRESS_2 = Address2, ADDRESS_2_OLD = Address2Old, CITY = City, CITY_OLD = CityOld, STATE = State, STATE_OLD = StateOld, ZIP = Zip, ZIP_OLD = ZipOld, PURCHASE_ORDER = PurchasOrder, PURCHASE_ORDER_OLD = PurchasOrderOld, PURCHASE_ORDER_DATE = PurchasOrderDate, PURCHASE_ORDER_DATE_OLD = PurchasOrderDateOld, STATUS = Status, STATUS_OLD = StatusOld, COMMENTS_1 = Comments1, EXPORTFDM4BATCH_SYS1 = ExportFDM4Batch }; wms.AUDIT_OUTBOUND.Add(Outbound); wms.SaveChanges(); } }
internal void CreateMoveQueue(string CarrierID) { if (MQType != "REPLEN") { CarrierTable Carrier = new CarrierTable(CarrierID); if (Carrier.Type == "Parcel") { ToLocation = "CONVEYOR"; } else { ToLocation = "SHIPSTAGE"; } } if (CreateTime == Convert.ToDateTime("1/1/0001")) { CreateTime = DateTime.Now; } if (Status == null || Status == "") { Status = "N"; } LastUpdated = DateTime.Now; LastUser = Environment.MachineName; LastModule = "CARTONIZE"; RID = GetNextRID("MOVE_QUEUE"); var WMS = new WMSEntities(); var MoveQ = new MOVE_QUEUE { C_RID_ = RID, INV_RID = InvRID, TYPE = MQType, SHIPMENT_ID = shipmentID, ORDER_NUMBER = OrderNumber, ORDER_LINE = (short?)OrderLine, PRIORITY = (short)Priority, CREATE_TIME = CreateTime, STATUS = Status, TO_LOCATION = ToLocation, FROM_LOCATION = FromLocation, TO_ZONE = ToZone, FROM_ZONE = FromZone, ORIG_QUANTITY_REQUIRED = OrigionalQuantityRequired, QUANTITY_INTRANSIT = QuantityInTransit, LABELLEVEL = LabelLevel, C_LAST_UPDATED_ = LastUpdated, C_LAST_MODULE_ = LastModule, C_LAST_USER_ = LastUser }; WMS.MOVE_QUEUE.Add(MoveQ); //Tim Uncomment WMS.SaveChanges(); // PrintMoveQueue(); }
public void UpdateLastUser(string Value) { using (WMSEntities wms = new WMSEntities()) { IQueryable <INVENTORY> Data = from Inv in wms.INVENTORies where Inv.C_RID_ == RID select Inv; foreach (INVENTORY InventoryData in Data) { InventoryData.C_LAST_USER_ = Value; } wms.SaveChanges(); } }
public void UpdateLastUpdated() { using (WMSEntities wms = new WMSEntities()) { IQueryable <INVENTORY> Data = from Inv in wms.INVENTORies where Inv.C_RID_ == RID select Inv; foreach (INVENTORY InventoryData in Data) { InventoryData.C_LAST_UPDATED_ = DateTime.Now; } wms.SaveChanges(); } }
public void updateReservationType(string Value) { using (WMSEntities wms = new WMSEntities()) { IQueryable <INVENTORY> Data = from Inv in wms.INVENTORies where Inv.C_RID_ == RID select Inv; foreach (INVENTORY InventoryData in Data) { InventoryData.RESERVATION_TYPE = Value; } wms.SaveChanges(); } }
internal void DeleteMoveQueueEntry(int InRID) { using (WMSEntities wms = new WMSEntities()) { IQueryable <MOVE_QUEUE> MoveQ = from MQ in wms.MOVE_QUEUE where MQ.C_RID_ == InRID select MQ; foreach (MOVE_QUEUE move in MoveQ) { wms.MOVE_QUEUE.Remove(move); } wms.SaveChanges(); } }
public void UpdateLastModule(string Value) { using (WMSEntities wms = new WMSEntities()) { IQueryable <Inventory> Data = from Inv in wms.Inventories where Inv.C_RID_ == RID select Inv; foreach (Inventory InventoryData in Data) { InventoryData.C_LAST_MODULE_ = Value; } wms.SaveChanges(); } }
internal void UpdateTransactionTime(DateTime Value) { TransactionTime = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <AUDIT_OUTBOUND> Data = from AO in wms.AUDIT_OUTBOUND where AO.C_RID_ == RID select AO; foreach (AUDIT_OUTBOUND AOData in Data) { AOData.TRANSACTION_TIME = TransactionTime; } wms.SaveChanges(); } }
internal void UpdateMaxThreads() { //if max threads was not 1, set it to 1 Log.Write("threads allowed: " + MaxThreads); if (MaxThreads > 0 && MaxThreads != 1) { using (WMSEntities wms = new WMSEntities()) { IQueryable <SYSTEM> Data = from S in wms.SYSTEMs where S.NAME == "Cartonize_threads_allowed" select S; foreach (SYSTEM sysData in Data) { sysData.VALUE = "1"; sysData.C_LAST_UPDATED_ = DateTime.Now; sysData.C_LAST_USER_ = "ATS"; sysData.C_LAST_MODULE_ = "WHT"; } wms.SaveChanges(); currentThreadCount = 1; } } if (currentThreadCount == 1 && currentThreadCount != MaxThreads) { using (WMSEntities wms = new WMSEntities()) { IQueryable <SYSTEM> Data = from S in wms.SYSTEMs where S.NAME == "Cartonize_threads_allowed" select S; foreach (SYSTEM sysData in Data) { sysData.VALUE = MaxThreads.ToString(); sysData.C_LAST_UPDATED_ = DateTime.Now; sysData.C_LAST_USER_ = "ATS"; sysData.C_LAST_MODULE_ = "WHT"; } wms.SaveChanges(); currentThreadCount = 0; } } }
internal void DeleteOBSEntry() { using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> obsd = from OD in wms.OUTBOUND_SHIPMENTS where OD.SHIPMENT_ID == ShipmentID && OD.ORDER_NUMBER == OrderNumber select OD; foreach (OUTBOUND_SHIPMENTS allocate in obsd) { wms.OUTBOUND_SHIPMENTS.Remove(allocate); } wms.SaveChanges(); } }
private int GetNextRID(string Table) { int RID = 0; using (WMSEntities wms = new WMSEntities()) { IQueryable <SYSTEMNEXTRID> Item = from NewRid in wms.SYSTEMNEXTRIDs where NewRid.GENERICNAME == Table select NewRid; foreach (SYSTEMNEXTRID New in Item) { New.NEXTRID++; RID = New.NEXTRID; wms.SaveChanges(); } } return(RID); }
public void UpdateLastUpdated() { LastUpdated = DateTime.Now; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENT_DETAILS> Data = from OBSD in wms.OUTBOUND_SHIPMENT_DETAILS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber && OBSD.ORDER_LINE == OrderLine select OBSD; foreach (OUTBOUND_SHIPMENT_DETAILS OBSDData in Data) { OBSDData.C_LAST_UPDATED_ = LastUpdated; } wms.SaveChanges(); } }
internal void UpdateShipmentID(string Value) { if (ShipmentID != Value) { ShipmentID = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <AUDIT_OUTBOUND> Data = from AO in wms.AUDIT_OUTBOUND where AO.C_RID_ == RID select AO; foreach (AUDIT_OUTBOUND AOData in Data) { AOData.SHIPMENT_ID = ShipmentID; } wms.SaveChanges(); } } }
internal void UpdateStatus(string Value) { if (Status != Value) { Status = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <AUDIT_OUTBOUND> Data = from AO in wms.AUDIT_OUTBOUND where AO.C_RID_ == RID select AO; foreach (AUDIT_OUTBOUND AOData in Data) { AOData.STATUS = Status; } wms.SaveChanges(); } } }
internal void UpdateLastModule(string Value) { if (LastModule != Value) { LastModule = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <AUDIT_OUTBOUND> Data = from AO in wms.AUDIT_OUTBOUND where AO.C_RID_ == RID select AO; foreach (AUDIT_OUTBOUND AOData in Data) { AOData.C_LAST_MODULE_ = LastModule; } wms.SaveChanges(); } } }
internal void UpdateLastUpdated() { _Last_Updated_ = DateTime.Now; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBS in wms.OUTBOUND_SHIPMENTS where OBS.SHIPMENT_ID == ShipmentID && OBS.ORDER_NUMBER == OrderNumber select OBS; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.C_LAST_UPDATED_ = _Last_Updated_; } wms.SaveChanges(); } }
/************************************************************************************** * Function name: CheckTruck * * What this Function Does: Checks to see if the order is ship mode 7(Truck) and of terms 1 or 2, if it is we change the order status to E * * update needed: none * * Variables passed in: None * * Variables Declared : None * * returns : Nothing * **************************************************************************************/ public void CheckTruck() { using (WMSEntities wms = new WMSEntities()) { IQueryable <HOST_ORDERS> items = from H in wms.HOST_ORDERS where ((H.TERMS == 1 && H.ORIGINAL_SHIP_MODE == "7") || (H.TERMS == 2 && H.ORIGINAL_SHIP_MODE == "7")) && H.STATUS == "N" select H; foreach (HOST_ORDERS x in items) { x.STATUS = "E"; Log.Write("Status Changed from N to E in CheckTruck()\n"); } wms.SaveChanges(); } }
internal void LogError(string ShipmentID, string OrderNumber, float?OrderLine, string ProductID, string StrText) { try { var WMS = new WMSEntities(); Write(StrText); int RID = GetNextErrorRID(); string SText = "Shipment: " + ShipmentID + " Order: " + OrderNumber + " Line: " + OrderLine + " Product_ID: " + ProductID; Write(SText); var error = new ERRORS_RUNTIME() { C_RID_ = RID, ERRORTIME = DateTime.Now, USERID = "WHT", MODULE = "Warehouse_Trans", FUNCTION = "Log_error", ERRORTYPE = null, ERRORNUMBER = 100, ERRORMESSAGE = StrText, ERRORDATA = SText, C_LAST_UPDATED_ = DateTime.Now, C_LAST_USER_ = "WHT", C_LAST_MODULE_ = "Warehouse_transfer" }; WMS.ERRORS_RUNTIME.Add(error); WMS.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); Console.ReadLine(); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); Console.ReadLine(); } } throw; } }
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(); } } }
private void UpdateThreads(int threadValue) { using (WMSEntities wms = new WMSEntities()) { IQueryable <SYSTEM> Data = from S in wms.SYSTEMs where S.NAME == "Cartonize_threads" select S; foreach (SYSTEM sysData in Data) { sysData.VALUE = threadValue.ToString(); sysData.C_LAST_UPDATED_ = DateTime.Now; sysData.C_LAST_USER_ = "ATS"; sysData.C_LAST_MODULE_ = "WHT"; } wms.SaveChanges(); } }
internal void updateUnitOfMesure(string Value) { if (UnitOfMesure != Value) { UnitOfMesure = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENT_DETAILS> Data = from OBSD in wms.OUTBOUND_SHIPMENT_DETAILS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber && OBSD.ORDER_LINE == OrderLine select OBSD; foreach (OUTBOUND_SHIPMENT_DETAILS OBSDData in Data) { OBSDData.UOM = UnitOfMesure; } wms.SaveChanges(); } } }
public void updateAllocationStatus(string Value) { if (AllocationStatus != Value) { AllocationStatus = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBSD in wms.OUTBOUND_SHIPMENTS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber select OBSD; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.ALLOCATION_STATUS = Value; } wms.SaveChanges(); } } }
internal void UpdateCatrtonType(string Value) { if (CartonType != Value) { CartonType = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBSD in wms.OUTBOUND_SHIPMENTS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber select OBSD; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.CARTON_TYPE = Value; } wms.SaveChanges(); } } }
internal void UpdateStatus(string Value) { if (Status != Value) { Status = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBS in wms.OUTBOUND_SHIPMENTS where OBS.SHIPMENT_ID == ShipmentID && OBS.ORDER_NUMBER == OrderNumber select OBS; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.STATUS = Value; } wms.SaveChanges(); } } }
internal void UpdateQCCodes(string Value) { if (QC_Codes != Value) { QC_Codes = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBSD in wms.OUTBOUND_SHIPMENTS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber select OBSD; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.QC_CODES = Value; } wms.SaveChanges(); } } }
internal void UpdatePurchaseOrder(string Value) { if (Purchase_order != Value) { Purchase_order = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENTS> Data = from OBSD in wms.OUTBOUND_SHIPMENTS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber select OBSD; foreach (OUTBOUND_SHIPMENTS OBSData in Data) { OBSData.PURCHASE_ORDER = 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 UpdateOrderQuantity(int Value) { if (OrderedUnits != Value) { OrderedUnits = Value; using (WMSEntities wms = new WMSEntities()) { IQueryable <OUTBOUND_SHIPMENT_DETAILS> Data = from OBSD in wms.OUTBOUND_SHIPMENT_DETAILS where OBSD.SHIPMENT_ID == ShipmentID && OBSD.ORDER_NUMBER == OrderNumber && OBSD.ORDER_LINE == OrderLine select OBSD; foreach (OUTBOUND_SHIPMENT_DETAILS OBSDData in Data) { OBSDData.ORDERED_UNITS = OrderedUnits; } 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(); } } }