Beispiel #1
0
        protected virtual void OnButtonOkClicked(object sender, System.EventArgs e)
        {
            if (String.IsNullOrEmpty(entrFieldName.Text))
            {
                MessageDialogs md =
                    new MessageDialogs(MessageDialogs.DialogButtonType.Ok, MainClass.Languages.Translate("please_enter_field_name"), "", Gtk.MessageType.Error, this);
                md.ShowDialog();

                return;
            }
            TreeIter ti;

            string typ = "";

            if (cbFieldType.GetActiveIter(out ti))
            {
                typ = fieldTypeStore.GetValue(ti, 0).ToString();
            }

            fieldTable         = new FieldTable(entrFieldName.Text, typ);
            fieldTable.NotNULL = chbNulable.Active;
            if (!String.IsNullOrEmpty(entrDefault.Text))
            {
                fieldTable.DefaultValue = entrDefault.Text;
            }
            this.Respond(ResponseType.Ok);
        }
Beispiel #2
0
        protected virtual void OnBtnCreateFieldClicked(object sender, System.EventArgs e)
        {
            SqlLiteAddFiled sqlAddField = new SqlLiteAddFiled(this);
            int             result      = sqlAddField.Run();

            if (result == (int)ResponseType.Ok)
            {
                FieldTable ft = sqlAddField.FieldTable;
                if (ft != null)
                {
                    FieldTable cdFind = fields.Find(x => x.Name.ToUpper() == ft.Name.ToUpper());
                    if (cdFind != null)
                    {
                        MessageDialogs md = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, MainClass.Languages.Translate("fileds_exist", ft.Name), "", Gtk.MessageType.Error, this);
                        md.ShowDialog();
                        sqlAddField.Destroy();
                        return;
                    }
                    string sql = String.Format("ALTER TABLE {0} ADD {1} {2} ", tableName, ft.Name, ft.Type);

                    if (ft.NotNULL)
                    {
                        sql = sql + " " + "NOT NULL";
                    }

                    if (!String.IsNullOrEmpty(ft.DefaultValue))
                    {
                        if ((ft.Type.IndexOf("NUMERIC") > -1) || (ft.Type.IndexOf("INTEGER") > -1))
                        {
                            sql = sql + " DEFAULT " + ft.DefaultValue;
                        }
                        else
                        {
                            string dfltValue = ft.DefaultValue;
                            if (!dfltValue.StartsWith("'"))
                            {
                                dfltValue = "'" + dfltValue;
                            }
                            if (!dfltValue.EndsWith("'"))
                            {
                                dfltValue = dfltValue + "'";
                            }

                            sql = sql + " DEFAULT " + dfltValue;
                        }
                    }

                    sql = sql + " ;";

                    if (sqlLiteDal.RunSqlScalar(sql))
                    {
                        fieldsStore.AppendValues(ft.Name, ft.Type, ft);
                        fields.Add(ft);
                    }
                }
            }
            sqlAddField.Destroy();
        }
Beispiel #3
0
        private void GetTableStructure()
        {
            fieldsStore.Clear();
            fields.Clear();

            SqliteConnection conn = (SqliteConnection)sqlLiteDal.GetConnect();
            SqliteDataReader dr   = null;

            string sql = String.Format("PRAGMA table_info( '{0}' );", tableName);

            //DataTable dt = null;
            try {
                //dt = sqlLiteDal.RunSqlReader(sql);

                using (SqliteCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    dr = cmd.ExecuteReader();
                }

                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        string name      = dr[1].ToString();
                        string type      = dr[2].ToString();
                        bool   notnull   = Convert.ToBoolean(dr[3]);
                        string dfltValue = dr[4].ToString();
                        //bool pk = Convert.ToBoolean(dr[5]);

                        FieldTable ft = new FieldTable(name, type);
                        ft.NotNULL      = notnull;
                        ft.DefaultValue = dfltValue;

                        fields.Add(ft);
                        fieldsStore.AppendValues(name, type, notnull.ToString(), dfltValue, ft);
                    }
                }
            } catch (Exception ex) {
                MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error, this);
                ms.ShowDialog();
            } finally {
                if (dr != null)
                {
                    dr.Close();
                }
                dr = null;
                conn.Close();
                conn = null;
            }
        }
Beispiel #4
0
        public SqlLiteAddFiled(FieldTable ft,Gtk.Window parent)
        {
            this.TransientFor =parent;

            this.Build();
            this.Title="Edit Field :"+ ft.Name;
            fieldTable = ft;

            CellRendererText textRenderer = new CellRendererText();
            cbFieldType.PackStart(textRenderer, true);

            entrFieldName.Text = ft.Name;

            if(!String.IsNullOrEmpty(ft.DefaultValue))
                entrDefault.Text = ft.DefaultValue;
            chbNulable.Active = ft.NotNULL;

            cbFieldType.Model = fieldTypeStore;

            int active = -1;

            if (String.IsNullOrEmpty(ft.Type))
                active = 0;
            fieldTypeStore.AppendValues("");

            if (ft.Type== "TEXT")
                active = 1;
            fieldTypeStore.AppendValues("TEXT");

            if (ft.Type== "NUMERIC")
                active = 2;
            fieldTypeStore.AppendValues("NUMERIC");

            if (ft.Type== "BLOB")
                active = 3;
            fieldTypeStore.AppendValues("BLOB");

            if (ft.Type== "INTEGER PRIMARY KEY")
                active = 4;
            fieldTypeStore.AppendValues("INTEGER PRIMARY KEY");

            /*if (ft.Type== "INTEGER PRIMARY KEY AUTOINCREMENT")
                active = 5;
            fieldTypeStore.AppendValues("INTEGER PRIMARY KEY AUTOINCREMENT");*/

            if (active==-1){
                fieldTypeStore.AppendValues(ft.Type);
                active = 5;
            }
            cbFieldType.Active = active;
        }
Beispiel #5
0
        protected virtual void OnBtnEditFieldClicked(object sender, System.EventArgs e)
        {
            TreeSelection ts = tvFields.Selection;

            TreeIter ti = new TreeIter();

            ts.GetSelected(out ti);

            TreePath[] tp = ts.GetSelectedRows();
            if (tp.Length < 1)
            {
                return;
            }

            FieldTable oldFT = (FieldTable)tvFields.Model.GetValue(ti, 4);

            if (oldFT == null)
            {
                return;
            }

            SqlLiteAddFiled sqlAddField = new SqlLiteAddFiled(oldFT, this);
            int             result      = sqlAddField.Run();

            if (result == (int)ResponseType.Ok)
            {
                FieldTable newFT = sqlAddField.FieldTable;
                if (newFT != null)
                {
                    string tempTable = "temp_" + tableName + "_backup";
                    string sqlBegin  = "BEGIN TRANSACTION ;";

                    string sqlRename = String.Format(" ALTER TABLE {0} RENAME TO {1} ;", tableName, tempTable);

                    string sqlReCreate = string.Format(" CREATE TABLE {0}( ", tableName);
                    string oldColums   = "";
                    string newColums   = "";

                    for (int r = 0; r < fields.Count; r++)
                    {
                        if (fields[r].Name != oldFT.Name)
                        {
                            string dfltValue = fields[r].DefaultValue;
                            string type      = fields[r].Type;

                            sqlReCreate = sqlReCreate + fields[r].Name + " " + type;

                            if (fields[r].NotNULL)
                            {
                                sqlReCreate = sqlReCreate + " NOT NULL";
                            }

                            if (!String.IsNullOrEmpty(dfltValue))
                            {
                                if ((type.IndexOf("NUMERIC") > -1) || (type.IndexOf("INTEGER") > -1))
                                {
                                    sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                                }
                                else
                                {
                                    if (!dfltValue.StartsWith("'"))
                                    {
                                        dfltValue = "'" + dfltValue;
                                    }
                                    if (!dfltValue.EndsWith("'"))
                                    {
                                        dfltValue = dfltValue + "'";
                                    }
                                    sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                                }
                            }

                            oldColums = oldColums + fields[r].Name;
                            newColums = newColums + fields[r].Name;
                        }
                        else
                        {
                            string dfltValue = newFT.DefaultValue;
                            string type      = newFT.Type;

                            sqlReCreate = sqlReCreate + newFT.Name + " " + type;

                            if (newFT.NotNULL)
                            {
                                sqlReCreate = sqlReCreate + " NOT NULL";
                            }

                            if (!String.IsNullOrEmpty(dfltValue))
                            {
                                if ((type.IndexOf("NUMERIC") > -1) || (type.IndexOf("INTEGER") > -1))
                                {
                                    sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                                }
                                else
                                {
                                    if (!dfltValue.StartsWith("'"))
                                    {
                                        dfltValue = "'" + dfltValue;
                                    }
                                    if (!dfltValue.EndsWith("'"))
                                    {
                                        dfltValue = dfltValue + "'";
                                    }

                                    sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                                }
                            }

                            oldColums = oldColums + fields[r].Name;
                            newColums = newColums + newFT.Name;
                        }

                        if (r < fields.Count - 1)
                        {
                            sqlReCreate = sqlReCreate + ",";
                            oldColums   = oldColums + ",";
                            newColums   = newColums + ",";
                        }
                    }
                    sqlReCreate = sqlReCreate + ") ;";

                    string sqlInsertInto = string.Format(" INSERT INTO {0}( {1} ) SELECT {2} FROM {3} ;", tableName, newColums, oldColums, tempTable);
                    string sqlDropTable  = string.Format(" DROP TABLE {0} ;", tempTable);
                    string sqlEnd        = "COMMIT ;";
                    string sql           = sqlBegin + "\n" + sqlRename + "\n" + sqlReCreate + "\n" + sqlInsertInto + "\n" + sqlDropTable + "\n" + sqlEnd;
                    //Console.WriteLine(sql);

                    if (sqlLiteDal.RunSqlScalar(sql))
                    {
                        //fields.Remove(oldFT);

                        //fieldsStore.SetValue(ti,

                        GetTableStructure();
                    }
                    else
                    {
                        // nepodarilo sa vymazanie, dam naspet
                        //fields.Add(oldFT);
                    }
                }
            }
            sqlAddField.Destroy();
        }
Beispiel #6
0
        protected virtual void OnBtnDeleteFieldClicked(object sender, System.EventArgs e)
        {
            TreeSelection ts = tvFields.Selection;

            TreeIter ti = new TreeIter();

            ts.GetSelected(out ti);

            TreePath[] tp = ts.GetSelectedRows();
            if (tp.Length < 1)
            {
                return;
            }

            FieldTable cd = (FieldTable)tvFields.Model.GetValue(ti, 4);

            if (cd == null)
            {
                return;
            }

            MessageDialogs md     = new MessageDialogs(MessageDialogs.DialogButtonType.YesNo, MainClass.Languages.Translate("delete_field", cd.Name), "", Gtk.MessageType.Question, this);
            int            result = md.ShowDialog();

            if (result != (int)Gtk.ResponseType.Yes)
            {
                return;
            }

            string tempTable = "temp_" + tableName + "_backup";
            string sqlBegin  = "BEGIN TRANSACTION ;";

            string sqlRename = String.Format(" ALTER TABLE {0} RENAME TO {1} ;", tableName, tempTable);

            string sqlReCreate = string.Format(" CREATE TABLE {0}( ", tableName);
            string colums      = "";

            int newCount = 0;

            for (int r = 0; r < fields.Count; r++)
            {
                if (fields[r].Name != cd.Name)
                {
                    string dfltValue = fields[r].DefaultValue;
                    string type      = fields[r].Type;

                    sqlReCreate = sqlReCreate + fields[r].Name + " " + type;

                    if (fields[r].NotNULL)
                    {
                        sqlReCreate = sqlReCreate + " NOT NULL";
                    }

                    if (!String.IsNullOrEmpty(dfltValue))
                    {
                        if ((type.IndexOf("NUMERIC") > -1) || (type.IndexOf("INTEGER") > -1))
                        {
                            sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                        }
                        else
                        {
                            if (!dfltValue.StartsWith("'"))
                            {
                                dfltValue = "'" + dfltValue;
                            }
                            if (!dfltValue.EndsWith("'"))
                            {
                                dfltValue = dfltValue + "'";
                            }

                            sqlReCreate = sqlReCreate + " DEFAULT " + dfltValue;
                        }
                    }
                    colums = colums + fields[r].Name;
                    if (newCount < fields.Count - 2)
                    {
                        sqlReCreate = sqlReCreate + ",";
                        colums      = colums + ",";
                    }
                    newCount++;
                }
            }
            sqlReCreate = sqlReCreate + ") ;";

            string sqlInsertInto = string.Format(" INSERT INTO {0}( {1} ) SELECT {1} FROM {2} ;", tableName, colums, tempTable);
            string sqlDropTable  = string.Format(" DROP TABLE {0} ;", tempTable);
            string sqlEnd        = "COMMIT ;";
            string sql           = sqlBegin + "\n" + sqlRename + "\n" + sqlReCreate + "\n" + sqlInsertInto + "\n" + sqlDropTable + "\n" + sqlEnd;

            //Console.WriteLine(sql);

            if (sqlLiteDal.RunSqlScalar(sql))
            {
                //fields.Remove(cd);
                //fieldsStore.Remove(ref ti);
                GetTableStructure();
            }
            else
            {
                // nepodarilo sa vymazanie, dam naspet
                //fields.Add(cd);
            }
        }
Beispiel #7
0
        protected virtual void OnButtonOkClicked(object sender, System.EventArgs e)
        {
            if (String.IsNullOrEmpty(entrFieldName.Text)){
                MessageDialogs md =
                    new MessageDialogs(MessageDialogs.DialogButtonType.Ok,MainClass.Languages.Translate("please_enter_field_name"),"" , Gtk.MessageType.Error,this);
                md.ShowDialog();

                return;
            }
            TreeIter ti;

            string typ="";

            if(cbFieldType.GetActiveIter(out ti)){
                 typ =  fieldTypeStore.GetValue(ti,0).ToString();
            }

            fieldTable = new FieldTable(entrFieldName.Text,typ);
            fieldTable.NotNULL= chbNulable.Active;
            if (!String.IsNullOrEmpty(entrDefault.Text))
                fieldTable.DefaultValue = entrDefault.Text;
            this.Respond(ResponseType.Ok);
        }
Beispiel #8
0
        public SqlLiteAddFiled(FieldTable ft, Gtk.Window parent)
        {
            this.TransientFor = parent;

            this.Build();
            this.Title = "Edit Field :" + ft.Name;
            fieldTable = ft;

            CellRendererText textRenderer = new CellRendererText();

            cbFieldType.PackStart(textRenderer, true);

            entrFieldName.Text = ft.Name;

            if (!String.IsNullOrEmpty(ft.DefaultValue))
            {
                entrDefault.Text = ft.DefaultValue;
            }
            chbNulable.Active = ft.NotNULL;

            cbFieldType.Model = fieldTypeStore;

            int active = -1;

            if (String.IsNullOrEmpty(ft.Type))
            {
                active = 0;
            }
            fieldTypeStore.AppendValues("");

            if (ft.Type == "TEXT")
            {
                active = 1;
            }
            fieldTypeStore.AppendValues("TEXT");

            if (ft.Type == "NUMERIC")
            {
                active = 2;
            }
            fieldTypeStore.AppendValues("NUMERIC");

            if (ft.Type == "BLOB")
            {
                active = 3;
            }
            fieldTypeStore.AppendValues("BLOB");

            if (ft.Type == "INTEGER PRIMARY KEY")
            {
                active = 4;
            }
            fieldTypeStore.AppendValues("INTEGER PRIMARY KEY");

            /*if (ft.Type== "INTEGER PRIMARY KEY AUTOINCREMENT")
             *      active = 5;
             * fieldTypeStore.AppendValues("INTEGER PRIMARY KEY AUTOINCREMENT");*/

            if (active == -1)
            {
                fieldTypeStore.AppendValues(ft.Type);
                active = 5;
            }
            cbFieldType.Active = active;
        }