public Task CreateGroupAsync(RoomItemGroup group) { const string sql = "INSERT INTO option_groups " + "(id, name, roomId, createdBy, createdDate) VALUES " + "(@id, @name, @roomId, @createdBy, @createdDate)"; return(ExecuteAsync(sql, group)); }
public Task UpdateGroupAsync(RoomItemGroup group) { const string sql = "UPDATE option_groups SET name = @name WHERE id = @id"; return(ExecuteAsync(sql, group)); }