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