public bool AddVote(int pJokeId, long pUserId, bool pVoteType) { bool ret = false; try { if (container == null) { container = new NokatModelContainer(); } var result = container.Votes.Where(i => i.JokeId == pJokeId && i.UserId == pUserId).FirstOrDefault(); if (result == null) { container.AddToVotes(new Votes(){ JokeId=pJokeId,UserId=pUserId,VoteType=pVoteType}); container.SaveChanges(); } else if(result.VoteType!=pVoteType) { result.VoteType=pVoteType; container.SaveChanges(); } ret=true; } catch { } return ret; }
public IQueryable<Jokes> GetJokesByUserId(int pUserId) { try { if (container == null) { container = new NokatModelContainer(); } var retJokes = container.Jokes.Where(i => i.UserId == pUserId).OrderByDescending(i => i.AddDate).AsQueryable<Jokes>(); return retJokes; } catch { return null; } }
public IQueryable<Jokes> GetAllJokesByDate() { try { if (container == null) { container = new NokatModelContainer(); } var retJokes = container.Jokes.OrderByDescending(i=>i.AddDate).AsQueryable(); return retJokes; } catch { return null; } }
public int GetJokesVotesCount(int pJokeId, bool pType) { int ret = 0; try { if (container == null) { container = new NokatModelContainer(); } ret = container.Votes.Count(i => i.JokeId == pJokeId && i.VoteType == pType); } catch { } return ret; }
public string GetCurrentUserVote(int pJokeId, long pUserId) { string ret =null; try { if (container == null) { container = new NokatModelContainer(); } var result = container.Votes.Where(i => i.JokeId == pJokeId && i.UserId==pUserId).Select(i=>i.VoteType).First(); if (result != null) { return result.ToString(); } } catch { } return ret; }
public int AddJoke(int pUserId, string pJoke) { int ret = 0; try { if (container == null) { container = new NokatModelContainer(); } Jokes newJoke = new Jokes(){ UserId = pUserId, Joke = pJoke, AddDate=DateTime.Now }; container.AddToJokes(newJoke); container.SaveChanges(); ret = newJoke.JokeId; } catch { ret = 0; } return ret; }