private void editType_Click(object sender, EventArgs e)
{
var tmp = serviceTypesView.SelectedRows.Count != 0 ? serviceTypesView.SelectedRows[0] : null;
if (tmp == null || tmp.Index == serviceTypesView.Rows.Count - 1)
{
MessageBox.Show("Ничего не выбрано!", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var editForm = new EditServiceTypesForm(tmp)
{
Text = "Редактировать"
};
editForm.ShowDialog();
if (!editForm.IsSaved)
{
return;
}
var type = editForm.ServiceType;
var parameters = new List <SQLiteParameter>()
{
new SQLiteParameter($"@{Db.ServiceTypes.name}", type.Name),
new SQLiteParameter($"@{Db.ServiceTypes.price}", type.Price),
new SQLiteParameter($"@{Db.ServiceTypes.name}1", tmp.Cells[0].Value)
};
DatabaseService.Execute(Db.ServiceTypes.Update, parameters);
ViewData();
}
private void addType_Click(object sender, EventArgs e)
{
var addForm = new EditServiceTypesForm()
{
Text = "Добавить"
};
addForm.ShowDialog();
if (!addForm.IsSaved)
{
return;
}
var type = addForm.ServiceType;
var parameters = new List <SQLiteParameter>()
{
new SQLiteParameter($"@{Db.ServiceTypes.name}", type.Name),
new SQLiteParameter($"@{Db.ServiceTypes.price}", type.Price),
};
DatabaseService.Execute(Db.ServiceTypes.Insert, parameters);
ViewData();
}
