static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
string connString = config.GetConnectionString("DefaultConnection");
IDbConnection conn = new MySqlConnection(connString);
DapperDepartmentRepository repo = new DapperDepartmentRepository(conn);
Console.WriteLine("Hello user. Here are current departments in the database:");
var depos = repo.GetAllDepartments();
foreach (var depo in depos)
{
Console.WriteLine($"ID-{depo.DepartmentID} Name-{depo.Name}");
}
Console.WriteLine("Do you want to add another department?");
String userResponce = Console.ReadLine();
if (userResponce.ToLower() == "yes")
{
Console.WriteLine("What is the name of the department you want to add: ");
var newDep = Console.ReadLine();
repo.InsertDepartment(newDep);
repo.GetAllDepartments();
}
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
string connString = config.GetConnectionString("DefaultConnection");
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 this new department called?");
userResponse = Console.ReadLine();
repo.InsertDepartment(userResponse);
Print(repo.GetAllDepartments());
}
Console.WriteLine("Have a nice day!");
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
//get the connection string value from the JSON key value pair
var connString = config.GetConnectionString("DefaultConnection");
//-------------------------------IoC-------------------------------
//container to implement IoC
var container = new Container(x =>
{
x.AddTransient <IDbConnection>((c) =>
{
return(new MySqlConnection(connString));
});
x.AddTransient <IDepartmentRepository, DapperDepartmentRepository>();
});
//var repo = container.GetService<IDepartmentRepository>();
/*-------------------------------IoC Ends----------------------------*/
//-------------------------------Without Dapper------------------------
//
// IDbConnection conn = new MySqlConnection(connString);
// var repo = new DepartmentRepository(conn);
//
// ----------------------------Without Dapper Ends-------------------*/
//-------------------------------Dapper--------------------------------
IDbConnection conn = new MySqlConnection(connString);
var repo = new DapperDepartmentRepository(conn);
//-----------------------------Dapper Ends-----------------------------
//Console.WriteLine("Type a new Department name");
//var newDepartment = Console.ReadLine();
//repo.InsertDepartment(newDepartment);
var departments = repo.GetAllDepartments();
Console.WriteLine("ID -- NAME \n---------------------------");
foreach (var dept in departments)
{
Console.WriteLine($"{dept.DepartmentID} -- {dept.Name}");
}
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
// Creating connection string using info from appsettings.json file
string connString = config.GetConnectionString("DefaultConnection");
// Using that string to make connection to database
IDbConnection conn = new MySqlConnection(connString);
var deptRepo = new DapperDepartmentRepository(conn);
//Console.WriteLine("Type a new Department name");
//var newDepartment = Console.ReadLine();
//deptRepo.InsertDepartment(newDepartment);
var departments = deptRepo.GetAllDepartments();
foreach (var dept in departments)
{
Console.WriteLine($"{dept.DepartmentID} : {dept.Name}");
}
Console.WriteLine();
// Creating new Product Repository
var prodRepo = new DapperProductRepository(conn);
// Bringing in all Products from database
var allProducts = prodRepo.GetAllProducts();
// take a look
//foreach (var prod in allProducts)
//{
// Console.WriteLine($"{prod.ProductID} : {prod.Name} : {prod.Price} : {prod.CategoryID} : {prod.OnSale} : {prod.StockLevel}");
//}
// Adding a new item in the Products table
//prodRepo.CreateProduct("MacBook Air", 1000.00, 1);
//foreach (var prod in allProducts)
//{
// Console.WriteLine($"{prod.ProductID} : {prod.Name} : {prod.Price} : {prod.CategoryID} : {prod.OnSale} : {prod.StockLevel}");
//}
//prodRepo.UpdateStockLevel(940, "100");
// prodRepo.DeleteProduct(941);
var allComputers = prodRepo.GetComputers();
var catOfProducts = prodRepo.GetCategoryProducts(2);
//foreach (var comp in catOfProducts)
//{
// Console.WriteLine($"{comp.ProductID} : {comp.Name} : {comp.Price}");
//}
var empRepo = new DapperEmployeeRepository(conn);
var allEmployees = empRepo.GetAllEmployees();
//Console.WriteLine("What is the new employee's First Name?");
//var FirstName = Console.ReadLine();
//Console.WriteLine("What is the new employee's Middle Initial?");
//var MiddleInitial = Console.ReadLine();
//Console.WriteLine("What is the new employee's Last Name?");
//var LastName = Console.ReadLine();
//Console.WriteLine("What is the new employee's Job Title?");
//var Title = Console.ReadLine();
// empRepo.AddEmployee(FirstName, MiddleInitial, LastName, Title);
foreach (var emp in allEmployees)
{
Console.WriteLine($"{emp.EmployeeID} : {emp.LastName} : {emp.Title}");
}
// Updating EmailAddress in database with method
var emailAddress = "*****@*****.**";
empRepo.UpdateEmail(34618, emailAddress);
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsetting.json")
.Build();
string connString = config.GetConnectionString("DefaultConnection");
IDbConnection conn = new MySqlConnection(connString);
var productsRepo = new DapperDepartmentRepository(conn);
Console.WriteLine($"What is the name of the new product?");
var productName = Console.ReadLine();
double priceOfProduct;
bool response;
do
{
Console.WriteLine($"How much does {productName} cost?");
response = double.TryParse(Console.ReadLine(), out priceOfProduct);
}while (response == false);
Console.WriteLine($"What is the CategoryID for {productName}?");
var categoryID = int.Parse(Console.ReadLine());
productsRepo.CreateProduct(productName, priceOfProduct, categoryID);
var products = productsRepo.GetAllProducts();
foreach (var item in products)
{
Console.WriteLine($"{item.productID} {item.Name} {item.Price}");
}
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();
foreach (var depo in depos)
{
Console.WriteLine($"ID:{ depo.DepartmentID} Name:{ depo.Name}");
}
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.");
}
