/// <summary> /// Get /// Calls [usp_select_ClientInvoiceLine] /// </summary> public static ClientInvoiceLine Get(System.Int32?clientInvoiceLineId) { Rebound.GlobalTrader.DAL.ClientInvoiceLineDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.ClientInvoiceLine.Get(clientInvoiceLineId); if (objDetails == null) { return(null); } else { ClientInvoiceLine obj = new ClientInvoiceLine(); obj.ClientInvoiceLineId = objDetails.ClientInvoiceLineId; obj.ClientInvoiceNo = objDetails.ClientInvoiceNo; obj.GoodsInNo = objDetails.GoodsInNo; obj.Price = objDetails.Price; obj.Part = objDetails.Part; obj.QtyReceived = objDetails.QtyReceived; obj.DateReceived = objDetails.DateReceived; obj.CurrencyCode = objDetails.CurrencyCode; obj.DateCode = objDetails.DateCode; obj.ProductNo = objDetails.ProductNo; obj.SupplierPart = objDetails.SupplierPart; obj.ROHS = objDetails.ROHS; obj.PackageNo = objDetails.PackageNo; obj.Landedcost = objDetails.Landedcost; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.ManufacturerName = objDetails.ManufacturerName; obj.CurrencyNo = objDetails.CurrencyNo; obj.ProductDescription = objDetails.ProductDescription; objDetails = null; return(obj); } }
/// <summary> /// Search Client goodsin line by given parameter /// Call Proc [usp_itemsearch_ClientInvoice_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 <ClientInvoiceLine> 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) { List <ClientInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.ClientInvoiceLine.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, companyNo, includeInvoiced, giLineDateFrom, giLineDateTo, goodsInNo); if (lstDetails == null) { return(new List <ClientInvoiceLine>()); } else { List <ClientInvoiceLine> lst = new List <ClientInvoiceLine>(); foreach (ClientInvoiceLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.ClientInvoiceLine obj = new Rebound.GlobalTrader.BLL.ClientInvoiceLine(); 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 Clientinvoiceline by ID /// Call Proc [usp_selectAll_ClientInvoiceLine_for_ClientInvoice] /// </summary> /// <param name="ClientInvoiceId"></param> /// <returns></returns> public static List <ClientInvoiceLine> GetListForClientInvoiceLine(System.Int32?ClientInvoiceId) { List <ClientInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.ClientInvoiceLine.GetListForClientInvoiceLine(ClientInvoiceId); if (lstDetails == null) { return(new List <ClientInvoiceLine>()); } else { List <ClientInvoiceLine> lst = new List <ClientInvoiceLine>(); foreach (ClientInvoiceLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.ClientInvoiceLine obj = new Rebound.GlobalTrader.BLL.ClientInvoiceLine(); obj.ClientInvoiceLineId = objDetails.ClientInvoiceLineId; obj.ClientInvoiceNo = objDetails.ClientInvoiceNo; 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.CountryOfManufacture = objDetails.CountryOfManufacture; obj.ProductNo = objDetails.ProductNo; obj.ProductName = objDetails.ProductName; obj.DateCode = objDetails.DateCode; obj.PackageNo = objDetails.PackageNo; obj.PackageName = objDetails.PackageName; obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo; obj.InternalPurchaseOrderNumber = objDetails.InternalPurchaseOrderNumber; obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.PurchaseOrderNo = objDetails.PurchaseOrderNo; obj.Taxable = objDetails.Taxable; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.POSerialNo = objDetails.POSerialNo; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// /// Calls [usp_getClientInvoice] /// </summary> public static List <ClientInvoiceLine> GetClientInvoice(System.Int32?ClientInvoiceId, System.Int32?clientInvoiceLineNo) { List <ClientInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.ClientInvoiceLine.GetClientInvoice(ClientInvoiceId, clientInvoiceLineNo); if (lstDetails == null) { return(new List <ClientInvoiceLine>()); } else { List <ClientInvoiceLine> lst = new List <ClientInvoiceLine>(); foreach (ClientInvoiceLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.ClientInvoiceLine obj = new Rebound.GlobalTrader.BLL.ClientInvoiceLine(); obj.ClientInvoiceLineId = objDetails.ClientInvoiceLineId; obj.ClientInvoiceNo = objDetails.ClientInvoiceNo; obj.DateReceived = objDetails.DateReceived; obj.CurrencyCode = objDetails.CurrencyCode; obj.QtyReceived = objDetails.QtyReceived; obj.Part = objDetails.Part; obj.Price = objDetails.Price; obj.ROHS = objDetails.ROHS; obj.GoodsInNo = objDetails.GoodsInNo; obj.ClientInvoiceNumber = objDetails.ClientInvoiceNumber; obj.RowNum = objDetails.RowNum; obj.RowCnt = objDetails.RowCnt; obj.GoodsInNumber = objDetails.GoodsInNumber; obj.InternalPurchaseOrderNumber = objDetails.InternalPurchaseOrderNumber; obj.DebitNumber = objDetails.DebitNumber; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }