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