help
Root Question Message
public List<CompletedAssignment> GetCompletedAssignments(int studentID, int assignmentID)
{
List<CompletedAssignment> completedAssignments = new List<CompletedAssignment>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "SELECT StudentID, AssignmentID, EarnedPoints FROM CompletedAssignments WHERE StudentID = @StudentID AND AssignmentID = @AssignmentID";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@StudentID", studentID);
command.Parameters.AddWithValue("@AssignmentID", assignmentID);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
CompletedAssignment completedAssignment = new CompletedAssignment();
completedAssignment.StudentID = reader.GetInt32(0);
completedAssignment.AssignmentID = reader.GetInt32(1);
completedAssignment.EarnedPoints = reader.GetInt32(2);
completedAssignments.Add(completedAssignment);
}
}
}
return completedAssignments;
}
private void UpdateTextBoxes()
{
if (comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
{
return;
}
Student student = (Student)comboBox1.SelectedItem;
Assignment assignment = (Assignment)comboBox2.SelectedItem;
string completedAssignment = dbManager.GetCompletedAssignments(assignment.AssignmentID, student.StudentID).ToString();
textBox1.Text = completedAssignment;
textBox2.Text = assignment.TotalPoints.ToString();
}
private void UpdateTextBoxes()
{
if (comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
{
return;
}
Student student = (Student)comboBox1.SelectedItem;
Assignment assignment = (Assignment)comboBox2.SelectedItem;
List<CompletedAssignment> completedAssignment = dbManager.GetCompletedAssignments(assignment.AssignmentID, student.StudentID);
textBox1.Text = completedAssignment.EarnedPoints.ToString();
textBox2.Text = assignment.TotalPoints.ToString();
}
}
}
`CompletedAssignment
sEarnedPoints
GetCompletedAssignments
wrong