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();
}
}
}
