public IActionResult Testing(int id) { string language = HttpContext.Session.GetString("lang"); var lang_id = from s in db.Languages where s.Name.ToString() == language select s.Id; int[] lgid = lang_id.ToArray(); string native_lang = HttpContext.Session.GetString("native_lang"); var native_lang_id = from s in db.Languages where s.Name.ToString() == native_lang select s.Id; int[] ntv_lgid = native_lang_id.ToArray(); int subCats = (int)HttpContext.Session.GetInt32("idWord"); WordsDTOsRepository WordsDTOs = new WordsDTOsRepository(); List <CategoriesDTO> WordDTO = WordsDTOs.GetWordsDTOs(ntv_lgid[0], lgid[0]); var TestIcon = from p in db.Tests where p.Id == id select p.Icon; string[] Ticon = TestIcon.ToArray(); foreach (var item in WordDTO) { item.TestName = $"{Ticon[0]}"; } return(View(WordDTO.Where(x => x.CategoryId == subCats))); }
public IActionResult WordsView(int id) { string language = HttpContext.Session.GetString("lang"); var lang_id = from s in db.Languages where s.Name.ToString() == language select s.Id; int[] lgid = lang_id.ToArray(); string native_lang = HttpContext.Session.GetString("native_lang"); var native_lang_id = from s in db.Languages where s.Name.ToString() == native_lang select s.Id; int[] ntv_lgid = native_lang_id.ToArray(); if (id != 0) { HttpContext.Session.SetInt32("idWord", id); } if (id == 0) { id = (int)HttpContext.Session.GetInt32("idWord"); HttpContext.Session.SetInt32("idWord", id); } CategoriesDTOsRepository catreps = new CategoriesDTOsRepository(); List <CategoriesDTO> catrep = catreps.GetCategoriesDTOs(ntv_lgid[0], lgid[0]); var catNameNative = from n in catrep where n.CategoryId == id select n.Native; string[] nativ = catNameNative.ToArray(); var catNameLearn = from n in catrep where n.CategoryId == id select n.Translation; string[] lern = catNameLearn.ToArray(); WordsDTOsRepository WordsDTOs = new WordsDTOsRepository(); List <CategoriesDTO> DTO = WordsDTOs.GetWordsDTOs(ntv_lgid[0], lgid[0]); foreach (var item in DTO) { item.TestName = $"{lern[0]}({nativ[0]})"; } return(View(DTO.Where(x => x.CategoryId == id))); }
public IActionResult Manual(int id) { string language = HttpContext.Session.GetString("lang"); var lang_id = from s in db.Languages where s.Name.ToString() == language select s.Id; int[] lgid = lang_id.ToArray(); string native_lang = HttpContext.Session.GetString("native_lang"); var native_lang_id = from s in db.Languages where s.Name.ToString() == native_lang select s.Id; int[] ntv_lgid = native_lang_id.ToArray(); WordsDTOsRepository WordsDTOs = new WordsDTOsRepository(); List <CategoriesDTO> DTO = WordsDTOs.GetWordsDTOs(ntv_lgid[0], lgid[0]); return(View(DTO.Where(x => x.CategoryId == id))); }