private void metroTile5_Click(object sender, EventArgs e)
{
distributerid = metroTextBox3.Text;
TMSQuerry qp = new TMSQuerry();
qp.DeleteDistributerRecord(distributerid);
DisplayData();
ClearData();
}
private void metroTile2_Click(object sender, EventArgs e)
{
m_id = metroTextBox3.Text;
status = metroComboBox1.Text;
TMSQuerry qp = new TMSQuerry();
qp.UpdateMaintenanceRecord(m_id, status);
DisplayData();
ClearData();
}
private void metroTile4_Click(object sender, EventArgs e)
{
fare = metroTextBox2.Text;
stop = metroTextBox3.Text;
TMSQuerry qp = new TMSQuerry();
qp.UpdateRoutesRecord(fare, stop);
DisplayData();
ClearData();
}
private void metroTile2_Click(object sender, EventArgs e)
{
driver = metroTextBox4.Text;
license = metroTextBox1.Text;
contact = metroTextBox5.Text;
salary = metroTextBox7.Text;
driverid = metroTextBox3.Text;
TMSQuerry qp = new TMSQuerry();
qp.AddDriver(driver, license, contact, salary, driverid);
ClearData();
}
private void metroTile2_Click(object sender, EventArgs e)
{
distributer = metroTextBox4.Text;
contact = metroTextBox5.Text;
salary = metroTextBox7.Text;
distributerid = metroTextBox3.Text;
TMSQuerry qp = new TMSQuerry();
qp.UpdateDistributerRecord(distributer, contact, salary, distributerid);
DisplayData();
ClearData();
}
private void metroTile2_Click(object sender, EventArgs e)
{
cname = metroTextBox4.Text;
contact = metroTextBox1.Text;
cartype = metroComboBox2.Text;
from = metroTextBox2.Text;
to = metroTextBox5.Text;
date = metroDateTime1.Text;
fare = metroTextBox6.Text;
TMSQuerry qp = new TMSQuerry();
qp.AddPNDReservation(cname, contact, cartype, from, to, date, fare);
ClearData();
}
private void metroTile1_Click(object sender, EventArgs e)
{
distributer = metroTextBox5.Text.ToString();
transport = metroTextBox4.Text.ToString();
from = metroComboBox2.Text.ToString();
to = metroComboBox1.Text.ToString();
stop = metroTextBox6.Text.ToString();
date = metroDateTime1.Value.ToShortDateString();
TMSQuerry qp = new TMSQuerry();
qp.ReserveTicket(distributer, transport, from, to, stop, date);
metroTextBox5.Text = "";
metroTextBox4.Text = "";
metroComboBox2.Text = "";
metroComboBox1.Text = "";
metroTextBox6.Text = "";
metroDateTime1.Text = "";
}