public IList<Post> GetPublicPosts()
{
using (DomainContext context = new DomainContext())
{
return context.Posts.Where(p => p.Approved).ToList();
}
}
public IList<Post> GetPosts()
{
using (DomainContext context = new DomainContext())
{
return context.Posts.ToList();
}
}
public Post GetPost(string name)
{
using (DomainContext context = new DomainContext())
{
return context.Posts.ToList().FirstOrDefault(p => string.Equals(p.Title, name, StringComparison.InvariantCultureIgnoreCase));
}
}
public Post GetPost(int id)
{
using (DomainContext context = new DomainContext())
{
return context.Posts.FirstOrDefault(p => p.Id == id);
}
}
public void UpdatePost(Post post)
{
using (DomainContext context = new DomainContext())
{
context.Posts.Attach(post);
context.Entry(post).State = EntityState.Modified;
context.SaveChanges();
}
}
public void DeletePost(Post post)
{
using (DomainContext context = new DomainContext())
{
context.Posts.Attach(post);
context.Posts.Remove(post);
context.SaveChanges();
}
}
public bool PromoteToAdmin(string userName)
{
using (DomainContext context = new DomainContext())
{
UserProfile existingUser = context.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == userName.ToLower());
if (existingUser != null)
{
return true;
}
return false;
}
}
public bool AddUser(UserProfile user)
{
using (DomainContext context = new DomainContext())
{
UserProfile existingUser = context.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == user.UserName.ToLower());
if (existingUser == null)
{
context.UserProfiles.Add(user);
context.SaveChanges();
return true;
}
return false;
}
}
public bool AddPost(Post post)
{
if (GetPost(post.Title) != null)
{
return false;
}
using (DomainContext context = new DomainContext())
{
context.Posts.Add(post);
context.SaveChanges();
}
return true;
}
