public int InsertTranslationHistory(int source, int target, string textToTranslate, string translatedText, string notes, int textToTranslateID)
{
try
{
connection = new SQLiteConnection(dbPath, false);
if (textToTranslateID == 0)
{
var TextToTranslate = new TextToTranslate()
{
Text1 = textToTranslate
};
connection.Insert(TextToTranslate);
textToTranslateID = TextToTranslate.TextToTranslateID;
}
var TranslatedText = new TranslatedText()
{
Text2 = translatedText
};
connection.Insert(TranslatedText);
var TranslatedTextID = TranslatedText.TranslatedTextID;
var translationHistory = new TextTranslation()
{
Source = source,
Target = target,
TextToTranslate = textToTranslateID,
TranslatedText = TranslatedTextID,
DateCreated = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
Notes = notes
};
var translationHistoryID = connection.Insert(translationHistory);
if (translationHistoryID < 1)
{
Logger.Log("Could not insert History in DB");
}
return(translationHistory.ID);
}
catch (Exception ex)
{
Logger.Log(ex.ToString());
}
finally
{
connection.Close();
}
return(1);
}
public void AddDetectedTextToImage(int ImageID, string DetectedText)
{
try
{
var TextDetected = 0;
string query;
connection = new SQLiteConnection(dbPath, false);
if (!String.IsNullOrEmpty(DetectedText))
{
TextDetected = 1;
//Add Detected text into TextToTranslate
TextToTranslate dText = new TextToTranslate();
dText.Text1 = DetectedText;
connection.Insert(dText);
query = "UPDATE CapturedImages SET TextDetected = " + TextDetected + ", TextToTransID = " + dText.TextToTranslateID + ", DateTextDetected = '" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "' WHERE CapturedImagesID = " + ImageID;
}
else
{
query = "UPDATE CapturedImages SET TextDetected = " + TextDetected + ", DateTextDetected = '" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "' WHERE CapturedImagesID = " + ImageID;
}
int result = connection.Execute(query);
if (result != 1)
{
Logger.Log("Could not Add detected Text to Image with ID " + ImageID);
}
}
catch (Exception ex)
{
Logger.Log(ex.ToString());
}
finally
{
connection.Close();
}
}