public static bool ValidateData()
{
using (var context = new NewsFeedDBEntities())
{
return(context.NewsFeed.Any());
}
}
public static Users Login(Users user)
{
using (var context = new NewsFeedDBEntities())
{
return(context.Users.Where(x => x.UserName == user.UserName && user.Password == user.Password).FirstOrDefault());
}
}
public static List <Feed> RetrieveFeedByUser(int userId)
{
using (var context = new NewsFeedDBEntities())
{
return(context.Feed.Where(x => x.CreatedBy == userId).ToList());
}
}
public static List <Feed> RetrieveFeed()
{
using (var context = new NewsFeedDBEntities())
{
return(context.Feed.Where(x => x.Active == true).ToList());
}
}
public static List <NewsFeed> RetrieveNewsFeedById(int id)
{
using (var context = new NewsFeedDBEntities())
{
return(context.NewsFeed.Where(x => x.Active == true && x.FeedId == id).Include(x => x.Users).Include(a => a.Feed).ToList());
}
}
public static void InsertDefaultData()
{
using (var context = new NewsFeedDBEntities())
{
var user = new Users {
Name = "Default", Password = "******"
};
context.Users.Add(user);
context.SaveChanges();
var feed = new Feed {
Name = "Sports", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true
};
context.Feed.Add(feed);
context.SaveChanges();
context.NewsFeed.Add(new NewsFeed {
Title = "Football", Description = "World Cup Qatar 2022 is comming.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Baseball", Description = "The official news source of Major League Baseball.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Voleyball", Description = "Volleyball news, interviews, transfers, videos and more.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.SaveChanges();
feed = new Feed {
Name = "Food", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true
};
context.Feed.Add(feed);
context.SaveChanges();
context.NewsFeed.Add(new NewsFeed {
Title = "Chinese", Description = "Find out what Chinese dishes to try in China, soon!", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Mexican", Description = "All the latest breaking news on Mexican Food.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Fast food", Description = "KFC hints at plan for plant-based chicken alternative.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.SaveChanges();
feed = new Feed {
Name = "Vacations", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true
};
context.Feed.Add(feed);
context.SaveChanges();
context.NewsFeed.Add(new NewsFeed {
Title = "Costa Rica", Description = "All the latest breaking news on Costa Rica travel.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Grand Canyon", Description = "If you want to really explore the Grand Canyon, you need to plan a day trip on your next vacation in Vegas.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.NewsFeed.Add(new NewsFeed {
Title = "Mexico", Description = "Cancun ranks as the top international destination this holiday season for U.S. travelers.", CreateDate = DateTime.Now, CreatedBy = user.Id, Active = true, FeedId = feed.Id
});
context.SaveChanges();
}
}
public static void AddSubscription(Subscription model)
{
using (var context = new NewsFeedDBEntities())
{
context.Subscription.Add(model);
context.SaveChanges();
}
}
public static void AddFeed(Feed model)
{
using (var context = new NewsFeedDBEntities())
{
context.Feed.Add(model);
context.SaveChanges();
}
}
public static void AddNewsFeed(NewsFeed newsFeed)
{
using (var context = new NewsFeedDBEntities())
{
context.NewsFeed.Add(newsFeed);
context.SaveChanges();
}
}
public static Users Register(Users user)
{
using (var context = new NewsFeedDBEntities())
{
context.Users.Add(user);
context.SaveChanges();
return(user);
}
}
public static void RemoveSubscription(Subscription model)
{
using (var context = new NewsFeedDBEntities())
{
var sub = context.Subscription.Where(x => x.UserId == model.UserId && x.FeedId == model.FeedId).FirstOrDefault();
context.Subscription.Remove(sub);
context.SaveChanges();
}
}
public static List <Feed> RetrieveFeedSubscriptions(int userId)
{
using (var context = new NewsFeedDBEntities())
{
var subscriptions = (from feed in context.Feed
join subs in context.Subscription on feed.Id equals subs.FeedId
where feed.Id == subs.FeedId && subs.UserId == userId
select feed).ToList();
return(subscriptions);
}
}
public static List <NewsFeed> SearchNewsFeed(string searchText)
{
using (var context = new NewsFeedDBEntities())
{
var news = context.NewsFeed.Where(x => x.Active == true).Include(x => x.Users).Include(a => a.Feed).ToList();
return(news.Where(x => x.Title.ToLower().Contains(searchText.ToLower()) ||
x.Description.ToLower().Contains(searchText.ToLower()) ||
x.Users.Name.ToLower().Contains(searchText.ToLower()) ||
x.Feed.Name.ToLower().Contains(searchText.ToLower())
).ToList());
}
}
