コード例 #1
0
        public void VerifyCategoryProperties()
        {
            Category category = new Category
            {
                ID = 1,
                Name = "Uncategorised",
                CreatedBy = 1,
                CreatedOn = DateTime.Now,
                ModifiedBy = 1,
                ModifiedOn = DateTime.Now
            };

            Assert.IsNotNull(category);
        }
コード例 #2
0
        public Category GetCategoryByID(int id)
        {
            const string sqlQuery = "SELECT ID, Name, CreatedOn " +
                                    "FROM Category " +
                                    "WHERE ID = @id";
            Category category = new Category();

            using (var reader = DbUtil.ExecuteReader(sqlQuery, new SQLiteParameter("@id", id)))
            {
                if (reader.Read())
                {
                    category = ReadCategory(reader);
                }
                
            }

            return category;
        }