public ActionResult FoodAdd(FormCollection fc, HttpPostedFileBase fileFoodItem) { int restaurantId = Convert.ToInt32(fc["hddRestaurantId"]); FoodItem f1 = new FoodItem(); RestaurantFoodCategory rfcate = new RestaurantFoodCategory(); rfcate.FoodCategoryId = Convert.ToInt32(fc["ddlFoodCategory"]); rfcate.RestaurantId = Convert.ToInt32(fc["hddRestaurantId"]);; db.RestaurantFoodCategories.Add(rfcate); db.SaveChanges(); f1.FoodItemName = fc["txtFoodItemName"]; f1.FoodDescription = fc["txtDesc"]; f1.RestaurantId = Convert.ToInt32(fc["hddRestaurantId"]); f1.FoodCategoryId = Convert.ToInt32(fc["ddlFoodCategory"]); f1.FoodItemRate = Convert.ToDouble(fc["txtRate"]); if (fileFoodItem != null) { string fileName = checkfile(fileFoodItem.FileName); string filePath = Path.Combine(Server.MapPath("~/Uploads"), Path.GetFileName(fileName)); fileFoodItem.SaveAs(filePath); f1.FoodItemImage = fileName; } db.FoodItems.Add(f1); db.SaveChanges(); return(RedirectToAction("Foodmenu", new { id = restaurantId })); }
public bool Update(RestaurantProfileVM profile) { Restaurant restaurant = db.Restaurant .Where(r => r.UserId == profile.UserId) .FirstOrDefault(); if (restaurant == null) { restaurant = new Restaurant(); db.Add(restaurant); db.SaveChanges(); } restaurant.UserId = profile.UserId; restaurant.Name = profile.Name; restaurant.PriceCategory = profile.PriceCategory; restaurant.Url = profile.Url; restaurant.StreetAddress = profile.StreetAddress; restaurant.City = profile.City; restaurant.PostalCode = profile.PostalCode; db.SaveChanges(); foreach (var checkbox in profile.FoodCategoryCheckboxes) { if (checkbox.IsChecked) { RestaurantFoodCategory entry = new RestaurantFoodCategory() { FoodCategoryId = checkbox.ID, RestaurantId = restaurant.Id }; db.Add(entry); db.SaveChanges(); } else { ICollection <RestaurantFoodCategory> entries = db.RestaurantFoodCategory .Where(f => f.RestaurantId == restaurant.Id && f.FoodCategoryId == checkbox.ID) .Distinct().ToList(); foreach (var entry in entries) { db.RestaurantFoodCategory.Remove(entry); db.SaveChanges(); } } } PriceCategoryDropdownBuilder helper = new PriceCategoryDropdownBuilder(); profile.PriceCategory = helper.convertType(profile.PriceCategoryString); if (profile.PriceCategory != null) { restaurant.PriceCategory = profile.PriceCategory; db.SaveChanges(); } return(true); }