public Question_bank GetQuestionsWithChoice(int gameID) { Question_bank objQuestionBank = new Question_bank(); List <QuestionandAnswer> objQuestionsWithChoice = new List <QuestionandAnswer>(); try { List <System.Data.Common.DbParameter> parameters = new List <System.Data.Common.DbParameter>(); parameters.Add(DbHelper.CreateParameter("GameID", gameID)); var data = DbHelper.ExecuteDataSet("USP_GETQuestionAndChoice", parameters.ToArray()); if (data.Tables[0].Rows.Count > 0) { foreach (DataRow row in data.Tables[0].Rows) { QuestionandAnswer objquestion = new QuestionandAnswer(); objquestion.GameId = Convert.ToInt32(row["GameID"]); objquestion.questionId = Convert.ToInt32(row["QuestionID"]); objquestion.question = Convert.ToString(row["Question"]); objquestion.correctChoice = Convert.ToString(row["CorrectChoice"]); objquestion.Category = Convert.ToString(row["Category"]); List <Choice> objchoiceLst = new List <Choice>(); if (!string.IsNullOrEmpty(Convert.ToString(row["Choice1"]))) { objchoiceLst = addChoice(Convert.ToString(row["Choice1"]), "Choice1", Convert.ToString(row["CorrectChoice"]), ref objchoiceLst); } if (!string.IsNullOrEmpty(Convert.ToString(row["Choice2"]))) { objchoiceLst = addChoice(Convert.ToString(row["Choice2"]), "Choice2", Convert.ToString(row["CorrectChoice"]), ref objchoiceLst); } if (!string.IsNullOrEmpty(Convert.ToString(row["Choice3"]))) { objchoiceLst = addChoice(Convert.ToString(row["Choice3"]), "Choice3", Convert.ToString(row["CorrectChoice"]), ref objchoiceLst); } if (!string.IsNullOrEmpty(Convert.ToString(row["Choice4"]))) { objchoiceLst = addChoice(Convert.ToString(row["Choice4"]), "Choice4", Convert.ToString(row["CorrectChoice"]), ref objchoiceLst); } if (!string.IsNullOrEmpty(Convert.ToString(row["Choice5"]))) { objchoiceLst = addChoice(Convert.ToString(row["Choice5"]), "Choice5", Convert.ToString(row["CorrectChoice"]), ref objchoiceLst); } objquestion.choices = objchoiceLst; objquestion.UpdatedDate = Convert.ToDateTime(row["UpdatedDate"]); objQuestionsWithChoice.Add(objquestion); } } objQuestionBank.question_bank = objQuestionsWithChoice; } catch (Exception ex) { Logger.Error(ex.Message); return(objQuestionBank); } return(objQuestionBank); }
public HttpResponseMessage GetQuestionsWithChoice(int gameID) { Logger.Info("GameID:" + gameID); Question_bank objqb = new Question_bank(); DataAccessService objservice = new DataAccessService(); var data = objservice.GetQuestionsWithChoice(gameID); return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage WWIDValidation(string WWID) { Logger.Info("WWID:" + WWID); Question_bank objqb = new Question_bank(); DataAccessService objservice = new DataAccessService(); int Count = objservice.ValidateWWID(WWID); if (Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, "WWID already Exist in Database.", Configuration.Formatters.JsonFormatter)); } else { return(Request.CreateResponse(HttpStatusCode.OK, "WWID Not Exist", Configuration.Formatters.JsonFormatter)); } }