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(); }