public string SaveContent(int catID = 0, int contentID = 0, int typeID = 0, string content = "") { CurtDevDataContext db = new CurtDevDataContext(); JavaScriptSerializer js = new JavaScriptSerializer(); FullContent newcontent = new FullContent(); try { Content c = new Content(); ContentBridge cb = new ContentBridge(); if (contentID != 0) { c = db.Contents.Where(x => x.contentID == contentID).First<Content>(); c.cTypeID = typeID; c.text = content; } else { c = new Content { cTypeID = typeID, text = content }; db.Contents.InsertOnSubmit(c); db.SubmitChanges(); cb = new ContentBridge { catID = catID, contentID = c.contentID }; db.ContentBridges.InsertOnSubmit(cb); } db.SubmitChanges(); newcontent = (from co in db.Contents join ct in db.ContentTypes on co.cTypeID equals ct.cTypeID where co.contentID == c.contentID select new FullContent { contentID = co.contentID, content = co.text, content_type = ct.type, content_type_id = ct.cTypeID }).FirstOrDefault<FullContent>(); } catch { }; return js.Serialize(newcontent); }
public static FullContent GetFullContent(int contentID = 0) { CurtDevDataContext db = new CurtDevDataContext(); FullContent content = new FullContent(); content = (from c in db.Contents where c.contentID.Equals(contentID) select new FullContent { contentID = c.contentID, content_type = c.ContentType.type, content = c.text, content_type_id = c.cTypeID }).FirstOrDefault<FullContent>(); return content; }
public string GetContent(int contentID = 0) { CurtDevDataContext db = new CurtDevDataContext(); JavaScriptSerializer js = new JavaScriptSerializer(); FullContent content = new FullContent(); try { content = (from c in db.Contents join ct in db.ContentTypes on c.cTypeID equals ct.cTypeID where c.contentID == contentID select new FullContent { contentID = c.contentID, content = c.text, content_type = ct.type, content_type_id = ct.cTypeID }).FirstOrDefault<FullContent>(); } catch { }; return js.Serialize(content); }