Exemple #1
0
        private async void ts_save_sql_Click(object sender, EventArgs e)
        {
            if (!structLoaded)
            {
                MessageBox.Show("You can not do that until a structure has been loaded!", "Structure Exception", MessageBoxButtons.OK, MessageBoxIcon.Hand);
                return;
            }

            string tablename = core.TableName;

            if (string.IsNullOrEmpty(tablename))
            {
                DialogResult result = MessageBox.Show("It seems the structure lua does not have a table name listed, would you like to define one?", "Input Required", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                switch (result)
                {
                case DialogResult.Cancel:
                    return;

                case DialogResult.No:
                    return;

                case DialogResult.Yes:
                    using (GUI.InputBox input = new GUI.InputBox("Enter desired table name", false))
                    {
                        if (input.ShowDialog(this) != DialogResult.OK)
                        {
                            return;
                        }

                        lManager.Enter(Logs.Sender.RDB, Logs.Level.WARNING, "User opted to provide Table name for save operation.\n\t- Table name provided: {0}", input.Value);
                        tablename = input.Value;
                    }

                    break;
                }
            }

            Database dManager = new Database();

            try { await Task.Run(() => { dManager.ExportToTable(tablename, tManager.RDBCore.Data); }); }
            catch (System.Data.SqlClient.SqlException ex)
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.SQL_ERROR, ex);
                return;
            }
            catch (Exception ex)
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.ERROR, ex);
                return;
            }
            finally
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.NOTICE, "{0} rows were saved to table: {1} from tab: {2}", tManager.RDBCore.RowCount, tablename, tManager.Text);
            }
        }
Exemple #2
0
        public async void TS_Save_File_Click(object sender, EventArgs e)
        {
            string buildPath = null;

            if (core is null)
            {
                MessageBox.Show("You cannot do that without having loaded data first!", "Save File Exception", MessageBoxButtons.OK, MessageBoxIcon.Hand);
                return;
            }

            try
            {
                string filename = core.FileName;
                if (string.IsNullOrEmpty(filename))
                {
                    DialogResult result = MessageBox.Show("It seems the structure lua does not have a filename listed, would you like to define one?\n\nReminder: Choosing no will cause me use this tabs name instead!", "Input Required", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                    switch (result)
                    {
                    case DialogResult.Cancel:
                        return;

                    case DialogResult.No:
                        lManager.Enter(Logs.Sender.RDB, Logs.Level.DEBUG, "User opted to use the tab name as Filename for save operation.\n\t- Filename provided: {0}", tManager.Text);
                        filename = string.Format("{0}.rdb", tManager.Text);
                        break;

                    case DialogResult.Yes:
                        using (GUI.InputBox input = new GUI.InputBox("Enter desired filename", false))
                        {
                            if (input.ShowDialog(this) != DialogResult.OK)
                            {
                                return;
                            }

                            lManager.Enter(Logs.Sender.RDB, Logs.Level.DEBUG, "User opted to provide Filename for save operation.\n\t- Filename provided: {0}", input.Value);
                            filename = input.Value;
                        }

                        break;
                    }
                }

                if (!filename.Contains("ascii") && ts_save_w_ascii.Checked)
                {
                    filename = string.Format(@"{0}(ascii).rdb", filename.Split('.')[0]);
                }

                if (ts_save_enc.Checked)
                {
                    filename = DataCore.Functions.StringCipher.Encode(filename);
                }

                buildPath = string.Format(@"{0}\{1}", buildDir, filename);

                if (!Directory.Exists(buildDir))
                {
                    Directory.CreateDirectory(buildDir);
                }

                if (File.Exists(buildPath))
                {
                    File.Delete(buildPath);
                }

                await Task.Run(() =>
                {
                    core.RdbPath = buildPath;
                    core.Write();
                });
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "RDB Save Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
                lManager.Enter(Logs.Sender.RDB, Logs.Level.ERROR, ex);
            }
            finally
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.NOTICE, "{0} entries written from tab: {1} into file: {2}", core.RowCount, tManager.Text, buildPath);
            }
        }
Exemple #3
0
        private async void ts_load_sql_Click(object sender, EventArgs e)
        {
            if (!structLoaded)
            {
                MessageBox.Show("You can not do that until a structure has been loaded!", "Structure Exception", MessageBoxButtons.OK, MessageBoxIcon.Hand);
                return;
            }

            string tablename = core.TableName;

            if (string.IsNullOrEmpty(tablename))
            {
                DialogResult result = MessageBox.Show("It seems the structure lua does not have a table name listed, would you like to define one?", "Input Required", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                switch (result)
                {
                case DialogResult.Cancel:
                    return;

                case DialogResult.No:
                    return;

                case DialogResult.Yes:
                    using (GUI.InputBox input = new GUI.InputBox("Enter desired table name", false))
                    {
                        if (input.ShowDialog(this) != DialogResult.OK)
                        {
                            return;
                        }

                        lManager.Enter(Logs.Sender.RDB, Logs.Level.WARNING, "User opted to provide Table name for load operation.\n\t- Table name provided: {0}", input.Value);
                        tablename = input.Value;
                    }

                    break;
                }
            }

            dManager = new Database();
            int rowCount = dManager.FetchRowCount(tablename);

            Daedalus.Structures.Row[] table_data = new Daedalus.Structures.Row[0];

            try
            {
                await Task.Run(() => { table_data = dManager.FetchTable(rowCount, tablename); });

                if (table_data.Length == 0)
                {
                    lManager.Enter(Logs.Sender.RDB, Logs.Level.ERROR, "No results were loaded from the table!");
                    return;
                }

                core.SetData(table_data);
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.SQL_ERROR, ex);
                return;
            }
            catch (Exception ex)
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.ERROR, ex);
                return;
            }
            finally
            {
                lManager.Enter(Logs.Sender.RDB, Logs.Level.NOTICE, "{0} rows were loaded from table: {1} into tab: {2}", table_data.Length, tablename, tManager.Text);

                tManager.Text = Path.GetFileNameWithoutExtension(tablename);
                initializeGrid();
            }
        }