public Question QuestionsByUser(int Q_By) { Question model = new Question(); MySqlCommand cmd = new MySqlCommand("spGetQuestionsByAskerID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("pQ_By", Q_By); dbUtil = new DBUtil(3); DataSet dsQuestionsByUser = dbUtil.FillDataSet(cmd); QuestionWS Qws = new QuestionWS(); model = Qws.GenModel4mDS(dsQuestionsByUser); return(model); }
public Question GetQuestionsBySortFilter(string Sort) { string procName; switch (Sort) { case "Premium": procName = "spGetPremiumQuestions"; break; case "Trending": procName = "spGetTrendingQuestions"; break; case "Unanswered": procName = "spGetUnansweredQuestions"; break; case "Live": procName = "spGetLiveQuestions"; break; case "Popular": procName = "spGetPopularQuestions"; break; case "Oldest": procName = "spGetOldestQuestions"; break; case "Newest": default: procName = "spGetAllQuestions"; break; } QuestionWS Qws = new QuestionWS(); Question model = Qws.GenModel4mDS( Questions_ds: Qws.GetQuestions(procName)); return(model); }