public static Compra GetTransaction(int UserId, int PeliculaId) { CompraTableAdapter adapter = new CompraTableAdapter(); Compra_DS.CompraDataTable table = adapter.ExistTransaction(UserId, PeliculaId); if (table.Rows.Count == 0) { return(null); } Compra_DS.CompraRow row = table[0]; Compra obj = new Compra() { CompraId = row.CompraId, Fecha = row.fecha, TotalPago = row.totalPago, TarjetaCredito = row.tarjetaCredito, CodigoTarjeta = row.codigoTarjeta, Estado = row.estado, UserId = row.UserId, PeliculaId = row.peliculaId }; return(obj); }
public static Compra GetCompraByID(int CompraId) { if (CompraId <= 0) { throw new ArgumentException("La CompraID debe ser mayor a 0"); } CompraTableAdapter adapter = new CompraTableAdapter(); Compra_DS.CompraDataTable table = adapter.GetCompraByID(CompraId); if (table.Rows.Count == 0) { return(null); } Compra_DS.CompraRow row = table[0]; Compra obj = new Compra(); obj.CompraId = row.CompraId; obj.Fecha = row.fecha; obj.TotalPago = row.totalPago; obj.TarjetaCredito = row.tarjetaCredito; obj.CodigoTarjeta = row.codigoTarjeta; obj.Estado = row.estado; obj.UserId = row.UserId; UserCLI userTemp = UserCLI_BRL.getUserById(row.UserId); obj.Email = userTemp.Email; obj.PeliculaId = row.peliculaId; Pelicula movieTemp = Pelicula_BRL.GetPeliculaByID(row.peliculaId); obj.NombrePelicula = movieTemp.Nombre; return(obj); }