//刪除
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"));
}
