public static List <Item> ConvertToList(DataTable dt) { var items = new List <Item>(); var rowIndex = 0; rowIndex++; // pass headers foreach (DataRow row in dt.Rows) { rowIndex++; var trValues = (row["MessageText"] + "").Trim(); if (string.IsNullOrWhiteSpace(trValues)) { continue; } var en = GoogleTranslator.TranslateTurkishToEnglish(trValues); if (string.IsNullOrWhiteSpace(en)) { continue; } var propName = GoogleTranslator.CreatePropertyNameFromSentence(en); items.Add(new Item { NameTR = trValues, ExcelRowIndex = rowIndex, NameEN = propName }); } return(items); }
static string TranslateTurkishToEnglish(string turkishText) { string english = null; if (TR_EN_Cache.TryGetValue(turkishText, out english)) { return(english); } english = GoogleTranslator.TranslateTurkishToEnglish(turkishText); TR_EN_Cache[turkishText] = english; return(english); }