public static DBO.Translation GetTranslationById(long id)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Translation translation = bdd.T_Translation.Where(x => x.id == id).FirstOrDefault();
if (translation != null)
{
DBO.Translation newTranslation = new DBO.Translation()
{
Content = translation.content,
Id = translation.id,
IdArticle = translation.id_article,
IdLanguage = translation.id_language,
IdTranslator = translation.id_translator,
Validated = translation.validated
};
return(newTranslation);
}
return(null);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
public static bool CreateTranslation(DBO.Translation translation)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Translation newTranslation = new T_Translation()
{
content = translation.Content,
id_article = translation.IdArticle,
id_language = translation.IdLanguage,
id_translator = translation.IdTranslator,
validated = translation.Validated
};
bdd.T_Translation.Add(newTranslation);
bdd.SaveChanges();
return(true);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(false);
}
}
public static bool UpdateTranslation(DBO.Translation translation)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Translation oldTranslation = bdd.T_Translation.Where(x => x.id == translation.Id).FirstOrDefault();
if (oldTranslation != null)
{
oldTranslation.content = translation.Content;
oldTranslation.id_article = translation.IdArticle;
oldTranslation.id_language = translation.IdLanguage;
oldTranslation.id_translator = translation.IdTranslator;
oldTranslation.validated = translation.Validated;
bdd.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(false);
}
}