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);
}
}
}
public static void UpdateBook(BOOK book, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
if (book == null)
{
throw new ArgumentNullException($"book: {nameof(book)}");
}
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
if (dbBook == null)
{
throw new Exception($"Книга с {book.ID} не найдена!");
}
dbBook.ISBN = book.ISBN;
dbBook.NAME = book.NAME;
dbBook.AUTHOR = book.AUTHOR;
dbBook.PUBLISHING = book.PUBLISHING;
dbBook.COUNT = book.COUNT;
dbBook.STATUS = book.STATUS;
dbBook.PRICE = book.PRICE;
dbBook.DESCRIPTION = book.DESCRIPTION;
db.SaveChanges();
transaction.Complete();
}
}
}
public static void UpdateViewer(VIEWER viewer, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
if (viewer == null)
{
throw new ArgumentNullException($"book: {nameof(viewer)}");
}
VIEWER dbViewer = db.VIEWERS.SingleOrDefault(v => v.ID == viewer.ID);
if (dbViewer == null)
{
throw new Exception($"Книга с {viewer.ID} не найдена!");
}
dbViewer.NAME = viewer.NAME;
dbViewer.SURNAME = viewer.SURNAME;
dbViewer.MIDDLE_NAME = viewer.MIDDLE_NAME;
dbViewer.ADDRESS = viewer.ADDRESS;
dbViewer.PHONE = viewer.PHONE;
dbViewer.EMAIL = viewer.EMAIL;
db.SaveChanges();
transaction.Complete();
}
}
}
public void TestViewer()
{
using (LibraryDb db = LibraryDb.GetDbContext())
{
var viewers = ViewerBl.GetViewers();
//add viewer test
VIEWER viewer = new VIEWER {
ADDRESS = "test", EMAIL = "*****@*****.**", NAME = "test", PHONE = "testtest"
};
ViewerBl.AddNewViewer(viewer);
VIEWER dbViewer = db.VIEWERS.SingleOrDefault(v => v.ID == viewer.ID);
Assert.IsNotNull(dbViewer);
//Change VIEWER test
dbViewer.MIDDLE_NAME = someText;
ViewerBl.UpdateViewer(dbViewer);
dbViewer = db.VIEWERS.SingleOrDefault(b => b.ID == viewer.ID);
Assert.AreEqual(true, dbViewer?.MIDDLE_NAME == someText);
//deleted test VIEWER
ViewerBl.ViewersRemove(new[] { viewer.ID });
dbViewer = db.VIEWERS.SingleOrDefault(b => b.ID == viewer.ID);
Assert.IsNull(dbViewer);
}
}
public void TestBook()
{
using (LibraryDb db = LibraryDb.GetDbContext())
{
var books = BooksBl.GetBooks();
//add book test
BOOK book = new BOOK {
ISBN = "test", COUNT = 0, NAME = "test", PRICE = 0
};
BooksBl.AddNewCard(book);
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNotNull(dbBook);
//Change book test
dbBook.DESCRIPTION = someText;
BooksBl.UpdateBook(dbBook);
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.AreEqual(true, dbBook?.DESCRIPTION == someText);
//deleted test book
BooksBl.BooksRemove(new[] { book.ID });
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNull(dbBook);
}
}
public static void AddNewCard(BOOK book, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
db.BOOKS.Add(book);
db.SaveChanges();
transaction.Complete();
}
}
}
public static void AddNewViewer(VIEWER viewer, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
db.VIEWERS.Add(viewer);
db.SaveChanges();
transaction.Complete();
}
}
}
static void Main(string[] args)
{
//using (var db = new LibraryDb())
//{
// db.Database.Initialize(true);
// var book = db.BOOKS.ToList();
// var viewersve = db.VIEWERS.ToList();
//}
using (LibraryDb db = LibraryDb.GetDbContext())
{
var qwer = db.Database.ExecuteSqlCommand("SELECT * FROM BOOKs");
Thread.Sleep(5000);
}
Console.ReadKey();
}
public static void BooksRemove(decimal[] booksId, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (decimal id in booksId)
{
BOOK book = db.BOOKS.SingleOrDefault(b => b.ID == id);
if (book != null)
{
db.BOOKS.Remove(book);
}
}
db.SaveChanges();
transaction.Complete();
}
}
}
public static void ViewersRemove(decimal[] idViewers, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (decimal id in idViewers)
{
VIEWER viewer = db.VIEWERS.SingleOrDefault(b => b.ID == id);
if (viewer != null)
{
db.VIEWERS.Remove(viewer);
}
}
db.SaveChanges();
transaction.Complete();
}
}
}
public static IEnumerable <BOOK> GetBooks(LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
return(db.BOOKS.ToList());
}
public static IEnumerable <VIEWER> GetViewers(LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
return(db.VIEWERS.ToList());
}