public IHttpActionResult PutCar(int id, Car car) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != car.Id) { return BadRequest(); } db.Entry(car).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CarExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
public IHttpActionResult PostCar(Car car) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.Cars.Add(car); db.SaveChanges(); return CreatedAtRoute("DefaultApi", new { id = car.Id }, car); }
public bool Edit(Car car) { try { F_Car f_cars = new F_Car(); f_cars.Update(car); return true; } catch (Exception e) { return false; } }
public bool Create(Car car) { try { F_Car f_cars = new F_Car(); f_cars.Insert(car); return true; } catch (Exception e) { return false; } }
public Car Find(int? id) { Car car = new Car(); Dt = new DataTable("Resultado"); try { //Conexion SqlCon = funciones_SQL.ObtenerConexion(); SqlCon.Open(); SqlCmd = new SqlCommand(); SqlCmd.CommandTimeout = 0;//Para correr queries pesados SqlCmd.Connection = SqlCon; //Mapear BD del Servidor SqlCmd.CommandText = "use [Software_Factory] select * from Car where car_id=@id"; SqlCmd.Parameters.AddWithValue("@id", id); SqlCmd.CommandType = CommandType.Text; SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd); SqlDat.Fill(Dt); if (Dt != null) { DataRow fila = Dt.Rows[0]; //El nombre de la fila debe ser igual al obtenido en el Query car.car_id = Int32.Parse(fila["car_id"].ToString()); ; car.name = fila["name"].ToString(); car.company = fila["company"].ToString(); car.stock = Int32.Parse(fila["stock"].ToString()); } Dt = null; } catch (Exception E) { throw new Exception("F_Car/Details: " + E.Message, E); } finally { if (SqlCon != null && SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return car; }
/// <summary> /// Extrae los datos de la tabla Car en SQL /// </summary> /// <returns>Listado de carros</returns> public List<Car> List() { List<Car> Listado = new List<Car>(); Dt = new DataTable("Resultado"); try { //Conexion SqlCon = funciones_SQL.ObtenerConexion(); SqlCon.Open(); SqlCmd = new SqlCommand(); SqlCmd.CommandTimeout = 0;//Para correr queries pesados SqlCmd.Connection = SqlCon; //Mapear BD del Servidor SqlCmd.CommandText = "use [Software_Factory] select * from Car"; SqlCmd.CommandType = CommandType.Text; SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd); SqlDat.Fill(Dt); foreach (DataRow fila in Dt.Rows) { Car aux = new Car(); //El nombre de la fila debe ser igual al obtenido en el Query aux.car_id = Int32.Parse(fila["car_id"].ToString()); ; aux.name = fila["name"].ToString(); aux.company = fila["company"].ToString(); aux.stock = Int32.Parse(fila["stock"].ToString()); //Nuevo elemento en la lista Listado.Add(aux); } Dt = null; } catch (Exception E) { throw new Exception("F_Car/Listar: " + E.Message, E); } finally { if (SqlCon != null && SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return Listado; }
public bool Update(Car car) { bool exito = false; try { //Conexion SqlCon = funciones_SQL.ObtenerConexion(); SqlCon.Open(); SqlCmd = new SqlCommand(); SqlCmd.CommandTimeout = 0;//Para correr queries pesados SqlCmd.Connection = SqlCon; //Mapear BD del Servidor SqlCmd.CommandText = "use [Software_Factory] update Car set name=@p1, company=@p2, stock=@p3 where car_id=@p4"; SqlCmd.Parameters.AddWithValue("@p1", car.name); SqlCmd.Parameters.AddWithValue("@p2", car.company); SqlCmd.Parameters.AddWithValue("@p3", car.stock); SqlCmd.Parameters.AddWithValue("@p4", car.car_id); SqlCmd.CommandType = CommandType.Text; SqlCmd.ExecuteNonQuery(); exito = true; } catch (Exception E) { throw new Exception("F_Car/Update: " + E.Message, E); } finally { if (SqlCon != null && SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return exito; }