private void Import(string file, TranslateSet set, TranslateCategory category, Language language)
{
var xmlText = System.IO.File.ReadAllText(file);
var xml = XElement.Parse(xmlText);
foreach (var data in xml.Descendants("data"))
{
string key = data.Attribute("name").Value;
string value = data.Descendants("value").Single().Value;
var translateKey = set.TranslateKeys.Where(x => x.Label == key && x.Set == set).SingleOrDefault();
if (translateKey == null)
{
translateKey = new TranslateKey
{
Label = key,
Set = set,
Category = category
};
set.TranslateKeys.Add(translateKey);
}
var translation = new Translation() { Key = translateKey, Language = language, Translator = null, Value = value };
DbSession.Save(translateKey);
DbSession.Save(translation);
}
Global.CurrentSession.Update(set);
}
private void Import(string file, TranslateSet set, TranslateCategory category, Language language)
{
var xmlText = System.IO.File.ReadAllText(file);
var xml = XElement.Parse(xmlText);
foreach (var data in xml.Descendants("data"))
{
string key = data.Attribute("name").Value;
string value = data.Descendants("value").Single().Value;
var translateKey = set.TranslateKeys.Where(x => x.Label == key && x.Set == set).SingleOrDefault();
if (translateKey == null)
{
translateKey = new TranslateKey
{
Label = key,
Set = set,
Category = category
};
set.TranslateKeys.Add(translateKey);
}
var translation = new Translation()
{
Key = translateKey, Language = language, Translator = null, Value = value
};
DbSession.Save(translateKey);
DbSession.Save(translation);
}
Global.CurrentSession.Update(set);
}
public ActionResult Index()
{
throw new NotSupportedException();
var set = TranslateSetService.FindByName("Ziber Websites");
var nl = LanguageService.GetLanguageByIsoCode("nl");
var en = LanguageService.GetLanguageByIsoCode("en");
if (set == null)
{
set = new TranslateSet
{
Name = "Ziber Websites",
NeedsReviewing = 0,
NeedsTranslations = 0,
Reviewed = 0
};
TranslateSetService.AddTranslateSet(set);
}
var category = set.FindOrCreateCategory("Shop");
set.TranslateKeys.Clear();
DbSession.Update(set);
if (nl == null)
{
nl = new Language()
{
IsoCode = "nl", Name = "Nederlands", IsEnabled = true
};
DbSession.Save(nl);
}
if (en == null)
{
en = new Language()
{
IsoCode = "en", Name = "Engels", IsEnabled = true
};
DbSession.Save(en);
}
Import(@"F:\dev\DL\producten\Domain.Resources\KZN\ProductShopTextDefaults.resx", set, category, nl);
Import(@"F:\dev\DL\producten\Domain.Resources\KZN\ProductShopTextDefaults.en-US.resx", set, category, en);
return(View());
}
public ActionResult Index()
{
throw new NotSupportedException();
var set = TranslateSetService.FindByName("Ziber Websites");
var nl = LanguageService.GetLanguageByIsoCode("nl");
var en = LanguageService.GetLanguageByIsoCode("en");
if (set == null)
{
set = new TranslateSet
{
Name = "Ziber Websites",
NeedsReviewing = 0,
NeedsTranslations = 0,
Reviewed = 0
};
TranslateSetService.AddTranslateSet(set);
}
var category = set.FindOrCreateCategory("Shop");
set.TranslateKeys.Clear();
DbSession.Update(set);
if (nl == null)
{
nl = new Language() { IsoCode = "nl", Name = "Nederlands", IsEnabled = true };
DbSession.Save(nl);
}
if (en == null)
{
en = new Language() { IsoCode = "en", Name = "Engels", IsEnabled = true };
DbSession.Save(en);
}
Import(@"F:\dev\DL\producten\Domain.Resources\KZN\ProductShopTextDefaults.resx", set, category, nl);
Import(@"F:\dev\DL\producten\Domain.Resources\KZN\ProductShopTextDefaults.en-US.resx", set, category, en);
return View();
}
public static void UpdateCounters(TranslateSet set, Language language)
{
var keyCount = set.TranslateKeys.Count;
var keys = DetachedCriteria.For<TranslateKey>("s")
.Add(Restrictions.Eq("Set", set))
.Add(Restrictions.EqProperty("s.Id", "t.Key.Id"))
.SetProjection(Projections.Id());
var translated = Global.CurrentSession.CreateCriteria<Translation>("t")
.Add(Restrictions.Eq("IsPublished", true))
.Add(Restrictions.Eq("NeedsReviewing", false))
.Add(Subqueries.Exists(keys))
.Add(Restrictions.Eq("Language", language))
.SetProjection(Projections.RowCount())
.UniqueResult<int>();
set.NeedsTranslations = keyCount - translated;
set.Reviewed = translated;
Global.CurrentSession.Update(set);
}
public static void UpdateCounters(TranslateSet set, Language language)
{
var keyCount = set.TranslateKeys.Count;
var keys = DetachedCriteria.For <TranslateKey>("s")
.Add(Restrictions.Eq("Set", set))
.Add(Restrictions.EqProperty("s.Id", "t.Key.Id"))
.SetProjection(Projections.Id());
var translated = Global.CurrentSession.CreateCriteria <Translation>("t")
.Add(Restrictions.Eq("IsPublished", true))
.Add(Restrictions.Eq("NeedsReviewing", false))
.Add(Subqueries.Exists(keys))
.Add(Restrictions.Eq("Language", language))
.SetProjection(Projections.RowCount())
.UniqueResult <int>();
set.NeedsTranslations = keyCount - translated;
set.Reviewed = translated;
Global.CurrentSession.Update(set);
}
public static void AddTranslateSet(TranslateSet set)
{
Global.CurrentSession.Save(set);
}
public static void AddTranslateSet(TranslateSet set)
{
Global.CurrentSession.Save(set);
}
