static void Main()
{
var connStr = new SqlConnectionStringBuilder
{
DataSource = "192.168.1.220, 1433",
InitialCatalog = "PublicLibrary",
UserID = "User1",
Password = "******",
Pooling = true
};
//Console.Write("Book Title: ");
//string title = Console.ReadLine();
//Console.Write("Writer Name: ");
//string name = Console.ReadLine();
//Console.Write("Writer LastName: ");
//string lastName = Console.ReadLine();
//Console.Write("Writer MiddleName: ");
//string middleName = Console.ReadLine();
//Console.Write("Country: ");
//string country = Console.ReadLine();
//using (var db = new DataBaseAccessor(connStr.ConnectionString))
//{
// long bookId = db.AddBook(title, name, lastName, middleName, country);
// db.AddExtraWriter(44, "David", "Copperfield", null, "Ukraine");
// db.ModifyBookCopy(1, "New Name");
// int rowsAffected = db.DeleteBook(79);
// Console.WriteLine(rowsAffected);
// Console.WriteLine("The book was added successfully!\nBookId = {0}", bookId);
//}
using (DataBaseAccessor db = new DataBaseAccessor(connStr.ConnectionString))
{
UI one = new UI(db);
//one.GetBooks(writerId:4);
//long bookId = db.AddBook(title, name, lastName, middleName, country);
//db.AddExtraWriter(44, "David", "Copperfield", null, "Ukraine");
//db.ModifyBookCopy(1, "New Name");
//int rowsAffected = db.DeleteBook(45);
//Console.WriteLine(rowsAffected);
//Console.WriteLine("The book was added successfully!\nBookId = {0}", bookId);
//foreach (var book in db.GetData())
//{
// Console.WriteLine(book);
//}
}
Console.ReadKey();
}
public UI(DataBaseAccessor source)
{
_accessor = source;
}
