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