public Admin(string id)
{
InitializeComponent();
//Получаем имя позователя для приветствия
salutationLabel.Text = DBGate.GetSalutation(Properties.Settings.Default.ConnectionString, id);
Users users = new Users {
Dock = DockStyle.Fill
};
usersTab.Controls.Add(users);
Students students = new Students {
Dock = DockStyle.Fill
};
studentsTab.Controls.Add(students);
Teachers teachers = new Teachers {
Dock = DockStyle.Fill
};
teachersTab.Controls.Add(teachers);
Reports reports = new Reports(id)
{
Dock = DockStyle.Fill
};
reportsTab.Controls.Add(reports);
}
private void Start()
{
salutationLabel.Text = DBGate.GetSalutation(Properties.Settings.Default.ConnectionString, id);
UserControls.Reports reports = new UserControls.Reports(id);
reports.Dock = DockStyle.Fill;
this.Controls["panel1"].Controls.Add(reports);
}
public Teacher(string id)
{
InitializeComponent();
//Получаем имя позователя для приветствия
salutationLabel.Text = DBGate.GetSalutation(Properties.Settings.Default.ConnectionString, id);
Students students = new Students {
Dock = DockStyle.Fill
};
string yearID = DBGate.Scalar(Properties.Settings.Default.ConnectionString, $"select yearID from Teachers where userID = {id}");
string classID = DBGate.Scalar(Properties.Settings.Default.ConnectionString, $"select classID from Teachers where userID = {id}");
students.query =
"select ID as 'ID', " +
"name as 'Имя', " +
"birth as 'Дата рождения', " +
"year as 'Год обучения', " +
"(select name from Classes where Classes.ID = Students.class) as 'Класс', " +
"paySumm as 'Задолженность', " +
"activeFlag as 'Питание' " +
"from Students " +
$"where year = {yearID} and class = {classID}";
students.Controls["panel4"].Controls["addUser"].Enabled = false;
students.Controls["panel1"].Controls["deleteStudent"].Enabled = false;
students.Start();
ClassPage.Controls.Add(students);
}
