public void SortFilesInStageDBData()
{
StageDB stageDB = new StageDB();
List <ImageInfo> imageInfos = new List <ImageInfo>();
imageInfos = stageDB.GetAllImageInfos();
FileMover fileMover = new FileMover();
decimal isCigDecider = new decimal(0.70);
decimal isNonCigDecider = new decimal(0.70);
foreach (ImageInfo imageInfo in imageInfos)
{
//{ LessThan = -1, Equals = 0, GreaterThan = 1 }
if (Decimal.Compare(imageInfo.IsCig, isCigDecider) == 1 || Decimal.Compare(imageInfo.IsCig, isCigDecider) == 0)
{
ImageFile imageFile = stageDB.GetImageFile(imageInfo.ImageFileID);
fileMover.MoveImageFile(imageFile, @"C:\TrashDetector\Data\StageDBData\cigarettes\");
imageFile.FilePath = @"C:\TrashDetector\Data\StageDBData\cigarettes\" + imageFile.FileName;
stageDB.UpdateImageFilePath(imageFile);
}
else if (Decimal.Compare(imageInfo.IsNotCig, isNonCigDecider) == 1 || Decimal.Compare(imageInfo.IsCig, isNonCigDecider) == 0)
{
ImageFile imageFile = stageDB.GetImageFile(imageInfo.ImageFileID);
fileMover.MoveImageFile(imageFile, @"C:\TrashDetector\Data\StageDBData\non_cigarettes\");
imageFile.FilePath = @"C:\TrashDetector\Data\StageDBData\non_cigarettes\" + imageFile.FileName;
stageDB.UpdateImageFilePath(imageFile);
}
else
{
ImageFile imageFile = stageDB.GetImageFile(imageInfo.ImageFileID);
fileMover.MoveImageFile(imageFile, @"C:\TrashDetector\Data\StageDBData\uncertain\");
imageFile.FilePath = @"C:\TrashDetector\Data\StageDBData\uncertain\" + imageFile.FileName;
stageDB.UpdateImageFilePath(imageFile);
}
}
}
public void LoadDataFromStageDBtoResultDB()
{
List <ImageFile> imageFiles = new List <ImageFile>();
List <ImageInfo> imageInfos = new List <ImageInfo>();
StageDB stageDB = new StageDB();
ResultDB resultDB = new ResultDB();
imageFiles = stageDB.GetAllImageFiles();
imageInfos = stageDB.GetAllImageInfos();
foreach (ImageFile imageFile in imageFiles)
{
imageFile.FilePath.Replace("StageDBData", "ResultDBData");
resultDB.InsertImageFile(imageFile);
}
foreach (ImageInfo imageInfo in imageInfos)
{
resultDB.InsertImageInfo(imageInfo);
}
}