Ejemplo n.º 1
0
        public List <VotesDTO> GetAllTheVotes()
        {
            SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);

            List <VotesDTO> list = new List <VotesDTO>();

            using (sqlconn)
            {
                using (SqlCommand cmd = new SqlCommand("getAllTheVotes", sqlconn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    sqlconn.Open();

                    using (SqlDataReader rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            VotesDTO userCampaign = new VotesDTO
                            {
                                UserId      = rdr["UserId"].ToString(),
                                CandidateId = rdr["CandidateID"].ToString(),
                                CampaignID  = rdr["CampaignID"].ToString()
                            };
                            list.Add(userCampaign);
                        }
                    }
                }
            }
            return(list);
        }
Ejemplo n.º 2
0
 public static void addVote(string siteName)
 {
     using (RecipezeEntities db = new RecipezeEntities())
     {
         try
         {
             var numOfVotes = db.Votes.Where(a => a.siteName == siteName).ToList();
             if (numOfVotes.Count == 0)
             {
                 VotesDTO voting = new VotesDTO()
                 {
                     siteName = siteName, voteNumbers = 1
                 };
                 db.Votes.Add(CONVERTERS.VotesConverter.ConvertVoteToDAL(voting));
                 db.SaveChanges();
             }
             else
             {
                 var voteUpdate = db.Votes.Where
                                  (
                     p => siteName.Contains(p.siteName)
                                  );
                 foreach (Vote p in voteUpdate)
                 {
                     p.voteNumbers++;
                 }
                 db.SaveChanges();
             }
         }
         catch (Exception e)
         {
             Console.WriteLine(e);
         }
     }
 }
Ejemplo n.º 3
0
 public static Vote ConvertVoteToDAL(VotesDTO vote)
 {
     return(new Vote
     {
         siteName = vote.siteName,
         voteNumbers = vote.voteNumbers
     });
 }
Ejemplo n.º 4
0
        public ActionResult Scan_FingerForeVote(VotesDTO paramVotesDTO)
        {
            Candidate candidate = null;

            try
            {
                if (paramVotesDTO == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                else
                {
                    // get logged in user id
                    String userId = User.Identity.GetUserId();
                    // get user fingerprint 
                    VoteViewModel voteVM = new VoteViewModel();
                    ViewBag.fingerprint = voteVM.GetUserFingerprint(userId);
                    // passing user id and finger print to the frontend
                    ViewBag.userId = userId;

                    var canId = paramVotesDTO.CandidateId;

                    ViewBag.candidateID = canId;
                    VoteViewModel vvM = new VoteViewModel();

                    candidate = vvM.GetCandidateDetailsById(canId);

                    //Get the candidate details
                    ViewBag.Name = candidate.Name;
                    ViewBag.Surname = candidate.Surname;
                    ViewBag.Gender = candidate.Gender;
                    ViewBag.Picture = candidate.CandidatePic;
                    ViewBag.CampaignID = candidate.CampaignID;


                }
                return View();
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(string.Empty, "Error: " + ex);
                return View();
            }
            
        }