public bool EditVoter(VoterProperties vp)
        {
            DBClass dbc           = new DBClass();
            bool    isEditSuccess = dbc.EditVoterProperties(vp);

            return(isEditSuccess);
        }
예제 #2
0
        public bool EditVoterProperties(VoterProperties vbc)
        {
            using (SqlConnection con = new SqlConnection(conStr))
            {
                SqlCommand command = new SqlCommand("spEditVoter", con);

                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue("Id", vbc.VoterId);
                command.Parameters.AddWithValue("@FullName", vbc.FullName);
                command.Parameters.AddWithValue("@PhoneNumber", vbc.PhoneNumber.ToString());
                command.Parameters.AddWithValue("@Email", vbc.Email.ToString());
                command.Parameters.AddWithValue("Gender", vbc.Gender);
                command.Parameters.AddWithValue("@DateOfBirth", vbc.DateOfBirth);
                command.Parameters.AddWithValue("@Password", vbc.Password);
                command.Parameters.AddWithValue("@UserName", vbc.FullName);

                con.Open();
                int k = command.ExecuteNonQuery();

                con.Close();
            }


            return(true);
        }
        public void Register(VoterProperties vp)
        {
            DBClass dbc = new DBClass();

            vp.FullName    = vp.FullName.ToUpper();
            vp.Email       = vp.Email.ToLower();
            vp.Gender      = vp.Gender.ToUpper();
            vp.DateOfBirth = vp.DateOfBirth;

            //encrypt password
            vp.Password = vp.Password;


            //send that data to dbclass

            dbc.AddData(vp);
        }