private void DgTerms_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgTerms.SelectedIndex != -1)
{
_t = (Models._Term)dgTerms.SelectedItem;
LoadResult();
}
}
private void DgTerm_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (sender != null && dgTerm.SelectedIndex != -1)
{
_t = (Models._Term)dgTerm.SelectedItem;
ToggleDetails(true);
}
}
private void BtnRemoveTerm_Click(object sender, RoutedEventArgs e)
{
if (dgTerms.SelectedIndex != -1)
{
_t = (Models._Term)dgTerms.SelectedItem;
eClass.RemoveExamTerm(_e.ID, _t.ID);
LoadTermTable();
}
else
{
MessageBox.Show("Please select a term.", "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
/// <summary>
/// Returns an observablecollection of Term of the selected Exam
/// </summary>
/// <param name="ExamID">ID of the selected exam</param>
/// <returns></returns>
public ObservableCollection <Models._Term> GetTerms(int ExamID)
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(Globals.DbConString))
{
string query = "SELECT E.ID_TERM, T.TERM FROM tblExamTerms E JOIN tblTerms T ON T.ID = E.ID_TERM WHERE E.ID_EXAM = @id ORDER BY E.ID_TERM DESC";
using (SQLiteCommand cmd = new SQLiteCommand(query, conn))
{
cmd.Parameters.Add("@id", DbType.Int32).Value = ExamID;
conn.Open();
SQLiteDataAdapter sda = new SQLiteDataAdapter(cmd);
DataTable dtItems = new DataTable();
sda.Fill(dtItems);
cmd.ExecuteNonQuery();
var col = new ObservableCollection <Models._Term>();
if (dtItems.Rows.Count != 0)
{
foreach (DataRow row in dtItems.Rows)
{
var obj = new Models._Term()
{
ID = Convert.ToInt32(row[0]),
TERM = row[1].ToString()
};
col.Add(obj);
}
return(col);
}
return(null);
}
}
}
catch (SQLiteException ex)
{
MessageBox.Show(ex.Message, "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
}
