/// <summary>
/// GetListForPurchaseOrderLine
/// Calls [usp_selectAll_Allocation_for_PurchaseOrderLine]
/// </summary>
public static List <Allocation> GetListForPurchaseOrderLine(System.Int32?purchaseOrderLineId)
{
List <AllocationDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.Allocation.GetListForPurchaseOrderLine(purchaseOrderLineId);
if (lstDetails == null)
{
return(new List <Allocation>());
}
else
{
List <Allocation> lst = new List <Allocation>();
foreach (AllocationDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.Allocation obj = new Rebound.GlobalTrader.BLL.Allocation();
obj.AllocationId = objDetails.AllocationId;
obj.QuantityAllocated = objDetails.QuantityAllocated;
obj.CustomerRMALineNo = objDetails.CustomerRMALineNo;
obj.GoodsInLineNo = objDetails.GoodsInLineNo;
obj.PurchaseOrderLineNo = objDetails.PurchaseOrderLineNo;
obj.StockNo = objDetails.StockNo;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.ReturnDate = objDetails.ReturnDate;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CustomerPO = objDetails.CustomerPO;
obj.DatePromised = objDetails.DatePromised;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.SupplierRMADate = objDetails.SupplierRMADate;
obj.Salesman = objDetails.Salesman;
obj.SalesmanName = objDetails.SalesmanName;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.Part = objDetails.Part;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.ManufacturerCode = objDetails.ManufacturerCode;
obj.ManufacturerName = objDetails.ManufacturerName;
obj.ProductNo = objDetails.ProductNo;
obj.ProductName = objDetails.ProductName;
obj.PackageNo = objDetails.PackageNo;
obj.PackageName = objDetails.PackageName;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.Price = objDetails.Price;
obj.CustomerPart = objDetails.CustomerPart;
obj.ROHS = objDetails.ROHS;
//[002] code start
obj.SalesOrderLineNo = objDetails.SalesOrderLineNo;
//[002] code end
obj.SOSerialNo = objDetails.SOSerialNo;
obj.ShipASAP = objDetails.ShipASAP;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// GetListForSalesOrderLine
/// Calls [usp_selectAll_Allocation_for_SalesOrderLine]
/// </summary>
public static List <Allocation> GetListForSalesOrderLine(System.Int32?salesOrderLineId)
{
List <AllocationDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.Allocation.GetListForSalesOrderLine(salesOrderLineId);
if (lstDetails == null)
{
return(new List <Allocation>());
}
else
{
List <Allocation> lst = new List <Allocation>();
foreach (AllocationDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.Allocation obj = new Rebound.GlobalTrader.BLL.Allocation();
obj.AllocationId = objDetails.AllocationId;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.Part = objDetails.Part;
obj.ROHS = objDetails.ROHS;
obj.QuantityAllocated = objDetails.QuantityAllocated;
obj.StockNo = objDetails.StockNo;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.PurchaseOrderLineNo = objDetails.PurchaseOrderLineNo;
obj.Price = objDetails.Price;
obj.ExpediteDate = objDetails.ExpediteDate;
obj.SupplierPart = objDetails.SupplierPart;
obj.CustomerRMANo = objDetails.CustomerRMANo;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.QuantityInStock = objDetails.QuantityInStock;
obj.QuantityOnOrder = objDetails.QuantityOnOrder;
obj.ReturnDate = objDetails.ReturnDate;
obj.LandedCost = objDetails.LandedCost;
obj.POSerialNo = objDetails.POSerialNo;
obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId;
obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo;
obj.IPOSupplier = objDetails.IPOSupplier;
obj.IPOSupplierName = objDetails.IPOSupplierName;
obj.ClientLandedCost = objDetails.ClientLandedCost;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <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>
/// GetListForSupplierRMALine
/// Calls [usp_selectAll_Allocation_for_SupplierRMALine]
/// </summary>
public static List <Allocation> GetListForSupplierRMALine(System.Int32?supplierRmaLineId)
{
List <AllocationDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.Allocation.GetListForSupplierRMALine(supplierRmaLineId);
if (lstDetails == null)
{
return(new List <Allocation>());
}
else
{
List <Allocation> lst = new List <Allocation>();
foreach (AllocationDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.Allocation obj = new Rebound.GlobalTrader.BLL.Allocation();
obj.AllocationId = objDetails.AllocationId;
obj.StockNo = objDetails.StockNo;
obj.Part = objDetails.Part;
obj.SupplierPart = objDetails.SupplierPart;
obj.SupplierCompanyNo = objDetails.SupplierCompanyNo;
obj.SupplierCompanyName = objDetails.SupplierCompanyName;
obj.ExpediteDate = objDetails.ExpediteDate;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.CustomerRMANo = objDetails.CustomerRMANo;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.ReturnDate = objDetails.ReturnDate;
obj.QuantityAllocated = objDetails.QuantityAllocated;
obj.Location = objDetails.Location;
obj.ROHS = objDetails.ROHS;
//[001] code start
obj.PurchaseOrderLineNo = objDetails.PurchaseOrderLineNo;
//[001] code end
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
private static Allocation PopulateFromDBDetailsObject(AllocationDetails obj)
{
Allocation objNew = new Allocation();
objNew.AllocationId = obj.AllocationId;
objNew.StockNo = obj.StockNo;
objNew.SalesOrderLineNo = obj.SalesOrderLineNo;
objNew.QuantityAllocated = obj.QuantityAllocated;
objNew.SupplierRMALineNo = obj.SupplierRMALineNo;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.SalesmanName = obj.SalesmanName;
objNew.SupplierRMANo = obj.SupplierRMANo;
objNew.SupplierRMANumber = obj.SupplierRMANumber;
objNew.Part = obj.Part;
objNew.ProductNo = obj.ProductNo;
objNew.ProductName = obj.ProductName;
objNew.ProductDescription = obj.ProductDescription;
objNew.ManufacturerNo = obj.ManufacturerNo;
objNew.ManufacturerCode = obj.ManufacturerCode;
objNew.ManufacturerName = obj.ManufacturerName;
objNew.PackageNo = obj.PackageNo;
objNew.PackageName = obj.PackageName;
objNew.PackageDescription = obj.PackageDescription;
objNew.DateCode = obj.DateCode;
objNew.ROHS = obj.ROHS;
objNew.LandedCost = obj.LandedCost;
objNew.QuantityInStock = obj.QuantityInStock;
objNew.WarehouseNo = obj.WarehouseNo;
objNew.WarehouseName = obj.WarehouseName;
objNew.PurchaseOrderNo = obj.PurchaseOrderNo;
objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber;
objNew.PurchaseOrderLineId = obj.PurchaseOrderLineId;
objNew.BuyPrice = obj.BuyPrice;
objNew.DeliveryDate = obj.DeliveryDate;
objNew.BuyCurrencyNo = obj.BuyCurrencyNo;
objNew.BuyCurrencyCode = obj.BuyCurrencyCode;
objNew.SupplierCompanyNo = obj.SupplierCompanyNo;
objNew.SupplierCompanyName = obj.SupplierCompanyName;
objNew.CustomerCompanyNo = obj.CustomerCompanyNo;
objNew.CustomerCompanyName = obj.CustomerCompanyName;
objNew.Salesman = obj.Salesman;
objNew.SalesOrderNo = obj.SalesOrderNo;
objNew.SalesOrderNumber = obj.SalesOrderNumber;
objNew.CustomerPO = obj.CustomerPO;
objNew.SellPrice = obj.SellPrice;
objNew.SellCurrencyNo = obj.SellCurrencyNo;
objNew.SellCurrencyCode = obj.SellCurrencyCode;
objNew.DatePromised = obj.DatePromised;
objNew.CustomerPart = obj.CustomerPart;
objNew.GoodsInLineNo = obj.GoodsInLineNo;
objNew.Shipped = obj.Shipped;
objNew.Location = obj.Location;
objNew.SupplierPart = obj.SupplierPart;
objNew.CustomerRMALineNo = obj.CustomerRMALineNo;
objNew.PurchaseOrderLineNo = obj.PurchaseOrderLineNo;
objNew.ReturnDate = obj.ReturnDate;
objNew.SupplierRMADate = obj.SupplierRMADate;
objNew.CompanyNo = obj.CompanyNo;
objNew.CompanyName = obj.CompanyName;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.Price = obj.Price;
objNew.ExpediteDate = obj.ExpediteDate;
objNew.CustomerRMANo = obj.CustomerRMANo;
objNew.CustomerRMANumber = obj.CustomerRMANumber;
objNew.QuantityOnOrder = obj.QuantityOnOrder;
return(objNew);
}
/// <summary>
/// GetList
/// Calls [usp_selectAll_Allocation]
/// </summary>
public static List <Allocation> GetList()
{
List <AllocationDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.Allocation.GetList();
if (lstDetails == null)
{
return(new List <Allocation>());
}
else
{
List <Allocation> lst = new List <Allocation>();
foreach (AllocationDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.Allocation obj = new Rebound.GlobalTrader.BLL.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;
obj.SalesmanName = objDetails.SalesmanName;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.Part = objDetails.Part;
obj.ProductNo = objDetails.ProductNo;
obj.ProductName = objDetails.ProductName;
obj.ProductDescription = objDetails.ProductDescription;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.ManufacturerCode = objDetails.ManufacturerCode;
obj.ManufacturerName = objDetails.ManufacturerName;
obj.PackageNo = objDetails.PackageNo;
obj.PackageName = objDetails.PackageName;
obj.PackageDescription = objDetails.PackageDescription;
obj.DateCode = objDetails.DateCode;
obj.ROHS = objDetails.ROHS;
obj.LandedCost = objDetails.LandedCost;
obj.QuantityInStock = objDetails.QuantityInStock;
obj.WarehouseNo = objDetails.WarehouseNo;
obj.WarehouseName = objDetails.WarehouseName;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.PurchaseOrderLineId = objDetails.PurchaseOrderLineId;
obj.BuyPrice = objDetails.BuyPrice;
obj.DeliveryDate = objDetails.DeliveryDate;
obj.BuyCurrencyNo = objDetails.BuyCurrencyNo;
obj.BuyCurrencyCode = objDetails.BuyCurrencyCode;
obj.SupplierCompanyNo = objDetails.SupplierCompanyNo;
obj.SupplierCompanyName = objDetails.SupplierCompanyName;
obj.CustomerCompanyNo = objDetails.CustomerCompanyNo;
obj.CustomerCompanyName = objDetails.CustomerCompanyName;
obj.Salesman = objDetails.Salesman;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CustomerPO = objDetails.CustomerPO;
obj.SellPrice = objDetails.SellPrice;
obj.SellCurrencyNo = objDetails.SellCurrencyNo;
obj.SellCurrencyCode = objDetails.SellCurrencyCode;
obj.DatePromised = objDetails.DatePromised;
obj.CustomerPart = objDetails.CustomerPart;
obj.GoodsInLineNo = objDetails.GoodsInLineNo;
obj.Shipped = objDetails.Shipped;
obj.Location = objDetails.Location;
obj.SupplierPart = objDetails.SupplierPart;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
