/// <summary> /// Populates the fields of a single objects from the columns found in an open reader. /// </summary> /// <param name="obj" type="VSALSalesOrder">Object of VSALSalesOrder to populate</param> /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/19/2015 1:00:17 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static void PopulateObjectFromReader(VSALSalesOrderBase obj, IDataReader rdr) { obj.CustomerID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.CustomerID)); obj.CustomerName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.CustomerName)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.Qty))) { obj.Qty = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.Qty)); } obj.SalesLineID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.SalesLineID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.TotalQty)); obj.UnitPrice = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.UnitPrice)); obj.BatchNumber = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.BatchNumber)); obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.ExpiryDate)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.TaxValue))) { obj.TaxValue = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.TaxValue)); } obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.SalesHeaderID)); obj.SalesDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.SalesDate)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceNumber))) { obj.InvoiceNumber = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceNumber)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceDate))) { obj.InvoiceDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceDate)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.PaymentTypeID))) { obj.PaymentTypeID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.PaymentTypeID)); } obj.TotalDiscountRatio = rdr.GetDouble(rdr.GetOrdinal(VSALSalesOrderFields.TotalDiscountRatio)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.TaxTypeName))) { obj.TaxTypeName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.TaxTypeName)); } obj.IsClosed = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsClosed)); obj.IsVoid = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsVoid)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.FinalPrice))) { obj.FinalPrice = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.FinalPrice)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.ChequeNumber))) { obj.ChequeNumber = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.ChequeNumber)); } obj.ProductName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.ProductName)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.ProductCode))) { obj.ProductCode = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.ProductCode)); } obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsAcceptBatch)); obj.UserFullName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.UserFullName)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.ProductID)); }
private static void PopulateObjectFromReader(VSALSalesOrderBase obj, IDataReader rdr) { obj.CustomerID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.CustomerID)); obj.CustomerName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.CustomerName)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.Qty))) { obj.Qty = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.Qty)); } obj.SalesLineID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.SalesLineID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.TotalQty)); obj.UnitPrice = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.UnitPrice)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.BatchNumber))) { obj.BatchNumber = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.BatchNumber)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.ExpiryDate))) { obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.ExpiryDate)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.TaxValue))) { obj.TaxValue = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.TaxValue)); } obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.SalesHeaderID)); obj.SalesDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.SalesDate)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceNumber))) { obj.InvoiceNumber = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceNumber)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceDate))) { obj.InvoiceDate = rdr.GetDateTime(rdr.GetOrdinal(VSALSalesOrderFields.InvoiceDate)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.PaymentTypeID))) { obj.PaymentTypeID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.PaymentTypeID)); } obj.TotalDiscountRatio = rdr.GetDouble(rdr.GetOrdinal(VSALSalesOrderFields.TotalDiscountRatio)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.TaxTypeName))) { obj.TaxTypeName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.TaxTypeName)); } obj.IsClosed = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsClosed)); obj.IsVoid = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsVoid)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.FinalPrice))) { obj.FinalPrice = rdr.GetDecimal(rdr.GetOrdinal(VSALSalesOrderFields.FinalPrice)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.ChequeNumber))) { obj.ChequeNumber = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.ChequeNumber)); } obj.ProductName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.ProductName)); if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.ProductCode))) { obj.ProductCode = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.ProductCode)); } if (!rdr.IsDBNull(rdr.GetOrdinal(VSALSalesOrderFields.IsAcceptBatch))) { obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal(VSALSalesOrderFields.IsAcceptBatch)); } obj.UserFullName = rdr.GetString(rdr.GetOrdinal(VSALSalesOrderFields.UserFullName)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(VSALSalesOrderFields.ProductID)); }