////public bool Add(int id, string name, string value, string type) ////{ //// using (var data = new Entities()) //// { //// bool rt = false; //// try //// { //// C_ProductProperty it = new C_ProductProperty(); //// it.ProductID = id; //// it.Name = name; //// it.Value = value; //// it.Type = type; //// data.C_ProductProperty.Add(it); //// data.SaveChanges(); //// rt = true; //// } //// catch (Exception) //// { //// rt = false; //// } //// return rt; //// } ////} /// <summary> /// Edits the specified product Property Object. /// </summary> /// <param name="propertyObject">product Property Object.</param> /// <returns>status edit property</returns> public bool Edit(C_ProductProperty propertyObject) { using (var data = new Entities()) { bool rt = false; try { var c_gen = data.C_ProductProperty.Where(p => p.ProID == propertyObject.ProID).FirstOrDefault(); c_gen.Name = propertyObject.Name; c_gen.Value = propertyObject.Value; c_gen.ProductID = propertyObject.ProductID; c_gen.Type = propertyObject.Type; data.SaveChanges(); rt = true; } catch (Exception) { rt = false; } return(rt); } }
/// <summary> /// Gets the type of the property by. /// </summary> /// <param name="type">The type.</param> /// <returns>the type of the property</returns> public List <C_ProductProperty> GetPropertyByType(string type) { using (var data = new Entities()) { try { //// First, check the cache List <C_ProductProperty> c_gen = this.Cache.Get(type) as List <C_ProductProperty>; if (c_gen == null) { c_gen = new List <C_ProductProperty>(); var lst = (from pp in data.C_ProductProperty group pp by new { pp.Type, pp.Value, pp.Name } into gpp select new { Type = gpp.Key.Type, Name = gpp.Key.Name, Value = gpp.Key.Value }).Where(c => c.Type == type).ToList(); if (lst.Count > 0) { foreach (var it in lst) { C_ProductProperty c_p = new C_ProductProperty(); c_p.Name = it.Name; c_p.Value = it.Value; c_p.Type = it.Type; c_p.ProID = 999999; c_p.ProductID = 999999; c_gen.Add(c_p); } } if (c_gen.Any()) { //// Put this data into the cache for 10 minutes this.Cache.Set(type, c_gen, int.Parse(Util.GetConfigValue(CommonGlobal.TimeCache, "10"))); } } return(c_gen); } catch (Exception) { return(null); } } }
/// <summary> /// Add the specified object. /// </summary> /// <param name="productProperty">product property object.</param> /// <returns>Add the specified</returns> public bool Add(C_ProductProperty productProperty) { using (var data = new Entities()) { bool rt = false; try { data.C_ProductProperty.Add(productProperty); data.SaveChanges(); rt = true; } catch (Exception) { rt = false; } return(rt); } }