//
// GET: /Tutorials/
public ActionResult Basics()
{
ViewBag.keywords = "C# tutorial for beginners quick and easy";
List<QuestionModel> questions = new List<QuestionModel>();
if (ModelState.IsValid)
{
ConnManager connManager = new ConnManager();
questions = connManager.GetQuestions("Select top 190 * from Question order by questionid");
}
return View(questions);
}
//[Route("")]
public ActionResult UnAns(string ddType)
{
List<QuestionModel> questions = new List<QuestionModel>();
//if (ModelState.IsValid)
//{
string strSQL = string.Empty;
user = (Users)Session["User"];
long val = 0;
if (!string.IsNullOrEmpty(ddType))
{
try
{
val = Convert.ToInt64(ddType);
}
catch
{
return View("../Que/UnAns");
}
if (user != null && user.UserId == 1)
strSQL = "Select * from Question Where QuestionId > 37861 and QuestionTypeId = " + ddType + " order by questionid desc";
else
strSQL = "Select top 75 * from Question Where QuestionId > 37861 and QuestionTypeId = " + ddType + " order by questionid desc";
}
else
{
if (user != null && user.UserId == 1)
strSQL = "Select * from Question Where QuestionId > 37861 order by questionid desc";
else
strSQL = "Select top 75 * from Question Where QuestionId > 37861 order by questionid desc";
}
ConnManager connManager = new ConnManager();
questions = connManager.GetQuestions(strSQL);
//}
ConnManager conn = new ConnManager();
List<QuestionType> items = conn.GetQuestionType();
ViewBag.DDItems = items;
return View(questions);
}
private List<QuestionModel> GetMyQues(List<QuestionModel> questions)
{
user = (Users)Session["User"];
if (ModelState.IsValid)
{
string strSQL = string.Empty;
strSQL = "SELECT * FROM VwQuestions WHERE AskedUser = " + user.UserId;
ConnManager connManager = new ConnManager();
questions = connManager.GetQuestions(strSQL);
}
return questions;
}