ReorderList_ItemReorder not properly reordering RSS

• • Reply
  

  surajjoshi13

  Member

  11 Points

  25 Posts

  ReorderList_ItemReorder not properly reordering

  Feb 13, 2012 12:11 PM|LINK

  protected void ReorderList1_ItemReorder(object sender, AjaxControlToolkit.ReorderListItemReorderEventArgs e)
      {
          System.Threading.Thread.Sleep(5000);
          int ListItemCount = 1;
          int NewOrder = e.NewIndex + 1;
          int OldOrder = e.OldIndex + 1; string temp=string.Empty;
          ReorderList li = (ReorderList)sender;
          foreach(ReorderListItem lii in li.Items) {
              if (OldOrder > NewOrder && ListItemCount >= NewOrder && ListItemCount < OldOrder)
              { temp = (ListItemCount + 1).ToString(); }
              else if (OldOrder < NewOrder && ListItemCount <= NewOrder && ListItemCount > OldOrder)
              { temp = (ListItemCount - 1).ToString(); }
              else if (OldOrder > NewOrder && ListItemCount == NewOrder) { temp = OldOrder.ToString(); }
              else if (OldOrder < NewOrder && ListItemCount == OldOrder) { temp = NewOrder.ToString(); }
              else { temp = (lii.ItemIndex+1).ToString(); }
              ListItemCount++;
          string ReorderListItemID = ReorderList1.DataKeys[lii.ItemIndex].ToString();
          d1.RunQuery_execnonquery("update HeaderSlider set sort_order='" + temp + "' where hsid='" + ReorderListItemID.ToString() + "'", null, CommandType.Text);
          }
          ReorderList1.DataSource = d1.RunQuery_Dataset("select hsid,linkid,linkname,sort_order,proids,catORsubcat,(select case when HeaderSlider.catORsubcat='1' then (select category from category where category.pro_cat_id=HeaderSlider.linkid)else(select pro_type from sub_category where sub_category.pro_type_id=HeaderSlider.linkid) end) as category from HeaderSlider order by sort_order", null, CommandType.Text);
          ReorderList1.DataBind();
      }
  
  
  Can you help me? so please help for this... thanx in advance...

  • Edited by surajjoshi13 on Feb 15, 2012 12:36 PM
• • Reply
  

  chetan.sarod...

  All-Star

  65749 Points

  11148 Posts

  Re: ReorderList_ItemReorder not properly reordering

  Feb 14, 2012 02:44 AM|LINK

  Hello

  For doing reorderlist events, you may refer to this post , see if it works for you.

  http://prasadmaduranga.blogspot.com/2009/08/ajax-reorder-list-issues-and-solutions.html

  Chetan Sarode
  Senior Software Engineer,
  Approva Systems Pvt Ltd, Pune, India.
  
  • Edited by chetan.sarode on Feb 15, 2012 12:36 PM
  • Marked as answer by Song-Tian - MSFT on Feb 17, 2012 08:23 AM
• • Reply
  

  surajjoshi13

  Member

  11 Points

  25 Posts

  Re: ReorderList_ItemReorder not properly reordering

  Apr 21, 2012 06:09 AM|LINK

  protected void ReorderList1_ItemReorder(object sender, AjaxControlToolkit.ReorderListItemReorderEventArgs e)
      {
          System.Threading.Thread.Sleep(2000);
          int ListItemCount = 1;
          int NewOrder = e.NewIndex;
          int OldOrder = e.OldIndex; string temp = string.Empty;
          string selectedDK = ReorderList1.DataKeys[OldOrder].ToString();
          string selectednDK = ReorderList1.DataKeys[NewOrder+1].ToString();
          string selectedoDK = ReorderList1.DataKeys[NewOrder].ToString();
          string[] sdk = new string[ReorderList1.DataKeys.Count];
          for (int z = 0; z < ReorderList1.DataKeys.Count; z++)
          {
              sdk[z] = ReorderList1.DataKeys[z].ToString();
              if (sdk[z].ToString() != selectedDK) {
                  if (string.IsNullOrEmpty(temp)) { temp = sdk[z].ToString(); }
                  else { temp += "^" + sdk[z].ToString(); }
              }
          }
          int newPriority = 0;
          string[] rolArr = null; rolArr = temp.Split('^');
          if (OldOrder > NewOrder)
          {
              foreach (var x in rolArr) { if(Convert.ToInt32(x)!=Convert.ToInt32(selectedoDK)){ newPriority = newPriority+1;
              "update HeaderSlider set sort_order='" + newPriority + "' where hsid='" + x + "'"
              }else{newPriority = newPriority+1+1;
              "update HeaderSlider set sort_order='" + newPriority + "' where hsid='" + x + "'"
              } }
          }
          else
          {
              foreach (var x in rolArr) { if(Convert.ToInt32(x)!=Convert.ToInt32(selectednDK)){ newPriority = newPriority+1;
              "update HeaderSlider set sort_order='" + newPriority + "' where hsid='" + x + "'"
              }else{newPriority = newPriority+1+1;
              "update HeaderSlider set sort_order='" + newPriority + "' where hsid='" + x + "'"
              } }
          }
          "update HeaderSlider set sort_order='" + Convert.ToInt32(NewOrder+1).ToString() + "' where hsid='" + selectedDK + "'"
          ReorderList1.DataSource =
          ReorderList1.DataBind();
          DropDownList ddlinsert1 = (DropDownList)ReorderList1.FindControl("_rliInsert").FindControl("ddlinsert1");
          "select pro_cat_id,category from category where pro_cat_id!='1'
          ddlinsert1.DataSource = ds.Tables[0];
          ddlinsert1.DataValueField = ds.Tables[0].Columns[0].ToString();
          ddlinsert1.DataTextField = ds.Tables[0].Columns[1].ToString(); ddlinsert1.DataBind();
      }

  • Marked as answer by surajjoshi13 on Apr 21, 2012 06:09 AM