Esempio n. 1
0
        /// <summary>
        /// Creates a new instance of the Sol_Settings class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual Sol_Setting MakeSol_Setting(SqlDataReader dataReader)
        {
            Sol_Setting sol_Setting = new Sol_Setting();

            sol_Setting.Name        = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
            sol_Setting.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
            sol_Setting.SetValue    = SqlClientUtility.GetObject(dataReader, "SetValue", new object());

            return(sol_Setting);
        }
Esempio n. 2
0
        /// <summary>
        /// Updates a record in the Sol_Settings table.
        /// </summary>
        public virtual void Update(Sol_Setting sol_Setting)
        {
            ValidationUtility.ValidateArgument("sol_Setting", sol_Setting);

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@Name", sol_Setting.Name),
                new SqlParameter("@Description", sol_Setting.Description),
                new SqlParameter("@SetValue", sol_Setting.SetValue)
            };

            SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_Settings_Update", parameters);
        }
Esempio n. 3
0
        /// <summary>
        /// Selects all records from the Sol_Settings table.
        /// </summary>
        public virtual List <Sol_Setting> SelectAll()
        {
            using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_Settings_SelectAll"))
            {
                List <Sol_Setting> sol_SettingList = new List <Sol_Setting>();
                while (dataReader.Read())
                {
                    Sol_Setting sol_Setting = MakeSol_Setting(dataReader);
                    sol_SettingList.Add(sol_Setting);
                }

                return(sol_SettingList);
            }
        }