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