public VideoPlayer ObtenerVideo(int id) { VideoPlayer video = null; SqlConnection con = new SqlConnection(cadenaConexion); con.Open(); //Cambiar la ruta string sql = "SELECT Nombre, Telefono FROM Clientes WHERE IdCliente = @idcliente"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@idcliente", System.Data.SqlDbType.NVarChar).Value = id; SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (reader.Read()) { video = new VideoPlayer(); video.Id = id; video.Nombre = reader.GetString(0); video.link = reader.GetString(1); video.tipus = reader.GetString(2); } reader.Close(); return video; }
// POST /Api/Clientes/Cliente { Nombre:"nombre", Telefono:123456789 } // PUT /Api/Clientes/Cliente/3 { Id:3, Nombre:"nombre", Telefono:123456789 } // GET /Api/Clientes/Cliente/3 // DELETE /Api/Clientes/Cliente/3 public JsonResult Videos(int? id, VideoPlayer item) { switch (Request.HttpMethod) { case "POST": return Json(videomanager.InsertarVideo(item)); /* case "PUT": return Json(clientesManager.ActualizarCliente(item));*/ case "GET": return Json(videomanager.ObtenerVideo(id.GetValueOrDefault()), JsonRequestBehavior.AllowGet); /* case "DELETE": return Json(clientesManager.EliminarCliente(id.GetValueOrDefault()));*/ } return Json(new { Error = true, Message = "Operación HTTP desconocida" }); }
public bool InsertarVideo(VideoPlayer video) { SqlConnection con = new SqlConnection(cadenaConexion); con.Open(); //Cambiar la ruta string sql = "INSERT INTO Clientes (Nombre, link, tipus) VALUES (@nombre, @link, @tipus)"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@nombre", System.Data.SqlDbType.NVarChar).Value = video.Nombre; cmd.Parameters.Add("@link", System.Data.SqlDbType.NVarChar).Value = video.link; cmd.Parameters.Add("@tipus", System.Data.SqlDbType.NVarChar).Value = video.tipus; int res = cmd.ExecuteNonQuery(); con.Close(); return (res == 1); }
public List<VideoPlayer> ObtenerVideos() { List<VideoPlayer> lista = new List<VideoPlayer>(); SqlConnection con = new SqlConnection(cadenaConexion); con.Open(); //Cambiar ruta string sql = "SELECT IdCliente, Nombre, Telefono FROM Clientes"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { VideoPlayer video = new VideoPlayer(); video = new VideoPlayer(); video.Id = reader.GetInt32(0); video.Nombre = reader.GetString(1); video.link = reader.GetString(2); video.tipus = reader.GetString(3); lista.Add(video); } reader.Close(); return lista; }