public void WithBookTest() { using (LibraryDb db = LibraryDb.GetDbContext()) { BOOK book = new BOOK { ISBN = "test", COUNT = 0, NAME = "test", PRICE = 0 }; using (DbManager <BOOK> manager = new DbManager <BOOK>(new ManagerBook(), book)) { manager.AddNewRow(); BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID); Assert.IsNotNull(dbBook); //Change book test dbBook.DESCRIPTION = someText; manager.Entity = dbBook; manager.UpdateRow(); dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID); Assert.AreEqual(true, dbBook?.DESCRIPTION == someText); //deleted test book manager.RemoveRow(); dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID); Assert.IsNull(dbBook); } } }
public void WithViewerTest() { using (LibraryDb db = LibraryDb.GetDbContext()) { VIEWER viewer = new VIEWER { ADDRESS = "test", EMAIL = "*****@*****.**", NAME = "test", PHONE = "testtest" }; using (DbManager <VIEWER> manager = new DbManager <VIEWER>(new ManagerViewer(), viewer)) { //add viewer test manager.AddNewRow(); VIEWER dbViewer = db.VIEWERS.SingleOrDefault(v => v.ID == viewer.ID); Assert.IsNotNull(dbViewer); //Change VIEWER test dbViewer.MIDDLE_NAME = someText; manager.Entity = dbViewer; manager.UpdateRow(); dbViewer = db.VIEWERS.SingleOrDefault(b => b.ID == viewer.ID); Assert.AreEqual(true, dbViewer?.MIDDLE_NAME == someText); //deleted test VIEWER manager.RemoveRow(); dbViewer = db.VIEWERS.SingleOrDefault(b => b.ID == viewer.ID); Assert.IsNull(dbViewer); } } }
private void BtnAddedViewer_OnClick(object sender, RoutedEventArgs e) { try { Logger.Info("Getting started: BtnAddedViewer_OnClick"); VIEWER viewer = GetWindowFields(); ThreadPool.QueueUserWorkItem(obj => { Manager.Entity = viewer; Manager.AddNewRow(); if (Manager.IsOk) { this.GuiSync(Close); } }); } catch (Exception ex) { Logger.Error(ex); MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error); } }