public bool CreateSchedule(Schedule obj) { try { using (var ctx = new ZzaDbContext()) { var query = ctx.Tasks.FirstOrDefault(x => x.taskID == obj.taskID); if (query != null) { query.Status = "Queued"; query.OutputLog = string.Empty; ctx.SaveChanges(); } var q = ctx.Schedules.Add(obj); ctx.SaveChanges(); } return true; } catch (Exception) { return false; } }
public bool UpdateScheduleInformation(Schedule obj) { try { using (var ctx = new ZzaDbContext()) { var query = ctx.Tasks.FirstOrDefault(x => x.taskID == obj.taskID); if (query != null) { query.Status = "Queued"; query.OutputLog = string.Empty; ctx.SaveChanges(); } var q = ctx.Schedules.First(m => m.sID == obj.sID); if (q != null) { q.endAt = obj.endAt; q.startAt = obj.startAt; q.intHours = obj.intHours; q.intMin = obj.intMin; q.intSec = obj.intSec; q.repeatforever = obj.repeatforever; ctx.SaveChanges(); } } return true; } catch (Exception) { return false; } }