public static DBO.Article GetArticle(long id)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Article article = bdd.T_Article.Where(x => x.id == id).FirstOrDefault();
if (article != null)
{
DBO.Article result = new DBO.Article()
{
Id = article.id,
Title = article.title,
Content = article.content,
CreatedDate = article.created_date,
IdCreator = article.id_creator,
Validated = article.validated
};
return(result);
}
return(null);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
public static bool CreateArticle(ref DBO.Article article)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Article newArticle = new T_Article()
{
title = article.Title,
content = article.Content,
id_creator = article.IdCreator,
created_date = article.CreatedDate,
validated = article.Validated
};
bdd.T_Article.Add(newArticle);
bdd.SaveChanges();
article.Id = newArticle.id;
return(true);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.ToString());
return(false);
}
}
public static bool UpdateArticle(DBO.Article article)
{
try
{
using (MeditateBookEntities bdd = new MeditateBookEntities())
{
T_Article oldarticle = bdd.T_Article.Where(x => x.id == article.Id).FirstOrDefault();
if (oldarticle != null)
{
oldarticle.title = article.Title;
oldarticle.content = article.Content;
oldarticle.id_creator = article.IdCreator;
oldarticle.validated = article.Validated;
oldarticle.created_date = article.CreatedDate;
bdd.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(false);
}
}