public static void RemoveFromCourse(int userID, int courseID)
{
DatabaseCall dbc = new DatabaseCall("Users_Purge", DBCallType.Execute);
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@CourseID", courseID);
dbc.Execute();
}
private void AddFile(string filename)
{
DatabaseCall dbc = new DatabaseCall("StudentAssignments_AddFile", DBCallType.Execute);
dbc.AddParameter("@UserAssignmentID", _userAssignmentID);
dbc.AddParameter("@FileName", filename);
dbc.Execute();
}
public void ImportToCourse(int courseID, string importID)
{
DatabaseCall dbc = new DatabaseCall("Users_ImportToCourse", DBCallType.Execute);
dbc.AddParameter("@UserID", _userID);
dbc.AddParameter("@CourseID", courseID);
dbc.AddParameter("@ImportID", importID);
dbc.Execute();
}
public void ClearSubmissions()
{
DatabaseCall dbc = new DatabaseCall("StudentAssignments_ClearSubmissions", DBCallType.Execute);
dbc.AddParameter("@UserID", _userID);
dbc.AddParameter("@AssignmentID", _assignmentID);
dbc.Execute();
}
public void AddResource(string name, string resourceValue)
{
DatabaseCall dbc = new DatabaseCall("Courses_AddResource", DBCallType.Execute);
dbc.AddParameter("@CourseID", _courseID);
dbc.AddParameter("@Name", name);
dbc.AddParameter("@ResourceValue", resourceValue);
dbc.Execute();
}
public static void SetRoleInCourse(int userID, int courseID, int roleID)
{
DatabaseCall dbc = new DatabaseCall("Roles_UpdateRoleInCourse", DBCallType.Execute);
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@CourseID", courseID);
dbc.AddParameter("@RoleID", roleID);
dbc.Execute();
}
internal void AddToCourse(int courseID, PermissionsID roleID)
{
DatabaseCall dbc = new DatabaseCall("Users_AddToCourse", DBCallType.Execute);
dbc.AddParameter("@UserID", _userID);
dbc.AddParameter("@CourseID", courseID);
dbc.AddParameter("RoleID", (int)roleID);
dbc.Execute();
}
public static AssignmentList GetStudentAssignmentListForCourse(int userID, int CourseID)
{
//****
DatabaseCall dbc = new DatabaseCall("Courses_GetStudentAssignmentList", DBCallType.Select);
AssignmentList assignList = new AssignmentList();
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@CourseID", CourseID);
dbc.Fill(assignList.assignmentDS);
return(assignList);
}
public void DeleteResource(int resourceID)
{
DatabaseCall dbc = new DatabaseCall("Courses_DeleteResource", DBCallType.Execute);
dbc.AddParameter("@CourseResourceID", resourceID);
dbc.Execute();
}
internal static void Delete(int assignid)
{
DatabaseCall dbc = new DatabaseCall("Assignments_Purge", DBCallType.Execute);
dbc.AddParameter("@AssignmentID", assignid);
dbc.Execute();
}
internal static bool CommitImport(string importID)
{
DatabaseCall dbc = new DatabaseCall("Import_LoadPendingImport", DBCallType.Select);
dbc.AddParameter("@ImportID", importID);
System.Data.DataSet ds = new System.Data.DataSet();
dbc.Fill(ds);
if ((ds.Tables.Count <= 0) || (ds.Tables[0].Rows.Count <= 0))
{
return(false);
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
UserM user = UserM.Load(Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"]));
user.GenerateNewPassword();
user.AddToCourse(Convert.ToInt32(ds.Tables[0].Rows[i]["CourseID"]));
}
catch
{
}
}
return(true);
}
public static CourseM Load(System.Guid courseGUID)
{
DatabaseCall dbc = new DatabaseCall("Courses_LoadCourseByGUID", DBCallType.Select);
dbc.AddParameter("@CourseGUID", courseGUID);
return(LoadCourseFromDatabase(dbc));
}
public static CourseM Load(string courseName)
{
DatabaseCall dbc = new DatabaseCall("Courses_LoadCourseByName", DBCallType.Select);
dbc.AddParameter("@ShortName", courseName);
return(LoadCourseFromDatabase(dbc));
}
public void ClearStarter()
{
DatabaseCall dbc = new DatabaseCall("Assignments_ClearStarter", DBCallType.Execute);
dbc.AddParameter("@AssignmentID", _assignmentID);
dbc.Execute();
}
internal void Delete()
{
DatabaseCall dbc = new DatabaseCall("Courses_DeleteCourse", DBCallType.Execute);
dbc.AddParameter("@CourseID", this._courseID);
dbc.Execute();
}
public static UserM Load(int userID)
{
DatabaseCall dbc = new DatabaseCall("Users_LoadUserByUserID", DBCallType.Select);
dbc.AddParameter("@UserID", userID);
return(LoadUserFromDatabase(dbc));
}
public static UserM LoadByUniversityID(string universityID)
{
DatabaseCall dbc = new DatabaseCall("Users_LoadUserByUniversityID", DBCallType.Select);
dbc.AddParameter("@UniversityID", universityID);
return(LoadUserFromDatabase(dbc));
}
public static UserM LoadByEmail(string email)
{
DatabaseCall dbc = new DatabaseCall("Users_LoadUserByEmail", DBCallType.Select);
dbc.AddParameter("@Email", email);
return(LoadUserFromDatabase(dbc));
}
public static UserM LoadByUserName(string username)
{
DatabaseCall dbc = new DatabaseCall("Users_LoadUserByUsername", DBCallType.Select);
dbc.AddParameter("@UserName", username);
return(LoadUserFromDatabase(dbc));
}
public static StudentAssignmentM Load(int userID, int assignmentID)
{
System.Data.DataSet ds = new System.Data.DataSet();
DatabaseCall dbc = new DatabaseCall("StudentAssignments_LoadAssignment", DBCallType.Select);
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@AssignmentID", assignmentID);
dbc.Fill(ds);
if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
return(PopulateNewAssignment(ds));
}
internal static void AbortImport(string importID)
{
DatabaseCall dbc = new DatabaseCall("Import_AbortImport", DBCallType.Execute);
dbc.AddParameter("@ImportID", importID);
dbc.Execute();
}
public string StarterFilesXML(System.Guid guid)
{
try
{
DataSet ds = new DataSet();
string downloadRoot = SharedSupport.AddBackSlashToDirectory(System.Web.HttpContext.Current.Request.MapPath(String.Empty, Constants.ASSIGNMENTMANAGER_DOWNLOAD_DIRECTORY, true));
string storageLocation = String.Empty;
AssignmentM assign = AssignmentM.Load(_assignmentID);
storageLocation = SharedSupport.AddBackSlashToDirectory(assign.StorageDirectory + Constants.STARTER_PROJECT_PATH);
//add unique guid to download path
downloadRoot = downloadRoot + SharedSupport.AddBackSlashToDirectory(guid.ToString());
DatabaseCall dbc = new DatabaseCall("Assignments_GetFiles", DBCallType.Select);
dbc.AddParameter("@AssignmentID", _assignmentID);
dbc.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string source = String.Empty;
string destination = String.Empty;
string filename = ds.Tables[0].Rows[i]["FileName"].ToString().Trim();
filename = filename.Replace(@"\", @"/");
source = SharedSupport.RemoveIllegalFilePathCharacters(storageLocation + filename);
destination = SharedSupport.RemoveIllegalFilePathCharacters(downloadRoot + filename);
//check to see if destination directory exists
string destinationDir = destination.Substring(0, destination.LastIndexOf("\\") + 1);
if (!Directory.Exists(destinationDir))
{
Directory.CreateDirectory(destinationDir);
}
//check if file is there
if (System.IO.File.Exists(source))
{
System.IO.File.Copy(source, destination, true);
}
else
{
throw new System.IO.FileNotFoundException(SharedSupport.GetLocalizedString("Assignment_UploadedFileNotFound"));
}
if (filename.StartsWith(@"/"))
{
ds.Tables[0].Rows[i]["FileName"] = guid + filename;
}
else
{
ds.Tables[0].Rows[i]["FileName"] = guid + @"/" + filename;
}
}
return(ds.GetXml());
}
catch (Exception e)
{
return(e.Message);
}
}
public static AssignmentList GetSubmissionsForAssignment(int AssignmentID)
{
DatabaseCall dbc = new DatabaseCall("Courses_GetSubmissionsList", DBCallType.Select);
AssignmentList assignList = new AssignmentList();
dbc.AddParameter("@AssignmentID", AssignmentID);
dbc.Fill(assignList.assignmentDS);
return(assignList);
}
public static UserList GetListFromCourse(int courseID)
{
UserList userList = new UserList();
DatabaseCall dbc = new DatabaseCall("Courses_GetUserList", DBCallType.Select);
dbc.AddParameter("@CourseID", courseID);
dbc.Fill(userList.ds);
return(userList);
}
public void SetPassword(string password, bool hasChanged)
{
Byte[] passwd = SharedSupport.ConvertStringToByteArray(password.Trim());
byte[] hashValue = ((HashAlgorithm)CryptoConfig.CreateFromName(Constants.HashMethod)).ComputeHash(passwd);
string hashedPassword = BitConverter.ToString(hashValue);
DatabaseCall dbc = new DatabaseCall("Users_ChangePassword", DBCallType.Execute);
dbc.AddParameter("@UserID", _userID);
dbc.AddParameter("@Password", hashedPassword);
dbc.AddParameter("@ChangedPassword", hasChanged);
dbc.Execute();
// This is only true when a faculty member updated someone else's password
if (!hasChanged)
{
SendPasswordToUser(password);
}
}
public static RoleM GetUsersRoleInCourse(int userID, int courseID)
{
DatabaseCall dbc = new DatabaseCall("Roles_GetRoleForUserInCourse", DBCallType.Select);
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@CourseID", courseID);
System.Data.DataSet ds = new System.Data.DataSet();
dbc.Fill(ds);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(new RoleM(0, ""));
}
else
{
int roleID = Convert.ToInt32(ds.Tables[0].Rows[0]["RoleID"]);
string roleName = ds.Tables[0].Rows[0]["Name"].ToString();
return(new RoleM(roleID, roleName));
}
}
/// <summary>
/// Sets value in Settings table
/// </summary>
/// <param name="settingName"> </param>
/// <param name="settingValue"> </param>
internal static void SetSetting(string settingName, string settingValue)
{
try
{
// validate parameters
if (settingName.Equals(null) || settingName == String.Empty)
{
throw new ArgumentNullException(SharedSupport.GetLocalizedString("SharedSupport_SettingNameField"), SharedSupport.GetLocalizedString("SharedSupport_Missing_SettingName"));
}
if (settingValue.Equals(null) || settingValue == String.Empty)
{
throw new ArgumentNullException(SharedSupport.GetLocalizedString("SharedSupport_SettingValueField"), SharedSupport.GetLocalizedString("SharedSupport_Missing_SettingValue"));
}
// if they are changing the AutoBuild/AutoCheck update the Service Status
if ((settingName.Equals(Constants.AUTOBUILD_SETTING)) || (settingName.Equals(Constants.AUTOCHECK_SETTING)))
{
// change the service status
if (!changeServiceStatus(settingValue, Constants.ACTION_SERVICE_NAME))
{
// throw an exception b/c we couldn't update the service
throw new System.Exception(GetLocalizedString("Setting_UnableToUpdateService_Error"));
}
// no database interaction for the Actions Service
}
else
{
//We're changing a setting stored in the database
DatabaseCall dbc = new DatabaseCall("Settings_UpdateSetting", DBCallType.Execute);
dbc.AddParameter("@Setting", settingName);
dbc.AddParameter("@Value", settingValue);
dbc.Execute();
}
}
catch (System.Exception e)
{
SharedSupport.HandleError(e);
}
}
internal static bool SecurityIsAllowed(int userID, int courseID, SecurityAction action)
{
DatabaseCall dbc = new DatabaseCall("Security_IsAllowed", DBCallType.Select);
dbc.AddParameter("@UserID", userID);
dbc.AddParameter("@CourseID", courseID);
dbc.AddParameter("@ActionID", (int)action);
System.Data.DataSet ds = new System.Data.DataSet();
dbc.Fill(ds);
try
{
if (Convert.ToInt32(ds.Tables[0].Rows[0]["UserID"]) == userID)
{
return(true);
}
}
catch
{
return(false);
}
return(false);
}
private int saveCourseToDatabase(CourseStoredProcType sprocType)
{
DatabaseCall dbc;
int retID = 0;
if (sprocType == CourseStoredProcType.Add)
{
dbc = new DatabaseCall("Courses_AddNewCourse", DBCallType.Execute);
dbc.AddOutputParameter("@CourseID");
}
else if (sprocType == CourseStoredProcType.Update)
{
dbc = new DatabaseCall("Courses_UpdateExistingCourse", DBCallType.Execute);
dbc.AddParameter("@CourseID", this._courseID);
}
else
{
throw new Exception("Unknown Stored Procedure Type");
}
dbc.AddParameter("@CourseGUID", _courseGUID);
dbc.AddParameter("@ShortName", _courseName);
dbc.AddNTextParameter("@Description", _description);
dbc.AddParameter("@LastUpdatedDate", System.DateTime.Now);
dbc.AddParameter("@LastUpdatedUserID", _lastUpdatedUserID);
dbc.AddParameter("@HomepageURL", _homepageURL);
dbc.AddParameter("@MultipleSubmitsFlag", false);
dbc.AddParameter("@SendEmailRemindersFlag", _sendEmailRemindersFlag);
dbc.AddParameter("@StartDate", _startDate);
dbc.AddParameter("@EndDate", _endDate);
dbc.AddParameter("@RootStoragePath", _rootStoragePath);
dbc.Execute();
if (sprocType == CourseStoredProcType.Add)
{
try
{
retID = Convert.ToInt32(dbc.GetOutputParam("@CourseID"));
this._courseID = retID;
}
catch
{
}
}
//Write course data to file
saveCourseXML();
return(retID);
}
private void SaveToDatabase(StoredProcType procType)
{
DatabaseCall dbc;
switch (procType)
{
case StoredProcType.New:
dbc = new DatabaseCall("StudentAssignments_AddNewAssignment", DBCallType.Execute);
dbc.AddOutputParameter("@UserAssignmentID");
break;
case StoredProcType.Update:
dbc = new DatabaseCall("StudentAssignments_UpdateExistingAssignment", DBCallType.Execute);
break;
default:
throw new Exception("Invalid Stored Procedure");
}
dbc.AddParameter("@UserID", this._userID);
dbc.AddParameter("@AssignmentID", this._assignmentID);
dbc.AddParameter("@LastSubmitDate", this._lastSubmitDate);
dbc.AddParameter("@LastUpdatedDate", this._lastUpdatedDate);
dbc.AddParameter("@OverallGrade", this._overallGrade);
dbc.AddNTextParameter("@GradeComments", this._gradeComments);
dbc.AddParameter("@AutoCompileStatus", this._autoCompileStatus);
dbc.AddParameter("@AutoGradeStatus", this._autoGradeStatus);
dbc.AddNTextParameter("@BuildDetails", this._buildDetails);
dbc.AddNTextParameter("@CheckDetails", this._checkDetails);
dbc.AddParameter("@BuildResultCode", this._buildResultCode);
dbc.AddParameter("@CheckResultCode", this._checkResultCode);
dbc.Execute();
if (procType == StoredProcType.New)
{
this._userAssignmentID = Convert.ToInt32(dbc.GetOutputParam("@UserAssignmentID"));
}
}
