Exemple #1
0
        private void ServerOptions_Load(object sender, EventArgs e)
        {
            InsertValueDB insert = new InsertValueDB();
            checkTable    getInformationFromDB = new checkTable();

            getInformationFromDB.getAllTable(listBox1);


            //server.createServer.Listener listen = new server.createServer.Listener();
            //listen.go();
            server.createServer.thr test = new server.createServer.thr();
            test.setThread(listBox1);
        }
Exemple #2
0
        public void getAllTable(ListBox listbox)
        {
            readFile getData = new readFile();
            string   data    = getData.getInformationFromFile();

            char[]   spearator = { ',' };
            String[] strlist   = data.Split(spearator);

            string ServerIp = strlist[0];
            string uid      = strlist[1];
            string password = strlist[2];

            string databaseName = "Users";
            string connstring   = string.Format("Server=" + ServerIp + "; database={0}; UID=" + uid + "; password="******"", databaseName);

            string quetyTable = string.Format(@"CREATE TABLE `{0}` (
                                `sid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
                                `nick` varchar(120) NOT NULL DEFAULT '',
                                `firstName` varchar(120) NOT NULL DEFAULT '',
                                `lastName` text NOT NULL,
                                `password` text NOT NULL,
                                `email` text NOT NULL,
                                `access` text NOT NULL,
                                PRIMARY KEY (`sid`))
                                ENGINE = MyISAM AUTO_INCREMENT = 1 ;", "Users");

            string queryTableLogs = string.Format(@"CREATE TABLE `{0}` (
                                `id` smallint(10) unsigned NOT NULL AUTO_INCREMENT,
                                `typeLog` text NOT NULL,
                                `message` text NOT NULL,
                                PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 1 ", "Logs");

            string queryTableTask = string.Format(@"CREATE TABLE `{0}` (
                                `id` smallint(10) unsigned NOT NULL AUTO_INCREMENT,
                                `resolver` text NOT NULL,
                                `titleTask` text NOT NULL,
                                `created` text NOT NULL,
                                `information` text NOT NULL,
                                `dateCreated` date NOT NULL,
                                `dateResolved` date ,
                                `status` text NOT NULL,
                                PRIMARy KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 1", "TaskList");

            MySqlConnection CL = new MySqlConnection(connstring);

            CL.Open();
            DateTime      localDate           = DateTime.Now;
            MySqlCommand  createTableTaskList = new MySqlCommand(queryTableTask, CL);
            InsertValueDB DbInsert            = new InsertValueDB();

            MySqlCommand createTableForLog = new MySqlCommand(queryTableLogs, CL);

            try
            {
                createTableForLog.ExecuteNonQuery();
                listbox.Items.Add(localDate + " Create Table : Table Logs is Created Correct");
                DbInsert.insertToTable("info", localDate + "Create Table : Table Logs is Created Correct");
            }
            catch (MySqlException e)
            {
                listbox.Items.Add(localDate + " Create Table : Table Logs Exist");
                DbInsert.insertToTable("info", localDate + "Create Table : Table Logs Exist");
            }

            try
            {
                createTableTaskList.ExecuteNonQuery();

                listbox.Items.Add(localDate + " Create Table : Table TaskList is Created Correct");
                DbInsert.insertToTable("info", localDate + "Create Table : Table TaskList is Created Correct");
            }
            catch (MySqlException e)
            {
                listbox.Items.Add(localDate + " Create Table : Table Logs Exist");
                DbInsert.insertToTable("info", localDate + "Create Table : Table Logs Exist");
            }

            MySqlCommand createTable = new MySqlCommand(quetyTable, CL);

            try
            {
                createTable.ExecuteNonQuery();
                listbox.Items.Add(localDate + " Create Table : Table user is Created Correct");
                DbInsert.insertToTable("info", localDate + "Create Table : Table user is Created Correct");
            }
            catch (MySql.Data.MySqlClient.MySqlException error)
            {
                Console.WriteLine(error);
                listbox.Items.Add(localDate + " Create Table : Table user exist");
                DbInsert.insertToTable("info", localDate + "Create Table : Table user exist");
            }
        }