public void DatabaseStateTest() { StoreService = StorageService.GetInstance(); var purchase = new Purchase { Date = DateTime.Now, Id = 0, ItemCost = 10.4, ItemsNumber = 135.2, TotalCost = 1406.08, IsMonthly = true, Name = "Cote d'Azure apple", PurchaseComment = "Воно чудо'ве", PurchaseRate = 10, StoreComment = "Цікави'й магазин", StoreName = "Нову'с магазин", StoreRate = 5, Type = new ProductType { Name = "Їжа", Id = 0 }, SubType = new ProductSubType { Name = "Фрукт", Id = 0 } }; var purchase2 = new Purchase { Date = DateTime.Now, Id = 0, ItemCost = 17.5, ItemsNumber = 544, TotalCost = 9520, IsMonthly = false, Name = "Ozone Mantra M6", PurchaseComment = "Це палапрал", PurchaseRate = 8, StoreComment = "Завжди тут беру", StoreName = "Від Перевалова", StoreRate = 7, Type = new ProductType { Name = "Спорядження", Id = 0 }, SubType = new ProductSubType { Name = "Льотне спорядження", Id = 0 } }; var purchase3 = new Purchase { Date = DateTime.Now, Id = 0, ItemCost = 234, ItemsNumber = 53, TotalCost = 12402, IsMonthly = true, Name = "Помаранч", PurchaseComment = "Нічотак", PurchaseRate = 9, StoreComment = "Зайшов після роботи", StoreName = "Фора", StoreRate = 6, Type = new ProductType { Name = "Їжа", Id = 0 }, SubType = new ProductSubType { Name = "Фрукт", Id = 0 } }; var purchase4 = new Purchase { Date = DateTime.Now, Id = 0, ItemCost = 1, ItemsNumber = 2, TotalCost = 2, IsMonthly = false, Name = "Груша", Type = new ProductType { Name = "Їжа", Id = 0 } }; //Cleanup Assert.IsTrue(StoreService.DeletePurchase(purchase.Name).Result, "Cleanup failed"); Assert.IsTrue(StoreService.DeletePurchase(purchase2.Name).Result, "Cleanup failed"); Assert.IsTrue(StoreService.DeletePurchase(purchase3.Name).Result, "Cleanup failed"); Assert.IsTrue(StoreService.DeletePurchase(purchase4.Name).Result, "Cleanup failed"); var foundListPre = StoreService.LoadPurchaseList(SearchRequestModel.Requests.Empty).Result; //Save test purchase = StoreService.AddPurchase(purchase).Result; Assert.IsNotNull(purchase, "Purchase saving error"); purchase2 = StoreService.AddPurchase(purchase2).Result; Assert.IsNotNull(purchase, "Purchase saving error"); purchase3 = StoreService.AddPurchase(purchase3).Result; Assert.IsNotNull(purchase, "Purchase saving error"); purchase4 = StoreService.AddPurchase(purchase4).Result; Assert.IsNotNull(purchase, "Purchase saving error"); //read test var searchRequest = new SearchRequestModel { Name = purchase.Name, SearchByName = true }; var searchRequest2 = new SearchRequestModel { Name = purchase2.Name, SearchByName = true }; var searchRequest3 = new SearchRequestModel { Name = purchase3.Name, SearchByName = true }; var searchRequest4 = new SearchRequestModel { Name = purchase4.Name, SearchByName = true }; var foundList = StoreService.LoadPurchaseList(searchRequest).Result; Assert.IsTrue(foundList.Count == 1, "Purchase storage error: records duplicating found"); var controlPurchase = foundList.FirstOrDefault(); Assert.IsTrue(controlPurchase.DeepEquals(purchase), "Purchase storage error: not consistent"); var foundList2 = StoreService.LoadPurchaseList(searchRequest2).Result; Assert.IsTrue(foundList2.Count == 1, "Purchase storage error: records duplicating found"); var controlPurchase2 = foundList2.FirstOrDefault(); Assert.IsTrue(controlPurchase2.DeepEquals(purchase2), "Purchase storage error: not consistent"); var foundList3 = StoreService.LoadPurchaseList(searchRequest3).Result; Assert.IsTrue(foundList3.Count == 1, "Purchase storage error: records duplicating found"); var controlPurchase3 = foundList3.FirstOrDefault(); Assert.IsTrue(controlPurchase3.DeepEquals(purchase3), "Purchase storage error: not consistent"); var foundList4 = StoreService.LoadPurchaseList(searchRequest4).Result; Assert.IsTrue(foundList4.Count == 1, "Purchase storage error: records duplicating found"); var controlPurchase4 = foundList4.FirstOrDefault(); Assert.IsTrue(controlPurchase4.DeepEquals(purchase4), "Purchase storage error: not consistent"); //update test purchase.IsMonthly = false; purchase.Name = "Звичайне яблуко"; purchase = StoreService.AddPurchase(purchase).Result; Assert.IsTrue(purchase != null, "Purchase saving error"); //repeated read test var controlPurchase_repeat = StoreService.LoadPurchase(controlPurchase.Id).Result; Assert.IsTrue(controlPurchase_repeat.DeepEquals(purchase), "Purchase storage error: not consistent"); //delete test Assert.IsTrue(StoreService.DeletePurchase(purchase).Result, "Purchase deletion error"); var deletedPurchase = StoreService.LoadPurchase(purchase.Id).Result; Assert.IsNull(deletedPurchase, "Purchase deletion error: not deleted"); }