public ActionResult Edit(int id)
{
var culture = System.Threading.Thread.CurrentThread.CurrentUICulture.Name.ToLowerInvariant();
var model = new PageContentCreateViewModel();
SqlConnectionCommon.Open();
var languages = SqlConnectionCommon.Query<Language>("LanguageGetAll", new { culture = string.Empty }, commandType: CommandType.StoredProcedure).ToList();
var contents = SqlConnectionCommon.Query<PageContent>("PageContentByCode", new { code = id }, commandType: CommandType.StoredProcedure).ToList();
SqlConnectionCommon.Close();
if (contents.Count != 0)
{
var newLanguages = languages.Where(p => contents.All(p2 => p2.Language != p.LCIDForLocale));
contents.AddRange(newLanguages.Select(newLanguage => new PageContent
{
Language = newLanguage.LCIDForLocale
}));
}
model.Items = contents;
model.Code = id;
model.Type = contents.First().Type;
return View(model);
}
public ActionResult Create()
{
var culture = System.Threading.Thread.CurrentThread.CurrentUICulture.Name.ToLowerInvariant();
var model = new PageContentCreateViewModel();
SqlConnectionCommon.Open();
var data = SqlConnectionCommon.Query<Language>("LanguageGetAll", new { culture = string.Empty }, commandType: CommandType.StoredProcedure);
SqlConnectionCommon.Close();
var languages = data.ToList();
model.Items = languages.Select(language => new PageContent { Language = language.LCIDForLocale }).ToList();
model.Code = GetNewCode();
return View(model);
}
public ActionResult ContentInsertUpdate(PageContentCreateViewModel model)
{
SqlConnectionCommon.Open();
var userId = User.Identity.Name;
// Insert - Update PageContent
foreach (var item in model.Items)
{
item.Code = model.Code;
item.Type = model.Type;
item.ContentPlainText = item.Content;
item.ModifiedUserId = userId;
SqlConnectionCommon.Query<int>("PageContentInsertUpdate", new
{
item.Id,
item.ProgrammeType,
item.Type,
item.Content,
item.ContentPlainText,
item.Tooltip,
item.Code,
item.Language,
item.ModifiedUserId
}, commandType: CommandType.StoredProcedure);
}
SqlConnectionCommon.Close();
//return Json(new {result = 1});
return Redirect("/text") ;
}