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