public ActionResult Delete(int id, string returnURL) { if (Session["admin"] != null) { SpotPics spotPic = db.SpotPics.Find(id); db.SpotPics.Remove(spotPic); Layout layout = db.Layout.Find(spotPic.LayoutId); string buildingId = layout.BuildingId.ToString(); UpdateRecord record = db.UpdateRecord.Where(item => item.BuildingId == buildingId).FirstOrDefault(); if (record != null) { record.UpdateTime = DateTime.Now; db.Entry(record).State = EntityState.Modified; } else { record = new UpdateRecord(); record.BuildingId = buildingId; record.UpdateTime = DateTime.Now; db.UpdateRecord.Add(record); } db.SaveChanges(); return(Redirect(returnURL)); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult Details(int id) { if (Session["admin"] != null) { SpotPics spotPis = db.SpotPics.Find(id); ViewBag.Details = true; return(View("Edit", spotPis)); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult GetSpotDetail(int spotId) { SpotPics spot = db.SpotPics.Find(spotId); SpotPicsDetailData spotDetail = new SpotPicsDetailData(); spotDetail.SpotId = spotId; spotDetail.SpotPics = spot.SpotDetails.Substring(0, spot.SpotDetails.Length - 1).Split(' '); for (int i = 0; i < spotDetail.SpotPics.Length; i++) { spotDetail.SpotPics[i] = ConfigurationManager.AppSettings["ResourceUrl"] + spotDetail.SpotPics[i]; } return(Json(new { data = spotDetail }, JsonRequestBehavior.AllowGet)); }
public ActionResult SavEdit(SpotPics spotPic, bool IsCreate) { if (Session["admin"] != null) { spotPic.CreateTime = DateTime.Now.ToString("yyyy-MM-dd"); spotPic.SpotIndex = ToSmall(spotPic.SpotIndex); StringBuilder sb = new StringBuilder(); string[] pics = spotPic.SpotDetails.Substring(0, spotPic.SpotDetails.Length - 1).Split(' '); foreach (var pic in pics) { sb.Append(ToSmall(pic)); sb.Append(" "); } spotPic.SpotDetails = sb.ToString(); if (IsCreate) { db.Entry(spotPic).State = EntityState.Modified; } else { db.SpotPics.Add(spotPic); } db.SaveChanges(); Layout layout = db.Layout.Find(spotPic.LayoutId); string buildingId = layout.BuildingId.ToString(); UpdateRecord record = db.UpdateRecord.Where(item => item.BuildingId == buildingId).FirstOrDefault(); if (record != null) { record.UpdateTime = DateTime.Now; db.Entry(record).State = EntityState.Modified; } else { record = new UpdateRecord(); record.BuildingId = buildingId; record.UpdateTime = DateTime.Now; db.UpdateRecord.Add(record); } db.SaveChanges(); return(RedirectToAction("List", new { id = spotPic.LayoutId })); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult Edit(int id) { if (Session["admin"] != null) { SpotPics spotPIc = db.SpotPics.Find(id); Layout layout = db.Layout.Find(spotPIc.LayoutId); ViewBag.LayId = layout.Id; ViewBag.LayName = layout.LayoutName; Building build = db.Building.Find(layout.BuildingId); ViewBag.BuildId = build.Id; ViewBag.BuildName = build.BuildingName; ViewBag.IsCreate = true; return(View(spotPIc)); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult Create(int id) { if (Session["admin"] != null) { ViewBag.IsCreate = false; SpotPics spotPics = new SpotPics(); spotPics.LayoutId = id; Layout layout = db.Layout.Find(id); ViewBag.LayName = layout.LayoutName; ViewBag.LayId = id; Building build = db.Building.Find(layout.BuildingId); ViewBag.BuildId = build.Id; ViewBag.BuildName = build.BuildingName; return(View("Edit", spotPics)); } else { return(RedirectToAction("Login", "Console")); } }