private void Update_Button_Click(object sender, EventArgs e) { var temp1 = StudentName_textbox.Text; var temp = Convert.ToInt32(StudentID_textbox.Text); var Updatequery = from Student student in studentRegistration.Students where student.Id == temp select student; foreach (var element in Updatequery) { if (StudentName_textbox.Text != String.Empty) { element.Name = temp1; } if (Majors_List.SelectedItem != null) { element.Major = Majors_List.SelectedItem as Major; } } studentRegistration.SaveChanges(); updateTable(); clear_textbox(); }
private void addSection(int courseID, int facID, string times, string days, string semester) { var courseCheck = sectionEntities.Courses.Where(c => c.Id == courseID); var facultyCheck = sectionEntities.Faculties.Where(f => f.Id == facID); if (courseCheck.Any() && facultyCheck.Any()) { Section newSection = new Section() { CourseID = courseID, FacultyID = facID, Time = times, Day = days, Semester = semester }; sectionEntities.Sections.Add(newSection); sectionEntities.SaveChanges(); errorLabel.Text = "Section Added."; } else if (courseCheck.Any() && (facultyCheck.Any() == false)) { errorLabel.Text = "No faculty with that ID exists, please put in a new faculty."; } else if ((courseCheck.Any() == false) && facultyCheck.Any()) { errorLabel.Text = "No course with that ID exists, please put in a new course."; } else { errorLabel.Text = "Neither the course nor the faculty you submitted exist, please enter valid data."; } }
public EnrollmentForm() { InitializeComponent(); EnrollmentEntities = new RegistrationEntities(); EnrollmentEntities.Enrollments.Load(); UpdateTable(); HideComponents(); //******************************************* START OF INITILIZATION TEST. PLEASE DELETE BEFORE FINAL TURN IN****************************************************// //Section newSection = new Section //{ // Id = 1, // CourseID = 1, // FacultyID = 1, // Day = "Wednesday", // Time = "9:00AM", // Semester = "Fall" //}; //Section newSection1 = new Section //{ // Id = 1, // CourseID = 1, // FacultyID = 1, // Day = "Wednesday", // Time = "9:00AM", // Semester = "Summer" //}; //Student newStudent = new Student //{ // Id = 1, // Name = "Avian", // MajorID = 1 //}; //Faculty newFaculty = new Faculty //{ // Id = 1, // Name = "Eric", // PhoneNumber = "248-880-2020" //}; //Course newCourse = new Course //{ // Id = 1, // Name = "Intro C#", // Number = "297", // Credits = 4, // Department = "CECS" //}; //EnrollmentEntities.Sections.Add(newSection); //EnrollmentEntities.Sections.Add(newSection1); //EnrollmentEntities.Students.Add(newStudent); //EnrollmentEntities.Faculties.Add(newFaculty); //EnrollmentEntities.Courses.Add(newCourse); //************************************** END OF INITILIZATION TESTS***********************************// EnrollmentEntities.SaveChanges(); }