/// <summary> /// ItemSearch /// Calls [usp_itemsearch_CustomerRMALine] /// </summary> public static List <CustomerRmaLine> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?salesman, System.String crmaNotesSearch, System.Int32?invoiceNoLo, System.Int32?invoiceNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.DateTime?customerRmaDateFrom, System.DateTime?customerRmaDateTo) { List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, partSearch, contactSearch, cmSearch, salesman, crmaNotesSearch, invoiceNoLo, invoiceNoHi, customerRmaNoLo, customerRmaNoHi, customerRmaDateFrom, customerRmaDateTo); if (lstDetails == null) { return(new List <CustomerRmaLine>()); } else { List <CustomerRmaLine> lst = new List <CustomerRmaLine>(); foreach (CustomerRmaLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine(); obj.CustomerRMAId = objDetails.CustomerRMAId; obj.CustomerRMALineId = objDetails.CustomerRMALineId; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; obj.Part = objDetails.Part; obj.ROHS = objDetails.ROHS; obj.CustomerRMADate = objDetails.CustomerRMADate; obj.Quantity = objDetails.Quantity; obj.SalesmanName = objDetails.SalesmanName; obj.InvoiceNumber = objDetails.InvoiceNumber; obj.RowNum = objDetails.RowNum; obj.RowCnt = objDetails.RowCnt; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
private static CustomerRmaLine PopulateFromDBDetailsObject(CustomerRmaLineDetails obj) { CustomerRmaLine objNew = new CustomerRmaLine(); objNew.CustomerRMALineId = obj.CustomerRMALineId; objNew.CustomerRMANo = obj.CustomerRMANo; objNew.InvoiceLineNo = obj.InvoiceLineNo; objNew.ReturnDate = obj.ReturnDate; objNew.Reason = obj.Reason; objNew.Quantity = obj.Quantity; objNew.Notes = obj.Notes; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.CustomerRMAId = obj.CustomerRMAId; objNew.CustomerRMANumber = obj.CustomerRMANumber; objNew.CustomerRMADate = obj.CustomerRMADate; objNew.CompanyName = obj.CompanyName; objNew.CompanyNo = obj.CompanyNo; objNew.InvoiceNumber = obj.InvoiceNumber; objNew.InvoiceNo = obj.InvoiceNo; objNew.ROHS = obj.ROHS; objNew.Part = obj.Part; objNew.ContactName = obj.ContactName; objNew.ContactNo = obj.ContactNo; objNew.ManufacturerNo = obj.ManufacturerNo; objNew.ManufacturerCode = obj.ManufacturerCode; objNew.RowNum = obj.RowNum; objNew.RowCnt = obj.RowCnt; objNew.QuantityReceived = obj.QuantityReceived; objNew.SalesmanName = obj.SalesmanName; objNew.ClientNo = obj.ClientNo; objNew.InvoiceDate = obj.InvoiceDate; objNew.CurrencyNo = obj.CurrencyNo; objNew.Salesman = obj.Salesman; objNew.DivisionNo = obj.DivisionNo; objNew.TeamNo = obj.TeamNo; objNew.QuantityAllocated = obj.QuantityAllocated; objNew.ProductNo = obj.ProductNo; objNew.ProductName = obj.ProductName; objNew.ProductDescription = obj.ProductDescription; objNew.ProductDutyCode = obj.ProductDutyCode; objNew.FullPart = obj.FullPart; objNew.CustomerPart = obj.CustomerPart; objNew.ManufacturerName = obj.ManufacturerName; objNew.PackageNo = obj.PackageNo; objNew.DateCode = obj.DateCode; objNew.PackageName = obj.PackageName; objNew.PackageDescription = obj.PackageDescription; objNew.Price = obj.Price; objNew.LandedCost = obj.LandedCost; objNew.LineNotes = obj.LineNotes; objNew.InvoiceLineAllocationId = obj.InvoiceLineAllocationId; return(objNew); }
/// <summary> /// GetQtyForCustomerRMA /// Calls [usp_GetQty_CustomerRMALine_for_CustomerRMA] /// </summary> public static CustomerRmaLine GetQtyForCustomerRMA(System.Int32?customerRMALineId, System.Int32?invoiceLineID) { CustomerRmaLineDetails lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetQtyForCustomerRMA(customerRMALineId, invoiceLineID); if (lstDetails == null) { return(new CustomerRmaLine()); } else { Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine(); obj.QuantityAvailable = lstDetails.QuantityAvailable; obj.QuantityShipped = lstDetails.QuantityShipped; obj.QuantityReceived = lstDetails.QuantityReceived; obj.QuantityCRMA = lstDetails.QuantityCRMA; obj.InvoiceLineNo = lstDetails.InvoiceLineNo; return(obj); } }
/// <summary> /// DataListNuggetReadyToReceive /// Calls [usp_datalistnugget_CustomerRMALine_ReadyToReceive] /// </summary> public static List <CustomerRmaLine> DataListNuggetReadyToReceive(System.Int32?clientId, System.Int32?pageIndex, System.Int32?pageSize, System.Int32?orderBy, System.Int32?sortDir, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?salesmanSearch, System.String crmaNotesSearch, System.Int32?invoiceNoLo, System.Int32?invoiceNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.DateTime?customerRmaDateFrom, System.DateTime?customerRmaDateTo, System.Int32?clientSearch, Boolean IsGlobalLogin) { List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.DataListNuggetReadyToReceive(clientId, pageIndex, pageSize, orderBy, sortDir, partSearch, contactSearch, cmSearch, salesmanSearch, crmaNotesSearch, invoiceNoLo, invoiceNoHi, customerRmaNoLo, customerRmaNoHi, customerRmaDateFrom, customerRmaDateTo, clientSearch, IsGlobalLogin); if (lstDetails == null) { return(new List <CustomerRmaLine>()); } else { List <CustomerRmaLine> lst = new List <CustomerRmaLine>(); foreach (CustomerRmaLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine(); obj.CustomerRMAId = objDetails.CustomerRMAId; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.CustomerRMADate = objDetails.CustomerRMADate; obj.CompanyName = objDetails.CompanyName; obj.CompanyNo = objDetails.CompanyNo; obj.InvoiceNumber = objDetails.InvoiceNumber; obj.InvoiceNo = objDetails.InvoiceNo; obj.Quantity = objDetails.Quantity; obj.QuantityReceived = objDetails.QuantityReceived; obj.ROHS = objDetails.ROHS; obj.Part = objDetails.Part; obj.ContactName = objDetails.ContactName; obj.ContactNo = objDetails.ContactNo; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.RowNum = objDetails.RowNum; obj.RowCnt = objDetails.RowCnt; obj.ClientNo = objDetails.ClientNo; obj.ClientName = objDetails.ClientName; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
// [001] code end /// <summary> /// GetListForReceiving /// Calls [usp_selectAll_CustomerRMALine_for_Receiving] /// </summary> public static List <CustomerRmaLine> GetListForReceiving(System.Int32?customerRmaNo) { List <CustomerRmaLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetListForReceiving(customerRmaNo); if (lstDetails == null) { return(new List <CustomerRmaLine>()); } else { List <CustomerRmaLine> lst = new List <CustomerRmaLine>(); foreach (CustomerRmaLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.CustomerRmaLine obj = new Rebound.GlobalTrader.BLL.CustomerRmaLine(); obj.CustomerRMAId = objDetails.CustomerRMAId; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.CustomerRMALineId = objDetails.CustomerRMALineId; obj.CustomerRMADate = objDetails.CustomerRMADate; obj.ReturnDate = objDetails.ReturnDate; obj.ClientNo = objDetails.ClientNo; obj.Notes = objDetails.Notes; obj.Reason = objDetails.Reason; obj.InvoiceNumber = objDetails.InvoiceNumber; obj.InvoiceDate = objDetails.InvoiceDate; obj.InvoiceNo = objDetails.InvoiceNo; obj.InvoiceLineNo = objDetails.InvoiceLineNo; obj.CurrencyNo = objDetails.CurrencyNo; obj.Salesman = objDetails.Salesman; obj.SalesmanName = objDetails.SalesmanName; obj.DivisionNo = objDetails.DivisionNo; obj.TeamNo = objDetails.TeamNo; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; obj.ContactNo = objDetails.ContactNo; obj.ContactName = objDetails.ContactName; obj.Quantity = objDetails.Quantity; obj.QuantityReceived = objDetails.QuantityReceived; obj.QuantityAllocated = objDetails.QuantityAllocated; obj.ProductNo = objDetails.ProductNo; obj.ProductName = objDetails.ProductName; obj.ProductDescription = objDetails.ProductDescription; obj.ProductDutyCode = objDetails.ProductDutyCode; obj.FullPart = objDetails.FullPart; obj.Part = objDetails.Part; obj.CustomerPart = objDetails.CustomerPart; obj.ROHS = objDetails.ROHS; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.ManufacturerName = objDetails.ManufacturerName; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.PackageNo = objDetails.PackageNo; obj.DateCode = objDetails.DateCode; obj.PackageName = objDetails.PackageName; obj.PackageDescription = objDetails.PackageDescription; obj.Price = objDetails.Price; obj.LandedCost = objDetails.LandedCost; obj.LineNotes = objDetails.LineNotes; obj.InvoiceLineAllocationId = objDetails.InvoiceLineAllocationId; obj.QuantityAllocated = objDetails.QuantityAllocated; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// GetForReceiving /// Calls [usp_select_CustomerRMALine_for_Receiving] /// </summary> public static CustomerRmaLine GetForReceiving(System.Int32?customerRmaLineNo) { Rebound.GlobalTrader.DAL.CustomerRmaLineDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLine.GetForReceiving(customerRmaLineNo); if (objDetails == null) { return(null); } else { CustomerRmaLine obj = new CustomerRmaLine(); obj.CustomerRMAId = objDetails.CustomerRMAId; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.CustomerRMALineId = objDetails.CustomerRMALineId; obj.CustomerRMADate = objDetails.CustomerRMADate; obj.ReturnDate = objDetails.ReturnDate; obj.ClientNo = objDetails.ClientNo; obj.Notes = objDetails.Notes; obj.Reason = objDetails.Reason; obj.InvoiceNumber = objDetails.InvoiceNumber; obj.InvoiceDate = objDetails.InvoiceDate; obj.InvoiceNo = objDetails.InvoiceNo; obj.InvoiceLineNo = objDetails.InvoiceLineNo; obj.CurrencyNo = objDetails.CurrencyNo; obj.Salesman = objDetails.Salesman; obj.SalesmanName = objDetails.SalesmanName; obj.DivisionNo = objDetails.DivisionNo; obj.TeamNo = objDetails.TeamNo; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; obj.ContactNo = objDetails.ContactNo; obj.ContactName = objDetails.ContactName; obj.Quantity = objDetails.Quantity; obj.QuantityReceived = objDetails.QuantityReceived; obj.QuantityAllocated = objDetails.QuantityAllocated; obj.ProductNo = objDetails.ProductNo; obj.ProductName = objDetails.ProductName; obj.ProductDescription = objDetails.ProductDescription; obj.ProductDutyCode = objDetails.ProductDutyCode; obj.FullPart = objDetails.FullPart; obj.Part = objDetails.Part; obj.CustomerPart = objDetails.CustomerPart; obj.ROHS = objDetails.ROHS; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.ManufacturerName = objDetails.ManufacturerName; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.PackageNo = objDetails.PackageNo; obj.DateCode = objDetails.DateCode; obj.PackageName = objDetails.PackageName; obj.PackageDescription = objDetails.PackageDescription; obj.Price = objDetails.Price; obj.LandedCost = objDetails.LandedCost; obj.LineNotes = objDetails.LineNotes; obj.InvoiceLineAllocationId = objDetails.InvoiceLineAllocationId; obj.QuantityAllocated = objDetails.QuantityAllocated; obj.Reason1 = objDetails.Reason1; obj.Reason2 = objDetails.Reason2; obj.Reason1Val = objDetails.Reason1Val; obj.Reason2Val = objDetails.Reason2Val; obj.RootCause = objDetails.RootCause; objDetails = null; return(obj); } }