using System;

using System.Data;

using Newtonsoft.Json;

using System.Xml;

using System.Text;

​

​

// Resource allocation 

public class Program

{

    public static string ass(DataTable table)

    {

        string JSONString = string.Empty;

        JSONString = JsonConvert.SerializeObject(table);

        return JSONString;

    }

​

    public static string stringout(int current, int total, string a, string b)

    {

        if (current < total)

        {

            return ("\"" + a + "\":" + "\"" + b + "\",");

        }

        else if (current == total)

        {

            return ("\"" + a + "\":" + "\"" + b + "\"");

        }

​

        return "";

    }

​

    public static string stringbuild(DataTable table, DataTable resources)

    {

        var JSONString = new StringBuilder();

        if (table.Rows.Count > 0)

        {

            JSONString.Append("[");

            int a = 0;

            for (int k = 0; k < resources.Rows.Count; k++)

            {

                JSONString.Append("{" + "\"" + resources.Columns[2].ColumnName.ToString() + "\":" + "\"" + resources.Rows[k][2].ToString() + "\",");

                JSONString.Append("\"tasks\":");

                JSONString.Append("[");

                int counter = a + Convert.ToInt32(resources.Rows[k][1].ToString());

                //Console.WriteLine(counter);

                for (int i = a; i < counter; i++)

                {

                    JSONString.Append("{");

                    if (i == 0)

                    {

                        JSONString.Append("\"" + table.Columns[3].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][3].ToString() + "\",");

                    }

​

                    JSONString.Append("\"" + table.Columns[1].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][1].ToString() + "\",");

                    JSONString.Append("\"" + table.Columns[2].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][2].ToString() + "\",");

                    JSONString.Append("\"" + table.Columns[4].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][4].ToString() + "\"");

                    if (i == counter - 1)

                    {

                        JSONString.Append("}");

                    }

                    else

                    {

                        JSONString.Append("},");

                    }

​

                    a++;

                }

​

                JSONString.Append("]");

                if (k == resources.Rows.Count - 1)

                {

                    JSONString.Append("}");

                }

                else

                {

                    JSONString.Append("},");

                }

            }

​

            JSONString.Append("]");

        }

​

        return JSONString.ToString();

    }

​

    public static DataTable getDataR()

    {

        //SELECT rid ID,count(rid) count,name task FROM trans inner join resources where trans.rid=resources.id group by rid

        DataTable dt = new DataTable();

        dt.Columns.Add("ID", typeof (Int32));

        dt.Columns.Add("count", typeof (Int32));

        dt.Columns.Add("resource", typeof (String));

        dt.Rows.Add(1, 1, "jcb");

        dt.Rows.Add(2, 2, "plotter");

        return dt;

    }

​

    public static DataTable getData()

    {

        //SELECT rid,task.start star,name FROM trans inner join task where trans.tid = task.id

        DataTable dt = new DataTable();

        dt.Columns.Add("ID", typeof (Int32));

        dt.Columns.Add("start", typeof (string));

        dt.Columns.Add("end", typeof (string));

        dt.Columns.Add("color", typeof (string));

        dt.Columns.Add("task", typeof (string));

        dt.Rows.Add(1, "2016-01-01", "2016-01-10", "#7B742C", "slab fill");

    //  dt.Rows.Add(1, "2016-01-10", "2016-01-14", "", "task2");

    //  dt.Rows.Add(1, "2016-01-16", "2016-01-28", "", "task3");

        dt.Rows.Add(2, "2016-01-10", "2016-01-23", "#7B742C", "slabfill");

        dt.Rows.Add(2, "2016-01-11", "2016-01-24", "", "flooring");

        return dt;

    }

​

    public static void Main()

    {

        DataTable task = getData();

        DataTable resources = getDataR();

        string outout = stringbuild(task, resources);

        Console.WriteLine(outout);

    }

}