private static void Main()
{
Console.WriteLine(sad);
var sqlEngine = new SqlDbEngine(SqlConnectionString);
//Task 1
WriteLine("1.Write a program that retrieves from the Northwind sample database in MS SQL Server the number of rows in the Categories table.");
var categoryCount = sqlEngine.GetNumberOfRowsFor("Categories");
WriteLine("Total categories: " + categoryCount);
Divide();
//Task 2
WriteLine("2.Write a program that retrieves the name and description of all categories in the Northwind DB.");
var categoryNamesAndDescriptions = sqlEngine.GetCategoryNamesAndDescriptions();
foreach (var category in categoryNamesAndDescriptions)
{
WriteLine(string.Format(ResultFormat, category.CategoryName, category.Description));
}
Divide();
//Task 3
WriteLine("3.Write a program that retrieves from the Northwind database all product categories and the names of the products in each category.");
var categoryWithProducts = sqlEngine.GetProductsGroupedByCategory();
foreach (var category in categoryWithProducts)
{
WriteLine(string.Format(ResultFormat, category.CategoryName, category.Products));
}
Divide();
//Task 4
sqlEngine.InsertProduct("Pesho", 2, 3, "Many peshos per unit", 1050000.3m, 5000);
//Task 5
WriteLine("5.Write a program that retrieves the images for all categories in the Northwind database and stores them as JPG files in the file system.");
var images = sqlEngine.GetAllCategoryImages();
var fileManager = new ImageFileManager();
for (var i = 0; i < images.Count; i++)
{
fileManager.WriteToDisk($"..\\..\\..\\..\\CategoryImages\\image-{i + 1}.jpg", images[i].Picture);
}
WriteLine("Downloaded and saved category images to ..\\..\\..\\..\\CategoryImages\\");
Divide();
//Task 6
WriteLine("6.Write a program that reads your MS Excel file through the OLE DB data provider and displays the name and score row by row.");
var oleDbEngine = new OleDbEngine(OledbConnectionString);
var scores = oleDbEngine.GetPersonScores();
foreach (var personScore in scores)
{
WriteLine(string.Format(ResultFormat, personScore.Name, personScore.Score));
}
Divide();
//Task 7
oleDbEngine.InsertPerson("Tosho", 50);
//Task 8
WriteLine("8.Write a program that reads a string from the console and finds all products that contain this string.");
var pattern = GetUserInput("product");
var searchResult = sqlEngine.SearchProductsByName(pattern);
foreach (var product in searchResult)
{
WriteLine(product.ProductName);
}
Divide();
//Task 9
WriteLine("9.Write methods for listing all books, finding a book by name and adding a book from a MySql Database.");
var mySqlDb = new MySqlDbEngine(MySqlConnectionString);
var allBooks = mySqlDb.ListAllBooks();
foreach (var book in allBooks)
{
WriteLine(string.Format(ResultFormat, book.Author, book.Name));
}
Divide();
//Task 9.1
var bookSearchPattern = GetUserInput("book");
var bookSearchResult = mySqlDb.SearchForBooksByName(bookSearchPattern);
foreach (var book in bookSearchResult)
{
WriteLine(string.Format(ResultFormat, book.Author, book.Name));
}
Divide();
//Task 9.2
mySqlDb.AddBook("The Art of War", "Sun Tzu", "56453-5654-4512", DateTime.Now);
var sqlLiteDb = new SqLiteDbEngine(SqLiteConnectionString);
//Task 10.2
sqlLiteDb.AddBook("The Art of Unit Testing", "Roy Osherove", "9781933988276", DateTime.Now);
//Task 10
WriteLine("Re-implement the previous task with SQLite embedded DB.");
var result = sqlLiteDb.ListAllBooks();
foreach (var book in result)
{
WriteLine(string.Format(ResultFormat, book.Author, book.Name));
}
Divide();
//Task 10.1
var bookSearchPatternLite = GetUserInput("book");
var bookSearchLiteResult = sqlLiteDb.SearchForBooksByName(bookSearchPatternLite);
foreach (var book in bookSearchLiteResult)
{
WriteLine(string.Format(ResultFormat, book.Author, book.Name));
}
Divide();
}
public void SetUp()
{
_engine = new SqlDbEngine();
}
