public List <Client> DeleteClient(int number)
{
try
{
var invoice = Invoice.Where(a => a.ClientId == number).ToList();
foreach (var item in invoice)
{
var invoiceRow = InvoiceRow.Where(i => i.InvoiceId == item.InvoiceId).ToList();
foreach (var ir in invoiceRow)
{
InvoiceRow.Remove(ir);
this.SaveChanges();
}
Invoice.Remove(item);
this.SaveChanges();
}
var client = Client.Where(a => a.ClientId == number).FirstOrDefault();
Client.Remove(client);
this.SaveChanges();
return(Client.ToList());
}
catch (Exception ex)
{
return(null);
}
}
public List <Invoice> DeleteInvoice(int number)
{
try
{
var invoiceRow = InvoiceRow.Where(a => a.InvoiceId == number).ToList();
foreach (var item in invoiceRow)
{
InvoiceRow.Remove(item);
this.SaveChanges();
}
var invoice = Invoice.Where(a => a.InvoiceId == number).FirstOrDefault();
Invoice.Remove(invoice);
this.SaveChanges();
return(Invoice.ToList());
}
catch (Exception ex)
{
return(null);
}
}