using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.SqlTypes;
using BrazilTimestampReconstruction;


namespace BrazilTimestampReconstructionTest
{
    class Program
    {
        public void ReconstructSimulationTimestamps()
        {
            string connStr = "Data Source=SDSSDB003;Initial Catalog=EcuadorStage;Integrated Security=True;";
            TimestampReconstruction btr = new TimestampReconstruction(connStr);
            btr.ReadAnchorInformation();
            btr.BuildTimeFits();
            btr.InsertIntoDatabase();
            //PrintResults(connStr);
        }
        public void PrintResults(string connStr)
        {
            try
            {
                string resultsString = "EXEC dbo.spTimestampAccuracy";
                SqlConnection conn = new SqlConnection(connStr);
                conn.Open();
                SqlCommand cmd = new SqlCommand(resultsString, conn);
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    string outstr = "";
                    outstr += rdr.GetInt32(0).ToString() + ",";
                    outstr += rdr.GetInt32(1).ToString() + ",";
                    outstr += rdr.GetSqlSingle(2).ToString() + ",";
                    outstr += rdr.GetSqlSingle(3).ToString() + ",";
                    Console.Out.Write(outstr);
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                Console.Out.WriteLine(ex.ToString());
            }
        }
        static void Main(string[] args)
        {
            Program worker = new Program();
            worker.ReconstructSimulationTimestamps();
        }
    }
}