private void BtnAddCourse_Click(object sender, EventArgs e)
{
AddEditDocument frm = new AddEditDocument(k);
frm.BtnEditDoc.Enabled = false;
frm.Show();
this.Hide();
}
private void BtnEditDoc_Click(object sender, EventArgs e)
{
//Редактирование данных о документе
AddEditDocument frm = new AddEditDocument(p);
//Передача данных о документе на форму редактирования
using (SqlConnection connecting = new SqlConnection(Program.connection))
{
connecting.Open();
// Данные из таблицы Документы
SqlCommand typedoc = connecting.CreateCommand();
typedoc.CommandText = "SELECT TypeDoc FROM [Documents] WHERE ID= " + p;
typedoc.ExecuteScalar();
SqlCommand group = connecting.CreateCommand();
group.CommandText = "SELECT [Group] FROM [Documents] WHERE ID= " + p;
group.ExecuteScalar();
SqlCommand idstudent = connecting.CreateCommand();
idstudent.CommandText = "SELECT IdStudent FROM [Documents] WHERE ID= " + p;
idstudent.ExecuteScalar();
SqlCommand statusdoc = connecting.CreateCommand();
statusdoc.CommandText = "SELECT StatusDoc FROM [Documents] WHERE ID= " + p;
statusdoc.ExecuteScalar();
SqlCommand utrata = connecting.CreateCommand();
utrata.CommandText = "SELECT Utrata FROM [Documents] WHERE ID= " + p;
utrata.ExecuteScalar();
SqlCommand obmen = connecting.CreateCommand();
obmen.CommandText = "SELECT Obmen FROM [Documents] WHERE ID= " + p;
obmen.ExecuteScalar();
SqlCommand unichtog = connecting.CreateCommand();
unichtog.CommandText = "SELECT Unichtog FROM [Documents] WHERE ID= " + p;
unichtog.ExecuteScalar();
SqlCommand seriesdoc = connecting.CreateCommand();
seriesdoc.CommandText = "SELECT SeriesDoc FROM [Documents] WHERE ID= " + p;
seriesdoc.ExecuteScalar();
SqlCommand numberdoc = connecting.CreateCommand();
numberdoc.CommandText = "SELECT NumberDoc FROM [Documents] WHERE ID= " + p;
numberdoc.ExecuteScalar();
SqlCommand regnumber = connecting.CreateCommand();
regnumber.CommandText = "SELECT RegNumber FROM [Documents] WHERE ID= " + p;
regnumber.ExecuteScalar();
//Заполнение полей на форме редактирования данных о студенте
frm.CbTypeDoc.Text = Convert.ToString(typedoc.ExecuteScalar());
frm.CbUtrata.Text = Convert.ToString(utrata.ExecuteScalar());
frm.CbUnichtog.Text = Convert.ToString(unichtog.ExecuteScalar());
frm.TbRegNumber.Text = Convert.ToString(regnumber.ExecuteScalar());
frm.CbGroup.Text = Convert.ToString(group.ExecuteScalar());
frm.TbStudent.Text = Convert.ToString(idstudent.ExecuteScalar());
frm.CbStatusDoc.Text = Convert.ToString(statusdoc.ExecuteScalar());
frm.CbObmen.Text = Convert.ToString(obmen.ExecuteScalar());
frm.TbSeriesDoc.Text = Convert.ToString(seriesdoc.ExecuteScalar());
frm.TbNumberDoc.Text = Convert.ToString(numberdoc.ExecuteScalar());
frm.BtnEditDoc.Enabled = true;
frm.BtnAddDoc.Enabled = false;
frm.Show();
this.Hide();
connecting.Close();
}
}
