source: Dev/LoggingTool/TestSpreadsheetOutput.cs @ 532

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;

namespace LoggingTool
{
    class TestSpreadsheetOutput
    {

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

        public SpreadsheetOutputTest()
        {
            output = new TeamUpSpeadsheetOutput("kaidencez@gmail.com", "verboden", "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;

        public SpreadsheetLogicTest()
        {
            logic = new TeamUpLogic();
            output = new TeamUpSpeadsheetOutput("kaidencez@gmail.com", "verboden", "GDataTest");
            //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;


        }
    }*/
}