public static void TestRequests(CoreAssembly coreAssembly) { Console.WriteLine(coreAssembly.RequestsFactory.GetMostExpensiveGoodCategory(coreAssembly.MyDataBase)); Console.WriteLine(); foreach (var el in coreAssembly.RequestsFactory.GetOrdersByCustomerWithLongestName(coreAssembly.MyDataBase)) { Console.WriteLine(el); } Console.WriteLine(); Console.WriteLine(coreAssembly.RequestsFactory.GetLeastSellsCity(coreAssembly.MyDataBase)); Console.WriteLine(); foreach (var lastName in coreAssembly.RequestsFactory.GetCustomersLastNameWhoBoughtMostPopularGood( coreAssembly .MyDataBase)) { Console.WriteLine(lastName); } Console.WriteLine(); Console.WriteLine( coreAssembly.RequestsFactory.GetShopsAmountInCountryWithLeastAmountOfShops(coreAssembly.MyDataBase)); Console.WriteLine(); foreach (var order in coreAssembly.RequestsFactory.GetOrdersInForeignCity(coreAssembly.MyDataBase)) { Console.WriteLine(order); } Console.WriteLine(); Console.WriteLine(coreAssembly.RequestsFactory.GetAllOrdersSum(coreAssembly.MyDataBase)); }
public static void SerializeAll(CoreAssembly coreAssembly, string prefix = "") { coreAssembly.MyDataBase.Serialize <Good>(prefix); coreAssembly.MyDataBase.Serialize <Shop>(prefix); coreAssembly.MyDataBase.Serialize <Customer>(prefix); coreAssembly.MyDataBase.Serialize <Order>(prefix); }
public static void FillFromJSON(CoreAssembly coreAssembly) { coreAssembly.MyDataBase.ClearAll(); coreAssembly.MyDataBase.RestoreDataTable <Shop>(); coreAssembly.MyDataBase.RestoreDataTable <Good>(); coreAssembly.MyDataBase.RestoreDataTable <Customer>(); coreAssembly.MyDataBase.RestoreDataTable <Order>(); //checkit SerializeAll(coreAssembly, "_TestCheck"); }
public static void Main(string[] args) { CoreAssembly coreAssembly = new CoreAssembly(); /* * FillSamples(coreAssembly); * coreAssembly.MyDataBase.ClearAll(); * FillFromJSON(coreAssembly); * TestRequests(coreAssembly); * Console.WriteLine();*/ ConsoleManager manager = new ConsoleManager(coreAssembly.CorrectnessChecker, coreAssembly.MyDataBase, coreAssembly.RequestsFactory, coreAssembly.DataBaseContentChecker); manager.StartSession(); }
public static void FillSamples(CoreAssembly coreAssembly) { coreAssembly.MyDataBase.CreateTable <Shop>(); coreAssembly.MyDataBase.CreateTable <Good>(); coreAssembly.MyDataBase.CreateTable <Customer>(); coreAssembly.MyDataBase.CreateTable <Order>(); coreAssembly.MyDataBase.InsertInto <Shop>(new ShopFactory("Shop1", "city1", "country1", "phone1")); coreAssembly.MyDataBase.InsertInto <Shop>(new ShopFactory("Shop2", "city2", "country2", "phone2")); coreAssembly.MyDataBase.InsertInto <Shop>(new ShopFactory("Shop3", "city3", "country2", "phone3")); coreAssembly.MyDataBase.InsertInto <Shop>(new ShopFactory("Shop4", "city4", "country2", "phone4")); coreAssembly.MyDataBase.InsertInto <Shop>(new ShopFactory("Shop5", "city5", "country1", "phone5")); coreAssembly.MyDataBase.InsertInto <Good>(new GoodFactory("good1", "desc1", "category1")); coreAssembly.MyDataBase.InsertInto <Good>(new GoodFactory("good2", "desc2", "category2")); coreAssembly.MyDataBase.InsertInto <Customer>(new CustomerFactory("customer1", "lastName1", "address1", "district1", "city1", "country1", "postalIndex1")); coreAssembly.MyDataBase.InsertInto <Customer>(new CustomerFactory("customer22", "lastName2", "address2", "district2", "city2", "country2", "postalIndex2")); coreAssembly.MyDataBase.InsertInto <Customer>(new CustomerFactory("customer3", "lastName3", "address3", "district3", "city3", "country3", "postalIndex3")); coreAssembly.MyDataBase.InsertInto <Order>(new OrderFactory(1, 0, 0, 3, 3)); coreAssembly.MyDataBase.InsertInto <Order>(new OrderFactory(0, 0, 0, 3, 20)); coreAssembly.MyDataBase.InsertInto <Order>(new OrderFactory(1, 1, 1, 5, 3)); coreAssembly.MyDataBase.InsertInto <Order>(new OrderFactory(2, 0, 0, 10, 3)); SerializeAll(coreAssembly); }