private void toolStripBtAddRepair_Click(object sender, EventArgs e)
{
if (tbSurnameDriver.Text == "" || tbNameDriver.Text == "" || tbPatronimycDriver.Text == "" ||
tbBrandCar.Text == "" || tbModelCar.Text == "" || cbYearCreated.Text == "" ||
tbNumberSTSCar.Text == "")
{
MessageBox.Show("Сначала заполните/сохраните информацию о клиенте", "Ошибка");
return;
}
FormAddRepairForCurrentClient farfcc = new FormAddRepairForCurrentClient(db);
farfcc.ShowDialog();
if (StaticData.DataBufferNameRepair != null && StaticData.DataBufferEmployee != null)
{
if (clbRepairs.Items.Contains(StaticData.DataBufferNameRepair))
{
DialogResult dialogResult = MessageBox.Show("Вы уверены что хотите добавить уже запланированную ремонтную работу ещё раз?", "Подтверждение", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.No)
{
return;
}
}
//Обновление списка работ после закрытия дочерней формы
clbRepairs.Items.Add(StaticData.DataBufferNameRepair);
lbEmployeesRepairs.Items.Add(StaticData.DataBufferEmployee);
db.SearchCostRepairs(StaticData.DataBufferNameRepair, lbRepairsCosts);
int totalCost = 0;
for (int i = 0; i < lbRepairsCosts.Items.Count; i++)
{
totalCost += Convert.ToInt32(lbRepairsCosts.Items[i].ToString());
}
lbRepairsTotalCost.Text = "Итоговая\nстоимость:\n" + totalCost + " рублей";
string[] strEmployee = lbEmployeesRepairs.Items[lbEmployeesRepairs.Items.Count - 1].ToString().Split(new char[] { ' ' });
int idEmployee = Convert.ToInt32(strEmployee[strEmployee.Length - 1]);
string factQuery;
factQuery = "(`work_hours_id_work_hours`, `repairs_id_repair`, `clients_id_client`, `time_start`, `status_repair`) VALUES('" +
db.SearchIdWorkHours(idEmployee, DateTime.Today.ToString("yyyy-MM-dd")) + "', '" +
db.SearchIdRepairs(clbRepairs.Items[clbRepairs.Items.Count - 1].ToString()) +
"', '" + idClient + "', '" + timeStartRepair + "', 'Не выполнено');";
db.Add("current_repairs", factQuery);
idCurrentRepairs.Add(db.LastIDCurrentRepairs());//Добавляем ID работы в список Id работ по клиенту
toolStripProgressBarStatusRepairs.Maximum = clbRepairs.Items.Count;
toolStripProgressBarStatusRepairs.Value = clbRepairs.CheckedItems.Count;
}
}
private void btAdd_Click(object sender, EventArgs e)
{
string factQuery;
if (tbSurname.Text == "" || tbName.Text == "" || tbPatronimyc.Text == "" || tbPhone.Text == "" || cbNumSTS.Text == "")
{
MessageBox.Show("Заполните все поля!", "Ошибка");
}
else
{
if (!edit)
{
factQuery = "(surname, name, patronimyc, phone_number, cars_number_sts) VALUES('" +
tbSurname.Text + "', '" + tbName.Text + "', '" + tbPatronimyc.Text + "', '" +
tbPhone.Text.Replace(" ", "").Replace("(", "").Replace(")", "") + "', '" + cbNumSTS.Text + "');";
db.Add("clients", factQuery);
}
else
{
factQuery = "surname = '" + tbSurname.Text + "', name = '" + tbName.Text + "', " +
"patronimyc = '" + tbPatronimyc.Text + "', phone_number = '" +
tbPhone.Text.Replace(" ", "").Replace("(", "").Replace(")", "") +
"', cars_number_sts = '" + cbNumSTS.Text + "'";
db.Edit("clients", "id_client", idClient, factQuery);
}
Hide();
}
}