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; }