public string InsertQuestion(string Question, string Answer, string Diagram, string TimeInSeconds, string Points, string Category)
{
QuestionsAndAnswer question = new QuestionsAndAnswer();
question.Question = Question;
question.Answer = Answer;
question.Diagram = Diagram;
question.TimeInSeconds = Convert.ToInt32(TimeInSeconds);
question.Points = Convert.ToInt32(Points);
question.Category = Category;
linq.QuestionsAndAnswers.InsertOnSubmit(question);
linq.SubmitChanges();
return("true");
}
public string UpdateQuestion(string QuestionID, string Question, string Answer, string Diagram, string TimeInSeconds, string Points, string Category)
{
QuestionsAndAnswer question = (from QuestionsAndAnswer in linq.QuestionsAndAnswers
where QuestionsAndAnswer.QuestionID == Convert.ToInt32(QuestionID)
select QuestionsAndAnswer).First();
question.Question = Question;
question.Answer = Answer;
question.Diagram = Diagram;
question.TimeInSeconds = Convert.ToInt32(TimeInSeconds);
question.Points = Convert.ToInt32(Points);
question.Category = Category;
linq.SubmitChanges();
return("true");
}
public string[] GetQuestion(string QuestionID)
{
QuestionsAndAnswer question = (from QuestionsAndAnswer in linq.QuestionsAndAnswers
where QuestionsAndAnswer.QuestionID == Convert.ToInt32(QuestionID)
select QuestionsAndAnswer).First();
string[] questionArray = new string[7];
questionArray[0] = question.QuestionID.ToString();
questionArray[1] = question.Question;
questionArray[2] = question.Answer;
questionArray[3] = question.Diagram;
questionArray[4] = question.TimeInSeconds.ToString();
questionArray[5] = question.Points.ToString();
questionArray[6] = question.Category;
return(questionArray);
}
partial void DeleteQuestionsAndAnswer(QuestionsAndAnswer instance);
partial void UpdateQuestionsAndAnswer(QuestionsAndAnswer instance);
partial void InsertQuestionsAndAnswer(QuestionsAndAnswer instance);
