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()); }