protected DataView GetData()
{
BPArticleCategories bp = new BPArticleCategories();
DSArticleCategories = bp.SelectByArticleTypeID(SubTypeID);
DSArticleCategories.tbl_ArticleCategories.DefaultView.Sort = DSArticleCategories.tbl_ArticleCategories.ArticleCategoryOrderColumn.ColumnName;
BindMoveControl(DSArticleCategories.tbl_ArticleCategories.DefaultView);
DSArticleCategories.tbl_ArticleCategories.DefaultView.RowFilter =
RowFilter(DSArticleCategories.tbl_ArticleCategories.ArticleCategoryNameColumn.ColumnName,
((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName,
DSArticleCategories.tbl_ArticleCategories.ArticleCategoryActiveColumn.ColumnName,
lstActive.SelectedValue);
return DSArticleCategories.tbl_ArticleCategories.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);
BPArticleCategories bp = new BPArticleCategories();
BEArticles ds = bp.SelectByArticleTypeID(SubTypeID);
BEArticles.tbl_ArticleCategoriesRow[] categoryRows =
(BEArticles.tbl_ArticleCategoriesRow[])ds.tbl_ArticleCategories.Select("", ds.tbl_ArticleCategories.ArticleCategoryOrderColumn.ColumnName);
BEArticles.tbl_ArticleCategoriesRow moveCategory = ds.tbl_ArticleCategories.FindByArticleCategoryID(ItemToMove);
foreach (BEArticles.tbl_ArticleCategoriesRow category in categoryRows)
{
if (found1 && found2)
break;
if (category.ArticleCategoryID == moveCategory.ArticleCategoryID)
{
found1 = true;
if (category.ArticleCategoryID == Position)
found2 = true;
}
else if (category.ArticleCategoryID == Position)
{
found2 = true;
if (rblBeforeAfter.SelectedValue == "0")
{
moveCategory.ArticleCategoryOrder = category.ArticleCategoryOrder;
category.ArticleCategoryOrder++;
}
else
{
if (found1)
category.ArticleCategoryOrder--;
moveCategory.ArticleCategoryOrder = category.ArticleCategoryOrder + 1;
}
}
else if (found1 && !found2)
category.ArticleCategoryOrder--;
else if (found2 && !found1)
category.ArticleCategoryOrder++;
}
bp.Update(ds);
dgArticleCategories.DataSource = GetData();
dgArticleCategories.DataBind();
}
