public object GetQuiz() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); var q = dbcontext.Quizs.Select(a => new { Id = a.QuizID, name = a.QuizName }).ToList(); return(q); }
public List <UnitMaster> GetUnit() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); dbcontext.Configuration.LazyLoadingEnabled = false; return(dbcontext.UnitMasters.ToList()); }
public List <Quiz> Gets(int subject, int unit) { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); dbcontext.Configuration.LazyLoadingEnabled = false; return(dbcontext.Quizs.Where(x => x.SubjectID == subject && x.UnitID == unit).ToList()); }
public List <Semester> GetSemester() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); var usercourse = (from a in dbcontext.StudentProfiles where a.EmailID == User.Identity.Name select a.Course).FirstOrDefault(); dbcontext.Configuration.LazyLoadingEnabled = false; return(dbcontext.Semesters.Where(a => a.CourseID == usercourse).ToList()); }
public List <Subject_Master> GetSubject() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); dbcontext.Configuration.LazyLoadingEnabled = false; var usercourse = (from a in dbcontext.StudentProfiles where a.EmailID == User.Identity.Name select a.Course).FirstOrDefault(); var sub = dbcontext.Subject_Master.Where(a => a.Course == usercourse).Select(a => a).ToList(); //return dbcontext.Subject_Master.ToList(); return(sub); }
public JsonResult GetUnitPerform(int?UnitID, int SubjectID) { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); var Student = new GetUserByUserName(User.Identity.Name); var Courseid = Student.CourseID; var Semid = Student.SemID; var Student_ID = Student.Student_ID; var Uid = Student.UnitID; //var subjectid = Student.SubjectID; var Unitid = Student.UnitID; var unitscore = new GetCalculatePerform(Student_ID, Courseid, Semid).temp; return(Json(new { scoreCard = unitscore }, JsonRequestBehavior.AllowGet)); }
//Subject Performance public JsonResult SubjectPerformance() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); var Student = new GetUserByUserName(User.Identity.Name); var CourseID = Student.CourseID; var SemID = Student.SemID; var Student_ID = Student.Student_ID; // var Uid = Student.UnitID; var subjectid = Student.SubjectID; var score = new GetCalculatePerform(Student_ID, CourseID, SemID).tempobj; GetMarks obj = new GetMarks(); int?userid = new GetUserByUserName(User.Identity.Name).Student_ID; var test = obj.GetMarksSubjectWise(userid); return(Json(new { scoreCard = score, marks = test }, JsonRequestBehavior.AllowGet)); }
//Recent Written test score public JsonResult Test() { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); var Student = new GetUserByUserName(User.Identity.Name); var details = (from i in dbcontext.Stu_Result join j in dbcontext.UnitMasters on i.UnitID equals j.Uid where (i.UserID == Student.Student_ID && i.CourseID == Student.CourseID && i.SemID == Student.SemID) orderby i.CreatedDate descending select new { i.ScoredMarks, i.UnitID, j.UnitName }).FirstOrDefault(); return(Json(new { UserDetails = details }, JsonRequestBehavior.AllowGet)); }
// GET: api/Quiz public QuizModel Get(int Id) { ireadytodayEntities2 dbcontext = new ireadytodayEntities2(); List <Config> tempcon = new List <Config> { new Config() { ShuffleQuestions = true, Automove = true, Allowback = false, ShowPager = false } }; List <QuestionType> tempqtype = new List <QuestionType> { new QuestionType() { Id = 1, IsActive = true, Name = "MCQ" } }; //System.Data.Entity.DbSet<Question> s = dbcontext.Questions; //IQueryable<Question> questions = dbcontext.Questions.Where(q => q.QuizID == 1) // .Select(a => new Question // { // QuizID = a.QuizID, // QuestionID = a.QuestionID, // QuestionText = a.QuestionText, // Answers = a.Answers.Where(q => q.QuestionID == a.QuestionID).Select(c => new Answer // { // AnswerID = c.AnswerID, // AnswerText = c.AnswerText, // IsAnwer = c.IsAnwer, // QuestionID = a.QuestionID, // }).ToList() // }).AsQueryable(); var q1 = dbcontext.Quizs.Where(a => a.QuizID == Id).FirstOrDefault(); var qq = q1.Questions.Select(a => new { Id = a.QuestionID, Name = a.QuestionText, QuestionTypeId = 1, Options = a.Answers.Select(b => new { Id = b.AnswerID, QuestionId = a.QuestionID, Name = b.AnswerText, IsAnswer = b.IsAnwer ?? false }) }).Take(10).ToList(); dbcontext.Configuration.LazyLoadingEnabled = false; QuizModel qz = new QuizModel() { quiz = q1, Config = tempcon, questions = qq.OrderBy(x => Guid.NewGuid()).Take(10).ToList() }; //var js = JsonConvert.SerializeObject(qz); return(qz); // return quiz.GetQuizs(); }