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