public ActionResult DeleteConfirmed(int id) { RaidInstance raidInstance = db.RaidInstance.Find(id); db.RaidInstance.Remove(raidInstance); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "RaidInstanceID,RaidID,RaidDate,Progression,RaidCleared,RaidRunTime")] RaidInstance raidInstance) { if (ModelState.IsValid) { db.Entry(raidInstance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RaidID = new SelectList(db.Raid, "RaidID", "RaidName", raidInstance.RaidID); return(View("~/Views/Admin/RaidInstances/Edit.cshtml", raidInstance)); }
// GET: RaidInstances/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RaidInstance raidInstance = db.RaidInstance.Find(id); if (raidInstance == null) { return(HttpNotFound()); } return(View("~/Views/Admin/RaidInstances/Details.cshtml", raidInstance)); }
// GET: RaidInstances/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RaidInstance raidInstance = db.RaidInstance.Find(id); if (raidInstance == null) { return(HttpNotFound()); } ViewBag.RaidID = new SelectList(db.Raid, "RaidID", "RaidName", raidInstance.RaidID); return(View("~/Views/Admin/RaidInstances/Edit.cshtml", raidInstance)); }
private void EnsureLoaded() { using (new ReaderLock(_lock)) { if (_loaded) return; using (new WriterLock(_lock)) { if (_loaded) return; Connection.ExecuteSql(new Query(RAID_INSTANCE_SELECT), delegate(SqlDataReader reader) { while (reader.Read()) { var newRaidInstance = new RaidInstance() { ID = (int)reader[0], Raid = reader[1].ToString(), Name = reader[2].ToString(), Description = reader[3].ToString(), InviteTime = (DateTime)reader[4], StartTime = (DateTime)reader[5], Archived = (bool)reader[6] }; _cache.Add(newRaidInstance); } }); _loaded = true; } } }
public bool TryUnArchive(RaidInstance instance, out string errorMsg) { EnsureLoaded(); using (new ReaderLock(_lock)) { if (false == instance.Archived) { errorMsg = "Cannot un-archive a non-archived raid."; return false; } using (new WriterLock(_lock)) { if (false == instance.Archived) { errorMsg = "Cannot un-archive a non-archived raid."; return false; } var success = false; Connection.ExecuteSql(new Query(RAID_INSTANCE_SET_ARCHIVE) .AddParam("IsArchived", false) .AddParam("ID", instance.ID), delegate(SqlDataReader reader) { if (0 == reader.RecordsAffected) return; success = true; }); errorMsg = ""; if (success) _cache.Find(ri => ri.ID == instance.ID).Archived = false; else errorMsg = "Datastore failure when un-archiving the raid instance. Please contact the administrator."; return success; } } }
public bool TryModify(RaidInstance instance, out string errorMsg) { EnsureLoaded(); using (new ReaderLock(_lock)) { RaidInstance ri; if (null == (ri = ReadOneOrDefault(i => i.ID == instance.ID))) { errorMsg = "You cannot edit a raid that does not exist."; return false; } if (DateTime.Compare(instance.InviteTime, DateTime.Now) < 0) { errorMsg = "You cannot schedule a raid in the past."; return false; } if (DateTime.Compare(instance.StartTime, instance.InviteTime) < 0) { errorMsg = "The start time cannot be before the invite time."; return false; } using (new WriterLock(_lock)) { if (null == (ri = ReadOneOrDefault(i => i.ID == instance.ID))) { errorMsg = "You cannot edit a raid that does not exist."; return false; } var success = false; if (null == instance.Description) instance.Description = ""; Connection.ExecuteSql(new Query(RAID_INSTANCE_UPDATE) .AddParam("ID", instance.ID) .AddParam("Raid", instance.Raid) .AddParam("Name", instance.Name) .AddParam("Description", instance.Description) .AddParam("InviteTime", instance.InviteTime) .AddParam("StartTime", instance.StartTime), delegate(SqlDataReader reader) { if (0 == reader.RecordsAffected) return; success = true; }); errorMsg = ""; if (success) { ri.Raid = instance.Raid; ri.Name = instance.Name; ri.Description = instance.Description; ri.InviteTime = instance.InviteTime; ri.StartTime = instance.StartTime; } else errorMsg = "Datastore failure when modifying the raid instance. Please contact the administrator."; return success; } } }
public bool TryCreate(RaidInstance instance, out string errorMsg) { EnsureLoaded(); using (new ReaderLock(_lock)) { if (DateTime.Compare(instance.InviteTime, DateTime.Now) < 0) { errorMsg = "You cannot schedule a raid in the past."; return false; } if (DateTime.Compare(instance.StartTime, instance.InviteTime) < 0) { errorMsg = "The start time cannot be before the invite time."; return false; } using (new WriterLock(_lock)) { var success = false; if (null == instance.Description) instance.Description = ""; object id = Connection.ExecuteSqlScalar(new Query(RAID_INSTANCE_INSERT) .AddParam("Raid", instance.Raid) .AddParam("Name", instance.Name) .AddParam("Description", instance.Description) .AddParam("InviteTime", instance.InviteTime) .AddParam("StartTime", instance.StartTime)); if (null != id) { instance.ID = (int)((decimal)id); success = true; } errorMsg = ""; if (success) _cache.Add(instance); else errorMsg = "Datastore failure when creating the raid instance. Please contact the administrator."; return success; } } }
private static Item Item(Item item, RaidInstance instance) { item.Instance = instance; return(item); }