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