public static void UpdateMenu(int bookId)
{
Console.WriteLine("1 - Update Title");
Console.WriteLine("2 - Update Publisher");
Console.WriteLine("3 - Update Year");
Console.WriteLine("4 - Update Price");
Console.WriteLine("5 - Back To Main Menu");
ConsoleKeyInfo cki = Console.ReadKey(true);
BookCrud.UpdateBook(bookId, cki);
}
public static void MainMenu()
{
Console.WriteLine("1 - Add a book");
Console.WriteLine("2 - Print book info");
Console.WriteLine("3 - Update book info");
Console.WriteLine("4 - Delete book from database");
Console.WriteLine("5 - Exit");
ConsoleKeyInfo cki = Console.ReadKey(true);
if (cki.Key.Equals(ConsoleKey.D1) || cki.Key.Equals(ConsoleKey.NumPad1))
{
Console.Clear();
Console.WriteLine("Book Title: ");
string title = Console.ReadLine();
Console.WriteLine("PublisherId: ");
int pId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Year: ");
int year = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Price: ");
int price = Convert.ToInt32(Console.ReadLine());
BookCrud.InsertBook(title, pId, year, price);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D2) || cki.Key.Equals(ConsoleKey.NumPad2))
{
Console.Clear();
Console.WriteLine("Book Id:");
int bId = Convert.ToInt32(Console.ReadLine());
SqlParameter bookId = new SqlParameter {
Value = bId, SqlDbType = SqlDbType.Int, ParameterName = "bookId"
};
EnumerableRowCollection <DataRow> bookInfo = BookCrud.ReadBook(bookId);
foreach (DataRow row in bookInfo)
{
Console.WriteLine($"Id: {row[0]}");
Console.WriteLine($"Title: {row[1]}");
Console.WriteLine($"Publisher: {row[2]}");
Console.WriteLine($"Year: {row[3]}");
Console.WriteLine($"Price: {row[4]}");
}
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D3) || cki.Key.Equals(ConsoleKey.NumPad3))
{
Console.Clear();
Console.WriteLine("Book Id:");
int bId = Convert.ToInt32(Console.ReadLine());
UpdateMenu(bId);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D4) || cki.Key.Equals(ConsoleKey.NumPad4))
{
Console.WriteLine("Book Id:");
int bId = Convert.ToInt32(Console.ReadLine());
SqlParameter bookId = new SqlParameter {
Value = bId, SqlDbType = SqlDbType.Int, ParameterName = "bookId"
};
BookCrud.DeleteBook(bookId);
MainMenu();
}
else if (cki.Key.Equals(ConsoleKey.D5) || cki.Key.Equals(ConsoleKey.NumPad5))
{
Console.WriteLine("Program will now exit...");
week09con.Close();
}
else
{
MainMenu();
}
}
