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