Changeset 5633 for branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/HiveDao.cs

Timestamp:

03/08/11 12:39:33 (12 years ago)

Author:

ascheibe

Message:

#1233 added Appointment/Schedule ws and dao methods

File:

• branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/HiveDao.cs (modified) (2 diffs)

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/HiveDao.cs

@@ -94 +94 @@
                     where resourceIds.Contains(ar.ResourceId)
                        && ar.Job.State == JobState.Waiting
-                       && ar.Job.IsParentJob 
+                       && ar.Job.IsParentJob
                        && (finished ? ar.Job.FinishWhenChildJobsFinished : !ar.Job.FinishWhenChildJobsFinished)
                        && (from child in db.Jobs
@@ -581 +581 @@
     }
     #endregion
+
+    #region AppointmentMethods
+    public Appointment GetAppointment(Guid id) {
+      using (var db = CreateContext()) {
+        return Convert.ToDto(db.UptimeCalendars.SingleOrDefault(x => x.UptimeCalendarId == id));
+      }
+    }
+
+    public IEnumerable<Appointment> GetAppointments(Expression<Func<UptimeCalendar, bool>> predicate) {
+      using (var db = CreateContext()) {
+        return db.UptimeCalendars.Where(predicate).Select(x => Convert.ToDto(x)).ToArray();
+      }
+    }
+
+    public Guid AddAppointment(Appointment dto) {
+      using (var db = CreateContext()) {
+        var entity = Convert.ToEntity(dto);
+        db.UptimeCalendars.InsertOnSubmit(entity);
+        db.SubmitChanges();
+        return entity.UptimeCalendarId;
+      }
+    }
+
+    public void UpdateAppointment(Appointment dto) {
+      using (var db = CreateContext()) {
+        var entity = db.UptimeCalendars.FirstOrDefault(x => x.UptimeCalendarId == dto.Id);
+        if (entity == null) db.UptimeCalendars.InsertOnSubmit(Convert.ToEntity(dto));
+        else Convert.ToEntity(dto, entity);
+        db.SubmitChanges();
+      }
+    }
+
+    public void DeleteAppointment(Guid id) {
+      using (var db = CreateContext()) {
+        var entity = db.UptimeCalendars.FirstOrDefault(x => x.UptimeCalendarId == id);
+        if (entity != null) db.UptimeCalendars.DeleteOnSubmit(entity);
+        db.SubmitChanges();
+      }
+    }
+    #endregion
   }
 }