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