public async Task SimpleQueryAsync()
{
var client = new ReportsServiceClient();
var columns = await client.GetSelectableColumnsAsync(this.platform, 1, null, null);
var request = new SearchRequest()
{
SelectedColumns = columns.Data.Take(30).Select(x => new SelectedColumn(x.Id)).ToList(),
TemporalAggregation = TemporalAggregation.Total,
PageSize = 100,
SortByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GroupByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GetCount = true,
};
var result = await client.SearchAsync(this.platform, 1, null, request);
Assert.IsNotNull(result);
Assert.IsNotNull(result.Data);
Assert.GreaterOrEqual(result.Data.Count, 1);
Console.WriteLine("{0} rows returned", result.Data.Count);
}
public void SimpleQuery_Mixed_MultiThreaded(int threadCount)
{
var client = new ReportsServiceClient();
var columns = client.GetSelectableColumns(this.platform, 1, null, null);
var request1 = new SearchRequest()
{
SelectedColumns = columns.Data.Take(30).Select(x => new SelectedColumn(x.Id)).ToList(),
TemporalAggregation = TemporalAggregation.Total,
PageSize = 100,
SortByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GroupByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GetCount = true,
};
var request2 = new SearchRequest()
{
SelectedColumns = columns.Data.Take(30).Select(x => new SelectedColumn(x.Id)).ToList(),
TemporalAggregation = TemporalAggregation.Total,
PageSize = 100,
SortByColumn = columns.Data.Where(x => x.UniqueName == "Campaign_CurrencyCode").Select(x => new SelectedColumn(x.Id)).First(),
GroupByColumn = columns.Data.Where(x => x.UniqueName == "Campaign_CurrencyCode").Select(x => new SelectedColumn(x.Id)).First(),
GetCount = true,
Filters = new List <SearchRequestFilter>()
{
new SearchRequestFilter()
{
ColumnId = columns.Data.First(x => x.UniqueName.EndsWith("UIStatus")).Id,
Values = new List <string> {
"1"
}
}
}
};
Parallel.For(0, threadCount, x =>
{
var result1 = client.Search(this.platform, 1, null, request1);
Assert.IsNotNull(result1);
Assert.IsNotNull(result1.Data);
Assert.GreaterOrEqual(result1.Data.Count, 1);
Console.WriteLine("{0} rows returned", result1.Data.Count);
var result2 = client.Search(this.platform, 1, null, request2);
Assert.IsNotNull(result2);
Assert.IsNotNull(result2.Data);
Assert.GreaterOrEqual(result2.Data.Count, 1);
Console.WriteLine("{0} rows returned", result2.Data.Count);
Assert.LessOrEqual(result2.Data.Count, 5); // assume we wont ever have > 5 currencies
});
}
public void GetColumns()
{
var client = new ReportsServiceClient();
var columns = client.GetSelectableColumns(this.platform, 1, null, null);
Assert.IsNotNull(columns);
Assert.IsNotNull(columns.Data);
Assert.GreaterOrEqual(columns.Data.Count, 1);
Console.WriteLine("{0} columns returned", columns.Data.Count);
}
public ActionResult GetVehiclesBySupplierID(int id)
{
dynamic vehicleList = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
vehicleList = service.GetVehiclesBySupplierID(id);
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something went wrong");
vehicleList = null;
throw ex;
}
return(Json(vehicleList, JsonRequestBehavior.AllowGet));
}
public ActionResult YardDataReport()
{
dynamic YardDataList = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
YardDataList = service.YardDataReport();
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something went Wrong");
YardDataList = null;
throw ex;
}
return(Json(YardDataList, JsonRequestBehavior.AllowGet));
}
public JsonResult AllVehicleExpenseReport(DateTime fromDate, DateTime toDate)
{
dynamic vehicleList = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
vehicleList = service.AllVehicleExpenseReport(fromDate, toDate);
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something went Wrong");
vehicleList = null;
throw ex;
}
return(Json(vehicleList, JsonRequestBehavior.AllowGet));
}
protected SearchRequest SetupRequest(ReportsServiceClient client, string groupByColumnUniqueName, string sortByColumnUniqueName = null)
{
var selected = _allColumns.Data.Select(x => new SelectedColumn(x.Id)).ToList();
var groupBy = _allColumns.Data.Single(x => x.UniqueName.ToLower() == groupByColumnUniqueName.ToLower());
var sortBy = _allColumns.Data.Single(x => x.UniqueName.ToLower() == (sortByColumnUniqueName ?? groupByColumnUniqueName).ToLower());
var pageIndex = 0;
var searchRequest = new SearchRequest()
{
SelectedColumns = selected,
SortByColumn = new SelectedColumn(sortBy.Id),
GroupByColumn = new SelectedColumn(groupBy.Id),
DebugMode = true,
GetCount = pageIndex == 0,
PageIndex = pageIndex,
PageSize = 50,
SortDescending = false,
};
return(searchRequest);
}
public ActionResult GetDailySalesData(DateTime date)
{
dynamic salesList = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
salesList = service.GetDailySalesData(date);
//return Json(vehicleList, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something Went Wrong");
salesList = null;
throw ex;
}
return(Json(salesList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetVehiclesBySupplierName(string prefix)
{
dynamic vehicles = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
vehicles = service.GetVehicles(prefix);
//return Json(customers, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something Went Wrong");
vehicles = null;
throw ex;
}
return(Json(vehicles, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDepositRefundData(DateTime fromDate, DateTime toDate)
{
dynamic accountList = 0;
try
{
if (ModelState.IsValid)
{
ReportsServiceClient service = new ReportsServiceClient();
accountList = service.GetDepositeRefundData(fromDate, toDate);
}
}
catch (Exception ex)
{
ModelState.AddModelError("error", "Something Wrong");
accountList = null;
throw ex;
}
return(Json(accountList, JsonRequestBehavior.AllowGet));
}
public void SimpleQuery()
{
var client = new ReportsServiceClient();
var columns = client.GetSelectableColumns(this.platform, 1, null, null);
var request = new SearchRequest()
{
SelectedColumns = columns.Data.Take(30).Select(x => new SelectedColumn(x.Id)).ToList(),
TemporalAggregation = TemporalAggregation.Total,
PageSize = 100,
SortByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GroupByColumn = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
GetCount = true,
};
client.RequestHeaders = new List <RequestHeader>
{
new RequestHeader()
{
Name = "x-correlation-id", Value = Guid.NewGuid().ToString()
},
new RequestHeader()
{
Name = "x-requesting-component", Value = "Tests"
}
};
var result = client.Search(this.platform, 1, null, request);
Assert.IsNotNull(result);
Assert.IsNotNull(result.Data);
Assert.GreaterOrEqual(result.Data.Count, 1);
Console.WriteLine("{0} rows returned", result.Data.Count);
}
public async Task GetColumnsAsync()
{
var client = new ReportsServiceClient();
client.RequestHeaders = new List <RequestHeader>
{
new RequestHeader()
{
Name = "x-correlation-id", Value = Guid.NewGuid().ToString()
},
new RequestHeader()
{
Name = "x-requesting-component", Value = "Tests"
}
};
var columns = await client.GetSelectableColumnsAsync(this.platform, 1, null, null);
Assert.IsNotNull(columns);
Assert.IsNotNull(columns.Data);
Assert.GreaterOrEqual(columns.Data.Count, 1);
Console.WriteLine("{0} columns returned", columns.Data.Count);
}
public void Setup()
{
_client = new ReportsServiceClient();
_allColumnInfo = _client.GetColumnMappings(_platform, 1, null, clearCache: true);
_allColumns = _client.GetSelectableColumns(_platform, null, null);
}
public void Setup()
{
this.client = new ReportsServiceClient();
}
public HomeController(IStudentSystemApi studentSystemApi, ReportsServiceClient reportsClient)
{
this.studentSystemApi = studentSystemApi;
this.reportsClient = reportsClient;
}
