/// <summary>
/// Ustala który panel do edycji opiekuna ma być dostępny
/// </summary>
/// <param name="panelType"></param>
private void ShowAdequatePanel(string panelType)
{
switch (panelType)
{
case "Add":
panelAdd.Enabled = true;
this.Text = "Add Keeper";
break;
case "Update":
panelUpdateKeeper.Enabled = true;
this.Text = "Update Keeper";
DataBaseQueries.SelectAll(sqlConnection, dataGridViewUpdateKeeper, "Opiekun");
break;
default:
panelDeleteKeeper.Enabled = true;
this.Text = "Delete Keeper";
DataBaseQueries.SelectAll(sqlConnection, dataGridViewDeleteKeeper, "Opiekun");
break;
}
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli Plan_lekcji
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonLessonPlan_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "Plan_lekcji");
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli Opiekun
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonKeepers_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "Opiekun");
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli Ocena
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonGrades_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "Ocena");
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli Nauczyciel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonTeachers_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "Nauczyciel");
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli Komentarz
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonComments_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "Komentarz");
}
/// <summary>
/// Przycisk wyświetląjacy zawartość tabeli adres_zamieszkania
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonAddress_Click(object sender, EventArgs e)
{
DataBaseQueries.SelectAll(sqlConnection, dataGridViewSchoolDiary, "adres_zamieszkania");
}
