public DocVenda Get(string id) { try { Models.Invoice invoice = (from i in db.Invoice where i.InvoiceNo == id select i).AsQueryable().First(); List <Models.Line> lines = (from i in db.Invoice join l in db.Line on i.InvoiceNo equals l.InvoiceNo where i.InvoiceNo == invoice.InvoiceNo select l).ToList(); Models.DocumentTotals doc = (from d in db.DocumentTotals where d.InvoiceNo == invoice.InvoiceNo select d).AsQueryable().First(); return(new DocVenda(invoice, lines, doc)); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public List <SaleInvoice> GetByClient(string id) { try { List <SaleInvoice> list = new List <SaleInvoice>(); List <Models.Invoice> invoices = (from i in db.Invoice where i.CustomerID == id select i).ToList(); foreach (var invoice in invoices) { List <Models.Line> lines = (from i in db.Line where i.InvoiceNo == invoice.InvoiceNo select i).ToList(); Models.DocumentTotals doc = (from d in db.DocumentTotals where d.InvoiceNo == invoice.InvoiceNo select d).AsQueryable().First(); list.Add(new SaleInvoice(invoice, lines, doc)); } return(list); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public List <SaleInvoice> GetByDate(string date) { DateTime time = DateTime.Today; var year = time.Year; var month = time.Month; var day = time.Day; double sumYear = 0; double sumMonth = 0; double sumDay = 0; double sumTotal = 0; var docs = new List <SaleInvoice>(); List <Models.Invoice> invoices = (from i in db.Invoice where i.InvoiceDate.CompareTo(date) >= 0 select i).ToList(); foreach (Models.Invoice invoice in invoices) { DateTime de = DateTime.Parse(invoice.InvoiceDate); List <Models.Line> lines = (from i in db.Invoice join l in db.Line on i.InvoiceNo equals l.InvoiceNo where i.InvoiceNo == invoice.InvoiceNo select l).ToList(); Models.DocumentTotals doc = (from d in db.DocumentTotals where d.InvoiceNo == invoice.InvoiceNo select d).AsQueryable().First(); docs.Add(new SaleInvoice(invoice, lines, doc)); } //docs = docs.OrderByDescending(x => x.Data).ToList(); return(docs); }
public List <DocVenda> Get() { DateTime time = DateTime.Today; var year = time.Year; var month = time.Month; var day = time.Day; double sumYear = 0; double sumMonth = 0; double sumDay = 0; double sumTotal = 0; var docs = new List <DocVenda>(); List <Models.Invoice> invoices = (from i in db.Invoice select i).ToList(); foreach (Models.Invoice invoice in invoices) { List <Models.Line> lines = (from i in db.Invoice join l in db.Line on i.InvoiceNo equals l.InvoiceNo where i.InvoiceNo == invoice.InvoiceNo select l).ToList(); Models.DocumentTotals doc = (from d in db.DocumentTotals where d.InvoiceNo == invoice.InvoiceNo select d).AsQueryable().First(); docs.Add(new DocVenda(invoice, lines, doc)); DateTime de = DateTime.Parse(invoice.InvoiceDate); sumTotal += doc.GrossTotal; if (de.Year >= year - 1) { sumYear += doc.GrossTotal; if (de.Month >= month) { sumMonth += doc.GrossTotal; if (de.Day == day) { sumDay += doc.GrossTotal; } } } } docs.Add(new Sums(sumYear, sumMonth, sumDay, sumTotal)); //docs = docs.OrderByDescending(x => x.Data).ToList(); return(docs); }
public List <SaleInvoice> GetByProduct(string id) { try { List <SaleInvoice> list = new List <SaleInvoice>(); List <Models.Invoice> invoices = (from i in db.Invoice join l in db.Line on i.InvoiceNo equals l.InvoiceNo where l.ProductCode == id select i).ToList(); foreach (var invoice in invoices) { List <Models.Line> lines = (from i in db.Line where i.InvoiceNo == invoice.InvoiceNo && i.ProductCode == id select i).ToList(); Models.DocumentTotals doc = (from d in db.DocumentTotals where d.InvoiceNo == invoice.InvoiceNo select d).AsQueryable().First(); if (list.Find(x => x.invoice == invoice) == null) { list.Add(new SaleInvoice(invoice, lines, doc)); } } return(list); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }
public DocVenda(Models.Invoice invoice, List <Models.Line> lines, Models.DocumentTotals docs) { this.invoice = invoice; this.lines = lines; this.docs = docs; }