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