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); }