public void DatalistData_ZeroFilteredRecords()
{
Int32 actual = new DatalistData().FilteredRecords;
Int32 expected = 0;
Assert.AreEqual(expected, actual);
}
public void GetData_FiltersByCheckIds()
{
datalist.Filter.Sort = "Count";
datalist.Filter.CheckIds.Add("9I");
datalist.Filter.CheckIds.Add("15I");
datalist.Filter.AdditionalFilters.Add("ParentId", "1000");
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2014, 12, 19).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("9V", actual.Rows[0][MvcDatalist.AcKey]);
Assert.Equal("9I", actual.Rows[0][MvcDatalist.IdKey]);
Assert.Equal("9V", actual.Rows[0]["Value"]);
Assert.Equal("19", actual.Rows[0]["Count"]);
Assert.Equal(new DateTime(2014, 12, 25).ToString("d"), actual.Rows[1]["Date"]);
Assert.Equal("15V", actual.Rows[1][MvcDatalist.AcKey]);
Assert.Equal("15I", actual.Rows[1][MvcDatalist.IdKey]);
Assert.Equal("15V", actual.Rows[1]["Value"]);
Assert.Equal("25", actual.Rows[1]["Count"]);
Assert.Equal(datalist.Columns, actual.Columns);
Assert.Equal(2, actual.FilteredRows);
Assert.Equal(2, actual.Rows.Count);
}
public void GetData_FiltersBySearch()
{
datalist.Filter.Search = "33V";
datalist.Filter.Sort = "Count";
datalist.GetData();
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2015, 1, 12).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("33V", actual.Rows[0][MvcDatalist.AcKey]);
Assert.Equal("33I", actual.Rows[0][MvcDatalist.IdKey]);
Assert.Equal("33V", actual.Rows[0]["Value"]);
Assert.Equal("43", actual.Rows[0]["Count"]);
Assert.Equal(new DateTime(2015, 4, 22).ToString("d"), actual.Rows[1]["Date"]);
Assert.Equal("133V", actual.Rows[1][MvcDatalist.AcKey]);
Assert.Equal("133I", actual.Rows[1][MvcDatalist.IdKey]);
Assert.Equal("133V", actual.Rows[1]["Value"]);
Assert.Equal("143", actual.Rows[1]["Count"]);
Assert.Equal(datalist.Columns, actual.Columns);
Assert.Equal(2, actual.FilteredRows);
Assert.Equal(2, actual.Rows.Count);
}
public void GetData_FiltersByNotSelected()
{
datalist.Filter.Sort = "Count";
datalist.Filter.Search = "133V";
datalist.Filter.Selected.Add("15I");
datalist.Filter.Selected.Add("125I");
datalist.GetData();
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2014, 12, 25).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("15V", actual.Rows[0][MvcDatalist.AcKey]);
Assert.Equal("15I", actual.Rows[0][MvcDatalist.IdKey]);
Assert.Equal("15V", actual.Rows[0]["Value"]);
Assert.Equal("25", actual.Rows[0]["Count"]);
Assert.Equal(new DateTime(2015, 4, 14).ToString("d"), actual.Rows[1]["Date"]);
Assert.Equal("125V", actual.Rows[1][MvcDatalist.AcKey]);
Assert.Equal("125I", actual.Rows[1][MvcDatalist.IdKey]);
Assert.Equal("125V", actual.Rows[1]["Value"]);
Assert.Equal("135", actual.Rows[1]["Count"]);
Assert.Equal(new DateTime(2015, 4, 22).ToString("d"), actual.Rows[2]["Date"]);
Assert.Equal("133V", actual.Rows[2][MvcDatalist.AcKey]);
Assert.Equal("133I", actual.Rows[2][MvcDatalist.IdKey]);
Assert.Equal("133V", actual.Rows[2]["Value"]);
Assert.Equal("143", actual.Rows[2]["Count"]);
Assert.Equal(datalist.Columns, actual.Columns);
Assert.Equal(1, actual.FilteredRows);
Assert.Equal(3, actual.Rows.Count);
}
protected override DatalistData FormDatalistData(IQueryable <UserModel> models)
{
DatalistData data = new DatalistData();
data.FilteredRecords = models.Count();
data.Columns.Add("FirstName", "First name");
data.Columns.Add("LastName", "Last name");
IQueryable <UserModel> pagedModels = models
.Skip(CurrentFilter.Page * CurrentFilter.RecordsPerPage)
.Take(CurrentFilter.RecordsPerPage);
foreach (UserModel model in pagedModels)
{
Dictionary <String, String> row = new Dictionary <String, String>();
row.Add(IdKey, model.Id);
row.Add(AcKey, String.Format("{0} {1}", model.FirstName, model.LastName));
row.Add("FirstName", model.FirstName);
row.Add("LastName", model.LastName);
row.Add("AdditionalData", "Additional data");
data.Rows.Add(row);
}
return(data);
}
public void DatalistData_CreatesEmpty()
{
DatalistData actual = new DatalistData();
Assert.Empty(actual.Columns);
Assert.Empty(actual.Rows);
}
public void GetData_FiltersByIds()
{
datalist.Filter.Ids.Add("9I");
datalist.Filter.Ids.Add("15I");
datalist.Filter.Sort = "Count";
datalist.Filter.Search = "Term";
datalist.Filter.Selected.Add("17I");
datalist.Filter.AdditionalFilters.Add("Value", "5V");
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2014, 12, 19).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("9V", actual.Rows[0]["Label"]);
Assert.Equal("9V", actual.Rows[0]["Value"]);
Assert.Equal("19", actual.Rows[0]["Count"]);
Assert.Equal("9I", actual.Rows[0]["Id"]);
Assert.Equal(new DateTime(2014, 12, 25).ToString("d"), actual.Rows[1]["Date"]);
Assert.Equal("15V", actual.Rows[1]["Label"]);
Assert.Equal("15V", actual.Rows[1]["Value"]);
Assert.Equal("25", actual.Rows[1]["Count"]);
Assert.Equal("15I", actual.Rows[1]["Id"]);
Assert.Equal(datalist.Columns, actual.Columns);
Assert.Equal(2, actual.FilteredRows);
Assert.Equal(2, actual.Rows.Count);
}
public void DatalistData_CreatesEmpty()
{
DatalistData actual = new DatalistData();
Assert.Equal(0, actual.FilteredRows);
Assert.Empty(actual.Columns);
Assert.Empty(actual.Rows);
}
public void GetData_ReturnsPublicJsonData()
{
datalist.GetData().Returns(new DatalistData());
JsonResult actual = controller.GetData(datalist, filter);
DatalistData expectedData = datalist.GetData();
Assert.Equal(JsonRequestBehavior.AllowGet, actual.JsonRequestBehavior);
Assert.Same(expectedData, actual.Data);
}
public JsonResult AllPatient(DatalistFilter filter)
{
PatientDataList datalist = new PatientDataList(_context, GetClinicID())
{
Filter = filter
};
DatalistData patientList = datalist.GetData();
return(Json(patientList, JsonRequestBehavior.AllowGet));
}
public void GetData_FiltersByAdditionalFilters()
{
datalist.Filter.Search = "6V";
datalist.Filter.AdditionalFilters.Add("Count", 16);
datalist.GetData();
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2014, 12, 16).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("6V", actual.Rows[0][MvcDatalist.AcKey]);
Assert.Equal("6I", actual.Rows[0][MvcDatalist.IdKey]);
Assert.Equal("6V", actual.Rows[0]["Value"]);
Assert.Equal("16", actual.Rows[0]["Count"]);
Assert.Equal(datalist.Columns, actual.Columns);
Assert.Equal(1, actual.FilteredRows);
Assert.Single(actual.Rows);
}
public void GetData_Sorts()
{
datalist.Filter.Order = DatalistSortOrder.Asc;
datalist.Filter.Search = "55V";
datalist.Filter.Sort = "Count";
datalist.GetData();
DatalistData actual = datalist.GetData();
Assert.Equal(new DateTime(2015, 2, 3).ToString("d"), actual.Rows[0]["Date"]);
Assert.Equal("55V", actual.Rows[0][MvcDatalist.AcKey]);
Assert.Equal("55I", actual.Rows[0][MvcDatalist.IdKey]);
Assert.Equal("55V", actual.Rows[0]["Value"]);
Assert.Equal("65", actual.Rows[0]["Count"]);
Assert.Equal(new DateTime(2015, 5, 14).ToString("d"), actual.Rows[1]["Date"]);
Assert.Equal("155V", actual.Rows[1][MvcDatalist.AcKey]);
Assert.Equal("155I", actual.Rows[1][MvcDatalist.IdKey]);
Assert.Equal("155V", actual.Rows[1]["Value"]);
Assert.Equal("165", actual.Rows[1]["Count"]);
}
