public async void Delete(int id)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new StantionOnTripsSql();
await conn.ExecuteAsync(sql.Delete(id));
}
}
public async Task <StantionOnTrip> ById(int id)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new StantionOnTripsSql();
return(await conn.QueryFirstOrDefaultAsync <StantionOnTrip>(sql.ById(id)));
}
}
public async Task <StantionOnTrip> Add(StantionOnTrip input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new StantionOnTripsSql();
var id = await conn.QueryFirstOrDefaultAsync <int>(sql.Add(input));
return(await ById(id));
}
}
public async Task <StantionOnTrip> Update(StantionOnTrip input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new StantionOnTripsSql();
await conn.ExecuteAsync(sql.Update(input));
return(await ById(input.Id));
}
}
public async Task <List <StantionOnTrip> > ByTripId(int tripId)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new StantionOnTripsSql();
var result = await conn.QueryAsync <StantionOnTrip>(sql.StationsOnTripByTripId(tripId));
return(result.ToList());
}
}
