public ActionResult StudioAdd(StudioAdminViewModel model) { if (ModelState.IsValid) { var api = GoPlayApi.Instance; var studio = new Studio() { name = model.name }; studio.id = api.CreateStudio(studio); if (studio.id > 0) { var studioAssignment = new StudioAdminAssignment() { studio_id = studio.id, game_admin_id = CurrentUser.Id }; api.CreateStudioAdminAssignment(studioAssignment); this.Flash(string.Format("Successfully added studio {0}!", model.name), FlashLevel.Success); return Redirect("/admin/studio/" + studio.id); } this.Flash(string.Format("Failure added studio {0}!", model.name), FlashLevel.Error); } return View(model); }
public bool UpdateStudio(Studio studio) { var repo = Repo.Instance; using (var db = repo.OpenConnectionFromPool()) { return repo.UpdateStudio(db, studio); } }
public bool UpdateStudio(IDbConnection db, Studio studio) { studio.updated_at = DateTime.UtcNow; return 1 == db.Execute(@"UPDATE studio SET name = @name, updated_at = @updated_at WHERE id = @id", studio); }
public ActionResult StudioEdit(StudioAdminViewModel model) { if (!ModelState.IsValid) return View("StudioAdd", model); var api = GoPlayApi.Instance; if (!PermissionHelper.HasManageStudio(CurrentUser.GetRoles(), CurrentUser.Id, model.studio_id.Value)) return new HttpStatusCodeResult(403); var studio = new Studio() { id = model.studio_id.Value, name = model.name }; if (api.UpdateStudio(studio)) { this.Flash(string.Format("Successfully updated studio {0}!", model.name), FlashLevel.Success); return Redirect("/admin/studio/" + studio.id); } this.Flash(string.Format("Failure updated studio {0}!", model.name), FlashLevel.Error); return View("StudioAdd", model); }
public int CreateStudio(IDbConnection db, Studio studio) { return db.Query<int>(@"INSERT INTO studio(name) VALUES (@name) RETURNING id;", studio).FirstOrDefault(); }