Random Unique Numbers in C#

Dj_Jestar · 10 Nov 2011 at 15:53

Right, then in that case:

Code:

if (list.items.Any()) {
  var numberToTake = 5 / list.items.Count() * 100;
  var theFivePercentOfRecords = list.items.OrderBy(each => Guid.NewGuid()).Take(numberToTake);
}

ringo747 · 10 Nov 2011 at 15:59

Dj_Jestar said:

Right, then in that case:

Code:

if (list.items.Any()) {
  var numberToTake = 5 / list.items.Count() * 100;
  var theFivePercentOfRecords = list.items.OrderBy(each => Guid.NewGuid()).Take(numberToTake);
}

Edit: ignore. stupid.

cotton31 · 10 Nov 2011 at 16:22

Still getting the same error for using .Any(), .Count() and .OrderBy() as you suggested?

ringo747 · 10 Nov 2011 at 16:31

You will possibly cast the list.items.count() to a double so that it will allow a decimal value on the division.

Code:

var numberToTake = ((5 / (double)list.Items.Count()) * 100);
var theFivePercentOfRecords = list.Items.OrderBy(each => Guid.NewGuid()).Take((int)numberToTake);

jennidc · 12 Nov 2011 at 03:54

what about using the hundreds of a second field from the system clock?

cotton31 · 13 Nov 2011 at 20:53

How do you mean?

ringo747 · 13 Nov 2011 at 21:27

Did you get rid of the errors you were having mate?

cotton31 · 14 Nov 2011 at 12:02

I didn't mate, not really looked at it since. Swamped with other stuff!

I'm going to try and look at it again this week, so expect more responses in this thread!

ringo747 · 14 Nov 2011 at 12:22

Stick up all the code and I'll try it in my MOSS VM.

cotton31 · 15 Nov 2011 at 12:34

Here it is mate, sorry for the delay!

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            //Declare sites
            SPSite sourceSite = new SPSite(@"http://sharepoint");

            //Declare webs
            SPWeb sourceWeb = sourceSite.RootWeb;

            //Declare lists
            SPLists sourceList = sourceWeb.GetList("/Lists/Staff Contacts");

            SPListItemCollection sourceItems = sourceList.Items;

            try
            {
                if (sourceList.Items.Any())
                {
                    var numberToTake = 5 / sourceList.Items.Count() * 100;
                    var thePercentOfRecords = sourceList.Items.OrderBy(each => Guid.NewGuid()).Take(numberToTake);
                }

                foreach (int n in thePercentOfRecords)
                {
                    SPListItem item = sourceList.Items[n];
                    String strFirstName = item["First Name"].ToString();
                    String strLastName = item["Last Name"].ToString();
                    String strFullName = strFirstName + " " + strLastName;
                    String strTeam = item["Team"].ToString();

                    CopyItem(strFullName, strTeam);

                }

                sourceWeb.Dispose();
                sourceSite.Dispose();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }

        static void CopyItem(String name, String team)
        {
            //Declare sites
            SPSite destSite = new SPSite(@"http://sharepoint/communications");

            //Declare webs
            SPWeb destWeb = destSite.OpenWeb();

            //Declare lists
            SPList destList = destWeb.Lists["Staff Satisfaction"];

            SPListItemCollection listItems = destList.Items;

            SPListItem item = listItems.Add();

            item["Staff Member"] = name;
            item["Team"] = team;

            item.Update();

            destWeb.Dispose();
            destSite.Dispose();
        }

    }
}

ringo747 · 15 Nov 2011 at 15:34

I think it is only the 2010 Object Model version that implements IEnumerable so this won't work for MOSS 2007 code. Will have a look in the VM later and see if I can get something working.

Dj_Jestar · 15 Nov 2011 at 15:57

it has always implemented IEnumerable.

@cotton31: Have you added a reference to System.Linq? take a screenshot of your IDE with the build errors visible.

ringo747 · 15 Nov 2011 at 16:05

From MSDN:

SharePoint 2010....
public class SPListItemCollection : SPBaseCollection, IEnumerable

WSS 3.0...
public class SPListItemCollection : SPBaseCollection

Does that not suggest that only 2010 implements IEnumerable?

I'm trying this in a VM and have added references to System.Core.dll and added using System.Linq and it doesn't work.

ringo747 · 15 Nov 2011 at 16:37

Give this a try. I haven't tested in my VM as I don't have the same SP objects/lists as you do but it builds and should work.

You will need to add some more error handling. I hope DJ doesn't critique my crappy code!

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                //Declare sites
                SPSite sourceSite = new SPSite(@"http://sharepoint");

                //Declare webs
                SPWeb sourceWeb = sourceSite.RootWeb;

                //Declare lists
                SPList sourceList = sourceWeb.GetList("/Lists/Staff Contacts");

                SPListItemCollection sourceItems = sourceList.Items;

                //Get a list of integers (5% of total)
                var queryset = RandomGenerator(0, sourceItems.Count, 5);

                foreach (int n in queryset)
                {
                    SPListItem item = sourceList.Items[n];
                    String strFirstName = item["First Name"].ToString();
                    String strLastName = item["Last Name"].ToString();
                    String strFullName = strFirstName + " " + strLastName;
                    String strTeam = item["Team"].ToString();

                    CopyItem(strFullName, strTeam);
                }

                sourceWeb.Dispose();
                sourceSite.Dispose();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }

        private static void CopyItem(String name, String team)
        {
            //Declare sites
            SPSite destSite = new SPSite(@"http://sharepoint/communications");

            //Declare webs
            SPWeb destWeb = destSite.OpenWeb();

            //Declare lists
            SPList destList = destWeb.Lists["Staff Satisfaction"];

            SPListItemCollection listItems = destList.Items;

            SPListItem item = listItems.Add();

            item["Staff Member"] = name;
            item["Team"] = team;

            item.Update();

            destWeb.Dispose();
            destSite.Dispose();
        }

        private static List<int> RandomGenerator(int start, int count, int percentage)
        {
            //Create two new lists
            List<int> list = new List<int>();
            List<int> result = new List<int>();

            //Populate a temporary list with all the possible values between start value + count
            for (int i = start; i < count; i++)
            {
                list.Add(i);
            }

            if (list.Any())
            {
                //Get the number of required values
                var numberToTake = ((percentage / (double)list.Count()) * 100);

                //Get a subset of the total
                var records = list.OrderBy(each => Guid.NewGuid()).Take((int)numberToTake);

                //Add the results to a list and return
                foreach (int i in records)
                {
                    result.Add(i);
                }
                return result;
            }
            else {
                return null;
            }
        }

    }
}

Dj_Jestar · 15 Nov 2011 at 16:40

ringo747 said:
From MSDN:

SharePoint 2010....
public class SPListItemCollection : SPBaseCollection, IEnumerable

WSS 3.0...
public class SPListItemCollection : SPBaseCollection

Does that not suggest that only 2010 implements IEnumerable?

I'm trying this in a VM and have added references to System.Core.dll and added using System.Linq and it doesn't work.

It implements SPBaseCollection, which implements ICollection, which extends IEnumerable.

It's not possible to use foreach on anything that doesn't implement IEnumerable. Try it. The error message will tell you exactly that.

ringo747 · 15 Nov 2011 at 16:49

Dj_Jestar said:
It implements SPBaseCollection, which implements ICollection, which extends IEnumerable.

It's not possible to use foreach on anything that doesn't implement IEnumerable. Try it. The error message will tell you exactly that.

The error message I was getting was this:

'Microsoft.SharePoint.SPListItemCollection' does not contain a definition for 'Any' and no extension method 'Any' accepting a first argument of type 'Microsoft.SharePoint.SPListItemCollection' could be found (are you missing a using directive or an assembly reference?)

Dj_Jestar · 15 Nov 2011 at 17:00

ringo747 said:
The error message I was getting was this:

'Microsoft.SharePoint.SPListItemCollection' does not contain a definition for 'Any' and no extension method 'Any' accepting a first argument of type 'Microsoft.SharePoint.SPListItemCollection' could be found (are you missing a using directive or an assembly reference?)

ringo747 · 15 Nov 2011 at 17:01

I would have said no to that!

Edit: I have added a reference to System.Core.dll which according to MSDN article I read is what is needed for System.Linq.

Dj_Jestar · 15 Nov 2011 at 17:08

Balls, just spotted what it is. .Any() is only supported on IEnumerable<T> not IEnumerable.

Revert to the old fashioned way:

Code:

if (list.items.Count > 0)

ringo747 · 15 Nov 2011 at 17:18

Ah ok. I'm assuming it's the same for OrderBy?