public int GetImageFilesCount()
{
using (var db = new ResultDBContext())
{
return((from imageFile in db.imageFiles select imageFile).Count());
}
}
public ImageFile InsertImageFile(ImageFile imageFile)
{
using (var db = new ResultDBContext())
{
db.imageFiles.InsertOnSubmit(imageFile);
db.SubmitChanges();
}
return(imageFile);
}
public ImageInfo InsertImageInfo(ImageInfo imageInfo)
{
using (var db = new ResultDBContext())
{
db.imageInfos.InsertOnSubmit(imageInfo);
db.SubmitChanges();
}
return(imageInfo);
}
public bool DatabaseExists()
{
try
{
using (var db = new ResultDBContext())
{
return(db.DatabaseExists());
}
}
catch (Exception)
{
throw new Exception("No Connection to the Source Database.");
}
}
public void RunSQLScript(string SQLScriptName)
{
string sqlScript = null;
if (SQLScriptName.ToLower().Equals("reset"))
{
//To Do: This scripts need to be relative, but for now its local..
sqlScript = File.ReadAllText(@"C:\Users\Chris\Source\Repos\UCN-4-Semester-Project---Group-7\TrashDetector\ResultDatabase\Scripts\Reset.sql");
}
if (sqlScript != null)
{
using (var db = new ResultDBContext())
{
db.ExecuteCommand(sqlScript);
}
}
}