public IActionResult Index() { var fooditemList = _context.FoodItems. AsNoTracking().Include(q => q.MealHour).ToList(); var ReuiredMaterialAvailable = _context.RequiredMaterial. AsNoTracking().ToList(); var fooditem = (from a in fooditemList join b in ReuiredMaterialAvailable on a.FoodItemId equals b.FoodItemId select new { FoodName = a.FoodName, MealHourName = a.MealHour.MealHourTitle, Description = a.Description, Price = a.Price, FoodItemId = a.FoodItemId, PhotoPath = a.PhotoPath, }).Distinct(); var fooditemvmlist = new List <FoodItemVm>(); foreach (var item in fooditem) { FoodItemVm fooditemvm = new FoodItemVm() { FoodName = item.FoodName, MealHourName = item.MealHourName, Description = item.Description, Price = item.Price, FoodItemId = item.FoodItemId, ExistingPhoto = item.PhotoPath }; fooditemvmlist.Add(fooditemvm); } return(View(fooditemvmlist)); }
public IActionResult UpdateFoodItem(FoodItemVm a) { FoodItem foodItem = _context.FoodItems.AsNoTracking() .Where(a => a.FoodItemId == a.FoodItemId).FirstOrDefault(); foodItem.FoodName = a.FoodName; foodItem.Description = a.Description; foodItem.Price = a.Price; foodItem.FoodItemId = a.FoodItemId; foodItem.MealHourId = a.MealHourId; if (a.Photopath != null) { if (a.ExistingPhoto != null) { string filePath = Path.Combine(hostingEnvironment.WebRootPath, "images", a.ExistingPhoto); System.IO.File.Delete(filePath); } foodItem.PhotoPath = UploadedFile(a); } _context.FoodItems.Update(foodItem); _context.SaveChanges(); ModelState.Clear(); return(RedirectToAction("FoodItemList")); }
public IActionResult FoodItemList(int Page = 1) { var a = _context.FoodItems.AsNoTracking().Include(s => s.MealHour).ToList(); var s = new List <FoodItemVm>(); int c = 1; foreach (var item in a) { FoodItemVm ab = new FoodItemVm() { Serial = c, FoodName = item.FoodName, MealHourName = item.MealHour.MealHourTitle, Price = item.Price, Description = item.Description, FoodItemId = item.FoodItemId, ExistingPhoto = item.PhotoPath }; s.Add(ab); c++; } var list = s.ToPagedList(Page, 5); return(View(list)); }
public IActionResult AddFoodItem(FoodItemVm a) { var valid = _context.FoodItems.AsNoTracking(). Where(t => t.FoodName == a.FoodName).FirstOrDefault(); if (valid != null) { ViewBag.Validation = "You have already added " + a.FoodName + "."; ViewBag.MealHour = new SelectList(_context.MealHour.AsNoTracking(). ToList(), "MealHourId", "MealHourTitle"); return(View()); //RedirectToAction("AddFoodItem"); } string uniqueFileName = UploadedFile(a); FoodItem p = new FoodItem() { FoodName = a.FoodName, Description = a.Description, Price = a.Price, FoodItemId = a.FoodItemId, MealHourId = a.MealHourId, PhotoPath = uniqueFileName }; _context.FoodItems.Add(p); _context.SaveChanges(); ViewBag.Success = "You have succesfully added " + a.FoodName + "."; ModelState.Clear(); ViewBag.MealHour = new SelectList(_context.MealHour.AsNoTracking(). ToList(), "MealHourId", "MealHourTitle"); return(View()); }
private string UploadedFile(FoodItemVm model) { string uniqueFileName = null; if (model.Photopath != null) { string uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "images"); uniqueFileName = Guid.NewGuid().ToString() + "_" + model.Photopath.FileName; string filePath = Path.Combine(uploadsFolder, uniqueFileName); using (var fileStream = new FileStream(filePath, FileMode.Create)) { model.Photopath.CopyTo(fileStream); } } return(uniqueFileName); }
public IActionResult UpdateFoodItem(int id) { var foodItem = _context.FoodItems.AsNoTracking() .Where(t => t.FoodItemId == id).FirstOrDefault(); FoodItemVm m = new FoodItemVm() { FoodItemId = foodItem.FoodItemId, Price = foodItem.Price, Description = foodItem.Description, MealHourId = foodItem.MealHourId, FoodName = foodItem.FoodName, ExistingPhoto = foodItem.PhotoPath }; ViewBag.MealHour = new SelectList(_context.MealHour.AsNoTracking(). ToList(), "MealHourId", "MealHourTitle"); return(View(m)); }