public void OrderGetAll() { DataBase dataBase = new DataBase(); string itemTypeName = Guid.NewGuid().ToString(); ItemType itemType = new ItemType {Name = itemTypeName,}; dataBase.ItemTypeInsert(itemType); ItemType itemTypeGet = dataBase.ItemTypeGet(itemTypeName); Assert.IsNotNull(itemTypeGet); string itemName = Guid.NewGuid().ToString(); Item item = new Item { Name = itemName, ItemTypeId = itemTypeGet.Id, }; dataBase.ItemInsert(item); Item itemGet = dataBase.ItemGet(itemName); Assert.IsNotNull(itemGet); string itemStatusName = Guid.NewGuid().ToString(); ItemStatus itemStatus = new ItemStatus {Name = itemStatusName}; dataBase.ItemStatusInsert(itemStatus); ItemStatus itemStatusGet = dataBase.ItemStatusGet(itemStatusName); Assert.IsNotNull(itemStatusGet); string personInfoName = Guid.NewGuid().ToString(); string personInfoSurName = Guid.NewGuid().ToString(); PersonInfo personInfo = new PersonInfo {Name = personInfoName, SurName = personInfoSurName,}; dataBase.PersonInfoInsert(personInfo); PersonInfo personInfoGet = dataBase.PersonInfoGet(personInfoName, personInfoSurName); Assert.IsNotNull(personInfoGet); Order order = new Order { ItemId = itemGet.Id, Count = 1, ItemStatusId = itemStatusGet.Id, LegalEntity = true, PersonInfoId = personInfoGet.Id, Postage = 0M.DecimalToString(), Price = 1M.DecimalToString(), BankId = -1, }; int rowsInserted = dataBase.OrderInsert(order); Assert.AreEqual(1, rowsInserted); List<Order> orders = dataBase.OrderGetAll(); Assert.IsNotNull(orders); Order find = orders.Find(o => o.ItemId == itemGet.Id); Assert.IsNotNull(find); }