public ActionResult Edit(string id, SpotPhotoViewModel spotPhotoViewModel, HttpPostedFileBase tourism_photo, String oldImg)
{
db.Entry(spotPhotoViewModel).State = EntityState.Modified;
db.SaveChanges();
string fileName = "";
if (tourism_photo != null)
{
if (tourism_photo.ContentLength > 0)
{
System.IO.File.Delete(Server.MapPath("~/images/spot/" + oldImg));
fileName = System.IO.Path.GetFileName(tourism_photo.FileName); //取得檔案的檔名(主檔名+副檔名)
tourism_photo.SaveAs(Server.MapPath("~/images/spot/" + fileName)); //將檔案存到該資料夾
}
}
else
{
fileName = oldImg;
}
var tp1 = db.tourism_photo.Where(m => m.tourism_id == id).FirstOrDefault();
tp1.tourism_photo1 = fileName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(string id)
{
SpotPhotoViewModel model = new SpotPhotoViewModel()
{
spot = db.spots.Where(m => m.spot_id == id).FirstOrDefault(),
spot_photos = db.tourism_photo.Where(m => m.tourism_id == id).FirstOrDefault()
};
return(View(model));
}
public ActionResult Edit(string id, SpotPhotoViewModel spotPhotoViewModel, HttpPostedFileBase[] tourism_photo, String oldImg)
{
spotPhotoViewModel.spot.update_date = DateTime.Now;
db.Entry(spotPhotoViewModel.spot).State = EntityState.Modified;
db.SaveChanges();
//圖片
string fileName = "";
var tp1 = db.tourism_photo.Where(m => m.tourism_id == id).ToList();
for (int i = 0; i < 3; i++)
{
if (tourism_photo[i] != null)
{
//如果有新增檔案到input
if (tourism_photo[i].ContentLength > 0)
{
//改名
string t = tourism_photo[i].FileName;
fileName = spotPhotoViewModel.spot.spot_id + "_" + DateTime.Now.ToString().Replace("/", "").Replace(":", "").Replace(" ", "") + (i + 1).ToString() + Path.GetExtension(t);
if (i < tp1.Count) //如果原有紀錄
{
//刪掉原檔案
System.IO.File.Delete(Server.MapPath("~/images/spot/" + tp1[i].tourism_photo1));
tourism_photo[i].SaveAs(Server.MapPath("~/images/spot/" + fileName)); //將檔案存到該資料夾
//改掉資料庫檔案
tp1[i].tourism_photo1 = fileName;
}
else //如果原本沒有
{
tourism_photo tp = new tourism_photo();
tp.tourism_photo1 = fileName;
tourism_photo[i].SaveAs(Server.MapPath("~/images/spot/" + fileName));
tp.tourism_id = spotPhotoViewModel.spot.spot_id;
db.tourism_photo.Add(tp);
}
}
//else
//{
//}
}
//else //if(String.IsNullOrEmpty(oldImg))
//{
// tourism_photo tp = new tourism_photo();
// tp.tourism_photo1 = fileName;
// tp.tourism_id = spotPhotoViewModel.spot.spot_id;
// db.tourism_photo.Add(tp);
//}
}
db.SaveChanges();
return(RedirectToAction("Index", new { page = Session["pg"] }));
}