/// <summary>
/// Takes a content region key and html to update it with. This is how the content gets IN.
/// </summary>
/// <param name="region"></param>
/// <param name="html"></param>
public static void Update(string key, string html)
{
using (var ctx = new picoDataContextDataContext(ContentRegion.ConnectionString))
{
var content = GetContentRegion(key, ctx);
if (content == null)
ctx.picocms_ContentRegions.InsertOnSubmit(
new picocms_ContentRegion()
{
ContentRegionID = Guid.NewGuid(),
Key = key,
Text = html
});
else
content.Text = html;
ctx.SubmitChanges();
}
}
/// <summary>
/// Returns a content region by its key, tied to the data context provided.
/// </summary>
/// <param name="key"></param>
/// <param name="ctx"></param>
/// <returns></returns>
internal static picocms_ContentRegion GetContentRegion(string key, picoDataContextDataContext ctx)
{
if (ctx == null || String.IsNullOrEmpty(key)) return null;
var query = from cr in ctx.picocms_ContentRegions
where cr.Key == key
select cr;
return query.FirstOrDefault();
}
