// Save student private void button1_Click(object sender, EventArgs e) { using (var db = new AcademyDB()) { if (isValid()) { Group group = comboBox2.SelectedItem as Group; Task task = new Task() { Name = textBox1.Text, Dedline = dateTimePicker2.Value, GroupID = group.id, Deleted = false, }; db.Task.Add(task); if (db.SaveChanges() != 0) { MessageBox.Show("Task added"); ClearInputs(); } else { MessageBox.Show("Error: Task did not added"); } } } }
//Selected classroom statistic private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { string groupInCls = ""; string selectedCls = ""; int studentCount = 0; if (e.RowIndex != -1 && e.RowIndex != dataGridView1.Rows.Count - 1) { int clsID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); using (var db = new AcademyDB()) { Classroom cls = db.Classroom.FirstOrDefault(c => c.id == clsID); Group group = db.Group.FirstOrDefault(g => g.ClassroomID == clsID); selectedCls = cls.Name; if (group != null) { studentCount = db.Student.Where(s => s.GroupID == group.id).Count(); groupInCls = " ( Group: " + group.Name + " Students: " + studentCount + " )"; } else { groupInCls = " ( Empty )"; } lblSelectedClassRoom.Text = selectedCls + groupInCls; } } }
// Updating Task from datagridView private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (formLoaded && e.RowIndex != dataGridView1.Rows.Count - 1) { int taskID = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; using (var db = new AcademyDB()) { if (CheckRow(e.RowIndex)) // checking cells validation { Model.Task task = db.Task.Where(t => t.id == taskID).FirstOrDefault(); task.Name = row.Cells[1].Value.ToString(); task.Dedline = Convert.ToDateTime(row.Cells[2].Value); task.GroupID = (int)row.Cells[3].Value; if (db.SaveChanges() != 0) { MessageBox.Show("Task updated"); fillGrid(db.Task.ToList()); } else { MessageBox.Show("Warning: Task did not updated!"); } } } } }
// Updating Group from datagridView private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (formLoaded && e.RowIndex != dataGridView1.Rows.Count - 1) { int groupID = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; using (var db = new AcademyDB()) { if (CheckRow(e.RowIndex)) // checking cells validation { Group grp = db.Group.FirstOrDefault(gr => gr.id == groupID); grp.Name = row.Cells[1].Value.ToString(); grp.ClassroomID = Convert.ToInt32(row.Cells[2].Value); grp.TeacherID = Convert.ToInt32(row.Cells[3].Value); grp.MentorID = Convert.ToInt32(row.Cells[4].Value); grp.Capacity = Convert.ToInt32(row.Cells[5].Value); grp.ProgramID = Convert.ToInt32(row.Cells[6].Value); if (db.SaveChanges() != 0) { fillGrid(db.Group.Where(gr => gr.Deleted == false).ToList()); dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.FromArgb(224, 255, 224); } else { MessageBox.Show("Error: Student is not updated!"); } } } } }
// Updating Student from datagridView private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (formLoaded && e.RowIndex != dataGridView1.Rows.Count - 1) { int stdID = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; using (var db = new AcademyDB()) { if (CheckRow(e.RowIndex)) // checking cells validation { Student std = db.Student.Where(s => s.id == stdID).FirstOrDefault(); std.Name = row.Cells[1].Value.ToString(); std.Surname = row.Cells[2].Value.ToString(); std.Email = row.Cells[3].Value.ToString(); std.Phone = row.Cells[4].Value.ToString(); std.Fee = Convert.ToDouble(row.Cells[5].Value); std.GroupID = Convert.ToInt32(row.Cells[6].Value); std.StartDate = Convert.ToDateTime(row.Cells[7].Value); if (db.SaveChanges() != 0) { fillGrid(db.Student.ToList()); dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.FromArgb(224, 255, 224); } else { MessageBox.Show("Error: Student is not updated!"); } } } } }
public void FormRefresh() { using (var db = new AcademyDB()) { fillgrid(db.Students.ToList()); } }
private void Button2_Click(object sender, EventArgs e) { using (var db = new AcademyDB()) { Task task = db.Tasks.Where(t => t.id == selectedtaskId).FirstOrDefault(); Group group = comboBox1.SelectedItem as Group; task.Name = textBox1.Text; task.Dedline = dateTimePicker1.Value; task.GroupID = group.id; if (db.SaveChanges() != 0) { MessageBox.Show("Task updated"); FormRefresh(); } else { MessageBox.Show("Task didn't update!"); } } }
// Updating Program from datagridView private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (formLoaded && e.RowIndex != dataGridView1.Rows.Count - 1) { int progID = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; using (var db = new AcademyDB()) { if (CheckRow(e.RowIndex)) // checking cells validation { Model.Program prog = db.Program.FirstOrDefault(c => c.id == progID); prog.Name = row.Cells[1].Value.ToString(); prog.Price = Convert.ToInt32(row.Cells[2].Value); prog.Period = Convert.ToInt32(row.Cells[3].Value); if (db.SaveChanges() != 0) { fillGrid(db.Program.ToList()); dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.FromArgb(224, 255, 224); } else { MessageBox.Show("Warning: Program did not updated!"); } } } } }
private void Btnsave_Click(object sender, EventArgs e) { Group grp = new Group(); Model.Classroom cls = comboBox1.SelectedItem as Model.Classroom; Employee empl1 = comboBox2.SelectedItem as Employee; Employee empl2 = comboBox3.SelectedItem as Employee; Model.Program pr = comboBox4.SelectedItem as Model.Program; grp.Name = textBox1.Text; grp.ClassroomID = cls.id; grp.TeacherID = empl1.id; grp.MentorID = empl2.id; grp.Capacity = Convert.ToInt32(textBox2.Text); grp.ProgramID = pr.id; grp.Deleted = false; using (var db = new AcademyDB()) { db.Groups.Add(grp); if (db.SaveChanges() != 0) { MessageBox.Show("Group added"); FormRefresh(); } else { MessageBox.Show("Group didn't add.Fill all inputs!"); } } }
// Fill grid Method public void fillGrid(List <Position> list) { dataGridView1.Rows.Clear(); getStatistic(); using (var db = new AcademyDB()) { foreach (Position pos in list) { if (pos.Deleted == false) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = pos.id; row.Cells[1].Value = pos.Name; // if no one in this position than set orange color Employee emp = db.Employee.FirstOrDefault(em => em.PositionID == pos.id); if (emp == null) { row.DefaultCellStyle.BackColor = Color.FromArgb(241, 196, 15); } else { row.DefaultCellStyle.BackColor = Color.White; } dataGridView1.Rows.Add(row); } } } }
// Search only width evaluations private void checkBox3_CheckedChanged(object sender, EventArgs e) { checkBox4.Checked = false; checkBox4.Enabled = false; if (checkBox3.Checked == true) { Task currentTask = comboBox1.SelectedItem as Task; List <Student> PointList = new List <Student>(); using (var db = new AcademyDB()) { foreach (Student student in SearchList) { Exam exam = db.Exam.FirstOrDefault(ex => ex.StudentID == student.id && ex.TaskID == currentTask.id); if (exam != null) { PointList.Add(student); } } } fillSearchList(PointList); } else { checkBox4.Enabled = true; fillSearchList(SearchList); } }
//adding private void Btnadd_Click(object sender, EventArgs e) { Employee employee = new Employee(); Position posid = comboBox1.SelectedItem as Position; Model.Program program = comboBox2.SelectedItem as Model.Program; employee.Name = textBox1.Text; employee.Surname = textBox2.Text; employee.SpecialityID = program.id; employee.Email = textBox4.Text; employee.Phone = textBox5.Text; employee.StartTime = dateTimePicker1.Value; employee.Salary = Convert.ToDouble(textBox6.Text); employee.PositionID = posid.id; employee.Deleted = false; using (var db = new AcademyDB()) { db.Employees.Add(employee); if (db.SaveChanges() != 0) { MessageBox.Show("Employee added"); FormRefresh(); } else { MessageBox.Show("Employee didn't add.Fill all inputs!"); } } }
public void FormRefresh() { using (var db = new AcademyDB()) { fillgrid(db.Classrooms.ToList()); } }
public void FormRefresh() { using (var db = new AcademyDB()) { fillgrid(db.Employees.ToList()); } }
private void Button1_Click(object sender, EventArgs e) { using (var db = new AcademyDB()) { Employee employee = db.Employees.Where(emp => emp.id == selectedemployerId).FirstOrDefault(); Model.Program program = comboBox2.SelectedItem as Model.Program; Position position = comboBox1.SelectedItem as Position; employee.Name = textBox1.Text; employee.Surname = textBox2.Text; employee.Email = textBox4.Text; employee.Phone = textBox5.Text; employee.SpecialityID = program.id; employee.StartTime = dateTimePicker1.Value; employee.Salary = Convert.ToDouble(textBox6.Text); employee.PositionID = position.id; if (db.SaveChanges() != 0) { MessageBox.Show("Employee updated"); FormRefresh(); } else { MessageBox.Show("Employee didn't update!"); } } }
// When selecting program fill teacher private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { List <Employee> TeacherList = new List <Employee>(); Model.Program program = comboBox1.SelectedItem as Model.Program; if (formLoaded && comboBox1.SelectedIndex != -1) { using (var db = new AcademyDB()) { foreach (Employee employee in db.Employee.ToList()) { // get only Free Teachers from employers Group grup = db.Group.FirstOrDefault(gr => gr.TeacherID == employee.id); if (grup == null && employee.SpecialityID == program.id) { TeacherList.Add(employee); } } comboBox2.DataSource = null; comboBox2.DataSource = TeacherList; comboBox2.DisplayMember = "Name"; comboBox2.ValueMember = "id"; } } comboBox2.Enabled = true; }
// DatagridView Delete Button Click private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; // if column is Delete button column if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0 && e.RowIndex != dataGridView1.Rows.Count - 1) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; DialogResult result = MessageBox.Show(row.Cells[1].Value + " " + row.Cells[2].Value, "Are you sure to delete?", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { using (var db = new AcademyDB()) { int stdID = (int)row.Cells[0].Value; Student std = db.Student.Where(s => s.id == stdID).FirstOrDefault(); std.Deleted = true; if (db.SaveChanges() != 0) { //Control frm = new Controls.Notification(row.Cells[2].Value + " " + row.Cells[3].Value + " Deleted", "success"); //GridPanel.Controls.Add(frm); MessageBox.Show("Deleted"); fillGrid(db.Student.ToList()); } else { MessageBox.Show("Error"); } } } } }
// Get Statistic public void getStatistic() { using (var db = new AcademyDB()) { int empCount = 0; int freeTeacher = 0; lblEmployers.Text = db.Employee.Where(em => em.Deleted == false).Count().ToString(); foreach (Employee emp in db.Employee.Where(em => em.Deleted == false).ToList()) { Group grp = db.Group.FirstOrDefault(gr => gr.Deleted == false && gr.TeacherID == emp.id); if (grp == null && emp.SpecialityID != null) { freeTeacher++; } } lblFreeTeacher.Text = freeTeacher.ToString(); if (comboBox1.SelectedIndex != -1) { Position pos = comboBox1.SelectedItem as Position; empCount = db.Employee.Where(emp => emp.PositionID == pos.id && emp.Deleted == false).Count(); lblSelectedPosition.Text = pos.Name + " ( " + empCount + " employers )"; } } }
public void fillgrid(List <Student> list) { dataGridView1.Rows.Clear(); using (var db = new AcademyDB()) { foreach (Student st in list) { if (st.Deleted == false && st.GroupID != null) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = st.id.ToString(); row.Cells[1].Value = st.Name; row.Cells[2].Value = st.Surname; row.Cells[3].Value = st.Email; row.Cells[4].Value = st.Phone; row.Cells[5].Value = st.Fee; row.Cells[6].Value = st.Group.Name; row.Cells[7].Value = st.StartDate; dataGridView1.Rows.Add(row); } } comboBox1.DataSource = db.Groups.ToList(); comboBox1.DisplayMember = "Name"; comboBox1.ValueMember = "id"; } }
// When selecting position filtering grid private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (formLoaded && comboBox1.SelectedIndex != -1) { getStatistic(); using (var db = new AcademyDB()) { Position position = comboBox1.SelectedItem as Position; fillGrid(db.Employee.Where(emp => emp.PositionID == position.id).ToList()); if (position.Name == "Teacher") { comboBox2.Enabled = true; comboBox2.DataSource = db.Program.Where(p => p.Deleted == false).ToList(); comboBox2.DisplayMember = "Name"; comboBox2.ValueMember = "id"; comboBox2.SelectedIndex = -1; } else { comboBox2.DataSource = null; comboBox2.SelectedIndex = -1; comboBox2.Enabled = false; } } } }
// Refresh form public void refreshForm() { using (var db = new AcademyDB()) { fillGrid(db.Program.ToList()); } }
private void Button2_Click(object sender, EventArgs e) { Student st = new Student(); Group grp = comboBox1.SelectedItem as Group; st.Name = textBox1.Text; st.Surname = textBox2.Text; st.Email = textBox3.Text; st.Phone = textBox4.Text; st.Fee = Convert.ToDouble(textBox5.Text); st.GroupID = grp.id; st.StartDate = dateTimePicker1.Value; st.Deleted = false; using (var db = new AcademyDB()) { db.Students.Add(st); if (db.SaveChanges() != 0) { MessageBox.Show("Student added"); FormRefresh(); } else { MessageBox.Show("Student didn't add.Fill all inputs!"); } } }
private void Btnupdate_Click(object sender, EventArgs e) { using (var db = new AcademyDB()) { Group group = db.Groups.Where(std => std.id == selectgrpId).FirstOrDefault(); Group st = new Group(); Model.Classroom cls = comboBox1.SelectedItem as Model.Classroom; Employee empl1 = comboBox2.SelectedItem as Employee; Employee empl2 = comboBox3.SelectedItem as Employee; Model.Program pr = comboBox4.SelectedItem as Model.Program; group.Name = textBox1.Text; group.ClassroomID = cls.id; group.TeacherID = empl1.id; group.MentorID = empl2.id; group.Capacity = Convert.ToInt32(textBox2.Text); group.ProgramID = pr.id; if (db.SaveChanges() != 0) { MessageBox.Show("Group updated"); FormRefresh(); } else { MessageBox.Show("Group didn't update!"); } } }
// Updating Classroom from datagridView private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (formLoaded && e.RowIndex != dataGridView1.Rows.Count - 1) { int clsID = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; using (var db = new AcademyDB()) { if (CheckRow(e.RowIndex)) // checking cells validation { Classroom cls = db.Classroom.FirstOrDefault(c => c.id == clsID); cls.Name = row.Cells[1].Value.ToString(); cls.Capacity = Convert.ToInt32(row.Cells[2].Value); if (db.SaveChanges() != 0) { fillGrid(db.Classroom.ToList()); dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.FromArgb(224, 255, 224); } else { MessageBox.Show("Error: Student is not updated!"); } } } } }
private void Button3_Click(object sender, EventArgs e) { using (var db = new AcademyDB()) { Student student = db.Students.Where(std => std.id == selectstudentId).FirstOrDefault(); Student st = new Student(); Group grp = comboBox1.SelectedItem as Group; st.Name = textBox1.Text; st.Surname = textBox2.Text; st.Email = textBox3.Text; st.Phone = textBox4.Text; st.Fee = Convert.ToDouble(textBox5.Text); st.GroupID = grp.id; st.StartDate = dateTimePicker1.Value; if (db.SaveChanges() != 0) { MessageBox.Show("Student updated"); FormRefresh(); } else { MessageBox.Show("Student updated!"); } } }
// Fill grid Method public void fillGrid(List <Classroom> list) { dataGridView1.Rows.Clear(); getStatistic(); using (var db = new AcademyDB()) { foreach (Classroom cls in list) { if (cls.Deleted == false) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = cls.id; row.Cells[1].Value = cls.Name; row.Cells[2].Value = cls.Capacity; // if group is free then set different color Group grup = db.Group.FirstOrDefault(gr => gr.ClassroomID == cls.id); if (grup == null) { row.DefaultCellStyle.BackColor = Color.FromArgb(186, 252, 186); } else { row.DefaultCellStyle.BackColor = Color.White; } dataGridView1.Rows.Add(row); } } } }
//Clear filters private void button1_Click(object sender, EventArgs e) { comboBox1.SelectedIndex = -1; using (var db = new AcademyDB()) { fillGrid(db.Group.ToList()); } }
// Fill grid Method public void fillGrid(List <Employee> list) { dataGridView1.Rows.Clear(); using (var db = new AcademyDB()) { // Fill comboboxes in datagridview dgvCombobox.DataSource = db.Position.Where(p => p.Deleted == false).ToList(); dgvCombobox.DisplayMember = "Name"; dgvCombobox.ValueMember = "id"; foreach (Employee emp in list) { if (emp.Deleted == false && emp.Position.Deleted == false) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); // if employer not teacher then set readonly to speciality if (emp.SpecialityID != null) { dgvComboboxSp.DataSource = db.Program.Where(p => p.Deleted == false).ToList(); dgvComboboxSp.DisplayMember = "Name"; dgvComboboxSp.ValueMember = "id"; dgvComboboxSp.ReadOnly = false; } else { row.Cells[8].Value = null; row.Cells[8].ReadOnly = true; } row.Cells[0].Value = emp.id; row.Cells[1].Value = emp.Name; row.Cells[2].Value = emp.Surname; row.Cells[3].Value = emp.Email; row.Cells[4].Value = emp.Phone; row.Cells[5].Value = emp.PositionID; // set selected position to combobox row.Cells[6].Value = emp.Salary; row.Cells[7].Value = emp.StartTime; row.Cells[8].Value = emp.SpecialityID; // set selected speciality to combobox2 // if teacher is not in any group Group grp = db.Group.FirstOrDefault(g => g.TeacherID == emp.id); if (grp == null && emp.SpecialityID != null) { row.DefaultCellStyle.BackColor = Color.FromArgb(241, 196, 15); } else { row.DefaultCellStyle.BackColor = Color.White; } dataGridView1.Rows.Add(row); } } } }
// Fill grid Method public void fillGrid(List <Student> list) { dataGridView1.Rows.Clear(); getStatistic(); using (var db = new AcademyDB()) { // Fill comboboxes in datagridview dgvComboboxGroup.DataSource = db.Group.Where(p => p.Deleted == false).ToList(); dgvComboboxGroup.DisplayMember = "Name"; dgvComboboxGroup.ValueMember = "id"; foreach (Student std in list) { if (std.Deleted == false && std.Group.Deleted == false) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = std.id; row.Cells[1].Value = std.Name; row.Cells[2].Value = std.Surname; row.Cells[3].Value = std.Email; row.Cells[4].Value = std.Phone; row.Cells[5].Value = std.Fee; row.Cells[6].Value = std.GroupID; // set selected group to combobox row.Cells[7].Value = std.StartDate; Group gr = db.Group.Where(g => g.id == std.GroupID).FirstOrDefault(); // if period of program end. then row will be red if (gr.Program.Period != null) { int periodMonths = (int)gr.Program.Period; DateTime programPeriod = std.StartDate.AddMonths(periodMonths); if (programPeriod < DateTime.Now) { row.DefaultCellStyle.BackColor = Color.FromArgb(255, 118, 117); } else { row.DefaultCellStyle.BackColor = Color.White; // if student has dept then cell color will be different color if (std.Fee < gr.Program.Price) { row.Cells[5].Style.BackColor = Color.FromArgb(241, 196, 15); } else { row.Cells[5].Style.BackColor = Color.White; } } } dataGridView1.Rows.Add(row); } } } }
// fill comboboxes public void fillCombobox() { using (var db = new AcademyDB()) { comboBox2.DataSource = db.Group.Where(g => g.Deleted == false).ToList(); comboBox2.DisplayMember = "Name"; comboBox2.ValueMember = "id"; comboBox2.SelectedIndex = -1; } }