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