//Done
public static string NextQuestion(string GameID, string UserID)
{
BaseObjects.GeneralResponse Result = new BaseObjects.GeneralResponse();
NextQuestionResult Response = new NextQuestionResult();
Response.Question = new Question();
Response.Question.CurrectAnswer = new Answer();
Response.Answer = new List <Answer>();
try
{
DataSet ds = new DataSet();
SqlDataAdapter dapt = new SqlDataAdapter("[spGetNextQuestion]", BaseObjects.connectionSTR);
dapt.SelectCommand.CommandType = CommandType.StoredProcedure;
dapt.SelectCommand.Parameters.Add("@GameID", SqlDbType.NVarChar, 100).Value = GameID;
dapt.SelectCommand.Parameters.Add("@UserID", SqlDbType.NVarChar, 100).Value = UserID;
dapt.SelectCommand.Parameters.Add("@Message", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
dapt.SelectCommand.Parameters.Add("@ResponseCode", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
dapt.Fill(ds);
Result.Message = dapt.SelectCommand.Parameters["@Message"].Value.ToString();
Result.ResponseCode = dapt.SelectCommand.Parameters["@ResponseCode"].Value.ToString();
if (ds.Tables[0].Rows.Count > 0)
{
Response.Question.ID = ds.Tables[0].Rows[0]["QuestionID"].ToString();
Response.Question.Description = ds.Tables[0].Rows[0]["QuestionDescription"].ToString();
Response.Question.CurrectAnswer.ID = ds.Tables[0].Rows[0]["CorrectAnswerID"].ToString();
Response.Question.CurrectAnswer.Description = ds.Tables[0].Rows[0]["CorrectAnswerDescription"].ToString();
Response.Question.QuestionTime = ds.Tables[0].Rows[0]["QuestionTime"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
Answer a = new Answer();
a.ID = ds.Tables[1].Rows[i]["AnswerID"].ToString();
a.OrderNo = ds.Tables[1].Rows[i]["OrderNo"].ToString();
a.OrderText = ds.Tables[1].Rows[i]["OrderText"].ToString();
a.Description = ds.Tables[1].Rows[i]["AnswerDescription"].ToString();
Response.Answer.Add(a);
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(Response));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(Result));
}
}
public static BaseObjects.GeneralResponse StartGame(string GameID)
{
BaseObjects.GeneralResponse Result = new BaseObjects.GeneralResponse();
SqlCommand cm = new SqlCommand();
SqlConnection cn = new SqlConnection(BaseObjects.connectionSTR);
cm.Connection = cn;
cm.CommandText = "[spStartGame]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@GameID", SqlDbType.NVarChar, 100).Value = GameID;
cm.Parameters.Add("@Message", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
cm.Parameters.Add("@ResponseCode", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
cn.Open();
cm.ExecuteNonQuery();
Result.Message = cm.Parameters["@Message"].Value.ToString();
Result.ResponseCode = cm.Parameters["@ResponseCode"].Value.ToString();
cn.Close();
cn.Dispose();
cm.Dispose();
return(Result);
}
//Done
public static string ListWithGamesStatus(string UserID)
{
BaseObjects.GeneralResponse Result = new BaseObjects.GeneralResponse();
List <QuestionGroupResult> Res = new List <QuestionGroupResult>();
try
{
DataSet ds = new DataSet();
SqlDataAdapter dapt = new SqlDataAdapter("[spGetQuestionGroupListWithGamesStatus]", BaseObjects.connectionSTR);
dapt.SelectCommand.Parameters.Add("@UserID", SqlDbType.NVarChar, 100).Value = UserID;
dapt.SelectCommand.Parameters.Add("@Message", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
dapt.SelectCommand.Parameters.Add("@ResponseCode", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
dapt.SelectCommand.CommandType = CommandType.StoredProcedure;
dapt.Fill(ds);
Result.Message = dapt.SelectCommand.Parameters["@Message"].Value.ToString();
Result.ResponseCode = dapt.SelectCommand.Parameters["@ResponseCode"].Value.ToString();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
QuestionGroupResult Q = new QuestionGroupResult();
Q.ID = ds.Tables[0].Rows[i]["QuestionGroupID"].ToString();
Q.Description = ds.Tables[0].Rows[i]["QuestionGroupDescription"].ToString();
Q.CountOfClosedGame = ds.Tables[0].Rows[i]["CountOfClosedGame"].ToString();
Q.CountOfOpenGame = ds.Tables[0].Rows[i]["CountOfOpenGame"].ToString();
Res.Add(Q);
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(Res));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(Result));
}
}
