public void UpdateStudentLineItem(StudentLineItem sli)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "Update StudentLineItem set CompletionDate = @CompletionDate ";
SQL += "where id = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@id", sli.Id);
cmd.Parameters.AddWithValue("@CompletionDate", sli.CompletionDate);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to update Student Line Item.");
}
}
}
public void SaveStudentLineItem(StudentLineItem sli)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "INSERT INTO StudentLineItem(StudentId, CurriculaLineItemId, CompletionDate) ";
SQL += "VALUES (@StudentId, @CurriculaLineItemId, @CompletionDate); ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@StudentId", sli.StudentId);
cmd.Parameters.AddWithValue("@CurriculaLineItemId", sli.CurriculaLineItemId);
cmd.Parameters.AddWithValue("@CompletionDate", sli.CompletionDate);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to insert Student Line Item.");
}
}
}
