public void Remove(Device device) { var model = DeviceModel.FromRepositoryType(device); var sql = @" DELETE FROM DeviceModels WHERE Id = @Id "; var parameters = new { Id = model.Id, }; _connection.Execute(sql, parameters); }
public void Add(Device device) { var model = DeviceModel.FromRepositoryType(device); var sql = @" INSERT INTO DeviceModels ( Address, IsConnected, LastPing, Name, Network_Id, Notes, Type_Name ) VALUES ( @Address, @IsConnected, @LastPing, @Name, @Network_Id, @Notes, @Type_Name ) SELECT CAST(IDENT_CURRENT('DeviceModels') as int) "; var parameters = new { Address = model.Address, IsConnected = model.IsConnected, LastPing = model.LastPing, Name = model.LastPing, Network_Id = model.Network_Id, Notes = model.Notes, Type_Name = model.Type_Name, }; var id = _connection.QuerySingle <int>(sql, parameters); device.SetId(id); }
public void Update(Device device) { var model = DeviceModel.FromRepositoryType(device); var sql = @" UPDATE DeviceModels SET Name = @Name, Notes = @Notes, Type_Name = @Type_Name WHERE Id = @Id "; var parameters = new { Id = model.Id, Name = model.Name, Notes = model.Notes, Type_Name = model.Type_Name, }; _connection.Execute(sql, parameters); }