private void GenerateJobSchedules()
{
var date = DateTime.Today.AddYears(-1).AddDays(7);
for (int i = 0; i < 261; i++)
{
date = GetNextBusinessDay(date);
foreach (var crew in Crews)
{
int id = crew.Id;
int operationId = id % Operations.Count;
operationId = operationId == 0 ? 1 : operationId;
var op = Operations[operationId];
JobSchedules.Add(new JobSchedule()
{
Id = id,
Date = date,
Crew = crew,
Operation = op
});
}
}
}
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 Schedules(string dbServer, Guid jobID)
{
List <JobScheduleListModel> schedules = new List <JobScheduleListModel>();
JobSchedules jobschedules = new JobSchedules();
schedules = jobschedules.getSchedules(dbServer, jobID);
ViewBag.ServerName = dbServer;
ViewBag.JobID = jobID;
return(View(schedules));
}
public async Task SaveSelectedSchedule(string name)
{
await base.GetJobSchedules();
var theOne = JobSchedules.SingleOrDefault(js => js.JobName == name);
if (theOne != null)
{
await _cacheService.SaveSelectedJobSchedule(theOne);
}
}
public ActionResult DeleteSchedule(string dbServer, Guid jobID, Guid scheduleUID)
{
JobSchedules jobschedules = new JobSchedules();
jobschedules.deleteSchedule(dbServer, jobID, scheduleUID);
ViewBag.ServerName = dbServer;
ViewBag.JobID = jobID;
LogActivity log = new LogActivity();
log.Add(User.Identity.Name, dbServer, jobID, "Delete Schedule");
return(RedirectToAction("Schedules", "Edit", new { dbServer = dbServer, jobID = jobID }));
}
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 async Task SetSelectedSchedule(string name)
{
await GetJobSchedules();
SelectedSchedule = JobSchedules.FirstOrDefault(js => js.JobName == name);
}
