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