public ActionResult Create(tMessageCode mescode, tForumTitle title, tForumMessage message) { if (Request.Cookies["account"] == null) { return(RedirectToAction("Index", "ForumHome")); } string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; db.tMessageCode.Add(mescode); db.SaveChanges(); title.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; title.fEp_ID = EP_ID; title.fFT_Date = DateTime.Now; message.fEp_ID = EP_ID; message.fFM_Date = DateTime.Now; message.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; db.tForumTitle.Add(title); db.tForumMessage.Add(message); db.SaveChanges(); return(RedirectToAction("Index", "ForumHome")); }
//刪除文章 public ActionResult Delete(int?id) { var FTid = db.tForumTitle.Where(p => p.fMC_ID == id).Single().fFT_ID; var FMid = db.tForumMessage.Where(p => p.fMC_ID == id).Single().fFM_ID; tMessageCode deleCode = db.tMessageCode.Find(id); tForumTitle deleTitle = db.tForumTitle.Find(FTid); tForumMessage deleMessage = db.tForumMessage.Find(FMid); db.tMessageCode.Remove(deleCode); db.tForumTitle.Remove(deleTitle); db.tForumMessage.Remove(deleMessage); db.SaveChanges(); return(RedirectToAction("Index", "ForumMyself")); }
public ActionResult CreateDetail(tTravelDetail _TravelDetail, HttpPostedFileBase fImage, string fTD_site) { if (ModelState.IsValid) { if (fImage != null && fImage.ContentLength > 0) { tMessageCode _MCode = new tMessageCode(); db.tMessageCode.Add(_MCode); db.SaveChanges(); //將上傳的圖轉成二進位 var imgSize = fImage.ContentLength; byte[] imgByte = new byte[imgSize]; fImage.InputStream.Read(imgByte, 0, imgSize); _TravelDetail.fTD_Image = imgByte; //將tTD_side地址轉座標 var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}", Uri.EscapeDataString(fTD_site)); 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); _TravelDetail.fTD_site = String.Format("{0},{1}", Convert.ToString(latitude), Convert.ToString(lngitude)); _TravelDetail.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; db.tTravelDetail.Add(_TravelDetail); db.SaveChanges(); return(RedirectToAction("Index", "TravelMapHome")); } else { ViewBag.message = "請選擇圖檔!!"; } } return(View()); }
public ActionResult tPhotoCreate([Bind(Include = "fPh_ID,fPh_PicFile,fAl_ID,fPh_Date,fPh_Notes,fMC_ID")] tPhoto tPhoto, HttpPostedFileBase[] photoImage) { try { if (ModelState.IsValid) { if (photoImage != null && photoImage.Count() > 0) { foreach (var uploadFile in photoImage) { if (uploadFile.ContentLength > 0) { var imgSize = uploadFile.ContentLength; byte[] imgByte = new byte[imgSize]; uploadFile.InputStream.Read(imgByte, 0, imgSize); tMessageCode tMessageCode = new tMessageCode(); db.tMessageCode.Add(tMessageCode); db.SaveChanges(); tPhoto.fPh_Notes = ""; tPhoto.fPh_PicFile = imgByte; tPhoto.fPh_Date = DateTime.Now; tPhoto.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; db.tPhoto.Add(tPhoto); db.SaveChanges(); } } return(RedirectToAction("Photo", "Albums", new { area = "Albums", id = tPhoto.fAl_ID })); } } ViewBag.fAl_ID = new SelectList(db.tAlbum, "fAl_ID", "fAl_ID", tPhoto.fAl_ID); ViewBag.fMC_ID = new SelectList(db.tMessageCode, "fMC_ID", "fMC_ID", tPhoto.fMC_ID); return(View(tPhoto)); } catch (Exception ex) { return(RedirectToAction("Index", "Albums", new { area = "Albums" })); } }
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")); }