private void editClient_Click(object sender, EventArgs e) { var isPhys = title == Db.PClients.title; var view = (isPhys) ? phisView : legalView; var tmp = view.SelectedRows.Count != 0 ? view.SelectedRows[0] : null; if (tmp == null || tmp.Index == view.Rows.Count - 1) { MessageBox.Show("Ничего не выбрано!", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var editForm = new EditClientsForm(isPhys, tmp) { Text = "Редактировать" }; editForm.ShowDialog(); if (!editForm.IsSaved) { return; } List <SQLiteParameter> parameters = new List <SQLiteParameter>(); if (isPhys) { var phys = editForm.pClient; parameters.Add(new SQLiteParameter($"@{Db.PClients.surname}", phys.Surname)); parameters.Add(new SQLiteParameter($"@{Db.PClients.name}", phys.Name)); parameters.Add(new SQLiteParameter($"@{Db.PClients.patronymic}", phys.Patronymic)); parameters.Add(new SQLiteParameter($"@{Db.Clients.address}", phys.Address)); parameters.Add(new SQLiteParameter($"@{Db.Clients.mobile}", phys.Mobile)); parameters.Add(new SQLiteParameter($"@{Db.Clients.email}", phys.Email)); parameters.Add(new SQLiteParameter($"@{Db.PClients.surname}1", tmp.Cells[0].Value)); parameters.Add(new SQLiteParameter($"@{Db.PClients.name}1", tmp.Cells[1].Value)); parameters.Add(new SQLiteParameter($"@{Db.PClients.patronymic}1", tmp.Cells[2].Value)); DatabaseService.Execute(Db.PClients.Update, parameters); } else { var legal = editForm.lClient; parameters.Add(new SQLiteParameter($"@{Db.PClients.name}", legal.Name)); parameters.Add(new SQLiteParameter($"@{Db.Clients.address}", legal.Address)); parameters.Add(new SQLiteParameter($"@{Db.Clients.mobile}", legal.Mobile)); parameters.Add(new SQLiteParameter($"@{Db.Clients.email}", legal.Email)); parameters.Add(new SQLiteParameter($"@{Db.PClients.name}1", tmp.Cells[0].Value)); DatabaseService.Execute(Db.LClients.Update, parameters); } viewData(); }
private void addClient_Click(object sender, EventArgs e) { var isPhys = title == Db.PClients.title; var addForm = new EditClientsForm(isPhys) { Text = "Добавить" }; addForm.ShowDialog(); if (!addForm.IsSaved) { MessageBox.Show("Данные не сохранены!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (isPhys) { var phys = addForm.pClient; var parameters = new List <SQLiteParameter>() { new SQLiteParameter($"@{Db.PClients.surname}", phys.Surname), new SQLiteParameter($"@{Db.PClients.name}", phys.Name), new SQLiteParameter($"@{Db.PClients.patronymic}", phys.Patronymic), new SQLiteParameter($"@{Db.Clients.address}", phys.Address), new SQLiteParameter($"@{Db.Clients.mobile}", phys.Mobile), new SQLiteParameter($"@{Db.Clients.email}", phys.Email) }; DatabaseService.Execute(Db.PClients.Insert, parameters); } else { var legal = addForm.lClient; var parameters = new List <SQLiteParameter>() { new SQLiteParameter($"@{Db.LClients.name}", legal.Name), new SQLiteParameter($"@{Db.Clients.address}", legal.Address), new SQLiteParameter($"@{Db.Clients.mobile}", legal.Mobile), new SQLiteParameter($"@{Db.Clients.email}", legal.Email) }; DatabaseService.Execute(Db.LClients.Insert, parameters); } viewData(); }