public ActionResult EditSchedule(string dbServer, Guid jobID, Guid scheduleUID) { JobSchedules jobschedules = new JobSchedules(); PopulateDropDowns dropdown = new PopulateDropDowns(); JobScheduleDetailsModel schedule = new JobScheduleDetailsModel(); List <SelectListItem> frequencyTypes = new List <SelectListItem>(); List <SelectListItem> subdayTypes = new List <SelectListItem>(); List <SelectListItem> freqRelativeIntervals = new List <SelectListItem>(); List <SelectListItem> monthlyFrequency = new List <SelectListItem>(); schedule = jobschedules.getScheduleDetails(dbServer, jobID, scheduleUID); frequencyTypes = dropdown.getFrequencyTypes(); ViewBag.FreqTypes = frequencyTypes; subdayTypes = dropdown.getSubdayTypes(); ViewBag.SubDayTypes = subdayTypes; freqRelativeIntervals = dropdown.getFreqRelativeIntervals(); ViewBag.FreqRelativeIntervals = freqRelativeIntervals; monthlyFrequency = dropdown.getMonthlyFrequency(); ViewBag.MonthlyFrequency = monthlyFrequency; ViewBag.ServerName = dbServer; ViewBag.JobID = jobID; return(View(schedule)); }
public ActionResult StartJob(string dbServer, Guid jobID) { JobDetailsModel model = new JobDetailsModel(); PopulateDropDowns dropdown = new PopulateDropDowns(); ConnectSqlServer connection = new ConnectSqlServer(); Server server = connection.Connect(dbServer); List <SelectListItem> stepList = new List <SelectListItem>(); stepList = dropdown.getSteps(dbServer, jobID); ViewBag.StepList = stepList; var job = server.JobServer.GetJobByID(jobID); model.JobName = job.Name; model.ServerName = dbServer; model.JobID = jobID; model.StepName = job.JobSteps[0].Name; return(View(model)); }
public ActionResult EditSchedule(JobScheduleDetailsModel schedule) { if (ModelState.IsValid) { JobSchedules jobschedules = new JobSchedules(); jobschedules.saveScheduleDetails(schedule); ViewBag.ServerName = schedule.ServerName; ViewBag.JobID = schedule.JobID; LogActivity log = new LogActivity(); log.Add(User.Identity.Name, schedule.ServerName, schedule.JobID, "Edit Schedule"); return(RedirectToAction("Schedules", "Edit", new { dbServer = ViewBag.ServerName, jobID = ViewBag.JobID })); } else { PopulateDropDowns dropdown = new PopulateDropDowns(); List <SelectListItem> frequencyTypes = new List <SelectListItem>(); List <SelectListItem> subdayTypes = new List <SelectListItem>(); List <SelectListItem> freqRelativeIntervals = new List <SelectListItem>(); List <SelectListItem> monthlyFrequency = new List <SelectListItem>(); frequencyTypes = dropdown.getFrequencyTypes(); ViewBag.FreqTypes = frequencyTypes; subdayTypes = dropdown.getSubdayTypes(); ViewBag.SubDayTypes = subdayTypes; freqRelativeIntervals = dropdown.getFreqRelativeIntervals(); ViewBag.FreqRelativeIntervals = freqRelativeIntervals; monthlyFrequency = dropdown.getMonthlyFrequency(); ViewBag.MonthlyFrequency = monthlyFrequency; ViewBag.ServerName = schedule.ServerName; ViewBag.JobID = schedule.JobID; return(View(schedule)); } }
public ActionResult EditStep(string dbServer, Guid jobID, int stepID) { JobSteps jobSteps = new JobSteps(); PopulateDropDowns dropdown = new PopulateDropDowns(); JobStepDetailsModel step = new JobStepDetailsModel(); List <SelectListItem> databaseList = new List <SelectListItem>(); List <SelectListItem> proxyList = new List <SelectListItem>(); List <SelectListItem> actionList = new List <SelectListItem>(); databaseList = dropdown.getDatabases(dbServer); ViewBag.DatabaseList = databaseList; proxyList = dropdown.getProxies(dbServer, AgentSubSystem.TransactSql); ViewBag.ProxyList = proxyList; actionList = dropdown.getActions(dbServer, jobID, stepID); ViewBag.ActionList = actionList; ViewBag.ServerName = dbServer; ViewBag.JobID = jobID; step = jobSteps.getStepDetails(dbServer, jobID, stepID); return(View(step)); }
public ActionResult EditStep(JobStepDetailsModel step) { if (ModelState.IsValid) { JobSteps jobSteps = new JobSteps(); jobSteps.saveStepDetails(step); ViewBag.ServerName = step.ServerName; ViewBag.JobID = step.JobID; LogActivity log = new LogActivity(); log.Add(User.Identity.Name, step.ServerName, step.JobID, "Edit Step"); return(RedirectToAction("Steps", "Edit", new { dbServer = step.ServerName, jobID = step.JobID })); } else { PopulateDropDowns dropdown = new PopulateDropDowns(); List <SelectListItem> databaseList = new List <SelectListItem>(); List <SelectListItem> proxyList = new List <SelectListItem>(); List <SelectListItem> actionList = new List <SelectListItem>(); databaseList = dropdown.getDatabases(step.ServerName); ViewBag.DatabaseList = databaseList; proxyList = dropdown.getProxies(step.ServerName, AgentSubSystem.TransactSql); ViewBag.ProxyList = proxyList; actionList = dropdown.getActions(step.ServerName, step.JobID, step.StepNo); ViewBag.ActionList = actionList; ViewBag.ServerName = step.ServerName; ViewBag.JobID = step.JobID; return(View(step)); } }