// GET: Categories
public async Task<ActionResult> Index()
{
var culture = System.Threading.Thread.CurrentThread.CurrentUICulture.Name.ToLowerInvariant();
var model = new PageContentViewModel();
SqlConnectionCommon.Open();
var data = SqlConnectionCommon.Query<Language>("LanguageGetAll", new { culture }, commandType: CommandType.StoredProcedure);
SqlConnectionCommon.Close();
var languages = data.ToList();
model.PageContents = languages.Select(language => new PageContent { Language = language.LCIDForLocale }).ToList();
return View(model);
}
public ActionResult LoadDataContent(int page, int size, int code, string type, string content)
{
var model = new PageContentViewModel();
var paramss = new DynamicParameters();
paramss.Add("page", page);
paramss.Add("size", size);
paramss.Add("code", code);
paramss.Add("type", type);
paramss.Add("content", content);
paramss.Add("out", dbType: DbType.Int32, direction: ParameterDirection.Output);
SqlConnectionCommon.Open();
var data = SqlConnectionCommon.Query<PageContent>("PageContentFilter", paramss, commandType: CommandType.StoredProcedure);
SqlConnectionCommon.Close();
model.PageContents = data.ToList();
var total = paramss.Get<int>("out");
model.TotalRecords = total;
var totalTemp = Convert.ToDecimal(model.TotalRecords) / Convert.ToDecimal(size);
var totalPages = Convert.ToInt32(Math.Ceiling(totalTemp));
model.TotalPages = totalPages;
model.CurrentPage = page;
model.PageSize = size;
return PartialView("Partial/_PageContentPartial", model);
}