How to move a row from one group to another group in Rad Grid.

[Abhi Shinde]

Hi,
        I am using radGrid. My radGrid contain all posted "Questions" and Group by "Question Category".
I want to reorder questions and update it into database. 
Reordering is working fine for same category BUT if i drop a row from one category to another, it wont work.

here, after dropping a row, how can i get destination "categoryID"....?????
  
(in grid itself, I want to move a question from one category to another category. )

protected void rgQuestions_RowDrop(object sender, GridDragDropEventArgs e)
    {
        if (e.DestDataItem != null && e.DestDataItem.OwnerGridID == rgQuestions.ClientID)
        {
            //reorder items in pending grid
            IList<Question> questions = Questions;
            Question order = GetQuestion(questions, (Int64)e.DestDataItem.GetDataKeyValue("Q_QuestionId"));
            int destinationIndex = questions.IndexOf(order);

            if (e.DropPosition == GridItemDropPosition.Above && e.DestDataItem.ItemIndex > e.DraggedItems[0].ItemIndex)
            {
                destinationIndex -= 1;
            }
            if (e.DropPosition == GridItemDropPosition.Below && e.DestDataItem.ItemIndex < e.DraggedItems[0].ItemIndex)
            {
                destinationIndex += 1;
            }

            List<Question> ordersToMove = new List<Question>();
            foreach (GridDataItem draggedItem in e.DraggedItems)
            {
                Question tmpOrder = GetQuestion(questions, (Int64)draggedItem.GetDataKeyValue("Q_QuestionId"));
                if (tmpOrder != null)
                    ordersToMove.Add(tmpOrder);
            }


            foreach (Question orderToMove in ordersToMove)
            {
                questions.Remove(orderToMove);

                questions.Insert(destinationIndex, orderToMove);
            }
            Questions = questions;
            rgQuestions.Rebind();

            foreach (GridDataItem item in rgQuestions.MasterTableView.Items)
            {
                Question tmpOrder = GetQuestion(questions, (Int64)item.GetDataKeyValue("Q_QuestionId"));

                string strQry = "Update Assess_QuestionMaster set Q_Order='"+ item.ItemIndex.ToString() +"' where Q_Questionid='" + tmpOrder.Q_QuestionId +"'";
                MySQL.ExecuteSQL(strQry);

            }
            rgQuestions.Rebind();
            int destinationItemIndex = destinationIndex - (rgQuestions.PageSize * rgQuestions.CurrentPageIndex);
            e.DestinationTableView.Items[destinationItemIndex].Selected = true;
        }
    }

plsss reply .....
Thanks 

protected void rgQuestions_RowDrop(object sender, GridDragDropEventArgs e)

    {

        if (e.DestDataItem != null && e.DestDataItem.OwnerGridID == rgQuestions.ClientID)

        {

            //reorder items in pending grid

            IList<Question> questions = Questions;

            Question order = GetQuestion(questions, (Int64)e.DestDataItem.GetDataKeyValue("Q_QuestionId"));

            int destinationIndex = questions.IndexOf(order);

 

            if (e.DropPosition == GridItemDropPosition.Above && e.DestDataItem.ItemIndex > e.DraggedItems[0].ItemIndex)

            {

                destinationIndex -= 1;

            }

            if (e.DropPosition == GridItemDropPosition.Below && e.DestDataItem.ItemIndex <e.DraggedItems[0].ItemIndex)

            {

                destinationIndex += 1;

            }

 

            List<Question> ordersToMove = new List<Question>();

            foreach (GridDataItem draggedItem in e.DraggedItems)

            {

                Question tmpOrder = GetQuestion(questions, (Int64)draggedItem.GetDataKeyValue("Q_QuestionId"));

                if (tmpOrder != null)

                    ordersToMove.Add(tmpOrder);

            }

             

 

            foreach (Question orderToMove in ordersToMove)

            {

                questions.Remove(orderToMove);

 

                questions.Insert(destinationIndex, orderToMove);

            }

            Questions = questions;

            rgQuestions.Rebind();

 

            foreach (GridDataItem item in rgQuestions.MasterTableView.Items)

            {

                Question tmpOrder = GetQuestion(questions, (Int64)item.GetDataKeyValue("Q_QuestionId"));

 

                string strQry = "Update Assess_QuestionMaster set Q_Order='"+ item.ItemIndex.ToString() +"' where Q_Questionid='" + tmpOrder.Q_QuestionId +"'";

                MySQL.ExecuteSQL(strQry);

 

            }

            rgQuestions.Rebind();

            int destinationItemIndex = destinationIndex - (rgQuestions.PageSize * rgQuestions.CurrentPageIndex);

            e.DestinationTableView.Items[destinationItemIndex].Selected = true;

        }

    }

[Iana Tsolova]

Hello Abhi,

In order to achieve your goal, you need to handle the RowDrop server-side event as you already found. There make sure you have updated the Category field for the dropped row record to the Category of the destination row and rebind the grid.

Best wishes,
Iana
the Telerik team

[Abhi Shinde]

off-course I want to pass the categoryID but My question is that, How can I get destination categoryID.??    

[Iana Tsolova]

Hi,

In the RowDrop event handler e.DestinationItem is a reference to the destination item. The you can get the CategoryId as below if where CategoryId is the UniqueName of the CategoryId column:

e.DestinationItem["CategoryId"].Text.

For more information on accessing grid cells and row, refer to this article.

Greetings,
Iana
the Telerik team