/// <summary>
/// Erstellt ein neues TranslationText-Objekt.
/// </summary>
/// <param name="translationTextID">Anfangswert der Eigenschaft TranslationTextID.</param>
/// <param name="translationID">Anfangswert der Eigenschaft TranslationID.</param>
/// <param name="cultureID">Anfangswert der Eigenschaft CultureID.</param>
/// <param name="createdDate">Anfangswert der Eigenschaft CreatedDate.</param>
public static TranslationText CreateTranslationText(global::System.Int64 translationTextID, global::System.Int64 translationID, global::System.Int32 cultureID, global::System.DateTime createdDate)
{
TranslationText translationText = new TranslationText();
translationText.TranslationTextID = translationTextID;
translationText.TranslationID = translationID;
translationText.CultureID = cultureID;
translationText.CreatedDate = createdDate;
return(translationText);
}
/// <summary>
/// Erstellt ein neues TranslationText-Objekt.
/// </summary>
/// <param name="translationTextID">Anfangswert der Eigenschaft TranslationTextID.</param>
/// <param name="translationID">Anfangswert der Eigenschaft TranslationID.</param>
/// <param name="cultureID">Anfangswert der Eigenschaft CultureID.</param>
/// <param name="createdDate">Anfangswert der Eigenschaft CreatedDate.</param>
public static TranslationText CreateTranslationText(global::System.Int64 translationTextID, global::System.Int64 translationID, global::System.Int32 cultureID, global::System.DateTime createdDate)
{
TranslationText translationText = new TranslationText();
translationText.TranslationTextID = translationTextID;
translationText.TranslationID = translationID;
translationText.CultureID = cultureID;
translationText.CreatedDate = createdDate;
return translationText;
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'TranslationTexts'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToTranslationTexts(TranslationText translationText)
{
base.AddObject("TranslationTexts", translationText);
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'TranslationTexts'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToTranslationTexts(TranslationText translationText)
{
base.AddObject("TranslationTexts", translationText);
}
public void Store(VSSolution solution)
{
using (TranslationStorage store = new TranslationStorage(getConnectionString()))
{
foreach (var project in solution.Projects.Values)
{
foreach (var fileGroup in project.ResxGroups.Values)
{
foreach (var dataGroup in fileGroup.AllData.Values)
{
var existingTranslationTexts = new List <TranslationText>();
foreach (var data in dataGroup.ResxData.Values)
{
existingTranslationTexts.AddRange(store.FindTranslations(data.Value, data.ResxFile.Culture.Name));
}
if (existingTranslationTexts.Count == 0)
{
var t = new Translation();
foreach (var data in dataGroup.ResxData.Values)
{
var text = new TranslationText();
text.Text = data.Value;
text.Culture = GetCulture(data.ResxFile.Culture, store);
text.CreatedDate = DateTime.Now;
text.ModifiedDate = DateTime.Now;
t.Translations.Add(text);
}
store.Translations.AddObject(t);
store.SaveChanges();
}
else
{
var list = from transText in existingTranslationTexts
join data in dataGroup.ResxData.Values
on transText.Text.ToLowerInvariant() equals data.Value.ToLowerInvariant()
group transText by transText.Translation into translation
select new { Translation = translation.Key, Count = translation.Count() };
var topCandidate = list.OrderByDescending(t => t.Count)
.FirstOrDefault();
if (topCandidate != null)
{
var notExistingCultures = from data in dataGroup.ResxData
where (topCandidate.Translation.Translations.Where(t => t.Text == data.Value.Value)).Count() == 0
select data.Key;
//var notExistingCultures = (from c in dataGroup.ResxData.Keys select c)
// .Except(from cn in topCandidate.Translation.Translations select CultureInfo.GetCultureInfo(cn.Culture.CultureName));
if (notExistingCultures.Count() > 0)
{
foreach (var culture in notExistingCultures)
{
var text = new TranslationText();
text.Text = dataGroup.ResxData[culture].Value;
text.Culture = GetCulture(culture, store);
text.CreatedDate = DateTime.Now;
text.ModifiedDate = DateTime.Now;
topCandidate.Translation.Translations.Add(text);
}
store.SaveChanges();
}
}
}
}
}
}
}
}
public void Store(VSSolution solution)
{
using (TranslationStorage store = new TranslationStorage(getConnectionString()))
{
foreach (var project in solution.Projects.Values)
{
foreach (var fileGroup in project.ResxGroups.Values)
{
foreach (var dataGroup in fileGroup.AllData.Values)
{
var existingTranslationTexts = new List<TranslationText>();
foreach (var data in dataGroup.ResxData.Values)
{
existingTranslationTexts.AddRange(store.FindTranslations(data.Value, data.ResxFile.Culture.Name));
}
if (existingTranslationTexts.Count == 0)
{
var t = new Translation();
foreach (var data in dataGroup.ResxData.Values)
{
var text = new TranslationText();
text.Text = data.Value;
text.Culture = GetCulture(data.ResxFile.Culture, store);
text.CreatedDate = DateTime.Now;
text.ModifiedDate = DateTime.Now;
t.Translations.Add(text);
}
store.Translations.AddObject(t);
store.SaveChanges();
}
else
{
var list = from transText in existingTranslationTexts
join data in dataGroup.ResxData.Values
on transText.Text.ToLowerInvariant() equals data.Value.ToLowerInvariant()
group transText by transText.Translation into translation
select new { Translation = translation.Key, Count = translation.Count() };
var topCandidate = list.OrderByDescending(t => t.Count)
.FirstOrDefault();
if (topCandidate == null)
throw new Exception("TODO: Error");
var notExistingCultures = (from c in dataGroup.ResxData.Keys select c)
.Except(from cn in topCandidate.Translation.Translations select CultureInfo.GetCultureInfo(cn.Culture.CultureName));
foreach (var culture in notExistingCultures)
{
var text = new TranslationText();
text.Text = dataGroup.ResxData[culture].Value;
text.Culture = GetCulture(culture, store);
text.CreatedDate = DateTime.Now;
text.ModifiedDate = DateTime.Now;
topCandidate.Translation.Translations.Add(text);
}
store.SaveChanges();
}
}
}
}
}
}
