//Jaimeiris - gets the submission with ID submission ID to be evaluated by evaluator with evaluatorID
public AssignedSubmission getSubmissionForEvaluation(long submissionID, long evaluatorID)
{
try
{
using (conferenceadminContext context = new conferenceadminContext())
{
//gets all the evaluations assigned to the given evaluator
AssignedSubmission subs = new AssignedSubmission();
evaluatiorsubmission sub;
//gets info for permissions in the front end (i.e. option to ask to add a final version)
bool isFinalVersion = context.usersubmission.Where(c => c.finalSubmissionID == submissionID).FirstOrDefault() == null ? false : true;
long userIDofEvaluator = context.evaluators.Where(c => c.evaluatorsID == evaluatorID).FirstOrDefault() == null ?
-1 : context.evaluators.Where(d => d.evaluatorsID == evaluatorID).FirstOrDefault().userID;
List<claim> userClaims = context.claims.Where(c => c.userID == userIDofEvaluator).ToList();
bool canAllowFinalVersion = false;
foreach (var claim in userClaims)
{
//if user is a master, admin or committee manager allow the to allow the submitter to submit a final version
if (claim.privilegesID == 1 || claim.privilegesID == 3 || claim.privilegesID == 5)
canAllowFinalVersion = true;
}
//gets submission info
sub = context.evaluatiorsubmissions.Where(c => c.submissionID == submissionID && c.evaluatorID == evaluatorID && c.deleted == false).FirstOrDefault();
if (sub.submission.submissionTypeID == 1 || sub.submission.submissionTypeID == 2 || sub.submission.submissionTypeID == 4)
{
subs = new AssignedSubmission
{
submissionID = sub.submissionID,
userType = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.usertype.userTypeName,
evaluatorID = sub.evaluatorID,
submissionTitle = sub.submission.title,
topic = sub.submission.topiccategory.name,
submitterFirstName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.firstName,
submitterLastName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.lastName,
submissionAbstract = sub.submission.submissionAbstract,
submissionFileList = sub.submission.documentssubmitteds.Where(u => u.deleted == false).
Select(c => new SubmissionDocument
{
documentssubmittedID = c.documentssubmittedID,
submissionID = c.submissionID,
documentName = c.documentName,
//document = c.document,
deleted = c.deleted
}).ToList(),
submissionType = sub.submission.submissiontype.name,
evaluationTemplateID = sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault() == null ? -1 : sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault().templateID,
panelistNames = null,
plan = null,
guideQuestions = null,
format = null,
equipment = null,
duration = null,
delivery = null,
evaluationsubmittedID = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? -1 : sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault().evaluationsubmittedID),
evaluatiorSubmissionID = sub.evaluationsubmissionID,
evaluationName = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.evaluationName).FirstOrDefault(),
evaluationFile = sub.evaluationsubmitteds.Where(d => d.deleted == false).Select(r => r.evaluationFile).FirstOrDefault(),
evaluationScore = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.score).FirstOrDefault(),
publicFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.publicFeedback).FirstOrDefault(),
privateFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.privateFeedback).FirstOrDefault(),
subIsEvaluated = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? false : true),
allowFinalVersion = ((sub.submission.usersubmissions1.FirstOrDefault() == null ?
null : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == null ?
false : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == false ? false : true
};
}
else if (sub.submission.submissionTypeID == 3)
{
subs = new AssignedSubmission
{
submissionID = sub.submissionID,
userType = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.usertype.userTypeName,
evaluatorID = sub.evaluatorID,
submissionTitle = sub.submission.title,
topic = sub.submission.topiccategory.name,
submitterFirstName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.firstName,
submitterLastName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.lastName,
submissionAbstract = sub.submission.submissionAbstract,
submissionFileList = sub.submission.documentssubmitteds.Where(u => u.deleted == false).
Select(c => new SubmissionDocument
{
documentssubmittedID = c.documentssubmittedID,
submissionID = c.submissionID,
documentName = c.documentName,
//document = c.document,
deleted = c.deleted
}).ToList(),
submissionType = sub.submission.submissiontype.name,
evaluationTemplateID = sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault() == null ? -1 : sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault().templateID,
panelistNames = sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault().panelistNames,
plan = sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault().plan,
guideQuestions = sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault().guideQuestion,
format = sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault().formatDescription,
equipment = sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.panels.Where(y => y.deleted == false).FirstOrDefault().necessaryEquipment,
duration = null,
delivery = null,
evaluationsubmittedID = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? -1 : sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault().evaluationsubmittedID),
evaluatiorSubmissionID = sub.evaluationsubmissionID,
evaluationName = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.evaluationName).FirstOrDefault(),
evaluationFile = sub.evaluationsubmitteds.Where(d => d.deleted == false).Select(r => r.evaluationFile).FirstOrDefault(),
evaluationScore = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.score).FirstOrDefault(),
publicFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.publicFeedback).FirstOrDefault(),
privateFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.privateFeedback).FirstOrDefault(),
subIsEvaluated = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? false : true),
allowFinalVersion = ((sub.submission.usersubmissions1.FirstOrDefault() == null ?
null : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == null ?
false : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == false ? false : true
};
}
else if (sub.submission.submissionTypeID == 5)
{
subs = new AssignedSubmission
{
submissionID = sub.submissionID,
userType = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.usertype.userTypeName,
evaluatorID = sub.evaluatorID,
submissionTitle = sub.submission.title,
topic = sub.submission.topiccategory.name,
submitterFirstName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.firstName,
submitterLastName = sub.submission.usersubmissions1.FirstOrDefault() == null ? null : sub.submission.usersubmissions1.FirstOrDefault().user.lastName,
submissionAbstract = sub.submission.submissionAbstract,
submissionFileList = sub.submission.documentssubmitteds.Where(u => u.deleted == false).
Select(c => new SubmissionDocument
{
documentssubmittedID = c.documentssubmittedID,
submissionID = c.submissionID,
documentName = c.documentName,
//document = c.document,
deleted = c.deleted
}).ToList(),
submissionType = sub.submission.submissiontype.name,
evaluationTemplateID = sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault() == null ? -1 : sub.submission.templatesubmissions.Where(u => u.deleted == false).FirstOrDefault().templateID,
panelistNames = null,
plan = sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault().plan,
guideQuestions = null,
format = null,
equipment = sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault().necessary_equipment,
duration = sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault().duration,
delivery = sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault() == null ? null : sub.submission.workshops.Where(y => y.deleted == false).FirstOrDefault().delivery,
evaluationsubmittedID = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? -1 : sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault().evaluationsubmittedID),
evaluatiorSubmissionID = sub.evaluationsubmissionID,
evaluationName = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.evaluationName).FirstOrDefault(),
evaluationFile = sub.evaluationsubmitteds.Where(d => d.deleted == false).Select(r => r.evaluationFile).FirstOrDefault(),
evaluationScore = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.score).FirstOrDefault(),
publicFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.publicFeedback).FirstOrDefault(),
privateFeedback = sub.evaluationsubmitteds.Where(c => c.deleted == false).Select(r => r.privateFeedback).FirstOrDefault(),
subIsEvaluated = (sub.evaluationsubmitteds.Where(c => c.deleted == false).FirstOrDefault() == null ? false : true),
allowFinalVersion = ((sub.submission.usersubmissions1.FirstOrDefault() == null ?
null : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == null ?
false : sub.submission.usersubmissions1.FirstOrDefault().allowFinalVersion) == false ? false : true
};
}
subs.isFinalVersion = isFinalVersion;
subs.canAllowFinalVersion = canAllowFinalVersion;
return subs;
}
}
catch (Exception ex)
{
Console.Write("SubmissionManager.getSubmission error " + ex);
return null;
}
}
public ProfileModules(ITokenizer tokenizer)
: base("/profile")
{
ProfileInfoManager profileInfo = new ProfileInfoManager();
SubmissionManager submission = new SubmissionManager();
ProfileAuthorizationManager profileAuthorization = new ProfileAuthorizationManager();
// [Randy] Get information for the user profile
Get["/getProfileInfo/{userID:long}"] = parameters =>
{
var user = this.Bind<UserInfo>();
return Response.AsJson(profileInfo.getProfileInfo(user));
};
// [Randy] Edit information of the user profile
Put["/updateProfileInfo"] = parameters =>
{
var user = this.Bind<UserInfo>();
if (profileInfo.updateProfileInfo(user))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
};
// [Randy] Make application to attend the conference
Put["/apply"] = parameters =>
{
var user = this.Bind<UserInfo>();
if (profileInfo.apply(user))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
};
//Put["/makePayment"] = parameters =>
//{
// var user = this.Bind<UserInfo>();
// if (.makePayment(user))
// return HttpStatusCode.OK;
// else
// return HttpStatusCode.Conflict;
//};
// [Randy] Register as a complementary user without paying
Put["/complementaryPayment"] = parameters =>
{
var user = this.Bind<UserInfo>();
if (profileInfo.complementaryPayment(user, user.key))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
};
// [Randy] Verify the complementary key
Get["/checkComplementaryKey/{complementaryKey}"] = parameters =>
{
var key = parameters.complementaryKey;
return (profileInfo.checkComplementaryKey(key));
};
//------------------------EVALUATOR - SUBMISSIONS-------------------------------------------
// [Jaimeiris] Gets the list of submissions assigned to the evaluator currently logged in to the system
Get["/getAssignedSubmissions/{evaluatorUserID:long}/{index:int}"] = parameters =>
{
long evaluatorUserID = parameters.evaluatorUserID; //ID of the evaluator that is currently signed in
int index = parameters.index;
SubmissionPagingQuery assignedSubmissions = submission.getAssignedSubmissions(evaluatorUserID, index);
if (assignedSubmissions == null)
{
assignedSubmissions = new SubmissionPagingQuery();
}
return Response.AsJson(assignedSubmissions);
};
/* [Randy] Search within the list with a certain criteria */
Get["/searchAssignedSubmission/{evaluatorUserID}/{index}/{criteria}"] = parameters =>
{
long evaluatorUserID = parameters.evaluatorUserID; //ID of the evaluator that is currently signed in
int index = parameters.index;
string criteria = parameters.criteria;
SubmissionPagingQuery assignedSubmissions = submission.searchAssignedSubmission(evaluatorUserID, index, criteria);
if (assignedSubmissions == null)
{
assignedSubmissions = new SubmissionPagingQuery();
}
return Response.AsJson(assignedSubmissions);
};
// [Jaimeiris] Get the info of a submission
Get["/getSubmission/{submissionID:long}/{evaluatorID:long}"] = parameters =>
{
long submissionID = parameters.submissionID;
long evaluatorID = parameters.evaluatorID;
AssignedSubmission sub = submission.getSubmissionForEvaluation(submissionID, evaluatorID);
if (sub == null)
{
sub = new AssignedSubmission();
}
return Response.AsJson(sub);
};
// [Jaimeiris] Post new evaluation for a submission
Post["/addEvaluation"] = parameters =>
{
var evaluation = this.Bind<evaluationsubmitted>();
usersubmission usersub = this.Bind<usersubmission>();
if (submission.addEvaluation(evaluation, usersub)) return HttpStatusCode.OK;
else return HttpStatusCode.Conflict;
};
// [Jaimeiris] Edit evaluation for a submission
Put["/editEvaluation"] = parameters =>
{
var evaluation = this.Bind<evaluationsubmitted>();
usersubmission usersub = this.Bind<usersubmission>();
if (submission.editEvaluation(evaluation, usersub)) return HttpStatusCode.OK;
else return HttpStatusCode.Conflict;
};
//------------------------------------USER SUBMISSIONS---------------------------------
// [Jaimeiris] Get list of all submissions
Get["/getUserSubmissionList/{id}"] = parameters =>
{
long userID = parameters.id; //ID of the evaluator that is currently signed in
List<Submission> userSubmissions = submission.getUserSubmissions(userID);
if (userSubmissions == null)
{
userSubmissions = new List<Submission>();
}
return Response.AsJson(userSubmissions);
};
// [Jaimeiris] Get single user submission
Get["/getUserSubmission/{id}"] = parameters =>
{
long submissionID = parameters.id;
CurrAndPrevSub sub = submission.getUserSubmission(submissionID);
if (sub == null)
{
sub = new CurrAndPrevSub();
}
return Response.AsJson(sub);
};
// [Jaimeiris] Get submission types
Get["/getSubmissionTypes"] = parameters =>
{
List<SubmissionType> subTypes = submission.getSubmissionTypes();
if (subTypes == null)
{
subTypes = new List<SubmissionType>();
}
return Response.AsJson(subTypes);
};
// [Jaimeiris] Delete a submission
Delete["/deleteSubmission/{id}"] = parameters =>
{
long submissionID = parameters.id;
Submission prevSub = submission.deleteSubmission(submissionID);
if (prevSub != null)
return Response.AsJson(prevSub);
else return null;
};
// [Jaimeiris] Add a submission
Post["/postSubmission"] = parameters =>
{
panel pannelToAdd = null;
workshop workshopToAdd = null;
submission submissionToAdd = this.Bind<submission>();
usersubmission usersubTA = this.Bind<usersubmission>();
int submissionTypeID = submissionToAdd.submissionTypeID;
if (submissionTypeID == 3)
{
pannelToAdd = this.Bind<panel>();
}
else if (submissionTypeID == 5)
{
workshopToAdd = this.Bind<workshop>();
}
Submission newSubmission =
submission.addSubmission(usersubTA, submissionToAdd, pannelToAdd, workshopToAdd);
return Response.AsJson(newSubmission);
};
// [Jaimeiris] Add new file to submission
Put["/addSubmissionFile"] = parameters =>
{
documentssubmitted doc = this.Bind<documentssubmitted>();
if (doc.document != null)
{
return Response.AsJson(submission.addSubmissionFile(doc));
}
else return null;
};
// [Jaimeiris] Manage existing files for a submission
Put["/manageExistingFiles"] = parameters =>
{
//documentssubmitted sub = this.Bind<documentssubmitted>();
ExistingFile sub = this.Bind<ExistingFile>();
/*if (sub.IDsList.Count == 0)
{
return HttpStatusCode.OK;
}
else
{*/
if (submission.manageExistingFiles(sub.submissionID, sub.IDsList))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
// }
};
// [Jaimeiris] Re-create final submission files
Put["/createFinalSubmissionFiles"] = parameters =>
{
//documentssubmitted sub = this.Bind<documentssubmitted>();
ExistingFile sub = this.Bind<ExistingFile>();
if (submission.createFinalSubmissionFiles(sub.submissionID, sub.prevID, sub.IDsList))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
};
// [Jaimeiris] Edit submission
Put["/editSubmission"] = parameters =>
{
panel pannelToEdit = null;
workshop workshopToEdit = null;
submission submissionToEdit = this.Bind<submission>();
int submissionTypeID = submissionToEdit.submissionTypeID;
if (submissionTypeID == 3)
{
pannelToEdit = this.Bind<panel>();
}
else if (submissionTypeID == 5)
{
workshopToEdit = this.Bind<workshop>();
}
Submission editedSubmission =
submission.editSubmission(submissionToEdit, pannelToEdit, workshopToEdit);
return Response.AsJson(editedSubmission);
};
// [Jaimeiris] Post final version of evaluation
Post["/postFinalSubmission"] = parameters =>
{
panel pannelToAdd = null;
workshop workshopToAdd = null;
submission submissionToAdd = this.Bind<submission>();
documentssubmitted submissionDocuments = this.Bind<documentssubmitted>();
usersubmission usersubTA = this.Bind<usersubmission>();
int submissionTypeID = submissionToAdd.submissionTypeID;
if (submissionDocuments.document == null && submissionDocuments.documentName == null)
{
submissionDocuments = null;
}
if (submissionTypeID == 3)
{
pannelToAdd = this.Bind<panel>();
}
else if (submissionTypeID == 5)
{
workshopToAdd = this.Bind<workshop>();
}
Submission newSubmission =
submission.addFinalSubmission(usersubTA, submissionToAdd, submissionDocuments, pannelToAdd, workshopToAdd);
return Response.AsJson(newSubmission);
};
// [Jaimeiris] Get the deadline for the additon of submissions
Get["/getSubmissionDeadlines"] = parameters =>
{
return Response.AsJson(submission.getSubmissionDeadlines());
};
// [Jaimeiris] Get the template file
Get["/getTemplateFile/{id}"] = parameters =>
{
int templateID = parameters.id;
return Response.AsJson(profileAuthorization.getTemplateFile(templateID));
};
// [Jaimeiris] Get the authorization file
Get["/getAuthorizationFile/{id}"] = parameters =>
{
int authorizationID = parameters.id;
return Response.AsJson(profileAuthorization.getAuthorizationFile(authorizationID));
};
// [Jaimeiris] Get evaluation template
Get["/getEvaluationTemplate/{templateID:long}"] = parameters =>
{
int templateID = parameters.templateID;
return Response.AsJson(submission.getEvaluationTemplate(templateID));
};
// [Jaimeiris] Get evaluation file
Get["/getEvaluationFile/{submissionID:long}/{evaluatorID:long}"] = parameters =>
{
long submissionID = parameters.submissionID;
long evaluatorID = parameters.evaluatorID;
return Response.AsJson(submission.getEvaluationFile(submissionID, evaluatorID));
};
//------------------------AUTHORIZATION----------------------------------
// [Randy] Upload an authorization document
Put["/uploadDocument"] = parameters =>
{
var doc = this.Bind<Authorization>();
var minor = this.Bind<MinorUser>();
return Response.AsJson(profileAuthorization.uploadDocument(doc, minor));
};
// [Randy] Get list of authorization templates
Get["/getTemplates"] = parameters =>
{
return Response.AsJson(profileAuthorization.getTemplates());
};
// [Randy] Get list of authorization documents submitted
Get["/getDocuments/{userID:long}"] = parameters =>
{
var user = this.Bind<UserInfo>();
return Response.AsJson(profileAuthorization.getDocuments(user));
};
// [Randy] Delete a specific document
Put["/deleteDocument"] = parameters =>
{
var doc = this.Bind<Authorization>();
if (profileAuthorization.deleteDocument(doc))
return HttpStatusCode.OK;
else
return HttpStatusCode.Conflict;
};
// [Randy] Bind companion with minor
Post["/selectCompanion"] = parameters =>
{
var user = this.Bind<UserInfo>();
var companion = this.Bind<companion>();
var status = profileAuthorization.selectCompanion(user, companion);
if (status != null)
return status;
else
return HttpStatusCode.Conflict;
};
// [Randy] Get submitted companion key
Get["/getCompanionKey/{userID:long}"] = parameters =>
{
var user = this.Bind<UserInfo>();
return Response.AsJson(profileAuthorization.getCompanionKey(user));
};
}
