public async Task <IActionResult> DeleteAllStudents()
{
using (var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection")))
{
try
{
connection.Open();
var numberOfAffectedRows = await StudentsRepository.DeleteAllStudentsAsync(connection);
if (numberOfAffectedRows == 0)
{
return(NotFound("There aren't any students in database"));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
return(NoContent());
}