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