コード例 #1
0
        /// <summary>
        /// Selects an election by election ID
        /// </summary>
        /// <param name="electionID"></param>
        /// <returns></returns>
        public ElectionVM SelectElectionByElectionID(int electionID)
        {
            ElectionVM election = new ElectionVM();
            var        conn     = DBConnection.GetConnection();
            var        cmd      = new SqlCommand("sp_select_election_by_election_id", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ElectionID", electionID);

            try
            {
                conn.Open();
                var reader = cmd.ExecuteReader();
                if (reader.Read())
                {
                    election.ElectionID  = reader.GetInt32(0);
                    election.Name        = reader.GetString(1);
                    election.Description = reader.GetString(2);
                    election.Active      = reader.GetBoolean(3);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
            return(election);
        }
コード例 #2
0
        public ActionResult _ElectionDatePartial(ElectionVM model)
        {
            if (!ModelState.IsValid)
            {
                return(PartialView(model));
            }

            // make sure dates are correct
            if (model.EndDate < model.StartDate)
            {
                return(Json(new { Status = 0, Message = "End date should be the future of the start date" }));
            }

            // get election
            var election = db.Election.FirstOrDefault();

            // update end date
            election.StartDate = model.StartDate;
            election.EndDate   = model.EndDate;

            // save db
            db.SaveChanges();

            return(Json(new { Status = 1, Message = "Success" }));
        }
コード例 #3
0
        /// <summary>
        /// Selects a list of elections by active
        /// </summary>
        /// <param name="active"></param>
        /// <returns></returns>
        public List <ElectionVM> SelectElectionsByActive(bool active)
        {
            List <ElectionVM> elections = new List <ElectionVM>();
            var conn = DBConnection.GetConnection();
            var cmd  = new SqlCommand("sp_select_elections_by_active", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@active", active);

            try
            {
                conn.Open();
                var reader = cmd.ExecuteReader();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        var election = new ElectionVM();

                        election.ElectionID  = reader.GetInt32(0);
                        election.Name        = reader.GetString(1);
                        election.Description = reader.GetString(2);
                        election.Active      = reader.GetBoolean(3);

                        elections.Add(election);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
            return(elections);
        }