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));
}
}
