コード例 #1
0
        //Update worker to Commissioner
        public string updateWorker(string id, string kalpiCode, string name, string lastname, string username, string password, string permission, DateTime birthDay, string addres, string area, string city, string tell)
        {
            Voter         worker = new Voter(id, kalpiCode, name, lastname, username, password, permission, birthDay, addres, area, city, tell, "Commissioner", true, false, true);
            sqlConnection con    = sqlConnection.Instance;

            con.sqlCommand("updateWorker");
            con.InsertValstring("@idVoter", worker.Id);
            con.InsertValstring("@kalpiCode", worker.KalpiCode);
            con.InsertValstring("@name", worker.FName);
            con.InsertValstring("@lastname", worker.LName);
            con.InsertValstring("@username", worker.username);
            con.InsertValstring("@password", worker.Passowrd);
            con.InsertValstring("@permission", worker.Permission);
            con.InsertValstring("@address", worker.Address);
            con.InsertValstring("@area", worker.Area);
            con.InsertValstring("@city", worker.City);
            con.InsertValDate("@birthDay", worker.DOB);
            con.InsertValstring("@tell", worker.Tell);
            return(con.getVal("@Result"));
        }
コード例 #2
0
        /// <summary>
        /// The function Chack if kalpi Name Equals with kalpi manager
        /// and blocked Voter.
        /// </summary>
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                int  i;
                bool success = int.TryParse(textBox1.Text, out i);
                if (textBox1.Text.Length == 9 && success == true && int.Parse(textBox1.Text) > 0) // Checks for valid input
                {
                    sqlConnection con = sqlConnection.Instance;                                   //sql conection
                    con.sqlCommand("getCalpiCodeById");                                           //sql Procedure
                    con.InsertValstring("@id", textBox1.Text.Trim());                             //sql insert Value
                    DataTable kCode = con.GetData("getCalpiCodeById");

                    if (kCode.Rows.Count == 0)
                    {
                        throw new Exception();
                    }
                    foreach (DataRow code in kCode.Rows)
                    {
                        if (code["kalpiCode"].ToString().Equals(manager.KalpiCode))
                        {
                            manager.BlockedCitizen(textBox1.Text); //call to blocked Function
                            MessageBox.Show("Block Voter Succeeded");
                            this.Close();
                        }
                        else
                        {
                            MessageBox.Show("can't block voter, he doesn't belong to your kalpi");
                            this.Close();
                        }
                    }
                }
                else
                {
                    MessageBox.Show(" Invalid input");
                }
            }
            catch {
                MessageBox.Show("The Id is invalid!");
            }
        }
コード例 #3
0
        public Boolean login(string id, string username, string password)//this function check the details accordingly to the data base.
        {
            con.sqlCommand("login");
            con.InsertValstring("@id", id.Trim());
            con.InsertValstring("@username", username.Trim());
            con.InsertValstring("@password", password.Trim());
            DataTable temp = con.GetData("login");

            if ((textBox1.Text == "") || (textBox2.Text == "") || (textBox3.Text == "")) //check if One or more of the fields are empty.
            {
                MessageBox.Show("One or more of the fields are empty");
                return(false);
            }
            try
            {
                int.Parse(textBox1.Text);//check id field - contain only numbers.
            }
            catch
            {
                MessageBox.Show("Invalid input in Id Field");
                return(false);
            }
            if (temp.Rows.Count > 0)
            {
                var factory = new FactroryVoter() as ICreateVoters;
                user = factory.createVoter(temp.Rows[0]);//if the user found in data base
                return(true);
            }
            else
            {
                MessageBox.Show("Doesn't Exist In Data Base!!");
                textBox1.Text = "";
                textBox2.Text = "";
                textBox3.Text = "";//clean fields
                return(false);
            }
        }
コード例 #4
0
 public int addNewKalpi(Kalpi kalpi)
 {
     con.sqlCommand("addNewKalpi");
     con.InsertValstring("@kalpiCode", kalpi.KalpiCode);
     con.InsertValstring("@kalpiName", kalpi.KalpiName);
     con.InsertValstring("@address", kalpi.Address);
     con.InsertValstring("@city", kalpi.City);
     con.InsertValstring("@area", this.Area);
     con.InsertValint("@maxVoters", kalpi.MaxVoters);
     return(int.Parse(con.getVal("Result").ToString()));
 }
コード例 #5
0
 public DataTable getVotesForPrime()
 {
     con.sqlCommand("getPrimeVotes");
     con.InsertValstring("@kalpiCode", this.KalpiCode);
     return(con.GetData("getPrimeVotes"));
 }