ActivEarth.DAO.UserStatisticDAO.GetStatisticFromUserIdAndStatType C# (CSharp) Метод

GetStatisticFromUserIdAndStatType() публичный статический Метод

Retrieves a User's Statistic from the DB based on the user's ID and statistic type.
public static GetStatisticFromUserIdAndStatType ( int userId, Statistic statType ) : UserStatistic
userId int ID of user to fetch statistic info for.
statType Statistic Type of statistic to retrieve from user.
Результат ActivEarth.Objects.Profile.UserStatistic
        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();
            }
        }