// GET: SQLJobs/Details/5 public async Task <IActionResult> Details(Guid id, [FromQuery] string server) { //SqlServerManager ssm = new SqlServerManager(); var j = _ssm.FindJobByID(id, server); SQLJob job = new SQLJob(); //TODO move this to a constructor job.JobID = j.JobID; job.Name = j.Name; job.Description = j.Description; job.OriginatingServer = j.OriginatingServer; job.Schedule = j.JobSchedules; job.Steps = j.JobSteps; job.CurrentRunStatus = j.CurrentRunStatus; job.CurrentRunStep = j.CurrentRunStep; job.DateCreated = j.DateCreated; job.DateModified = j.DateLastModified; job.LastRunDate = j.LastRunDate; job.NextRunDate = j.NextRunDate; // var sQLJob = await _context.SQLJobs // .FirstOrDefaultAsync(m => m.JobID == id); // if (sQLJob == null) // { // return NotFound(); // } return(View(job)); }
public async Task <IActionResult> Edit(Guid id, [Bind("JobID,Name,Description,OriginatingServer,DateCreated,DateModified,LastRunDate,NextRunDate")] SQLJob sQLJob) { if (id != sQLJob.JobID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(sQLJob); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SQLJobExists(sQLJob.JobID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(sQLJob)); }
public async Task <IActionResult> Create([Bind("JobID,Name,Description,OriginatingServer,DateCreated,DateModified,LastRunDate,NextRunDate")] SQLJob sQLJob) { if (ModelState.IsValid) { sQLJob.JobID = Guid.NewGuid(); _context.Add(sQLJob); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(sQLJob)); }
// GET: SQLJobs public async Task <IActionResult> Index() { //AM_SqlServer.SqlServerManager ssm = new AM_SqlServer.SqlServerManager(); //TODO: use AppSettings to pull this, set value through a settings/config menu List <Job> localJobs = _ssm.GetAllSqlAgentJobs(); List <SQLJob> sqlJobs = new List <SQLJob>(); foreach (Job j in localJobs) { SQLJob job = new SQLJob(); job.JobID = j.JobID; job.Name = j.Name; job.Description = j.Description; job.OriginatingServer = j.OriginatingServer; job.Schedule = j.JobSchedules; job.Steps = j.JobSteps; job.CurrentRunStatus = j.CurrentRunStatus; job.CurrentRunStep = j.CurrentRunStep; job.DateCreated = j.DateCreated; job.DateModified = j.DateLastModified; job.LastRunDate = j.LastRunDate; job.NextRunDate = j.NextRunDate; sqlJobs.Add(job); } //TODO remove this and have code loop through the list of WAMSqlConnectionObjects and pull jobs for each List <Job> remoteJobs = _ssm.GetAllSqlAgentJobs("sa", "password", "SERVER02"); foreach (Job j in remoteJobs) { SQLJob job = new SQLJob(); //TODO move this to a constructor job.JobID = j.JobID; job.Name = j.Name; job.Description = j.Description; job.OriginatingServer = j.OriginatingServer; job.Schedule = j.JobSchedules; job.Steps = j.JobSteps; job.CurrentRunStatus = j.CurrentRunStatus; job.CurrentRunStep = j.CurrentRunStep; job.DateCreated = j.DateCreated; job.DateModified = j.DateLastModified; job.LastRunDate = j.LastRunDate; job.NextRunDate = j.NextRunDate; sqlJobs.Add(job); } return(View(sqlJobs)); // return View(await _context.SQLJobs.ToListAsync()); }