public bool DeleteQuestion(short QuestionID) { Common.ConnectionManagement myconnector = new Common.ConnectionManagement(_connectionstring); List <SqlParameter> procParams = new List <SqlParameter>(); procParams.Add(new SqlParameter("QuestionID", QuestionID)); Common.SQLQueryResult queryRes = myconnector.ExecuteNonQueryProcedure("srvy.DeleteQuestion", procParams, 600); _lastSqlException = queryRes.SqlError; if (queryRes.SqlError != null) { return(false); } else { return(true); } }
//----------------------------------------- //-------- Answer Table Methods ---------- //----------------------------------------- public bool InsertAnswer(short QuestionID, bool?YesNo, string Description) { Common.ConnectionManagement myconnector = new Common.ConnectionManagement(_connectionstring); List <SqlParameter> procParams = new List <SqlParameter>(); procParams.Add(new SqlParameter("@QuestionID", QuestionID)); procParams.Add(new SqlParameter("@YesNo", YesNo)); procParams.Add(new SqlParameter("@Description", Description)); Common.SQLQueryResult queryRes = myconnector.ExecuteNonQueryProcedure("srvy.InsertAnswer", procParams, 600); _lastSqlException = queryRes.SqlError; if (queryRes.SqlError != null) { return(false); } else { return(true); } }