// GET: Language
public ActionResult Index()
{
var model = new LanguageCreateViewModel();
SqlConnectionCommon.Open();
var data = SqlConnectionCommon.Query<Language>("LanguageGetAll", new { culture = string.Empty }, commandType: CommandType.StoredProcedure);
SqlConnectionCommon.Close();
model.Languages = data.ToList();
return View(model);
}
public ActionResult Create()
{
var model = new LanguageCreateViewModel();
SqlConnectionCommon.Open();
var languageSystems = SqlConnectionCommon.Query<string>("LanguageSystem", commandType: CommandType.StoredProcedure).ToList();
SqlConnectionCommon.Close();
model.Languages = languageSystems.Select(languageSystem => new Language { LCIDForLocale = languageSystem }).ToList();
return View(model);
}
public ActionResult LanguageInsertUpdate(LanguageCreateViewModel model)
{
SqlConnectionCommon.Open();
var userId = User.Identity.Name;
// Insert Language
if (!string.IsNullOrEmpty(model.LanguageCode))
{
SqlConnectionCommon.Query<int>("LanguageInsertUpdate", new
{
model.Id,
model.Locale,
model.LanguageCode,
model.LCIDString,
model.LCIDDecimal,
model.LCIDHexadecimal,
model.Codepage,
model.Tooltip,
LCIDForLocale = model.LCIDString
}, commandType: CommandType.StoredProcedure);
}
// Update Language
foreach (var item in model.Languages)
{
if (!string.IsNullOrEmpty(item.Locale))
{
SqlConnectionCommon.Query<int>("LanguageInsertUpdate", new
{
item.Id,
item.Locale,
model.LanguageCode,
model.LCIDString,
model.LCIDDecimal,
model.LCIDHexadecimal,
model.Codepage,
item.Tooltip,
item.LCIDForLocale
}, commandType: CommandType.StoredProcedure);
}
}
SqlConnectionCommon.Close();
//return Json(new { result = 1 });
return Redirect("/language");
}
public ActionResult Edit(int id)
{
var model = new LanguageCreateViewModel();
SqlConnectionCommon.Open();
var languages = SqlConnectionCommon.Query<Language>("LanguageGetAll", new { culture = "en" }, commandType: CommandType.StoredProcedure).ToList();
var editLanguage = SqlConnectionCommon.Query<Language>("LanguageByCode", new { code = id }, commandType: CommandType.StoredProcedure).ToList();
SqlConnectionCommon.Close();
if (languages.Count != 0)
{
var newLanguages = languages.Where(p => editLanguage.All(p2 => p2.LCIDForLocale != p.LCIDForLocale));
editLanguage.AddRange(newLanguages.Select(newLanguage => new Language
{
LCIDForLocale = newLanguage.LCIDForLocale
}));
}
model.Languages = editLanguage;
return View(model);
}