public async Task <ActionResult <SearchReportsOutputModel> > Search(
[FromQuery] ReportsQuery query)
{
var reportListings = await this.reports.GetListings(query);
var totalPages = await this.reports.Total(query);
return(new SearchReportsOutputModel(reportListings, query.Page, totalPages));
}
public void GetReportsTestWithNullConnectionString()
{
var r = new ReportsQuery("");
var exception = Record.Exception(() => r.GetReports(""));
Assert.NotNull(exception);
_output.WriteLine(exception.Message);
Assert.True(exception.Message.Contains("is null"));
}
public async Task <ActionResult <MineReportsOutputModel> > Mine(
[FromQuery] ReportsQuery query)
{
var reporterId = await this.reporters.GetIdByUser(this.currentUser.UserId);
var reportListings = await this.reports.Mine(reporterId, query);
var totalPages = await this.reports.Total(query);
return(new MineReportsOutputModel(reportListings, query.Page, totalPages));
}
public void GetReportsTest(string supplierCode, string fromDate, string toDate)
{
var r = new ReportsQuery("");
DateTime?fromDateTime = string.IsNullOrEmpty(fromDate) ? (DateTime?)null : DateTime.Parse(fromDate);
DateTime?toDateTime = string.IsNullOrEmpty(toDate) ? (DateTime?)null : DateTime.Parse(toDate);
var exception = Record.Exception(() => r.GetReports(supplierCode, fromDateTime, toDateTime));
Assert.NotNull(exception);
_output.WriteLine(exception.Message);
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Reports mock = CreateMockInstance(tm);
bool result = DataRepository.ReportsProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
ReportsQuery query = new ReportsQuery();
query.AppendEquals(ReportsColumn.Idx, mock.Idx.ToString());
if (mock.DepId != null)
{
query.AppendEquals(ReportsColumn.DepId, mock.DepId.ToString());
}
if (mock.RepName != null)
{
query.AppendEquals(ReportsColumn.RepName, mock.RepName.ToString());
}
if (mock.Description != null)
{
query.AppendEquals(ReportsColumn.Description, mock.Description.ToString());
}
if (mock.Procedure != null)
{
query.AppendEquals(ReportsColumn.Procedure, mock.Procedure.ToString());
}
if (mock.DepCode != null)
{
query.AppendEquals(ReportsColumn.DepCode, mock.DepCode.ToString());
}
if (mock.Status != null)
{
query.AppendEquals(ReportsColumn.Status, mock.Status.ToString());
}
query.AppendEquals(ReportsColumn.SafeNameChecked, mock.SafeNameChecked.ToString());
TList <Reports> results = DataRepository.ReportsProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
