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

Timestamp:

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

Author:

ascheibe

Message:

#1233 added Appointment/Schedule ws and dao methods

Location:

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

Files:

• Convert.cs (modified) (2 diffs)
• HiveDao.cs (modified) (2 diffs)
• Interfaces/IHiveDao.cs (modified) (1 diff)

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

@@ -64 +64 @@
           target.StateLogs.Add(Convert.ToEntity(sl));
         }
-        
+
         //target.StateLogs.AddRange(source.StateLog.Select(x => Convert.ToEntity(x)).OrderBy(x => x.DateTime));
         target.IsParentJob = source.IsParentJob;
@@ -103 +103 @@
       if ((source != null) && (target != null)) {
         target.StateLogId = source.Id; target.DateTime = source.DateTime; target.Exception = source.Exception; target.JobId = source.JobId; target.SlaveId = source.SlaveId; target.State = source.State; target.UserId = source.UserId;
+      }
+    }
+    #endregion
+
+    #region Appointment
+    public static DT.Appointment ToDto(UptimeCalendar source) {
+      if (source == null) return null;
+      return new DT.Appointment { Id = source.UptimeCalendarId, AllDayEvent = source.AllDayEvent, EndDate = source.EndDate, Recurring = source.Recurring, RecurringId = source.RecurringId, ResourceId = source.ResourceId, StartDate = source.StartDate };
+    }
+    public static UptimeCalendar ToEntity(DT.Appointment source) {
+      if (source == null) return null;
+      var entity = new UptimeCalendar(); ToEntity(source, entity);
+      return entity;
+    }
+    public static void ToEntity(DT.Appointment source, UptimeCalendar target) {
+      if ((source != null) && (target != null)) {
+        target.UptimeCalendarId = source.Id; target.AllDayEvent = source.AllDayEvent; target.EndDate = source.EndDate; target.Recurring = source.Recurring; target.RecurringId = source.RecurringId; target.ResourceId = source.ResourceId; target.StartDate = source.StartDate;
       }
     }

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
   }
 }

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/Interfaces/IHiveDao.cs

@@ -105 +105 @@
     void SetLastCleanup(DateTime datetime);
     #endregion
+
+    #region Appointment Methods
+    DT.Appointment GetAppointment(Guid id);
+    IEnumerable<DT.Appointment> GetAppointments(Expression<Func<UptimeCalendar, bool>> predicate);
+    Guid AddAppointment(DT.Appointment dto);
+    void UpdateAppointment(DT.Appointment dto);
+    void DeleteAppointment(Guid id);
+    #endregion
+
   }
 }