public IHttpActionResult Postt_Valve_Setting(t_Valve_Setting t_Valve_Setting)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.t_Valve_Setting.Add(t_Valve_Setting);

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

            return(CreatedAtRoute("DefaultApi", new { id = t_Valve_Setting.ValveID }, t_Valve_Setting));
        }
        public IHttpActionResult Gett_Valve_Setting(string id)
        {
            t_Valve_Setting t_Valve_Setting = db.t_Valve_Setting.Find(id);

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

            return(Ok(t_Valve_Setting));
        }
        public IHttpActionResult Deletet_Valve_Setting(string id)
        {
            t_Valve_Setting t_Valve_Setting = db.t_Valve_Setting.Find(id);

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

            db.t_Valve_Setting.Remove(t_Valve_Setting);
            db.SaveChanges();

            return(Ok(t_Valve_Setting));
        }
        public IHttpActionResult Putt_Valve_Setting(t_Valve_Setting t_Valve_Setting)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["db"].ConnectionString;
            int    nRows            = 0;

            using (SqlConnection connect = new SqlConnection(connectionString))
            {
                string sqlQuery = $"update t_Valve_Setting set ValveID = '{t_Valve_Setting.ValveID}', ValveTag = '{t_Valve_Setting.ValveTag}', Value = {t_Valve_Setting.Value}, Flag = '{t_Valve_Setting.Flag}'";

                connect.Open();
                using (SqlCommand command = new SqlCommand(sqlQuery, connect))
                {
                    nRows = command.ExecuteNonQuery();
                }
            }

            return(Ok(nRows));
        }