public int SaveEnrollCourse(EnrollStudentCourse enrollStudentCourse) { try { connection = new SqlConnection(connectionString); //string query = "INSERT INTO StudentEnrollInCourse VALUES(@StudentId,@CourseId,@EnrollDate)"; string query = "INSERT INTO StudentEnrollInCourse VALUES('" + enrollStudentCourse.StudentId + "','" + enrollStudentCourse.CourseId + "','" + enrollStudentCourse.EnrollDate + "','" + 1 + "')"; command = new SqlCommand(query, connection); connection.Open(); command = new SqlCommand(query, connection); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); //command.Parameters.Clear(); //command.Parameters.AddWithValue("@StudentId", enrollStudentCourse.StudentId); //command.Parameters.AddWithValue("@CourseId", enrollStudentCourse.Name); //command.Parameters.AddWithValue("@EnrollDate", enrollStudentCourse.EnrollDate); //command.Parameters.AddWithValue("@Status",1); //int rowAffected = command.ExecuteNonQuery(); //return rowAffected; } catch (Exception exception) { throw new Exception("Could Not save", exception); } finally { connection.Close(); } }
public ActionResult DeleteConfirmed(int id) { EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id); db.EnrollStudentCourses.Remove(enrollStudentCourse); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "EnrollStudentCourseID,CourseID,StudentID,Grade")] EnrollStudentCourse enrollStudentCourse) { if (ModelState.IsValid) { db.Entry(enrollStudentCourse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollStudentCourse.CourseID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", enrollStudentCourse.StudentID); return(View(enrollStudentCourse)); }
public string SaveEnrollCourse(EnrollStudentCourse enrollStudentCourse) { if (studentGateway.IsEXistEnrollStudentCourse(enrollStudentCourse.CourseId, enrollStudentCourse.StudentId)) { return(" Exist Course"); } if (studentGateway.SaveEnrollCourse(enrollStudentCourse) > 0) { return("Save Enroll Course"); } return("Failed to save"); }
public ActionResult Create(EnrollStudentCourse enrollStudentCourse) { try { IEnumerable <Student> students = studentManager.GetStudents(); ViewBag.Students = students; ViewBag.message = studentManager.SaveEnrollCourse(enrollStudentCourse); return(View()); } catch { return(View()); } }
// GET: EnrollStudentCourse/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id); if (enrollStudentCourse == null) { return(HttpNotFound()); } return(View(enrollStudentCourse)); }
// GET: EnrollStudentCourse/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id); if (enrollStudentCourse == null) { return(HttpNotFound()); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollStudentCourse.CourseID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", enrollStudentCourse.StudentID); return(View(enrollStudentCourse)); }