/// <summary> /// Create a new tbl_link_data object. /// </summary> /// <param name="id">Initial value of the id property.</param> public static tbl_link_data Createtbl_link_data(global::System.Int32 id) { tbl_link_data tbl_link_data = new tbl_link_data(); tbl_link_data.id = id; return(tbl_link_data); }
public static bool InsertLinkData(int userID, string linkName, string linkUrl, string linkIcon, string linkColor, string linkCate, out string errmsg) { bool bOk = false; using (FavLinkEntities context = new FavLinkEntities()) { int ncate = int.Parse(linkCate); var items = from x in context.tbl_link_data where x.ref_userID == userID && x.ref_categoryID == ncate && (0 == string.Compare(linkUrl, x.url, true))// 0 == x.url.CompareTo(linkUrl) select x; if (items.Any()) { var item = items.First(); errmsg = string.Format("The URL was already exist, the name is: {0}", item.name); return(false); } //insert var entity = new tbl_link_data() { ref_userID = userID, name = linkName, url = linkUrl, icon = linkIcon, bg_color = linkColor, ref_categoryID = ncate }; try { context.tbl_link_data.AddObject(entity); context.SaveChanges(); bOk = true; errmsg = string.Empty; } catch (Exception ex) { errmsg = ex.Message; } } return(bOk); }
/// <summary> /// Deprecated Method for adding a new object to the tbl_link_data EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotbl_link_data(tbl_link_data tbl_link_data) { base.AddObject("tbl_link_data", tbl_link_data); }