Beispiel #1
0
 public GameAnswer(Answer answer)
 {
     Usable = true; ;
     AnswerString = answer.AnswerString;
     using (Repos repo = new Repos())
     {
         answer.Pictures = repo.GetPicturesByAnswerID(answer.AnswerID).ToList();
     }
     Pictures = ConvertPictures(answer.Pictures);
 }
Beispiel #2
0
 public bool AddAnswer(Answer answer)
 {
     var idParam = new SqlParameter
     {
         ParameterName = "AnswerString",
         Value = answer.AnswerString
     };
     var idParam1 = new SqlParameter
     {
         ParameterName = "ModuleID",
         Value = answer.ModuleID
     };
     try
     {
         _dc.Database.ExecuteSqlCommand(
             "INSERT INTO [dbo].[Answers] ([AnswerString],[ModuleID]) VALUES (@AnswerString, @ModuleID)", idParam, idParam1
             );
     }
     catch (Exception)
     {
         return false;
     }
     return true;
 }
Beispiel #3
0
 public bool UpdateAnswer(Answer answer)
 {
     var idParam = new SqlParameter
     {
         ParameterName = "AnswerString",
         Value = answer.AnswerString
     };
     var idParam1 = new SqlParameter
     {
         ParameterName = "ModuleID",
         Value = answer.ModuleID
     };
     var idParam2 = new SqlParameter
     {
         ParameterName = "AnswerID",
         Value = answer.AnswerID
     };
     try
     {
         _dc.Database.ExecuteSqlCommand(
             "UPDATE Answers SET AnswerString = @AnswerString, ModuleID = @ModuleID WHERE AnswerID = @AnswerID", idParam, idParam1, idParam2
             );
     }
     catch (Exception)
     {
         return false;
     }
     return true;
 }