public Tuple <List <UnitReceiptNoteViewModel>, int> GetReport(string no, string unit, string category, DateTime?dateFrom, DateTime?dateTo) { FilterDefinitionBuilder <UnitReceiptNoteViewModel> filterBuilderUnitReceiptNote = Builders <UnitReceiptNoteViewModel> .Filter; List <FilterDefinition <UnitReceiptNoteViewModel> > filter = new List <FilterDefinition <UnitReceiptNoteViewModel> > { filterBuilderUnitReceiptNote.Eq("_deleted", false), filterBuilderUnitReceiptNote.Eq("supplier.import", false) }; if (no != null) { filter.Add(filterBuilderUnitReceiptNote.Eq("no", no)); } if (unit != null) { filter.Add(filterBuilderUnitReceiptNote.Eq("unit.code", unit)); } if (category != null) { filter.Add(filterBuilderUnitReceiptNote.Eq("items.purchaseOrder.category.code", category)); } if (dateFrom != null && dateTo != null) { filter.Add(filterBuilderUnitReceiptNote.And(filterBuilderUnitReceiptNote.Gte("date", dateFrom), filterBuilderUnitReceiptNote.Lte("date", dateTo))); } IMongoCollection <UnitReceiptNoteViewModel> collection = new MongoDbContext().UnitReceiptNoteViewModel; List <UnitReceiptNoteViewModel> ListData = collection.Find(filterBuilderUnitReceiptNote.And(filter)).ToList(); //List<UnitReceiptNoteViewModel> ListData = collection.Aggregate() // .Match(filterBuilder.And(filter)) // .ToList(); foreach (var data in ListData) { var dataUnitPaymentOrder = collectionUnitPaymentOrder.Find(filterBuilder.Eq("items.unitReceiptNote.no", data.no)).FirstOrDefault(); data.incomeTaxNo = dataUnitPaymentOrder != null?GetBsonValue.ToString(dataUnitPaymentOrder, "incomeTaxNo", new BsonString("-")) : "-"; } return(Tuple.Create(ListData, ListData.Count)); }
public List <Livro> Obter() { return(context.Find()); }
public List <Midia> Obter() { return(context.Find()); }
public IEnumerable <Transaction> Get() { return(context.Find()); }
public List <Emprestimo> Obter() { return(context.Find()); }
public List <Pessoa> Obter() { return(context.Find()); }