/// <summary> /// Populates the fields of a single objects from the columns found in an open reader. /// </summary> /// <param name="obj" type="SALSalesLine">Object of SALSalesLine to populate</param> /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:03 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static void PopulateObjectFromReader(SALSalesLineBase obj, IDataReader rdr) { obj.SalesLineID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesLineID)); obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalQty)); obj.TotalBonus = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalBonus)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount))) { obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount)); } obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountRatio)); obj.UnitPrice = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.UnitPrice)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreatedBy))) { obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.CreatedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreateDate))) { obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.CreateDate)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy))) { obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdateDate))) { obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.UpdateDate)); } obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesLineFields.IsDeleted)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeletedBy))) { obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.DeletedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeleteDate))) { obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.DeleteDate)); } }
/// <summary> /// Populates the fields of a single objects from the columns found in an open reader. /// </summary> /// <param name="obj" type="SALSalesLine">Object of SALSalesLine 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:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static void PopulateObjectFromReader(SALSalesLineBase obj,IDataReader rdr) { obj.SalesLineID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesLineID)); obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.SalesHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalQty)); obj.TotalBonus = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.TotalBonus)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount))) { obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountAmount)); } obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.DiscountRatio)); obj.UnitPrice = rdr.GetDecimal(rdr.GetOrdinal(SALSalesLineFields.UnitPrice)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreatedBy))) { obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.CreatedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.CreateDate))) { obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.CreateDate)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy))) { obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.UpdatedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.UpdateDate))) { obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.UpdateDate)); } obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesLineFields.IsDeleted)); if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeletedBy))) { obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesLineFields.DeletedBy)); } if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesLineFields.DeleteDate))) { obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesLineFields.DeleteDate)); } }