public JsonResult GetScore()
{
GetMarks obj = new GetMarks();
int?userid = new GetUserByUserName(User.Identity.Name).Student_ID;
var test = obj.GetMarksSubjectWise(userid);
return(Json(new { marksdata = test }, JsonRequestBehavior.AllowGet));
}
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));
}
public ActionResult Index()
{
//JobsNotification Begin
var JobsNotification = dbcontext.Job_Master.Where(i => i.JobID != 0).ToList();
ViewBag.JobsN = JobsNotification;
//JobsNotification End
//StudyMaterials Begin
var StudyMaterialsNotification = dbcontext.StudyMaterials.Where(i => i.SM_Name != null).Take(3).ToList();
ViewBag.studymN = StudyMaterialsNotification;
//StudyMaterials End
var StudentName = (from a in dbcontext.StudentProfiles.Where(x => x.EmailID == User.Identity.Name) select a.Name).FirstOrDefault();
ViewBag.name = StudentName;
//Additional Question Request Begin
var AddQueReq = (from Qreq in dbcontext.Stu_Additionalquestionrequest
join user in dbcontext.StudentProfiles on Qreq.ProfileId equals user.Student_ID
join course in dbcontext.Course_master on Qreq.Course equals course.Course_ID
//where user.EmailID == User.Identity.Name
select new QuestionRequestModel
{
StudentName = user.Name,
Course = course.Name,
Update = (bool)Qreq.Updated == true ? "Updated" : "Pending",
}).Take(2).ToList();
ViewBag.QueReq = AddQueReq;
//Additional Question Request End
var Student = new GetUserByUserName(User.Identity.Name);
var CourseID = Student.CourseID;
var SemID = Student.SemID;
var Student_ID = Student.Student_ID;
var UnitID = Student.UnitID;
var SubjectID = Student.SubjectID;
List <Subject_Master> s = dbcontext.Subject_Master.Where(x => x.Course == CourseID && x.Semester == SemID).ToList();
Subject_Master sub = new Subject_Master
{
Name = "----please select Course----",
SubjectID = 0
};
s.Insert(0, sub);
SelectList selectsubject = new SelectList(s, "SubjectID", "Name", 0);
ViewBag.selectedsubject = selectsubject;
List <UnitMaster> u = dbcontext.UnitMasters.ToList();
UnitMaster unit = new UnitMaster
{
UnitName = "----Please select unit----",
Uid = 0
};
u.Insert(0, unit);
SelectList selectunit = new SelectList(u, "Uid", "UnitName", 0);
ViewBag.selectedunit = selectunit;
return(View());
}
