private static XmlNode createNode(CATEGORY category, string encCampaign, XmlDocument doc, XmlNode father, string lang) { string encCategory; XmlNode node = doc.CreateNode(XmlNodeType.Element, "Menu", ""); XmlAttribute attr; // text attribute for Menu name attr = doc.CreateAttribute("text"); if (lang == "en-US") { attr.Value = category.NameEng; } else { attr.Value = category.Name; } node.Attributes.Append(attr); // value attribute for category id attr = doc.CreateAttribute("value"); attr.Value = category.ID.ToString(); node.Attributes.Append(attr); encCategory = Encryption.Encrypt(category.ID.ToString()); attr = doc.CreateAttribute("url"); attr.Value = "/campaign/" + encCampaign + "/cat/" + encCategory + "/"; node.Attributes.Append(attr); father.AppendChild(node); return node; }
public void Update(CATEGORY upCategory) { Context.CATEGORY.Attach(upCategory); var entry = Context.ObjectStateManager.GetObjectStateEntry(upCategory); entry.SetModifiedProperty("Name"); entry.SetModifiedProperty("NameEng"); entry.SetModifiedProperty("Description"); entry.SetModifiedProperty("AttributeID"); entry.SetModifiedProperty("Ordering"); }
private void FixupCATEGORY2(CATEGORY previousValue) { if (previousValue != null && previousValue.CATEGORY1.Contains(this)) { previousValue.CATEGORY1.Remove(this); } if (CATEGORY2 != null) { if (!CATEGORY2.CATEGORY1.Contains(this)) { CATEGORY2.CATEGORY1.Add(this); } if (ParentID != CATEGORY2.ID) { ParentID = CATEGORY2.ID; } } else if (!_settingFK) { ParentID = null; } }
public void Insert(CATEGORY Category) { _categoryDAO.Insert(Category); Context.SaveChanges(); }
public List<CATEGORY> Search(CATEGORY Category, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, Util.SortDirection SortDirection) { return _categoryDAO.Search(Category, PageSize, PageIndex, out TotalRecords, OrderExp, SortDirection); }
public void ImportProducts(int CampaignId, string Path) { var productList = ProductExcelImporter.ReadProductExcel(Path); string encryptedCampId = FashionZone.BL.Util.Encryption.Encrypt(CampaignId.ToString()); PRODUCT product; // preparing categories List<CATEGORY> categoriesList = _categoryDAO.GetCategoryListByCampaign(CampaignId); int? categoryParentF = null, categoryParentM = null; CATEGORY cat, categoryParent = null; categoryParent = categoriesList.Where(o => o.NameEng.Contains("Woman")).FirstOrDefault(); if (categoryParent != null) { cat = new CATEGORY() { ID = categoryParent.ID }; categoryParentF = categoryParent.ID; } categoryParent = categoriesList.Where(o => o.NameEng.Contains("Man")).FirstOrDefault(); if (categoryParent != null) { cat = new CATEGORY() { ID = categoryParent.ID }; categoryParentM = categoryParent.ID; } var query = (from c in categoriesList select new { c.ID, c.Name, c.NameEng, c.ParentID }).ToList(); foreach (FZExcelProduct exProd in productList) { product = new PRODUCT(); product.Name = exProd.Title; product.Code = exProd.Code; decimal our, original, suppl = 0; if (Decimal.TryParse(exProd.Sell, out our)) { product.OurPrice = our; } if (Decimal.TryParse(exProd.Retail, out original)) { product.OriginalPrice = original; } if (Decimal.TryParse(exProd.Buy, out suppl)) { product.SupplierPrice = suppl; } product.Description = "Produkti <br /><br />" + exProd.Title + "<br /><br />" + exProd.Desc.Replace("\n", "<br />"); setCategories(CampaignId, query, product, exProd.Category, exProd.Sex, categoryParentF, categoryParentM); // inserting the product entity, we are on a "transaction" so everything will // be rolled back in case the other statements aren't successful Insert(product); setAttributes(categoriesList, product, exProd); setImages(product, exProd, encryptedCampId); } }
public void DeleteById(int id) { CATEGORY obj = new CATEGORY() { ID = id }; Delete(obj); }
public void Delete(CATEGORY delCategory) { Context.CATEGORY.Attach(delCategory); Context.DeleteObject(delCategory); //Context.SaveChanges(); }
public List<CATEGORY> Search(CATEGORY Category, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, SortDirection SortDirection) { throw new NotImplementedException(); }
private static TreeNode addNodeToTree(TreeNode myNode, CATEGORY singleC, ICollection<CATEGORY> cats) { var node = new TreeNode(singleC.Name, singleC.ID.ToString()); node.ShowCheckBox = true; if (cats != null && cats.Count > 0 && cats.Any(cat => cat.ID == singleC.ID)) node.Checked = true; myNode.ChildNodes.Add(node); return node; }
private static void populateTreeView(TreeNode myNode, CATEGORY singleC, ICollection<CATEGORY> cats, List<CATEGORY> allCats) { var catChChildren = allCats.Where(c => c.ParentID == singleC.ID).OrderBy(c2 => c2.Ordering).ToList(); TreeNode nFather = addNodeToTree(myNode, singleC, cats); if (catChChildren.Count > 0) { foreach (var c in catChChildren) populateTreeView(nFather, c, cats, allCats); } catChChildren.Clear(); }
private bool setCategories(PRODUCT product) { CATEGORY cat; bool subCatChecked = false; foreach (TreeNode node in tvCategories.CheckedNodes) { if (node.Depth == 2) { subCatChecked = true; } cat = new CATEGORY() { ID = Int32.Parse(node.Value) }; product.CATEGORY.Add(cat); } return subCatChecked; }
private static void DeleteCat(CATEGORY c) { ApplicationContext.Current.Categories.Delete(c); List<CATEGORY> listChildrenCat = ApplicationContext.Current.Categories.GetChildrenCategoryList(c.ID); if (listChildrenCat.Count > 0) foreach (var cat in listChildrenCat) DeleteCat(cat); }
private static TreeNode addNodeToTree(TreeNode myNode, CATEGORY singleC) { var node = new TreeNode(singleC.Name, singleC.ID.ToString()); node.ShowCheckBox = true; node.SelectAction = TreeNodeSelectAction.Select; myNode.ChildNodes.Add(node); return node; }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { //Save Categories CATEGORY newCat = new CATEGORY(); int id; int idForEdit; int.TryParse(hdnIdNode.Value, out idForEdit); if (idForEdit != 0) newCat = new CATEGORY() { ID = idForEdit}; newCat.Name = txtName.Text; newCat.NameEng = txtNameEng.Text; newCat.Description = txtDesc.Text; Int32.TryParse(dll_campain.SelectedValue, out id); newCat.CampaignID = id; if (!string.IsNullOrWhiteSpace(ddl_Attributes.SelectedValue)) { Int32.TryParse(ddl_Attributes.SelectedValue, out id); newCat.AttributeID = id; } if (!string.IsNullOrWhiteSpace(txtOrder.Text)) { int.TryParse(txtOrder.Text, out id); newCat.Ordering = id; } switch (TreeView1.CheckedNodes.Count) { case 0: resetFields(); pnlInfo.Visible = txtName.Visible = txtNameEng.Visible = txtDesc.Visible = txtOrder.Visible = false; break; case 1: TreeNode selectedNode = new TreeNode(); selectedNode = TreeView1.CheckedNodes[0]; int.TryParse(selectedNode.Value, out id); newCat.ParentID = id; pnlInfo.Visible = txtName.Visible = txtNameEng.Visible = txtDesc.Visible = txtOrder.Visible = true; break; default: sendMsg("Zgjidh vetem NJE kategori!!"); break; } if (idForEdit == 0) { ApplicationContext.Current.Categories.Insert(newCat); sendMsg("Insert successful!"); } else { ApplicationContext.Current.Categories.Update(newCat); sendMsg("Update successful!"); } resetFields(); popola(); } }
public void Delete(CATEGORY Category) { _categoryDAO.Delete(Category); Context.SaveChanges(); }
private void FixupCATEGORY2(CATEGORY previousValue) { if (previousValue != null && previousValue.CATEGORY1.Contains(this)) { previousValue.CATEGORY1.Remove(this); } if (CATEGORY2 != null) { if (!CATEGORY2.CATEGORY1.Contains(this)) { CATEGORY2.CATEGORY1.Add(this); } if (ParentID != CATEGORY2.ID) { ParentID = CATEGORY2.ID; } } else if (!_settingFK) { ParentID = null; } }
public void Insert(CATEGORY newCategory) { Context.CATEGORY.AddObject(newCategory); //Context.SaveChanges(); }