/// <summary>
/// Get
/// Calls [usp_select_Allocation]
/// </summary>
public static Allocation Get(System.Int32?allocationId)
{
Rebound.GlobalTrader.DAL.AllocationDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Allocation.Get(allocationId);
if (objDetails == null)
{
return(null);
}
else
{
Allocation obj = new Allocation();
obj.AllocationId = objDetails.AllocationId;
obj.StockNo = objDetails.StockNo;
obj.SalesOrderLineNo = objDetails.SalesOrderLineNo;
obj.QuantityAllocated = objDetails.QuantityAllocated;
obj.SupplierRMALineNo = objDetails.SupplierRMALineNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new AllocationDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual AllocationDetails GetAllocationFromReader(DbDataReader reader)
{
AllocationDetails allocation = new AllocationDetails();
if (reader.HasRows)
{
allocation.AllocationId = GetReaderValue_Int32(reader, "AllocationId", 0); //From: [Table]
allocation.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null); //From: [Table]
allocation.SalesOrderLineNo = GetReaderValue_NullableInt32(reader, "SalesOrderLineNo", null); //From: [Table]
allocation.QuantityAllocated = GetReaderValue_Int32(reader, "QuantityAllocated", 0); //From: [Table]
allocation.SupplierRMALineNo = GetReaderValue_NullableInt32(reader, "SupplierRMALineNo", null); //From: [Table]
allocation.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
allocation.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
allocation.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_selectAll_Allocation]
allocation.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null); //From: [usp_selectAll_Allocation]
allocation.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null); //From: [usp_selectAll_Allocation]
allocation.Part = GetReaderValue_String(reader, "Part", ""); //From: [usp_selectAll_Allocation]
allocation.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null); //From: [usp_selectAll_Allocation]
allocation.ProductName = GetReaderValue_String(reader, "ProductName", ""); //From: [usp_selectAll_Allocation]
allocation.ProductDescription = GetReaderValue_String(reader, "ProductDescription", ""); //From: [usp_selectAll_Allocation]
allocation.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null); //From: [usp_selectAll_Allocation]
allocation.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", ""); //From: [usp_selectAll_Allocation]
allocation.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", ""); //From: [usp_selectAll_Allocation]
allocation.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null); //From: [usp_selectAll_Allocation]
allocation.PackageName = GetReaderValue_String(reader, "PackageName", ""); //From: [usp_selectAll_Allocation]
allocation.PackageDescription = GetReaderValue_String(reader, "PackageDescription", ""); //From: [usp_selectAll_Allocation]
allocation.DateCode = GetReaderValue_String(reader, "DateCode", ""); //From: [usp_selectAll_Allocation]
allocation.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0); //From: [usp_selectAll_Allocation]
allocation.LandedCost = GetReaderValue_NullableDouble(reader, "LandedCost", null); //From: [usp_selectAll_Allocation]
allocation.QuantityInStock = GetReaderValue_Int32(reader, "QuantityInStock", 0); //From: [usp_selectAll_Allocation]
allocation.WarehouseNo = GetReaderValue_NullableInt32(reader, "WarehouseNo", null); //From: [usp_selectAll_Allocation]
allocation.WarehouseName = GetReaderValue_String(reader, "WarehouseName", ""); //From: [usp_selectAll_Allocation]
allocation.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null); //From: [usp_selectAll_Allocation]
allocation.PurchaseOrderNumber = GetReaderValue_NullableInt32(reader, "PurchaseOrderNumber", null); //From: [usp_selectAll_Allocation]
allocation.PurchaseOrderLineId = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineId", null); //From: [usp_selectAll_Allocation]
allocation.BuyPrice = GetReaderValue_NullableDouble(reader, "BuyPrice", null); //From: [usp_selectAll_Allocation]
allocation.DeliveryDate = GetReaderValue_NullableDateTime(reader, "DeliveryDate", null); //From: [usp_selectAll_Allocation]
allocation.BuyCurrencyNo = GetReaderValue_NullableInt32(reader, "BuyCurrencyNo", null); //From: [usp_selectAll_Allocation]
allocation.BuyCurrencyCode = GetReaderValue_String(reader, "BuyCurrencyCode", ""); //From: [usp_selectAll_Allocation]
allocation.SupplierCompanyNo = GetReaderValue_NullableInt32(reader, "SupplierCompanyNo", null); //From: [usp_selectAll_Allocation]
allocation.SupplierCompanyName = GetReaderValue_String(reader, "SupplierCompanyName", ""); //From: [usp_selectAll_Allocation]
allocation.CustomerCompanyNo = GetReaderValue_NullableInt32(reader, "CustomerCompanyNo", null); //From: [usp_selectAll_Allocation]
allocation.CustomerCompanyName = GetReaderValue_String(reader, "CustomerCompanyName", ""); //From: [usp_selectAll_Allocation]
allocation.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null); //From: [usp_selectAll_Allocation]
allocation.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null); //From: [usp_selectAll_Allocation]
allocation.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null); //From: [usp_selectAll_Allocation]
allocation.CustomerPO = GetReaderValue_String(reader, "CustomerPO", ""); //From: [usp_selectAll_Allocation]
allocation.SellPrice = GetReaderValue_NullableDouble(reader, "SellPrice", null); //From: [usp_selectAll_Allocation]
allocation.SellCurrencyNo = GetReaderValue_NullableInt32(reader, "SellCurrencyNo", null); //From: [usp_selectAll_Allocation]
allocation.SellCurrencyCode = GetReaderValue_String(reader, "SellCurrencyCode", ""); //From: [usp_selectAll_Allocation]
allocation.DatePromised = GetReaderValue_NullableDateTime(reader, "DatePromised", null); //From: [usp_selectAll_Allocation]
allocation.CustomerPart = GetReaderValue_String(reader, "CustomerPart", ""); //From: [usp_selectAll_Allocation]
allocation.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null); //From: [usp_selectAll_Allocation]
allocation.Shipped = GetReaderValue_NullableBoolean(reader, "Shipped", null); //From: [usp_selectAll_Allocation]
allocation.Location = GetReaderValue_String(reader, "Location", ""); //From: [usp_selectAll_Allocation]
allocation.SupplierPart = GetReaderValue_String(reader, "SupplierPart", ""); //From: [usp_selectAll_Allocation]
allocation.CustomerRMALineNo = GetReaderValue_NullableInt32(reader, "CustomerRMALineNo", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.PurchaseOrderLineNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineNo", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.SupplierRMADate = GetReaderValue_NullableDateTime(reader, "SupplierRMADate", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.Price = GetReaderValue_NullableDouble(reader, "Price", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine]
allocation.ExpediteDate = GetReaderValue_NullableDateTime(reader, "ExpediteDate", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
allocation.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
allocation.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
allocation.QuantityOnOrder = GetReaderValue_NullableInt32(reader, "QuantityOnOrder", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
}
return(allocation);
}
