/// <summary>
/// GetListForDebit
/// Calls [usp_selectAll_DebitLine_for_Debit_Print]
/// </summary>
public static List <DebitLine> GetListForDebitPrint(System.Int32?debitId, System.Boolean?IsHUBDebit)
{
List <DebitLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.DebitLine.GetListForDebitPrint(debitId, IsHUBDebit);
if (lstDetails == null)
{
return(new List <DebitLine>());
}
else
{
List <DebitLine> lst = new List <DebitLine>();
foreach (DebitLineDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.DebitLine obj = new Rebound.GlobalTrader.BLL.DebitLine();
obj.DebitLineId = objDetails.DebitLineId;
obj.DebitNo = objDetails.DebitNo;
obj.DebitNumber = objDetails.DebitNumber;
obj.DebitDate = objDetails.DebitDate;
obj.DivisionNo = objDetails.DivisionNo;
obj.FullPart = objDetails.FullPart;
obj.Part = objDetails.Part;
obj.ROHS = objDetails.ROHS;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.ManufacturerName = objDetails.ManufacturerName;
obj.ManufacturerCode = objDetails.ManufacturerCode;
obj.DateCode = objDetails.DateCode;
obj.PackageNo = objDetails.PackageNo;
obj.PackageName = objDetails.PackageName;
obj.PackageDescription = objDetails.PackageDescription;
obj.ProductNo = objDetails.ProductNo;
obj.ProductName = objDetails.ProductName;
obj.ProductDescription = objDetails.ProductDescription;
obj.Quantity = objDetails.Quantity;
obj.Price = objDetails.Price;
obj.LandedCost = objDetails.LandedCost;
obj.Taxable = objDetails.Taxable;
obj.PurchaseOrderLineNo = objDetails.PurchaseOrderLineNo;
obj.SupplierPart = objDetails.SupplierPart;
obj.SupplierRMALineNo = objDetails.SupplierRMALineNo;
obj.StockNo = objDetails.StockNo;
obj.ServiceNo = objDetails.ServiceNo;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.LineNotes = objDetails.LineNotes;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.ProductDutyCode = objDetails.ProductDutyCode;
obj.PrintHazardous = objDetails.PrintHazardous;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
private static DebitLine PopulateFromDBDetailsObject(DebitLineDetails obj)
{
DebitLine objNew = new DebitLine();
objNew.DebitLineId = obj.DebitLineId;
objNew.DebitNo = obj.DebitNo;
objNew.FullPart = obj.FullPart;
objNew.Part = obj.Part;
objNew.ManufacturerNo = obj.ManufacturerNo;
objNew.DateCode = obj.DateCode;
objNew.PackageNo = obj.PackageNo;
objNew.ProductNo = obj.ProductNo;
objNew.Quantity = obj.Quantity;
objNew.Price = obj.Price;
objNew.Taxable = obj.Taxable;
objNew.SupplierPart = obj.SupplierPart;
objNew.LandedCost = obj.LandedCost;
objNew.PurchaseOrderLineNo = obj.PurchaseOrderLineNo;
objNew.SupplierRMALineNo = obj.SupplierRMALineNo;
objNew.StockNo = obj.StockNo;
objNew.ROHS = obj.ROHS;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.ServiceNo = obj.ServiceNo;
objNew.Notes = obj.Notes;
objNew.FullSupplierPart = obj.FullSupplierPart;
objNew.DebitId = obj.DebitId;
objNew.DebitNumber = obj.DebitNumber;
objNew.DebitDate = obj.DebitDate;
objNew.CompanyName = obj.CompanyName;
objNew.CompanyNo = obj.CompanyNo;
objNew.SupplierRMANumber = obj.SupplierRMANumber;
objNew.SupplierRMANo = obj.SupplierRMANo;
objNew.SupplierInvoice = obj.SupplierInvoice;
objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber;
objNew.PurchaseOrderNo = obj.PurchaseOrderNo;
objNew.ContactName = obj.ContactName;
objNew.ContactNo = obj.ContactNo;
objNew.ManufacturerCode = obj.ManufacturerCode;
objNew.RowNum = obj.RowNum;
objNew.RowCnt = obj.RowCnt;
objNew.DivisionNo = obj.DivisionNo;
objNew.ManufacturerName = obj.ManufacturerName;
objNew.PackageName = obj.PackageName;
objNew.PackageDescription = obj.PackageDescription;
objNew.ProductName = obj.ProductName;
objNew.ProductDescription = obj.ProductDescription;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.LineNotes = obj.LineNotes;
return(objNew);
}
/// <summary>
/// Get
/// Calls [usp_select_DebitLine]
/// </summary>
public static DebitLine Get(System.Int32?debitLineId)
{
Rebound.GlobalTrader.DAL.DebitLineDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.DebitLine.Get(debitLineId);
if (objDetails == null)
{
return(null);
}
else
{
DebitLine obj = new DebitLine();
obj.DebitLineId = objDetails.DebitLineId;
obj.DebitNo = objDetails.DebitNo;
obj.DebitNumber = objDetails.DebitNumber;
obj.DebitDate = objDetails.DebitDate;
obj.DivisionNo = objDetails.DivisionNo;
obj.FullPart = objDetails.FullPart;
obj.Part = objDetails.Part;
obj.ROHS = objDetails.ROHS;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.ManufacturerName = objDetails.ManufacturerName;
obj.ManufacturerCode = objDetails.ManufacturerCode;
obj.DateCode = objDetails.DateCode;
obj.PackageNo = objDetails.PackageNo;
obj.PackageName = objDetails.PackageName;
obj.PackageDescription = objDetails.PackageDescription;
obj.ProductNo = objDetails.ProductNo;
obj.ProductName = objDetails.ProductName;
obj.ProductDescription = objDetails.ProductDescription;
obj.Quantity = objDetails.Quantity;
obj.Price = objDetails.Price;
obj.LandedCost = objDetails.LandedCost;
obj.Taxable = objDetails.Taxable;
obj.PurchaseOrderLineNo = objDetails.PurchaseOrderLineNo;
obj.SupplierPart = objDetails.SupplierPart;
obj.SupplierRMALineNo = objDetails.SupplierRMALineNo;
obj.StockNo = objDetails.StockNo;
obj.ServiceNo = objDetails.ServiceNo;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.LineNotes = objDetails.LineNotes;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.IsProdHazardous = objDetails.IsProdHazardous;
obj.PrintHazardous = objDetails.PrintHazardous;
objDetails = null;
return(obj);
}
}
} /// <summary>
/// DataListNugget
/// Calls [usp_datalistnugget_DebitLine]
/// </summary>
public static List <DebitLine> DataListNugget(System.Int32?clientId, System.Int32?teamId, System.Int32?divisionId, System.Int32?loginId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?buyerSearch, System.String debitNotesSearch, System.String supplierInvoiceSearch, System.Int32?debitNoLo, System.Int32?debitNoHi, System.Int32?purchaseOrderNoLo, System.Int32?purchaseOrderNoHi, System.Int32?supplierRmaNoLo, System.Int32?supplierRmaNoHi, System.DateTime?debitDateFrom, System.DateTime?debitDateTo, System.Boolean?PohubOnly, Boolean IsGlobalLogin, System.Int32?clientSearchId)
{
List <DebitLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.DebitLine.DataListNugget(clientId, teamId, divisionId, loginId, orderBy, sortDir, pageIndex, pageSize, partSearch, contactSearch, cmSearch, buyerSearch, debitNotesSearch, supplierInvoiceSearch, debitNoLo, debitNoHi, purchaseOrderNoLo, purchaseOrderNoHi, supplierRmaNoLo, supplierRmaNoHi, debitDateFrom, debitDateTo, PohubOnly, IsGlobalLogin, clientSearchId);
if (lstDetails == null)
{
return(new List <DebitLine>());
}
else
{
List <DebitLine> lst = new List <DebitLine>();
foreach (DebitLineDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.DebitLine obj = new Rebound.GlobalTrader.BLL.DebitLine();
obj.DebitId = objDetails.DebitId;
obj.DebitNumber = objDetails.DebitNumber;
obj.Part = objDetails.Part;
obj.DebitDate = objDetails.DebitDate;
obj.CompanyName = objDetails.CompanyName;
obj.CompanyNo = objDetails.CompanyNo;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.SupplierInvoice = objDetails.SupplierInvoice;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.ContactName = objDetails.ContactName;
obj.ContactNo = objDetails.ContactNo;
obj.ROHS = objDetails.ROHS;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.ManufacturerCode = objDetails.ManufacturerCode;
obj.RowNum = objDetails.RowNum;
obj.RowCnt = objDetails.RowCnt;
obj.IPOCompanyNo = objDetails.IPOCompanyNo;
obj.IPOCompanyName = objDetails.IPOCompanyName;
obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId;
obj.ClientName = objDetails.ClientName;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}