public ActionResult Ask(FormCollection q) { using (var db = new DBTuVanSinhVien()) { int id = (int)HttpContext.Session["IDUser"]; string field = q["dropdownlist"]; var f = (from u in db.FIELDs where u.NameOfField == field select u.IDField).FirstOrDefault(); QUESTIONNOTCHECK qn = new QUESTIONNOTCHECK(); qn.IDField = (int)(f); qn.IDUser = id; qn.Checked = false; var s = (from u in db.STUDENTs where u.IDUser == id select u.IDStu).FirstOrDefault(); qn.IDStu = (int)(s); qn.Question = q["askcontent"]; db.QUESTIONNOTCHECKs.Add(qn); db.SaveChanges(); } return(RedirectToAction("Ask", "Ask")); }
//[HttpPost, ActionName("Duyet")] // [ValidateAntiForgeryToken] public ActionResult Duyet(int id) { QUESTIONQUEUE qQ = new QUESTIONQUEUE(); DateTime dt = new DateTime(); dt = DateTime.Today; int IDUser = (int)HttpContext.Session["IDUser"]; qQ.DateOfModeration = dt; qQ.QuestionID = id; using (var db = new DBTuVanSinhVien()) { var x = (from u in db.MANAGERs where u.IDUser == IDUser select u.IDField).FirstOrDefault(); qQ.IDField = (int)x; var y = (from m in db.QUESTIONNOTCHECKs where m.QuestionID == id select new{ m.Question, m.IDUser }).FirstOrDefault(); qQ.Question = y.Question.ToString(); qQ.IDUser = y.IDUser; db.QUESTIONQUEUEs.Add(qQ); QUESTIONNOTCHECK rm = new QUESTIONNOTCHECK(); rm = (from n in db.QUESTIONNOTCHECKs where n.QuestionID == id select n).FirstOrDefault <QUESTIONNOTCHECK>(); rm.Checked = true; db.SaveChanges(); } List <QUESTIONNOTCHECK> lst = new List <QUESTIONNOTCHECK>(); lst = getListQuestionNotCheck(); return(View("Manager", lst)); }