source: Dev/LoggingTool/TestSpreadsheetOutput.cs @ 3

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Google.GData.Client;
using Google.GData.Extensions;
using Google.GData.Spreadsheets;
using LoggingTool.interfaces;
using LoggingTool.models;
using System.IO;
using UDKTCPLink;
using LoggingTool.network;
using System.Threading;

namespace LoggingTool
{
    class TestSpreadsheetOutput
    {

        /*static void Main(string[] args)
        {
            //new SpreadsheetLogicTest();
            Console.ReadKey();
        }*/
    }
    class SpreadsheetOutputTest
    {
        private ILoggerOutput output;

        public SpreadsheetOutputTest()
        {
            output = new TeamUpSpeadsheetOutput("cpsgamingstreet@gmail.com", "wachtwoord2009", "GDataTest");
            LoggerMessage questionnaireMessage = new TeamUpSpreadsheetMessage(TeamUpSpreadsheetMessage.QUESTIONNAIRE, new List<String>() {"1", "11.8940", "1", "20", "0", "1", "2", "3", "4", "5", "6", "7", "8"});
            LoggerMessage eventMessage = new TeamUpSpreadsheetMessage(TeamUpSpreadsheetMessage.EVENT, new List<String>() {"1", "11.8940", "1337"});
            output.send(questionnaireMessage);
            output.send(eventMessage);
        }
    }

    /* class SpreadsheetLogicTest
     {
         private ILoggerLogic logic;
         private ILoggerOutput output;
         private ILoggerInput input;

         public SpreadsheetLogicTest()
         {

             Console.WriteLine("Setting up Logic");
             logic = new TeamUpLogic();
             Console.WriteLine("Setting up Output");
             output = new TeamUpSpeadsheetOutput("cpsgamingstreet@gmail.com", "wachtwoord2009", "GDataTest");
             Console.WriteLine("Setting up Input");
             input = new TeamUpInput(logic);

             Console.WriteLine("Setting up Server");
             TeamUpServer server = new TeamUpServer();
             Console.WriteLine("Setting Protocol");
             server.Protocol = new TeamUpProtocol(server);
             Console.WriteLine("Activating Server");
             server.Activate(input);
             while (true)
                 Thread.Sleep(1000);
            
            
            /* 
             //Create some filestreams for testing purposes
             FileStream fQ = new FileStream("D:\\jkraaijeveld\\Desktop\\questionnaires.log", FileMode.Open);
             FileStream fE = new FileStream("D:\\jkraaijeveld\\Desktop\\events.log", FileMode.Open);
             StreamReader sQ = new StreamReader(fQ);
             StreamReader sE = new StreamReader(fE);

             //Read everything in both of the files
             while (!sQ.EndOfStream)
             {
                 logic.addInput(sQ.ReadLine());
             }
             while (!sE.EndOfStream)
             {
                 logic.addInput(sE.ReadLine());
             }

             //Create all the models
             logic.createModels();
             //Write them
             List<LoggerMessage> messages = logic.formatModels();
             foreach (LoggerMessage message in messages)
             {
                 output.send(message);
             }
         }
     }*/









    /*static void Main(string[] args)
        {
            //Login to google docs
            SpreadsheetsService service = new SpreadsheetsService("testLogger");
            
            //Retrieve all spreadsheets in the account
            SpreadsheetQuery query = new SpreadsheetQuery();
            SpreadsheetFeed feed = service.Query(query);

            Console.WriteLine("All spreadsheets:");
            SpreadsheetEntry testEntry = new SpreadsheetEntry();
            foreach (SpreadsheetEntry entry in feed.Entries)
            {
                Console.WriteLine(entry.Title.Text);
                if(entry.Title.Text.Equals("GDataTest"))
                {
                    testEntry = entry;
                }
            }

            //Get the first worksheet
            AtomLink link = testEntry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
            WorksheetQuery workSheetQuery = new WorksheetQuery(link.HRef.ToString());
            WorksheetFeed workSheetFeed = service.Query(workSheetQuery);
            WorksheetEntry worksheet = (WorksheetEntry)workSheetFeed.Entries.First();

            writeRow(service, worksheet);

            //Prompt user for cell to update
            Console.Write("Row of cell to update? ");
            string row = Console.ReadLine();
            Console.Write("Column of cell to update? ");
            string col = Console.ReadLine();

            //Get the proper cell
            AtomLink cellFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
            CellQuery cellQuery = new CellQuery(cellFeedLink.HRef.ToString());
            cellQuery.MinimumRow = cellQuery.MaximumRow = uint.Parse(row);
            cellQuery.MinimumColumn = cellQuery.MaximumColumn = uint.Parse(col);
            CellFeed cellFeed = service.Query(cellQuery);
            CellEntry cell = (CellEntry)cellFeed.Entries.First();

            Console.Write("Enter a new Value: ");
            cell.Cell.InputValue = Console.ReadLine();
            AtomEntry updatedCell = cell.Update();


            Console.ReadKey();

        }

        public static void writeRow(SpreadsheetsService service, WorksheetEntry worksheet)
        {
            String[] testArray = new String[] { "Testing", "inserting", "row", "into", "spreadsheet" };


            AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);

            ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
            ListFeed feed = service.Query(query);

            ListEntry firstRow = feed.Entries[0] as ListEntry;
            ListEntry newRow = new ListEntry();


            for (int i = 0; i < testArray.Length; i++)
            {

                ListEntry.Custom element = firstRow.Elements[i];
                ListEntry.Custom curElement = new ListEntry.Custom();
                curElement.LocalName = element.LocalName;
                curElement.Value = testArray[i];

                newRow.Elements.Add(curElement);
            }

            Console.WriteLine("Row is inserted when you press a key.");
            Console.ReadKey();

            ListEntry insertedRow = feed.Insert(newRow) as ListEntry;


        }
    }*/
}