private static void Employees(IApplicationBuilder app)
{
app.Run(async(context) =>
{
ICachedEmployeesService cachedEmployeesService = context.RequestServices.GetService <ICachedEmployeesService>();
IEnumerable <Employee> employees = cachedEmployeesService.GetEmployees("employees20");
string httpString = "<html>" +
"<head>" +
"<title>Таблица Employees</title>" +
"<style>" +
"div { font-size: 24; }" +
"table { font-size: 20; }" +
"</style>" +
"</head>" +
"<meta charset='utf-8'/>" +
"<body>" +
"<div align='center'>Таблица 'Employees'</div>" +
"<div align='center'>" +
"<table border=1>" +
"<tr>" +
"<td>Должность</td>" +
"<td>Имя</td>" +
"<td>Фамилия</td>" +
"<td>Отчество</td>" +
"<td>Дата трудоустройства</td>" +
"</tr>";
foreach (Employee employee in employees)
{
httpString += "<tr>";
httpString += $"<td>{employee.Post}</td>";
httpString += $"<td>{employee.Name}</td>";
httpString += $"<td>{employee.Surname}</td>";
httpString += $"<td>{employee.Patronymic}</td>";
httpString += $"<td>{employee.EmploymentDate}</td>";
httpString += "</tr>";
}
httpString += "</table>";
httpString += "<div align='center'><a href='/'>Главная</a></div>";
httpString += "</body>" +
"</html>";
await context.Response.WriteAsync(httpString);
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, car_sharingContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseSession();
app.Map("/info", Info);
app.Map("/carmodels", CarModels);
app.Map("/cars", Cars);
app.Map("/employees", Employees);
app.Map("/searchform", SearchForm);
app.Run(async(context) =>
{
ICachedCarModelsService cachedCarModels = context.RequestServices.GetService <ICachedCarModelsService>();
cachedCarModels.GetCarModels("carmodels20");
ICachedEmployeesService cachedEmployeesService = context.RequestServices.GetService <ICachedEmployeesService>();
cachedEmployeesService.GetEmployees("employees20");
ICachedCarsService cachedCarsService = context.RequestServices.GetService <ICachedCarsService>();
cachedCarsService.GetCars("cars20");
User user = context.Session.Get <User>("user") ?? new User();
string htmlString = "<html>" +
"<head>" +
"<title>Форма пользователя</title>" +
"<style>" +
"div { font-size: 24; }" +
"</style>" +
"</head>" +
"<meta charset='utf-8'/>" +
"<body>" +
"<div align='center'>" +
"<form action='/'>" +
"<div>Введите логин:</div>";
htmlString += $"<div><input type='text' name='loginStr' value=" + user.Login + "></div>";
htmlString += "<div>Введите пароль:</div>";
htmlString += $"<div><input type='text' name='passwordStr' value=" + user.Password + "></div>" +
"<div><input type='submit' value='Enter/Update'></div>" +
"</form>" +
"<div><a href='/carmodels'>Table 'CarModels'</a></div>" +
"<div><a href='/employees'>Table 'Employees'</a></div>" +
"<div><a href='/cars'>Table 'Cars'</a></div>" +
"<div><a href='/searchform'>Search Form</a></div>" +
"</div>" +
"</body>" +
"</html>";
string Login = context.Request.Query["loginStr"];
string Password = context.Request.Query["passwordStr"];
if (Login != null && Password != null)
{
user.Login = Login;
user.Password = Password;
context.Session.Set <User>("user", user);
}
await context.Response.WriteAsync(htmlString);
});
}
private static void SearchForm(IApplicationBuilder app)
{
app.Run(async(context) =>
{
ICachedCarModelsService cachedCarModelsService = context.RequestServices.GetService <ICachedCarModelsService>();
IEnumerable <CarModel> carModels = cachedCarModelsService.GetCarModels("carmodels20");
ICachedCarsService cachedCarsService = context.RequestServices.GetService <ICachedCarsService>();
IEnumerable <Car> cars = cachedCarsService.GetCars("cars20");
ICachedEmployeesService cachedEmployeesService = context.RequestServices.GetService <ICachedEmployeesService>();
IEnumerable <Employee> employees = cachedEmployeesService.GetEmployees("employees20");
string httpString = "<html>" +
"<head>" +
"<title>Форма поиска</title>" +
"<style>" +
"div { font-size: 24; }" +
"table { font-size: 20; }" +
"select {font-size: 20; width=20%; }" +
"input {font-size: 22; width=20%; }" +
"</style>" +
"</head>" +
"<meta charset='utf-8'/>" +
"<body>" +
"<div align='middle' text-align='left'>" +
"<form action='/searchform'>" +
"<div width=20%>Выберете таблицу</div>" +
"<select name='tableName'>" +
"<option>Choose table</option>" +
"<option>CarModels</option>" +
"<option>Employees</option>" +
"<option>Cars</option>" +
"</select>" +
"<input type = 'submit' value = 'Select'>";
string selectedText = context.Request.Cookies["table"] ?? context.Request.Query["tableName"];
if (context.Request.Cookies["table"] == "Choose table")
{
context.Response.Cookies.Delete("table");
}
if (selectedText != null)
{
if (selectedText != "Choose table" && selectedText != context.Request.Cookies["tableName"])
{
string querySttring = context.Request.Query["tableName"];
if (querySttring != null && querySttring != "Choose table")
{
context.Response.Cookies.Append("table", querySttring);
selectedText = querySttring;
}
}
switch (selectedText)
{
case "CarModels":
httpString += "<ul>";
foreach (CarModel carModel in carModels)
{
httpString += $"<li>{carModel.Name}</li>";
}
httpString += "</ul>";
break;
case "Employees":
httpString += "<ul>";
foreach (Employee employee in employees)
{
httpString += $"<li>{employee.Name}</li>";
}
httpString += "</ul>";
break;
case "Cars":
httpString += "<ul>";
foreach (Car car in cars)
{
httpString += $"<li>{car.Vincode}, {car.CarModel?.Name}.</li>";
}
httpString += "</ul>";
break;
}
httpString += "<div>" +
"<input type='text' name='entity'>" +
"<input type='submit' value='Input'>" +
"</div>";
string entityInput;
if ((entityInput = context.Request.Query["entity"]) != null && entityInput != "")
{
switch (selectedText)
{
case "CarModels":
CarModel carModel = carModels.FirstOrDefault(c => c.Name == entityInput);
if (carModel != null)
{
httpString += "<div>" +
"<p>" +
$"Название модели: {carModel.Name}, Описание: {carModel.Description}." +
"</p>" +
"</div>";
}
break;
case "Employees":
Employee employee = employees.FirstOrDefault(e => e.Name == entityInput);
if (employee != null)
{
httpString += "<div>" +
"<p>" +
$"Имя: {employee.Name}, Фамилия {employee.Surname}, Отчество: {employee.Patronymic}, " +
$"Должность: {employee.Post}, дата трудоустройства: {employee.EmploymentDate}." +
"</p>" +
"</div>";
}
break;
case "Cars":
int id;
if (int.TryParse(entityInput, out id))
{
Car car = cars.FirstOrDefault(c => c.CarId == id);
httpString += "<div><p>";
httpString += $"Название модели : {car.CarModel?.Name},";
httpString += $"Описание: {car.CarModel?.Description},";
httpString += $"Регистрационный номер: {car.RegNum},";
httpString += $"VIN-код: {car.Vincode},";
httpString += $"Номер двигателя: {car.EngineNum},";
httpString += $"Цена: {car.Price},";
httpString += $"Аренда: {car.RentalPrice},";
httpString += $"Год выпуска: {car.IssueDate},";
httpString += $"Характеристики: {car.Specs},";
httpString += $"Дата ТО: {car.TechnicalMaintenanceDate},";
httpString += $"Спец. метка: {car.SpecMark},";
httpString += $"Метка возврата: {car.ReturnMark},";
httpString += $"Имя сотрудника: {car.Employee?.Name},";
httpString += $"Фамилия сотрудника: {car.Employee?.Surname},";
httpString += "</p>" +
"</div>";
}
break;
}
}
}
httpString += "</form>" +
"<div><a href='/searchform'>Очистить</a></div>" +
"<div><a href='/'>Главная</a></div>" +
"</div>" +
"</body>" +
"</html>";
await context.Response.WriteAsync(httpString);
});
}
