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