private void ButtonAdd_Click(object sender, RoutedEventArgs e)
{
if (TextBoxProjCount.Text == string.Empty)
{
Driver dr = new Driver(TextBoxName.Text, Convert.ToInt32(TextBoxAge.Text), Convert.ToInt32(TextBoxSNN.Text), TextBoxCarType.Text, Convert.ToInt32(TextBoxHours.Text));
OleDbCommand insert = new OleDbCommand("INSERT INTO drivers (`SNN`, `DrName`, `Age`, `CarType`, `Hours`) VALUES (@snn, @drName, @age, @carType, @hours)", con);
insert.Parameters.AddWithValue("@snn", dr.Snn);
insert.Parameters.AddWithValue("@drName", dr.Name);
insert.Parameters.AddWithValue("@age", dr.Age);
insert.Parameters.AddWithValue("@carType", dr.CarType);
insert.Parameters.AddWithValue("@hours", dr.Hours);
con.Open();
insert.ExecuteNonQuery();
con.Close();
Workers.Add(dr);
MessageBox.Show("Добавили \n" + dr.Name);
ClearTextBoxes();
}
else
{
// вставить код для добавления менеджера
}
}
private static void ShowList()
{
Worker[] workers = new Worker[5];
workers[0] = new Driver("John", 27, 6435, "BMW", 256);
workers[1] = new Manager("Hulk", 25, 465138, 25);
workers[2] = new Manager("Helena", 25, 478656, 12);
workers[3] = new Driver("Jason", 45, 46513, "BMW", 256);
workers[4] = new Manager("Mary", 27, 461577, 15);
List<Worker> list = new List<Worker>();
list.AddRange(workers);
list.Insert(0, new Manager("Jenny", 25, 55431, 45));
list.Reverse();
foreach (Worker item in list)
{
item.Print();
}
List<int> list2 = new List<int>();
}
private void ButtonUpdate_Click(object sender, RoutedEventArgs e)
{
if (TextBoxProjCount.Text == string.Empty)
{
Driver dr = new Driver(TextBoxName.Text, Convert.ToInt32(TextBoxAge.Text), Convert.ToInt32(TextBoxSNN.Text), TextBoxCarType.Text, Convert.ToInt32(TextBoxHours.Text));
WorkersDataSetTableAdapters.driversTableAdapter drivers = new WorkersDataSetTableAdapters.driversTableAdapter();
con.Open();
drivers.UpdateBySNNQuery(dr.Snn, dr.Name, dr.Age, dr.CarType, dr.Hours, dr.Snn);
con.Close();
MessageBox.Show("Добавили \n" + dr.Name);
ClearTextBoxes();
}
else
{
// вставить код для добавления менеджера
}
}
