public ActionResult CreateCity(tCityCountry _city, HttpPostedFileBase fImage, string fCountry, string fCity) { if (ModelState.IsValid) { if (fImage != null && fImage.ContentLength > 0) { //檢查國家是否重複新增 //若有則直接新增城市 //若無則先新增國家在新增城市 var _country = from c in db.tCityCountry where (c.fCC_Place == fCountry) select c; if (_country.Count() == 0) { _city.fCC_Dad = null; _city.fCC_Place = fCountry; db.tCityCountry.Add(_city); db.SaveChanges(); tCityCountry tcc = new tCityCountry(); tcc.fCC_Dad = db.tCityCountry.AsEnumerable().Last().fCC_ID; tcc.fCC_Place = fCity; //將上傳的圖轉成二進位 var imgSize = fImage.ContentLength; byte[] imgByte = new byte[imgSize]; fImage.InputStream.Read(imgByte, 0, imgSize); tcc.fCC_Img = imgByte; db.tCityCountry.Add(tcc); db.SaveChanges(); } else { _city.fCC_Dad = _country.Single().fCC_ID; _city.fCC_Place = fCity; //將上傳的圖轉成二進位 var imgSize = fImage.ContentLength; byte[] imgByte = new byte[imgSize]; fImage.InputStream.Read(imgByte, 0, imgSize); _city.fCC_Img = imgByte; db.tCityCountry.Add(_city); db.SaveChanges(); } return(RedirectToAction("Index", "TravelMapHome")); } else { ViewBag.message = "請選擇圖檔!!"; } } return(View()); }
public ActionResult GetImageByte(int id) { tCityCountry _citycountry = db.tCityCountry.Find(id); byte[] img = _citycountry.fCC_Img; try { return(File(img, "image/jpeg")); } catch { return(View()); } }
public ActionResult Edit(HttpPostedFileBase fImage) { tCityCountry _ct = db.tCityCountry.Find(Convert.ToInt32(Request.Form["cityID"])); _ct.fCC_Place = Request.Form["CityName"]; //將上傳的圖轉成二進位 var imgSize = fImage.ContentLength; byte[] imgByte = new byte[imgSize]; fImage.InputStream.Read(imgByte, 0, imgSize); _ct.fCC_Img = imgByte; db.Entry(_ct).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ShowAll")); }
public ActionResult Index(tCityCountry _city, tSampleProposal _proposal, List <string> ActCheckbox) { _proposal.fCC_ID = _city.fCC_ID; _proposal.fSP_Date = DateTime.Now; db.tSampleProposal.Add(_proposal); db.SaveChanges(); int a = db.tSampleProposal.AsEnumerable().Last().fSP_ID; tActivitySelect _actselect = new tActivitySelect(); foreach (string _actlist in ActCheckbox) { _actselect.fSP_ID = a; _actselect.fAL_ID = Convert.ToInt32(_actlist); db.tActivitySelect.Add(_actselect); db.SaveChanges(); } return(RedirectToAction("Index", "Activity")); }