public ActionResult Counselling()
{
if ((HttpContext.Session.GetString("Role") == null) ||
(HttpContext.Session.GetString("Role") != "User"))
{
return(RedirectToAction("Index", "Home"));
}
CounselReq counselS = new CounselReq();
counselS.Queue = userDAL.getSessions();
return(View(counselS));
}
public void reqHelp(int userid, CounselReq c)
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"INSERT INTO PendingCounsellingSession(Feeling,Thought,Problems,DateCreated,UserID)
VALUES(@feelings,@thought,@problems,@datetime,@userID)";
cmd.Parameters.AddWithValue("@feelings", c.Feelings);
cmd.Parameters.AddWithValue("@thought", c.Thought);
cmd.Parameters.AddWithValue("@problems", c.Problems);
cmd.Parameters.AddWithValue("@datetime", DateTime.UtcNow);
cmd.Parameters.AddWithValue("@userID", userid);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public ActionResult Counselling(CounselReq counsel)
{
int id = (int)HttpContext.Session.GetInt32("UserID");
bool inQueue = userDAL.checkReq(id);
if (inQueue == false)
{
userDAL.reqHelp(id, counsel);
TempData["CounselMsg"] = "Thank you for reaching out";
}
else
{
TempData["CounselMsg"] = "You are already in queue, please wait";
}
ModelState.Clear(); // Clears textbox
CounselReq counselS = new CounselReq();
counselS.Queue = userDAL.getSessions();
return(View(counselS));
}