/// <summary> /// Get /// Calls [usp_select_Lot] /// </summary> public static Lot Get(System.Int32?lotId) { Rebound.GlobalTrader.DAL.LotDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Lot.Get(lotId); if (objDetails == null) { return(null); } else { Lot obj = new Lot(); obj.LotId = objDetails.LotId; obj.ClientNo = objDetails.ClientNo; obj.LotName = objDetails.LotName; obj.Cost = objDetails.Cost; obj.CurrencyNo = objDetails.CurrencyNo; obj.OnHold = objDetails.OnHold; obj.Consignment = objDetails.Consignment; obj.Notes = objDetails.Notes; obj.LotCode = objDetails.LotCode; obj.Inactive = objDetails.Inactive; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.CurrencyCode = objDetails.CurrencyCode; obj.CurrencyDescription = objDetails.CurrencyDescription; obj.LockForCustomerNo = objDetails.LockForCustomerNo; obj.LockForCustomer = objDetails.LockForCustomer; objDetails = null; return(obj); } }
/// <summary> /// GetForPage /// Calls [usp_select_Lot_for_Page] /// </summary> public static Lot GetForPage(System.Int32?lotId) { Rebound.GlobalTrader.DAL.LotDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Lot.GetForPage(lotId); if (objDetails == null) { return(null); } else { Lot obj = new Lot(); obj.LotId = objDetails.LotId; obj.LotName = objDetails.LotName; obj.ClientNo = objDetails.ClientNo; obj.Inactive = objDetails.Inactive; objDetails = null; return(obj); } }
/// <summary> /// Returns a new LotDetails instance filled with the DataReader's current record data /// </summary> protected virtual LotDetails GetLotFromReader(DbDataReader reader) { LotDetails lot = new LotDetails(); if (reader.HasRows) { lot.LotId = GetReaderValue_Int32(reader, "LotId", 0); //From: [Table] lot.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] lot.LotName = GetReaderValue_String(reader, "LotName", ""); //From: [usp_select_GoodsInLine] lot.Cost = GetReaderValue_NullableDouble(reader, "Cost", null); //From: [usp_selectAll_Login_Top_Salespersons] lot.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine] lot.OnHold = GetReaderValue_Boolean(reader, "OnHold", false); //From: [Table] lot.Consignment = GetReaderValue_Boolean(reader, "Consignment", false); //From: [Table] lot.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] lot.LotCode = GetReaderValue_String(reader, "LotCode", ""); //From: [Table] lot.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] lot.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] lot.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] lot.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_list_Activity_by_Client_with_filter] lot.StockCount = GetReaderValue_NullableInt32(reader, "StockCount", null); //From: [usp_datalistnugget_Lot] lot.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_list_Activity_by_Client_with_filter] lot.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Client] } return lot; }