public HttpResponseMessage DeleteRoom(int itemId, int codeCampId)
{
try
{
var tracks = TrackDataAccess.GetItems(codeCampId).Where(t => t.RoomId == itemId);
if (tracks.Any())
{
foreach (var track in tracks)
{
track.RoomId = null;
track.LastUpdatedByDate = DateTime.Now;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.UpdateItem(track);
}
}
RoomDataAccess.DeleteItem(itemId, codeCampId);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage AssignSessionToTrack(int sessionId, int trackId, int codeCampId)
{
try
{
var session = SessionDataAccess.GetItem(sessionId, codeCampId);
session.TrackId = trackId;
session.LastUpdatedByDate = DateTime.Now;
session.LastUpdatedByUserId = UserInfo.UserID;
SessionDataAccess.UpdateItem(session);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateSpeaker(SpeakerInfo speaker)
{
try
{
var timeStamp = DateTime.Now;
speaker.CreatedByDate = timeStamp;
speaker.CreatedByUserId = UserInfo.UserID;
speaker.LastUpdatedByDate = timeStamp;
speaker.LastUpdatedByUserId = UserInfo.UserID;
if (speaker.RegistrationId == 0)
{
speaker.RegistrationId = null;
}
SpeakerDataAccess.CreateItem(speaker);
var speakers = SpeakerDataAccess.GetItems(speaker.CodeCampId);
var savedSpeaker = speakers.OrderByDescending(s => s.CreatedByDate).FirstOrDefault(s => s.Email == speaker.Email);
var response = new ServiceResponse <SpeakerInfo> {
Content = savedSpeaker
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateVolunteerTask(VolunteerTaskInfo task)
{
try
{
var timeStamp = DateTime.Now;
task.CreatedByDate = timeStamp;
task.CreatedByUserId = UserInfo.UserID;
task.LastUpdatedByDate = timeStamp;
task.LastUpdatedByUserId = UserInfo.UserID;
VolunteerTaskDataAccess.CreateItem(task);
var savedTask =
VolunteerTaskDataAccess.GetItems(task.VolunteerId)
.OrderByDescending(t => t.CreatedByDate)
.FirstOrDefault();
var response = new ServiceResponse <VolunteerTaskInfo> {
Content = savedTask
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateRoom(RoomInfo room)
{
try
{
room.CreatedByDate = DateTime.Now;
room.CreatedByUserId = UserInfo.UserID;
room.LastUpdatedByDate = DateTime.Now;
room.LastUpdatedByUserId = UserInfo.UserID;
RoomDataAccess.CreateItem(room);
var savedRoom = RoomDataAccess.GetItems(room.CodeCampId).OrderByDescending(r => r.CreatedByDate).FirstOrDefault();
var response = new ServiceResponse <RoomInfo> {
Content = savedRoom
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetTimeSlot(int itemId, int codeCampId)
{
try
{
var timeSlot = TimeSlotDataAccess.GetItem(itemId, codeCampId);
// removing this prevented the saved/retrieved time from being offset to being about 4 hours off
//if (timeSlot != null)
//{
// timeSlot.BeginTime = timeSlot.BeginTime.ToLocalTime();
// timeSlot.EndTime = timeSlot.EndTime.ToLocalTime();
//}
var response = new ServiceResponse <TimeSlotInfo> {
Content = timeSlot
};
if (timeSlot == null)
{
ServiceResponseHelper <TimeSlotInfo> .AddNoneFoundError("timeSlot", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetSessionCountBySpeakerId(int codeCampId, int speakerId)
{
try
{
var allSessions = SessionDataAccess.GetItems(codeCampId);
var sessionSpeakers = SessionSpeakerDataAccess.GetItemsBySpeakerId(speakerId).Select(s => s.SessionId);
var sessions = allSessions.Where(s => sessionSpeakers.Contains(s.SessionId));
var response = new ServiceResponse <int> {
Content = sessions.Any() ? sessions.Count() : 0
};
if (!sessions.Any())
{
ServiceResponseHelper <int> .AddNoneFoundError("sessions", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetVolunteer(int itemId, int codeCampId)
{
try
{
var volunteer = VolunteerDataAccess.GetItem(itemId, codeCampId);
var response = new ServiceResponse <VolunteerInfo> {
Content = volunteer
};
if (volunteer == null &&
(UserInfo.IsSuperUser || UserInfo.IsInRole(PortalSettings.AdministratorRoleName) ||
ModulePermissionController.HasModulePermission(ActiveModule.ModulePermissions, "Edit")))
{
// automatically make superusers, admins, and editors a volunteer
response.Content = GenerateOrganizerVolunteerInfo(codeCampId);
}
else if (volunteer == null)
{
ServiceResponseHelper <VolunteerInfo> .AddNoneFoundError("volunteer", ref response);
}
if (volunteer != null)
{
LoadSupplementalProperties(ref volunteer);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UnassignTimeSlotFromSession(int sessionId, int timeSlotId, int codeCampId)
{
try
{
var session = SessionDataAccess.GetItem(sessionId, codeCampId);
if (session != null)
{
session.TimeSlotId = null;
session.LastUpdatedByDate = DateTime.Now;
session.LastUpdatedByUserId = UserInfo.UserID;
SessionDataAccess.UpdateItem(session);
}
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
if (session == null)
{
ServiceResponseHelper <string> .AddNoneFoundError("session", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetRegistrationByUserId(int userId, int codeCampId)
{
try
{
var response = new ServiceResponse <RegistrationInfo>();
RegistrationInfo registration = null;
if (userId > 0)
{
registration = RegistrationDataAccess.GetItemByUserId(userId, codeCampId);
response.Content = registration;
}
if (registration == null)
{
ServiceResponseHelper <RegistrationInfo> .AddNoneFoundError("registration", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetVolunteers(int codeCampId)
{
try
{
var volunteers = VolunteerDataAccess.GetItems(codeCampId);
volunteers = LoadSupplementalProperties(volunteers);
var response = new ServiceResponse <List <VolunteerInfo> > {
Content = volunteers.ToList()
};
if (volunteers == null)
{
ServiceResponseHelper <List <VolunteerInfo> > .AddNoneFoundError("volunteers", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage DeleteTrack(int itemId, int codeCampId)
{
try
{
var sessions = SessionDataAccess.GetItemsByTrackId(itemId, codeCampId);
if (sessions.Any())
{
foreach (var session in sessions)
{
session.TrackId = null;
session.LastUpdatedByDate = DateTime.Now;
session.LastUpdatedByUserId = UserInfo.UserID;
SessionDataAccess.UpdateItem(session);
}
}
TrackDataAccess.DeleteItem(itemId, codeCampId);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateTrack(TrackInfo track)
{
try
{
var timeStamp = DateTime.Now;
track.CreatedByDate = timeStamp;
track.CreatedByUserId = UserInfo.UserID;
track.LastUpdatedByDate = timeStamp;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.CreateItem(track);
var tracks = TrackDataAccess.GetItems(track.CodeCampId);
var savedTrack = tracks.OrderByDescending(s => s.CreatedByDate).FirstOrDefault(s => s.Title == track.Title);
var response = new ServiceResponse <TrackInfo> {
Content = savedTrack
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UnassignRoomFromTrack(int roomId, int trackId, int codeCampId)
{
try
{
var track = TrackDataAccess.GetItem(trackId, codeCampId);
if (track != null)
{
track.RoomId = null;
track.LastUpdatedByDate = DateTime.Now;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.UpdateItem(track);
}
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
if (track == null)
{
ServiceResponseHelper <string> .AddNoneFoundError("track", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetRoomByTrackId(int trackId, int codeCampId)
{
try
{
RoomInfo room = null;
var track = TrackDataAccess.GetItems(codeCampId).Where(t => t.TrackId == trackId).FirstOrDefault();
if (track != null)
{
room = RoomDataAccess.GetItem(track.RoomId.Value, codeCampId);
}
var response = new ServiceResponse <RoomInfo> {
Content = room
};
if (room == null)
{
ServiceResponseHelper <RoomInfo> .AddNoneFoundError("rooms", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UpdateEvent(CodeCampInfo codeCamp)
{
try
{
var originalEvent = CodeCampDataAccess.GetItem(codeCamp.CodeCampId, codeCamp.ModuleId);
var updatesToProcess = EventHasUpdates(ref originalEvent, ref codeCamp);
if (updatesToProcess)
{
originalEvent.LastUpdatedByDate = DateTime.Now;
originalEvent.LastUpdatedByUserId = UserInfo.UserID;
CodeCampDataAccess.UpdateItem(originalEvent);
}
var savedEvent = CodeCampDataAccess.GetItem(originalEvent.CodeCampId, originalEvent.ModuleId);
var response = new ServiceResponse <CodeCampInfo> {
Content = savedEvent
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UpdateSpeakerAvatar(int codeCampId, int speakerId)
{
try
{
var result = NO_FILES;
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
var folderPath = string.Format("~/Portals/{0}/CodeCamps/{1}/SpeakerAvatars/", PortalSettings.PortalId, codeCampId);
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
var filePath = HttpContext.Current.Server.MapPath(string.Concat(folderPath, postedFile.FileName));
// TODO: append "-ORIGINAL" to the file name
// TODO: parse the image and resize as required
// TODO: allow avatars to be cropepd and saved
// TODO: update speaker profile with file id
postedFile.SaveAs(filePath);
// NOTE: To store in memory use postedFile.InputStream
var folderInfo = DotNetNuke.Services.FileSystem.FolderManager.Instance.GetFolder(PortalSettings.PortalId, folderPath);
var fileExists = DotNetNuke.Services.FileSystem.FileManager.Instance.FileExists(folderInfo, postedFile.FileName);
if (fileExists)
{
result = DotNetNuke.Services.FileSystem.FileManager.Instance.GetFile(folderInfo, postedFile.FileName).FileId.ToString();
if (!string.IsNullOrEmpty(result))
{
var speaker = SpeakerDataAccess.GetItem(speakerId, codeCampId);
if (speaker != null)
{
speaker.IconFile = result;
SpeakerDataAccess.UpdateItem(speaker);
}
}
}
}
}
var response = new ServiceResponse <string> {
Content = result
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.GetBaseException().Message));
}
}
public HttpResponseMessage Ping()
{
var response = new ServiceResponse <string>()
{
Content = "Success"
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
public HttpResponseMessage PingSecurityCheck()
{
// this response should only be reached if the user is allowed to edit the module
// otherwise, they'll be automatically met with a 401 unauthorized error
var response = new ServiceResponse <string>()
{
Content = "Success"
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
public HttpResponseMessage UpdateRoom(RoomInfo room)
{
try
{
var originalRoom = RoomDataAccess.GetItem(room.RoomId, room.CodeCampId);
var updatesToProcess = false;
if (!string.Equals(originalRoom.RoomName, room.RoomName))
{
originalRoom.RoomName = room.RoomName;
updatesToProcess = true;
}
if (!string.Equals(originalRoom.Description, room.Description))
{
originalRoom.Description = room.Description;
updatesToProcess = true;
}
if (originalRoom.MaximumCapacity != room.MaximumCapacity)
{
originalRoom.MaximumCapacity = room.MaximumCapacity;
updatesToProcess = true;
}
if (updatesToProcess)
{
room.LastUpdatedByDate = DateTime.Now;
room.LastUpdatedByUserId = UserInfo.UserID;
RoomDataAccess.UpdateItem(room);
}
var savedRoom = RoomDataAccess.GetItem(room.RoomId, room.CodeCampId);
var response = new ServiceResponse <RoomInfo> {
Content = savedRoom
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage DeleteEvent(int itemId)
{
try
{
CodeCampDataAccess.DeleteItem(itemId, ActiveModule.ModuleID);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage PingError()
{
var errors = new List <ServiceError>();
errors.Add(new ServiceError()
{
Code = "NULL",
Description = "NullReferenceException stack trace"
});
var response = new ServiceResponse <string>()
{
Errors = errors
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
public HttpResponseMessage GetCurrentUserId()
{
try
{
var currentUserId = UserInfo.UserID;
var response = new ServiceResponse <int> {
Content = currentUserId
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetRegistration(int itemId, int codeCampId)
{
try
{
var registration = RegistrationDataAccess.GetItem(itemId, codeCampId);
var response = new ServiceResponse <RegistrationInfo> {
Content = registration
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UpdateSessionTimeSlotOrder(int sessionId, int codeCampId, int newPosition)
{
try
{
SessionDataAccess.UpdateItemSortOrder(sessionId, codeCampId, newPosition);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage DeleteVolunteerTask(int itemId, int volunteerId)
{
try
{
VolunteerTaskDataAccess.DeleteItem(itemId, volunteerId);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UpdateSessionSpeaker(SessionSpeakerInfo speaker)
{
try
{
SessionSpeakerDataAccess.UpdateItem(speaker);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateSession(SessionInfo session)
{
try
{
var timeStamp = DateTime.Now;
session.CreatedByDate = timeStamp;
session.CreatedByUserId = UserInfo.UserID;
session.LastUpdatedByDate = timeStamp;
session.LastUpdatedByUserId = UserInfo.UserID;
if (session.TrackId == 0)
{
session.TrackId = null;
}
if (session.TimeSlotId == 0)
{
session.TimeSlotId = null;
}
// adding a date/time placeholder because DAL doesn't know how to handle a null value
session.ApprovedByDate = Globals.NULL_DATE;
SessionDataAccess.CreateItem(session);
var sessions = SessionDataAccess.GetItems(session.CodeCampId);
var savedSession = sessions.OrderByDescending(s => s.CreatedByDate).FirstOrDefault(s => s.Title == session.Title);
var response = new ServiceResponse <SessionInfo> {
Content = savedSession
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UpdateSessionRegistration(SessionRegistrationInfo registration)
{
try
{
SessionRegistrationDataAccess.UpdateItem(registration);
var savedRegistration = SessionRegistrationDataAccess.GetItems(registration.SessionId).FirstOrDefault(r => r.RegistrationId == registration.RegistrationId);
var response = new ServiceResponse <SessionRegistrationInfo> {
Content = savedRegistration
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateVolunteer(VolunteerInfo volunteer)
{
try
{
VolunteerDataAccess.CreateItem(volunteer);
var savedVolunteer = VolunteerDataAccess.GetItemByRegistrationId(volunteer.RegistrationId, volunteer.CodeCampId);
var response = new ServiceResponse <VolunteerInfo> {
Content = savedVolunteer
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
