private void radButton4_Click(object sender, EventArgs e) { Form4 f4 = new Form4(); HANO.userType = HANO.SqlQueryScalarLogIn("SELECT type FROM login WHERE username='******' and password='******'"); if (HANO.userType == "") { return; } HANO.userID = int.Parse(HANO.SqlQueryExec("SELECT userID FROM login WHERE username='******'").Rows[0][0].ToString()); DataTable dt = HANO.SqlQueryExec("SELECT First_Name,Last_Name,locationID,email,Phone_Number FROM person WHERE loginID = '" + HANO.userID + "'"); try { HANO.userFName = dt.Rows[0][0].ToString(); HANO.userLName = dt.Rows[0][1].ToString(); HANO.mail = dt.Rows[0][3].ToString(); HANO.number = dt.Rows[0][4].ToString(); loc = dt.Rows[0][2].ToString(); } catch (Exception err) { print(err.Message); } dt = HANO.SqlQueryExec("SELECT country,city,street FROM location WHERE locationID = " + loc + ""); try { HANO.country = dt.Rows[0][0].ToString(); HANO.city = dt.Rows[0][1].ToString(); HANO.street = dt.Rows[0][2].ToString(); } catch (Exception err) { print(err.Message); } switch (HANO.userType) { case "admin": HANO.msg("Welcome Back, " + HANO.userFName + "!", "You are logged in as an ADMIN"); //(new Form2()).Show(); break; case "passenger": HANO.msg("Welcome Back, " + HANO.userFName + "!", "You are logged in as a Passenger"); //(new Form6()).Show(); break; case "employee": HANO.msg("Welcome Back, " + HANO.userFName + "!", "You are logged in as an Employee"); //(new Form5()).Show(); break; default: { HANO.msg("Error logging in!", "Wrong Username or Password.\nTry again.\nIf you are a new user, you can create a new account now for free!"); return; } } this.Close(); f4.StartPosition = FormStartPosition.CenterScreen; f4.Show(); }
private void radButton6_Click_1(object sender, EventArgs e) { int userId; SqlConnection conn = new SqlConnection(HANO.projConn); SqlCommand cmd = new SqlCommand("addUser", conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param; param = cmd.Parameters.Add("@fname", SqlDbType.VarChar, 20); param.Value = radTextBox3.Text; param = cmd.Parameters.Add("@lname", SqlDbType.VarChar, 20); param.Value = radTextBox4.Text; param = cmd.Parameters.Add("@bdate", SqlDbType.Date); param.Value = radDateTimePicker1.Value; param = cmd.Parameters.Add("@gender", SqlDbType.VarChar, 7); param.Value = (radCheckBox1.Checked?"Male":"Female"); param = cmd.Parameters.Add("@mail", SqlDbType.NVarChar, 50); param.Value = ok?radTextBox5.Text :""; param = cmd.Parameters.Add("@number", SqlDbType.BigInt); param.Value = ok ? 0: (Convert.ToUInt32(radTextBox5.Text)); param = cmd.Parameters.Add("@username", SqlDbType.VarChar, 30); param.Value = radTextBox6.Text; param = cmd.Parameters.Add("@pass", SqlDbType.VarChar, 30); param.Value = radTextBox7.Text; param = cmd.Parameters.Add("@type", SqlDbType.VarChar, 10); param.Value = "passenger"; param = cmd.Parameters.Add("@country", SqlDbType.VarChar, 50); param.Value = radTextBox8.Text; param = cmd.Parameters.Add("@city", SqlDbType.VarChar, 50); param.Value = radTextBox9.Text; param = cmd.Parameters.Add("@street", SqlDbType.VarChar, 50); param.Value = radTextBox10.Text; // Add the output parameter. param = cmd.Parameters.Add("@logID", SqlDbType.Int); param.Direction = ParameterDirection.Output; // Execute the command. conn.Open(); try { //print("start"); cmd.ExecuteScalar(); //print("end"); } catch (SqlException err) { print(err.Message); } userId = int.Parse(param.Value.ToString()); if (userId > 0) { //print("Your user ID is" + param.Value); HANO.userID = userId; HANO.userFName = radTextBox3.Text; HANO.userLName = radTextBox4.Text; HANO.userType = "passenger"; HANO.country = radTextBox8.Text; HANO.city = radTextBox9.Text; HANO.street = radTextBox10.Text; HANO.mail = ok ? radTextBox5.Text : ""; HANO.number = ok ? "" : radTextBox5.Text; Close(); Form4 f4 = new Form4(); f4.StartPosition = FormStartPosition.CenterScreen; f4.Show(); } else if (userId == -1) { RadMessageBox.Show("Username already exists.\nGo back and change it then try again", "Change your username.", MessageBoxButtons.OK, RadMessageIcon.Exclamation); } conn.Close(); }