/// <summary>
/// Populates the fields of a single objects from the columns found in an open reader.
/// </summary>
/// <param name="obj" type="BDProduct">Object of BDProduct to populate</param>
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static void PopulateObjectFromReader(BDProductBase obj, IDataReader rdr)
{
obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(BDProductFields.ProductID));
obj.ProductName = rdr.GetString(rdr.GetOrdinal(BDProductFields.ProductName));
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductGroupID)))
{
obj.ProductGroupID = rdr.GetInt32(rdr.GetOrdinal(BDProductFields.ProductGroupID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductCode)))
{
obj.ProductCode = rdr.GetString(rdr.GetOrdinal(BDProductFields.ProductCode));
}
obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsAcceptBatch));
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductPrice)))
{
obj.ProductPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.ProductPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.IsFixedPrice)))
{
obj.IsFixedPrice = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsFixedPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.HasDiscount)))
{
obj.HasDiscount = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.HasDiscount));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.DiscountAmount)))
{
obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.DiscountAmount));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.DescountRatio)))
{
obj.DescountRatio = rdr.GetDouble(rdr.GetOrdinal(BDProductFields.DescountRatio));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.IsActive)))
{
obj.IsActive = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsActive));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.Notes)))
{
obj.Notes = rdr.GetString(rdr.GetOrdinal(BDProductFields.Notes));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.MinPrice)))
{
obj.MinPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.MinPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.MaxPrice)))
{
obj.MaxPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.MaxPrice));
}
}
public static BDProductCollection GetAllProductsForOpenningQuantities(int InventoryID)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.AddParameter("@InventoryID", InventoryID);
IDataReader dr = oDatabaseHelper.ExecuteReader("usp_GetopeningStockLine", ref ExecutionState);
BDProductCollection BDProductCollection = BDProductBase.PopulateObjectsFromReader(dr);
dr.Close();
oDatabaseHelper.Dispose();
return(BDProductCollection);
}
/// <summary>
/// Populates the fields of a single objects from the columns found in an open reader.
/// </summary>
/// <param name="obj" type="BDProduct">Object of BDProduct to populate</param>
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static void PopulateObjectFromReader(BDProductBase obj,IDataReader rdr)
{
obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(BDProductFields.ProductID));
obj.ProductName = rdr.GetString(rdr.GetOrdinal(BDProductFields.ProductName));
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductGroupID)))
{
obj.ProductGroupID = rdr.GetInt32(rdr.GetOrdinal(BDProductFields.ProductGroupID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductCode)))
{
obj.ProductCode = rdr.GetString(rdr.GetOrdinal(BDProductFields.ProductCode));
}
obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsAcceptBatch));
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.ProductPrice)))
{
obj.ProductPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.ProductPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.IsFixedPrice)))
{
obj.IsFixedPrice = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsFixedPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.HasDiscount)))
{
obj.HasDiscount = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.HasDiscount));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.DiscountAmount)))
{
obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.DiscountAmount));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.DescountRatio)))
{
obj.DescountRatio = rdr.GetDouble(rdr.GetOrdinal(BDProductFields.DescountRatio));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.IsActive)))
{
obj.IsActive = rdr.GetBoolean(rdr.GetOrdinal(BDProductFields.IsActive));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.Notes)))
{
obj.Notes = rdr.GetString(rdr.GetOrdinal(BDProductFields.Notes));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.MinPrice)))
{
obj.MinPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.MinPrice));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(BDProductFields.MaxPrice)))
{
obj.MaxPrice = rdr.GetDecimal(rdr.GetOrdinal(BDProductFields.MaxPrice));
}
}
