/// <summary>
/// Adds a new Article to the database and returns the success of the operation.
/// The id field of the parameter will be ignored when adding to the database.
/// </summary>
public static bool AddArticle(Dbo.Article article)
{
try
{
using (ProjectDBEntities ctx = new ProjectDBEntities())
{
ctx.T_Article.Add(new T_Article()
{
Title = article.Title,
IdAuthor = article.IdAuthor,
Date = article.Date,
Image = article.Image,
Text = article.Text,
Viewcount = 0
});
if (ctx.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Increments the viewcounter of the matching article and returns the success of the operation.
/// </summary>
public static bool IncrementArticleViewcountById(long id)
{
try
{
using (ProjectDBEntities ctx = new ProjectDBEntities())
{
var article = (from tmp in ctx.T_Article
where tmp.Id == id
select tmp).First();
article.Viewcount = article.Viewcount + 1;
if (ctx.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Adds a new User to the database and returns the success of the operation.
/// The id field of the parameter will be ignored when adding to the database.
/// </summary>
public static bool AddUser(Dbo.User user)
{
try
{
using (ProjectDBEntities ctx = new ProjectDBEntities())
{
ctx.T_User.Add(new T_User()
{
Name = user.Name,
Password = user.Password,
Admin = user.Admin
});
if (ctx.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}