public string Add(StantionOnTrip input)
{
return($@"
insert into {Table} ([InTime], [OutTime], [StantionId], [TripId]) values('{input.InTime}', '{input.OutTime}', {input.StantionId}, {input.TripId})
SELECT SCOPE_IDENTITY()
");
}
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 <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 string Update(StantionOnTrip input)
{
return($@"
update {Table} set InTime = '{input.InTime}', OutTime = '{input.OutTime}', StantionId = {input.StantionId}, TripId = {input.TripId} where id = {input.Id}
");
}