public async Task <bool> DeleteSurvey(int id) { var existingSurvey = await _surveyRepository.GetAsync(id); if (existingSurvey == null) { return(false); } var param = new SqlParameter[] { new SqlParameter() { ParameterName = "@QuestionId", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = DBNull.Value }, new SqlParameter() { ParameterName = "@SurveyId", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Size = 50, Value = id } }; await _surveyRepository.ExecuteSqlRawAsync("[dbo].[SP_DeleteQuestionOrdersBySurveyIdQuestionId] @QuestionId, @SurveyId", param); await _surveyRepository.RemoveAsync(existingSurvey); return(true); }