public SW_Lang GetLang(string langShortName)
        {
            HttpContext c = HttpContext.Current;

            SW_Lang getLang = (SW_Lang)c.Cache["getlang-" + langShortName];

            if (getLang == null)
            {
                Searchwar_netEntities db = new Searchwar_netEntities();

                getLang = (from L in db.SW_Lang
                           where L.LangShortname.ToLower() == langShortName
                           select L).SingleOrDefault <SW_Lang>();

                // add Cache
                c.Cache.Add("getlang-" + langShortName, getLang,
                            null,
                            TimeZoneManager.DateTimeNow.AddMonths(1),
                            System.Web.Caching.Cache.NoSlidingExpiration,
                            System.Web.Caching.CacheItemPriority.Normal,
                            null);
            }



            return(getLang);
        }
        public SW_Lang GetLang(int langaugeId)
        {
            using (Searchwar_netEntities db = new Searchwar_netEntities())
            {
                SW_Lang Result = (from L in db.SW_Lang
                                  where L.LangId.Equals(langaugeId)
                                  select L).SingleOrDefault <SW_Lang>();



                return(Result);
            }
        }