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;
}
}