public User Login(string username, string password)
{
using (var db = new SuperServiceContext())
{
//Add password hashing encryption/decryption
return(db.Users.Where(x => x.Username == username && x.Password == password).FirstOrDefault());
}
}
public void Setup()
{
_db = new SuperServiceContext(new DbContextOptionsBuilder().UseInMemoryDatabase(databaseName: "Fake_DB").Options);
var burger = new Item()
{
Cost = 5.50m, Name = "TestCheeseburger"
};
var bun = new Ingredient()
{
Name = "TestSesame seed bun", Calories = 220, Carbohydrates = 40, Fat = 0, Protein = 0, Salt = 4, Sugar = 10, NumberInStock = 120
};
var cheese = new Ingredient()
{
Name = "TestCheese slice", Calories = 120, Carbohydrates = 3, Fat = 15, Protein = 1, Salt = 2, Sugar = 3, NumberInStock = 50
};
var beefBurger = new Ingredient()
{
Name = "TestQuarter pound beef burger", Calories = 250, Carbohydrates = 6, Fat = 15, Protein = 28, Salt = 10, Sugar = 1, NumberInStock = 80
};
var ingredientList = new List <Ingredient>()
{
bun,
cheese,
beefBurger
};
foreach (var ingredient in ingredientList)
{
if (_db.Ingredients.Where(x => x.Name == ingredient.Name).Count() > 0)
{
var ingId = _db.Ingredients.Where(x => x.Name == ingredient.Name).First().IngredientID;
_db.ItemIngredients.RemoveRange(_db.ItemIngredients.Include(x => x.Ingredient).Where(x => x.Ingredient.IngredientID == ingId));
_db.SaveChanges();
_db.Ingredients.Remove(_db.Ingredients.Where(x => x.Name == ingredient.Name).FirstOrDefault());
_db.SaveChanges();
}
}
if (_db.Items.Where(x => x.Name == burger.Name).Count() > 0)
{
_db.Items.RemoveRange(_db.Items.Where(x => x.Name == burger.Name));
}
_db.ItemIngredients.Add(new ItemIngredients()
{
Ingredient = bun, Item = burger
});
_db.ItemIngredients.Add(new ItemIngredients()
{
Ingredient = cheese, Item = burger
});
_db.ItemIngredients.Add(new ItemIngredients()
{
Ingredient = beefBurger, Item = burger
});
_db.SaveChanges();
}
public void SetUp()
{
db = new SuperServiceContext(new DbContextOptionsBuilder().UseInMemoryDatabase(databaseName: "Fake_DB").Options);
iHelper = new ItemHelper(db);
tHelper = new TableHelper(db);
oHelper = new OrderHelper(new OrderService(db), new OrderItemsService(db));
if (oHelper.GetOrdersByTableNumber(1000).Count() > 0)
{
var oList = oHelper.GetOrdersByTableNumber(1000).ToList();
foreach (var o in oList)
{
oHelper.DeleteOrder(o);
}
}
if (tHelper.GetTableByTableNumber(1000) != null)
{
tHelper.DeleteTableByTableNumber(1000);
}
tHelper.AddNewTable(new Table
{
TableNumber = 1000,
NumberOfSeats = 1,
});
table = tHelper.GetTableByTableNumber(1000);
order = new Order {
Table = table
};
if (iHelper.GetAllItemsOrderedByAvailability().FirstOrDefault() == null)
{
iHelper.AddNewItem(new Item {
Cost = 5, Name = "TestSandwich"
}, new List <Ingredient>
{
new Ingredient {
Name = "TestBread", Calories = 230, Carbohydrates = 15, Fat = 1, Protein = 1, Salt = 5, Sugar = 5, NumberInStock = 10
},
new Ingredient {
Name = "TestCheese", Calories = 150, Carbohydrates = 1, Fat = 10, Protein = 2, Salt = 5, Sugar = 3, NumberInStock = 10
}
});
iHelper.AddNewItem(new Item {
Cost = 8, Name = "TestStew"
}, new List <Ingredient>
{
new Ingredient {
Name = "TestCabbage", Calories = 60, Carbohydrates = 15, Fat = 1, Protein = 1, Salt = 5, Sugar = 5, NumberInStock = 10
},
new Ingredient {
Name = "TestPotatoes", Calories = 300, Carbohydrates = 60, Fat = 3, Protein = 2, Salt = 5, Sugar = 3, NumberInStock = 10
},
new Ingredient {
Name = "TestCarrots", Calories = 100, Carbohydrates = 20, Fat = 10, Protein = 2, Salt = 5, Sugar = 3, NumberInStock = 0
},
});
}
items = new List <Item>
{
iHelper.GetAllItemsOrderedByAvailability().First(),
iHelper.GetAllItemsOrderedByAvailability().Last()
};
db.OrderStatuses.Add(new OrderStatus()
{
Name = "Order Placed"
});
db.SaveChanges();
}
public TableHelper(SuperServiceContext db)
{
_serv = new TableService(db);
}
public ItemsController(SuperServiceContext db)
{
_iHelper = new ItemHelper(new ItemService(db), new IngredientService(db));
}
public IngredientService(SuperServiceContext db)
{
_db = db;
}
public ItemService(SuperServiceContext db)
{
_db = db;
}
public UserService(SuperServiceContext db)
{
_db = db;
}
public IngredientsController(SuperServiceContext context)
{
_context = context;
_helper = new IngredientHelper(new IngredientService(_context));
}
public TableService(SuperServiceContext db)
{
_db = db;
}
public ItemHelper(SuperServiceContext db)
{
_serv = new ItemService(db);
_ingServ = new IngredientService(db);
_iIServ = new ItemIngredientService(db);
}
public OrderItemsService(SuperServiceContext db)
{
_db = db;
}
