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