public ActionResult Create([Bind(Include = "EnrollmentID,Grade,CourseID,StudentID")] Enrollment enrollment) { if (ModelState.IsValid) { var list = db.Enrollment.Where(x => x.StudentID == enrollment.StudentID && x.CourseID == enrollment.CourseID && x.Grade == enrollment.Grade).ToList(); if (list.Count > 0) { ModelState.AddModelError("message", "Ya está matrículado en el curso"); return(RedirectToAction("Create")); } else { db.Enrollment.Add(enrollment); db.SaveChanges(); } return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Course, "CourseID", "Title", enrollment.CourseID); ViewBag.StudentID = new SelectList(db.Student, "StudentID", "LastName", enrollment.StudentID); return(View(enrollment)); }
//To save data in student table// public bool Save(Student student) { student.CurrentYear = Convert.ToString(DateTime.Parse(student.regDate.ToString()).Year); dbContext.Students.Add(student); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
//To assign course in Course assign table// public bool Save(CourseAssign courseAssign) { courseAssign.Assign = true; dbContext.CourseAssigns.Add(courseAssign); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,Email,EnrollmentDate,DNI")] Student student) { if (ModelState.IsValid) { db.Student.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "CourseID,Title,Credits")] Course course) { if (ModelState.IsValid) { db.Course.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create([Bind(Include = "EnrollmentID,CourseID,StudentID")] Enrollment enrollment) { if (ModelState.IsValid) { db.Enrollment.Add(enrollment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Course, "CourseID", "Title", enrollment.CourseID); ViewBag.StudentID = new SelectList(db.Student, "StudentID", "LastName", enrollment.StudentID); return(View(enrollment)); }
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,Email,EnrollmentDate,Birthday")] Student student) { if (ModelState.IsValid) { DateTime today = DateTime.Today; db.Student.Add(student); student.EnrollmentDate = today; student.Enabled = true; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
//To save data in course table// public bool Save(Course course) { dbContext.Courses.Add(course); int rowaffeced = dbContext.SaveChanges(); return(rowaffeced > 0); }
// To save data in Department table// public bool Save(Department department) { dbContext.Departments.Add(department); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
//To save data in Teacher table// public bool Save(Teacher teacher) { dbContext.Teachers.Add(teacher); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
public bool Commit() { transaction = db.Database.BeginTransaction(); int affected = db.SaveChanges(); transaction.Commit(); return(affected > 0); }
//To save data in AllocateRoom table// public bool AllocateRoom(RoomAlloted allotedroom) { AllotedRoom alloted = new AllotedRoom(); alloted.Assign = true; alloted.depCode = allotedroom.depCode; alloted.CourseID = allotedroom.CourseID; alloted.dayID = allotedroom.dayID; alloted.roomID = allotedroom.roomID; alloted.fromTime = allotedroom.FormTime(); alloted.toTime = allotedroom.EndTime(); dbContext.AllotedRooms.Add(alloted); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }
public bool Save(Enrollment enrollment) { using (UniversityDBEntities db = new UniversityDBEntities()) { db.Enrollments.AddOrUpdate(enrollment); db.SaveChanges(); return(true); } }
public bool Save(Student student) { using (UniversityDBEntities db = new UniversityDBEntities()) { db.Students.AddOrUpdate(student); db.SaveChanges(); return(true); } }
public bool Delete(Enrollment enrollment) { using (UniversityDBEntities db = new UniversityDBEntities()) { db.Entry(enrollment).State = EntityState.Deleted; db.SaveChanges(); return(true); } }
public bool Update(Department department) { using (UniversityDBEntities db = new UniversityDBEntities()) { db.Departments.AddOrUpdate(department); db.SaveChanges(); return(true); } }
public bool Save(Course course) { using (var db = new UniversityDBEntities()) { db.Courses.AddOrUpdate(course); db.SaveChanges(); return(true); } }
public bool Delete(Course course) { using (var db = new UniversityDBEntities()) { db.Entry(course).State = EntityState.Deleted; db.SaveChanges(); return(true); } }
public bool Delete(Department department) { using (UniversityDBEntities db = new UniversityDBEntities()) { //db.Departments.Remove(department); db.Entry(department).State = EntityState.Deleted; db.SaveChanges(); return(true); } }
// to save result in student result table// public bool SaveResult(StudentResultEnrolled StudentResult) { Result result = new Result(); result.StudentID = StudentResult.StudentID; result.gradeID = StudentResult.gradeID; result.CourseID = StudentResult.CourseID; dbContext.Results.Add(result); int rowaffected = dbContext.SaveChanges(); return(rowaffected > 0); }