예제 #1
0
        public IHttpActionResult Postt_Valve_Status(t_Valve_Status t_Valve_Status)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.t_Valve_Status.Add(t_Valve_Status);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (t_Valve_StatusExists(t_Valve_Status.ValveID))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = t_Valve_Status.ValveID }, t_Valve_Status));
        }
예제 #2
0
        public IHttpActionResult Putt_Valve_Status(string id, t_Valve_Status t_Valve_Status)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != t_Valve_Status.ValveID)
            {
                return(BadRequest());
            }

            db.Entry(t_Valve_Status).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!t_Valve_StatusExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
예제 #3
0
        public IHttpActionResult Gett_Valve_Status(string id)
        {
            t_Valve_Status t_Valve_Status = db.t_Valve_Status.Find(id);

            if (t_Valve_Status == null)
            {
                return(NotFound());
            }

            return(Ok(t_Valve_Status));
        }
예제 #4
0
        public IHttpActionResult Deletet_Valve_Status(string id)
        {
            t_Valve_Status t_Valve_Status = db.t_Valve_Status.Find(id);

            if (t_Valve_Status == null)
            {
                return(NotFound());
            }

            db.t_Valve_Status.Remove(t_Valve_Status);
            db.SaveChanges();

            return(Ok(t_Valve_Status));
        }
예제 #5
0
        public DateTime?GetTimeDataSend(string valveId)
        {
            DateTime?temp = null;

            try
            {
                t_Valve_Status t = db.t_Valve_Status.Find(valveId);
                temp = t.TimeStamp;
            }
            catch
            {
                temp = null;
            }

            return(temp);
        }