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);
}
