public static Round UpdateRound(Round round)
{
Round newRound = null;
db_votecontestEntities dbVoteContest = new db_votecontestEntities();
try
{
newRound = dbVoteContest.Rounds.Where(x => x.idRound == round.idRound).FirstOrDefault();
if (newRound != null)
{
newRound.nameRound = round.nameRound;
newRound.ruleRound = round.ruleRound;
newRound.startDate = round.startDate;
newRound.endDate = round.endDate;
dbVoteContest.SaveChanges();
}
}
finally
{
if (dbVoteContest != null)
{
((IDisposable)dbVoteContest).Dispose();
}
}
return(newRound);
}
public static User AddUser(string email)
{
User user = new User();
db_votecontestEntities dbVoteContest = new db_votecontestEntities();
try
{
User userE = dbVoteContest.Users.Where(x => x.emailUser == email).FirstOrDefault();
if (userE == null)
{
user = new User
{
emailUser = email
};
dbVoteContest.Users.Add(user);
dbVoteContest.SaveChanges();
}
else
{
user = userE;
}
}
finally
{
if (dbVoteContest != null)
{
((IDisposable)dbVoteContest).Dispose();
}
}
return(user);
}
public static bool UpdateTag(Tag newtag)
{
bool isSucces = false;
db_votecontestEntities dbVoteContest = new db_votecontestEntities();
try
{
Tag tag = dbVoteContest.Tags.Where(x => x.idTag == newtag.idTag).FirstOrDefault();
if (tag != null)
{
tag.nameTag = newtag.nameTag;
tag.valueTag = newtag.valueTag;
dbVoteContest.SaveChanges();
isSucces = true;
}
}
finally
{
if (dbVoteContest != null)
{
((IDisposable)dbVoteContest).Dispose();
}
}
return(isSucces);
}
public static Video UpdateVideo(Video video)
{
Video newvideo = new Video();
db_votecontestEntities dbVoteContest = new db_votecontestEntities();
try
{
newvideo = dbVoteContest.Videos.Where(x => x.idVideo == video.idVideo).FirstOrDefault();
if (newvideo != null)
{
newvideo.authorVideo = video.authorVideo;
newvideo.codeAuthor = video.codeAuthor;
newvideo.describeVideo = video.describeVideo;
newvideo.urlVideo = video.urlVideo;
newvideo.titleVideo = video.titleVideo;
newvideo.idRound = video.idRound;
}
else
{
video.createDate = DateTime.Now;
newvideo = dbVoteContest.Videos.Add(video);
}
dbVoteContest.SaveChanges();
}
finally
{
if (dbVoteContest != null)
{
((IDisposable)dbVoteContest).Dispose();
}
}
return(newvideo);
}
public static Video AddVote(int idVideo, string codeAuthor, int idUser)
{
Video videoVote = null;
db_votecontestEntities dbVoteContest = new db_votecontestEntities();
try
{
Video video = VideoService.GetVideoById(idVideo);
// Get round for check expire date
Round round = RoundService.GetRoundById((int)video.idRound);
DateTime now = DateTime.Now;
// Check expire date
if (round.startDate <= now && round.endDate >= now)
{
// Get voting video of user
VotingVideo votingVideo = dbVoteContest.VotingVideos.Join(dbVoteContest.Videos, vote => vote.idVideo, v => v.idVideo, (vote, v) => new { Vote = vote, Video = v }).Where(x => x.Video.idRound == round.idRound && x.Vote.idUser == idUser).Select(x => x.Vote).FirstOrDefault();
// null : user do not vote video yet
if (votingVideo == null)
{
votingVideo = new VotingVideo();
votingVideo.idVideo = idVideo;
votingVideo.codeAuthor = codeAuthor;
votingVideo.idUser = idUser;
dbVoteContest.VotingVideos.Add(votingVideo);
dbVoteContest.SaveChanges();
videoVote = dbVoteContest.Videos.Where(x => x.idVideo == idVideo).FirstOrDefault();
videoVote.codeAuthor = codeAuthor;
}
else // !null is check round
{
// get video voted
Video videoVoted = dbVoteContest.Videos.Where(x => x.idVideo == votingVideo.idVideo).FirstOrDefault();
//videoVote = dbVoteContest.Videos.Where(x => x.idVideo == idVideo).FirstOrDefault();
//// Check round
//if (videoVoted.idRound != videoVote.idRound)
//{
// votingVideo = new VotingVideo();
// votingVideo.idVideo = idVideo;
// votingVideo.codeAuthor = codeAuthor;
// votingVideo.idUser = idUser;
// dbVoteContest.VotingVideos.Add(votingVideo);
// dbVoteContest.SaveChanges();
// videoVote = dbVoteContest.Videos.Where(x => x.idVideo == idVideo).FirstOrDefault();
// videoVote.codeAuthor = codeAuthor;
//}
//else
//{
// videoVote = videoVoted;
// videoVote.codeAuthor = votingVideo.codeAuthor;
//}
videoVote = videoVoted;
videoVote.codeAuthor = votingVideo.codeAuthor;
}
}
}
finally
{
if (dbVoteContest != null)
{
((IDisposable)dbVoteContest).Dispose();
}
}
return(videoVote);
}
