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