private void AddStudent_Load(object sender, EventArgs e)
{
grups = new Grups();
grups.OpenConnection(connectionString);
comboBox_Grups.Items.AddRange(grups.GetAllGrups());
grups.CloseConnection();
}
public DeleteGrup()
{
InitializeComponent();
connectionString = ConfigurationManager.AppSettings["connectionString"];
grups = new Grups();
grups.OpenConnection(connectionString);
this.comboBox_Grups.Items.AddRange(grups.GetAllGrups());
grups.CloseConnection();
}
public EnterMarks(int id)
{
InitializeComponent();
this.id = id;
connectionString = ConfigurationManager.AppSettings["connectionString"];
Predmets pr = new Predmets();
pr.OpenConnection(connectionString);
comboBox_Predmet.Items.AddRange(pr.GetPredmetsByPrepodId(id));
pr.CloseConnection();
Grups g = new Grups();
g.OpenConnection(connectionString);
comboBox_Group.Items.AddRange(g.GetAllGrups());
g.CloseConnection();
}
private void button_Add_Click(object sender, EventArgs e)
{
string name = textBox_Name.Text;
try
{
Grups grups = new Grups();
grups.OpenConnection(connectionString);
grups.InsertGrups(name);
grups.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
MessageBox.Show("Группа была успешно добавлена!");
this.Close();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Grups g = new Grups();
g.OpenConnection(connectionString);
int idgr = g.GetIdByNzach(nzach);
g.CloseConnection();
Predmets p = new Predmets();
p.OpenConnection(connectionString);
int idprd = p.GetIdByName(comboBox1.Text);
p.CloseConnection();
Marks m = new Marks();
m.OpenConnection(connectionString);
dataGridView1.DataSource = m.GetMarksByGroupAndPredmet(idgr, idprd);
m.CloseConnection();
}
