public static List <TreeListModelItem> getTree() { iys.ModelProject.iysContext cdb = new ModelProject.iysContext(); List <TreeListModel> lesson = (from d in cdb.LESSONS select new TreeListModel { ID = d.LESSON_CODE, ParentID = 0, Name = d.LESSON_NAME }).ToList(); List <TreeListModel> document = (from d in cdb.DOCUMENTS select new TreeListModel { ID = d.DOCUMENT_CODE, ParentID = d.LESSON_CODE, Name = d.DOCUMENT_NAME }).ToList(); List <TreeListModelItem> treeListItem = new List <TreeListModelItem>(); treeListItem = convettoItem(treeListItem, lesson, "l", ""); treeListItem = convettoItem(treeListItem, document, "", "l"); return(treeListItem); }
public ActionResult calenderPartial() { iys.ModelProject.iysContext db = new ModelProject.iysContext(); var model = from d in db.USER_QUIZ_STATUSS where d.USER_CODE == User.Identity.Name select new { name = d.DATE, puan = d.GRADE }; return(PartialView("_calenderPartial", model.ToList())); }
public ActionResult successPartial() { iys.ModelProject.iysContext db = new ModelProject.iysContext(); var model = (from d in db.DOCUMENTS from b in db.USER_QUIZ_STATUSS.Where(x => x.DOCUMENT_CODE == d.DOCUMENT_CODE).Where(dd => dd.USER_CODE == User.Identity.Name).DefaultIfEmpty() orderby b.DATE descending select new succesVievModel { name = d.DOCUMENT_NAME.Substring(0, 10), puan = b.GRADE }).Take(20).ToList(); return(PartialView("_successPartial", model)); }
public ActionResult ChartPartial() { iys.ModelProject.iysContext db = new ModelProject.iysContext(); var model = db.USER_ANSWERS; List <succesVievModel> scList = new List <succesVievModel>(); succesVievModel scK = new succesVievModel(); scK.name = "Kalan"; scK.puan = db.DOCUMENTS.Count(); succesVievModel scS = new succesVievModel(); scS.name = "Biten"; scS.puan = db.USER_QUIZ_STATUSS.Where(x => x.USER_CODE == User.Identity.Name).Where(x => x.GRADE >= 50).Count(); scK.puan = scK.puan - scS.puan; scList.Add(scK); scList.Add(scS); return(PartialView("_ChartPartial", scList)); }
public ActionResult userInfoPartial() { iys.ModelProject.iysContext db = new ModelProject.iysContext(); int model = 0; try { model = (int)db.USER_QUIZ_STATUSS.Where(x => x.USER_CODE == User.Identity.Name).Average(x => x.GRADE).Value; } catch (Exception) { } ////(from d in db.USER_QUIZ_STATUSS // where d.USER_CODE==User.Identity.Name // select new succesVievModel { name = d.USER_CODE, puan = d.GRADE }); succesVievModel sv = new succesVievModel(); sv.name = User.Identity.Name; sv.puan = model; return(PartialView("_userInfoPartial", sv)); }