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 }