public Comment GetByID(long ID)
{
using (var db = new NEWSEntities())
{
return(db.Comments.SingleOrDefault(d => d.ID == ID));
}
}
public IHttpActionResult GetArticles(string status = "")
{
var articles = new List <ViewArticleJournalistModel>();
//ViewModelJournalist jr = new ViewModelJournalist();
using (var context = new NEWSEntities())
{
//var article = context.Article.ToList();
var article = context.Article.Where(f => f.Status == status).ToList();
if (article == null)
{
return(NotFound());
}
foreach (var n in article)
{
ViewArticleJournalistModel vm = new ViewArticleJournalistModel();
vm.Img = n.Img;
vm.Titre = n.Titre;
vm.Body = n.Body;
vm.Date = n.Date;
vm.Journaliste = n.Journalistes.Nom;
articles.Add(vm);
}
}
return(Ok(articles));
}
public IHttpActionResult GetSlideArticle()
{
var articles = new List <ViewArticleJournalist>();
//ViewModelJournalist jr = new ViewModelJournalist();
using (var context = new NEWSEntities())
{
//var article = context.Article.ToList();
var status = "posted";
var article = context.Article.Where(f => f.Status == status).OrderBy(a => a.Date).Take(4).ToList();
if (article == null)
{
return(NotFound());
}
foreach (var n in article)
{
ViewArticleJournalist vm = new ViewArticleJournalist();
vm.ID = n.ID;
vm.Img = n.Img;
vm.Titre = n.Titre;
vm.Body = n.Body;
vm.Description = n.Description;
vm.Date = n.Date;
vm.Journaliste = n.Journalistes.Nom;
articles.Add(vm);
}
}
return(Ok(articles));
}
public IList <string> GetTagsPost(long postID)
{
using (var db = new NEWSEntities())
{
return(db.Database.SqlQuery <string>("SELECT t.Name\r\nFROM dbo.PostTag AS pt\r\nINNER JOIN dbo.Tag AS t ON t.ID = pt.TagID\r\nWHERE PostID = " + postID).ToList());
}
}
public IList <Comment> GetAll()
{
using (var db = new NEWSEntities())
{
return(db.Comments.OrderBy(d => d.PostID).ToList());
}
}
public IHttpActionResult GetChefRedactions()
{
var redacteurs = new List <ChefRedactionViewModel>();
//ViewModelJournalist jr = new ViewModelJournalist();
using (var context = new NEWSEntities())
{
//var article = context.Article.ToList();
var redacteur = context.RedacteurEnChef.ToList();
if (redacteur == null)
{
return(NotFound());
}
foreach (var n in redacteur)
{
ChefRedactionViewModel vm = new ChefRedactionViewModel();
vm.Nom = n.Nom;
vm.Prenom = n.Prenom;
vm.Image = n.Image;
vm.Email = n.Email;
vm.Statu = n.Statu;
vm.NombrArticle = context.Article.Count();
vm.ID = n.ID;
redacteurs.Add(vm);
}
}
return(Ok(redacteurs));
}
public PostGallery GetByID(long ID)
{
using (var db = new NEWSEntities())
{
return(db.PostGalleries.SingleOrDefault(d => d.ID == ID));
}
}
public IHttpActionResult GetJournalist(int id = 0)
{
JournalistViewModel vm;
using (var context = new NEWSEntities())
{
var j = context.Journalistes.Where(jl => jl.ID == id).FirstOrDefault();
if (j == null)
{
return(NotFound());
}
vm = new JournalistViewModel();
vm.ID = id;
vm.Nom = j.Nom;
vm.Prenom = j.Prenom;
vm.Image = j.Image;
vm.NombrArticle = j.Article.Count();
var al = new List <ArticleViewModel>();
foreach (var a in j.Article)
{
ArticleViewModel am = new ArticleViewModel();
am.ID = a.ID;
am.Titre = a.Titre;
am.Body = a.Body;
am.Img = a.Img;
am.Date = a.Date.ToString();
am.Video = a.video;
al.Add(am);
}
vm.articles = al;
}
return(Ok(vm));
}
public IList <Gallery> GetAll()
{
using (var db = new NEWSEntities())
{
return(db.Galleries.OrderBy(d => d.PostGalleryID).ToList());
}
}
public Tag GetByName(string Name)
{
using (var db = new NEWSEntities())
{
return(db.Tags.SingleOrDefault(t => t.Name == Name));
}
}
public IList <Post> GetAll()
{
using (var db = new NEWSEntities())
{
return(db.Posts.OrderBy(d => d.CreateDate).ToList());
}
}
public void Update(Post Instance)
{
using (var db = new NEWSEntities())
{
try
{
var existItem = db.Posts.SingleOrDefault(d => d.ID == Instance.ID);
existItem.Title = Instance.Title;
existItem.ShortDescription = Instance.ShortDescription;
existItem.LongDescription = Instance.LongDescription;
existItem.MainImageUrl = Instance.MainImageUrl;
existItem.CreateDate = Instance.CreateDate;
existItem.Actived = Instance.Actived;
existItem.ViewerCount = Instance.ViewerCount;
existItem.IsGallery = Instance.IsGallery;
existItem.AuthorID = Instance.AuthorID;
existItem.CategoryID = Instance.CategoryID;
existItem.PostGalleryID = Instance.PostGalleryID;
db.SaveChanges();
}
catch (Exception ex)
{
throw new AggregateException(ex);
}
}
}
public IHttpActionResult GetJournalists()
{
var journalistes = new List <JournalistesModel>();
//ViewModelJournalist jr = new ViewModelJournalist();
using (var context = new NEWSEntities())
{
//var article = context.Article.ToList();
var journaliste = context.Journalistes.ToList();
if (journaliste == null)
{
return(NotFound());
}
foreach (var n in journaliste)
{
JournalistesModel vm = new JournalistesModel();
vm.Nom = n.Nom;
vm.Prenom = n.Prenom;
vm.Image = n.Image;
vm.Email = n.Email;
vm.Statu = n.Statu;
vm.NombrArticle = context.Article.Count();
vm.ID = n.ID;
journalistes.Add(vm);
}
}
return(Ok(journalistes));
}
public Category GetByID(long ID)
{
using (var db = new NEWSEntities())
{
return(db.Categories.SingleOrDefault(d => d.ID == ID));
}
}
public IList <Tag> GetAll()
{
using (var db = new NEWSEntities())
{
var result = db.Tags.SqlQuery("SELECT *\r\nFROM dbo.Tag\r\nORDER BY Name").ToList();
return(result);
}
}
public IEnumerable <Post> GetRelatedPost(long postID, long categoryID)
{
using (var db = new NEWSEntities())
{
return(db.Database.SqlQuery <Post>("SELECT *\r\nFROM dbo.Post\r\nWHERE CategoryID = " + categoryID
+ "\r\n\r\nEXCEPT\r\n\r\n SELECT *\r\n FROM dbo.Post\r\n WHERE ID = " + postID).ToList());
}
}
public IList <Post> GetPostsByTag(long tagID)
{
using (var db = new NEWSEntities())
{
var model = db.Posts.SqlQuery("SELECT dbo.Post.*\r\nFROM dbo.PostTag\r\nINNER JOIN dbo.Post ON Post.ID = PostTag.PostID\r\nWHERE TagID = " + tagID).ToList();
return(model);
}
}
public Post GetByTitleDateAuthor(string Title, DateTime CreateDate, string AuthorID)
{
using (var db = new NEWSEntities())
{
return(db.Posts.SingleOrDefault(p => p.Title == Title &&
p.CreateDate == CreateDate &&
p.AuthorID == AuthorID));
}
}
public static IEnumerable <Post> Search(string searchItem)
{
using (var db = new NEWSEntities())
{
var searched = db.Posts.Where(t => t.Title.Contains(searchItem)).ToList();
return(searched);
}
}
public Post GetPostByPostGallery(long postgalleryID)
{
using (var db = new NEWSEntities())
{
var post = db.Posts.SingleOrDefault(pg => pg.PostGalleryID == postgalleryID);
return(post);
}
}
public IEnumerable <Post> GetPostsHasGallery()
{
using (var db = new NEWSEntities())
{
return(db.Posts
.Where(p => p.IsGallery == true)
.OrderByDescending(post => post.CreateDate)
.ToArray());
}
}
public IList <Category> GetAll()
{
using (var db = new NEWSEntities())
{
return(db.Categories
.Include(c => c.Category1)
.OrderBy(d => d.Name)
.ToList());
}
}
public IEnumerable <NEWSAuthor> Authors()
{
using (var db = new NEWSEntities())
{
var model = db.Database.SqlQuery <NEWSAuthor>(
"SELECT AuthorID AS ID, FirstName + \' \' + LastName AS FullName, COUNT(Post.ID) AS PostCount,ImageUrl AS Avatar\r\nFROM dbo.Post\r\nLEFT OUTER JOIN dbo.Users ON Users.Id = Post.AuthorID\r\nLEFT OUTER JOIN dbo.UserRole ON UserRole.IdentityUser_Id = Users.Id\r\nGROUP BY AuthorID,FirstName + \' \' + LastName,ImageUrl").ToList();
return(model);
}
}
public void SetTagToPost(long postID, long tagID)
{
using (var db = new NEWSEntities())
{
var post = db.Posts.SingleOrDefault(p => p.ID == postID);
var tag = db.Tags.SingleOrDefault(t => t.ID == tagID);
post.Tags.Add(tag);
db.SaveChanges();
}
}
public IEnumerable <Post> GetPublishedPosts()
{
using (var db = new NEWSEntities())
{
return(db.Posts
.Include("Users")
.Where(p => p.CreateDate < DateTime.Now)
.OrderByDescending(p => p.CreateDate)
.ToArray());
}
}
public IList <Gallery> GetGallerysByPostGallery(long?postGalleryID)
{
using (var db = new NEWSEntities())
{
return(db.Galleries
.Include("PostGallery")
.Where(p => p.PostGalleryID == postGalleryID)
.OrderByDescending(post => post.PostGalleryID)
.ToArray());
}
}
public IList <NEWSTags> GetPosTags(long PostID)
{
using (var db = new NEWSEntities())
{
var model = db.Database
.SqlQuery <NEWSTags>(
"SELECT ID , PostID , Name\r\nFROM dbo.PostTag\r\nINNER JOIN dbo.Tag ON Tag.ID = PostTag.TagID\r\nWHERE PostID = " +
PostID).ToList();
return(model);
}
}
public IList <Comment> GetCommentsByPost(long postID)
{
using (var db = new NEWSEntities())
{
return(db.Comments
.Include("Post")
.Where(p => p.PostID == postID)
.OrderByDescending(post => post.PostID)
.ToArray());
}
}
public IEnumerable <Post> GetPostsByAuthor(string authorId)
{
using (var db = new NEWSEntities())
{
return(db.Posts
.Include(u => u.User)
.Where(p => p.AuthorID == authorId)
.OrderByDescending(post => post.CreateDate)
.ToArray());
}
}
public void SetGalleryToPost(long postGalleryID, IList <long> galleryID)
{
using (var db = new NEWSEntities())
{
foreach (var item in galleryID)
{
var gallery = db.Galleries.SingleOrDefault(g => g.ID == item);
gallery.PostGalleryID = postGalleryID;
db.SaveChanges();
}
}
}
