using System;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Diagnostics;

using WmData;

namespace WillemsWeerWachter {
    public class WmDataIntermediar {
        protected static WillemsWeerWachter willemsWeerWachter = null;
        public static WillemsWeerWachter WillemsWeerWachter {
            get { return willemsWeerWachter; }
            set { willemsWeerWachter = value; }
        }
        
        protected static Forecaster forecaster = null;
        public static Forecaster Forecaster {
            get { return forecaster; }
            set { forecaster = value; }
        }

        protected static WmData.WmData data;
        protected static WmData.WmData Data {
            get { return data; }
            set { data = value; }
        }

        public static void initiateData(string databaseUsername, string databasePassword, string databaseHost, int databasePort, string databaseCatalog) {
            data = new WmData.WmData(databaseUsername, databasePassword, databaseHost, databasePort, databaseCatalog);
        }

        public static void initWorkers() {
            forecaster = new Forecaster();
            willemsWeerWachter = new WillemsWeerWachter();
        }

        public static Status getStatus() {
            Status status = (Status) Data.getObject(typeof(Status), 1);
            if (status == null) {
                status = new Status();
                status.Id = 1;
                status.LastWeatherUpdate = new DateTime(1985, 09, 10);
                status.LastTideUpdate = new DateTime(1985, 09, 10);
                status.WarningCount = 0;
                status.WeatherUpdateCount = 0;
                status.TideUpdateCount = 0;
                Data.addObject(status, true);
                return getStatus();
            } else {
                return status;
            }
        }
        public static void updateStatus(Status updateItem) {
            Data.updateObject(updateItem);
        }

        public static KiteForecast getKiteForecast(int id) {
            return (KiteForecast) Data.getObject(typeof(KiteForecast), id);
        }
        public static KiteForecast[] getKiteForecasts(string select) {
            ArrayList tmpRes = Data.getObjects(typeof(KiteForecast), select);
            tmpRes.Sort();
            return (KiteForecast[]) tmpRes.ToArray(typeof(KiteForecast));
        }
        public static void addKiteForecast(KiteForecast addItem) {
            Data.addObject(addItem);
        }
        public static void updateKiteForecast(KiteForecast updateItem) {
            Data.updateObject(updateItem);
        }
        public static void deleteKiteForecast(KiteForecast deleteItem) {
            Data.deleteObject(deleteItem);
        }
        public static KiteForecast getKiteForecast(DateTime date) {
            string select = "date='" + date.Date.ToString() + "'";
            KiteForecast forecast = (KiteForecast) Data.getObject(typeof(KiteForecast), select);
            if (forecast == null) {
                forecast = new KiteForecast();
                forecast.Date = date;
                addKiteForecast(forecast);
                return getKiteForecast(date);
            } else {
                return forecast;
            }
        }
    }
}