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();
}
