//Error
public ActionResult Demo1()
{
var task = repository.GetAllAsync();
//other logic
var employees = task.Result;
return(View("Index", employees));
}
static async Task TestRepo()
{
var repo = new ArticlesRepository("Articles");
// Example with Print Baked into the Object itself
List <Articles> articles = new List <Articles>();
articles = (await repo.GetAllAsync()).ToList();
TestTool.PrintSuccess("Got {0} row from Articles\n", articles.Count());
articles.First().PrintKeys();
articles.ForEach(article => article.Print());
//
var repoEmployees = new EmployeesRepository("Employees");
List <Employees> employees = (await repoEmployees.GetAllAsync()).ToList();
TestTool.PrintSuccess("Got {0} row from Employees\n", employees.Count());
Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", "ID", "Name", "LastName", "Email", "Password");
employees.ForEach(employee => Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", employee.ID, employee.Name, employee.LastName, employee.Email, new string('*', employee.Password.Length)));
//
var repoIngredients = new IngredientsRepository("Ingredients");
var ingredients = (await repoIngredients.GetAllAsync()).ToList();
TestTool.PrintSuccess("Got {0} row from Ingredients\n", employees.Count());
Console.Write("{0}\t{1}\t{2}\n", "ID", "Name", "Price");
ingredients.ForEach(ingredient => Console.Write("{0}\t{1}\t{2}\n", ingredient.ID, ingredient.Name, ingredient.Price));
//
var repoOrders = new OrdersRepository("Orders");
List <Orders> orders = (await repoOrders.GetAllAsync()).ToList();
TestTool.PrintSuccess("Got {0} row from Orders\n", orders.Count());
Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", "ID", "TimeCreated", "Orderstatus", "Price", "CustomerID");
orders.ForEach(order => Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", order.ID, order.TimeCreated, order.Orderstatus, order.Price, order.CustomerID));
//Orders order = (await repoOrders.GetAsync(4));
//await repoOrders.UpdateAsync(new Orders() {ID = 12, Orderstatus = 0, Price = 124, CustomerID = 1 });
//await repoIngredients.InsertCustomIngredientsAsync(orders.First(), articles.First(), articles.First().Ingredients);
//Orders order = orders.First() ;
//List<Articles> tempArticles = articles.GetRange(0, 2);
//await repoOrders.MakeOrderAsync(order, tempArticles);
//List<Articles> orderListArticles = (await repo.GetAllAsync(order)).ToList();
//foreach (var item in orderListArticles)
//{
// Console.WriteLine(item.Name + " " + item.Type);
// foreach (var item2 in item.Ingredients)
// {
// Console.Write(item2.Name.Trim() + ", ");
// }
//}
//articles[0].ID = 71;
//await General.articlesRepo.UpdateAsync(articles[0]);
}
public async Task <EmployeeDTO> GetEmployeeById(int idEmployee)
{
try
{
EmployeesRepository emp = new EmployeesRepository();
var employeesResult = await emp.GetAllAsync();
var employeeResult = employeesResult.Where(x => x.Id == idEmployee).FirstOrDefault();
employeeResult.AnnualSalary = CalculateSalary(employeeResult.ContractTypeName, employeeResult.HourlySalary, employeeResult.MonthlySalary);
return(employeeResult);
}
catch (Exception ex)
{
throw;
}
}
public async Task <List <EmployeeDTO> > GetAllEmployees()
{
try
{
EmployeesRepository emp = new EmployeesRepository();
var employeesResult = await emp.GetAllAsync();
foreach (var employee in employeesResult)
{
employee.AnnualSalary = CalculateSalary(employee.ContractTypeName, employee.HourlySalary, employee.MonthlySalary);
}
return(employeesResult);
}
catch (Exception ex)
{
throw;
}
}
public async void GetAllAsync_ShouldReturnListOfEmployees()
{
// Arrange
var employees = new List <Employee>
{
new Employee {
Id = 1, FirstName = "John", LastName = "Dou", MediaInteractivaEmployee = true
},
new Employee {
Id = 2, FirstName = "Sam", LastName = "Smith", MediaInteractivaEmployee = false
}
};
var options = new DbContextOptionsBuilder <AppContext>()
.UseInMemoryDatabase(databaseName: "Employees1")
.Options;
using (var appContext = new AppContext(options))
{
await appContext.Employees.AddRangeAsync(employees);
await appContext.SaveChangesAsync();
}
using (var appContext = new AppContext(options))
{
var repo = new EmployeesRepository(appContext);
// Act
var result = await repo.GetAllAsync();
// Assert
Assert.IsAssignableFrom <IEnumerable <Employee> >(result);
Assert.Equal(employees.Count, result.Count());
}
}
