using System;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public class BudgetDataSource

    {

        public int Order {get;set;}

        public long? BudgetDataSourceLookupId {get;set;}

        public string PaddockActionManagerBudgetId {get;set;}

        public long?WorksheetGroupId {get;set;}

    }

    public static void Main()

    {

        var strDataSource = "11  8   7   5   3   1   2   10  9   6   ";

        var result = CreateBudgetDataSources(strDataSource,1);

        foreach(var r in result)

        {

            Console.WriteLine("-----");

            Console.WriteLine("DataSource Order "+ r.Order);

            Console.WriteLine("DataSource budget "+ r.BudgetDataSourceLookupId);

            Console.WriteLine("DataSource paddock "+ r.PaddockActionManagerBudgetId);

            Console.WriteLine("DataSource worksheetgroup "+ r.WorksheetGroupId);

        }

        Console.WriteLine("Hello World");

    }

        public static List<BudgetDataSource>  CreateBudgetDataSources(string dataSourceStrRaw, int startOrder)

        {

            var result = new List<BudgetDataSource>();

            var dataSourceRaws = dataSourceStrRaw.Split(new[] {"  "}, StringSplitOptions.RemoveEmptyEntries);

​

            foreach(var dataSourceRaw in dataSourceRaws)

            {

                if(string.IsNullOrWhiteSpace(dataSourceRaw) == true) 

                {

                    Console.WriteLine("WhiteSpace detected" +dataSourceRaw);

                    continue;

                }

                BudgetDataSource dataSource = new BudgetDataSource()

                {

                    Order = startOrder                  

                };

​

                if (dataSourceRaw.Contains('P'))

                {

                    dataSource.BudgetDataSourceLookupId = 1;

                    dataSource.PaddockActionManagerBudgetId = dataSourceRaw;

                }

                else

                {                   

                    var dataSourceId = Convert.ToInt64(dataSourceRaw);

                    dataSource.BudgetDataSourceLookupId = 2;

                    //at the moment, we treat all the budget records using pam worksheet, 

                    // customise worksheet is treated in different story

                    dataSource.WorksheetGroupId = Convert.ToInt64(dataSourceRaw);                    

                }

                result.Add(dataSource);

                startOrder++;

            }           

            return result;

        }

​

}