private void AddFile(string filename) { DatabaseCall dbc = new DatabaseCall("StudentAssignments_AddFile", DBCallType.Execute); dbc.AddParameter("@UserAssignmentID", _userAssignmentID); dbc.AddParameter("@FileName", filename); dbc.Execute(); }
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(); }
public void ClearSubmissions() { DatabaseCall dbc = new DatabaseCall("StudentAssignments_ClearSubmissions", DBCallType.Execute); dbc.AddParameter("@UserID", _userID); dbc.AddParameter("@AssignmentID", _assignmentID); 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(); }
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 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(); }
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 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(); }
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)); }
internal static void Delete(int assignid) { DatabaseCall dbc = new DatabaseCall("Assignments_Purge", DBCallType.Execute); dbc.AddParameter("@AssignmentID", assignid); dbc.Execute(); }
public void ClearStarter() { DatabaseCall dbc = new DatabaseCall("Assignments_ClearStarter", DBCallType.Execute); dbc.AddParameter("@AssignmentID", _assignmentID); dbc.Execute(); }
public void DeleteResource(int resourceID) { DatabaseCall dbc = new DatabaseCall("Courses_DeleteResource", DBCallType.Execute); dbc.AddParameter("@CourseResourceID", resourceID); dbc.Execute(); }
public static UserM LoadByUniversityID(string universityID) { DatabaseCall dbc = new DatabaseCall("Users_LoadUserByUniversityID", DBCallType.Select); dbc.AddParameter("@UniversityID", universityID); 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) { return(null); } return(PopulateNewAssignment(ds)); }
public static UserM Load(int userID) { DatabaseCall dbc = new DatabaseCall("Users_LoadUserByUserID", DBCallType.Select); dbc.AddParameter("@UserID", userID); 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 UserM LoadByEmail(string email) { DatabaseCall dbc = new DatabaseCall("Users_LoadUserByEmail", DBCallType.Select); dbc.AddParameter("@Email", email); return(LoadUserFromDatabase(dbc)); }
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 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)); } }
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")); } }
internal static AssignmentM Load(int assignmentID) { //set courseID = 0, it will get overwritten when we load. AssignmentM retVal = new AssignmentM(0); DatabaseCall dbc = new DatabaseCall("Assignments_LoadAssignment", DBCallType.Select); dbc.AddParameter("@AssignmentID", assignmentID); DataSet ds = new DataSet(); dbc.Fill(ds); if (ds.Tables.Count <= 0) { return(null); } // Populate the return value. retVal._assignmentID = assignmentID; retVal.Description = ds.Tables[0].Rows[0]["Description"].ToString(); retVal.StarterProjectFlag = Convert.ToBoolean(ds.Tables[0].Rows[0]["StarterProjectFlag"]); retVal.ShortName = ds.Tables[0].Rows[0]["ShortName"].ToString(); retVal.CompilerType = ds.Tables[0].Rows[0]["CompilerType"].ToString(); retVal.LastUpdatedDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["LastUpdatedDate"].ToString()); retVal.LastUpdatedUserID = Convert.ToInt32(ds.Tables[0].Rows[0]["LastUpdatedUserID"]); retVal.DueDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["DueDate"].ToString()); retVal.AssignmentURL = ds.Tables[0].Rows[0]["AssignmentURL"].ToString(); retVal.CommandLineArgs = ds.Tables[0].Rows[0]["CommandLineArgs"].ToString(); retVal.InputFile = ds.Tables[0].Rows[0]["InputFile"].ToString(); retVal.OutputFile = ds.Tables[0].Rows[0]["OutputFile"].ToString(); retVal.MultipleSubmitsFlag = Convert.ToBoolean(ds.Tables[0].Rows[0]["MultipleSubmitsFlag"]); retVal.AutoGradeFlag = Convert.ToBoolean(ds.Tables[0].Rows[0]["AutoGradeFlag"]); retVal.AutoCompileFlag = Convert.ToBoolean(ds.Tables[0].Rows[0]["AutoCompileFlag"]); retVal.SendReminders = Convert.ToBoolean(ds.Tables[0].Rows[0]["SendReminders"]); retVal.SendPastDue = Convert.ToBoolean(ds.Tables[0].Rows[0]["SendPastDue"]); retVal.SendNewProject = Convert.ToBoolean(ds.Tables[0].Rows[0]["SendNewProject"]); retVal.SendUpdatedProject = Convert.ToBoolean(ds.Tables[0].Rows[0]["SendUpdatedProject"]); retVal.GradeType = Convert.ToByte(ds.Tables[0].Rows[0]["GradeType"]); retVal.CourseAssignmentID = Convert.ToInt32(ds.Tables[0].Rows[0]["CourseAssignmentID"]); retVal.ReminderWarningDays = Convert.ToInt32(ds.Tables[0].Rows[0]["ReminderWarningDays"]); retVal.PastDueWarningDays = Convert.ToInt32(ds.Tables[0].Rows[0]["PastDueWarningDays"]); retVal.CourseID = Convert.ToInt32(ds.Tables[0].Rows[0]["CourseID"]); return(retVal); }
private int saveUserToDatabase(StoredProcType sprocType) { DatabaseCall dbc; int retID = 0; if (sprocType == StoredProcType.Create) { dbc = new DatabaseCall("Users_CreateNew", DBCallType.Execute); dbc.AddOutputParameter("@UserID"); } else if (sprocType == StoredProcType.Update) { dbc = new DatabaseCall("Users_UpdateExisting", DBCallType.Execute); dbc.AddParameter("@UserID", _userID); } else { throw new Exception("Unknown Stored Procedure Type"); } dbc.AddParameter("@LastName", _lastName); dbc.AddParameter("FirstName", _firstName); dbc.AddParameter("@MiddleName", _middleName); dbc.AddParameter("@Email", _emailAddress); dbc.AddParameter("@UniversityIdentifier", _universityID); dbc.AddParameter("@UserName", _username); dbc.AddParameter("@Password", _password); dbc.AddParameter("@LastUpdatedDate", _lastUpdatedDate); dbc.AddParameter("@LastUpdatedUserID", _lastUpdatedUserID); dbc.AddParameter("@ChangedPassword", _changedPassword); dbc.Execute(); if (sprocType == StoredProcType.Create) { retID = Convert.ToInt32(dbc.GetOutputParam("@UserID")); this._userID = retID; } return(retID); }
/// <summary> /// Retrieves value from Settings table /// </summary> /// <param name="settingName"> </param> internal static string GetSetting(string settingName) { try { // validate parameter if (settingName == null || settingName == String.Empty) { throw new ArgumentNullException(SharedSupport.GetLocalizedString("SharedSupport_SettingNameField"), SharedSupport.GetLocalizedString("SharedSupport_Missing_SettingName")); } if (settingName.Equals(Constants.AUTOBUILD_SETTING) || settingName.Equals(Constants.AUTOCHECK_SETTING)) { // query the status of the actual service return(getServiceStatus(Constants.ACTION_SERVICE_NAME)); } else { DatabaseCall dbc = new DatabaseCall("Settings_GetSetting", DBCallType.Select); dbc.AddParameter("@Setting", settingName); System.Data.DataSet ds = new System.Data.DataSet(); dbc.Fill(ds); try { return(ds.Tables[0].Rows[0]["Value"].ToString().Trim()); } catch { return(String.Empty); } } } catch (System.Exception e) { SharedSupport.HandleError(e); return(null); } }
public void SendNotifications(object sender, System.Timers.ElapsedEventArgs args) { // disable the timer timer.Enabled = false; try { // use Assignment Manager sysadmin email UserM amsaUser = UserM.Load(Constants.ASSIGNMENTMANAGER_SYSTEM_ADMIN_USERID); string sentByEmail = amsaUser.EmailAddress; System.Data.DataSet dsAssignmentList = new System.Data.DataSet(); DatabaseCall dbc = new DatabaseCall("Notifications_GetAssignmentList", DBCallType.Select); dbc.Fill(dsAssignmentList); if (dsAssignmentList.Tables[0].Rows.Count <= 0) { return; } for (int j = 0; j < dsAssignmentList.Tables[0].Rows.Count; j++) { int assignmentID = Convert.ToInt32(dsAssignmentList.Tables[0].Rows[j]["AssignmentID"]); // send the notifications try { ////////////////////////////////////////////////////////////////////// /// Past Due Notifications ////////////////////////////////////////////////////////////////////// System.Data.DataSet ds = new System.Data.DataSet(); dbc = new DatabaseCall("Notifications_BrowsePastDueNotifications", DBCallType.Select); dbc.AddParameter("AssignmentID", assignmentID); dbc.Fill(ds); if (ds.Tables[0].Rows.Count <= 0) { continue; } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["AssignmentID"] != DBNull.Value) { string assignName = ds.Tables[0].Rows[i]["ShortName"].ToString(); DateTime dueDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["DueDate"]); string[] AssignmentInfo = new string[] { assignName, string.Format("{0:d}", dueDate) }; string pastDueSubject = SharedSupport.GetLocalizedString("Notification_PastDueSubject", AssignmentInfo); string pastDueBody = SharedSupport.GetLocalizedString("Notification_PastDueBody", AssignmentInfo); string reminderSubject = SharedSupport.GetLocalizedString("Notification_ReminderSubject", AssignmentInfo); string reminderBody = SharedSupport.GetLocalizedString("Notification_ReminderBody", AssignmentInfo); TimeSpan difference = dueDate - DateTime.Today; if (Convert.ToBoolean(ds.Tables[0].Rows[i]["SendPastDue"]) && (difference.Days == -1 * Convert.ToInt32(ds.Tables[0].Rows[i]["PastDueWarningDays"]))) { UserM user = UserM.Load(Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"])); MessageM.SendMessage(sentByEmail, user.EmailAddress, pastDueSubject, pastDueBody); } if (Convert.ToBoolean(ds.Tables[0].Rows[i]["SendReminders"]) && (difference.Days == Convert.ToInt32(ds.Tables[0].Rows[i]["ReminderWarningDays"]))) { UserM user = UserM.Load(Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"])); MessageM.SendMessage(sentByEmail, user.EmailAddress, reminderSubject, reminderBody); } } } } catch (System.Exception ex) { SharedSupport.HandleError(ex); } } } catch (System.Exception ex) { SharedSupport.HandleError(ex); } finally { // reset the interval for the next event timer.Interval = millisecondsToMidnight(); // re-enable the timer timer.Enabled = true; } }
private int SaveAssignmentToDatabase(StoredProcType procType) { int retID = 0; DatabaseCall dbc = null; switch (procType) { case StoredProcType.New: dbc = new DatabaseCall("Assignments_AddNewAssignment", DBCallType.Execute); dbc.AddOutputParameter("@AssignmentID"); dbc.AddOutputParameter("@CourseAssignmentID"); break; case StoredProcType.Update: dbc = new DatabaseCall("Assignments_UpdateExistingAssignment", DBCallType.Execute); dbc.AddParameter("@AssignmentID", this.AssignmentID); break; default: throw new Exception("Invalid Stored Procedure"); } dbc.AddParameter("@ShortName", this.ShortName); dbc.AddNTextParameter("@Description", this.Description); dbc.AddParameter("@LastUpdatedDate", this.LastUpdatedDate); dbc.AddParameter("@LastUpdatedUserID", this.LastUpdatedUserID); dbc.AddParameter("@StarterProjectFlag", this.StarterProjectFlag); dbc.AddParameter("@MakeFile", this.MakeFile); dbc.AddParameter("@CompilerType", this.CompilerType); dbc.AddParameter("@CourseID", this.CourseID); dbc.AddParameter("@DueDate", this.DueDate); dbc.AddParameter("@MultipleSubmitsFlag", this.MultipleSubmitsFlag); dbc.AddParameter("@SendReminders", this.SendReminders); dbc.AddParameter("@AutoGradeFlag", this.AutoGradeFlag); dbc.AddParameter("@InputFile", this.InputFile); // set to either DBNull or String Valu); dbc.AddParameter("@OutputFile", this.OutputFile); // set to either DBNull or String Valu); dbc.AddParameter("@GradeType", this.GradeType); dbc.AddParameter("@AutoCompileFlag", this.AutoCompileFlag); dbc.AddParameter("@AssignmentURL", this.AssignmentURL); // set to either DBNull or String Valu); dbc.AddParameter("@CommandLineArgs", this.CommandLineArgs); dbc.AddParameter("@SendPastDue", this.SendPastDue); dbc.AddParameter("@SendNewProject", this.SendNewProject); dbc.AddParameter("@SendUpdatedProject", this.SendUpdatedProject); dbc.AddParameter("@PastDueWarningDays", this.PastDueWarningDays); dbc.AddParameter("@ReminderWarningDays", this.ReminderWarningDays); dbc.Execute(); if (procType == StoredProcType.New) { retID = Convert.ToInt32(dbc.GetOutputParam("@AssignmentID")); _courseAssignmentID = Convert.ToInt32(dbc.GetOutputParam("@CourseAssignmentID")); } return(retID); }