/// <summary> /// Returns a new CustomerRmaLineAllocationDetails instance filled with the DataReader's current record data /// </summary> protected virtual CustomerRmaLineAllocationDetails GetCustomerRmaLineAllocationFromReader(DbDataReader reader) { CustomerRmaLineAllocationDetails customerRmaLineAllocation = new CustomerRmaLineAllocationDetails(); if (reader.HasRows) { customerRmaLineAllocation.CustomerRMALineAllocationId = GetReaderValue_Int32(reader, "CustomerRMALineAllocationId", 0); //From: [Table] customerRmaLineAllocation.CustomerRMALineNo = GetReaderValue_Int32(reader, "CustomerRMALineNo", 0); //From: [Table] customerRmaLineAllocation.InvoiceLineAllocationNo = GetReaderValue_Int32(reader, "InvoiceLineAllocationNo", 0); //From: [Table] customerRmaLineAllocation.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); //From: [usp_select_CustomerRMA] customerRmaLineAllocation.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null); //From: [Table] customerRmaLineAllocation.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] customerRmaLineAllocation.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] customerRmaLineAllocation.CustomerRMAId = GetReaderValue_Int32(reader, "CustomerRMAId", 0); //From: [Table] customerRmaLineAllocation.CustomerRMANumber = GetReaderValue_Int32(reader, "CustomerRMANumber", 0); //From: [Table] customerRmaLineAllocation.CustomerRMADate = GetReaderValue_DateTime(reader, "CustomerRMADate", DateTime.MinValue); //From: [Table] customerRmaLineAllocation.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null); //From: [Table] customerRmaLineAllocation.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] customerRmaLineAllocation.Reason = GetReaderValue_String(reader, "Reason", ""); //From: [Table] customerRmaLineAllocation.InvoiceNumber = GetReaderValue_Int32(reader, "InvoiceNumber", 0); //From: [usp_itemsearch_CustomerRMA] customerRmaLineAllocation.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null); //From: [Table] customerRmaLineAllocation.InvoiceLineNo = GetReaderValue_Int32(reader, "InvoiceLineNo", 0); //From: [Table] customerRmaLineAllocation.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table] customerRmaLineAllocation.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_CustomerRMA] customerRmaLineAllocation.PurchaseOrderLineNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineNo", null); //From: [usp_selectAll_CustomerRMALineAllocation_for_PurchaseOrderLine] customerRmaLineAllocation.AuthorisedBy = GetReaderValue_Int32(reader, "AuthorisedBy", 0); //From: [Table] customerRmaLineAllocation.AuthoriserName = GetReaderValue_String(reader, "AuthoriserName", ""); //From: [usp_itemsearch_CustomerRMA] customerRmaLineAllocation.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null); //From: [usp_selectAll_CustomerRMALineAllocation_for_PurchaseOrderLine] } return(customerRmaLineAllocation); }
/// <summary> /// Get /// Calls [usp_select_CustomerRMALineAllocation] /// </summary> public static CustomerRmaLineAllocation Get(System.Int32?customerRmaLineAllocationId) { Rebound.GlobalTrader.DAL.CustomerRmaLineAllocationDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRmaLineAllocation.Get(customerRmaLineAllocationId); if (objDetails == null) { return(null); } else { CustomerRmaLineAllocation obj = new CustomerRmaLineAllocation(); obj.CustomerRMALineAllocationId = objDetails.CustomerRMALineAllocationId; obj.CustomerRMALineNo = objDetails.CustomerRMALineNo; obj.InvoiceLineAllocationNo = objDetails.InvoiceLineAllocationNo; obj.Quantity = objDetails.Quantity; obj.GoodsInLineNo = objDetails.GoodsInLineNo; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; objDetails = null; return(obj); } }