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)); }