using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using HeuristicLab.Hive.Server.DataAccess;
using HeuristicLab.Hive.Contracts.BusinessObjects;
using HeuristicLab.DataAccess.ADOHelper;
using HeuristicLab.Hive.Server.ADODataAccess.dsHiveServerTableAdapters;
using System.Data.Common;
using System.Data.SqlClient;
using HeuristicLab.Hive.Server.ADODataAccess.TableAdapterWrapper;
using System.IO;

namespace HeuristicLab.Hive.Server.ADODataAccess {
  class JobResultsAdapter: 
    DataAdapterBase<dsHiveServerTableAdapters.JobResultTableAdapter, 
                    JobResult, 
                    dsHiveServer.JobResultRow>,
    IJobResultsAdapter {
    #region Fields
    private IClientAdapter clientAdapter = null;

    private IClientAdapter ClientAdapter {
      get {
        if (clientAdapter == null)
          clientAdapter =
            this.Session.GetDataAdapter<ClientInfo, IClientAdapter>();

        return clientAdapter;
      }
    }

    private IJobAdapter jobAdapter = null;

    private IJobAdapter JobAdapter {
      get {
        if (jobAdapter == null)
          jobAdapter =
            this.Session.GetDataAdapter<Job, IJobAdapter>();

        return jobAdapter;
      }
    }
    #endregion

    public JobResultsAdapter(): base(new JobResultsAdapterWrapper()) {
    }

    #region Overrides
    protected override dsHiveServer.JobResultRow ConvertObj(JobResult result,
      dsHiveServer.JobResultRow row) {
      if (row != null && result != null) {
        if (result.JobId != Guid.Empty)
          row.JobId = result.JobId;
        else
          row.SetJobIdNull();

        if (result.ClientId != Guid.Empty)  {
          ClientInfo client = 
                 ClientAdapter.GetById(result.ClientId);

          if (client != null)
            row.ResourceId = client.Id;
          else
            row.SetResourceIdNull();
        }           
        else
          row.SetResourceIdNull();

        if (result.Exception != null)
          row.Message = result.Exception.ToString();
        else
          row.SetMessageNull();

        row.Percentage = result.Percentage;

        if (result.DateFinished != DateTime.MinValue)
          row.DateFinished = result.DateFinished;
        else
          row.SetDateFinishedNull();

        return row;
      } else
        return null;
    }

    protected override JobResult ConvertRow(dsHiveServer.JobResultRow row, 
      JobResult result) {
      if (row != null && result != null) {
        result.Id = row.JobResultId;

        if (!row.IsJobIdNull())
          result.JobId = row.JobId;
        else
          result.JobId = Guid.Empty;

        if (!row.IsResourceIdNull())
          result.ClientId = row.ResourceId;
        else
          result.ClientId = Guid.Empty;

        if (!row.IsMessageNull())
          result.Exception = new Exception(row.Message);
        else
          result.Exception = null;

        result.Percentage = row.Percentage;

        if (!row.IsDateFinishedNull())
          result.DateFinished = row.DateFinished;
        else
          result.DateFinished = DateTime.MinValue;

        return result;
      } else
        return null;
    }
    #endregion

    #region IJobResultsAdapter Members
    public ICollection<JobResult> GetResultsOf(Guid jobId) {
        return 
          base.FindMultiple(
            delegate() {
              return Adapter.GetDataByJob(jobId);
            });
    }

    public JobResult GetLastResultOf(Guid jobId) {
        return 
          base.FindSingle(
            delegate() {
              return Adapter.GetDataByLastResult(jobId);
            });
    }

    public SerializedJobResult GetSerializedJobResult(Guid jobResultId) {
      return (SerializedJobResult)base.doInTransaction(
        delegate() {
          SerializedJobResult jobResult =
            new SerializedJobResult();

          jobResult.JobResult = GetById(jobResultId);
          if (jobResult.JobResult != null) {
            jobResult.SerializedJobResultData =
              base.Adapter.GetSerializedJobResultById(jobResultId);

            return jobResult;
          } else {
            return null;
          }
        });
    }

    public Stream GetSerializedJobResultStream(Guid jobResultId, bool useExistingConnection) {
      return
        ((JobResultsAdapterWrapper)
        base.DataAdapterWrapper).
          GetSerializedJobResultStream(jobResultId, useExistingConnection);
    }

    public void UpdateSerializedJobResult(SerializedJobResult jobResult) {
      if (jobResult != null &&
        jobResult.JobResult != null) {
        base.doInTransaction(
          delegate() {
            Update(jobResult.JobResult);
            return base.Adapter.UpdateSerializedJobResultById(
              jobResult.SerializedJobResultData,
              jobResult.JobResult.Id);
          });
      }
    }
    #endregion
  }
}