//刪除 public ActionResult Delete(int id) { tMealClass removeMealClass = db.tMealClass.Where(m => m.fRe_ID == id).Single(); db.tMealClass.Remove(removeMealClass); db.SaveChanges(); db.tRestaurant.Remove(db.tRestaurant.Find(id)); db.SaveChanges(); //轉到Index Action顯示刪除完的結果 return(new EmptyResult()); }
public ActionResult AddRestaurant(tRestaurant restaurant, HttpPostedFileBase RestaurantImg, List <string> chkfoodclass, string rd1, int fEp_ID = 2) { if (ModelState.IsValid) { if (RestaurantImg != null && RestaurantImg.ContentLength > 0) { //先在messageCode建立一個流水號 tMessageCode newCode = new tMessageCode(); db.tMessageCode.Add(newCode); db.SaveChanges(); restaurant.fMC_ID = db.tMessageCode.ToList().Last().fMC_ID; //將上傳的圖轉成二進位 var imgSize = RestaurantImg.ContentLength; byte[] imgByte = new byte[imgSize]; RestaurantImg.InputStream.Read(imgByte, 0, imgSize); restaurant.fRe_Image = imgByte; //將tRe_site地址轉座標 var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}", Uri.EscapeDataString(restaurant.fRe_Addr)); var request = WebRequest.Create(requestUri); var response = request.GetResponse(); var xdoc = XDocument.Load(response.GetResponseStream()); var result = xdoc.Element("GeocodeResponse").Element("result"); var locationElement = result.Element("geometry").Element("location"); var lat = locationElement.Element("lat"); var lng = locationElement.Element("lng"); double latitude = Double.Parse(lat.Value); double lngitude = Double.Parse(lng.Value); restaurant.fRe_site = String.Format("{0},{1}", Convert.ToString(latitude), Convert.ToString(lngitude)); //後來要看使用者是誰 先給EPID預設值2 restaurant.fEp_ID = fEp_ID; if (rd1 == "Yes") { restaurant.fRe_Delivery = true; } else { restaurant.fRe_Delivery = false; } db.tRestaurant.Add(restaurant); db.SaveChanges(); //meal篩選 tMealClass newMealC = new tMealClass(); int RestaurantLastID = db.tRestaurant.AsEnumerable().Last().fRe_ID; foreach (string mealidnum in chkfoodclass) { newMealC.fML_ID = Convert.ToInt32(mealidnum); newMealC.fRe_ID = RestaurantLastID; db.tMealClass.Add(newMealC); db.SaveChanges(); } return(RedirectToAction("Index", "FoodHome")); } else { ViewBag.message = "請選擇圖檔!!"; } } ViewBag.datas = db.tRestaurant.ToList(); return(RedirectToAction("Index", "FoodHome")); }