private void ClientsForm_Load(object sender, EventArgs e)
{
// TODO: данная строка кода позволяет загрузить данные в таблицу "computerByteDataBaseDataSet2.Clients". При необходимости она может быть перемещена или удалена.
this.clientsTableAdapter.Fill(this.computerByteDataBaseDataSet2.Clients);
gridViewControll.Update(clientsGridView, "Clients");
}
public SaleComputersForm()
{
InitializeComponent();
saleComputers = this;
_viewControll.Update(computersDataGridView, "Computers");
_viewControll.Update(clientsDataGridView, "Clients");
}
private void registrationButton_Click(object sender, EventArgs e)
{
try
{
int discount = Convert.ToInt32(discountTextBox.Text);
string cmdText = $"INSERT INTO Clients ([Фамилия], [Имя], [Отчество], [Адрес], [Паспорт], [Дата регистрации], [Мобильный телефон], [Предоставить скидку], [Предпологаемый месяц], [Средняя зарплата]) VALUES (" +
$"'" + lastNameTextBox.Text + "'," +
" '" + firstNameTextBox.Text + "'," +
" '" + patronymicTextBox.Text + "'," +
" '" + adressTextBox.Text + "'," +
" '" + pasportTextBox.Text + "'," +
" '" + DateTime.Now + "'," +
" '" + phoneTextBox.Text + "'," +
" '" + discount + "'," +
" '" + monthСomboBox.Text + "'," +
" '" + profitTextBox.Text + "')";
new ColculateStatistick().AddClient(int.Parse(profitTextBox.Text));
TableMenager tableMenager = new TableMenager();
tableMenager.ExecuteRequest(cmdText);
DataGridViewControll gridViewControll = new DataGridViewControll();
gridViewControll.Update(DataGrid, "Clients");
MessageBox.Show("Готово!", "Внимание!");
}
catch (Exception)
{
MessageBox.Show("Проверьте введенные данные", "Ошибка");
}
}
public AssortmentForm()
{
InitializeComponent();
pictureBox1.Image = Image.FromFile($@"{Application.StartupPath}\ComputerImages\0.jpeg");
gridViewControll = new DataGridViewControll();
gridViewControll.Update(assortmentTable, "Computers");
}
private void deleteButton_Click(object sender, EventArgs e)
{
try
{
string request = $@"Delete * From Employees WHERE код = {employeesDataGridView[0, SelectRow].Value}";
new TableMenager().ExecuteRequest(request);
gridViewControll.Update(employeesDataGridView, "Employees");
}
catch (Exception)
{
MessageBox.Show("Нельзя удалить", "Внимание!");
}
}
private void update_Click(object sender, EventArgs e)
{
gridViewControll.Update(assortmentTable, "Computers");
}
private void AddingComputerForm_FormClosed(object sender, FormClosedEventArgs e)
{
DataGridViewControll gridViewControll = new DataGridViewControll();
gridViewControll.Update(AssortmentDataGrid, "Computers");
}
