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