public ActionResult CreateNewLanguage()
        {
            TittleLanguageServices _LangService = new TittleLanguageServices();
            List <CustomLanguage>  langs        = _LangService.GetLanguagesList();
            CustomNewLanguage      model        = new CustomNewLanguage();

            model.AddedLanguages     = langs;
            model.AvailableLanguages = new Dictionary <string, string>();
            foreach (var item in CoreKeyValue.AvailableLanguages)
            {
                bool isFound = false;
                foreach (var lang in langs)
                {
                    if (item.Value == lang.LangLabel)
                    {
                        isFound = true;
                        break;
                    }
                }
                if (!isFound)
                {
                    model.AvailableLanguages.Add(item.Key, item.Value);
                }
            }
            return(PartialView("CreateNewLanguage", model));
        }
        /// <summary>
        /// Save or update Language info
        /// </summary>
        /// <param name="newLang"></param>
        /// <param name="nID"></param>
        /// <returns></returns>
        public string SaveOrUpdateLanguage(CustomNewLanguage newLang, ref long nID)
        {
            string sMessage = "Success";

            language obj = new language();


            using (var db = new TittleEntities())
            {
                obj.locale     = newLang.locale;
                obj.label      = newLang.langLabel;
                obj.created_at = DateTime.Now;
                obj.updated_at = DateTime.Now;
                db.languages.Add(obj);
                db.SaveChanges();

                //add entry in translation
                StringBuilder strQuery = new StringBuilder();
                strQuery.Append("INSERT INTO `translations` ");
                strQuery.Append("(`language_id`,`key_id`,`value`,`created_at`,`updated_at`) ");
                strQuery.Append("select " + obj.id.ToString() + ",id,'',NOW(),NOW() from `keys`");
                var _dataQuery = db.Database.ExecuteSqlCommand(strQuery.ToString());
                nID = obj.id;
            }

            return(sMessage);
        }
        public ActionResult CreateNewLanguage(CustomNewLanguage model)
        {
            string sMessage = "";

            if (ModelState.IsValid)
            {
                TittleLanguageServices languageService = new TittleLanguageServices();
                long nID = 0;

                sMessage = languageService.SaveOrUpdateLanguage(model, ref nID);
            }

            return(Json(new
            {
                message = sMessage
            }));
        }