private void Report_Load(object sender, EventArgs e)
{
cmd = "Select BranchID from (Select TOP 1(count(BranchID)) as totalBranch, BranchID from Reservation group by BranchID order by totalBranch desc) as temp";
data.myCommand.CommandText = cmd;
mostBranch = (Guid)data.myCommand.ExecuteScalar();
data.clearParameters();
cmd = "Select Location from Branch where BranchID = @branch";
data.myCommand.Parameters.AddWithValue("branch", mostBranch.ToString());
data.myCommand.CommandText = cmd;
mostLocation = (string)data.myCommand.ExecuteScalar();
MessageBox.Show(mostBranch.ToString());
data.clearParameters();
labelMostBranch.Text = mostLocation;
cmd = "Select max([Total Price]) from Reservation";
data.myCommand.CommandText = cmd;
mostMoney = (decimal)data.myCommand.ExecuteScalar();
labelMostMoney.Text = mostMoney.ToString();
data.clearParameters();
cmd = "Select totalBranch from (Select TOP 1(count(BranchID)) as totalBranch, BranchID from Reservation group by BranchID order by totalBranch desc) as temp";
data.myCommand.CommandText = cmd;
mostReservation = (int)data.myCommand.ExecuteScalar();
labelMostReservation.Text = mostReservation.ToString();
}
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);
}