public ActionResult <StudentData> AddStudentData(StudentData student) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var existingPesel = _dbContext.Students.SingleOrDefault(x => x.pesel == student.pesel); var existingIndexNumber = _dbContext.Students.SingleOrDefault(x => x.indexNumber == student.indexNumber); var existingEmail = _dbContext.Students.SingleOrDefault(x => x.email == student.email); if (existingPesel != null || existingIndexNumber != null || existingEmail != null) { return(StatusCode(StatusCodes.Status409Conflict, "Student's data with the same pesel / index number or email already exists.")); } _dbContext.Students.Add(student); _dbContext.SaveChanges(); return(CreatedAtAction(nameof(GetStudentData), new { id = student.Id }, student)); } catch (Exception exc) { while (exc.InnerException != null) { exc = exc.InnerException; } return(StatusCode(StatusCodes.Status500InternalServerError, exc.Message)); } }
public ActionResult SaveStudent(StudentVM Model) { using (StudentDataContext dc = new StudentDataContext()) { var student = dc.Student.Where(s => s.ID == Model.ID).FirstOrDefault(); var subject = dc.Subject.Where(s => s.SubjectName.ToLower() == Model.SubjectName.ToLower()).FirstOrDefault(); if (subject == null) { subject = new Subject(); subject.SubjectName = Model.SubjectName; dc.Subject.Add(subject); dc.SaveChanges(); } if (student == null) { student = new Student(); dc.Student.Add(student); } student.FirstName = Model.FirstName; student.LastName = Model.LastName; student.Class = Model.Class; student.SubjectID = subject.ID; student.Marks = Model.Marks; dc.SaveChanges(); } return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "Id,Room,Title,CourseName")] Subject subject) { if (ModelState.IsValid) { db.Subjects.Add(subject); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(subject)); }
public ActionResult Create([Bind(Include = "Id,Name,LastName,Mark")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "Id,Title,Price,Duration")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create(Student model) { model.Status = "Disactivated"; dbc.Students.Add(model); dbc.SaveChanges(); var data = new { message = "Thanh Cong" }; return(Json(data)); }
public ActionResult Update(Student model) { var data = dbc.Students.Single(a => a.Id == model.Id); data.Name = model.Name; data.Number = model.Number; data.Sta = model.Sta; dbc.SaveChanges(); return(Json(new { message = "Cap Nhat Thanh Cong" })); }
public ActionResult DeleteStudent(int ID) { using (StudentDataContext dc = new StudentDataContext()) { var student = dc.Student.Where(s => s.ID == ID).FirstOrDefault(); dc.Student.Remove(student); dc.SaveChanges(); } return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public IActionResult AddGrade(CourseGrade courseGrade) { if (!ModelState.IsValid) { return(View()); } courseGrade.CreatedDate = DateTime.Now; _db.Grades.Add(courseGrade); _db.SaveChanges(); return(RedirectToAction(nameof(StudentController.Index), "Student")); }