public List <Measurement> SelectMeasurements()
{
List <MeasurementEntity> measurementEntities = DatabaseConnection.Table <MeasurementEntity>().ToList();
List <Measurement> measurements = new List <Measurement>();
foreach (MeasurementEntity measurementEntity in measurementEntities)
{
InstallationEntity installationEntity = DatabaseConnection.Get <InstallationEntity>(measurementEntity.InstallationID);
Installation installation = new Installation(installationEntity);
MeasurementItemEntity measurementItemEntity = DatabaseConnection.Get <MeasurementItemEntity>(measurementEntity.CurrentID);
var valuesArray = JArray.Parse(measurementItemEntity.Values);
var indexesArray = JArray.Parse(measurementItemEntity.Indexes);
var standardsArray = JArray.Parse(measurementItemEntity.Standards);
var valueIDs = ParseJSONToIntArray(valuesArray, "Id");
var indexIDs = ParseJSONToIntArray(indexesArray, "Id");
var standardIDs = ParseJSONToIntArray(standardsArray, "Id");
var measurementValues = DatabaseConnection.Table <ParameterValue>().Where(x => valueIDs.Contains(x.Id)).ToList();
var measurementIndexes = DatabaseConnection.Table <Index>().Where(x => indexIDs.Contains(x.Id)).ToList();
var measurementStandards = DatabaseConnection.Table <Standard>().Where(x => standardIDs.Contains(x.Id)).ToList();
MeasurementItem measurementItem = new MeasurementItem(measurementItemEntity, measurementValues, measurementIndexes, measurementStandards);
Measurement measurement = new Measurement(measurementEntity, installation, measurementItem);
measurements.Add(measurement);
}
return(measurements);
}
// TODO log
public Option <InstallationDomain> TrySave(InstallationDomain domain)
{
if (!_installationDao.ExistsByExternalId(domain.ExternalId))
{
InstallationEntity entity = _installationDao.Save(InstallationEntity.FromDomain(domain));
return(Option <InstallationDomain> .Of(entity.ToDomain()));
}
return(Option <InstallationDomain> .Empty <InstallationDomain>());
}
/// <summary>
/// Get Settings from Setting table
/// </summary>
/// <returns>list with available installations</returns>
/// /// Method Revision History
///
/// Author Date Description
/// ---------------------------------------------------
/// Anuradha 05-Feb-2009 Intial Version
///
public static InstallationEntity[] GetInstallations()
{
InstallationEntity[] clsInstallation = null;
DataTable dtInstallations = null;
int iCount = 0;
try
{
// lInstallations = new List<int>();
//Get available installations.
dtInstallations = SqlHelper.ExecuteDataset(GetConnectionString(), CommandType.StoredProcedure,
DBConstants.RSP_GETINSTALLATIONDETAILS).Tables[0];
if (dtInstallations != null)
{
clsInstallation = new InstallationEntity[dtInstallations.Rows.Count];
//Add the installation no to the list.
foreach (DataRow row in dtInstallations.Rows)
{
clsInstallation[iCount] = new InstallationEntity();
clsInstallation[iCount].InstallationNumber = Convert.ToInt32(row["Installation_No"].ToString());
clsInstallation[iCount].BarPositionName = row["Bar_Pos_Name"].ToString();
clsInstallation[iCount].BarPositionMachineEnabled = row["BarPositionMachineEnabled"].ToString();
clsInstallation[iCount].DataPakNumber = int.Parse(row["Datapak_Serial"].ToString());
clsInstallation[iCount].BarPositionNo = int.Parse(row["Bar_Pos_No"].ToString());
iCount++;
}
}
//Get the site code.
string SiteCode = SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.Text,
"Select code from site").ToString();
if (!String.IsNullOrEmpty(SiteCode))
{
for (int k = 0; k < clsInstallation.Length; k++)
{
clsInstallation[k].SiteCode = SiteCode;
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
finally
{
if (dtInstallations != null)
{
dtInstallations.Dispose();
}
}
return(clsInstallation);
}
public static Installation ToInstallation(this InstallationEntity installationEntity)
{
return(new Installation()
{
Id = installationEntity.Id,
Location = JsonConvert.DeserializeObject <Coordinates>(installationEntity.LocationString),
Address = JsonConvert.DeserializeObject <Address>(installationEntity.AddressString),
Elevation = installationEntity.Elevation,
IsAirlyInstallation = installationEntity.IsAirlyInstallation,
});
}
public bool DeleteById(long id)
{
InstallationEntity installation = FindById(id);
if (installation == null)
{
return(false);
}
_db.Installations.Remove(installation);
_db.SaveChanges();
return(true);
}
public void InsertInstallations(IEnumerable <Installation> installations)
{
if (installations == null)
{
return;
}
List <InstallationEntity> installationEntities = new List <InstallationEntity>();
foreach (Installation installation in installations)
{
InstallationEntity installationEntity = new InstallationEntity(installation);
installationEntities.Add(installationEntity);
}
DatabaseConnection.RunInTransaction(() =>
{
DatabaseConnection.DeleteAll <InstallationEntity>();
DatabaseConnection.InsertAll(installationEntities);
});
}
public async Task SaveInstalations(List <Installation> installations)
{
var objList = new List <InstallationEntity>();
foreach (var item in installations)
{
var installationEntity = new InstallationEntity
{
Address = JsonConvert.SerializeObject(item.Address),
Elevation = item.Elevation,
IsAirlyInstallation = item.IsAirlyInstallation,
Sponsor = JsonConvert.SerializeObject(item.Sponsor),
Measurement = JsonConvert.SerializeObject(item.Measurement)
};
objList.Add(installationEntity);
}
await _db.RunInTransactionAsync(t =>
{
t.DeleteAll <InstallationEntity>();
t.InsertAll(objList, false);
});
}
// TODO log
public InstallationDomain Save(InstallationDomain installation)
{
InstallationEntity entity = _installationDao.Save(InstallationEntity.FromDomain(installation));
return(entity.ToDomain());
}
public InstallationEntity Save(InstallationEntity installation)
{
_db.Installations.Add(installation);
_db.SaveChanges();
return(installation); // TODO verify id exists on saved entity
}
