public ModRequestViewModel GetModRequest() { ModRequestViewModel my = new ModRequestViewModel(); my._Requests = _connection.Query <Request>("SELECT * FROM Request WHERE Pending = 1"); return(my); }
public IActionResult ProcessMod(ModRequestViewModel req) { if (req.response.Status == 1) { _upload.SetAccess(req.response.ForumID, req.response.UID); } _edit.UpdateModRequest(req); return(Redirect(nameof(ModRequest))); }
public bool HasRequested(Forum reqForum, string user) { ModRequestViewModel my = new ModRequestViewModel(); my._Requests = _connection.Query <Request>("SELECT * FROM Request WHERE Pending = 1"); if (my._Requests.Count() == 0) { return(false); } foreach (var request in my._Requests) { if (reqForum.FName == request.ForumID && request.Pending == true && request.UID == user) { return(true); } } return(false); }
public void UpdateModRequest(ModRequestViewModel update) { _connection.Execute($@"UPDATE Request SET Pending = @{nameof(update.response.Pending)}, Status = @{nameof(update.response.Status)} WHERE Id = @{nameof(update.response.Id)}", new { update.response.Pending, update.response.Status, update.response.Id }); }