Exemplo n.º 1
0
        private void btnProcess_Click(object sender, EventArgs e)
        {
            string  ticketType;
            string  fname;
            decimal balance;
            Visitor vistor = null;
            string  lname;
            int     id;
            string  email;
            string  city;
            string  postcode;
            string  coutry;
            string  username;
            string  pwd;
            string  street;
            int     phoneNr;
            int     checkin;
            int     Pstatus;
            string  rfid;
            int     housenr;


            if (TBCUSID.Text != "")
            {
                id         = Convert.ToInt32(TBCUSID.Text);
                ticketType = Convert.ToString(tbticketType.Text);
                balance    = Convert.ToDecimal(TBBALANCE.Text);
                fname      = Convert.ToString(TBFNAME.Text);
                lname      = Convert.ToString(TBLNAME.Text);
                email      = Convert.ToString(tbemail.Text);
                pwd        = Convert.ToString(tbpwd.Text);
                housenr    = Convert.ToInt32(tbhousenr.Text);
                username   = Convert.ToString(tbusername.Text);
                postcode   = Convert.ToString(tbpostcode.Text);
                city       = Convert.ToString(tbcity.Text);
                coutry     = Convert.ToString(tbcountry.Text);
                rfid       = Convert.ToString(tbrfid.Text);
                street     = Convert.ToString(tbstreet.Text);
                phoneNr    = Convert.ToInt32(tbphone.Text);
                checkin    = Convert.ToInt32(tbcheckin.Text);
                Pstatus    = Convert.ToInt32(tbstatus.Text);



                //int nrAdded = RDH.AssignTheRFID(rfid, balance, fname);
                // RDH.UpdateRFIDStatus(vistor, rfid);

                int nrAdded = ticketData.AssignTicket(id, balance, lname, fname, email, username, pwd, postcode, street, housenr, city, coutry, phoneNr, ticketType, checkin, Pstatus, rfid);
                if (nrAdded > 0)
                {
                    MessageBox.Show("Succesfully added to the database");
                }
                else
                {
                    MessageBox.Show("Error while BUYING TICKET to the visitor");
                }
            }
        }
Exemplo n.º 2
0
        private void btnProcess_Click(object sender, EventArgs e)
        {
            string  ticketType;
            string  fname;
            decimal balance = 200;
            //Visitor vistor = null;
            string lname;
            int    id = 0;
            string email;
            string city     = null;
            string postcode = null;
            string coutry   = null;
            string username = null;
            string pwd      = null;
            string street   = null;
            int    phoneNr  = 0;
            int    checkin  = 0;
            int    Pstatus  = 0;
            string rfid     = null;
            int    housenr  = 0;


            if (TBCUSID.Text != "")
            {
                id = Convert.ToInt32(TBCUSID.Text);
                //id++;
                ticketType = Convert.ToString(tbticketType.Text);
                //balance = Convert.ToDecimal(TBBALANCE.Text);
                fname = Convert.ToString(TBFNAME.Text);
                lname = Convert.ToString(TBLNAME.Text);
                email = Convert.ToString(tbemail.Text);


                if (FRI.Checked)
                {
                    ticketType = "FRI";
                }
                if (SAT.Checked)
                {
                    ticketType = "SAT";
                }
                if (SUN.Checked)
                {
                    ticketType = "SUN";
                }
                if (FRI.Checked && SAT.Checked)
                {
                    ticketType = "FRI-SAT";
                }
                if (FRI.Checked && SUN.Checked)
                {
                    ticketType = "FRI-SUN";
                }
                if (SAT.Checked && SUN.Checked)
                {
                    ticketType = "SAT-SUN";
                }
                if (FRI.Checked && SAT.Checked && SUN.Checked)
                {
                    ticketType = "FRI-SAT-SUN";
                }


                int nrAdded = ticketData.AssignTicket(id, balance, lname, fname, email, username, pwd, postcode, street, housenr, city, coutry, phoneNr, ticketType, checkin, Pstatus, rfid);
                if (nrAdded > 0)
                {
                    MessageBox.Show("Succesfully added to the database");
                }
                else
                {
                    MessageBox.Show("Error while BUYING TICKET to the visitor");
                }
            }
        }