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 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);
}
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);
}
