/// <summary>
/// Gets a rating by ID
/// </summary>
/// <param name="output"></param>
/// <param name="id"></param>
/// <returns></returns>
public static bool FetchById(ref StruckRate output, int id)
{
SQLiteDataReader reader = DBI.DoPreparedQuery(
@"SELECT id, user, rate, rank, earned,
COALESCE(expires, -1) AS expires
FROM StruckRate
WHERE id = @id LIMIT 1;" ,
new Tuple <string, object>("@id", id));
if (reader != null && reader.Read())
{
output = StruckRate.Factory(reader);
return(true);
}
return(false);
}
/// <summary>
/// Gets a user's primary rate based on their id and rate id
/// </summary>
/// <param name="output"></param>
/// <param name="uid"></param>
/// <param name="rid"></param>
/// <returns></returns>
public static bool FetchByUserRateId(ref StruckRate output, int uid,
int rid)
{
SQLiteDataReader reader = DBI.DoPreparedQuery(
@"SELECT id, user, rate, rank, earned,
COALESCE(expires, -1) AS expires
FROM StruckRate
WHERE user = @user AND rate = @rate;" ,
new Tuple <string, object>("@user", uid),
new Tuple <string, object>("@rate", rid));
if (reader != null && reader.Read())
{
output = StruckRate.Factory(reader);
return(true);
}
return(false);
}
/// <summary>
/// Fetches a rating by ID
/// </summary>
/// <param name="output"></param>
/// <param name="rate"></param>
/// <returns></returns>
public static bool FetchByRateId(ref List <StruckRate> output,
int rate)
{
output = new List <StruckRate>();
SQLiteDataReader reader = DBI.DoPreparedQuery(
@"SELECT id, user, rate, rank, earned,
COALESCE(expires, -1) AS expires
FROM StruckRate
WHERE id = @id;" ,
new Tuple <string, object>("@id", rate));
while (reader != null && reader.Read())
{
output.Add(StruckRate.Factory(reader));
}
return(true);
}
