public async Task AddAsync(int clientId, MeasurementEntity weight)
{
var client = await _clientRepository.GetAsync(clientId);
client.WeightMeasurements.Add(weight);
_context.SaveChanges();
}
public void InsertMeasurements(IEnumerable <Measurement> measurements)
{
if (measurements == null)
{
return;
}
DatabaseConnection.RunInTransaction(() =>
{
DatabaseConnection.DeleteAll <MeasurementEntity>();
DatabaseConnection.DeleteAll <MeasurementItemEntity>();
DatabaseConnection.DeleteAll <ParameterValue>();
DatabaseConnection.DeleteAll <Index>();
DatabaseConnection.DeleteAll <Standard>();
foreach (Measurement measurement in measurements)
{
DatabaseConnection.InsertAll(measurement.Current.Values, false);
DatabaseConnection.InsertAll(measurement.Current.Indexes, false);
DatabaseConnection.InsertAll(measurement.Current.Standards, false);
MeasurementItemEntity measurementItemEntity = new MeasurementItemEntity(measurement);
DatabaseConnection.Insert(measurementItemEntity);
MeasurementEntity measurementEntity = new MeasurementEntity(measurement, measurementItemEntity);
DatabaseConnection.Insert(measurementEntity);
}
});
}
public async Task SaveMeasurements(List <Measurement> measurements)
{
await _db.RunInTransactionAsync(t =>
{
t.DeleteAll <MeasurementEntity>();
t.DeleteAll <MeasurementItemEntity>();
t.DeleteAll <MeasurementValue>();
t.DeleteAll <AirQualityIndex>();
t.DeleteAll <AirQualityStandard>();
foreach (var item in measurements)
{
t.InsertAll(item.Current.Values, false);
t.InsertAll(item.Current.Indexes, false);
t.InsertAll(item.Current.Standards, false);
var obj = new MeasurementItemEntity
{
FromDateTime = item.Current.FromDateTime,
TillDateTime = item.Current.TillDateTime,
Indexes = JsonConvert.SerializeObject(item.Current.Indexes),
Standards = JsonConvert.SerializeObject(item.Current.Standards),
Values = JsonConvert.SerializeObject(item.Current.Values)
};
t.Insert(obj);
var measurementEntity = new MeasurementEntity {
CurrentId = obj.Id
};
t.Insert(measurementEntity);
}
});
}
public bool DeleteById(long id)
{
MeasurementEntity entity = FindById(id);
if (entity == null)
{
return(false);
}
_db.Measurements.Remove(entity);
_db.SaveChanges();
return(true);
}
public void AddMeasurementsToDatabase(IEnumerable <Measurement> measurements)
{
try
{
foreach (var measurement in measurements)
{
var tempCurrent = new MeasurementItemEntity(measurement.Current);
CurrentDbConnection.Insert(tempCurrent);
var tempMeasurement = new MeasurementEntity(measurement);
tempMeasurement.CurrentId = tempCurrent.Id;
CurrentDbConnection.Insert(tempMeasurement);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
public void SaveMeasurements(IEnumerable <Measurement> measurements)
{
db.DeleteAll <MeasurementValue>();
db.DeleteAll <AirQualityIndex>();
db.DeleteAll <AirQualityStandard>();
db.DeleteAll <MeasurementItemEntity>();
db.DeleteAll <MeasurementEntity>();
foreach (var measurement in measurements)
{
db.InsertAll(measurement.Current.Values);
db.InsertAll(measurement.Current.Indexes);
db.InsertAll(measurement.Current.Standards);
var measurementItemEntity = new MeasurementItemEntity(measurement.Current);
db.Insert(measurementItemEntity);
var measurementEntity = new MeasurementEntity(measurementItemEntity.Id, measurement.Installation.Id);
db.Insert(measurementEntity);
}
}
public MeasurementEntity Save(MeasurementEntity measurement)
{
_db.Measurements.Add(measurement);
_db.SaveChanges();
return(measurement);
}
public MeasurementDomain Save(MeasurementDomain domain) => _measurementDao.Save(MeasurementEntity.FromDomain(domain)).ToDomain();
public void SaveMeasurements(IEnumerable <Measurement> measurements)
{
_connection?.RunInTransaction(() =>
{
_connection?.DeleteAll <MeasurementValue>();
_connection?.DeleteAll <AirQualityIndex>();
_connection?.DeleteAll <AirQualityStandard>();
_connection?.DeleteAll <MeasurementItemEntity>();
_connection?.DeleteAll <MeasurementEntity>();
foreach (var measurement in measurements)
{
_connection?.InsertAll(measurement.Current.Values, false);
_connection?.InsertAll(measurement.Current.Indexes, false);
_connection?.InsertAll(measurement.Current.Standards, false);
var measurementItemEntity = new MeasurementItemEntity(measurement.Current);
_connection?.Insert(measurementItemEntity);
var measurementEntity =
new MeasurementEntity(measurementItemEntity.Id, measurement.Installation.Id);
_connection?.Insert(measurementEntity);
}
});
}
