Example #1
0
 public REPORTINCIDENT GetReportIncidents(int id)
 {
     using (ReidiusDBEntities3 enteties = new ReidiusDBEntities3())
     {
         return(enteties.REPORTINCIDENT.FirstOrDefault(e => e.reportIncidentID == id));
     }
 }
Example #2
0
 public IEnumerable <REPORTINCIDENT> GetReportedIncidents()
 {
     using (ReidiusDBEntities3 entities = new ReidiusDBEntities3())
     {
         return(entities.REPORTINCIDENT.ToList());
     }
 }
Example #3
0
        public void Post([FromBody] REPORTINCIDENT reportIncident)
        {
            try
            {
                using (ReidiusDBEntities3 entities = new ReidiusDBEntities3())
                {
                    entities.REPORTINCIDENT.Add(reportIncident);
                    entities.SaveChanges();
                }
            }


            catch (Exception ex)
            {
            }
        }
Example #4
0
        public HttpResponseMessage Get(string status)
        {
            using (ReidiusDBEntities3 enteties = new ReidiusDBEntities3())
            {
                switch (status)
                {
                case "Open":
                    return(Request.CreateResponse(HttpStatusCode.OK, enteties.REPORTINCIDENT.Where(e => e.status == "Open").ToList()));

                case "InProgress":
                    return(Request.CreateResponse(HttpStatusCode.OK, enteties.REPORTINCIDENT.Where(e => e.status == "InProgress").ToList()));

                case "Closed":
                    return(Request.CreateResponse(HttpStatusCode.OK, enteties.REPORTINCIDENT.Where(e => e.status == "Closed").ToList()));

                default:
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Status value must be Open, InProgress, or Closed"));
                }
            }
        }