internal void StoreHeatmapPoints(IEnumerable <PictureDTO> pictures, FilterResultDTO.CaracteristicType filterType)
{
ApplicationDbContext db = new ApplicationDbContext();
foreach (var picture in pictures.GroupBy(x => x.panoID).Select(g => g.First()).ToList())
{
var lat = picture.location.lat.ToString(CultureInfo.InvariantCulture);
var lon = picture.location.lng.ToString(CultureInfo.InvariantCulture);
var geo = DbGeography.PointFromText(string.Format("POINT({0} {1})", lon, lat), 4326);
var density = (float?)(picture.filterResults.FirstOrDefault(r => r.Type == filterType).Density);
var newPoint = new HeatmapPointModel()
{
ID = picture.panoID,
coordinates = geo,
TreesDensity = filterType == FilterResultDTO.CaracteristicType.Trees ? density : null,
CracksDensity = filterType == FilterResultDTO.CaracteristicType.Cracks ? density : null
};
var oldPoint = db.HeatmapPointModel.FirstOrDefault(p => p.ID == newPoint.ID);
if (oldPoint != null)
{
oldPoint.TreesDensity = newPoint.TreesDensity ?? oldPoint.TreesDensity;
oldPoint.CracksDensity = newPoint.CracksDensity ?? oldPoint.TreesDensity;
db.Entry <HeatmapPointModel>(oldPoint).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.HeatmapPointModel.Add(newPoint);
}
}
db.SaveChanges();
db.Dispose();
}
public void detectFeatureInSequence(ref IEnumerable <PictureDTO> pictures, FilterResultDTO.CaracteristicType filterType)
{
var filter = ImageFilters.FirstOrDefault(p => p.FilterType.Equals(filterType));
if (filter == null)
{
return;
}
foreach (var picture in pictures)
{
var pictureBitmap = picture.getImage();
var img = new Image <Bgr, byte>(pictureBitmap);
var result = filter.filterImage(img);
picture.filterResults.Add(result);
img.Dispose();
pictureBitmap.Dispose();
}
}
internal void detectFeatureInPictureDTO(ref PictureDTO picture, FilterResultDTO.CaracteristicType filterType)
{
var filter = ImageFilters.FirstOrDefault(p => p.FilterType.Equals(filterType));
if (filter == null)
{
return;
}
var pictureBitmap = picture.getImage();
var img = new Image <Bgr, byte>(pictureBitmap);
var result = filter.filterImage(img);
result.imageID = picture.imageID;
result.panoID = picture.panoID;
if (picture.filterResults == null)
{
picture.filterResults = new List <FilterResultDTO>();
}
picture.filterResults.Add(result);
img.Dispose();
pictureBitmap.Dispose();
}
internal void detectFeatureInGSSequence(ref IEnumerable <PictureDTO> pictures, FilterResultDTO.CaracteristicType filterType)
{
var filter = ImageFilters.FirstOrDefault(p => p.FilterType.Equals(filterType));
if (filter == null)
{
return;
}
//SQL_GIS_T1Entities gist1 = new SQL_GIS_T1Entities();
foreach (var picture in pictures)
{
var pictureBitmap = picture.getImage();
var img = new Image <Bgr, byte>(pictureBitmap);
var result = filter.filterImage(img);
result.imageID = picture.imageID;
result.panoID = picture.panoID;
if (picture.filterResults == null)
{
picture.filterResults = new List <FilterResultDTO>();
}
picture.filterResults.Add(result);
//var lat = picture.location.lat.ToString(CultureInfo.InvariantCulture);
//var lon = picture.location.lng.ToString(CultureInfo.InvariantCulture);
//var geo = DbGeography.PointFromText(string.Format("POINT({0} {1})", lon, lat), 4326);
//var newPoint = new Point()
//{
// idNode = picture.panoID,
// coordinate = geo,
// treesDensity = filterType == FilterResultDTO.CaracteristicType.Trees ? result.Density : null,
// cracksDensity = filterType == FilterResultDTO.CaracteristicType.Cracks ? result.Density : null
//};
//var oldPoint = gist1.Point.FirstOrDefault(p => p.idNode == newPoint.idNode);
//if (oldPoint != null)
//{
// oldPoint.treesDensity = newPoint.treesDensity ?? oldPoint.treesDensity;
// oldPoint.cracksDensity = newPoint.cracksDensity ?? oldPoint.treesDensity;
// gist1.Entry<Point>(oldPoint).State = System.Data.Entity.EntityState.Modified;
//}
//else
//{
// gist1.Point.Add(newPoint);
//}
img.Dispose();
pictureBitmap.Dispose();
}
//gist1.SaveChanges();
//gist1.Dispose();
}
internal IEnumerable <PictureDTO> detectFeatureInGSSequence(IEnumerable <GSPicture> gspictures, FilterResultDTO.CaracteristicType filterType)
{
var pictures = gspictures.Select(p => new PictureDTO(p));
detectFeatureInGSSequence(ref pictures, filterType);
return(pictures);
}
