public ImageInfoGet GetImage(string fileName, string mas)
{
ImageInfoGet tmp = new ImageInfoGet();
tmp.Path = fileName;
tmp.JpegCover = mas;
db = new Database.ApplicationContext();
foreach (var img in db.Images)
{
if (fileName == img.Path)
{
var mas1 = Convert.FromBase64String(mas);
IStructuralEquatable equ = mas1;
var masFromDB = img.Details.Image;
if (equ.Equals(masFromDB, EqualityComparer <object> .Default))
{
img.count++;
db.SaveChanges();
tmp.Name = img.Name;
tmp.Class = img.ClassName;
tmp.Confidence = img.Confidence;
return(tmp);
}
}
}
return(null);
}
public void ClearDB()
{
db = new Database.ApplicationContext();
db.Images.RemoveRange(db.Images);
db.SaveChanges();
}
public void AddToDB(ImageInfoGet imageInfo)
{
db = new Database.ApplicationContext();
Database.ImageDetails imageDetails = new Database.ImageDetails {
Image = Convert.FromBase64String(imageInfo.JpegCover)
};
db.Images.Add(new Database.ImageData {
Path = imageInfo.Path, Name = imageInfo.Name, ClassName = imageInfo.Class, Confidence = imageInfo.Confidence, Details = imageDetails
});
db.SaveChanges();
}
public List <string> GetStatistics()
{
List <string> result = new List <string>();
db = new Database.ApplicationContext();
var q = from img in db.Images select img;
foreach (var img in q)
{
string res = "";
res += img.Path + "; Number of requests: " + img.count;
result.Add(res);
}
return(result);
}
public List <ImgNames> GetImages(string name)
{
List <ImgNames> result = new List <ImgNames>();
db = new Database.ApplicationContext();
foreach (var img in db.Images)
{
if (img.ClassName == name)
{
var tmp = new ImgNames();
tmp.Name = img.Path;
tmp.Image = Convert.ToBase64String(img.Details.Image);
result.Add(tmp);
}
}
return(result);
}
public List <ClassNames> GetClasses()
{
List <ClassNames> result = new List <ClassNames>();
db = new Database.ApplicationContext();
var q = db.Images.ToArray().GroupBy(img => img.ClassName);
foreach (var g in q)
{
int count = 0;
foreach (var img in g)
{
count++;
}
var tmp = new ClassNames();
tmp.ClassName = g.Key;
tmp.Count = count.ToString();
result.Add(tmp);
}
return(result);
}