/// <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.Insert(row);
return(TranslationTransformer.ToBean(row));
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public TranslationVal Get(TranslationValKey key)
{
if (key == null || key.CultureId < 0 || string.IsNullOrWhiteSpace(key.Key))
{
return(null);
}
var row = _dbContext.Table <TranslationRow>().Where(m => m.CultureId == key.CultureId && m.Key == key.Key).FirstOrDefault();
if (row != null)
{
return(TranslationTransformer.ToBean(row));
}
return(null);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <TranslationVal> Find(TranslationValCriteria translationValCriteria = null)
{
List <TranslationVal> resultList = null;
var rowList = _dbContext.Table <TranslationRow> ();
CriteriaTransformer.CompleteQuery(ref rowList, translationValCriteria);
if (rowList != null && rowList.Count() > 0)
{
resultList = new List <TranslationVal>();
foreach (var row in rowList)
{
resultList.Add(TranslationTransformer.ToBean(row));
}
}
return(resultList);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <TranslationVal> Find()
{
List <TranslationVal> resultList = null;
IQueryable <TranslationRow> rowList = _dbContext.Translation;
if (rowList != null)
{
foreach (var row in rowList)
{
if (resultList == null)
{
resultList = new List <TranslationVal>();
}
resultList.Add(TranslationTransformer.ToBean(row));
}
}
return(resultList);
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="translation">data</param>
/// <returns>updated data</returns>
public TranslationVal Update(TranslationVal translation)
{
if (translation == null || translation.CultureId < 0 || string.IsNullOrWhiteSpace(translation.Key))
{
return(null);
}
var row = _dbContext.Translation.Where(m => m.CultureId == translation.CultureId && m.Key == translation.Key).FirstOrDefault();
if (row == null)
{ // No data in database
return(Create(translation));
}
else
{ //Modify Data in database
TranslationTransformer.ToRow(translation, row);
_dbContext.SaveChanges();
return(TranslationTransformer.ToBean(row));
}
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="translation">data</param>
/// <returns>updated data</returns>
public TranslationVal Update(TranslationVal translation)
{
if (translation == null || translation.CultureId < 0 || string.IsNullOrWhiteSpace(translation.Key))
{
return(null);
}
var row = _dbContext.Table <TranslationRow>().Where(m => m.CultureId == translation.CultureId && m.Key == translation.Key).FirstOrDefault();
if (row == null)
{ // No data in database
return(Create(translation));
}
else
{ //Modify Data in database
TranslationTransformer.ToRow(translation, row);
_dbContext.Delete(row); //Update don't work... need delete and insert
_dbContext.Insert(row);
return(TranslationTransformer.ToBean(row));
}
}
