private TreeView PopulateRootLevel() { DataTable dt = GetTableFromQuery("select * FROM Table_LookupCategories WHERE ParentCatId='-1'"); TreeView tv = this.treeViewCategories; if ((dt == null) || (dt.Rows.Count == 0)) { // create main category _linqLookupCategoryTableRow = new Table_LookupCategory(); _linqLookupCategoryTableRow.CatHebrewName = "עמוד ראשי"; _linqLookupCategoryTableRow.CatEnglishName = "Main|Home Page"; _linqLookupCategoryTableRow.ParentCatId = -1; Db.Table_LookupCategories.InsertOnSubmit(_linqLookupCategoryTableRow); Db.SubmitChanges(); dt = GetTableFromQuery("select * FROM Table_LookupCategories WHERE ParentCatId='-1'"); } PopulateNodes(dt, tv.Nodes); return tv; }
private void ToolStripMenuItemAddCategory_Click(object sender, EventArgs e) { TreeNode node = this.treeView1.SelectedNode; if (node == null) return; // creating new category in the DB int pId = int.Parse(node.ToolTipText); _tblLookupCategories = new Table_LookupCategory(); _tblLookupCategories.CatHebrewName = "קטגוריה חדשה"; _tblLookupCategories.CatEnglishName = "New Category"; _tblLookupCategories.ParentCatId = pId; string ticksId = DateTime.Now.Ticks.ToString(); _tblLookupCategories.Tags = ticksId; _db.Table_LookupCategories.InsertOnSubmit(_tblLookupCategories); _db.SubmitChanges(); // getting the new category ID _tblLookupCategories = (from c in _db.Table_LookupCategories where c.Tags.Trim() == ticksId select c).Single(); node.Nodes.Add(_tblLookupCategories.CatHebrewName); node.Nodes[_tblLookupCategories.CatHebrewName].ToolTipText = _tblLookupCategories.CatId.ToString(); }
private void FillFormWithSelectedNodeData() { if (selectedTreeNode == null) return; if (StringIsNullOrEmpty(selectedTreeNode.ToolTipText)) return; int catId = int.Parse(selectedTreeNode.ToolTipText); _linqLookupCategoryTableRow = GetCategoryDataObjectById(catId); //(from c in _db.Table_LookupCategories //where catId == c.CatId //select c).Single(); textBoxCategoryNameEnglish.Text = _linqLookupCategoryTableRow.CatEnglishName; textBoxCategoryNameHebrew.Text = _linqLookupCategoryTableRow.CatHebrewName; textBoxKeys.Text = _linqLookupCategoryTableRow.Description; textBoxTags.Text = _linqLookupCategoryTableRow.MetaTags; ConvertRelatedCategories_StringToList(_linqLookupCategoryTableRow.RelatedCatIds); }
//private void ToolStripMenuItemAddCategory_Click(object sender, EventArgs e) //{ // _formState = CategoryEditorStateEnum.ADD; // this.buttonSaveChanges.Enabled = true; // // clear KEYS // this.textBoxKeys.Text = ""; // // clear TAGS // this.textBoxTags.Text = ""; // // clear RELATED CATEGORIES // this.listBoxRelatedCategories.Items.Clear(); // this.textBoxCategoryNameEnglish.Text = ""; // this.textBoxCategoryNameHebrew.Text = ""; // //enabled only explicitly // this.buttonDeleteCategory.Enabled = false; //} private void DeleteCategoryFromDB(DialogResult dr, TreeNode parentNode) { if (parentNode == null) return; if (DialogResult.Yes == dr) foreach (TreeNode node in parentNode.Nodes) { DeleteCategoryFromDB(dr, node); } try { // delete from DB int catId = int.Parse(selectedTreeNode.ToolTipText); _linqLookupCategoryTableRow = GetCategoryDataObjectById(catId); //(from c in _db.Table_LookupCategories //where c.CatId == catId //select c).Single(); Db.Table_LookupCategories.DeleteOnSubmit(_linqLookupCategoryTableRow); Db.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
private static void InsertNewCategoryDataObject(Table_LookupCategory catLinqObj) { Db.Table_LookupCategories.InsertOnSubmit(catLinqObj); Db.SubmitChanges(); }
private void AddTreeNodeSiblingFromForm(TreeNode node) { if (NodeNameExistInSiblings(node)) return; // ELSE: buttonSaveChanges.Enabled = false; try { int parentId = int.Parse(node.ToolTipText); if (_formState == CategoryEditorStateEnum.ADD) { // add the node to tree Form_CategoriesManager.newNode = node.Nodes.Add(textBoxCategoryNameHebrew.Text); FillFromFormAndSaveToDB(parentId); // fetching the new Category from DB to get its CatId _linqLookupCategoryTableRow = (from c in Db.Table_LookupCategories where c.CatHebrewName.Contains(textBoxCategoryNameHebrew.Text) select c).Single(); newNode.ToolTipText = _linqLookupCategoryTableRow.CatId.ToString(); _formState = CategoryEditorStateEnum.EDIT; } else if (_formState == CategoryEditorStateEnum.EDIT) { FillFromFormAndSaveToDB(parentId); selectedTreeNode.Text = textBoxCategoryNameHebrew.Text; } } catch (Exception ex) { buttonSaveChanges.Enabled = true; MessageBox.Show(ex.Message , "חלה שגיאה בהוספת קטגוריה" , MessageBoxButtons.OK , MessageBoxIcon.Error); } }
private void FillFromFormAndSaveToDB(int parentCatId) { if (_formState == CategoryEditorStateEnum.EDIT) { // editing is on the "parent" (=selected) node // fetch record from DB _linqLookupCategoryTableRow = GetCategoryDataObjectById(parentCatId); //(from c in _db.Table_LookupCategories //where c.CatId == parentCatId //select c).Single(); } else if (_formState == CategoryEditorStateEnum.ADD) { _linqLookupCategoryTableRow = new Table_LookupCategory(); } //filling data from form _linqLookupCategoryTableRow.CatHebrewName = textBoxCategoryNameHebrew.Text; _linqLookupCategoryTableRow.CatEnglishName = textBoxCategoryNameEnglish.Text; _linqLookupCategoryTableRow.MetaTags = textBoxTags.Text; _linqLookupCategoryTableRow.RelatedCatIds = ""; // fetching related cats from listbox foreach (object item in listBoxRelatedCategories.Items) { int relatedCatId = DataAccess.Lookup.GetLookupCategoryIdFromName((string)item); _linqLookupCategoryTableRow.RelatedCatIds += String.Format("{0}#", relatedCatId); } _linqLookupCategoryTableRow.RssId = _linqLookupCategoryTableRow.ParentCatId; // TBD - implement RSS support _linqLookupCategoryTableRow.Description = textBoxKeys.Text; try { if (_formState == CategoryEditorStateEnum.ADD) { _linqLookupCategoryTableRow.ParentCatId = parentCatId; // inserting the new category into the DB Db.Table_LookupCategories.InsertOnSubmit(_linqLookupCategoryTableRow); } Db.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void ToolStripMenuItemEditCategory_Click(object sender, EventArgs e) { selectedTreeNode = treeViewCategories.Nodes[0]; if (selectedTreeNode.ToolTipText == "-1") return; _formState = CategoryEditorStateEnum.EDIT; try { _linqLookupCategoryTableRow = (from c in _db.Table_LookupCategories where c.CatId == int.Parse(selectedTreeNode.ToolTipText) select c).Single(); } catch (Exception ex) { throw new Exception(ex.Message); } this.buttonSaveChanges.Enabled = true; // fetch KEYS this.textBoxKeys.Text = _linqLookupCategoryTableRow.Description; // fetch TAGS this.textBoxTags.Text = _linqLookupCategoryTableRow.MetaTags; // fetch RELATED CATEGORIES listBoxRelatedCategories.Items.Clear(); if (_linqLookupCategoryTableRow.RelatedCatIds != null) { string[] relatedCategoriesIds = _linqLookupCategoryTableRow.RelatedCatIds.Split('#'); foreach (string item in relatedCategoriesIds) { try { string relatedCatStr = (from c in _db.Table_LookupCategories where c.CatId == int.Parse(item.Trim('#',' ')) select c.CatHebrewName).Single(); listBoxRelatedCategories.Items.Add(relatedCatStr); } catch { } } } this.textBoxCategoryNameEnglish.Text = _linqLookupCategoryTableRow.CatEnglishName; this.textBoxCategoryNameHebrew.Text = _linqLookupCategoryTableRow.CatHebrewName; this.buttonSaveChanges.Enabled = true; // only for delete need explicitly enabled this.checkBoxEnableDelete.Enabled = true; this.checkBoxEnableDelete.Checked = false; this.buttonDeleteCategory.Enabled = false; }
private void detach_Table_LookupCategories1(Table_LookupCategory entity) { this.SendPropertyChanging(); entity.Table_Article1 = null; }
private void attach_Table_LookupCategories(Table_LookupCategory entity) { this.SendPropertyChanging(); entity.Table_Article = this; }
private void detach_Table_LookupCategories(Table_LookupCategory entity) { this.SendPropertyChanging(); entity.Table_OriginalPhotosArchive = null; }