public IActionResult SubCategoriesView(int id)
{
var query = from item in db.Categories where item.ParentId == null select item;
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("idCat", id);
}
if (id == 0)
{
id = (int)HttpContext.Session.GetInt32("idCat");
HttpContext.Session.SetInt32("idCat", id);
}
CategoriesDTOsRepository categoryDTOs = new CategoriesDTOsRepository();
List <CategoriesDTO> DTO = categoryDTOs.GetCategoriesDTOs(ntv_lgid[0], lgid[0]);
return(View(DTO.Where(x => x.ParentId == id)));
}
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 CategoriesView()
{
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();
CategoriesDTOsRepository categoryDTOs = new CategoriesDTOsRepository();
List <CategoriesDTO> DTO = categoryDTOs.GetCategoriesDTOs(ntv_lgid[0], lgid[0]);
return(View(DTO.Where(x => x.ParentId == null)));
}
public JsonResult TestStatictics()
{
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();
CategoriesDTOsRepository categoryDTOs = new CategoriesDTOsRepository();
List <CategoriesDTO> CatDTO = categoryDTOs.GetCategoriesDTOs(ntv_lgid[0], lgid[0]).ToList();
TestsDTOsRepository TestDTOs = new TestsDTOsRepository();
List <CategoriesDTO> TestDTO = TestDTOs.GetTestDTOs(ntv_lgid[0], lgid[0]).ToList();
LanguagesDTOsRepository LangDTOs = new LanguagesDTOsRepository();
List <CategoriesDTO> LangDTO = LangDTOs.GetLanguagesDTOs(ntv_lgid[0], lgid[0]).ToList();
TestResultsRepository testResultRepository = new TestResultsRepository();
List <TestResults> testResult = testResultRepository.GetList().ToList();
TotalScoresRepository totalRepository = new TotalScoresRepository();
List <TotalScores> totalScore = totalRepository.GetList().ToList();
StatisticObject statisticObject = new StatisticObject();
statisticObject.CategoriesDTO = CatDTO;
statisticObject.LanguageDTO = LangDTO;
statisticObject.TestsDTO = TestDTO;
statisticObject.TestResults = testResult;
statisticObject.TotalScore = totalScore;
return(Json(statisticObject));
}
