public bool SignIn(string login, string password) { Users user; using (var context = new QuizDBEntities()) { user = context.Users .FirstOrDefault(c => c.user_login == login && c.user_pass == password); } if (user != null) { return true; } return false; }
public Test GetTest() { var test = new Test(); using (var context = new QuizDBEntities()) { var tests = context.Tests.ToArray(); var questions = context.Questions.ToArray(); var variants = context.Variants.ToArray(); test = tests .Select(t => new Test { Name = t.name, Questions = questions .Where(q => q.testId == t.id) .Select(q => new Question { Id = q.id, QuestionText = q.question, Variants = variants .Where(v => v.questionId == q.id) .Select(v => new Variant { Id = v.id, VariantText = v.variant, ImageUri = v.imgPath, Type = v.variant_type }) .ToList() }) .ToList() }) .ToList()[1]; } return test; }