/// <summary>
/// Returns a new CustomerRmaLineDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual CustomerRmaLineDetails GetCustomerRmaLineFromReader(DbDataReader reader)
{
CustomerRmaLineDetails customerRmaLine = new CustomerRmaLineDetails();
if (reader.HasRows)
{
customerRmaLine.CustomerRMALineId = GetReaderValue_Int32(reader, "CustomerRMALineId", 0); //From: [Table]
customerRmaLine.CustomerRMANo = GetReaderValue_Int32(reader, "CustomerRMANo", 0); //From: [Table]
customerRmaLine.InvoiceLineNo = GetReaderValue_Int32(reader, "InvoiceLineNo", 0); //From: [Table]
customerRmaLine.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null); //From: [Table]
customerRmaLine.Reason = GetReaderValue_String(reader, "Reason", ""); //From: [Table]
customerRmaLine.Quantity = GetReaderValue_NullableInt32(reader, "Quantity", null); //From: [usp_select_CustomerRMA]
customerRmaLine.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
customerRmaLine.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
customerRmaLine.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
customerRmaLine.CustomerRMAId = GetReaderValue_Int32(reader, "CustomerRMAId", 0); //From: [Table]
customerRmaLine.CustomerRMANumber = GetReaderValue_Int32(reader, "CustomerRMANumber", 0); //From: [Table]
customerRmaLine.CustomerRMADate = GetReaderValue_DateTime(reader, "CustomerRMADate", DateTime.MinValue); //From: [Table]
customerRmaLine.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_CustomerRMA]
customerRmaLine.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
customerRmaLine.InvoiceNumber = GetReaderValue_Int32(reader, "InvoiceNumber", 0); //From: [usp_itemsearch_CustomerRMA]
customerRmaLine.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null); //From: [Table]
customerRmaLine.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0); //From: [usp_datalistnugget_CustomerRMALine]
customerRmaLine.Part = GetReaderValue_String(reader, "Part", ""); //From: [usp_datalistnugget_CustomerRMALine]
customerRmaLine.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_select_CustomerRMA]
customerRmaLine.ContactNo = GetReaderValue_NullableInt32(reader, "ContactNo", null); //From: [Table]
customerRmaLine.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null); //From: [usp_datalistnugget_CustomerRMALine]
customerRmaLine.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", ""); //From: [usp_datalistnugget_CustomerRMALine]
customerRmaLine.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_itemsearch_CustomerRMA]
customerRmaLine.QuantityReceived = GetReaderValue_NullableInt32(reader, "QuantityReceived", null); //From: [usp_select_CustomerRMA]
customerRmaLine.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_itemsearch_CustomerRMA]
customerRmaLine.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
customerRmaLine.InvoiceDate = GetReaderValue_DateTime(reader, "InvoiceDate", DateTime.MinValue); //From: [usp_select_CustomerRMA]
customerRmaLine.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [usp_select_CustomerRMA]
customerRmaLine.Salesman = GetReaderValue_Int32(reader, "Salesman", 0); //From: [usp_select_CustomerRMA]
customerRmaLine.DivisionNo = GetReaderValue_NullableInt32(reader, "DivisionNo", null); //From: [Table]
customerRmaLine.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.QuantityAllocated = GetReaderValue_NullableInt32(reader, "QuantityAllocated", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.ProductName = GetReaderValue_String(reader, "ProductName", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.ProductDescription = GetReaderValue_String(reader, "ProductDescription", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.ProductDutyCode = GetReaderValue_String(reader, "ProductDutyCode", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.FullPart = GetReaderValue_String(reader, "FullPart", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.CustomerPart = GetReaderValue_String(reader, "CustomerPart", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.DateCode = GetReaderValue_String(reader, "DateCode", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.PackageName = GetReaderValue_String(reader, "PackageName", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.PackageDescription = GetReaderValue_String(reader, "PackageDescription", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.Price = GetReaderValue_NullableDouble(reader, "Price", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.LandedCost = GetReaderValue_NullableDouble(reader, "LandedCost", null); //From: [usp_select_CustomerRMALine]
customerRmaLine.LineNotes = GetReaderValue_String(reader, "LineNotes", ""); //From: [usp_select_CustomerRMALine]
customerRmaLine.InvoiceLineAllocationId = GetReaderValue_Int32(reader, "InvoiceLineAllocationId", 0); //From: [usp_select_CustomerRMALine_for_Receiving]
// [001] code start
customerRmaLine.QuantityShipped = GetReaderValue_NullableInt32(reader, "QuantityShipped", null); //From: [usp_select_CustomerRMA]
customerRmaLine.QuantityCRMA = GetReaderValue_NullableInt32(reader, "QuantityAllocatedToCRMA", null); // from: [usp_select_CustomerRMA]
customerRmaLine.Closed = GetReaderValue_Boolean(reader, "Closed", false); //From: [Table]
// [001] code end
}
return(customerRmaLine);
}
/// <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);
}
}