private static void NewOne() { BasketDal dal = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); BasketDTO m = new BasketDTO { // BasketID = 2, Title = "Mizery", UserID = 1, BookID = 1, StatusID = 2, Author = "King", Price = 150, Amount = 1, Date = DateTime.Now }; m = dal.CreateBasket(m); Console.WriteLine($"New basket ID: {m.Title}"); foreach (var basket in dal.GetAllBaskets()) { Console.WriteLine($"{basket.BasketID}\t{basket.Title}\t{basket.Price}"); } Console.WriteLine($"Deleting basket ID: {m.BasketID}"); dal.DeleteBasket(m.BasketID); foreach (var basket in dal.GetAllBaskets()) { Console.WriteLine($"{basket.BasketID}\t{basket.Title}\t{basket.Price}"); } }
public void CreateTest() { BasketDal dal = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); var result = dal.CreateBasket(new BasketDTO { Title = "Test for basket", UserID = 1, BookID = 1, StatusID = 1, Author = "Test one", Price = 100, Amount = 1, Date = DateTime.Now }); Assert.IsTrue(result.BasketID != 0, "returned ID should be more than zero"); }
public void GetAllTest() { BasketDal dal = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); var result = dal.CreateBasket(new BasketDTO { Title = "Test for all baskets", UserID = 1, BookID = 1, StatusID = 1, Author = "Test one", Price = 100, Amount = 1, Date = DateTime.Now }); var movies = dal.GetAllBaskets(); Assert.AreEqual(1, movies.Count(x => x.Title == "get all baskets")); }
public static void Menu() { int id = Login(); //int id = 1; Console.WriteLine("Do you want to:\n 1-See all books \n " + "2-See your basket\n" + "3-Add a book to the basket\n" + "4-Go out\n"); var x = Console.ReadLine(); switch (x) { case "1": //можна побачити посортований за назвою список книг певної категорії,або знайти за назвою певну книгу CategoriesDal dal = new CategoriesDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); Console.WriteLine("Please,choose a category"); foreach (var categories in dal.GetAllCategories()) { Console.WriteLine($"{categories.Category}"); } string c = Console.ReadLine(); string connStr = ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString; BooksDal dal3 = new BooksDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); foreach (var book in dal3.Sort(c)) { Console.WriteLine($"{book.Title}\t{book.Author}\t{book.Price}"); } Console.WriteLine("Do you want to find smth?yes/no"); string s = Console.ReadLine(); if (s == "yes") { Console.WriteLine("Write the title of the book:"); string ti = Console.ReadLine(); foreach (var book in dal3.Find(ti, c)) { Console.WriteLine($"{book.Title}\t{book.Author}\t{book.Price}"); } } Menu(); break; case "2": Customer.GetBasket(id); Console.WriteLine("Do you want to buy books from basket?yes/no"); string s1 = Console.ReadLine(); if (s1 == "yes") { Customer.UpdateStatus(id, 1); } Console.WriteLine("Do you want to order shipping?yes/no"); string s2 = Console.ReadLine(); if (s2 == "yes") { Customer.UpdateStatus(id, 2); } Menu(); break; case "3": BasketDal dal2 = new BasketDal(ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString); Console.WriteLine("Write a name of the wished book"); string t = Console.ReadLine(); Console.WriteLine("Write necessary amount:"); int a = Convert.ToInt32(Console.ReadLine()); string connStr2 = ConfigurationManager.ConnectionStrings["IMDB"].ConnectionString; using (SqlConnection conn = new SqlConnection(connStr2)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); comm.CommandText = $"select * from Books where Title = '{t}'"; SqlDataReader reader = comm.ExecuteReader(); BooksDTO Book = new BooksDTO(); while (reader.Read()) { Book.BookID = (int)reader["BookID"]; Book.Author = reader["Autor"].ToString(); Book.Price = (Decimal)reader["Price"]; } conn.Close(); BasketDTO m = new BasketDTO { Title = t, UserID = id, BookID = Book.BookID, StatusID = 3, Author = Book.Author, Price = Book.Price, Amount = a, Date = DateTime.Now }; m = dal2.CreateBasket(m); } Menu(); break; case "4": Console.WriteLine("Bye:("); Thread.Sleep(1000); System.Environment.Exit(20); break; } }