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