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."); } } }