/// <summary>
        /// Gets the one.
        /// </summary>
        /// <param name="id">The id.</param>
        /// <returns></returns>
        public Category GetOne(int id)
        {
            string sqlStatement = "select * from Categories where CategoryID = @CategoryID";

            var item = new Category();

            using (var conn = this.CreateGlimpseDbConnection())
                using (var command = new GlimpseDbCommand(new SqlCommand()))
                {
                    command.Connection     = conn;
                    command.CommandType    = CommandType.Text;
                    command.CommandTimeout = 180;
                    command.CommandText    = sqlStatement;

                    command.Parameters.Add(new SqlParameter("CategoryID", id));

                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }

                    using (IDataReader reader = command.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            item.CategoryID   = int.Parse(reader["CategoryID"].ToString());
                            item.CategoryName = reader["CategoryName"].ToString();
                            item.Description  = reader["Description"].ToString();
                        }
                    }
                }
            return(item);
        }
        /// <summary>
        /// Unwraps the given command and returns the inner command.
        /// </summary>
        /// <param name="command">The outer command.</param>
        /// <returns>The inner command.</returns>
        public override IDbCommand GetInnerCommand(IDbCommand command)
        {
            if (command == null)
            {
                throw new ArgumentNullException("command");
            }

            GlimpseDbCommand profiledCommand = (GlimpseDbCommand)command;

            return(profiledCommand.InnerCommand);
        }
Example #3
0
        public IDbCommand GenerateCommand(CommandType type, SqlString sqlString, SqlType[] parameterTypes)
        {
            var innerCommand = _innerDriver.GenerateCommand(type, sqlString, parameterTypes);

            if (innerCommand is GlimpseDbCommand)
            {
                return(innerCommand);
            }

            var command = new GlimpseDbCommand(innerCommand as DbCommand);

            return(command);
        }
        /// <summary>
        /// Gets the categories.
        /// </summary>
        /// <returns></returns>
        public List <Category> GetCategories()
        {
            var categories = new List <Category>();

            string sqlStatement = "select * from Categories order by CategoryID desc";

            using (var conn = this.CreateGlimpseDbConnection())
                using (var command = new GlimpseDbCommand(new SqlCommand()))
                {
                    command.Connection     = conn;
                    command.CommandType    = CommandType.Text;
                    command.CommandTimeout = 180;
                    command.CommandText    = sqlStatement;

                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }

                    using (IDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var item = new Category
                            {
                                CategoryID   = int.Parse(reader["CategoryID"].ToString()),
                                CategoryName = reader["CategoryName"].ToString(),
                                Description  = reader["Description"].ToString()
                            };

                            categories.Add(item);
                        }
                    }
                }
            return(categories);
        }