private void filterButton_Click(object sender, EventArgs e) { cmd = "Select* from Car where VehicleID = @carID"; data.myCommand.Parameters.AddWithValue("carID", vehicleID); try { data.query(cmd); //dataRead = dataCommand.ExecuteReader(); carData.DataSource = null; carData.Rows.Clear(); while (data.myReader.Read()) { carData.Rows.Add(data.myReader["VehicleID"].ToString(), data.myReader["Color"].ToString(), data.myReader["Model"].ToString(), data.myReader["Make"].ToString(), data.myReader["Status"].ToString(), data.myReader["Type of Vehicle"].ToString(), data.myReader["UserID"].ToString()); } data.myReader.Close(); //dataCommand.Parameters.Clear(); data.clearParameters(); } catch (Exception e3) { MessageBox.Show(e3.ToString(), "Error"); //dataRead.Close(); // Close(); } }
private void clientRentals_Load(object sender, EventArgs e) { cmd = "Select UserID from users where users.username = @theUsername"; data.myCommand.CommandText = cmd; data.myCommand.Parameters.AddWithValue("theUsername", data.usr); Guid user = (Guid)data.myCommand.ExecuteScalar(); data.clearParameters(); cmd = "Select * from Reservation where Reservation.UserID = @username"; data.myCommand.Parameters.AddWithValue("username", user.ToString()); try { data.query(cmd); //dataRead = dataCommand.ExecuteReader(); reservationData.DataSource = null; reservationData.Rows.Clear(); while (data.myReader.Read()) { reservationData.Rows.Add(data.myReader["ReservationID"].ToString(), data.myReader["Start date"].ToString(), data.myReader["End date"].ToString(), data.myReader["Total Price"].ToString(), data.myReader["BranchID"].ToString(), data.myReader["VehicleID"].ToString(), data.myReader["UserID"].ToString()); } data.myReader.Close(); //dataCommand.Parameters.Clear(); data.clearParameters(); } catch (Exception e3) { MessageBox.Show(e3.ToString(), "Error"); data.myReader.Close(); //dataRead.Close(); // Close(); } // TODO: This line of code loads data into the '_291GroupProjectDataSetReservation.Reservation' table. You can move, or remove it, as needed. this.reservationTableAdapter.Fill(this._291GroupProjectDataSetReservation.Reservation); }
private void updateButton_Click(object sender, EventArgs e) { // First check if Phone text boxes were changed /* * Obtains all necessary/changed fields to update the information of the user */ if (phoneFlag) { string Phone = Phone1.Text + Phone2.Text + Phone3.Text; if (!parameters.ContainsKey("Users.[Phone]")) { parameters.Add("Users.[Phone]", "@Phone"); } } else if (!phoneFlag && parameters.ContainsKey("Users.[Phone]")) { parameters.Remove("Users.[Phone]"); } string cmd = "UPDATE Users SET "; if (parameters.Count > 0) { foreach (KeyValuePair <string, string> param in parameters) { cmd = cmd + param.Key + " = " + param.Value + ", "; switch (param.Value) { case ("@First"): datab.myCommand.Parameters.AddWithValue("First", firstTBox.Text); break; case ("@Last"): datab.myCommand.Parameters.AddWithValue("Last", lastTBox.Text); break; case ("@Address"): datab.myCommand.Parameters.AddWithValue("Address", addressTBox.Text); break; case ("@Phone"): datab.myCommand.Parameters.AddWithValue("Phone", Phone); break; case ("@Credit"): datab.myCommand.Parameters.AddWithValue("Credit", CreditTBox.Text); break; } } int lastComma = cmd.LastIndexOf(", "); cmd = cmd.Remove(lastComma); cmd = cmd + " WHERE Users.username=@User"; try { datab.myCommand.Parameters.AddWithValue("User", datab.usr); if (datab.myConnection.State == ConnectionState.Closed) { datab.myConnection.Open(); } datab.query(cmd); MessageBox.Show("Fields were Changed, Please Exit and Enter to view changes", "ALERT"); datab.myCommand.Parameters.Clear(); // call on Load reload = true; ReloadForm(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "ERROR"); } } else { // if no fields were changed, do nothing MessageBox.Show("NOTE: No fields were changed", "ALERT"); } }