private void btAdd_Click(object sender, EventArgs e)
{
FormAddCar fAdd = new FormAddCar();
fAdd.ShowDialog();
dataGridView1.Rows.Clear();
db.LoadTables("cars", dataGridView1);
}
public FormRequests()
{
InitializeComponent();
db = new ClassDB();
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].HeaderCell.Value = "ID заявки";
dataGridView1.Columns[1].HeaderCell.Value = "Категория";
dataGridView1.Columns[2].HeaderCell.Value = "ID клиента";
dataGridView1.Columns[3].HeaderCell.Value = "Описание";
db.LoadTables("requests", dataGridView1);
}
public FormCars()
{
InitializeComponent();
dataGridView1.ColumnCount = 5;
dataGridView1.Columns[0].HeaderCell.Value = "СТС";
dataGridView1.Columns[1].HeaderCell.Value = "Марка";
dataGridView1.Columns[2].HeaderCell.Value = "Модель";
dataGridView1.Columns[3].HeaderCell.Value = "Год выпуска";
dataGridView1.Columns[4].HeaderCell.Value = "Дата последнего ТО";
db = new ClassDB();
db.LoadTables("cars", dataGridView1);
}
public FormPicClient()
{
InitializeComponent();
db = new ClassDB();
dataGridView1.ColumnCount = 6;
dataGridView1.Columns[0].HeaderCell.Value = "ID Клиента";
dataGridView1.Columns[1].HeaderCell.Value = "Фамилия";
dataGridView1.Columns[2].HeaderCell.Value = "Имя";
dataGridView1.Columns[3].HeaderCell.Value = "Отчество";
dataGridView1.Columns[4].HeaderCell.Value = "Мобильный телефон";
dataGridView1.Columns[5].HeaderCell.Value = "Номер СТС машины";
db.LoadTables("clients", dataGridView1);
}
public FormEmployees()
{
InitializeComponent();
db = new ClassDB();
dataGridView1.ColumnCount = 6;
dataGridView1.Columns[0].HeaderCell.Value = "ID сотрудника";
dataGridView1.Columns[1].HeaderCell.Value = "Фамилия";
dataGridView1.Columns[2].HeaderCell.Value = "Имя";
dataGridView1.Columns[3].HeaderCell.Value = "Отчество";
dataGridView1.Columns[4].HeaderCell.Value = "Мобильный телефон";
dataGridView1.Columns[5].HeaderCell.Value = "Должность";
db.LoadTables("employees", dataGridView1);
}
private void btDelete_Click(object sender, EventArgs e)
{
db.Delete("`requests`", "id_request", dataGridView1);
dataGridView1.Rows.Clear();
db.LoadTables("requests", dataGridView1);
}