/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of INVProductStockCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:07 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static INVProductStockCollection PopulateObjectsFromReader(IDataReader rdr) { INVProductStockCollection list = new INVProductStockCollection(); while (rdr.Read()) { INVProductStock obj = new INVProductStock(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } return(list); }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of INVProductStockCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:07 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static INVProductStockCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { INVProductStockCollection list = new INVProductStockCollection(); if (rdr.Read()) { INVProductStock obj = new INVProductStock(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new INVProductStock(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return(list); } else { oDatabaseHelper.Dispose(); return(null); } }
private static INVProductStockCollection Fill(IDataReader dr, bool getWithBatch) { INVProductStockCollection collection = new INVProductStockCollection(); while (dr.Read()) { INVProductStock obj = new INVProductStock(); obj.ProductStockID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.ProductStockID)); obj.ProductID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.ProductID)); obj.TotalQty = dr.GetDecimal(dr.GetOrdinal(ALLINVProductStockFields.TotalQty)); obj.StockTypeID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.StockTypeID)); obj.ProductName = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.ProductName)); obj.StockType = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.StockTypeName)); if (!dr.IsDBNull(dr.GetOrdinal(ALLINVProductStockFields.ProductCode))) { obj.ProductCode = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.ProductCode)); } if (dr.GetOrdinal("IsAcceptBatch") != null) { obj.IsAcceptBatch = dr.GetBoolean(dr.GetOrdinal("IsAcceptBatch")); } if (getWithBatch) { if (dr.GetOrdinal(ALLINVProductStockFields.BatchNumber) != null) { obj.BatchNo = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.BatchNumber)); } if (dr.GetOrdinal(ALLINVProductStockFields.ExpiryDate) != null) { obj.ExpiryDate = dr.GetDateTime(dr.GetOrdinal(ALLINVProductStockFields.ExpiryDate)); } if (dr.GetOrdinal(ALLINVProductStockFields.BatchQty) != null) { obj.BatchQty = dr.GetDecimal(dr.GetOrdinal(ALLINVProductStockFields.BatchQty)); } } collection.Add(obj); } return(collection); }