/// <summary> /// Returns the current logged-in user. /// </summary> /// <returns> /// Returns the current logged-in user. /// </returns> /// <param name="name">The input username.</param> public user GetUser(string name) { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.users.Where(a => a.Username == name).FirstOrDefault()); } }
/// <summary> /// Returns book by input barcode. /// </summary> /// <returns> /// Returns book by input barcode. /// </returns> /// <param name="barcode]">The barcode of the book.</param> public book GetBookByBarcode(int barcode) { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.books.Where(a => a.barcodeId == barcode).FirstOrDefault()); } }
/// <summary> /// Returns a list with all registered users. /// </summary> /// <returns> /// Returns a list with all registered users. /// </returns> public List <user> GetAllUsers() { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.users.ToList()); } }
/// <summary> /// Returns the type of the input book. /// </summary> /// <returns> /// Returns the type of the input book. /// </returns> /// <param name="book]">The input book.</param> public booktype GetBookType(book book) { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.booktypes.Where(a => a.Id == book.BookTypeId).FirstOrDefault()); } }
/// <summary> /// Returns the count of the books. /// </summary> /// <returns> /// Returns the count of the books. /// </returns> public int GetAllBarcodesCount() { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.books.ToList().Count()); } }
/// <summary> /// Returns all books from the database. /// </summary> /// <returns> /// Returns all books from the database. /// </returns> public List <book> GetAllBooks() { using (bookstoreDBcontext = new bookshopEntities1()) { return(bookstoreDBcontext.books.ToList()); } }
/// <summary> /// Removes a user by input name. /// </summary> /// <param name="name">The input username.</param> public void RemoveUser(string name) { user user = GetUser(name); using (bookstoreDBcontext = new bookshopEntities1()) { bookstoreDBcontext.users.Attach(user); bookstoreDBcontext.users.Remove(user); bookstoreDBcontext.SaveChanges(); } }
/// <summary> /// Creates new user into the database. /// </summary> /// <param name="name">The input username.</param> /// <param name="password">The input password.</param> public void AddUser(string name, string password) { using (bookstoreDBcontext = new bookshopEntities1()) { user user = new user(); user.Username = name; user.Password = password; bookstoreDBcontext.users.Add(user); bookstoreDBcontext.SaveChanges(); } }
/// <summary> /// Restocks the amount of the input book. /// </summary> /// <param name="book]">The book to be restocked.</param> /// <param name="quantity]">The amount to be added into the current.</param> public void UpdateBookQuantity(book book, int quantity) { book book1 = book; book1.Number = quantity; using (bookstoreDBcontext = new bookshopEntities1()) { bookstoreDBcontext.books.AddOrUpdate(book1); bookstoreDBcontext.SaveChanges(); } }
public void AssertThatDatabaseContainsCertainBook() { List <book> booksFromDB = new List <book>(); using (dbContext = new bookshopEntities1()) { booksFromDB = this.dbContext.books.ToList(); } bool containsTheBook = booksFromDB.Select(x => x).Where(x => x.barcodeId == 105).Count() > 0; Assert.AreEqual(containsTheBook, true, "Business dbContext differs from the original context."); }
public void AssertThatDatabaseContainsCertainUser() { List <user> usersFromDB = new List <user>(); using (dbContext = new bookshopEntities1()) { usersFromDB = this.dbContext.users.ToList(); } bool containsTheUser = usersFromDB.Select(x => x).Where(x => x.Username == "user").Count() > 0; Assert.AreEqual(containsTheUser, true, "Business dbContext differs from the original context."); }
public void UpdateBookQuantityAfterPurchaseTestOne() { using (dbContext = new bookshopEntities1()) { book firstBook = dbContext.books.Where(b => b.barcodeId == 101).First(); int originalQuantity = firstBook.Number; int quantity = 4; business.UpdateBook(firstBook, quantity); firstBook = dbContext.books.Where(b => b.barcodeId == 101).First(); Assert.AreEqual(originalQuantity, quantity + firstBook.Number, "Book quantity do not change after purchase."); } }
/// <summary> /// Gets old user with his password and checks if it exists and replaces it. /// </summary> /// <param name="user">Contains user information.</param> public void UpdateUserPass(user user) { using (bookstoreDBcontext = new bookshopEntities1()) { var pass = bookstoreDBcontext.users.Where(a => a.Username == user.Username).FirstOrDefault(); if (pass != null) { user.Id = pass.Id; bookstoreDBcontext.Entry(pass).CurrentValues.SetValues(user); bookstoreDBcontext.SaveChanges(); } } }
/// <summary> /// Adds a book by input name, author, publisher, quantity, costPrice, /// sellingPrice and identifier for the book type. /// </summary> /// <param name="name">The name of the book.</param> /// <param name="author">The author of the book.</param> /// <param name="publisher">The publisher of the book.</param> /// <param name="quantity">The quantity of the book.</param> /// <param name="costPrice">The cost of the book.</param> /// <param name="sellingPrice">The sell price of the book.</param> /// <param name="bookTypeId">The identifier's type of the book.</param> public void AddBook(string name, string author, string publisher, int quantity, float costPrice, double sellingPrice, int bookTypeId) { using (bookstoreDBcontext = new bookshopEntities1()) { book book = new book(); book.Author = author; book.Number = quantity; book.Price = costPrice; book.Publisher = publisher; book.Book1 = name; sellingPrice = costPrice + 7; // + 7leva book.BookTypeId = bookTypeId; bookstoreDBcontext.books.Add(book); bookstoreDBcontext.SaveChanges(); } }
public void UpdateUserPasswordTest() { business.AddUser("Ivan Ivanov", "httrersgsa"); string userPassword = null; string newPassword = "******"; using (dbContext = new bookshopEntities1()) { user ivan = dbContext.users.Where(u => u.Username == "Ivan Ivanov").First(); ivan.Password = newPassword; business.UpdateUserPass(ivan); userPassword = dbContext.users.Where(u => u.Username == "Ivan Ivanov").First().Password; } business.RemoveUser("Ivan Ivanov"); Assert.AreEqual(userPassword, newPassword, "The user password do not change."); }