private int GetThreads()
{
try
{
int threads = -1;
using (WMSEntities wms = new WMSEntities())
{
IQueryable <SYSTEM> Data = from s in wms.SYSTEMs where s.NAME == "Cartonize_threads" select s;
foreach (SYSTEM x in Data)
{
threads = Convert.ToInt32(x.VALUE);
}
}
return(threads);
}
catch (Exception e)
{
Log.Write("Error in :" + System.Reflection.MethodBase.GetCurrentMethod().Name);
Log.Write("Error Message: " + e.Message);
Log.Write("Stack Trace: " + e.StackTrace);
Log.Write("Target Site: " + e.TargetSite);
Log.Write("Exiting Program");
return(-1);
}
}
public CarrierTable(string ID)
{
using (WMSEntities wms = new WMSEntities())
{
IQueryable <CARRIER> Data = from Cr in wms.CARRIERS where Cr.CARRIER_ID == ID select Cr;
foreach (CARRIER Carr in Data)
{
CarrierID = Carr.CARRIER_ID;
PoolPoint = Carr.POOL_POINT;
Name = Carr.NAME;
Address1 = Carr.ADDRESS_1;
Address2 = Carr.ADDRESS_2;
City = Carr.CITY;
State = Carr.STATE;
ZIP = Carr.ZIP;
ContactName = Carr.CONTACT_NAME;
ContactPhone = Carr.CONTACT_PHONE;
Comments1 = Carr.COMMENTS_1;
Comments2 = Carr.COMMENTS_2;
Comments3 = Carr.COMMENTS_3;
Comments4 = Carr.COMMENTS_4;
AccountNumber = Carr.ACCOUNT_NUMBER;
ICCNumber = Carr.ACCOUNT_NUMBER;
LastUpdated = Carr.C_LAST_UPDATED_;
LastUser = Carr.C_LAST_USER_;
LastModule = Carr.C_LAST_MODULE_;
CompanyName = Carr.COMPANY_NAME;
Type = Carr.TYPE;
ShipModeDefault = Carr.SHIP_MODE_DEFAULT;
}
}
}
public MoveQueue(int InRID)
{
using (WMSEntities wms = new WMSEntities())
{
IQueryable <MOVE_QUEUE> Item = from MQ in wms.MOVE_QUEUE where MQ.C_RID_ == InRID select MQ;
foreach (MOVE_QUEUE Move in Item)
{
RID = Move.C_RID_;
InvRID = Move.INV_RID;
MQType = Move.TYPE;
Priority = Move.PRIORITY;
CreateTime = Move.CREATE_TIME;
Status = Move.STATUS;
LabelLevel = Move.LABELLEVEL;
ToZone = Move.TO_ZONE;
ToLocation = Move.TO_LOCATION;
FromLocation = Move.FROM_LOCATION;
OrigionalQuantityRequired = Move.ORIG_QUANTITY_REQUIRED;
QuantityRequired = Move.QUANTITY_REQUIRED;
QuantityInTransit = Move.QUANTITY_INTRANSIT;
UserIdInTransit = Move.USER_ID_INTRANSIT;
VehicleInTranset = Move.VEHICLE_INTRANSIT;
shipmentID = Move.SHIPMENT_ID;
OrderNumber = Move.ORDER_NUMBER;
OrderLine = Move.ORDER_LINE;
LastUpdated = Move.C_LAST_UPDATED_;
LastModule = Move.C_LAST_MODULE_;
LastUser = Move.C_LAST_USER_;
}
}
}
public Locations(string PiecePickLocation)
{
using (WMSEntities wms = new WMSEntities())
{
IQueryable <LOCATION> Data = from LO in wms.LOCATIONS where LO.LOCATION_ID == PiecePickLocation select LO;
foreach (LOCATION Dloc in Data)
{
LocationID = Dloc.LOCATION_ID;
LocationGroup = Dloc.LOCATION_GROUP;
EisLocation = Dloc.EIS_LOCATION;
PickSequence = Dloc.PICK_SEQUENCE;
Aisle = Dloc.AISLE;
Slot = Dloc.SLOT;
VLevel = Dloc.VLEVEL;
Bin = Dloc.BIN;
Status = Dloc.STATUS;
SiteID = Dloc.SITE_ID;
PickingZone = Dloc.PICKING_ZONE;
AllowPiecePick = Dloc.ALLOWPIECEPICKING;
Type = Dloc.TYPE;
Usage = Dloc.USAGE;
LastUpdated = Dloc.C_LAST_UPDATED_;
LastUser = Dloc.C_LAST_USER_;
LastModule = Dloc.C_LAST_MODULE_;
PutawaySequence = Dloc.PUTAWAY_SEQUENCE;
ReverseSlot = Dloc.REVERSE_SLOT;
}
}
}
/**************************************************************************************
* Function name: CreatePicks
*
* What this Function Does: once the order is broken down, this function will look for the inventory to try and fill the order
*
* update needed: error handeling
*
* Variables passed in: order- the order object
* orderType- the type of order we are processing
*
* Variables Declared : AllocationStatus: the status of the order being allocated( C:compleate
* E:Error
* R:Error
* S:short)
* OrderCancelRequest- bool value to see if the order was canceled;
*
* returns : Nothing
* **************************************************************************************/
internal void CreatePicks(Order Orders, string orderType)
{
string allocationstatus;
bool OrderCancelRequest = false;
allocationstatus = Orders.PiecePickCreation();
Log.Write("ALLOCATION STATUS: " + allocationstatus);
if ((allocationstatus == "E" || allocationstatus == "R") || (allocationstatus == "S"))
{
Log.Write("*********************************************************************************");
Log.Write("COULD NOT ALLOCATE INVENTORY FOR ORDER " + Orders.OrderID + ".....ROLLING BACK");
Log.Write("*********************************************************************************");
Orders.RemoveAllocation(allocationstatus, Orders.OrderID);
Orders.UpdateHostOrderStatus(allocationstatus, OrderCancelRequest, orderType);
}
else
{
using (WMSEntities wms = new WMSEntities())
{
Log.Write("Sucessful Allocation");
if ((allocationstatus == "C"))
{
Orders.UpdateStatuses("N");
Orders.UpdateHostOrderStatus(allocationstatus, OrderCancelRequest, orderType);
}
}
}
}
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 ProductMaster(string InProductID)
{
using (WMSEntities wms = new WMSEntities())
{
IQueryable <PRODUCT_MASTER> Item = from PM in wms.PRODUCT_MASTER where PM.PRODUCT_ID == InProductID select PM;
foreach (PRODUCT_MASTER PM in Item)
{
ProductID = PM.PRODUCT_ID;
EisProductID = PM.EIS_PRODUCT_ID;
UpcCode = PM.UPC_CODE;
VendorID = PM.VENDOR_ID;
Description = PM.DESCRIPTION;
ShortDescription = PM.SHORT_DESCRIPTION;
BaseUom = PM.BASE_UOM;
ProductionUom = PM.PRODUCTION_UOM;
StockUom = PM.STOCK_UOM;
RecivingUom = PM.RECEIVING_UOM;
BaseUomPerCaseLevel = PM.BASE_UOM_PER_CASELEVEL;
CaseLevelPerPallettote = PM.CASELEVEL_PER_PALLETTOTE;
CaseLevelPerContainer = PM.CASELEVEL_PER_CONTAINER;
Location_group = PM.LOCATION_GROUP;
PutAwayZone1 = PM.PUTAWAY_ZONE_1;
PutAwayZone2 = PM.PUTAWAY_ZONE_2;
PutAwayZone3 = PM.PUTAWAY_ZONE_3;
PickZone1 = PM.PICK_ZONE_1;
PickZone2 = PM.PICK_ZONE_2;
PickZone3 = PM.PICK_ZONE_3;
PiecePickLocation = PM.PIECE_PICK_LOCATION;
CaseLevelPickLocation = PM.CASELEVEL_PICK_LOCATION;
PallotePickLocation = PM.PALLETTOTE_PICK_LOCATION;
ContainerPickLocation = PM.CONTAINER_PICK_LOCATION;
BolCLass = PM.BOL_CLASS;
ProductType = PM.PRODUCT_TYPE;
InitQcCategory = PM.INIT_QC_CATEGORY;
ShelfLife = PM.SHELF_LIFE;
ShipByWindow = PM.SHIP_BY_WINDOW;
ConsolidationWindow = PM.CONSOLIDATION_WINDOW;
CaseLevelWeight = PM.CASELEVEL_WEIGHT;
CubePerUom = PM.CUBEPERUOM;
AutoRelease = PM.AUTO_RELEASE;
EisAvgUnitCost = PM.EIS_AVG_UNIT_COST;
EisSize = PM.EIS_SIZE;
EisMillStyleNumber = PM.EIS_MILL_STYLE_NUMBER;
EisPackageQty = PM.EIS_PACKAGE_QTY;
EisQtyOnOrder = PM.EIS_QTY_ONORDER;
EisQtyOnHand = PM.EIS_QTY_ONHAND;
EisMillPurchasePrice = PM.EIS_MILL_PURCHASE_PRICE;
LastUpdated = PM.C_LAST_UPDATED_;
LastModule = PM.C_LAST_MODULE_;
EisPieceWeight = PM.EIS_PIECE_WEIGHT;
EisColor = PM.EIS_COLOR;
}
}
}
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;
}
}
}
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();
}
}
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();
}
}
internal void DeleteInventoryAllocation(int InRID)
{
using (WMSEntities wms = new WMSEntities())
{
IQueryable <INVENTORY_ALLOCATION> inv = from IA in wms.INVENTORY_ALLOCATION where IA.C_RID_ == InRID select IA;
foreach (INVENTORY_ALLOCATION allocate in inv)
{
wms.INVENTORY_ALLOCATION.Remove(allocate);
}
// wms.SaveChanges();
}
}
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();
}
}
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();
}
}
private int?GetCaseQuantity(string ProductID)
{
int quantity = 0;
using (WMSEntities wms = new WMSEntities())
{
var info = (from PM in wms.PRODUCT_MASTER where PM.PRODUCT_ID == ProductID select PM.BASE_UOM_PER_CASELEVEL);
foreach (var data in info)
{
quantity = (int)data.Value;
}
}
return(quantity);
}
private int GetThreads()
{
int threads = -1;
using (WMSEntities wms = new WMSEntities())
{
IQueryable <SYSTEM> Data = from s in wms.SYSTEMs where s.NAME == "Cartonize_threads" select s;
foreach (SYSTEM x in Data)
{
threads = Convert.ToInt32(x.VALUE);
}
}
return(threads);
}
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();
}
}
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 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 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 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 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();
}
}
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);
}
/**************************************************************************************
* Function name: CreatePicks
*
* What this Function Does: once the order is broken down, this function will look for the inventory to try and fill the order
*
* update needed: error handeling
*
* Variables passed in: order- the order object
* orderType- the type of order we are processing
*
* Variables Declared : AllocationStatus: the status of the order being allocated( C:compleate
* E:Error
* R:Error
* S:short)
* OrderCancelRequest- bool value to see if the order was canceled;
*
* returns : Nothing
* **************************************************************************************/
internal void CreatePicks(Order Orders, string orderType)
{
string allocationstatus;
bool OrderCancelRequest = false;
allocationstatus = Orders.PiecePickCreation();
Log.Write("ALLOCATION STATUS: " + allocationstatus);
if ((allocationstatus == "E" || allocationstatus == "R") || (allocationstatus == "S"))
{
Log.Write("*********************************************************************************");
Log.Write("COULD NOT ALLOCATE INVENTORY FOR ORDER " + Orders.OrderID + ".....ROLLING BACK");
Log.Write("*********************************************************************************");
Orders.RemoveAllocation(allocationstatus, Orders.OrderID);
Orders.UpdateHostOrderStatus(allocationstatus, OrderCancelRequest, orderType);
}
else
{
using (WMSEntities wms = new WMSEntities())
{
var item = (from ORC in wms.ORDER_CANCEL_REQUESTS where ORC.EIS_ORDER_ID == Orders.OrderID select ORC.EIS_ORDER_ID).SingleOrDefault();
if (item != null)
{
Log.Write("**************************************************************************");
Log.Write("ORDER " + Orders.OrderID + " CANCELED THROUGH FDM4....ROLLING BACK");
Log.Write("**************************************************************************");
Orders.RemoveAllocation(allocationstatus, Orders.OrderID);
OrderCancelRequest = true;
}
else
{
Log.Write("Sucessful Allocation");
if ((allocationstatus == "C"))
{
Orders.UpdateStatuses("N");
Orders.UpdateHostOrderStatus(allocationstatus, OrderCancelRequest, orderType);
}
}
}
}
}
public string getPiecePickLocation(string ProductID)
{
string location = "";
using (WMSEntities wms = new WMSEntities())
{
var item = (from h in wms.PRODUCT_MASTER where h.PRODUCT_ID == ProductID select h.PIECE_PICK_LOCATION).SingleOrDefault();
if (item != null)
{
location = item;
}
}
return(location);
}
/**************************************************************************************
* 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();
}
}
