public InvoiceDecorated Add(InvoiceDecorated invoice)
{
//This is not necesary put the table and primarykey because
//the class InvoiceDecorated had PocoDecoration
this.db.Insert(invoice);
return(invoice);
}
public Invoice GetFullInvoice(int id)
{
string getInvoice = "Select id, nroinvoice, company, customer, datecreate from dbo.invoice where id=@id";
string getInvoiceDetails = "Select id, idInvoice, productname, quantity, unitprice, subtotal from dbo.invoiceDetail where idInvoice=@id";
Invoice invoice = this.db.SingleOrDefault <Invoice>(getInvoice, id);
InvoiceDecorated invoiceDecorate = this.db.SingleOrDefault <InvoiceDecorated>("where id=@id", id);
List <InvoiceDetail> invoiceDetails = this.db.Query <InvoiceDetail>(getInvoiceDetails, id).ToList();
invoice.InvoiceDetails.AddRange(invoiceDetails);
return(invoice);
}
public InvoiceDecorated Update(InvoiceDecorated invoice)
{
this.Update(invoice);
return(invoice);
}
