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
}));
}
