private static void Main()
{
try
{
if (chkDBExists(ConnettionStringDB))
{ //Проверка наличия Базы Данных
Program.Connection.Open(); //Открываем соединение
}
else //Создание Базы Данных и таблиц
{
Connection = new NpgsqlConnection(ConnectionString);
Connection.Open();
var Createdb = new NpgsqlCommand($"CREATE DATABASE \"{NameDB}\" " +
"WITH OWNER = \"postgres\" " +
"ENCODING = 'UTF8' " +
"CONNECTION LIMIT = -1;", Connection).ExecuteNonQuery();
Connection.Close();
Connection = new NpgsqlConnection(ConnettionStringDB);
Connection.Open();
//////Создание таблиц по умолчанию
var command = new NpgsqlCommand();
command.Connection = Connection;
//Таблица Users
command.CommandText = @"CREATE TABLE Users(id SERIAL PRIMARY KEY, login VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL,first_name VARCHAR(50) NOT NULL, middle_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(50) NOT NULL, phone_number VARCHAR(50), access_level INT NOT NULL)";
command.ExecuteNonQuery();
//Таблица HotelRoom
command.CommandText = @"CREATE TABLE Hotelroom(id SERIAL PRIMARY KEY, name_room VARCHAR(50) NOT NULL, id_user_book int, date_reservation VARCHAR(50), date_end_reservation VARCHAR(50), room_price int NOT NULL)";
command.ExecuteNonQuery();
//Таблица Contact
command.CommandText = @"CREATE TABLE Contact ( id SERIAL PRIMARY KEY, user_id integer NOT NULL, topic VARCHAR(255) NOT NULL, message VARCHAR(255))";
command.ExecuteNonQuery();
//Таблица Messages
command.CommandText = @"CREATE TABLE Messages ( id SERIAL PRIMARY KEY, user_id integer NOT NULL, adressed_user_id integer NOT NULL, topic VARCHAR(255), message VARCHAR(255))";
command.ExecuteNonQuery();
///////Тестовое заполнение Базы Данных
UserController.Add("admin", "admin", "Administrator", "*****@*****.**", "Скрыто", "Скрыто", "+78889234532", 0); //Администратор
UserController.Add("user", "user", "Петя", "*****@*****.**", "Павлович", "Вовкин", "+78889234532 ", 1); //Пользователь
UserController.Add("user1", "user1", "Макс", "*****@*****.**", "Андреев", "Галкин", "+78889234532 ", 1); //Пользователь
UserController.Add("user2", "user2", "Вася", "*****@*****.**", "Андреевич", "Бабак", "+78889234532 ", 1); //Пользователь
UserController.Add("user3", "user3", "Коля", "*****@*****.**", "Кучьмич", "Кубак", "+78889234532 ", 1); //Пользователь
//Заполнение комнат отеля
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Стандарт',null,null,null,2000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Стандарт',null,null,null,2000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Стандарт плюс',null,null,null,4000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Стандарт плюс',null,null,null,4000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Люкс',null,null,null,6000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Люкс',null,null,null,6000)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Hotelroom(name_room, id_user_book,date_reservation,date_end_reservation,room_price) VALUES('Аппартаменты',null,null,null,10000)";
command.ExecuteNonQuery();
MessageController.PushMessageToAnotherUser(4, 1, "Hello", "Привет юзер!");
MessageController.PushMessageToAnotherUser(2, 3, "Вопрос", "Как вас день прошел?");
MessageController.PushMessageToAnotherUser(3, 1, "qq", "Привет админ!!!!!!");
MessageController.PushMessageToAnotherUser(2, 2, "Как дела?", "как дела, админ?");
MessageController.PushMessageToAnotherUser(2, 1, "Ошибка в по", "У меня баг!");
ContactController.PushMessage(2, "Оставили ключи в номере, а дверь захлопнулась.", "Я забыл их, что делать?");
ContactController.PushMessage(3, "Другое.", "Где обновление?");
}
}
catch (Exception ex)
{
MessageBox.Show("Не удалось подключиться к PostgresDB. Проверте данные от сервера строку подключения к postgres"); return;
}
AdminController.GetAllIdUser();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Authorization());
}