public static string GetSingleTranslation(string EnglishTagalogText)
{
EnglishTagalogText = Utils.CleanUpText(EnglishTagalogText);
using var context = new TagalogHelperContext();
var englishData = context.Translations.Where(x => x.EnglishText == EnglishTagalogText).ToList();
foreach (var translation in englishData)
{
if (translation.EnglishText == EnglishTagalogText)
{
return(translation.TagalogText + " [English to Tagalog Detected]");
}
}
var tagalogData = context.Translations.Where(x => x.TagalogText == EnglishTagalogText).ToList();
foreach (var translation in tagalogData)
{
if (translation.TagalogText == EnglishTagalogText)
{
return(translation.EnglishText + " [Tagalog to English Detected]");
}
}
return("No translation found.");
}
public static void ResetData()
{
using var context = new TagalogHelperContext();
if (context.Translations.Any())
{
var data = context.Translations.ToList();
foreach (var translation in data)
{
context.Translations.Remove(translation);
}
context.SaveChanges();
}
}
public static void GetAll()
{
using var context = new TagalogHelperContext();
if (context.Translations.Any())
{
var data = context.Translations.ToList();
foreach (var translation in data)
{
Console.WriteLine(translation.TagalogText);
}
}
else
{
Console.WriteLine("No translations found");
}
}
public static bool LoadData()
{
ResetData();
string path =
Assembly.GetExecutingAssembly().Location.Replace("TagalogHelper.Domain.dll", "") +
@"\Data\TranslationData.txt";
System.IO.StreamReader file =
new System.IO.StreamReader(path);
string line;
TranslationTable data;
using var context = new TagalogHelperContext();
while ((line = file.ReadLine()) != null)
{
string[] columnData = line.Split(';');
try
{
data = new TranslationTable
{
EnglishText = columnData[1].ToUpper(),
TagalogText = Utils.CleanUpText(columnData[2].ToUpper())
};
switch (columnData[0])
{
case "0":
data.TranslationGroupTypeId = TranslationTypes.Fragments;
break;
case "1":
data.TranslationGroupTypeId = TranslationTypes.Greetings;
break;
case "2":
data.TranslationGroupTypeId = TranslationTypes.Goodbyes;
break;
case "3":
data.TranslationGroupTypeId = TranslationTypes.Food;
break;
case "4":
data.TranslationGroupTypeId = TranslationTypes.Romantic;
break;
case "5":
data.TranslationGroupTypeId = TranslationTypes.GeneralQuestions;
break;
case "6":
data.TranslationGroupTypeId = TranslationTypes.Financial;
break;
case "7":
data.TranslationGroupTypeId = TranslationTypes.Numbers;
break;
case "99":
data.TranslationGroupTypeId = TranslationTypes.Other;
break;
}
var entity = context.Translations.Add(data);
entity.State = EntityState.Added;
}
catch
{
Console.Write("Unable to read line: [" + line + "]");
return(false);
}
}
context.SaveChanges();
return(true);
}