ActivEarth.DAO.BadgeDAO.GetBadgeFromUserIdAndStatistic C# (CSharp) Метод

        public static Badge GetBadgeFromUserIdAndStatistic(int userId, Statistic statistic)
        {
            using (SqlConnection connection = ConnectionManager.GetConnection())
            {
                var data = new ActivEarthDataProvidersDataContext(connection);
                Badge badge = (from c in data.BadgeDataProviders
                               where c.user_id == userId && c.statistic == (byte)statistic
                               select
                                   new Badge
                                   {
                                       ID = c.id,
                                       UserID = c.user_id,
                                       StatisticBinding = (Statistic)c.statistic,
                                       Level = c.badge_level,
                                       Progress = c.progress
                                   }).FirstOrDefault();

                if (badge != null) { LoadExternalBadgeData(badge); }

                return badge;
            }
        }