public ActionResult GetSpecificScheduleClockItems(string scheduleClockName)
{
if (String.IsNullOrWhiteSpace(scheduleClockName))
{
// Schedule Clock ID was null
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json("The Schedule Clock name cannot be empty."));
}
else
{
ScheduleClock existingScheduleClock = _db.ScheduleClock.Where(r => r.ScheduleClockName.Equals(scheduleClockName)).First();
// If any ScheduleClocks were found return them as a JSON Object
var existingScheduleClockItems = _db.ScheduleClockItems.Where(r => r.ScheduleClock.ScheduleClockId.Equals(existingScheduleClock.ScheduleClockId)).OrderBy(r => r.ScheduleClockItemIndex);
if (existingScheduleClockItems.Any())
{
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(existingScheduleClockItems));
}
else
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json("No schedule clock items found."));
}
}
}
public ActionResult SubmitScheduleClock(string scheduleClockItemInputs, string scheduleClockName, string scheduleClockDuration)
{
int scheduleClockDurationInt;
if (!Int32.TryParse(scheduleClockDuration, out scheduleClockDurationInt))
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json("The schedule clock duration couldn't be converted to an integer."));
}
// Parse the JSON string input to a ScheduleClockItemInput object
ScheduleClockItemInput[] scheduleClockObject = JsonConvert.DeserializeObject <ScheduleClockItemInput[]>(scheduleClockItemInputs);
// Check whether the name of the clock already exists
var scheduleClock = _db.ScheduleClock.Where(r => r.ScheduleClockName == scheduleClockName);
// Placeholder for the Schedule Clock reference
ScheduleClock scheduleClockDB;
if (!scheduleClock.Any())
{
// The schedule name was not found in the database
// Add a new item to the ScheduleClock db
scheduleClockDB = new ScheduleClock
{
ScheduleClockName = scheduleClockName,
ScheduleClockDuration = Int32.Parse(scheduleClockDuration)
};
// Add the schedule clock db to the database
_db.ScheduleClock.Add(scheduleClockDB);
_db.SaveChanges();
}
else
{
// The schedule name was found in the database
// Get a reference to the Schedule Clock
scheduleClockDB = _db.ScheduleClock.Where(r => r.ScheduleClockName == scheduleClockName).First();
// Get the schedule clock items from the database
var scheduleClockTest = _db.ScheduleClockItems.Where(r => r.ScheduleClock.ScheduleClockId.Equals(scheduleClockDB.ScheduleClockId));
foreach (var scheduleClockItem in scheduleClockTest)
{
// Remove the items from the database
_db.ScheduleClockItems.Remove(scheduleClockItem);
}
// Save the changes
_db.SaveChanges();
}
// Loop over the schedule clock items and add them to the database
foreach (ScheduleClockItemInput scheduleClockItem in scheduleClockObject)
{
// Find audio reference to be used as a foreign key
AudioType audioType = _db.AudioType.Where(r => r.AudioTypeName == scheduleClockItem.schedule_clock_name).First();
if (audioType == null)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json("scheduleClockDuration"));
}
ScheduleClockItem scheduleClockItemDB = new ScheduleClockItem
{
ScheduleClockItemIndex = scheduleClockItem.schedule_clock_index,
ScheduleClock = scheduleClockDB,
AudioType = audioType
};
// Add the schedule item to the database
_db.ScheduleClockItems.Add(scheduleClockItemDB);
_db.SaveChanges();
}
return(Json(scheduleClock));
}
