public BEStories SelectAllInactive()
{
BEStories ds = new BEStories();
DAStoryTypes da = new DAStoryTypes();
da.SelectAllInactive(ds.tbl_StoryTypes);
return ds;
}
public BEStories SelectAll()
{
BEStories ds = new BEStories();
DAStories da = new DAStories();
da.SelectAll(ds.tbl_Stories);
return ds;
}
public BEStories SelectStoryTypeByID(int StoryTypeID)
{
BEStories ds = new BEStories();
DAStoryTypes da = new DAStoryTypes();
da.SelectByID(StoryTypeID.ToString(), ds.tbl_StoryTypes);
return ds;
}
public BEStories SelectActiveByStoryTypeID(int storyTypeID)
{
BEStories ds = new BEStories();
DAStories da = new DAStories();
da.SelectActiveByStoryTypeID(storyTypeID, ds.tbl_Stories);
return ds;
}
private void BindTitle()
{
BPStoryTypes bp = new BPStoryTypes();
DSStories = bp.SelectStoryTypeByID(SubTypeID);
if (DSStories.tbl_StoryTypes.Count > 0)
{
BEStories.tbl_StoryTypesRow typeRow = DSStories.tbl_StoryTypes[0];
lblTitle.Text = "Browse " + typeRow.StoryTypeName + " Pages";
btnAdd.Text = "Add New";
}
}
private DataView GetData()
{
BPStories bp = new BPStories();
DSStories = bp.SelectByStoryTypeID(SubTypeID);
DSStories.tbl_Stories.DefaultView.Sort = DSStories.tbl_Stories.StoryOrderColumn.ColumnName;
BindMoveControl(DSStories.tbl_Stories.DefaultView);
DSStories.tbl_Stories.DefaultView.RowFilter =
RowFilter(DSStories.tbl_Stories.StoryTitleColumn.ColumnName,
((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName,
DSStories.tbl_Stories.StoryActiveColumn.ColumnName,
lstActive.SelectedValue);
return DSStories.tbl_Stories.DefaultView;
}
public void Update(BEStories ds)
{
DAStoryTypes da = new DAStoryTypes();
da.Update(ds.tbl_StoryTypes);
}
private void SaveStoryInfo()
{
bool isNew = false;
BPStories bp = new BPStories();
BEStories dsStories = new BEStories();
BEStories.tbl_StoriesRow story = null;
if (StoryID > 0)
{
dsStories = bp.SelectStoryByID(StoryID);
story = dsStories.tbl_Stories.FindByStoryID(StoryID);
}
if (story == null)
{
story = dsStories.tbl_Stories.Newtbl_StoriesRow();
isNew = true;
}
//page
story.StoryTitle = txtPageTitle.Text.Trim();
if (edtContentBody1.Text.Trim() == "" || edtContentBody1.Text.Trim() == "<p> </p>")
story.SetStoryBody1Null();
else
story.StoryBody1 = edtContentBody1.Text.Trim();
story.StoryActive = chkStoryActive.Checked;
story.DateModified = DateTime.Now;
story.ModifiedByAdminID = PageUserID;
if (isNew)
{
story.StoryTypeID = SubTypeID;
story.StoryOrder = bp.GetStoryMaxOrder(SubTypeID);
story.DateCreated = DateTime.Now;
dsStories.tbl_Stories.Addtbl_StoriesRow(story);
}
bp.Update(dsStories);
StoryID = story.StoryID;
if (isNew)
{
//Add to main Pages table
BPPages bpPages = new BPPages();
BEPages dsPages = new BEPages();
BEPages.tbl_PagesRow pageRow = dsPages.tbl_Pages.Newtbl_PagesRow();
pageRow.PageTypeID = PageTypeID;
pageRow.PageTypeSpecificID = StoryID;
pageRow.SubTypeID = SubTypeID;
dsPages.tbl_Pages.Addtbl_PagesRow(pageRow);
bpPages.Update(dsPages);
PageID = pageRow.PageID;
}
AddUpdateImageCategory(story.StoryTitle);
}
