public HttpResponseMessage updatePedido(recetasModel receta)
{
try
{
using (SqlConnection conn = new SqlConnection(DatabaseConnectionString))
{
SqlCommand cmd = new SqlCommand("UPDATE RECETAS SET Imagen=@imagen, idDoctor=@doctor WHERE idReceta=@id", conn);
cmd.Parameters.AddWithValue("@id", receta.idReceta);
cmd.Parameters.AddWithValue("@imagen", receta.Imagen);
cmd.Parameters.AddWithValue("@doctor", receta.idDoctor);
cmd.Connection = conn;
conn.Open();
cmd.ExecuteReader();
var message = Request.CreateResponse(HttpStatusCode.Created, receta);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage regReceta([FromBody] recetasModel receta)
{
try
{
using (SqlConnection conn = new SqlConnection(DatabaseConnectionString))
{
SqlCommand cmd = new SqlCommand("INSERT INTO RECETAS(idCliente,Imagen,Estado, idDoctor) OUTPUT INSERTED.idReceta VALUES (@cliente,@imagen,@estado,@doctor)", conn);
cmd.Parameters.AddWithValue("@cliente", receta.idCliente);
cmd.Parameters.AddWithValue("@imagen", receta.Imagen);
cmd.Parameters.AddWithValue("@estado", 1);
cmd.Parameters.AddWithValue("@doctor", receta.idDoctor);
cmd.Connection = conn;
conn.Open();
var message = Request.CreateResponse(HttpStatusCode.Created, serial.singleserialize(cmd.ExecuteReader()));
conn.Close();
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
