public async Task <bool> InsertAsync(Genre item) { var genreId = await adoTemplate.ExecuteScalarAsync(@"INSERT INTO Genre(Titel) output inserted.GenreId VALUES(@GTitel)", new QueryParameter(@"@GTitel", item.Titel)); if (genreId != default) { item.GenreId = genreId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(CinemaHall item) { var cinemaHallId = await adoTemplate.ExecuteScalarAsync(@"INSERT INTO CinemaHall(Name, Archived) output inserted.CinemaHallId VALUES(@CName, @Archive)", new QueryParameter(@"CName", item.Name), new QueryParameter(@"Archive", item.Archived)); if (cinemaHallId != default) { item.CinemaHallId = cinemaHallId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(SeatCategory sc) { var seatCategoryId = await adoTemplate.ExecuteScalarAsync(@"INSERT INTO SeatCategory(CategoryName, Price) output inserted.SeatCategoryId VALUES(@CName, @Price)", new QueryParameter("@CName", sc.CategoryName), new QueryParameter("@Price", sc.Price)); if (seatCategoryId != default) { sc.SeatCategoryId = seatCategoryId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(Actor a) { var actorId = await adoTemplate.ExecuteScalarAsync( @"INSERT INTO Actor(Firstname, Lastname) output inserted.ActorId VALUES (@FName, @LName)", new QueryParameter("@FName", a.Firstname), new QueryParameter("@LName", a.Lastname)); if (actorId != default) { a.ActorId = actorId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(Schedule s) { var scheduleId = await adoTemplate.ExecuteScalarAsync(@"INSERT INTO Schedule(CinemaHallId, MovieId, StartTime) output inserted.ScheduleId VALUES(@CId, @MId, @ST)", new QueryParameter(@"@CId", s.CinemaHall.CinemaHallId), new QueryParameter(@"@MId", s.Movie.MovieId), new QueryParameter(@"@ST", s.StartTime)); if (scheduleId != default) { s.ScheduleId = scheduleId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(CinemaHall item, Row row) { //INSERT INTO ROW(SeatCategoryId, CinemaHallId) VALUES(@SCId, @CId) var rowId = await adoTemplate.ExecuteScalarAsync( @"INSERT INTO ROW(SeatCategoryId, CinemaHallId) output inserted.RowId VALUES(@SCId, @CId)", new QueryParameter("@SCId", row.SeatCategory.SeatCategoryId), new QueryParameter("@CId", item.CinemaHallId)); if (rowId != default) { row.RowId = rowId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(Reservation item) { var reservationId = await adoTemplate.ExecuteScalarAsync( "INSERT INTO Reservation(Seat_Row_CinemaHallId, Seat_RowId, SeatId, ScheduleId) output inserted.ReservationId VALUES(@SRCId, @SRId, @SId, @ScheId)", new QueryParameter(@"@SRCId", item.CinemaHall.CinemaHallId), new QueryParameter(@"@SRId", item.Row.RowId), new QueryParameter(@"@SId", item.Seat.SeatId), new QueryParameter(@"@ScheId", item.Schedule.ScheduleId)); if (reservationId != default) { item.ReservationId = reservationId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(CinemaHall item, Row row, Seat seat) { //INSERT INTO Seat(RowId, Row_CinemaHallId, CinemaHallId) VALUES(@RId, @RCId, @CId) var seatId = await adoTemplate.ExecuteScalarAsync( @"INSERT INTO Seat(RowId, Row_CinemaHallId, CinemaHallId) output inserted.SeatId VALUES(@RId, @RCId, @CId)", new QueryParameter("@RId", row.RowId), new QueryParameter("@RCId", item.CinemaHallId), new QueryParameter("@CId", item.CinemaHallId)); if (seatId != default) { seat.SeatId = seatId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }
public async Task <bool> InsertAsync(Movie item) { var movieId = await adoTemplate.ExecuteScalarAsync( @"INSERT INTO Movie(Titel, Description, Playtime, Poster, Link, Archived) output inserted.MovieId VALUES(@Titel, @Desc, @Playtime, @Poster, @Link, @Archived)", new QueryParameter("@Titel", item.Titel), new QueryParameter("@Desc", item.Description), new QueryParameter("@Playtime", item.Playtime), new QueryParameter("@Poster", item.Poster), new QueryParameter("@Link", item.Link), new QueryParameter("@Archived", item.Archived)); if (movieId != default) { item.MovieId = movieId; return(await Task.FromResult(true)); } return(await Task.FromResult(false)); }