/// <summary>
/// Search supplier goodsin line by given parameter
/// Call Proc [usp_itemsearch_SupplierInvoice_GoodsInLine]
/// </summary>
/// <param name="clientId"></param>
/// <param name="orderBy"></param>
/// <param name="sortDir"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="companyNo"></param>
/// <param name="includeInvoiced"></param>
/// <param name="giLineDateFrom"></param>
/// <param name="giLineDateTo"></param>
/// <returns></returns>
public static List <SupplierInvoiceLine> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.Int32 companyNo, System.Boolean?includeInvoiced, System.DateTime?giLineDateFrom, System.DateTime?giLineDateTo, System.Int32?goodsInNo, System.Boolean?IsPoHub, bool?isClientInvoice, System.Int32?poNoLo, System.Int32?poNoHi)
{
List <SupplierInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierInvoiceLine.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, companyNo, includeInvoiced, giLineDateFrom, giLineDateTo, goodsInNo, IsPoHub, isClientInvoice, poNoLo, poNoHi);
if (lstDetails == null)
{
return(new List <SupplierInvoiceLine>());
}
else
{
List <SupplierInvoiceLine> lst = new List <SupplierInvoiceLine>();
foreach (SupplierInvoiceLineDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.SupplierInvoiceLine obj = new Rebound.GlobalTrader.BLL.SupplierInvoiceLine();
obj.GoodsInLineNo = objDetails.GoodsInLineNo;
obj.GoodsInNumber = objDetails.GoodsInNumber;
obj.Part = objDetails.Part;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.QtyReceived = objDetails.QtyReceived;
obj.Price = objDetails.Price;
obj.ShipInCost = objDetails.ShipInCost;
obj.NPRPrinted = objDetails.NPRPrinted;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.RowNum = objDetails.RowNum;
obj.RowCnt = objDetails.RowCnt;
obj.DateReceived = objDetails.DateReceived;
obj.GoodsInNo = objDetails.GoodsInNo;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// Get supplierinvoiceline by ID
/// Call Proc [usp_selectAll_SupplierInvoiceLine_for_SupplierInvoice]
/// </summary>
/// <param name="SupplierInvoiceId"></param>
/// <returns></returns>
public static List <SupplierInvoiceLine> GetListForSupplierInvoiceLine(System.Int32?SupplierInvoiceId)
{
List <SupplierInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierInvoiceLine.GetListForSupplierInvoiceLine(SupplierInvoiceId);
if (lstDetails == null)
{
return(new List <SupplierInvoiceLine>());
}
else
{
List <SupplierInvoiceLine> lst = new List <SupplierInvoiceLine>();
foreach (SupplierInvoiceLineDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.SupplierInvoiceLine obj = new Rebound.GlobalTrader.BLL.SupplierInvoiceLine();
obj.SupplierInvoiceLineId = objDetails.SupplierInvoiceLineId;
obj.SupplierInvoiceNo = objDetails.SupplierInvoiceNo;
obj.GoodsInNo = objDetails.GoodsInNo;
obj.GoodsInNumber = objDetails.GoodsInNumber;
obj.Part = objDetails.Part;
obj.SupplierPart = objDetails.SupplierPart;
obj.UnitPrice = objDetails.UnitPrice;
obj.QtyReceived = objDetails.QtyReceived;
obj.Landedcost = objDetails.Landedcost;
obj.DateReceived = objDetails.DateReceived;
obj.StockNo = objDetails.StockNo;
obj.ROHS = objDetails.ROHS;
obj.DLUP = objDetails.DLUP;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.GoodsInLineNo = objDetails.GoodsInLineNo;
obj.PackageNo = objDetails.PackageNo;
obj.ProductName = objDetails.ProductName;
obj.CountryOfManufacture = objDetails.CountryOfManufacture;
obj.DateCode = objDetails.DateCode;
obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId;
obj.InternalPurchaseOrderNumber = objDetails.InternalPurchaseOrderNumber;
obj.ShipInCost = objDetails.ShipInCost;
obj.BuyerName = objDetails.BuyerName;
obj.BuyerNo = objDetails.BuyerNo;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}