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