public bool Import(string file, Guid solutionId, LanguageCode baseLanguageId)
{
var data = new DataTable();// _dataImporter.ExcelToDataTable(file);
var languages = _languageService.Query(n => n.Sort(s => s.SortAscending(f => f.Name)));
foreach (DataRow row in data.Rows)
{
var objectId = Guid.Parse(row[0].ToString());
var name = row[1].ToString();
var typeCode = int.Parse(row[2].ToString());
foreach (var lg in languages)
{
if (data.Columns.Contains(lg.UniqueId.ToString()))
{
var label = row[lg.UniqueId.ToString()] != null ? row[lg.UniqueId.ToString()].ToString() : string.Empty;
var originalLabel = _localizedLabelService.Find(n => n.ObjectId == objectId && n.ObjectColumnName == name && (int)n.LanguageId == lg.UniqueId);
if (originalLabel != null)
{
if (label.IsEmpty())
{
_localizedLabelService.DeleteById(originalLabel.LocalizedLabelId);
}
else if (!label.IsCaseInsensitiveEqual(originalLabel.Label))
{
originalLabel.Label = label;
_localizedLabelService.Update(originalLabel);
}
}
else if (label.IsNotEmpty())
{
_localizedLabelService.Create(solutionId, label, typeCode.ToString(), name, objectId, (LanguageCode)Enum.Parse(typeof(LanguageCode), lg.UniqueId.ToString()));
}
}
}
}
return(true);
}
