BuildingScore IBuildingScoreRepository.Update(BuildingScore buildingScore)
{
var buildingscorechanges = _appDbContext.BuildingScores.Attach(buildingScore);
buildingscorechanges.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_appDbContext.SaveChanges();
return(buildingScore);
}
BuildingScore IBuildingScoreRepository.Delete(Guid facilityId)
{
BuildingScore buildingScore = _appDbContext.BuildingScores.Find(facilityId);
if (buildingScore != null)
{
_appDbContext.BuildingScores.Remove(buildingScore);
_appDbContext.SaveChanges();
}
return(buildingScore);
}
public async Task <IEnumerable <BuildingScore> > GetBuildingScores()
{
// Input query commands, support multiple
var queries = new[]
{
" SELECT * FROM BuildingScores WHERE time> now() - 24h "
};
var dbName = "db_score";
// Query data from a specified library
var response = await clientDb.Client.QueryAsync(queries, dbName);
//Get the Serie collection object(returning the results of executing multiple queries)
var series = response.ToList();
// The query result of the first command is a collection.
var list = series[0].Values;
List <BuildingScore> listScore = new List <BuildingScore>();
BuildingScore objScore = null;
// Extract the first data from the collection
foreach (var obj in list)
{
objScore = new BuildingScore();
string updatedobj2 = obj[2].ToString().Replace("\"", "");
objScore.FacilityId = new Guid(updatedobj2);
string updatedobj4 = obj[4].ToString().Replace("\"", "");
objScore.SiteId = new Guid(updatedobj4);
string updatedobj5 = obj[5].ToString().Replace("\"", "");
objScore.ZoneId = new Guid(updatedobj5);
objScore.MyPrSiteNameoperty = obj[3].ToString().Replace("\"", "");
listScore.Add(objScore);
}
return(listScore);
}
public void Put([FromBody] BuildingScore buildingScore)
{
_buildingScoreService.Update(buildingScore);
}
public void Post([FromBody] BuildingScore buildingScore)
{
_buildingScoreService.Add(buildingScore);
}
BuildingScore IBuildingScoreService.Update(BuildingScore buildingScore)
{
return(_BuildingScoreRepository.Update(buildingScore));
}
BuildingScore IBuildingScoreService.Add(BuildingScore buildingScore)
{
return(_BuildingScoreRepository.Add(buildingScore));
}
BuildingScore IBuildingScoreRepository.Add(BuildingScore buildingScore)
{
this._appDbContext.BuildingScores.Add(buildingScore);
_appDbContext.SaveChanges();
return(buildingScore);
}
public BuildingScore Update(BuildingScore buildingScore)
{
throw new NotImplementedException();
}
