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