public async Task <IActionResult> DeleteConfirmed(int id)
{
var clientService = await _context.ClientServices.FindAsync(id);
var lines = await _context.Clineitems
.Where(l => l.ClientServiceId == clientService.ClientServiceId).ToListAsync();
foreach (Clineitem l in lines)
{
_context.Clineitems.Remove(l);
_context.SaveChanges();
}
var sca = await _context.ScaScreen
.FirstOrDefaultAsync(m => m.ClientServiceId == clientService.ClientServiceId);
if (sca != null)
{
_context.ScaScreen.Remove(sca);
_context.SaveChanges();
}
_context.ClientServices.Remove(clientService);
_context.SaveChanges();
TempData["Alert"] = "Deleted Inquiry";
return(RedirectToAction(nameof(Index)));
}