public async Task <IActionResult> Edit(int id, [Bind("Id,HospitalId,Nome,CRV")] VeterinarioModel veterinarioModel)
{
if (id != veterinarioModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
veterinarioModel.Nome = veterinarioModel.Nome.ToUpper();
_context.Update(veterinarioModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VeterinarioModelExists(veterinarioModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["HospitalId"] = new SelectList(_context.HospitalModel, "Id", "Nome", veterinarioModel.HospitalId);
return(View(veterinarioModel));
}
public async Task <IActionResult> Create([Bind("Id,HospitalId,Nome,CRV")] VeterinarioModel veterinarioModel)
{
if (ModelState.IsValid)
{
veterinarioModel.Nome = veterinarioModel.Nome.ToUpper();
_context.Add(veterinarioModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["HospitalId"] = new SelectList(_context.HospitalModel, "Id", "Nome", veterinarioModel.HospitalId);
return(View(veterinarioModel));
}
public IHttpActionResult PostNewVeterinario(VeterinarioModel veterinario)
{
if (!ModelState.IsValid)
{
return(BadRequest("Datos invalidos"));
}
using (MySqlConnection conexion = ConexionBase.GetDBConnection()){
conexion.Open();
string insert = "insert into veterinarios (id, nombre, apellidoPaterno, apellidoMaterno, sexo) values ('" + veterinario.id + "', '" + veterinario.nombre + "', '" + veterinario.apellidoPaterno + "', '" + veterinario.apellidoMaterno + "', '" + veterinario.sexo + "' );";
MySqlCommand query = new MySqlCommand(insert, conexion);
MySqlDataReader myReader;
myReader = query.ExecuteReader();
conexion.Close();
return(Ok());
}
}
public IHttpActionResult Put(VeterinarioModel veterinario)
{
if (!ModelState.IsValid)
{
return(BadRequest("Modelo de datos invalido"));
}
using (MySqlConnection conexion = ConexionBase.GetDBConnection())
{
conexion.Open();
string update = "update veterinarios set nombre='" + veterinario.nombre + "',apellidoPaterno='" + veterinario.apellidoPaterno + "',apellidoMaterno='" + veterinario.apellidoMaterno + "',sexo='" + veterinario.sexo + "'where id='" + veterinario.id + "';";
MySqlCommand query = new MySqlCommand(update, conexion);
MySqlDataReader myReader;
myReader = query.ExecuteReader();
conexion.Close();
return(Ok());
}
}
public IHttpActionResult GetVeterinarioById(int id)
{
VeterinarioModel veterinario = null;
using (MySqlConnection conexion = ConexionBase.GetDBConnection())
{
conexion.Open();
MySqlCommand query = new MySqlCommand("select id, nombre, apellidoPaterno, apellidoMaterno, sexo from veterinarios where id=" + id.ToString(), conexion);
using (var reader = query.ExecuteReader())
{
// try
//{
reader.Read();
veterinario = new VeterinarioModel()
{
id = Convert.ToInt32(reader["Id"]),
nombre = reader["nombre"].ToString(),
apellidoPaterno = reader["apellidoPaterno"].ToString(),
apellidoMaterno = reader["apellidoMaterno"].ToString(),
sexo = reader["sexo"].ToString()
};
// }
/* catch (Exception e)
* {
* Console.WriteLine("ERRORSS"+e.Message);
* } */
}
if (veterinario == null)
{
return(NotFound());
}
else
{
return(Ok(veterinario));
}
}
}
