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