protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
//List<StCr> stdCrs; //List<InsCr> insCrs; private void CoursesForm_Load(object sender, EventArgs e) { this.FormClosed += (sender, e) => { ctxAllCourses.Dispose(); ctx.Dispose(); }; ctxAllCourses.Courses.Load(); gridAllCourses.DataSource = ctxAllCourses.Courses.Local.ToBindingList(); gridAllCourses.Columns["Exams"].Visible = false; gridAllCourses.Columns["InsCrs"].Visible = false; gridAllCourses.Columns["Questions"].Visible = false; gridAllCourses.Columns["CrsId"].Visible = false; using (ExamContext ctx = new ExamContext()) { ctx.Courses.Load(); ctx.Students.Load(); ctx.Instructors.Load(); //ctx.StCrs.Load(); //ctx.InsCrs.Load(); students = ctx.Students.Local.ToList(); instructors = ctx.Instructors.Local.ToList(); courses = ctx.Courses.Local.ToList(); //stdCrs = ctx.StCrs.Local.ToList(); //insCrs = ctx.InsCrs.Local.ToList(); } //cmbStd.DataSource = ctx.Students.Local.ToList(); cmbStd.DataSource = students; cmbStd.DisplayMember = "StName"; cmbStd.ValueMember = "StId"; cmbStd.SelectedIndex = 0; cmbCourse.DataSource = courses; cmbCourse.ValueMember = "CrsId"; cmbCourse.DisplayMember = "CrsName"; cmbCourse.SelectedIndex = 0; cmbInstructor.DataSource = instructors; cmbInstructor.DisplayMember = "InsName"; cmbInstructor.ValueMember = "InsId"; cmbInstructor.SelectedIndex = 0; cmbInsCourses.DataSource = courses; cmbInsCourses.ValueMember = "CrsId"; cmbInsCourses.DisplayMember = "CrsName"; cmbInsCourses.SelectedIndex = 0; }
private void InstructorsForm_Load(object sender, EventArgs e) { this.FormClosed += (sender, e) => { ctx.Dispose(); }; ctx.Instructors.Load(); ctx.Departments.Load(); stdList = ctx.Instructors.Local.ToBindingList(); deptList = ctx.Departments.Local.ToBindingList(); stdBinding = new BindingSource(stdList, ""); deptBinding = new BindingSource(deptList, ""); //public int InsId { get; set; } //public string InsName { get; set; } //public string InsEmail { get; set; } //public string InsHashedPwd { get; set; } //public int DeptId { get; set; } //public virtual Department Dept { get; set; } //public virtual ICollection<Department> Departments { get; set; } //public virtual ICollection<InsCr> InsCrs { get; set; } // we should add first datasource on grid grid.DataSource = stdBinding; grid.Columns["InsId"].Visible = false; grid.Columns["InsHashedPwd"].Visible = false; grid.Columns["Dept"].Visible = false; //grid.Columns["Departments"].Visible = false; grid.Columns["InsCrs"].Visible = false; grid.Columns.AddRange(DC); DC.DataSource = deptBinding; DC.HeaderText = "Departments"; DC.DisplayMember = "DeptName"; DC.ValueMember = "DeptId"; DC.DataPropertyName = "DeptId"; stdBinding.AddingNew += (sender, e) => { e.NewObject = new Instructor() { DeptId = deptList.FirstOrDefault().DeptId, }; }; }
protected virtual void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { _context.Dispose(); } } this.disposed = true; }
private void DepartmentsForm_Load(object sender, EventArgs e) { this.FormClosed += (sender, e) => { ctx.Dispose(); }; ctx.Departments.Load(); ctx.Instructors.Load(); deptList = ctx.Departments.Local.ToBindingList(); stdList = ctx.Instructors.Local.ToBindingList(); deptBinding = new BindingSource(deptList, ""); stdBinding = new BindingSource(stdList, ""); // we should add first datasource on grid grid.DataSource = deptBinding; //grid.Columns["DeptId"].Visible = false; grid.Columns["Mgr"].Visible = false; grid.Columns["MgrId"].Visible = false; grid.Columns["DeptId"].Visible = false; grid.Columns["Instructors"].Visible = false; //grid.Columns["Departments"].Visible = false; grid.Columns["Students"].Visible = false; // public int DeptId { get; set; } //public string DeptName { get; set; } //public int? MgrId { get; set; } //public virtual Instructor Mgr { get; set; } //public virtual ICollection<Instructor> Instructors { get; set; } //public virtual ICollection<Student> Students { get; set; } grid.Columns.AddRange(DC); DC.DataSource = stdBinding; DC.HeaderText = "Manager"; DC.DisplayMember = "InsName"; DC.ValueMember = "InsId"; DC.DataPropertyName = "MgrId"; stdBinding.AddingNew += (sender, e) => { e.NewObject = new Department() { }; }; }
public void Dispose() { _context.Dispose(); }
private void StudentsForm_Load(object sender, EventArgs e) { this.FormClosed += (sender, e) => { ctx.Dispose(); }; ctx.Students.Load(); ctx.Departments.Load(); stdList = ctx.Students.Local.ToBindingList(); deptList = ctx.Departments.Local.ToBindingList(); stdBinding = new BindingSource(stdList, ""); deptBinding = new BindingSource(deptList, ""); grid.DataSource = stdBinding; //public int StId { get; set; } //public int Ssn { get; set; } //public string StName { get; set; } //public DateTime BirthDate { get; set; } //public string StEmail { get; set; } //public string StHashedPwd { get; set; } //public int DeptId { get; set; } //public virtual Department Dept { get; set; } //public virtual ICollection<Exam> Exams { get; set; } //public virtual ICollection<StCr> StCrs { get; set; } grid.Columns["StId"].Visible = false; grid.Columns["StHashedPwd"].Visible = false; grid.Columns["Exams"].Visible = false; grid.Columns["StCrs"].Visible = false; grid.Columns["Dept"].Visible = false; // public int DeptId { get; set; } //public string DeptName { get; set; } DC.HeaderText = "Departments"; // must be moved from here not to add again when reload grid.Columns.AddRange(DC); //DC.DataSource = pubList; DC.DataSource = deptBinding; DC.DisplayMember = "DeptName"; DC.ValueMember = "DeptId"; DC.DataPropertyName = "DeptId"; stdBinding.AddingNew += (sender, e) => { e.NewObject = new Student() { DeptId = deptList.FirstOrDefault()?.DeptId ?? 0, }; }; }
public void Dispose() { dataContext.Dispose(); }