public void CheckCustsAlphanso()
{
using (var db = new ProjectOneContext())
{
var custs = db.Customers
.FromSqlRaw("SELECT * FROM Customers WHERE FName = 'Alphanso'")
.ToList();
int val = -1;
if (custs.Count > 0)
{
val = 1;
}
Assert.Equal(-1, val);
}
}
public void CheckLocations()
{
using (var db = new ProjectOneContext())
{
var locs = db.Locations
.FromSqlRaw("SELECT * FROM Locations")
.ToList();
int val = -1;
if (locs.Count > 0)
{
val = 1;
}
Assert.Equal(1, val);
}
}
public void CheckProducts()
{
using (var db = new ProjectOneContext())
{
var prods = db.Products
.FromSqlRaw("SELECT * FROM Products")
.ToList();
int val = -1;
if (prods.Count > 0)
{
val = 1;
}
Assert.Equal(1, val);
}
}
public void CheckOrders()
{
using (var db = new ProjectOneContext())
{
var ords = db.Orders
.FromSqlRaw("SELECT * FROM Orders")
.ToList();
int val = -1;
if (ords.Count > 0)
{
val = 1;
}
Assert.Equal(1, val);
}
}
public CustomersController(ProjectOneContext context)
{
_context = context;
}
public ProductsController(ProjectOneContext context)
{
_context = context;
}
public StoresController(ProjectOneContext context)
{
_context = context;
}
public OrdersController(ProjectOneContext context, IProductRepo pcontext, ICustomerRepo ccontext)
{
_context = context;
_pcontext = pcontext;
_ccontext = ccontext;
}
public OrdersController(ProjectOneContext context)
{
_context = context;
}
public LocationsController(ProjectOneContext context)
{
_context = context;
}
