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