public Task <int> Count(DocumentPagination p) { var query = from d in context.Documents select d; if (p.From != "") { var date = DateTime.Parse(p.From); query = query.Where(d => d.EmissionDate.Date >= date); } if (p.To != "") { var date = DateTime.Parse(p.To); query = query.Where(d => d.EmissionDate.Date <= date); } if (p.State != null) { query = query.Where(d => d.EmissionState == p.State); } if (p.Plate != null) { query = query.Where(d => d.Plate == p.Plate); } if (p.EmissionPoint != 0) { query = query.Where(d => d.EmissionPoint.Id == p.EmissionPoint); } return(query.CountAsync()); }
public async Task <IActionResult> Get([FromQuery] DocumentPagination p) { var documents = await documentRepository.Get(p); var orders = new List <OrderResponse>(); foreach (Document document in documents) { var docType = document.Type; var serie = document.Serie; var correlative = document.Correlative; var order = new OrderResponse { Document = document, Tax = await taxRepository.Find(docType, serie, correlative), Detail = await detailRepository.Find(docType, serie, correlative) }; orders.Add(order); } ; return(Json(new StandardResponse { Status = 200, Data = orders })); }
public async Task <IActionResult> Count([FromQuery] DocumentPagination p) { var count = await documentRepository.Count(p); return(Json(new StandardResponse { Status = 200, Data = count })); }
public Task <List <Document> > Get(DocumentPagination p) { // Console.WriteLine($"From: {p.From}"); // Console.WriteLine($"To: {p.To}"); // Console.WriteLine($"State: {p.State}"); // Console.WriteLine($"Plate: {p.Plate}"); // Console.WriteLine(p.Plate == null); // Console.WriteLine(p.State == null); var query = from d in context.Documents select d; if (p.From != null && p.From != "") { var date = DateTime.Parse(p.From).Date; query = query.Where(d => d.EmissionDate.Date >= date); } if (p.To != null && p.To != "") { var date = DateTime.Parse(p.To).Date; query = query.Where(d => d.EmissionDate.Date <= date); } if (p.State != null) { query = query.Where(d => d.EmissionState == p.State); } if (p.Plate != null) { query = query.Where(d => d.Plate == p.Plate); } if (p.EmissionPoint != 0) { query = query.Where(d => d.EmissionPoint.Id == p.EmissionPoint); } if (p.User != 0) { query = query.Where(d => d.User.Id == p.User); } if (p.Serie != null) { query = query.Where(d => d.Serie == p.Serie); } if (p.Correlative != 0) { query = query.Where(d => d.Correlative == p.Correlative); } query = query.Include(d => d.User).Include(d => d.EmissionPoint); return(query.ToListAsync()); }
public async Task <IActionResult> GenerateGeneralReport(DocumentPagination p) { var documents = await documentRepository.Get(p); var orders = new List <OrderResponse>(); foreach (Document document in documents) { var docType = document.Type; var serie = document.Serie; var correlative = document.Correlative; var order = new OrderResponse { Document = document, Tax = await taxRepository.Find(docType, serie, correlative), Detail = await detailRepository.Find(docType, serie, correlative) }; orders.Add(order); } ; var binary = reportService.GenerateOrdersReport(orders); // HttpResponseMessage response = new HttpResponseMessage(); // response.Content = new ByteArrayContent(binary); // response.Content.Headers.ContentDisposition = new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment"); // response.Content.Headers.ContentDisposition.FileName = $"Reporte-Ventas-{DateTime.Now.ToString("dd/MM/yyy hh:m:ss")}"; // response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel"); // return response; var hardcoded = Convert.ToBase64String(binary); return(Json(new StandardResponse { Status = 200, Data = hardcoded })); }