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 void AddInvoiceRows(List <InvoiceRow> invoiceRows, int id)
{
foreach (var ir in invoiceRows)
{
ir.InvoiceId = id;
InvoiceRow.Add(ir);
this.SaveChanges();
}
}
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);
}
}
//public Client GetClientByData(string nip,string name)
//{
// var client = Client.Where(c => c.Nip == id).FirstOrDefault();
// return client;
//}
public List <InvoiceRow> GetInvoiceRow(int id)
{
var iRows = InvoiceRow.Where(i => i.InvoiceId == id).ToList();
return(iRows);
}
