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