public TestController(Helper helper) { this._helper = helper; this._db = new ProductHouseContext(); Tuple <int, int> ids = Helper.GetLanguagesId(); NativeLanguageId = ids.Item1; LearningLanguageId = ids.Item2; }
public void SaveTestResult([FromBody] TestResults testResult) { if (testResult != null) { testResult.TestDate = DateTime.Now; using (ProductHouseContext db = new ProductHouseContext()) { db.TestResults.Add(testResult); db.SaveChanges(); } } }
public TestResults GetById(int id) { using (ProductHouseContext db = new ProductHouseContext()) { try { return(db.TestResults.First(c => c.Id == id)); } catch (Exception e) { throw e; } } }
public Users GetById(int id) { using (ProductHouseContext db = new ProductHouseContext()) { try { return(db.Users.FirstOrDefault()); } catch (Exception e) { throw e; } } }
public LanguageTranslations GetById(int id) { using (ProductHouseContext db = new ProductHouseContext()) { try { return(db.LanguageTranslations.FirstOrDefault(c => c.Id == id)); } catch (Exception e) { throw e; } } }
public TotalScores GetById(int id) { using (ProductHouseContext db = new ProductHouseContext()) { try { return(db.TotalScores.Where(c => c.Id == id).FirstOrDefault()); } catch (Exception e) { throw e; } } }
public CategoriesTranslations GetById(int id) { using (ProductHouseContext db = new ProductHouseContext()) { try { return(db.CategoriesTranslations.First(c => c.Id == id)); } catch (Exception e) { throw e; } } }
private List <CategoryStatistic> FillCategory() { List <CategoryStatistic> categoryStatistic = new List <CategoryStatistic>(); ProductHouseContext db = new ProductHouseContext(); var CategoryTranslations = (from categoryTrans in db.CategoriesTranslations join category in db.Categories on categoryTrans.CategoryId equals category.Id where categoryTrans.LangId == _userLanguageId select new { CategoryTrans = categoryTrans.Translation, CategoryId = category.Id, ParentId = category.ParentId }).ToList(); var testsTrans = (from testTrans in db.TestTranslations where testTrans.LangId == _userLanguageId join test in db.Tests on testTrans.TestId equals test.Id select new { TestTrans = testTrans.Translation, TestId = test.Id }).ToList(); var parentCategories = CategoryTranslations.Where(c => c.ParentId == null).ToArray(); for (int i = 0; i < parentCategories.Count(); i++) { var parentCategory = parentCategories[i]; categoryStatistic.Add(new CategoryStatistic { CategoryName = parentCategory.CategoryTrans }); List <SubcategoryStatistic> subcategoryStatistics = new List <SubcategoryStatistic>(); foreach (var subcategory in CategoryTranslations.Where(s => s.ParentId == parentCategory.CategoryId)) { subcategoryStatistics.Add(new SubcategoryStatistic { SubcategoryName = subcategory.CategoryTrans, TestNames = testsTrans.Select(t => t.TestTrans).ToList(), CategoryId = subcategory.CategoryId }); } categoryStatistic[i].SubcategoryStatistics = subcategoryStatistics; } return(categoryStatistic); }
public IActionResult Register([FromBody] Users user) { if (user == null) { return(InvalidClientRequest()); } LoginModel loginModel = new LoginModel { Login = user.Email, Password = user.PasswordHash }; string userId = Guid.NewGuid().ToString("N"); string hashedPassword = _helper.ComputeSha256Hash(user.PasswordHash); UserSettings userSettings = new UserSettings { LearningLanguageId = 0, NativeLanguageId = 0, UserId = userId }; user.Id = userId; user.UserSettings = new List <UserSettings> { userSettings }; user.PasswordHash = hashedPassword; using (ProductHouseContext db = new ProductHouseContext()) { db.Users.Add(user); db.SaveChanges(); } return(Login(loginModel)); }
public TestsResultsRepository() { db = new ProductHouseContext(ConfigurateOptions.GetOptions()); }
public LanguagesTranslationsRepository() { db = new ProductHouseContext(ConfigurateOptions.GetOptions()); }
public TotalScoresRepository() { db = new ProductHouseContext(ConfigurateOptions.GetOptions()); }
public Helper(IHttpContextAccessor httpContextAccessor) { _db = new ProductHouseContext(); _httpContextAccessor = httpContextAccessor; }
public CategoriesRepository() { db = new ProductHouseContext(ConfigurateOptions.GetOptions()); }