public string Update(DayOfRoute input)
{
return($@"
update {Table} set
Day = '{(int)input.Day}',
TurnoverId = '{input.TurnoverId}',
where id = {input.Id}
");
}
public async Task <DayOfRoute> Update(DayOfRoute input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(_sql.Update(input));
return(await ById(input.Id));
}
}
public async Task <DayOfRoute> Add(DayOfRoute input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var id = await conn.QueryFirstOrDefaultAsync <int>(_sql.Add(input));
return(await ById(id));
}
}
public string Add(DayOfRoute input)
{
return($@"
insert into {Table}
([Day], [TurnoverId])
values
('{(int)input.Day}', '{input.TurnoverId}')
SELECT SCOPE_IDENTITY()
");
}
