/// <summary>
/// Update the myschedule item.
/// </summary>
/// <param name="sched">The schedule information</param>
/// <returns>The original schedule</returns>
public MYSCHEDULE Update(MYSCHEDULE sched)
{
var gordon_id = sched.GORDON_ID;
var event_id = sched.EVENT_ID;
// Account Verification
var account = _unitOfWork.AccountRepository.FirstOrDefault(x => x.gordon_id == gordon_id);
if (account == null)
{
throw new ResourceNotFoundException()
{
ExceptionMessage = "The account was not found."
};
}
var original = _unitOfWork.MyScheduleRepository.FirstOrDefault(x => x.GORDON_ID == gordon_id && x.EVENT_ID == event_id);
if (original == null)
{
throw new ResourceNotFoundException()
{
ExceptionMessage = "The MySchedule was not found."
};
}
var eventIdParam = new SqlParameter("@EVENTID", sched.EVENT_ID);
var idParam = new SqlParameter("@GORDONID", sched.GORDON_ID);
var locationParam = sched.LOCATION == null ?
new SqlParameter("@LOCATION", original.LOCATION): new SqlParameter("@LOCATION", sched.LOCATION);
var descriptionParam = sched.DESCRIPTION == null ?
new SqlParameter("@DESCRIPTION", original.DESCRIPTION) : new SqlParameter("@DESCRIPTION", sched.DESCRIPTION);
var monCdeParam = new SqlParameter("@MON_CDE", (object)sched.MON_CDE ?? DBNull.Value);
var tueCdeParam = new SqlParameter("@TUE_CDE", (object)sched.TUE_CDE ?? DBNull.Value);
var wedCdeParam = new SqlParameter("@WED_CDE", (object)sched.WED_CDE ?? DBNull.Value);
var thuCdeParam = new SqlParameter("@THU_CDE", (object)sched.THU_CDE ?? DBNull.Value);
var friCdeParam = new SqlParameter("@FRI_CDE", (object)sched.FRI_CDE ?? DBNull.Value);
var satCdeParam = new SqlParameter("@SAT_CDE", (object)sched.SAT_CDE ?? DBNull.Value);
var sunCdeParam = new SqlParameter("@SUN_CDE", (object)sched.SUN_CDE ?? DBNull.Value);
var allDayParam = sched.IS_ALLDAY == null ?
new SqlParameter("@IS_ALLDAY", original.IS_ALLDAY) : new SqlParameter("@IS_ALLDAY", sched.IS_ALLDAY);
var beginTimeParam = sched.BEGIN_TIME == null ?
new SqlParameter("@BEGINTIME", original.BEGIN_TIME) : new SqlParameter("@BEGINTIME", sched.BEGIN_TIME);
var endTimeParam = sched.END_TIME == null ?
new SqlParameter("@ENDTIME", original.END_TIME) : new SqlParameter("@ENDTIME", sched.END_TIME);
var context = new CCTEntities1();
context.Database.ExecuteSqlCommand("UPDATE_MYSCHEDULE " +
"@EVENTID, @GORDONID, @LOCATION, @DESCRIPTION, @MON_CDE, @TUE_CDE, @WED_CDE, " +
"@THU_CDE, @FRI_CDE, @SAT_CDE, @SUN_CDE, @IS_ALLDAY, @BEGINTIME, @ENDTIME"
, eventIdParam, idParam, locationParam, descriptionParam, monCdeParam, tueCdeParam,
wedCdeParam, thuCdeParam, friCdeParam, satCdeParam, sunCdeParam, allDayParam,
beginTimeParam, endTimeParam); // run stored procedure.
_unitOfWork.Save();
return(original);
}
public IHttpActionResult Post([FromBody] MYSCHEDULE mySchedule)
{
const int MAX = 50;
DateTime localDate = DateTime.Now;
// Verify Input
if (!ModelState.IsValid || mySchedule == null)
{
string errors = "";
foreach (var modelstate in ModelState.Values)
{
foreach (var error in modelstate.Errors)
{
errors += "|" + error.ErrorMessage + "|" + error.Exception;
}
}
throw new BadInputException()
{
ExceptionMessage = errors
};
}
// Check if maximum
var authenticatedUser = this.ActionContext.RequestContext.Principal as ClaimsPrincipal;
var username = authenticatedUser.Claims.FirstOrDefault(x => x.Type == "user_name").Value;
var id = _accountService.GetAccountByUsername(username).GordonID;
object existingEvents = _myScheduleService.GetAllForID(id);
JArray jEvents = JArray.FromObject(existingEvents);
if (jEvents.Count > MAX)
{
return(Unauthorized());
}
var result = _myScheduleService.Add(mySchedule);
if (result == null)
{
return(NotFound());
}
_scheduleControlService.UpdateModifiedTimeStamp(id, localDate);
return(Created("myschedule", mySchedule));
}
/// <summary>
/// Adds a new mySchedule record to storage.
/// </summary>
/// <param name="mySchedule">The membership to be added</param>
/// <returns>The newly added custom event</returns>
public MYSCHEDULE Add(MYSCHEDULE mySchedule)
{
// Account verification
var account = _unitOfWork.AccountRepository.FirstOrDefault(x => x.gordon_id == mySchedule.GORDON_ID);
if (account == null)
{
throw new ResourceNotFoundException()
{
ExceptionMessage = "The account was not found."
};
}
// Assign event id
var myScheduleList = _unitOfWork.MyScheduleRepository.GetAll(x => x.GORDON_ID == mySchedule.GORDON_ID);
int largestEventId = 1000;
int i = 0;
foreach (var schedule in myScheduleList)
{
if (!Int32.TryParse(schedule.EVENT_ID, out i))
{
i = -1;
}
if (largestEventId < i)
{
largestEventId = i;
}
}
largestEventId++;
mySchedule.EVENT_ID = largestEventId.ToString();
// The Add() method returns the added schedule
var payload = _unitOfWork.MyScheduleRepository.Add(mySchedule);
// There is a unique constraint in the Database on columns
if (payload == null)
{
throw new ResourceCreationException()
{
ExceptionMessage = "There was an error adding the myschedule event. Verify that a similar schedule doesn't already exist."
};
}
_unitOfWork.Save();
return(payload);
}
public IHttpActionResult Put([FromBody] MYSCHEDULE mySchedule)
{
DateTime localDate = DateTime.Now;
if (!ModelState.IsValid || mySchedule == null)
{
string errors = "";
foreach (var modelstate in ModelState.Values)
{
foreach (var error in modelstate.Errors)
{
errors += "|" + error.ErrorMessage + "|" + error.Exception;
}
}
throw new BadInputException()
{
ExceptionMessage = errors
};
}
var result = _myScheduleService.Update(mySchedule);
if (result == null)
{
return(NotFound());
}
var authenticatedUser = this.ActionContext.RequestContext.Principal as ClaimsPrincipal;
var username = authenticatedUser.Claims.FirstOrDefault(x => x.Type == "user_name").Value;
var id = _accountService.GetAccountByUsername(username).GordonID;
_scheduleControlService.UpdateModifiedTimeStamp(id, localDate);
return(Ok(result));
}
