public static UserStatistic GetStatisticFromUserIdAndStatType(int userId, Statistic statType)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from p in data.UserStatisticDataProviders
where p.user_id == userId
&& p.statistic_type.Equals((byte)statType)
select new UserStatistic((Statistic)p.statistic_type, (float)p.value)
{
UserStatisticID = p.id,
UserID = p.user_id
}).FirstOrDefault();
}
}