public Comment GetComment(int id)
{
using (var db = new StackoverflowContext())
{
return(db.comment.FirstOrDefault(x => x.Id == id));
}
}
public List <User> GetUsers()
{
using (var db = new StackoverflowContext())
{
return(db.user.ToList());
}
}
public List <Bookmark> getBookmarks(int userid)
{
using (var db = new StackoverflowContext())
{
return(db.bookmark.Where(x => x.userid == userid).ToList());
}
}
public int GetNumberOfPosts()
{
using (var db = new StackoverflowContext())
{
return(db.posts.Count());
}
}
// private string connectingString = "host=localhost;db=stackoverflow;uid=postgres;pwd=postgres";
public Post GetPostById(int id)
{
using (var db = new StackoverflowContext())
{
return(db.posts.FirstOrDefault(x => x.Id == id));
}
}
public List <Post> GetPostsByTags(string tagSearch)
{
using (var db = new StackoverflowContext())
{
return(db.posts.Where(x => x.Tags.Contains(tagSearch)).ToList());
}
}
public void createUser(string userPWD, string userName, int age, string displayName, string userLoc, string salt)
{
using (var db = new StackoverflowContext())
{
db.Database.ExecuteSqlCommand("select createusers({0},{1},{2},{3},{4},{5})", userPWD, userName, age, displayName, userLoc, salt);
}
}
public List <Post> GetPosts(Args args)
{
using (var db = new StackoverflowContext())
{
var query = db.posts
.Include(x => x.Comment).AsQueryable();
// query = query.Where(x => x.Tags.Contains("sasdsdasd"));
//query = query.Skip(args.Page * args.PageSize)
//.Take(args.PageSize);
/*
* if (!string.IsNullOrEmpty(args.Tag))
* {
* query = query.Where(x => x.Tags.Contains(args.Tag));
*
* }
*/
query = query.Skip(args.Page * args.PageSize)
.Take(args.PageSize);
return(query.ToList());
}
}
public List <WordCloud> GetWordCloud(string wordSearch)
{
using (var db = new StackoverflowContext())
{
var wordCloudResponse = db.WordCloudResults.FromSql("select * from co_ocsearch({0})", wordSearch).ToList();
return(wordCloudResponse);
}
}
public int BookmarkPost(int postid, int userid, string annotation)
{
using (var db = new StackoverflowContext())
{
var databaseResponse = db.Database.ExecuteSqlCommand("select postmarking({0},{1},{2})", postid, userid, annotation);
return(databaseResponse);
}
}
public List <Post> GetPosts(int page, int pageSize)
{
using (var db = new StackoverflowContext())
{
// var result in db.SearchResults.FromSql("select * from search({0})", "al")
return(db.posts
.Include(x => x.Comment)
.Skip(page * pageSize)
.Take(pageSize)
.ToList());
}
}
public User GetUserByUsername(string FetchUser)
{
using (var db = new StackoverflowContext())
{
try
{
return(db.user.FirstOrDefault(x => x.Username == FetchUser));
}catch (Exception)
{
return(null);
}
}
}
public SearchResultObjectExact ExactMatch(string wordSearch, int page, int pageSize)
{
string[] wordSplit = wordSearch.Split(' ');
using (var db = new StackoverflowContext())
{
var result = db.ExactSearchResults.FromSql("select * from ExactMatch({0})", wordSplit).AsQueryable();
var count = result.Count();
var posts = result.Skip(page * pageSize)
.Take(pageSize);
return(new SearchResultObjectExact(count, posts.ToList()));
}
}
public SearchResultObject WeightedSearch(string wordSearch, int page, int pageSize)
{
string test = wordSearch.Replace(" ", "','");
string test1 = "select * from weigthsearch('" + test + "')";
using (var db = new StackoverflowContext())
{
var result = db.SearchResults.FromSql(test1).AsQueryable();
var count = result.Count();
var posts = result.Skip(page * pageSize)
.Take(pageSize);
return(new SearchResultObject(count, posts.ToList()));
}
}
public SearchResultObject /*List<SearchResult>*/ wordToWordSearch(string wordSearch, int page, int pageSize)
{
string[] wordSplit = wordSearch.Split(' ');
using (var db = new StackoverflowContext())
{
//List<SearchResult> result = db.SearchResults.FromSql("select * from bestmatch3({0},{1},{2})", wordSplit).ToList();
var result = db.SearchResults.FromSql("select * from bestmatch3({0},{1},{2})", wordSplit).AsQueryable();
var count = result.Count();
var posts = result.Skip(page * pageSize)
.Take(pageSize);
//return posts.ToList();
return(new SearchResultObject(count, posts.ToList()));
}
}
//public List<Post> GetPosts(int page, int pageSize)
//{
// using (var db = new StackoverflowContext())
// {
// List<Post> list = db.posts.ToList();
// return list;
// }
//}
public void CreateNewUser(string _userpassword, string _userName, int _age, string _displayName, string _userLocation)
{
using (var db = new StackoverflowContext())
{
db.user.Add(new User
{
UserPassword = _userpassword,
Username = _userName,
Age = _age,
DisplayName = _displayName,
UserLocation = _userLocation,
//CreationDate = new DateTime().Date
});
db.SaveChanges();
}
}
