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