public void Delete(DataContracts.Device entity) { string query = string.Format("DELETE FROM DEVICE WHERE id={0};", entity.ID); using (SqlCommand cmd = AccessBD.Connection.CreateCommand()) { cmd.CommandText = query; cmd.ExecuteNonQuery(); } }
public void Insert(DataContracts.Device entity) { string query = string.Format("INSERT INTO DEVICE(type, uniqueIdentifier, userId) VALUES('{0}', '{1}', '{2}');", entity.type, entity.uniqueIdentifier, entity.userId); using (SqlCommand cmd = AccessBD.Connection.CreateCommand()) { cmd.CommandText = query; cmd.ExecuteNonQuery(); } }
public void Update(DataContracts.Device entity) { Device dev = _source.First(o => o.ID == entity.ID); if (dev != null) { dev.type = entity.type; dev.uniqueIdentifier = entity.uniqueIdentifier; dev.userId = entity.userId; } }
public void Update(DataContracts.Device entity) { string query = string.Format("UPDATE DEVICE SET type='{1}', uniqueIdentifier='{2}', userId={3} WHERE id={0};", entity.ID, entity.type, entity.uniqueIdentifier, entity.userId); using (SqlCommand cmd = AccessBD.Connection.CreateCommand()) { cmd.CommandText = query; cmd.ExecuteNonQuery(); } }
public void Update(DataContracts.Device device) { _repo.Update(device); }
private List<Device> MapDEVICE(IDataReader dataReader) { List<Device> list = new List<Device>(); while (dataReader.Read()) { Device device = new Device() { ID = Tools.ChangeType<int>(dataReader["id"]), type = Tools.ChangeType<string>(dataReader["type"]), uniqueIdentifier = Tools.ChangeType<string>(dataReader["uniqueIdentifier"]), userId = Tools.ChangeType<int>(dataReader["userId"]) }; list.Add(device); } return list; }
public void Delete(DataContracts.Device entity) { _source.RemoveAll(o => o.ID == entity.ID); }
public void Insert(DataContracts.Device entity) { _source.Add(entity); }
public void Insert(Device entity) { _repo.Insert(entity); }
public void Delete(Device entity) { _repo.Delete(entity); }