static public ObservableCollection <Discipline> GetDisciplines()
{
DataBase = new DisciplineContext();
DataBase.Disciplines.Load();
students = DataBase.Disciplines.Local;
return(students);
}
private void DisciplineDataShowBtn_Click(object sender, EventArgs e) // Show info about discipline
{
try
{
DisciplineID = (Nullable <int>)ResultDGV.CurrentRow.Cells["DisciplineID"].Value;
if (DisciplineID == null)
{
DisciplineDGV.Rows.Clear();
return;
}
var db = new DisciplineContext();
var DisciplineDataSource = db.Disciplines.Where(d => d.ID == DisciplineID).ToList();
DisciplineDGV.DataSource = DisciplineDataSource;
DisciplineDGV.Columns["ID"].Visible = false;
DisciplineDGV.Columns["Name"].HeaderText = "Название дисциплины"; // Localisation of tables
DisciplineDGV.Columns["Teacher"].HeaderText = "Преподаватель";
} catch (Exception ex)
{
MessageBox.Show(
ex.Message,
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
static public void DisciplineADD(Discipline discipline)
{
using (DisciplineContext db = new DisciplineContext())
{
db.Disciplines.Add(discipline);
db.SaveChanges();
}
}
private void DeleteDiscipline()
{
var Context = new DisciplineContext();
int DisciplineID;
try
{
DisciplineID = (int)DisciplineDGV.CurrentRow.Cells["ID"].Value;
}
catch (Exception e)
{
MessageBox.Show(
"Возможно вы не выбрали строку\n" +
e.Message,
"Ошибка!",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return;
}
DialogResult dialog = MessageBox.Show(
$"Вы действительно хотите удалить дисциплину?",
"Вы уверены?",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning
);
if (dialog == DialogResult.Yes)
{
var stud = Context.Disciplines.Find(DisciplineID);
if (stud != null)
{
Context.Disciplines.Attach(stud);
Context.Disciplines.Remove(stud);
Context.SaveChanges();
MessageBox.Show(
$"Удаление успешно!",
"Успех!",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
LoadData();
}
}
}
private void LoadData()
{
var query = context.Students;
var students = query.ToList();
dataGridView1.DataSource = students;
var disciplineDb = new DisciplineContext();
var disciplines = disciplineDb.Disciplines.ToList();
DisciplineDGV.DataSource = disciplines;
var adminDb = new AdministratorContext();
var admins = adminDb.Admins.ToList();
AdminsDGV.DataSource = admins;
}
public AdminForm()
{
InitializeComponent();
context = new StudentContext();
dContext = new DisciplineContext();
LoadData();
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.AllowUserToDeleteRows = true;
dataGridView1.Columns["StudentNumber"].HeaderText = "Номер зачетной книги";
dataGridView1.Columns["Name"].HeaderText = "ФИО";
dataGridView1.Columns["Gender"].HeaderText = "Пол";
dataGridView1.Columns["DateOfBirth"].HeaderText = "Дата рождения";
dataGridView1.Columns["Group"].HeaderText = "Группа";
dataGridView1.Columns["Specialty"].HeaderText = "Специальность";
dataGridView1.Columns["Faculty"].HeaderText = "Факультет";
//dataGridView1.Columns["DateOfBirth"].DefaultCellStyle.Format = "dd.MM.yyyy";
AdminsDGV.Columns["Login"].HeaderText = "Логин";
AdminsDGV.Columns["Pass"].Visible = false;
DisciplineDGV.Columns["ID"].HeaderText = "Идентификационный номер";
DisciplineDGV.Columns["Name"].HeaderText = "Название дисциплины";
DisciplineDGV.Columns["Teacher"].HeaderText = "Преподаватель";
ToolTip tooltip = new ToolTip
{
AutoPopDelay = 5000,
InitialDelay = 100,
ReshowDelay = 200
};
tooltip.SetToolTip(this.HelpBtn, "Для удаления записи, выделите ее в таблице и нажмите кнопку \"Delete\"");
}
static public void Init()
{
DataBase = new DisciplineContext();
}
static public Discipline GetDiscipline(int DisciplineID)
{
using (DisciplineContext db = new DisciplineContext())
return(db.Disciplines.Where(d => d.ID == DisciplineID).FirstOrDefault());
}
