}//GridRefresh
private void GridLocalRefresh()
{
string sql = "SELECT objectId, policyName, policyDescription, policyDiscounts FROM net_list_policys WHERE objectId IN (" + BaseConnectString.GetIds() + ") AND objectType = 140 AND objectStatus = 150;";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
command = new MySqlCommand(sql, connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dataGridView2.Rows.Add(reader["objectId"].ToString(), reader["policyName"].ToString(),
reader["policyDescription"].ToString(), reader["policyDiscounts"].ToString());
}
}
}
private void BaseConnectForm_Load(object sender, EventArgs e)
{
string connectString = "SELECT * FROM Connection;";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
command = new MySqlCommand(connectString, connection);
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
BaseServerNameTextBox.Text = reader["ServerName"].ToString();
BaseUserNameTextBox.Text = reader["UserName"].ToString();
BaseNameTextBox.Text = reader["DbName"].ToString();
BasePortTextBox.Text = reader["Port"].ToString();
BasePasswordTextBox.Text = reader["Password"].ToString();
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
DataGridViewRow selectedRow = dataGridView1.SelectedRows[0];
connection.Open();
string updateUser = "******" + LoginTextBox.Text + ", " +
"Password = "******", " +
"Privileges = " + checkBox1.Checked + " " +
"WHERE Login = "******" AND " +
"Password = "******" AND " +
"Privileges = " + bool.Parse(selectedRow.Cells[2].Value.ToString()) + ";";
MySqlCommand command = new MySqlCommand(updateUser, connection);
command.ExecuteNonQuery();
}
dataGridView1.Enabled = true;
AddButton.Enabled = true;
ChangeButton.Enabled = true;
DeleteButton.Enabled = true;
SaveButton.Enabled = false;
dataGridView1.Rows.Clear();
ControlsClear();
GridRefresh();
}
private void GridRefresh()
{
string sql = "SELECT Login, Password, Privileges FROM Users;";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
finally
{
}
MySqlCommand command = new MySqlCommand(sql, connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dataGridView1.Rows.Add(reader["Login"].ToString(), reader["Password"].ToString(),
reader["Privileges"].ToString());
}
}
}
private void FirmBindDeleteButton_Click(object sender, EventArgs e)
{
//for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
//{
//}
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
foreach (DataGridViewRow row in dataGridView2.SelectedRows)
{
string deleteRow = "DELETE FROM policys WHERE policyId = " + row.Cells[0].Value.ToString() + ";";
command = new MySqlCommand(deleteRow, connection);
command.ExecuteNonQuery();
}
}
dataGridView2.Rows.Clear();
GridLocalRefresh();
}
private void FimrBindAddButton_Click(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
string insertRow = "INSERT policys (policyId) VALUES (" + row.Cells[0].Value.ToString() + ");";
command = new MySqlCommand(insertRow, connection);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
if (ex.Message.Contains("Duplicate entry"))
{
MessageBox.Show("Объект уже добален");
}
}
}
}
dataGridView2.Rows.Clear();
GridLocalRefresh();
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(false)))
{
MySqlCommand command;
MySqlDataReader reader;
try
{
connection.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("Проверьте подключение к базе и перезапустите программу.");
return;
}
string baseCreate = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'cardlocal'";
command = new MySqlCommand(baseCreate, connection);
reader = command.ExecuteReader();
if (!reader.Read())
{
Application.Run(new Enter());
}
else
{
Application.Run(new AuthorizationForm(false));
}
}
}
public static string GetIds()
{
MySqlCommand command;
string ids = "";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return("-1");
}
string getPolicysId = "SELECT * FROM Policys";
command = new MySqlCommand(getPolicysId, connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ids += reader["policyId"].ToString() + ',';
}
ids = ids.TrimEnd(',');
if (ids == "")
{
ids = "-1";
}
}
return(ids);
}
private void DisplayLocalFirm()
{
string localFirm = "SELECT firmName, firmNameExt FROM Firms;";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
MySqlCommand command = new MySqlCommand(localFirm, connection);
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
firmNameTextBox.Text = reader[0].ToString();
firmNameExtTextBox.Text = reader[1].ToString();
reader.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (KeyTextBox.Text != BaseConnectString.GetLocalConnetion())
{
Close();
}
else
{
new AuthorizationForm(true).Show();
}
}
private void BaseConnetionSaveButton_Click(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
string checkConnetion = "SELECT * FROM Connection";
command = new MySqlCommand(checkConnetion, connection);
MySqlDataReader reader = command.ExecuteReader();
string insertConnetion;
if (!reader.Read())
{
insertConnetion = "INSERT Connection(ServerName, UserName, DbName, Port, Password)" +
"VALUES" +
"('" + BaseServerNameTextBox.Text + "'," +
"'" + BaseUserNameTextBox.Text + "'," +
"'" + BaseNameTextBox.Text + "'," +
"'" + BasePortTextBox.Text + "'," +
"'" + BasePasswordTextBox.Text + "');";
reader.Close();
command = new MySqlCommand(insertConnetion, connection);
command.ExecuteNonQuery();
}
else
{
string connectUpdate = "UPDATE Connection SET " +
"ServerName ='" + BaseServerNameTextBox.Text + "', " +
"UserName ='******', " +
"DbName ='" + BaseNameTextBox.Text + "', " +
"Port ='" + BasePortTextBox.Text + "', " +
"Password ='******';";
reader.Close();
command = new MySqlCommand(connectUpdate, connection);
command.ExecuteNonQuery();
}
}
Close();
}
private void GridRefresh()
{
string sql = "SELECT objectId, policyName, policyDescription, policyDiscounts FROM net_list_policys WHERE objectType = 140 AND objectStatus = 150";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
finally
{
}
adapter = new MySqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
switch (i)
{
case 1:
dataGridView1.Columns[i].HeaderText = "Название";
break;
case 2:
dataGridView1.Columns[i].HeaderText = "Описание";
break;
case 3:
dataGridView1.Columns[i].HeaderText = "Скидки";
break;
default:
dataGridView1.Columns[i].Visible = false;
break;
}
}
}
}//GridRefresh
private void GridRefresh()
{
string sql = "SELECT objectId, firmName, firmNameExt FROM net_list_card_firms WHERE objectType = 140 AND objectStatus = 150";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
finally
{
}
MySqlDataAdapter adapter = new MySqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
switch (i)
{
case 1:
dataGridView1.Columns[i].HeaderText = "Имя";
dataGridView1.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
break;
case 2:
dataGridView1.Columns[i].HeaderText = "Дополнительно";
dataGridView1.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
break;
default:
dataGridView1.Columns[i].Visible = false;
break;
}
}
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
DataGridViewRow selectedRow = dataGridView1.SelectedRows[0];
connection.Open();
string updateUser = "******" +
"WHERE Login = '******' AND " +
"Password = '******' AND " +
"Privileges = " + bool.Parse(selectedRow.Cells[2].Value.ToString()) + ";";
MySqlCommand command = new MySqlCommand(updateUser, connection);
command.ExecuteNonQuery();
}
dataGridView1.Rows.Clear();
ControlsClear();
GridRefresh();
}
private void AddButton_Click(object sender, EventArgs e)
{
if (LoginTextBox.Text != "" && PasswordTextBox.Text != "")
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
connection.Open();
string addUser = "******" +
"VALUES('" + LoginTextBox.Text + "', '" + PasswordTextBox.Text + "', " + checkBox1.Checked + ");";
MySqlCommand command = new MySqlCommand(addUser, connection);
command.ExecuteNonQuery();
}
}
else
{
MessageBox.Show("Заполните поля!");
return;
}
dataGridView1.Rows.Clear();
GridRefresh();
ControlsClear();
}
private void ChangeButton_Click_1(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
string insertRow = "UPDATE Firms SET firmId = " + row.Cells[0].Value.ToString() + ", firmName = '" + row.Cells[1].Value.ToString() + "', firmNameExt = '" + row.Cells[2].Value.ToString() + "';";
MySqlCommand command = new MySqlCommand(insertRow, connection);
command.ExecuteNonQuery();
}
}
DisplayLocalFirm();
}
private void CardNumberButtonSearch_Click(object sender, EventArgs e)
{
if (CardNumberTextBox.Text == "")
{
MessageBox.Show("Введите номер карты");
return;
}
else if (CardNumberTextBox.Text.Length < 6)
{
CardNumberTextBox.Text = CardNumberTextBox.Text.PadLeft(6, '0');
}
string checkCard = "SELECT holderId, objectId FROM net_list_cards WHERE objectType = 140 AND objectStatus = 150 AND cardSerial = '" + CardNumberTextBox.Text + "';";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch (Exception ex)
{
MessageBox.Show("Хъюстон, у нас проблемы!");
return;
}
MySqlCommand command = new MySqlCommand(checkCard, connection);
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
cardObjectId = reader.GetInt32("objectId");
if (reader.GetInt32("holderId") != 0)
{
string getHolderData =
"SELECT cardHold.holderName, cardHold.comments, cards.objectId, cardHold.holderSex, firms.firmName, cards.holderId, cardHold.holderEmail, cardHold.holderBirthday, cardHold.holderPhone, cards.cardSerial " +
"FROM net_list_cards AS cards, net_list_card_firms AS firms, net_list_card_holders AS cardHold " +
"WHERE firms.objectId = cardHold.firmId AND cardHold.objectType = 140 AND cards.holderId = cardHold.objectId AND cards.objectType = 140 AND " +
"cards.cardSerial = '" + CardNumberTextBox.Text + "';";
reader.Close();
command = new MySqlCommand(getHolderData, connection);
reader = command.ExecuteReader();
reader.Read();
CardFIOTextBox.Text = reader["holderName"].ToString();
CardPhoneTextBox.Text = reader["holderPhone"].ToString();
CardEmailTextBox.Text = reader["holderEmail"].ToString();
CardFirmTextBox.Text = reader["firmName"].ToString();
CardCommentRichTextBox.Text = reader["comments"].ToString();
if (reader.GetMySqlDateTime("holderBirthday").IsValidDateTime)
{
CardBirthDatePicker.Text = reader.GetMySqlDateTime("holderBirthday").ToString();
}
else
{
//поставить дефолтное значение для даты, если невалидно
//Изменить парсинг даты
CardBirthDatePicker.Text = "";
}
CardGenderComboBox.SelectedItem = holderSex[reader.GetInt32("holderSex") - 4230];
holderId = reader.GetUInt16("holderId");
string getCardDiscount = "SELECT policys.policyName, policys.policyDescription, policys.policyCumulationPeriod, policys.policyCumulationUnit " +
"FROM net_list_cards AS cards, net_list_purse_discount AS discounts, net_list_policys AS policys " +
"WHERE cards.objectId = discounts.cardId AND policys.objectId = discounts.policyId AND policys.objectType = 140 AND discounts.objectType = 140 AND discounts.objectStatus = 150 AND cards.objectType = 140 AND policys.objectStatus = 150 AND cards.objectStatus = 150 AND cards.cardSerial='" + CardNumberTextBox.Text + "';";
reader.Close();
command = new MySqlCommand(getCardDiscount, connection);
reader = command.ExecuteReader();
dataGridView1.Rows.Clear();
while (reader.Read())
{
//Добавляем строку, указывая значения каждой ячейки по имени (можно использовать индекс 0, 1, 2 вместо имен)
dataGridView1.Rows.Add(reader["policyName"].ToString(),
reader["policyDescription"].ToString(),
policyCumPeriod[reader.GetInt16("policyCumulationPeriod") - 280],
policyCumType[reader.GetInt16("policyCumulationUnit") - 300]);
}
connection.Close();
}
else
{
DialogResult dialogResult = MessageBox.Show("К карте пользователь не привязан. Привязать нового пользователя к этой карте?", "Создание пользователя", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
holderId = 0;
ControlsEnable(true);
ControlsClear();
}
else if (dialogResult == DialogResult.No)
{
ControlsClear();
return;
}
}
}
else
{
MessageBox.Show("Карта не найдена!");
ControlsClear();
return;
}
}
}
private void ChangeCardDataButton_Click(object sender, EventArgs e)
{
string date = "";
if (cardObjectId == -1)
{
MessageBox.Show("Карта не выбрана!");
return;
}
if (CardBirthDatePicker.Text != "")
{
date = CardBirthDatePicker.Text.Substring(6, 4) + "-" + CardBirthDatePicker.Text.Substring(3, 2) + "-" + CardBirthDatePicker.Text.Substring(0, 2) + "";
}
// Trash
if (holderId != 0)
{
string holderUpdate =
"UPDATE net_list_card_holders " +
"SET holderName='" + CardFIOTextBox.Text + "', " +
"holderPhone='" + CardPhoneTextBox.Text + "', " +
"holderBirthday='" + date +
" WHERE Id='" + holderId + "';";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
finally
{
}
MySqlCommand command = new MySqlCommand(holderUpdate, connection);
int result = command.ExecuteNonQuery();
if (result != 0)
{
MessageBox.Show("Данные изменены");
}
connection.Close();
}
}
else if (holderId == 0)
{
string selectObjectIdMaxDiscounts = "SELECT MAX(objectId) FROM net_list_purse_discount";
string selectObjectIdMaxHolders = "SELECT MAX(objectId) FROM net_list_card_holders";
int maxObjectIdHolders;
int maxObjectIdDiscounts;
//Получение последнего objcetId
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
MySqlCommand command = new MySqlCommand(selectObjectIdMaxHolders, connection);
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
maxObjectIdHolders = reader.GetInt32(0) + 1;
reader.Close();
command = new MySqlCommand(selectObjectIdMaxDiscounts, connection);
reader = command.ExecuteReader();
reader.Read();
maxObjectIdDiscounts = reader.GetInt32(0) + 1;
reader.Close();
//reader.Dispose();
}
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
MySqlCommand command = new MySqlCommand("SELECT firmId FROM Firms;", connection);
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
firm = reader[0].ToString();
reader.Close();
}
string holderInsert =
"INSERT net_list_card_holders" +
"(holderName," +
"cardCount," +
"firmId," +
"holderSex," +
"holderEmail," +
"holderBirthday," +
"objectId," +
"objectType," +
"objectStatus," +
"creatorId," +
"dtModify," +
"comments," +
"holderPhone) " +
"VALUES(" +
"'" + CardFIOTextBox.Text + "'," +
"1," +
"" + firm + "," +
"" + (holderSex.IndexOf(CardGenderComboBox.Text) + 4230) + "," +
"'" + CardEmailTextBox.Text + "'," +
"'" + date + "'," +
"" + maxObjectIdHolders + "," +
"" + 140 + "," +
"" + 150 + "," +
"" + 100 + "," +
//"NOW()," +
" NOW(), " +
"'" + CardCommentRichTextBox.Text + "'," +
"'" + CardPhoneTextBox.Text + "');";
string policys = BaseConnectString.GetIds();
string cardUpdate =
"UPDATE net_list_cards " +
"SET holderId=" + maxObjectIdHolders + ", purseDiscountCount=" + policys.Split(',').Count() + ", objectStatus =" + 150 + ", objectType=" + 140 + ", firmId=" + 2 + " " +
"WHERE cardSerial='" + CardNumberTextBox.Text + "' AND holderId=" + 0 + " AND firmId=" + 0 + ";";
//string policyInsert =
// "INSERT net_list_purse_discount " +
// "(cardId, policyId, objectId, objectType, objectStatus, creatorId, dtModify) " +
// "VALUES(" + cardObjectId + "," + 10 + "," + maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW()), " +
// "(" + cardObjectId + "," + 12 + "," + ++maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW()), " +
// "(" + cardObjectId + "," + 15 + "," + ++maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW());";
string policyInsert =
"INSERT net_list_purse_discount " +
"(cardId, policyId, objectId, objectType, objectStatus, creatorId, dtModify) " +
"VALUES";
if (policys != "-1")
{
foreach (string policy in policys.Split(','))
{
policyInsert += "(" + cardObjectId + "," + policy + "," + maxObjectIdDiscounts++ + "," + 140 + "," + 150 + "," + 100 + "," + "NOW()),";
}
policyInsert = policyInsert.TrimEnd(',');
policyInsert += ";";
}
//"(" + cardObjectId + "," + 10 + "," + maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW()), " +
//"(" + cardObjectId + "," + 12 + "," + ++maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW()), " +
//"(" + cardObjectId + "," + 15 + "," + ++maxObjectIdDiscounts + "," + 140 + "," + 150 + "," + 100 + "," + "NOW());";
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetString()))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Проверьте соединение с базой");
return;
}
MySqlCommand command = new MySqlCommand(holderInsert, connection);
command.ExecuteNonQuery();
command = new MySqlCommand(cardUpdate, connection);
command.ExecuteNonQuery();
if (policys != "-1")
{
command = new MySqlCommand(policyInsert, connection);
command.ExecuteNonQuery();
}
}
}
ControlsClear();
ControlsEnable(false);
}
private void AuthorizationEnterButton_Click(object sender, EventArgs e)
{
if (AuthorizationLoginTextBox.Text == "" || AuthorizationPasswordTextBox.Text == "")
{
MessageBox.Show("Заполните поля!");
return;
}
using (connection = new MySqlConnection(BaseConnectString.GetLocalString(true)))
{
try
{
connection.Open();
}
catch (MySqlException ex)
{
MessageBox.Show("Проверьте подключение к базе и перезапустите программу.");
Close();
return;
}
//проверка наличия хотя бы одного юзера
string checkUsers = "SELECT * FROM Users;";
MySqlCommand commandUsers = new MySqlCommand(checkUsers, connection);
MySqlDataReader readerUsers = commandUsers.ExecuteReader();
//Если первый вход
if (!readerUsers.Read())
{
readerUsers.Close();
//Добавляем админа
string addAdmin = "INSERT Users(Login, Password, Privileges)" +
"VALUES('" + AuthorizationLoginTextBox.Text + "', '" + AuthorizationPasswordTextBox.Text + "', TRUE);";
command = new MySqlCommand(addAdmin, connection);
int result = command.ExecuteNonQuery();
//Переходим на главное окно
if (result != 0)
{
MessageBox.Show("Учетная запись администратора создана");
MainForm main = new MainForm(this, true);
main.Show();
Hide();
}
else
{
MessageBox.Show("Ошибка при добавлении администратора");
}
}
//Иначе проверяем наличие пользователя
else
{
string loginIn = "SELECT * FROM Users WHERE Login='******' AND Password='******';";
readerUsers.Close();
command = new MySqlCommand(loginIn, connection);
MySqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
//Тут добавил проверку привелегий
MainForm main = new MainForm(this, reader.GetBoolean("Privileges"));
main.Show();
Hide();
}
else
{
MessageBox.Show("Пользователь или пароль не найдены!");
//return;
}
}
}
}
private void AuthorizationForm_Load(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(BaseConnectString.GetLocalString(false)))
{
try
{
connection.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("Проверьте подключение к базе и перезапустите программу.");
Close();
return;
}
finally
{
}
string baseCreate = "CREATE DATABASE IF NOT EXISTS cardlocal";
command = new MySqlCommand(baseCreate, connection);
if (FingerPrint.Value() != BaseConnectString.val)
{
Close();
}
int result = command.ExecuteNonQuery();
if (what)
{
//firstEnter = true;
MessageBox.Show("Base created!");
string useBase = "USE cardlocal;";
command = new MySqlCommand(useBase, connection);
command.ExecuteNonQuery();
string usersTable = "CREATE TABLE IF NOT EXISTS Users (" +
"User_id INT AUTO_INCREMENT PRIMARY KEY," +
"Login VARCHAR(255) NOT NULL," +
"Password VARCHAR(255)," +
"Privileges BOOLEAN NOT NULL)";
command = new MySqlCommand(usersTable, connection);
command.ExecuteNonQuery();
string firmTable = "CREATE TABLE IF NOT EXISTS Firms (" +
"id INT AUTO_INCREMENT PRIMARY KEY," +
"firmId INT NOT NULL," +
"firmName VARCHAR(255) NOT NULL," +
"firmNameExt VARCHAR(255) NOT NULL)";
command = new MySqlCommand(firmTable, connection);
command.ExecuteNonQuery();
string firmInsert = "INSERT Firms(firmId, firmName, firmNameExt) VALUES(2, '', '')";
command = new MySqlCommand(firmInsert, connection);
command.ExecuteNonQuery();
string connectionTable = "CREATE TABLE IF NOT EXISTS Connection (" +
"Connection_id INT AUTO_INCREMENT PRIMARY KEY," +
"ServerName VARCHAR(255) NOT NULL," +
"UserName VARCHAR(255) NOT NULL," +
"DbName VARCHAR(255) NOT NULL," +
"Port VARCHAR(255) NOT NULL," +
"Password VARCHAR(255) NOT NULL)";
command = new MySqlCommand(connectionTable, connection);
command.ExecuteNonQuery();
string policyTable = "CREATE TABLE IF NOT EXISTS Policys ( id INT AUTO_INCREMENT PRIMARY KEY," +
"policyId INT UNIQUE NOT NULL)";
command = new MySqlCommand(policyTable, connection);
command.ExecuteNonQuery();
//string insertConnetion = "INSERT Connection(ServerName, UserName, DbName, Port, Password) VALUES ('', '', '', '', '');";
//command = new MySqlCommand(insertConnetion, connection);
//command.ExecuteNonQuery();
}
}
}
