public void Should_Success_Get_Report_Data_Excel()
{
BsonDocument data = DataUtil.GetTestData();
var xls = this.Facade.GenerateExcel(GetBsonValue.ToString(data, "no"), GetBsonValue.ToString(data, "unit.code"), GetBsonValue.ToString(data, "items.purchaseOrder.category.code"), null, null);
Assert.IsType(typeof(System.IO.MemoryStream), xls);
this.Facade.DeleteDataMongoByNo(data["no"].AsString);
}
public void Should_Success_Get_Report_Data()
{
BsonDocument data = DataUtil.GetTestData();
var Response = this.Facade.GetReport(GetBsonValue.ToString(data, "no"), GetBsonValue.ToString(data, "unit.code"), GetBsonValue.ToString(data, "items.purchaseOrder.category.code"), null, null);
Assert.NotEqual(Response.Item2, 0);
this.Facade.DeleteDataMongoByNo(data["no"].AsString);
}
public async Task Should_Success_Get_Report_Data()
{
var data = DataUtil.GetTestData();
var result = await this.Facade.GetReport(25, 1, "{}", GetBsonValue.ToString(data.Item1, "no"), GetBsonValue.ToString(data.Item1, "supplier.code"), null, null, 7);
Assert.NotNull(result);
this.Facade.DeleteDataMongoUPO("{ _id : ObjectId('" + data.Item1["_id"].AsObjectId.ToString() + "') }");
this.Facade.DeleteDataMongoURN("{ _id : ObjectId('" + data.Item2["_id"].AsObjectId.ToString() + "') }");
}
public async Task Should_Success_Get_Mongo_Data_Parm()
{
var data = DataUtil.GetTestData();
var date = data.Item1["dueDate"].ToUniversalTime();
var result = await this.Facade.GetReportMongo(GetBsonValue.ToString(data.Item1, "no"), GetBsonValue.ToString(data.Item1, "supplier.code"), date.AddDays(-15), date.AddDays(15));
Assert.NotEmpty(result);
this.Facade.DeleteDataMongoUPO("{ _id : ObjectId('" + data.Item1["_id"].AsObjectId.ToString() + "') }");
this.Facade.DeleteDataMongoURN("{ _id : ObjectId('" + data.Item2["_id"].AsObjectId.ToString() + "') }");
}
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 async Task Should_Success_Get_Report_Data_Parm_All()
{
var data = DataUtil.GetTestData();
var date = data.Item1["dueDate"].ToUniversalTime();
var result = await this.Facade.GetReport(25, 1, "{\"UnitPaymentOrderNo\":\"asc\"}", GetBsonValue.ToString(data.Item1, "no"), GetBsonValue.ToString(data.Item1, "supplier.code"), date.AddDays(-15), date.AddDays(15), 0);
Assert.NotNull(result);
this.Facade.DeleteDataMongoUPO("{ _id : ObjectId('" + data.Item1["_id"].AsObjectId.ToString() + "') }");
this.Facade.DeleteDataMongoURN("{ _id : ObjectId('" + data.Item2["_id"].AsObjectId.ToString() + "') }");
}
