public IEnumerable <string> GetCategoryNames() { List <string> categNames = new List <string>(); var categs = _categoryDal.GetAll(); foreach (Category categ in categs) { categNames.Add(categ.Name); } return(categNames); }
public void TestMethod4() { List <Category> categoryList = categoryDal.GetAll(); int result = categoryList.Count; Assert.AreEqual(7, result); }
public void ChooseActionForCategories() { CategoryDal categoryDal = new CategoryDal(); Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n"); Console.WriteLine("What action you want to choose?\n" + "1. View all categories\n" + "2. Get category by Id\n" + "3. Get category by name of column\n" + "4. Add category\n" + "5. Edit info about category\n" + "6. Delete category by Id\n" + "7. Delete category by name of column\n" + "8. Back to start menu"); Console.Write("\nYour selection: "); string ch = Console.ReadLine(); switch (ch) { case "1": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n"); categoryDal.PrintListOfCategories(categoryDal.GetAll()); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "2": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\nId: "); int id = Convert.ToInt32(Console.ReadLine()); categoryDal.PrintCategory(categoryDal.GetById(id)); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "3": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n"); Console.WriteLine("Name of column: "); string fieldName = Console.ReadLine(); Console.WriteLine("\nValue: "); string text = Console.ReadLine(); categoryDal.PrintListOfCategories(categoryDal.GetByFieldName(fieldName, text)); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "4": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n"); Console.WriteLine("NAME: "); string name = Console.ReadLine(); Console.WriteLine("DESCRIPTION: "); string desc = Console.ReadLine(); Category category = new Category(name, desc); categoryDal.Insert(category); Console.WriteLine("Category succesfully inserted :)"); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "5": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n"); Console.WriteLine("Name of column (set): "); string fieldName = Console.ReadLine(); Console.WriteLine("Value (set): "); string text = Console.ReadLine(); Console.WriteLine("Name of column (condition): "); string fieldCondition = Console.ReadLine(); Console.WriteLine("Value (condition): "); string textCondition = Console.ReadLine(); categoryDal.UpdateByFieldName(fieldName, text, fieldCondition, textCondition); Console.WriteLine("Category succesfully updated :)"); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "6": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\nId: "); int id = Convert.ToInt32(Console.ReadLine()); categoryDal.DeleteById(id); Console.WriteLine("Category succesfully deleted :)"); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "7": { try { Console.Clear(); Console.WriteLine("TABLE: CATEGORIES\n\n "); Console.WriteLine("Name of column (condition): "); string fieldCondition = Console.ReadLine(); Console.WriteLine("Value (condition): "); string textCondition = Console.ReadLine(); categoryDal.DeleteByFieldName(fieldCondition, textCondition); Console.WriteLine("Category succesfully deleted :)"); Console.ReadKey(); break; } finally { Menu menu = new Menu(); menu.ChooseActionForCategories(); } } case "8": { Menu menu = new Menu(); menu.ChooseTable(); break; } default: Console.WriteLine("Invalid selection. Please select 1, 2, 3, 4, 5, 6, 7 or 8."); break; } }
public IList<Category> GetAllCache() { IList<Category> cache = Common.BuildCache<IList<Category>>.Default.Get(this.CategoryAllCacheKey); if (cache == null) { using (CategoryDal dal = new CategoryDal()) { cache = dal.GetAll(); if (cache != null) { lock (this.lockCategory) { Common.BuildCache<IList<Category>>.Default.Cache(this.CategoryAllCacheKey, cache); } } } } return cache; }