public static DataSet GetNameOfMovieXCode(string Id)
{
WSDB.WebServiceSoapClient WS = new WSDB.WebServiceSoapClient();
DataSet ds = WS.GetData("SELECT [id],[Codigo],[Pelicula] FROM [Paz].[dbo].[Peliculas] where codigo='" + Id + "'", Server, DB);
return(ds);
}
public static DataSet GetAllMovies()
{
WSDB.WebServiceSoapClient WS = new WSDB.WebServiceSoapClient();
DataSet ds = WS.GetData("SELECT [id],[Codigo],[Pelicula] FROM [Paz].[dbo].[Peliculas]", Server, DB);
return(ds);
}
public static void InsertNewMovie(string Codigo, string NPelicula)
{
WSDB.WebServiceSoapClient WS = new WSDB.WebServiceSoapClient();
DataSet ds = WS.GetData("INSERT INTO [Paz].[dbo].[Peliculas] (Codigo,Pelicula) values ('" + Codigo + "','" + NPelicula + "');", Server, DB);
}