/// <summary> /// Get all. /// </summary> /// <returns>List all product tag</returns> public List <C_ProductTag> GetAll() { using (var data = new Entities()) { try { List <C_ProductTag> lst = new List <C_ProductTag>(); var c_gen = (from t in data.C_ProductTag group t by new { t.Tag, t.Link } into g select new { Tag = g.Key.Tag, Link = g.Key.Link }).ToList(); if (c_gen.Count > 0) { foreach (var it in c_gen) { C_ProductTag tag = new C_ProductTag(); tag.Tag = it.Tag; tag.Link = it.Link; tag.ProductTagID = 99999999; tag.ProductID = 99999999; lst.Add(tag); } } return(lst); } catch (Exception) { return(null); } } }
/// <summary> /// Gets the tag by link. /// </summary> /// <param name="link">The link.</param> /// <returns>the tag</returns> public C_ProductTag GetTagByLink(string link) { List <C_ProductTag> lstTag = this.GetAll().FindAll(delegate(C_ProductTag tag) { return(tag.Link.Contains(link)); }); if (lstTag.Count > 0) { C_ProductTag tagreturn = lstTag[0]; return(tagreturn); } else { return(new C_ProductTag()); } }
/// <summary> /// Add the tag. /// </summary> /// <param name="tag">tag object.</param> /// <returns>status add</returns> public bool Add_Tag(C_ProductTag tag) { using (var data = new Entities()) { bool rt; try { data.C_ProductTag.Add(tag); data.SaveChanges(); rt = true; } catch (Exception) { rt = false; } return(rt); } }
/// <summary> /// Edit the tag. /// </summary> /// <param name="tag">tag object.</param> /// <returns>status edit tag</returns> public bool Edit_Tag(C_ProductTag tag) { using (var data = new Entities()) { bool rt; try { var c_gen = data.C_ProductTag.Where(p => p.ProductTagID == tag.ProductTagID).FirstOrDefault(); c_gen.ProductID = tag.ProductID; c_gen.Tag = tag.Tag; c_gen.Link = tag.Link; data.SaveChanges(); rt = true; } catch (Exception) { rt = false; } return(rt); } }