/// <summary> /// Gets a list of Submissions of an assignment. /// </summary> /// <param name="courseId"> ID of the course.</param> /// <returns>List of Submissions.</returns> public static SubmissionList GetItemByCourse(string courseId) { SubmissionList mySubmissionList = null; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spGetGradeGroupByCourse", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@courseID", courseId); myConnection.Open(); using (SqlDataReader myDataReader = myCommand.ExecuteReader()) { if (myDataReader.HasRows) { mySubmissionList = new SubmissionList(); while (myDataReader.Read()) { mySubmissionList.Add(FillRecordByCourse(myDataReader)); } } myDataReader.Close(); } myConnection.Close(); } return(mySubmissionList); }
/// <summary> /// Views grades. /// </summary> /// <param name="dList">Data list for submission list.</param> /// <param name="sid">Student ID.</param> /// <param name="courseId">Course ID.</param> public void ViewAssignmentGradeByStudent(DataList dList, string sid, string courseId) { DataTable dt = new DataTable(); SubmissionList submissionList = SubmissionController.GetItem(sid, courseId); DataColumn dc = new DataColumn(); dc.DataType = Type.GetType("System.String"); dc.ColumnName = "ATitle"; dt.Columns.Add(dc); DataColumn dc1 = new DataColumn(); dc1.DataType = Type.GetType("System.String"); dc1.ColumnName = "Grade"; dt.Columns.Add(dc1); DataRow dr; if (submissionList != null) { foreach (Submission sb in submissionList) { dr = dt.NewRow(); dr["ATitle"] = sb.Assignment.ATitle; dr["Grade"] = sb.Grade; dt.Rows.Add(dr); } } dList.DataSource = dt; dList.DataBind(); }
/// <summary> /// Gets a list of Submissions of an assignment by the student. /// </summary> /// <param name="sid"> Unique id of the student.</param> /// <param name="courseId">Unique id of the course.</param> /// <returns>List of Submissions.</returns> public static SubmissionList GetItem(string sid, string courseId) { SubmissionList mySubmissionList = null; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spGetGradeGroupByAssignmentForStudent", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@SID", sid); myCommand.Parameters.AddWithValue("@CourseID", courseId); myConnection.Open(); using (SqlDataReader myDataReader = myCommand.ExecuteReader()) { if (myDataReader.HasRows) { mySubmissionList = new SubmissionList(); while (myDataReader.Read()) { mySubmissionList.Add(FillRecordByStudent(myDataReader)); } } myDataReader.Close(); } myConnection.Close(); } return mySubmissionList; }
/// <summary> /// Saves a Submission in the database. /// </summary> /// <param name="mySubmissionList">The Submissionlist to store.</param> /// <returns>The new ID if the Submission is new in the database or the existing ID when an record was updated.</returns> public static int Save(SubmissionList mySubmissionList) { int result = 0; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spUpdateAssignmentSubmissionGrade", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myConnection.Open(); foreach (Submission mySubmission in mySubmissionList) { myCommand.Parameters.AddWithValue("@sid", mySubmission.Student.SId); myCommand.Parameters.AddWithValue("@assignmentID", mySubmission.Assignment.AssignmentId); myCommand.Parameters.AddWithValue("@grade", mySubmission.Grade); //DbParameter retValue = myCommand.CreateParameter(); //retValue.Direction = ParameterDirection.ReturnValue; //myCommand.Parameters.Add(retValue); myCommand.ExecuteNonQuery(); //result = Convert.ToInt32(retValue.Value); myCommand.Parameters.Clear(); } myConnection.Close(); } return(result); }
private bool DoSelect(out string formID) { Program.ConnectToService(); submissionListBindingSource.DataSource = SubmissionList.FindAll(); var hasSelected = ShowDialog(Program.MainForm) == DialogResult.OK; formID = hasSelected ? ((SubmissionList)submissionListBindingSource.Current).URI : null; return(hasSelected); }
protected void btnSave_Click(object sender, EventArgs e) { SubmissionList slist = new SubmissionList(); foreach (DataListItem item in dlGradeAssignmentByInstructor.Items) { Submission s = new Submission(); s.Student.SId = ((Label)item.FindControl("lblStudentID")).Text; s.Grade = Convert.ToDecimal(((TextBox)item.FindControl("txtBoxGrade")).Text); s.Assignment.AssignmentId = assignmentId; slist.Add(s); } SubmissionController.Save(slist); slist.Clear(); Response.Redirect("~/Presentation/formAssignment.aspx"); }
public async Task OnGetAsync(int?id) { CurrentProfile = await profileDbContext.Profiles.SingleOrDefaultAsync(m => m.ID == 1); ID = (int)id; var tempList = await submissionDbContext.Submissions.ToListAsync(); foreach (var submission in tempList) { if (submission.AssignmentID == ID) { SubmissionList.Add(submission); } } SubmissionList.OrderBy(m => m.DateTime); }
/// <summary> /// Views grades. /// </summary> /// <param name="dList">Data list for submission list.</param> /// <param name="sid">Student ID.</param> /// <param name="courseId">Course ID.</param> public void ViewAssignmentGradeByStudent(DataList dList, string courseId) { DataTable dt = new DataTable(); SubmissionList submissionList = SubmissionController.GetItemByCourse(courseId); DataColumn dc = new DataColumn(); dc.DataType = Type.GetType("System.String"); dc.ColumnName = "StudentName"; dt.Columns.Add(dc); DataColumn dc1 = new DataColumn(); dc1.DataType = Type.GetType("System.String"); dc1.ColumnName = "AggregateGrade"; dt.Columns.Add(dc1); DataColumn dc2 = new DataColumn(); dc2.DataType = Type.GetType("System.String"); dc2.ColumnName = "StudentID"; dt.Columns.Add(dc2); DataRow dr; if (submissionList != null) { foreach (Submission sb in submissionList) { dr = dt.NewRow(); dr["StudentID"] = sb.Student.SId; dr["AggregateGrade"] = sb.Grade.ToString(".00"); dr["StudentName"] = sb.Student.FullName; dt.Rows.Add(dr); } } dList.DataSource = dt; dList.DataBind(); }
/// <summary> /// Saves a Submission in the database. /// </summary> /// <param name="mySubmissionList">The Submissionlist to store.</param> /// <returns>The new ID if the Submission is new in the database or the existing ID when an record was updated.</returns> public static int Save(SubmissionList mySubmissionList) { return(SubmissionDA.Save(mySubmissionList)); }
/// <summary> /// Gets a list of Submissions of an assignment. /// </summary> /// <param name="assignmentId"> ID of an assignment.</param> /// <returns>List of Submissions.</returns> public static SubmissionList GetItem(int assignmentId) { SubmissionList mySubmissionList = null; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spGetSubmissionAssignmentByAssignment", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@assignmentID", assignmentId); myConnection.Open(); using (SqlDataReader myDataReader = myCommand.ExecuteReader()) { if (myDataReader.HasRows) { mySubmissionList = new SubmissionList(); while (myDataReader.Read()) { mySubmissionList.Add(FillRecord(myDataReader)); } } myDataReader.Close(); } myConnection.Close(); } return mySubmissionList; }
/// <summary> /// Saves a Submission in the database. /// </summary> /// <param name="mySubmissionList">The Submissionlist to store.</param> /// <returns>The new ID if the Submission is new in the database or the existing ID when an record was updated.</returns> public static int Save(SubmissionList mySubmissionList) { int result = 0; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spUpdateAssignmentSubmissionGrade", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myConnection.Open(); foreach (Submission mySubmission in mySubmissionList) { myCommand.Parameters.AddWithValue("@sid", mySubmission.Student.SId); myCommand.Parameters.AddWithValue("@assignmentID", mySubmission.Assignment.AssignmentId); myCommand.Parameters.AddWithValue("@grade", mySubmission.Grade); //DbParameter retValue = myCommand.CreateParameter(); //retValue.Direction = ParameterDirection.ReturnValue; //myCommand.Parameters.Add(retValue); myCommand.ExecuteNonQuery(); //result = Convert.ToInt32(retValue.Value); myCommand.Parameters.Clear(); } myConnection.Close(); } return result; }
public IActionResult SubmissionForm(Submission rSubmit) { SubmissionList.addSubmission(rSubmit); return(View()); }
protected void btnSave_Click(object sender, EventArgs e) { SubmissionList slist = new SubmissionList(); foreach (DataListItem item in dlGradeAssignmentByInstructor.Items) { Submission s = new Submission(); s.Student.SId = ((Label) item.FindControl("lblStudentID")).Text; s.Grade = Convert.ToDecimal(((TextBox) item.FindControl("txtBoxGrade")).Text); s.Assignment.AssignmentId = assignmentId; slist.Add(s); } SubmissionController.Save(slist); slist.Clear(); Response.Redirect("~/Presentation/formAssignment.aspx"); }
/// <summary> /// Saves a Submission in the database. /// </summary> /// <param name="mySubmissionList">The Submissionlist to store.</param> /// <returns>The new ID if the Submission is new in the database or the existing ID when an record was updated.</returns> public static int Save(SubmissionList mySubmissionList) { return SubmissionDA.Save(mySubmissionList); }