public ManagerClientsForm()
{
InitializeComponent();
ControlClients CtrlClients = new ControlClients();
comboBoxClients.DataSource = CtrlClients.ClientsToList(CtrlClients.Clients);
}
public void AddClientToDB(ControlClients CtrlClients, int ClientId, string LastName, string FirstName, string SecondName, string PhoneNumber, string Email)
{
Connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\user\Documents\Visual Studio 2015\Projects\EduCentre\EdCentre.accdb;
Persist Security Info=False;";
try
{
Connection.Open();
OleDbCommand CommandInsert = new OleDbCommand();
CommandInsert.Connection = Connection;
CommandInsert.CommandText = "INSERT INTO clients(last_name, first_name, second_name, phone_number, email) values('" + LastName + "', '" + FirstName + "', '" + SecondName + "', '" + PhoneNumber + "', '" + Email + "')";
CommandInsert.ExecuteNonQuery();
Client NewClient = new Client(ClientId, LastName, FirstName, SecondName, PhoneNumber, Email);
CtrlClients.Clients.Add(NewClient);
MessageBox.Show("Клиент добавлен");
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex);
}
Connection.Close();
}