public ActionResult Edit(int FoodId, FoodViewModel editedFood) { try { // TODO: Add update logic here //var food = foods.First(f => f.FoodId == FoodId); using (var db = new FoodLogContext()) { var food = db.Foods.First(f => f.FoodId == FoodId); food.Name = editedFood.Food.Name; food.Calories = editedFood.Food.Calories; food.GramsOfCarb = editedFood.Food.GramsOfCarb; food.GramsOfFat = editedFood.Food.GramsOfFat; food.GramsOfProtein = editedFood.Food.GramsOfProtein; food.FoodType = food.FoodType.FoodTypes.First(t => t.Name == editedFood.SelectedFoodType); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(FoodViewModel newFood) { try { // TODO: Add insert logic here var food = new FoodModel() { Name = newFood.Food.Name, Calories = newFood.Food.Calories, GramsOfCarb = newFood.Food.GramsOfCarb, GramsOfFat = newFood.Food.GramsOfFat, GramsOfProtein = newFood.Food.GramsOfProtein }; food.FoodType = food.FoodType.FoodTypes.First(t => t.Name == newFood.SelectedFoodType); using (var db = new FoodLogContext()) { db.Foods.Add(food); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public async Task UpdateAsync(T item) { using (var _ctx = new FoodLogContext()) { _ctx.Entry(item).State = EntityState.Modified; await _ctx.SaveChangesAsync(); } }
public void Update(T item) { using (var _ctx = new FoodLogContext()) { _ctx.Entry(item).State = EntityState.Modified; _ctx.SaveChanges(); } }
public void Create(T item) { using (var _ctx = new FoodLogContext()) { _ctx.Set <T>().Add(item); _ctx.SaveChanges(); } }
public async Task CreateAsync(T item) { using (var _ctx = new FoodLogContext()) { await _context.Set <T>().AddAsync(item); await _context.SaveChangesAsync(); } }
//List<FoodModel> foods = new List<FoodModel>() {new FoodModel() //{ // FoodId = 1, // Name = "Black Beans", // ServingSize = 1, // Calories = 227, // GramsOfProtein = 15.2, // GramsOfFat = .9, // GramsOfCarb = 40.8, // FoodType = FoodTypeModel.GetFoodTypeList().First(t => t.Name == "Legumes") //} }; // GET: Food public ActionResult Index() { List <FoodModel> foods = new List <FoodModel>(); using (var db = new FoodLogContext()) { foods.AddRange(db.Foods.ToList()); } return(View(foods)); }
// GET: Food/Delete/5 public ActionResult Delete(int FoodId) { using (var db = new FoodLogContext()) { db.Foods.Remove(db.Foods.First(food => food.FoodId == FoodId)); db.SaveChanges(); } //foods.Remove(foods.First(food => food.FoodId == FoodId)); return(RedirectToAction("Index")); }
static async System.Threading.Tasks.Task Main(string[] args) { var ctx = new FoodLogContext(); ctx.Database.EnsureDeleted(); ctx.Database.EnsureCreated(); Console.WriteLine("Done!"); /* FoodsBusinessObject _fbo = new FoodsBusinessObject(); * * var regex = new Regex("^" + "", RegexOptions.IgnoreCase); * var regex2 = new Regex("^" + "b", RegexOptions.IgnoreCase); * var res2 = await _fbo.FilterAsync(x => regex.IsMatch(x.Name)); * var res3 = await _fbo.FilterAsync(x => regex2.IsMatch(x.Name));*/ }
public ActionResult Delete(int FoodId, FormCollection collection) { try { using (var db = new FoodLogContext()) { db.Foods.Remove(db.Foods.First(food => food.FoodId == FoodId)); db.SaveChanges(); } // TODO: Add delete logic here //foods.Remove(foods.First(food => food.FoodId == FoodId)); return(RedirectToAction("Index")); } catch { return(View()); } }
private IEnumerable <SelectListItem> GetFoodTypeSelectList() { var selectList = new List <SelectListItem>(); using (var db = new FoodLogContext()) { foreach (var foodType in db.FoodTypes.ToList()) { selectList.Add(new SelectListItem() { Value = foodType.Name, Text = foodType.Name }); } } //foreach (var foodType in FoodTypeModel.GetFoodTypeList()) //{ // selectList.Add(new SelectListItem() { Value = foodType.Name, Text = foodType.Name }); //} return(selectList); }
// GET: Food/Edit/5 public ActionResult Edit(int FoodId) { //return View(new FoodViewModel() //{ // Food = foods.First(food => food.FoodId == FoodId), // SelectedFoodType = string.Empty, // FoodTypesSelectList = GetFoodTypeSelectList() //}); FoodModel food; using (var db = new FoodLogContext()) { food = db.Foods.First(t => t.FoodId == FoodId); } return(View(new FoodViewModel() { Food = food, SelectedFoodType = string.Empty, FoodTypesSelectList = GetFoodTypeSelectList() })); }
public BaseDataAccessObject() { _context = new FoodLogContext(); }