Beispiel #1
0
 public CategoryDialog(Helpers.Data.Objects.Settings AppSettings, TranslationsHelpers translator, Category editCat)
 {
     InitializeComponent();
     _translator = translator;
     _AppSettings = AppSettings;
     this.Text = _translator.GetTranslatedMessage(_AppSettings.Language, 36, "Edit Category");
     _translator.TranslateUI(_AppSettings.Language, this.Name, this.Controls);
     PopulateForm(editCat);
 }
Beispiel #2
0
        public Category GetCategory(int categoryID)
        {
            Category result = null;

            if (_Connection.State != System.Data.ConnectionState.Open)
                //I raise an error as there is no connection to the database
                throw new Exception("There is no connection to the database");

            String sql = string.Format("SELECT id, name, icon, expanded " +
                         "FROM Categories C " +
                         "WHERE id = {0};",categoryID);

            SQLiteCommand command = new SQLiteCommand(sql, _Connection);
            SQLiteDataReader reader = command.ExecuteReader();

            if (reader.HasRows)
            {
                reader.Read();

                int itemID = -1;
                if (reader["id"] != DBNull.Value)
                    itemID = reader.GetInt32(0);

                string itemName = string.Empty;
                if (reader["name"] != DBNull.Value)
                    itemName = reader.GetString(1);

                string itemIcon = string.Empty;
                if (reader["icon"] != DBNull.Value)
                    itemIcon = reader.GetString(2);

                bool itemExpanded = false;
                if (reader["expanded"] != DBNull.Value)
                    itemExpanded = reader.GetBoolean(3);

                bool itemSelected = (itemExpanded) ? true : false;

                result = new Category(itemID, itemName, itemIcon, itemExpanded, itemSelected);
            }

            return result;
        }
Beispiel #3
0
 private void PopulateForm(Category editCat)
 {
     txtIcon.Text = editCat.Icon;
     txtName.Text = editCat.Name;
 }