public ActionResult Create([Bind(Include = "Id,Name")] Teacher teacher) { if (ModelState.IsValid) { db.Teachers.Add(teacher); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(teacher)); }
public ActionResult Create([Bind(Include = "Id,Name")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "Id,Name,TeacherId")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "Name", course.TeacherId); return(View(course)); }
public ActionResult Create([Bind(Include = "Id,Name,CourseId")] Assignment assignment) { if (ModelState.IsValid) { db.Assignments.Add(assignment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "Id", "Name", assignment.CourseId); return(View(assignment)); }
public ActionResult Create([Bind(Include = "Id,StudentId,CourseId")] StudentCourse studentCourse) { if (ModelState.IsValid) { db.StudentCourses.Add(studentCourse); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "Id", "Name", studentCourse.CourseId); ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", studentCourse.StudentId); return(View(studentCourse)); }
public ActionResult Create([Bind(Include = "Id,StudentId,AssignmentId")] StudentAssignment studentAssignment) { if (ModelState.IsValid) { db.StudentAssignments.Add(studentAssignment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AssignmentId = new SelectList(db.Assignments, "Id", "Name", studentAssignment.AssignmentId); ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", studentAssignment.StudentId); return(View(studentAssignment)); }
private void deleteBT_Click(object sender, EventArgs e) // This method run when deleteBT clicked { try // Holding errors { using (SchoolDatabaseEntities schoolDatabase = new SchoolDatabaseEntities()) // Create temporary object of SchoolDatabaseEntities { var entry = schoolDatabase.Entry(students); // This variable store information about current state of entry on object if (entry.State == EntityState.Detached) // If state is detached { schoolDatabase.students.Attach(students); // Ataching student object to table } schoolDatabase.students.Remove(students); // Removeing students object from table schoolDatabase.SaveChanges(); // Saveing changes refreshDataGridView(); // Refreshing DataGridView with students clear(); // Run clear method } MessageBox.Show("Removeing record successfull !", "Entity Inforamtion", // Inform user about successfull inserting record MessageBoxButtons.OK, MessageBoxIcon.Information); // Set buttons and icon for messagebox } catch (Exception exception) // If some error become { MessageBox.Show("Error, contact system admin ! \n" + exception.ToString(), "Entity Error", // Inform user about some error MessageBoxButtons.OK, MessageBoxIcon.Error); // Set buttons and icon for messagebox } }
private void saveBT_Click(object sender, EventArgs e) // This method run when saveBT clicked { try // Holding errors { students.name = nameTB.Text.Trim(); // Set value of name as a nameTB.Text students.surname = surnameTB.Text.Trim(); // Set value of surname as a surnameTB.Text students.age = Convert.ToInt32(ageTB.Text.Trim()); // Set value of age as a ageTB.Text students.@class = classTB.Text.Trim(); // Set value of class as a classTB.Text students.address = addressTB.Text.Trim(); // Set value of address as a addressTB.Text using (SchoolDatabaseEntities schoolDatabase = new SchoolDatabaseEntities()) // Create temporary object of SchoolDatabaseEntities { schoolDatabase.Entry(students).State = EntityState.Modified; // Modify the current record schoolDatabase.SaveChanges(); // Saving changes } clear(); // Run clear method refreshDataGridView(); // Refreshing DataGridView with students MessageBox.Show("Updateing record successfull !", "Entity Inforamtion", // Inform user about successfull inserting record MessageBoxButtons.OK, MessageBoxIcon.Information); // Set buttons and icon for messagebox } catch (Exception exception) // If some error become { MessageBox.Show("Error, contact system admin ! \n" + exception.ToString(), "Entity Error", // Inform user about some error MessageBoxButtons.OK, MessageBoxIcon.Error); // Set buttons and icon for messagebox } }