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); }