public ActionResult DangNhap(USER u)
{
int id = 1;
USER x = new USER();
using (var db = new DBTuVanSinhVien())
{
id = (from i in db.USERS
where i.Email == u.Email
select i.IDUser).FirstOrDefault();
HttpContext.Session.Add("IDUser", id);
var permiss = (from k in db.USERS
where k.IDUser == id
select k.Permission).FirstOrDefault();
switch ((int)permiss)
{
case 1: return(RedirectToAction("Ask", "Ask"));
case 2: return(RedirectToAction("Manager", "Manager"));
case 3: return(RedirectToAction("Answer", "Answer"));
}
}
return(RedirectToAction("Ask", "Ask"));
}
public ActionResult DangKy(USER u, string sex)
{
using (var db = new DBTuVanSinhVien()){
var x = from i in db.USERS
where i.Email == u.Email
select i.IDUser;
if (x.Count() == 0)
{
if (sex == "Nam")
{
u.Sex = true;
}
else
{
u.Sex = false;
}
u.Permission = 1;
db.USERS.Add(u);
STUDENT st = new STUDENT();
st.IDUser = u.IDUser;
db.STUDENTs.Add(st);
db.SaveChanges();
ViewBag.message = "Đăng ký thành công";
}
else
{
ViewBag.message = "Email đã được sử dụng";
return(View("DangKy", u));
}
}
return(View());
}
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"));
}
public ActionResult Ask()
{
List <QUESTIONANDANSWER> lstQ = new List <QUESTIONANDANSWER>();
int iduser = (int)HttpContext.Session["IDUser"];
using (var db = new DBTuVanSinhVien())
{
var ls = from u in db.FIELDs
select u.NameOfField;
ViewBag.listfield = ls.ToList();
var x = (from m in db.QUESTIONNOTCHECKs
where m.IDUser == iduser
select m.QuestionID).ToList();
foreach (var i in x)
{
var y = (from n in db.QUESTIONANDANSWERs
where n.QuestionID == i
select n).FirstOrDefault <QUESTIONANDANSWER>();
if (y != null)
{
lstQ.Add(y);
}
}
}
return(View(lstQ));
}
public ActionResult Reply(int id, string answer = "")
{
QUESTIONANDANSWER qa = new QUESTIONANDANSWER();
using (var db = new DBTuVanSinhVien())
{
var x = (from u in db.QUESTIONQUEUEs
where u.QuestionID == id
select new { u.Question, u.IDField }).FirstOrDefault();
if (x != null)
{
qa.QuestionID = id;
qa.Question = x.Question;
qa.IDField = x.IDField;
qa.Answer = answer;
qa.DateOfAnswer = DateTime.Now;
db.QUESTIONANDANSWERs.Add(qa);
var y = (from m in db.QUESTIONQUEUEs
where m.QuestionID == id
select m).FirstOrDefault <QUESTIONQUEUE>();
db.QUESTIONQUEUEs.Remove(y);
db.SaveChanges();
}
}
List <QUESTIONQUEUE> qQ = new List <QUESTIONQUEUE>();
qQ = getListQuestionQueue();
return(View("Answer", qQ));
}
public ActionResult Xoa(int id)
{
using (var db = new DBTuVanSinhVien())
{
var ask = (from u in db.QUESTIONNOTCHECKs
where u.QuestionID == id
select u).FirstOrDefault <QUESTIONNOTCHECK>();
db.QUESTIONNOTCHECKs.Remove(ask);
db.SaveChanges();
}
List <QUESTIONNOTCHECK> lst = new List <QUESTIONNOTCHECK>();
lst = getListQuestionNotCheck();
return(View("Manager", lst));
}
public List <QUESTIONNOTCHECK> getListQuestionNotCheck()
{
int id = (int)HttpContext.Session["IDUser"];
using (var db = new DBTuVanSinhVien())
{
var f = (from u in db.MANAGERs
where u.IDUser == id
select u.IDField).FirstOrDefault();
int idField = (int)f;
var questionQueue = (from x in db.QUESTIONNOTCHECKs
where x.IDField == idField && x.Checked == false
select x);
var listQuestion = new List <QUESTIONNOTCHECK>();
listQuestion = questionQueue.ToList <QUESTIONNOTCHECK>();
return(listQuestion);
}
}
public List <QUESTIONQUEUE> getListQuestionQueue()
{
int id = (int)HttpContext.Session["IDUser"];
List <QUESTIONQUEUE> lst = new List <QUESTIONQUEUE>();
using (var db = new DBTuVanSinhVien())
{
var x = (from u in db.TEACHERs
where u.IDUser == id
select u.IDField).FirstOrDefault();
int f = (int)x; // f là idField
var list = (from m in db.QUESTIONQUEUEs
where m.IDField == f
select m);
lst = list.ToList <QUESTIONQUEUE>();
return(lst);
}
}
//[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));
}
