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