public void addUser(Nike_User u)
{
using (var db = new NikeDBEntities())
{
db.Nike_User.Add(u);
db.SaveChanges();
}
}
//Get category of the product {prod}
public string GetProductCategory(Nike_Product prod)
{
using (var db = new NikeDBEntities())
{
var category = db.Nike_Category.FirstOrDefault(p => p.Id == prod.CategoryId);
return category.Name;
}
}
//Get product with id = {id}
public Nike_Product GetProduct(int id)
{
using (var db = new NikeDBEntities())
{
var prod = db.Nike_Product.FirstOrDefault(p => p.Id == id);
return prod;
}
}
//Get all products
public List<Nike.DataLayer.Nike_Product> GetProducts()
{
using (var db = new NikeDBEntities())
{
var products = db.Nike_Product.ToList();
return products;
}
}
public List<Nike_User> GetAllUsers()
{
List<Nike_User> userList;
using (var db = new NikeDBEntities())
{
userList = db.Nike_User.ToList();
return userList;
}
}
public Boolean checkUserExists(Nike_User u)
{
List<Nike_User> userList;
using (var db = new NikeDBEntities())
{
userList = db.Nike_User.ToList();
foreach (var item in userList)
{
if (item.emailAddress == u.emailAddress)
{
return true;
}
}
}
return false;
}
