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