//
/// <summary>
/// Return a count of filtered rows of Incident
/// </summary>
/// <param name="jsonString">
/// {"first":0,"rows":3,"sortOrder":1,"filters":{"ServerId":{"value":1,"matchMode":"eq"},"Mailed":{"value":false,"matchMode":"eq"},"Closed":{"value":false,"matchMode":"eq"},"Special":{"value":false,"matchMode":"eq"}},"globalFilter":null}
/// param>
/// <returns>List of IncidentData</returns>
public long GetCountPagination(string jsonString)
{
JavaScriptSerializer _js_slzr = new JavaScriptSerializer();
LazyLoadEvent _pagination = (LazyLoadEvent)_js_slzr.Deserialize(jsonString, typeof(LazyLoadEvent));
return(GetCountPagination(_pagination));
}
public void LazyLoading_LazyFilter11_BadOperator_Test()
{
string _pagination = "{\"first\":0,\"rows\":3,\"sortOrder\":-1," +
"\"filters\":{\"NoteTypeSortOrder\":{\"value\":\"100\",\"matchMode\":\"eq\"}},\"multiSortMeta\": {},\"globalFilter\": {}}";
Console.WriteLine(_pagination);
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
try
{
List <NoteType> _rows = noteTypeQueryable.LazyFilters <NoteType>(loadEvent).ToList();
Assert.Fail();
}
catch (ArgumentOutOfRangeException _ok)
{
Console.WriteLine(_ok.Message);
}
catch (Exception _ex)
{
Assert.Fail(_ex.Message);
}
//
}
//
public IncidentPaginationData()
{
incidents = new List <IncidentData>();
loadEvent = null;
totalRecords = 0;
message = "";
}
// Return a count of filtered rows of Incident
private long GetCountPagination(LazyLoadEvent jsonData)
{
IQueryable <Incident> _incidentQuery = _niEntities.Incidents;
_incidentQuery = _incidentQuery.LazyFilters(jsonData);
long _incidentCount = _incidentQuery.Count();
return(_incidentCount);
}
public void LazyLoadEvent_ToString_Test()
{
// given
LazyLoadEvent loadEvent = new LazyLoadEvent();
// when
string eventString = loadEvent.ToString();
// then
Assert.AreEqual(eventString, "LazyLoadEvent:[first: 0, rows: 0, sortField: /null/, sortOrder: 0, multiSortMeta: /null/, filters: /null/, globalFilter: /null/]");
//
}
public void LazyLoading_LazyFilter12_LT_LT_Test()
{
string _pagination = "{\"filters\":{\"NoteTypeId\":{\"value\":5,\"matchMode\":\"lt\"},\"NoteTypeSortOrder\":{\"value\":105,\"matchMode\":\"lt\"}}}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
List <NoteType> _rows = noteTypeQueryable.LazyFilters <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 3);
NoteType _row0 = _rows[0];
Assert.AreEqual(_row0.NoteTypeSortOrder, 104);
}
public void LazyLoading_LazyFilter10_EndsWith_Test()
{
string _pagination = "{\"filters\":{\"NoteTypeDesc\":{\"value\":\"1\",\"matchMode\":\"EndsWith\"}}}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
List <NoteType> _rows = noteTypeQueryable.LazyFilters <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 2);
NoteType _row0 = _rows[0];
Assert.IsTrue(_row0.NoteTypeDesc.Substring(_row0.NoteTypeDesc.Length - 1, 1) == "1");
}
public void LazyLoading_LazySkipTake02_Test()
{
string _pagination = "{\"first\":5,\"rows\":5}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
List <NoteType> _rows = noteTypeQueryable.LazySkipTake <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 2);
NoteType _row0 = _rows[0];
Assert.AreEqual(_row0.NoteTypeId, 6);
}
public void LazyLoading_LazyFilter05_LT_Test()
{
// string _pagination = "{\"filters\":{\"NoteTypeSortOrder\":{\"value\":100,\"matchMode\":\"equals\"},\"Mailed\":{\"value\":false,\"matchMode\":\"equals\"},\"Closed\":{\"value\":false,\"matchMode\":\"equals\"},\"Special\":{\"value\":false,\"matchMode\":\"equals\"}},\"globalFilter\":null}";
string _pagination = "{\"filters\":{\"NoteTypeSortOrder\":{\"value\":103,\"matchMode\":\"lt\"}}}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
List <NoteType> _rows = noteTypeQueryable.LazyFilters <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 4);
NoteType _row0 = _rows[0];
Assert.IsTrue(_row0.NoteTypeSortOrder < 103);
}
public void LazyLoadEvent_JsonString_Test()
{
// given
string lazyLoadJSON = "{\"first\":0,\"rows\":5,\"sortOrder\":1,\"filters\":{" +
"\"ServerId\":{\"value\":1,\"matchMode\":\"equals\"}," +
"\"Mailed\":{\"value\":false,\"matchMode\":\"equals\"}," +
"\"Closed\":{\"value\":false,\"matchMode\":\"equals\"}," +
"\"Special\":{\"value\":false,\"matchMode\":\"equals\"}},\"globalFilter\":null}";
// when
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(lazyLoadJSON);
// then
Assert.IsNotNull(loadEvent);
// when
string eventString = loadEvent.ToString();
// then
Assert.AreEqual(eventString, "LazyLoadEvent:[first: 0, rows: 5, sortField: , sortOrder: 1, multiSortMeta: /null/, filters: ServerId-equals:1:/null/, Mailed-equals:False:/null/, Closed-equals:False:/null/, Special-equals:False:/null/, globalFilter: /null/]");
//
}
public void LazyLoading_Lazy_All_01_Test()
{
string _jsonString = "{\"first\":0,\"rows\":3," +
"\"sortOrder\":-1,\"sortField\":\"NoteTypeSortOrder\"," +
"\"filters\":{\"NoteTypeDesc\":{\"value\":\"SO\",\"matchMode\":\"StartsWith\"}}}";
LazyLoadEvent _loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_jsonString);
List <NoteType> _rows = NoteTypes.AsQueryable()
.LazyOrderBy <NoteType>(_loadEvent)
.LazyFilters <NoteType>(_loadEvent)
.LazySkipTake <NoteType>(_loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 3);
NoteType _row0 = _rows[0];
Assert.IsTrue(_row0.NoteTypeDesc.Substring(0, 2) == "SO");
Assert.AreEqual(_row0.NoteTypeSortOrder, 104);
Assert.AreEqual(_row0.NoteTypeId, 2);
}
public void LazyLoading_LazyOrderBy02_Test()
{
// sortField: "NoteTypeSortOrder"
// string _pagination = "{\"sortOrder\":1,\"sortField\":\"NoteTypeSortOrder\",\"filters\":{\"ServerId\":{\"value\":1,\"matchMode\":\"equals\"},\"Mailed\":{\"value\":false,\"matchMode\":\"equals\"},\"Closed\":{\"value\":false,\"matchMode\":\"equals\"},\"Special\":{\"value\":false,\"matchMode\":\"equals\"}},\"globalFilter\":null}";
string _pagination = "{\"sortOrder\":-1,\"sortField\":\"NoteTypeSortOrder\"}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
List <NoteType> _rows = noteTypeQueryable.LazyOrderBy <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 7);
NoteType _row0 = _rows[0];
Assert.AreEqual(_row0.NoteTypeSortOrder, 200);
NoteType _row7 = _rows[6];
Assert.AreEqual(_row7.NoteTypeSortOrder, 100);
}
public void LazyLoading_LazyFilter01_IntEquals_Test()
{
string _pagination = "{\"first\":0,\"rows\":3,\"sortOrder\":-1," +
"\"filters\":{\"NoteTypeSortOrder\":{\"value\":\"100\",\"matchMode\":\"equals\"}},\"multiSortMeta\": {},\"globalFilter\": {}}";
IQueryable <NoteType> noteTypeQueryable =
(from _r in NoteTypes select _r).AsQueryable();
Console.WriteLine(_pagination);
LazyLoadEvent loadEvent = JsonConvert.DeserializeObject <LazyLoadEvent>(_pagination);
Console.WriteLine(loadEvent);
List <NoteType> _rows = noteTypeQueryable.LazyFilters <NoteType>(loadEvent).ToList();
//
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 2);
NoteType _row0 = _rows[0];
Assert.AreEqual(_row0.NoteTypeSortOrder, 100);
}
