private void button1_Click_1(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (textBox2.Text == "" || textBox3.Text == "") { MessageBox.Show("Missing required input.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var classroom = new Classroom { Name = textBox2.Text.ToString(), Capacity = Convert.ToInt32(textBox3.Text) }; ctx.Classrooms.Add(classroom); ctx.SaveChanges(); var len = ctx.Classrooms.ToArray().Length; this.Close(); //Adding ClassroomTimeRestriction foreach (var r in restrictions) { var restriction = new ClassroomTimeRestriction { TimeslotId = r, }; ctx.ClassroomTimeRestrictions.Add(restriction); ctx.SaveChanges(); } } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (textBox2.Text == "") { MessageBox.Show("Missing required input.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var prof = new Professor { // Podesi input, automatski increase ID Name = textBox2.Text.ToString(), }; ctx.Professors.Add(prof); ctx.SaveChanges(); //Adding ProfessorTimeRestriction foreach (var r in restrictions) { var restriction = new ProfessorTimeRestriction { ProfessorId = prof.Id, TimeslotId = r, }; ctx.ProfessorTimeRestrictions.Add(restriction); ctx.SaveChanges(); } this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (comboBox1.SelectedItem.ToString() == "" || comboBox2.SelectedItem.ToString() == "" || comboBox3.SelectedItem.ToString() == "") { MessageBox.Show("Missing required input from dropdown menu.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int groupId = Convert.ToInt32(comboBox1.SelectedValue); int courseId = Convert.ToInt32(comboBox2.SelectedValue); int professorId = Convert.ToInt32(comboBox3.SelectedValue); if (ctx.GroupCourseProfessors.Any(gcp => gcp.GroupId == groupId && gcp.CourseId == courseId && gcp.ProfessorId == professorId)) { this.Close(); return; } var g = new GroupCourseProfessor { GroupId = groupId, CourseId = courseId, ProfessorId = professorId, Timeslots = Convert.ToInt32(textBox1.Text) }; ctx.GroupCourseProfessors.Add(g); ctx.SaveChanges(); this.Close(); } } }
private void button3_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in classroomDataGridView.SelectedRows) { Classroom sch = row.DataBoundItem as Classroom; if (sch != null) { _context.Classrooms.Remove(sch); _context.SaveChanges(); } } }
private void button3_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in timeslotDataGridView.SelectedRows) { Timeslot sch = row.DataBoundItem as Timeslot; if (sch != null) { _context.Timeslots.Remove(sch); _context.SaveChanges(); } } }
private void button6_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in scheduleDataGridView.SelectedRows) { Schedule sch = row.DataBoundItem as Schedule; if (sch != null) { _context.Schedules.Remove(sch); _context.SaveChanges(); } } }
private void button3_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in professorDataGridView.SelectedRows) { Professor sch = row.DataBoundItem as Professor; if (sch != null) { _context.Professors.Remove(sch); _context.SaveChanges(); } } }
private void button3_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in groupDataGridView.SelectedRows) { Group sch = row.DataBoundItem as Group; if (sch != null) { _context.Groups.Remove(sch); _context.SaveChanges(); } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (textBox2.Text == "") { MessageBox.Show("Missing required input.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var schedule = new Schedule { Name = textBox2.Text.ToString(), }; ctx.Schedules.Add(schedule); ctx.SaveChanges(); this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (textBox2.Text == "") { MessageBox.Show("Missing required input.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var course = new Course { Name = textBox2.Text.ToString(), }; ctx.Courses.Add(course); ctx.SaveChanges(); var len = ctx.Classrooms.ToArray().Length; this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (comboBox1.SelectedItem.ToString() == "") { MessageBox.Show("Missing required input from dropdown menu.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var timeslot = new Timeslot { From = Convert.ToInt32(textBox2.Text), To = Convert.ToInt32(textBox3.Text), Day = comboBox1.SelectedItem.ToString(), }; ctx.Timeslots.Add(timeslot); ctx.SaveChanges(); var len = ctx.Timeslots.ToArray().Length; this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { using (var ctx = new ScheduleContext()) { if (textBox2.Text == "" || textBox3.Text == "") { MessageBox.Show("Missing required input.", "Missing input", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var group = new Group { Name = textBox2.Text.ToString(), Members = Convert.ToInt32(textBox3.Text.ToString()), ParentId = Convert.ToInt32(comboBox1.SelectedValue), }; ctx.Groups.Add(group); ctx.SaveChanges(); var len = ctx.Groups.ToArray().Length; this.Close(); } } }