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 DeleteClient(int id) { try { using (var ctx = new ZzaDbContext()) { var tasks = ctx.Tasks.Where(x => x.ClientID == id).ToList(); if (tasks.Any()) { foreach (var tsk in tasks) { ctx.Tasks.Remove(tsk); ctx.SaveChanges(); } } var client = ctx.Clients.First(m => m.ID == id); ctx.Clients.Remove(client); 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); } }
public bool UpdateTaskInformation(Task obj) { try { using (var ctx = new ZzaDbContext()) { var q = ctx.Tasks.First(m => m.taskID == obj.taskID); if (q != null) { q.Command = obj.Command; q.Path = obj.Path; q.TaskName = obj.TaskName; q.TaskType = obj.TaskType; q.Status = "Queued"; q.OutputLog = string.Empty; ctx.SaveChanges(); } } return(true); } catch (Exception) { return(false); } }
public void SubmitOrder(Order order) { _context.Orders.Add(order); order.OrderItems.ForEach(oi => _context.OrderItems.Add(oi)); _context.SaveChanges(); }
public void TaskDone(int taskid, string output) { try { using (var ctx = new ZzaDbContext()) { var q = ctx.Tasks.First(m => m.taskID == taskid); q.Status = "Done"; q.OutputLog = output; ctx.SaveChanges(); } } catch (Exception) { } }
public bool CreateTask(Task obj) { try { using (var ctx = new ZzaDbContext()) { var q = ctx.Tasks.Add(obj); ctx.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool DeleteSchedule(int id) { try { using (var ctx = new ZzaDbContext()) { var task = ctx.Schedules.FirstOrDefault(x => x.sID == id); if (task != null) { ctx.Schedules.Remove(task); ctx.SaveChanges(); } return(true); } } catch (Exception) { return(false); } }
public bool UpdateClientInformation(Client obj) { try { using (var ctx = new ZzaDbContext()) { var q = ctx.Clients.First(m => m.ID == obj.ID); if (q != null) { q.HostName = obj.HostName; q.IpAddress = obj.IpAddress; q.Username = obj.Username; q.Password = obj.Password; ctx.SaveChanges(); } } return(true); } catch (Exception) { return(false); } }