Changeset 4381 for trunk/sources/HeuristicLab.Services.OKB/3.3/AdminService.cs

Timestamp:

09/13/10 01:21:32 (14 years ago)

Author:

swagner

Message:

Worked on OKB data model and services (#1174).

File:

• trunk/sources/HeuristicLab.Services.OKB/3.3/AdminService.cs (modified) (6 diffs)

trunk/sources/HeuristicLab.Services.OKB/3.3/AdminService.cs

@@ -24 +24 @@
 using System.ServiceModel;
 using HeuristicLab.Services.OKB.DataAccess;
-using log4net;
 
 namespace HeuristicLab.Services.OKB {
-
   /// <summary>
   /// Implementation of <see cref="IAdminService"/>
   /// </summary>
-  [ServiceBehavior(
-    InstanceContextMode = InstanceContextMode.PerSession,
-    IncludeExceptionDetailInFaults = true)]
+  [ServiceBehavior(IncludeExceptionDetailInFaults = true)]
   public class AdminService : IAdminService {
-
-    private static ILog logger = LogManager.GetLogger(typeof(AdminService));
-
-    private OKBDataContext GetDataContext() {
-      return new OKBDataContext();
-    }
-
     /// <summary>
     /// Gets all available platforms.
     /// </summary>
     /// <returns>A list of <see cref="Platform"/>s.</returns>
-    public Platform[] GetPlatformNames() {
-      OKBDataContext okb = GetDataContext();
-      return okb.Platforms.ToArray();
+    public Platform[] GetPlatforms() {
+      using (OKBDataContext okb = new OKBDataContext()) {
+        return okb.Platforms.ToArray();
+      }
     }
 
@@ -54 +44 @@
     /// Gets the complete algorithm object graph up to the following entities:
     /// <list type="bullet">
-    ///     <item>Parameter</item>
-    ///     <item>Algorithm_Paramters.Parameter.DataType</item>
-    ///     <item>Algorithm_Results.Result.DataType</item>
-    ///   </list>
+    ///   <item>Parameter</item>
+    ///   <item>Algorithm_Paramters.Parameter.DataType</item>
+    ///   <item>Algorithm_Results.Result.DataType</item>
+    /// </list>
     /// </summary>
     /// <param name="id">The algorithm id.</param>
     /// <returns>An <see cref="Algorithm"/></returns>
     public Algorithm GetCompleteAlgorithm(int id) {
-      OKBDataContext okb = GetDataContext();
-      var dlo = new DataLoadOptions();
-      dlo.LoadWith<Algorithm>(a => a.Platform);
-      dlo.LoadWith<Algorithm>(a => a.Algorithm_Parameters);
-      dlo.LoadWith<Algorithm>(a => a.Algorithm_Results);
-      dlo.LoadWith<Algorithm_Parameter>(ap => ap.Parameter);
-      dlo.LoadWith<Algorithm_Result>(ar => ar.Result);
-      dlo.LoadWith<Parameter>(p => p.DataType);
-      dlo.LoadWith<Result>(r => r.DataType);
-      okb.LoadOptions = dlo;
-      return okb.Algorithms.Single(a => a.Id == id);
+      using (OKBDataContext okb = new OKBDataContext()) {
+        var dlo = new DataLoadOptions();
+        dlo.LoadWith<Algorithm>(a => a.AlgorithmClass);
+        dlo.LoadWith<Algorithm>(a => a.Platform);
+        dlo.LoadWith<Algorithm>(a => a.AlgorithmUsers);
+        dlo.LoadWith<AlgorithmUser>(u => u.User);
+        okb.LoadOptions = dlo;
+        return okb.Algorithms.Single(a => a.Id == id);
+      }
     }
 
@@ -78 +66 @@
     /// Gets the complete problem object graph up to the following entities:
     /// <list type="bullet">
-    ///     <item>Platform</item>
-    ///     <item>SolutionRepresentation</item>
-    ///     <item>Problem_Parameters.Parameter</item>
-    ///     <item>IntProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
-    ///     <item>FloatProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
-    ///     <item>CharProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
-    ///   </list>
+    ///   <item>Platform</item>
+    ///   <item>SolutionRepresentation</item>
+    ///   <item>Problem_Parameters.Parameter</item>
+    ///   <item>IntProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
+    ///   <item>FloatProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
+    ///   <item>CharProblemCharacteristicValues.ProblemCharacteristic.DataType</item>
+    /// </list>
     /// </summary>
     /// <param name="id">The problem id.</param>
     /// <returns>A <see cref="Problem"/></returns>
     public Problem GetCompleteProblem(int id) {
-      OKBDataContext okb = GetDataContext();
-      var dlo = new DataLoadOptions();
-      dlo.LoadWith<Problem>(p => p.Platform);
-      dlo.LoadWith<Problem>(p => p.SolutionRepresentation);
-      dlo.LoadWith<Problem>(p => p.Problem_Parameters);
-      dlo.LoadWith<Problem>(p => p.IntProblemCharacteristicValues);
-      dlo.LoadWith<Problem>(p => p.FloatProblemCharacteristicValues);
-      dlo.LoadWith<Problem>(p => p.CharProblemCharacteristicValues);
-      dlo.LoadWith<Problem_Parameter>(ap => ap.Parameter);
-      dlo.LoadWith<IntProblemCharacteristicValue>(ipcv => ipcv.ProblemCharacteristic);
-      dlo.LoadWith<FloatProblemCharacteristicValue>(fpcv => fpcv.ProblemCharacteristic);
-      dlo.LoadWith<CharProblemCharacteristicValue>(cpcv => cpcv.ProblemCharacteristic);
-      dlo.LoadWith<Parameter>(p => p.DataType);
-      dlo.LoadWith<ProblemCharacteristic>(pc => pc.DataType);
-      okb.LoadOptions = dlo;
-      return okb.Problems.Single(p => p.Id == id);
+      using (OKBDataContext okb = new OKBDataContext()) {
+        var dlo = new DataLoadOptions();
+        dlo.LoadWith<Problem>(p => p.ProblemClass);
+        dlo.LoadWith<Problem>(p => p.SolutionRepresentation);
+        dlo.LoadWith<Problem>(p => p.Platform);
+        dlo.LoadWith<Problem>(p => p.ProblemUsers);
+        dlo.LoadWith<ProblemUser>(u => u.User);
+        dlo.LoadWith<Problem>(p => p.ProblemCharacteristicIntValues);
+        dlo.LoadWith<Problem>(p => p.ProblemCharacteristicFloatValues);
+        dlo.LoadWith<Problem>(p => p.ProblemCharacteristicStringValues);
+        dlo.LoadWith<ProblemCharacteristicIntValue>(ipcv => ipcv.ProblemCharacteristic);
+        dlo.LoadWith<ProblemCharacteristicFloatValue>(fpcv => fpcv.ProblemCharacteristic);
+        dlo.LoadWith<ProblemCharacteristicStringValue>(cpcv => cpcv.ProblemCharacteristic);
+        dlo.LoadWith<ProblemCharacteristic>(pc => pc.DataType);
+        okb.LoadOptions = dlo;
+        return okb.Problems.Single(p => p.Id == id);
+      }
     }
 
@@ -110 +99 @@
     /// Updates the algorithm object graph including the following properties and linked entitites:
     /// <list type="bullet">
-    ///     <item>Name</item>
-    ///     <item>Description</item>
-    ///     <item>AlgorithmClassId</item>
-    ///     <item>PlatformId</item>
-    ///     <item>Algorithm_Parameters</item>
-    ///     <item>Algorithm_Results</item>
-    ///   </list>
-    ///   <remarks>
+    ///   <item>Name</item>
+    ///   <item>Description</item>
+    ///   <item>AlgorithmClassId</item>
+    ///   <item>PlatformId</item>
+    ///   <item>Algorithm_Parameters</item>
+    ///   <item>Algorithm_Results</item>
+    /// </list>
+    /// <remarks>
     /// New <see cref="Parameter"/>s or <see cref="Result"/>s will not be
     /// created but have to be pre-existing.
@@ -124 +113 @@
     /// <param name="algorithm">The algorithm.</param>
     public void UpdateCompleteAlgorithm(Algorithm algorithm) {
-      OKBDataContext okb = GetDataContext();
-      Algorithm original = okb.Algorithms.Single(a => a.Id == algorithm.Id);
+      using (OKBDataContext okb = new OKBDataContext()) {
+        Algorithm original = okb.Algorithms.Single(a => a.Id == algorithm.Id);
+        UpdateAlgorithmData(algorithm, original, okb);
+        okb.SubmitChanges();
+      }
+    }
+
+    /// <summary>
+    /// Updates the problem object graph including the following properties and linked entities:
+    /// <list type="bullet">
+    ///   <item>Name</item>
+    ///   <item>Description</item>
+    ///   <item>ProblemClassId</item>
+    ///   <item>PlatformId</item>
+    ///   <item>SolutionRepresentationId</item>
+    ///   <item>IntProblemCharacteristicValues.Value</item>
+    ///   <item>FloatProblemCharacteristicValues.Value</item>
+    ///   <item>CharProblemCharacteristicValues.Value</item>
+    ///   <item>Problem_Parameters</item>
+    /// </list>
+    /// <remarks>
+    /// New <see cref="ProblemCharacteristic"/>s or <see cref="Parameter"/>s will
+    /// not be created but have to be pre-existing.
+    /// </remarks>
+    /// </summary>
+    /// <param name="problem">The problem.</param>
+    public void UpdateCompleteProblem(Problem problem) {
+      using (OKBDataContext okb = new OKBDataContext()) {
+        Problem originalProblem = okb.Problems.Single(p => p.Id == problem.Id);
+        UpdateProblemData(problem, originalProblem, okb);
+        UpdateProblemCharacteristics(problem, originalProblem, okb);
+        okb.SubmitChanges();
+      }
+    }
+
+    private static void UpdateAlgorithmData(Algorithm algorithm, Algorithm original, OKBDataContext okb) {
       original.Name = algorithm.Name;
       original.Description = algorithm.Description;
       original.AlgorithmClassId = algorithm.AlgorithmClassId;
       original.PlatformId = algorithm.PlatformId;
-      okb.Algorithm_Parameters.DeleteAllOnSubmit(original.Algorithm_Parameters);
-      foreach (var a_p in algorithm.Algorithm_Parameters)
-        original.Algorithm_Parameters.Add(new Algorithm_Parameter() {
+      okb.AlgorithmUsers.DeleteAllOnSubmit(original.AlgorithmUsers);
+      original.AlgorithmUsers.Clear();
+      foreach (var u in algorithm.AlgorithmUsers) {
+        original.AlgorithmUsers.Add(new AlgorithmUser() {
           AlgorithmId = original.Id,
-          ParameterId = a_p.ParameterId,
-        });
-      okb.Algorithm_Results.DeleteAllOnSubmit(original.Algorithm_Results);
-      foreach (var a_r in algorithm.Algorithm_Results)
-        original.Algorithm_Results.Add(new Algorithm_Result() {
-          AlgorithmId = original.Id,
-          ResultId = a_r.ResultId,
-        });
-      logger.Info("Updating algorithm implementation for " + original.Name);
-      okb.SubmitChanges();
-    }
-
-    /// <summary>
-    /// Updates the problem object graph including the following properties and linked entities:
-    /// <list type="bullet">
-    ///     <item>Name</item>
-    ///     <item>Description</item>
-    ///     <item>ProblemClassId</item>
-    ///     <item>PlatformId</item>
-    ///     <item>SolutionRepresentationId</item>
-    ///     <item>IntProblemCharacteristicValues.Value</item>
-    ///     <item>FloatProblemCharacteristicValues.Value</item>
-    ///     <item>CharProblemCharacteristicValues.Value</item>
-    ///     <item>Problem_Parameters</item>
-    ///   </list>
-    ///   <remarks>
-    /// New <see cref="ProblemCharacteristic"/>s or <see cref="Parameter"/>s will
-    /// not be created but have to be pre-existing.
-    /// </remarks>
-    /// </summary>
-    /// <param name="problem">The problem.</param>
-    public void UpdateCompleteProblem(Problem problem) {
-      OKBDataContext okb = GetDataContext();
-      Problem originalProblem = okb.Problems.Single(p => p.Id == problem.Id);
-      UpdateProblemMasterInfo(problem, originalProblem);
-      UpdateProblemCharacteristics(problem, okb, originalProblem);
-      UpdateProblemParameters(problem, okb, originalProblem);
-      logger.Info("Updating problem " + originalProblem.Name);
-      okb.SubmitChanges();
-    }
-
-    private static void UpdateProblemParameters(Problem problem, OKBDataContext okb, Problem originalProblem) {
-      okb.Problem_Parameters.DeleteAllOnSubmit(originalProblem.Problem_Parameters);
-      originalProblem.Problem_Parameters.Clear();
-      foreach (var p_p in problem.Problem_Parameters) {
-        originalProblem.Problem_Parameters.Add(new Problem_Parameter() {
-          ProblemId = originalProblem.Id,
-          ParameterId = p_p.ParameterId,
-        });
-      }
-    }
-
-    private static void UpdateProblemCharacteristics(Problem problem, OKBDataContext okb, Problem originalProblem) {
-      okb.IntProblemCharacteristicValues.DeleteAllOnSubmit(originalProblem.IntProblemCharacteristicValues);
-      okb.FloatProblemCharacteristicValues.DeleteAllOnSubmit(originalProblem.FloatProblemCharacteristicValues);
-      okb.CharProblemCharacteristicValues.DeleteAllOnSubmit(originalProblem.CharProblemCharacteristicValues);
-      originalProblem.IntProblemCharacteristicValues.Clear();
-      originalProblem.FloatProblemCharacteristicValues.Clear();
-      originalProblem.CharProblemCharacteristicValues.Clear();
-      foreach (var ipc in problem.IntProblemCharacteristicValues) {
-        originalProblem.IntProblemCharacteristicValues.Add(new IntProblemCharacteristicValue() {
-          ProblemId = originalProblem.Id,
+          UserId = u.UserId
+        });
+      }
+    }
+
+    private static void UpdateProblemData(Problem problem, Problem original, OKBDataContext okb) {
+      original.Name = problem.Name;
+      original.Description = problem.Description;
+      original.ProblemClassId = problem.ProblemClassId;
+      original.SolutionRepresentationId = problem.SolutionRepresentationId;
+      original.PlatformId = problem.PlatformId;
+      okb.ProblemUsers.DeleteAllOnSubmit(original.ProblemUsers);
+      original.ProblemUsers.Clear();
+      foreach (var u in problem.ProblemUsers) {
+        original.ProblemUsers.Add(new ProblemUser() {
+          ProblemId = original.Id,
+          UserId = u.UserId
+        });
+      }
+    }
+    private static void UpdateProblemCharacteristics(Problem problem, Problem original, OKBDataContext okb) {
+      okb.ProblemCharacteristicIntValues.DeleteAllOnSubmit(original.ProblemCharacteristicIntValues);
+      okb.ProblemCharacteristicFloatValues.DeleteAllOnSubmit(original.ProblemCharacteristicFloatValues);
+      okb.ProblemCharacteristicStringValues.DeleteAllOnSubmit(original.ProblemCharacteristicStringValues);
+      original.ProblemCharacteristicIntValues.Clear();
+      original.ProblemCharacteristicFloatValues.Clear();
+      original.ProblemCharacteristicStringValues.Clear();
+      foreach (var ipc in problem.ProblemCharacteristicIntValues) {
+        original.ProblemCharacteristicIntValues.Add(new ProblemCharacteristicIntValue() {
+          ProblemId = original.Id,
           ProblemCharacteristicId = ipc.ProblemCharacteristicId,
           Value = ipc.Value,
         });
       }
-      foreach (var fpc in problem.FloatProblemCharacteristicValues) {
-        originalProblem.FloatProblemCharacteristicValues.Add(new FloatProblemCharacteristicValue() {
-          ProblemId = originalProblem.Id,
+      foreach (var fpc in problem.ProblemCharacteristicFloatValues) {
+        original.ProblemCharacteristicFloatValues.Add(new ProblemCharacteristicFloatValue() {
+          ProblemId = original.Id,
           ProblemCharacteristicId = fpc.ProblemCharacteristicId,
           Value = fpc.Value,
         });
       }
-      foreach (var cpc in problem.CharProblemCharacteristicValues) {
-        originalProblem.CharProblemCharacteristicValues.Add(new CharProblemCharacteristicValue() {
-          ProblemId = originalProblem.Id,
+      foreach (var cpc in problem.ProblemCharacteristicStringValues) {
+        original.ProblemCharacteristicStringValues.Add(new ProblemCharacteristicStringValue() {
+          ProblemId = original.Id,
           ProblemCharacteristicId = cpc.ProblemCharacteristicId,
           Value = cpc.Value,
@@ -215 +207 @@
       }
     }
-
-    private static void UpdateProblemMasterInfo(Problem problem, Problem originalProblem) {
-      originalProblem.Name = problem.Name;
-      originalProblem.Description = problem.Description;
-      originalProblem.ProblemClassId = problem.ProblemClassId;
-      originalProblem.PlatformId = problem.PlatformId;
-      originalProblem.SolutionRepresentationId = problem.SolutionRepresentationId;
-    }
   }
 }