/// <summary> /// Creates a new instance of the sol_Products class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Product MakeSol_Product(SqlDataReader dataReader) { Sol_Product sol_Product = new Sol_Product(); sol_Product.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0); sol_Product.ProName = SqlClientUtility.GetString(dataReader, "ProName", String.Empty); sol_Product.ProDescription = SqlClientUtility.GetString(dataReader, "ProDescription", String.Empty); sol_Product.ProShortDescription = SqlClientUtility.GetString(dataReader, "ProShortDescription", String.Empty); sol_Product.ProImage = SqlClientUtility.GetBytes(dataReader, "ProImage", new byte[0]); sol_Product.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0); sol_Product.MenuOrder = SqlClientUtility.GetInt32(dataReader, "MenuOrder", 0); sol_Product.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false); sol_Product.Price = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero); sol_Product.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0); sol_Product.RefundAmount = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero); sol_Product.HandlingCommissionAmount = SqlClientUtility.GetDecimal(dataReader, "HandlingCommissionAmount", Decimal.Zero); sol_Product.CommissionUnit = SqlClientUtility.GetInt32(dataReader, "CommissionUnit", 0); sol_Product.VafAmount = SqlClientUtility.GetDecimal(dataReader, "VafAmount", Decimal.Zero); sol_Product.FeeUnit = SqlClientUtility.GetInt32(dataReader, "FeeUnit", 0); sol_Product.ContainerID = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0); sol_Product.StandardDozenID = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0); sol_Product.UPC = SqlClientUtility.GetString(dataReader, "UPC", String.Empty); sol_Product.ProductCode = SqlClientUtility.GetString(dataReader, "ProductCode", String.Empty); sol_Product.TypeId = SqlClientUtility.GetByte(dataReader, "TypeId", 0x00); sol_Product.Tax1Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax1Exempt", false); sol_Product.Tax2Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax2Exempt", false); sol_Product.MasterProductID = SqlClientUtility.GetInt32(dataReader, "MasterProductID", 0); sol_Product.Weight = SqlClientUtility.GetDecimal(dataReader, "Weight", Decimal.Zero); sol_Product.Volume = SqlClientUtility.GetDecimal(dataReader, "Volume", Decimal.Zero); sol_Product.TargetQuantity = SqlClientUtility.GetInt32(dataReader, "TargetQuantity", 0); return(sol_Product); }
/// <summary> /// Creates a new instance of the Sac_Settings class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_Setting MakeSac_Setting(SqlDataReader dataReader) { Sac_Setting sac_Setting = new Sac_Setting(); sac_Setting.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sac_Setting.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sac_Setting.SetValue = SqlClientUtility.GetBytes(dataReader, "SetValue", new byte[0]); return(sac_Setting); }
/// <summary> /// Creates a new instance of the Sac_Charity class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_Charity MakeSac_Charity(SqlDataReader dataReader) { Sac_Charity sac_Charity = new Sac_Charity(); sac_Charity.CharityID = SqlClientUtility.GetInt32(dataReader, "CharityID", 0); sac_Charity.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0); sac_Charity.ShortName = SqlClientUtility.GetString(dataReader, "ShortName", String.Empty); sac_Charity.CharityDescription = SqlClientUtility.GetString(dataReader, "CharityDescription", String.Empty); sac_Charity.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0); sac_Charity.RegistrationNumber = SqlClientUtility.GetString(dataReader, "RegistrationNumber", String.Empty); sac_Charity.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false); sac_Charity.ButtonPosition = SqlClientUtility.GetByte(dataReader, "ButtonPosition", 0x00); sac_Charity.Logo = SqlClientUtility.GetBytes(dataReader, "Logo", new byte[0]); return(sac_Charity); }