/// <summary>
        /// Gets the general.
        /// </summary>
        /// <param name="name">The name.</param>
        /// <param name="lang">The language.</param>
        /// <returns>get General</returns>
        public C_General GetGeneral(string name, string lang)
        {
            using (var data = new Entities())
            {
                try
                {
                    if (string.IsNullOrEmpty(lang))
                    {
                        lang = LanguageModels.ActiveLanguage().LangCultureName;
                    }

                    var c_gen = data.C_General.Where(p => p.GeneralName == name && p.Lang.Trim().ToLower() == lang.Trim().ToLower()).FirstOrDefault();
                    return(c_gen);
                }
                catch (Exception ex)
                {
                    return(new C_General());
                }
            }
        }
        /// <summary>
        /// Gets the content.
        /// </summary>
        /// <param name="name">The name.</param>
        /// <param name="lang">The language.</param>
        /// <returns>Get Content</returns>
        public static string GetContent(string name, string lang)
        {
            using (var data = new Entities())
            {
                try
                {
                    if (string.IsNullOrEmpty(lang))
                    {
                        lang = LanguageModels.ActiveLanguage().LangCultureName;
                    }

                    var c_gen = data.C_General.Where(p => p.GeneralName == name && p.Lang.Trim().ToLower() == lang.Trim().ToLower() && p.Show == true).FirstOrDefault();

                    return(c_gen.GeneralContent ?? string.Empty);
                }
                catch (Exception)
                {
                    return(string.Empty);
                }
            }
        }