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