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