// GET: SuperAdmin/SchoolArticleApproval public ActionResult schoolapprovalarticle() { if (Session["Ad"] == null) { return(RedirectToAction("login", "Home", new { area = "" })); } Digital_SchoolEntities2 entities = new Digital_SchoolEntities2(); List <Article> article = entities.Articles.Where(x => x.SchoolId != null).ToList(); List <Status> status = entities.Status.ToList(); List <School> school = entities.Schools.ToList(); List <ArticleType> articletype = entities.ArticleTypes.ToList(); var query = from c in article join s in status on c.statusId equals s.statusId into table1 join t in articletype on c.Article_TypeId equals t.Article_TypeId into table2 join sc in school on c.SchoolId equals sc.School_Id into table3 from s in table1.DefaultIfEmpty() from t in table2.DefaultIfEmpty() from sc in table3.DefaultIfEmpty() select new ViewStatus { schoolarticle = c, statustype = s, Article_Typename = t, School_Name = sc }; return(View(query)); }
public ActionResult ApproveArticleClient(int id) { //var Statustype = new SelectList(db.Status.ToList(), "statusId", "statustype"); //ViewData["StatusType"] = Statustype; using (Digital_SchoolEntities2 entities = new Digital_SchoolEntities2()) { //Response.Write(submit); return(View(entities.Articles.Single(x => x.ArticleId == id))); } }
public ActionResult updateLacture(int id) { using (Digital_SchoolEntities2 entities = new Digital_SchoolEntities2()) { //Response.Write(submit); var test = db.Lectures.Find(id); Session["url"] = test.LectureUrl; return(View(entities.Lectures.Single(x => x.LectureId == id))); } }
public ActionResult updateManualTest(int id) { using (Digital_SchoolEntities2 entities = new Digital_SchoolEntities2()) { //Response.Write(submit); var test = db.ManualTests.Find(id); Session["url"] = test.TestUrl; return(View(entities.ManualTests.Single(x => x.TestId == id))); } }
public ActionResult ApproveArticleClient(int id, string submit) { switch (submit) { case "Approve": using (Digital_SchoolEntities2 entities = new Digital_SchoolEntities2()) { var item = entities.Articles.Single(x => x.ArticleId == id); item.statusId = 2; entities.Articles.Attach(item); entities.Entry(item).Property(X => X.statusId).IsModified = true; entities.SaveChanges(); return(RedirectToAction("Clientapprovalarticle")); break; } case "Reject": using (Digital_SchoolEntities2 entities = new Digital_SchoolEntities2()) { var item = entities.Articles.Single(x => x.ArticleId == id); item.statusId = 3; entities.Articles.Attach(item); entities.Entry(item).Property(X => X.statusId).IsModified = true; entities.SaveChanges(); return(RedirectToAction("Clientapprovalarticle")); break; } default: throw new Exception(); break; } return(View()); }
public ActionResult viewassignment(int?courseid) { if (Session["Teacher"] == null) { return(RedirectToAction("Login", "Account", new { area = "" })); } Digital_SchoolEntities2 entities = new Digital_SchoolEntities2(); List <SubmitAssignment> sa = entities.SubmitAssignments.ToList(); List <School> s = entities.Schools.ToList(); List <SchoolAssignment> sca = entities.SchoolAssignments.ToList(); List <Course> c = entities.Courses.ToList(); var query = from sas in sa join ss in s on sas.SchoolId equals ss.School_Id into table1 from ss in table1.DefaultIfEmpty() join sss in sca on sas.AssignmentId equals sss.AssignmentId into table2 from sss in table2.DefaultIfEmpty() join ssss in c on sas.CourseId equals ssss.courseId into table3 from ssss in table3.DefaultIfEmpty() select new AssignmentDetail { sub = sas, s = ss, sc = sss, c = ssss }; return(View(query)); }