source: branches/3.3-Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.Server.LINQDataAccess/3.3/PluginInfoDao.cs @ 4423

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using HeuristicLab.Hive.Contracts.BusinessObjects;
using HeuristicLab.Hive.Server.DataAccess;

namespace HeuristicLab.Hive.Server.LINQDataAccess {
  public class PluginInfoDao: BaseDao<HivePluginInfoDto, PluginInfo>, IPluginInfoDao {
    #region IGenericDao<HivePluginInfoDto,PluginInfo> Members

    public HivePluginInfoDto FindById(Guid id) {
      return (from pi in Context.PluginInfos
              where pi.PluginId.Equals(id)
              select EntityToDto(pi, null)
             ).SingleOrDefault();  
    }

    public IEnumerable<HivePluginInfoDto> FindAll() {
      return (from pi in Context.PluginInfos              
              select EntityToDto(pi, null)
       ).ToList();  
    }

    public HivePluginInfoDto Insert(HivePluginInfoDto bObj) {
      PluginInfo pi = DtoToEntity(bObj, null);
      Context.PluginInfos.InsertOnSubmit(pi);
      CommitChanges();
      bObj.Id = pi.PluginId;
      return bObj;
    }

    public void Delete(Guid id) {
      PluginInfo pi = Context.PluginInfos.SingleOrDefault(p => p.PluginId.Equals(id));
      Context.PluginInfos.DeleteOnSubmit(pi);      
    }

    public void Update(HivePluginInfoDto bObj) {
      PluginInfo pi = Context.PluginInfos.SingleOrDefault(p => p.PluginId.Equals(bObj.Id));
      DtoToEntity(bObj, pi);
      CommitChanges();
    }

    public void InsertPluginDependenciesForJob(JobDto jobDto) {
      foreach (HivePluginInfoDto info in jobDto.PluginsNeeded) {                
        PluginInfo dbpi =
          Context.PluginInfos.Where(pi => pi.Name.Equals(info.Name) && pi.Version == info.Version.ToString()).SingleOrDefault();
        if (dbpi == null) {
          dbpi = new PluginInfo {
                                  Name = info.Name,
                                  Version = info.Version.ToString()
                                };
          Context.PluginInfos.InsertOnSubmit(dbpi);
          CommitChanges();
        }

        RequiredPlugin rq = new RequiredPlugin();
        rq.JobId = jobDto.Id;
        rq.PluginInfo = dbpi;
        Context.RequiredPlugins.InsertOnSubmit(rq);
        CommitChanges();
      }
    }

    public List<HivePluginInfoDto> GetPluginDependenciesForJob(JobDto jobDto) {
      return (from rp in Context.RequiredPlugins
              where rp.JobId.Equals(jobDto.Id)
              select EntityToDto(rp.PluginInfo, null)).ToList();
      
    }

    #endregion

    // Build Date not mapped - won't matter anyway, it's a obsolete field.
    public override PluginInfo DtoToEntity(HivePluginInfoDto source, PluginInfo target) {
      if (source == null)
        return null;
      if (target == null)
        target = new PluginInfo();

      target.Name = source.Name;
      target.PluginId = source.Id;
      target.Version = source.Version.ToString();      

      return target;

    }

    public override HivePluginInfoDto EntityToDto(PluginInfo source, HivePluginInfoDto target) {
      if (source == null)
        return null;
      if (target == null)
        target = new HivePluginInfoDto();

      target.Name = source.Name;
      target.Id = source.PluginId;
      target.Version = new Version(source.Version);

      return target;
    }
  }
}