Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using MySql.Data.MySqlClient;
- namespace KusovayaDatabase
- {
- public partial class Form1 : Form
- {
- public static int count = 0;
- string connStr = "server=localhost;user=root;database=SportClub;password=423002;SslMode=none";
- public string SelectedTable { get => comboBox1.SelectedItem.ToString(); }
- MySqlConnection conn;
- Database Database;
- public Form1()
- {
- InitializeComponent();
- conn = new MySqlConnection(connStr);
- conn.Open();
- Database = new Database("SportClub", conn);
- Database.Donwload();
- foreach (var table in Database.Tables.Keys)
- comboBox1.Items.Add(table);
- comboBox1.SelectedItem = Database.Tables.Keys.First();
- Database.Tables[SelectedTable].Show(dataGridView1);
- Database.Tables["Абонементы"].AddConstraint("Код_зала", "Залы", "Код_зала");
- Database.Tables["Клиенты"].AddConstraint("Код_тренера", "Тренеры", "Код_тренера");
- Database.Tables["Учет"].AddConstraint("Код_клиента", "Клиенты", "Код_клиента");
- Database.Tables["Учет"].AddConstraint("Код_абонемента", "Абонементы", "Код_абонемента");
- }
- private void comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
- {
- var name = comboBox1.SelectedItem.ToString();
- if (Database.Tables.ContainsKey(name))
- Database.Tables[name].Show(dataGridView1);
- }
- private void Form1_FormClosed(object sender, FormClosedEventArgs e)
- {
- foreach (var table in Database.Tables.Values)
- table.Save();
- conn.Close();
- Dispose();
- }
- private void Create_Click(object sender, EventArgs e)
- {
- Database.Tables[SelectedTable].Create(dataGridView1);
- }
- private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
- {
- var value = dataGridView1[e.ColumnIndex, e.RowIndex].Value ?? String.Empty;
- var succeed = Database.Tables[SelectedTable].Edit(e.ColumnIndex, e.RowIndex, value.ToString());
- if (!succeed)
- {
- dataGridView1[e.ColumnIndex, e.RowIndex].Value = Database.Tables[SelectedTable].Records[e.RowIndex][e.ColumnIndex];
- var message = Database.Tables[SelectedTable].Columns[e.ColumnIndex].ToString();
- MessageBox.Show("Введены неверные данные, ожидалось " + message, "Неверный ввод", MessageBoxButtons.OK);
- }
- }
- private void Delete_Click(object sender, EventArgs e)
- {
- var cells = dataGridView1.SelectedCells;
- if (cells.Count == 1)
- dataGridView1.Rows[cells[0].RowIndex].Selected = true;
- var rows = dataGridView1.SelectedRows;
- if (rows.Count == 0)
- return;
- var message = new StringBuilder("Вы уверены, что хотите удалить следующую запись?\r\n");
- message.AppendLine(Database.Tables[SelectedTable].Records[rows[0].Index].ToString());
- var result = MessageBox.Show(message.ToString(), "Удаление", MessageBoxButtons.YesNo);
- if (result == DialogResult.No)
- return;
- Database.Tables[SelectedTable].Delete(rows[0].Index);
- dataGridView1.Rows.Remove(rows[0]);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement