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; }
protected void btnMove_Click(object sender, EventArgs e) { bool found1 = false, found2 = false; int Position = Convert.ToInt32(ddlPosition.SelectedValue); int ItemToMove = Convert.ToInt32(ddlItemToMove.SelectedValue); BPStories bp = new BPStories(); BEStories ds = bp.SelectByStoryTypeID(SubTypeID); BEStories.tbl_StoriesRow[] storyRows = (BEStories.tbl_StoriesRow[])ds.tbl_Stories.Select("", "StoryOrder"); BEStories.tbl_StoriesRow moveStory = ds.tbl_Stories.FindByStoryID(ItemToMove); foreach (BEStories.tbl_StoriesRow story in storyRows) { if (found1 && found2) break; if (story.StoryID == moveStory.StoryID) { found1 = true; if (story.StoryID == Position) found2 = true; } else if (story.StoryID == Position) { found2 = true; if (rblBeforeAfter.SelectedValue == "0") { moveStory.StoryOrder = story.StoryOrder; story.StoryOrder++; } else { if (found1) story.StoryOrder--; moveStory.StoryOrder = story.StoryOrder + 1; } } else if (found1 && !found2) story.StoryOrder--; else if (found2 && !found1) story.StoryOrder++; } bp.Update(ds); dgStories.DataSource = GetData(); dgStories.DataBind(); }
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); }
protected void btnDelete_Click(object sender, EventArgs e) { BPStories bpStories = new BPStories(); BEStories dsStories = bpStories.SelectStoryByID(StoryID); BPPages bpPages = new BPPages(); BEPages dsPages = bpPages.SelectByPageTypeIDAndPageTypeSpecificID(PageTypeID, StoryID); if (dsStories.tbl_Stories.Count > 0) { DeleteRelatedPageLinks(); dsStories.tbl_Stories[0].Delete(); bpStories.Update(dsStories); if (dsPages.tbl_Pages.Count > 0) { DeleteImageGallery(dsPages.tbl_Pages[0].PageID); dsPages.tbl_Pages[0].Delete(); bpPages.Update(dsPages); } } BrowseRedirect(); }
private void BindStoryInfo() { if (StoryID > 0) { BPStories bp = new BPStories(); BEStories ds = bp.SelectStoryByID(StoryID); BEStories.tbl_StoriesRow story = null; if (ds.tbl_Stories.Count > 0) { story = ds.tbl_Stories[0]; GetPageID(); BindImageGalleryUserControl(); lblTitle.Text = "Edit " + story.StoryTitle; txtPageTitle.Text = story.StoryTitle; if (!story.IsStoryBody1Null()) edtContentBody1.Text = story.StoryBody1; else edtContentBody1.Text = ""; BindSelectedRelatedPages(); chkStoryActive.Checked = story.StoryActive; } } else { lblTitle.Text = "Add New " + SubTypeName + " Page"; btnDelete.Visible = false; edtContentBody1.Text = ""; plcNewGalleryMessage.Visible = true; plcInactiveGalleryMessage.Visible = false; ucImageGallery.Visible = false; } }