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