Example #1
0
        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;
        }
Example #2
0
        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();
        }