/// <summary> /// Updates the electronics. /// </summary> /// <exception cref="Exception">Unable to fetch electronics category item.</exception> /// <exception cref="System.Exception">Unable to fetch electronics category item.</exception> public static void UpdateElectronics() { List <Category> electronicCategories = new List <Category>(); ICategoryTable categoryTable = TablesProvider.GetCategoryTable(); Category electronics = new Category { Name = "Electronics" }; List <Category> elec_sub = new List <Category>() { { new Category { Name = "Laptops" } }, { new Category { Name = "TVs" } }, { new Category { Name = "CellPhones" } }, { new Category { Name = "PC Periferics" } }, }; electronics.Subcategories = elec_sub; electronicCategories.Add(electronics); electronicCategories.AddRange(elec_sub); InsertCategoryList(electronicCategories); }
/// <summary> /// Updates the home. /// </summary> /// <exception cref="Exception">Unable to fetch home category item.</exception> public static void UpdateHome() { ICategoryTable categoryTable = TablesProvider.GetCategoryTable(); Category home = new Category { Name = "Home" }; List <Category> home_sub = new List <Category>() { { new Category { Name = "Chairs" } }, { new Category { Name = "Tables" } }, { new Category { Name = "Bolts" } }, }; home.Subcategories = home_sub; List <Category> homeCategories = new List <Category>(); homeCategories.Add(home); homeCategories.AddRange(home_sub); InsertCategoryList(homeCategories); }
/// <summary> /// Inserts the category list. /// </summary> /// <param name="list">The list.</param> public static void InsertCategoryList(List <Category> list) { ICategoryTable categoryTable = TablesProvider.GetCategoryTable(); foreach (Category category in list) { try { categoryTable.InsertCategory(category); } catch (Exception) { } } foreach (Category category in list) { try { Category fetched_with_id = categoryTable.FetchCategoryByName(category.Name); Category fetched_sub_with_id = categoryTable.FetchCategoryByName(category.Name); foreach (Category sub_category in category.Subcategories) { categoryTable.InsertSubCategory(fetched_with_id.IdCategory, fetched_sub_with_id.IdCategory); } } catch (Exception) { } } }
/// <summary> /// Gets the available categories. /// </summary> /// <returns>All available categories.</returns> public List <Category> GetAvailableCategories() { ICategoryTable categoryTable = this.tablesProvider.GetCategoryTable(); List <Category> categories = categoryTable.FetchAllCategories(); return(categories); }
public void UpdateHome_ShouldChangeTheListSize() { ICategoryTable categoryTable = tables.GetCategoryTable(); int actual_size = categoryTable.FetchAllCategories().Count; CategoriesUpdater.TablesProvider = tables; CategoriesUpdater.UpdateHome(); int new_size = categoryTable.FetchAllCategories().Count; Assert.NotEqual(actual_size, new_size); }
/// <summary> /// Prevents a default instance of the <see cref="DomainDataStorage"/> class from being created. /// </summary> private DomainDataStorage() { string connectionString = ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString; this.databaseConneection = new MySqlConnection(connectionString); this.auctionTable = this.databaseConneection.As <IAuctionTable>(); this.bidTable = this.databaseConneection.As <IBidTable>(); this.categoryTable = this.databaseConneection.As <ICategoryTable>(); this.currencyTable = this.databaseConneection.As <ICurrencyTable>(); this.personBidderTable = this.databaseConneection.As <IPersonBidderTable>(); this.personMarkTable = this.databaseConneection.As <IPersonMarkTable>(); this.personOfferorTable = this.databaseConneection.As <IPersonOfferorTable>(); this.personTable = this.databaseConneection.As <IPersonTable>(); this.productTable = this.databaseConneection.As <IProductTable>(); }
public CategoryDatabaseValidateService(ICategoryTable categoryTable, IGenderDatabaseValidateService genderDatabaseValidateService) : base(categoryTable) { _genderDatabaseValidateService = genderDatabaseValidateService; }
/// <summary> /// База данных /// </summary> private static Mock <IBoutiqueDatabase> GetDatabase(IGenderTable genderTable, ICategoryTable categoryTable, IClothesTypeTable clothesTypeTable) => new Mock <IBoutiqueDatabase>(). Void(mock => mock.Setup(database => database.GendersTable).Returns(genderTable)). Void(mock => mock.Setup(database => database.CategoryTable).Returns(categoryTable)). Void(mock => mock.Setup(database => database.ClotheTypeTable).Returns(clothesTypeTable));