public static void ToRow(TranslationVal bean, TranslationRow row)
{
if (bean == null)
return;
row.CultureId = bean.CultureId;
row.Key = bean.Key;
row.Value = bean.Value;
}
internal static TranslationVal ToBean(TranslationRow row)
{
if (row == null)
return null;
var bean = new TranslationVal();
bean.CultureId = row.CultureId;
bean.Key = row.Key;
bean.Value = row.Value;
return bean;
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="translation">Data</param>
/// <returns>insert data</returns>
public TranslationVal Create(TranslationVal translation)
{
if (translation == null || translation.CultureId < 0 || string.IsNullOrWhiteSpace(translation.Key))
return null;
var row = new TranslationRow();
TranslationTransformer.ToRow(translation, row);
_dbContext.Translation.Add(row);
_dbContext.SaveChanges();
return TranslationTransformer.ToBean(row);
}
public static void UpdateInDB(string key, string value, ApplicationDbContext dbContext = null, int cultureId=-1)
{
if (dbContext == null)
dbContext = new ApplicationDbContext();
var localizer = GetLocalizer() as StringLocalizer;
localizer.RemoveTranslationInDictionnary("DB_" + key);
int currentCultureId;
if (cultureId == -1)
currentCultureId = GetCurrentCultureId();
else
currentCultureId = cultureId;
TranslationRow row = dbContext.Translation.Where(t => t.CultureId == currentCultureId && t.Key.ToLower() == key.ToLower()).FirstOrDefault();
if(row == null)
{
row = new TranslationRow();
row.CultureId = currentCultureId;
row.Key = key;
row.Value = value;
dbContext.Translation.Add(row);
}
else
row.Value = value;
dbContext.SaveChanges();
}
