public List<StatModel> GetTestStats(Guid id) { using (var DB = new MainContext()) { return DB.Stats.Where(x => x.TestModel.Id == id).ToList(); } }
public ProfessorModel GetProfessorById(Guid guid) { using (var DB = new MainContext()) { return DB.Professors.Where(x => x.Id == guid).FirstOrDefault(); } }
public SpaceModel GetSpaceById(Guid guid) { using (var DB = new MainContext()) { return DB.Spaces.Where(x => x.Id == guid).FirstOrDefault(); } }
public List<QuestionModel> GetTestQuestions(Guid testGuid) { using (var DB = new MainContext()) { return DB.Tests.Where(x => x.Id == testGuid).FirstOrDefault().Questions.ToList(); } }
public InfoModel GetInfoCreatedForTest(Guid testId) { using (var DB = new MainContext()) { return DB.Infos.Where(x => x.Tests.FirstOrDefault().Id == testId).FirstOrDefault(); } }
public InfoModel GetInfoById(Guid guid) { using (var DB = new MainContext()) { return DB.Infos.Where(x => x.Id == guid).FirstOrDefault(); } }
public AnswerModel GetAnswer(Guid guid) { using (var DB = new MainContext()) { return DB.Answers.Where(x => x.Id == guid).FirstOrDefault(); } }
public List<InfoModel> GetInfos() { using (var DB = new MainContext()) { return DB.Infos.ToList(); } }
public List<SubjectModel> GetSubjects() { using (var DB = new MainContext()) { return DB.Subjects.ToList(); } }
public SubjectModel GetSubjectById(Guid guid) { using (var DB = new MainContext()) { return DB.Subjects.Where(x => x.Id == guid).FirstOrDefault(); } }
public List<ProfessorModel> GetProfessors() { using (var DB = new MainContext()) { return DB.Professors.ToList(); } }
public List<SpaceModel> GetSpaces() { using (var DB = new MainContext()) { return DB.Spaces.ToList(); } }
public void Delete(Guid id) { using (var DB = new MainContext()) { DB.Entry(GetProfessorById(id)).State = System.Data.Entity.EntityState.Deleted; DB.SaveChanges(); } }
public bool Add(SpaceModel data) { using (var DB = new MainContext()) { DB.Spaces.Add(data); DB.SaveChanges(); return true; } return false; }
public bool Add(ProfessorModel data) { using (var DB = new MainContext()) { DB.Professors.Add(data); DB.SaveChanges(); return true; } return false; }
public bool Add(SubjectModel model) { using (var DB = new MainContext()) { DB.Subjects.Add(model); DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged; DB.SaveChanges(); return true; } return false; }
public bool Edit(ProfessorModel data) { using (var DB = new MainContext()) { DB.Professors.Attach(data); DB.Entry(data).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return true; } return false; }
private static bool CheckQuestion(QuestionModel question) { using (var DB = new MainContext()) { foreach(var ans in question.Answers) { if (DB.Answers.Where(x => x.Id == ans.Id).FirstOrDefault().isRight != ans.isRight) return false; } } return true; }
public bool ChangeRating(Guid TestId, int Rating) { using (var DB = new MainContext()) { var test = DB.Tests.Where(x => x.Id == TestId).FirstOrDefault(); test.Rating += Rating; DB.Entry(test).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return true; } return false; }
public List<SubjectModel> GetSpaceSubjects(Guid id) { using (var DB = new MainContext()) { return DB.Spaces.Where(x => x.Id == id).FirstOrDefault().Subjects.Select(x => new SubjectModel() { Id = x.Id, Name = x.Name, Shortcut = x.Shortcut }).ToList(); } }
public bool Add(StatModel model) { using (var DB = new MainContext()) { model.TestModel.Questions = null; DB.Stats.Add(model); DB.Entry(model.TestModel).State = System.Data.Entity.EntityState.Unchanged; DB.SaveChanges(); return true; } return false; }
/// <summary> /// todo: implement algorythm /// </summary> /// <returns></returns> public List<TestInfoModel> GetRecommendedTests() { using (var DB = new MainContext()) { return DB.Tests.OrderBy(r => Guid.NewGuid()).Take(3) .Select(t => new TestInfoModel() { Shortcut = t.Shortcut, Space = t.Space.Name, Description = t.Description, Rating = t.Rating, Creator = t.Creator.UserName }).ToList(); } }
public List<SpaceInfoModel> GetSpacesForAutocomplete(string space, string test) { using (var DB = new MainContext()) { var list = DB.Spaces.AsEnumerable().Select(x => new SpaceInfoModel() { Id = x.Id, Name = x.Name, Space = x.Shortcut, Shortcut = x.Shortcut, }).ToList(); var spaces = list.Where(x => AutocompleteAlgorithms.Matches(x, space, test)).ToList(); return spaces; } }
public bool Add(TestModel model) { model.Creator = new UserProfile() { UserId = WebMatrix.WebData.WebSecurity.CurrentUserId, UserName = WebMatrix.WebData.WebSecurity.CurrentUserName }; using (var DB = new MainContext()) { var context = new ValidationContext(model.Infos.First(), serviceProvider: null, items: null); var validationResults = new List<ValidationResult>(); bool isValid = Validator.TryValidateObject(model.Infos.First(), context, validationResults, true); if (isValid) { DB.Infos.Add(model.Infos.First()); DB.SaveChanges(); } else model.Infos.Remove(model.Infos.First()); DB.Tests.Add(model); DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged; DB.Entry(model.Subject).State = System.Data.Entity.EntityState.Unchanged; DB.Entry(model.Creator).State = System.Data.Entity.EntityState.Unchanged; if (model.Infos != null) { foreach (var infoModel in model.Infos) { DB.Entry(infoModel).State = System.Data.Entity.EntityState.Unchanged; } } DB.SaveChanges(); return true; } return false; }
public TestModel GetTestByShortcut(string @short) { using (var DB = new MainContext()) { return DB.Tests.Where(x => string.Compare(x.Shortcut, @short, true) == 0).FirstOrDefault(); } }
public List<TestInfoModel> GetTestsForAutocomplete(string space, string test) { using (var DB = new MainContext()) { var list = DB.Tests.AsEnumerable().Select(x => new TestInfoModel() { Id = x.Id, Name = x.Name, Space = (x.Space != null) ? (x.Space.Shortcut) : (""), Rating = x.Rating, Shortcut = x.Shortcut, Creator = x.Creator.UserName }).ToList(); var tests = list.Where(x => AutocompleteAlgorithms.Matches(x, space, test)).ToList(); return tests; } }
public TestModel GetTest(Guid guid) { using (var DB = new MainContext()) { return DB.Tests.Where(x => x.Id == guid).FirstOrDefault(); } }
public ViewResult Pass(Guid Id) { var DB = new MainContext(); return View(DB.Tests.Where(x => x.Id == Id).FirstOrDefault()); }
// // GET: /Space/ public ViewResult Index(Guid Id) { var DB = new MainContext(); return View(DB.Spaces.Where(x => x.Id == Id).FirstOrDefault()); }