private void InsertValue()
{
// retrieving to key
var key = db.NewsKeys.Single(x => x.NewsKeyID.Equals(HiddenSubmitID.Value));
// applying changes to value table
var value = new NewsValue()
{
NewsKeyID = key.NewsKeyID,
BodyText = TextEditorNews.Value,
HeaderText = tbNewsTitleEditor.Text,
CultureCode = LanguageList.SelectedValue,
CreateDate = DateTime.Today
};
key.NewsValues.Add(value);
db.SubmitChanges();
}
/// <summary>
/// Insert a new news item in both NewsKey and NewsValue tables
/// </summary>
private void InsertKeyAndValue()
{
NewsKey key = new NewsKey
{
NewsDate = NewsCalender.SelectedDate,
TopNewsIndicator = cbTopNews.Checked,
};
NewsValue value = new NewsValue
{
BodyText = TextEditorNews.Value,
CreateDate = DateTime.Today,
CultureCode = BRITISH_CULTURE, // always english for new items
HeaderText = tbNewsTitleEditor.Text
};
key.NewsValues.Add(value);
db.NewsKeys.InsertOnSubmit(key);
db.SubmitChanges();
}
