<commit_before>﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace LcRest
{
    /// <summary>
    /// 
    /// </summary>
    public class ExperienceLevel
    {
        #region Fields
        public int experienceLevelID;
        public string name;
        public string description;
        public DateTime updatedDate;
        #endregion

        #region Instances
        public ExperienceLevel() { }

        public static ExperienceLevel FromDB(dynamic record)
        {
            if (record == null) return null;
            return new ExperienceLevel
            {
                experienceLevelID = record.experienceLevelID,
                name = record.name,
                description = record.description,
                updatedDate = record.updatedDate
            };
        }
        #endregion

        #region Fetch
        const string sqlGetList = @"
            SELECT  L.experienceLevelID,
                    L.ExperienceLevelName as name,
                    L.ExperienceLevelDescription as description,
                    L.updatedDate
            FROM    ExperienceLevel As L
            WHERE   L.LanguageID = @0 AND L.CountryID = @1
        ";
        const string sqlGetItem = @"
            SELECT  TOP 1
                    L.experienceLevelID,
                    L.ExperienceLevelName as name,
                    L.ExperienceLevelDescription as description,
                    L.updatedDate
            FROM    ExperienceLevel As L
            WHERE   L.LanguageID = @0 AND L.CountryID = @1 AND L.experienceLevelID = @2
        ";

        public static IEnumerable<ExperienceLevel> GetList(int languageID, int countryID)
        {
            using (var db = new LcDatabase())
            {
                return db.Query(sqlGetList, languageID, countryID).Select(FromDB);
            }
        }

        public static ExperienceLevel GetItem(int experienceLevelID, int languageID, int countryID)
        {
            using (var db = new LcDatabase())
            {
                return FromDB(db.QuerySingle(sqlGetList, languageID, countryID, experienceLevelID));
            }
        }
        #endregion
    }
}<commit_msg>fixed bug with experience level in public job title api #392<commit_after>﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace LcRest
{
    /// <summary>
    /// 
    /// </summary>
    public class ExperienceLevel
    {
        #region Fields
        public int experienceLevelID;
        public string name;
        public string description;
        public DateTime updatedDate;
        #endregion

        #region Instances
        public ExperienceLevel() { }

        public static ExperienceLevel FromDB(dynamic record)
        {
            if (record == null) return null;
            return new ExperienceLevel
            {
                experienceLevelID = record.experienceLevelID,
                name = record.name,
                description = record.description,
                updatedDate = record.updatedDate
            };
        }
        #endregion

        #region Fetch
        const string sqlGetList = @"
            SELECT  L.experienceLevelID,
                    L.ExperienceLevelName as name,
                    L.ExperienceLevelDescription as description,
                    L.updatedDate
            FROM    ExperienceLevel As L
            WHERE   L.LanguageID = @0 AND L.CountryID = @1
        ";
        const string sqlGetItem = @"
            SELECT  TOP 1
                    L.experienceLevelID,
                    L.ExperienceLevelName as name,
                    L.ExperienceLevelDescription as description,
                    L.updatedDate
            FROM    ExperienceLevel As L
            WHERE   L.LanguageID = @0 AND L.CountryID = @1 AND L.experienceLevelID = @2
        ";

        public static IEnumerable<ExperienceLevel> GetList(int languageID, int countryID)
        {
            using (var db = new LcDatabase())
            {
                return db.Query(sqlGetList, languageID, countryID).Select(FromDB);
            }
        }

        public static ExperienceLevel GetItem(int experienceLevelID, int languageID, int countryID)
        {
            using (var db = new LcDatabase())
            {
                return FromDB(db.QuerySingle(sqlGetItem, languageID, countryID, experienceLevelID));
            }
        }
        #endregion
    }
}
{'fraction_non_alphanumeric': 0.06755852842809365, 'fraction_numerical': 0.0033444816053511705, 'mean_word_length': 1.5387662705149971, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '808156', 'n_tokens_mistral': 1108, 'n_tokens_neox': 1056, 'n_words': 296}