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"); } } }
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"); } } }