public void WebSrv_NI_Incident_GetByPrimaryKey_Test()
{
long _id = 1;
IncidentAccess _sut = new IncidentAccess(_niEntities);
IncidentData _row = _sut.GetByPrimaryKey(_id);
Assert.IsNotNull(_row);
Assert.AreEqual(_row.IncidentId, _id);
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
//
// GET api/<controller>/5
/// <summary>
/// /api/Incident/1?mailed=true&closed=true&special=false
/// </summary>
/// <param name="id"></param>
/// <param name="mailed"></param>
/// <param name="closed"></param>
/// <param name="special"></param>
/// <returns></returns>
public IEnumerable <IncidentData> Get(int id, [FromUri] bool mailed, [FromUri] bool closed, [FromUri] bool special)
{
IncidentAccess _access = new IncidentAccess(_incidentEntities);
IEnumerable <IncidentData> _incidents = null;
_incidents = _access.ListIncidentQueryable()
.Where(_r => _r.ServerId == id &&
_r.Mailed == mailed && _r.Closed == closed && _r.Special == special)
.OrderByDescending(_r => _r.IncidentId);
return(_incidents);
}
public void WebSrv_NI_Incident_ListbyFlags_MailedClosed_Test()
{
IncidentAccess _sut = new IncidentAccess(_niEntities);
List <IncidentData> _data = _sut.ListbyFlags(1, true, true, false);
Assert.IsTrue(_data.Count > 0);
Assert.AreEqual(_data[0].ServerId, 1);
foreach (var _row in _data)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
}
public IncidentPaginationData Get()
{
// cheating hack
string _uri = System.Web.HttpUtility.UrlDecode(Request.RequestUri.Query);
if (string.IsNullOrEmpty(_uri) || _uri.Length == 1)
{
IncidentPaginationData _return = new IncidentPaginationData();
_return.message = "Invalid pagination options.";
return(_return);
}
if (_uri.Substring(0, 1) == "?")
{
_uri = _uri.Substring(1);
}
IncidentAccess _access = new IncidentAccess(_incidentEntities);
IncidentPaginationData _incidents = _access.ListByPagination(_uri);
return(_incidents);
}
public void WebSrv_NI_Incident_ListByPagination01_Test()
{
IncidentAccess _sut = new IncidentAccess(_niEntities);
string _pagination = "{\"first\":0,\"rows\":3,\"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}";
IncidentPaginationData _data = _sut.ListByPagination(_pagination);
System.Diagnostics.Debug.WriteLine(string.Format("Tot Rec:{0}, Msg:{1}",
_data.totalRecords, _data.message));
List <IncidentData> _rows = _data.incidents;
foreach (var _row in _rows)
{
System.Diagnostics.Debug.WriteLine(_row.ToString());
}
Assert.IsTrue(_rows.Count == 3);
IncidentData _row0 = _rows[0];
Assert.AreEqual(_row0.ServerId, 1);
Assert.AreEqual(_row0.Mailed, false);
}
//
#endregion
//
// DELETE api/Incident/<key> delete
//
#region "restful updates"
//
/// <summary>
/// DELETE api/Incident/<key>
///
/// Delete one row from Incident
/// </summary>
/// <param name="id">IncidentID of the record to delete</param>
public int Delete(long id)
{
IncidentAccess _access = new IncidentAccess(_incidentEntities);
return(_access.Delete(id));
}
