static void Main(string[] args)
{
#region Configuration
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsetting.json")
.Build();
string connString = config.GetConnectionString("DefaultConnection");
#endregion
IDbConnection conn = new MySqlConnection(connString);
DapperDepartmentRepository repo = new DapperDepartmentRepository(conn);
Console.WriteLine("Hello user, here are the current departments.");
Console.WriteLine("Please press enter");
Console.ReadLine();
var depos = repo.GetAllDepartments();
Print(depos);
Console.WriteLine("Do you want to add a department?");
string userResponse = Console.ReadLine();
if (userResponse.ToLower() == "yes")
{
Console.WriteLine("What is the name of your new department?");
userResponse = Console.ReadLine();
repo.InsertDepartment(userResponse);
Print(repo.GetAllDepartments());
}
Console.WriteLine("Have a great day!");
//IDbConnection conn1 = new MySqlConnection(connString);
DapperProductsRepository repo1 = new DapperProductsRepository(conn);
Console.WriteLine("Hello user, here are the current products.");
Console.WriteLine("Please press enter");
Console.ReadLine();
var produc = repo1.GetAllProducts();
Print(produc);
Console.WriteLine("Do you want to add a product?");
string userResponse1 = Console.ReadLine();
if (userResponse.ToLower() == "yes")
{
Console.WriteLine("What is the name of your new product?");
var proName = Console.ReadLine();
Console.WriteLine($"What is the new product's price?");
var price = Convert.ToDouble(Console.ReadLine());
Console.WriteLine($"What is the new product's category id?");
var categoryID = Convert.ToInt32(Console.ReadLine());
repo1.CreateProduct(proName, price, categoryID);
Print(repo1.GetAllProducts());
}
Console.WriteLine("Have a great day!");
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
// sets this projects directory to the bas directory
.SetBasePath(Directory.GetCurrentDirectory())
// adds .json as a reference to this projects path
.AddJsonFile("appsettings.json")
// builds configuration with the file above
.Build();
// sets connection string to "Default connection" that we stated in the .json file
string connString = config.GetConnectionString("DefaultConnection");
// places the Sql connection that is using the "Default Connection" key value pair from .json file
// into a IDbConnection object
IDbConnection conn = new MySqlConnection(connString);
// Use the IDbConnection object in this constructor to set the connection to _connection in DapperDeparmentRepository
// as well as create an instance of this class to call the methods for querying
var deptRepo = new DapperDepartmentRepository(conn);
var prodRepo = new DapperProductsRepository(conn);
Console.WriteLine("What kind of data would you like to access?");
Console.WriteLine(
"(D)epartments\n" +
"(P)roducts\n");
Console.Write("> ");
var userInput = Console.ReadLine().ToLower().Trim();
if (userInput.StartsWith('d'))
{
Console.WriteLine("\nDo you want to add a department? yes/no");
Console.Write("> ");
var addDepartmentInput = Console.ReadLine().ToLower().Trim();
if (addDepartmentInput.StartsWith('y'))
{
// Takes input from the user for new department name
Console.WriteLine("\nEnter a new department name to add to the database..\n");
var userInputNewDepartment = Console.ReadLine();
deptRepo.InsertDepartment(userInputNewDepartment);
Console.WriteLine("List of Departments:");
var departmentList = deptRepo.GetDepartments();
// create foreach loop to enumerate over the list and write all department names to the console
foreach (var dept in departmentList)
{
Console.WriteLine(dept.Name);
}
}
else
{
Console.WriteLine();
Console.WriteLine("List of Departments:");
// reads departments and return a list of the departments
var departmentList = deptRepo.GetDepartments();
// create foreach loop to enumerate over the list and write all department names to the console
foreach (var dept in departmentList)
{
Console.WriteLine(dept.Name);
}
}
}
else if (userInput.StartsWith('p'))
{
Console.WriteLine("Do you want to add a product? yes/no");
Console.Write("> ");
var addProductInput = Console.ReadLine().ToLower().Trim();
if (addProductInput.StartsWith('y'))
{
var newProduct = new Products();
Console.Write("\nProduct Name: ");
newProduct.Name = Console.ReadLine();
Console.Write("\nProduct Price: ");
newProduct.Price = double.Parse(Console.ReadLine());
Console.Write("\nProduct Category ID: ");
newProduct.CategoryID = int.Parse(Console.ReadLine());
prodRepo.CreateProduct(newProduct.Name, newProduct.Price, newProduct.CategoryID);
prodRepo.ListAllProducts();
}
else
{
prodRepo.ListAllProducts();
}
}
else
{
Console.WriteLine("Incorrect Input");
}
Console.ReadLine();
}