/// <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);
}
