public ActionResult Create([Bind("Id,StudentId,CourseId")] StudentEnrollCourse studentEnrollCourse) { if (ModelState.IsValid) { string cs = Configuration.GetConnectionString("DefaultDBConnection"); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("sp_addStudentToCourse", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@studentid", studentEnrollCourse.StudentId); cmd.Parameters.AddWithValue("@courseid", studentEnrollCourse.CourseId); con.Open(); cmd.ExecuteNonQuery(); } //_context.Add(studentEnrollCourse); //await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CourseId"] = new SelectList(_context.Course, "Id", "Name", studentEnrollCourse.CourseId); ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Name", studentEnrollCourse.StudentId); return(View(studentEnrollCourse)); }
public ActionResult Edit(int id, [Bind("Id,StudentId,CourseId")] StudentEnrollCourse studentEnrollCourse) { if (id != studentEnrollCourse.Id) { return(NotFound()); } if (ModelState.IsValid) { string cs = Configuration.GetConnectionString("DefaultDBConnection"); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("update StudentEnrollCourses set StudentId = @sid, CourseId = @cid where Id = @id; ", con); cmd.Parameters.AddWithValue("@sid", studentEnrollCourse.StudentId); cmd.Parameters.AddWithValue("@cid", studentEnrollCourse.CourseId); cmd.Parameters.AddWithValue("@id", studentEnrollCourse.Id); con.Open(); cmd.ExecuteNonQuery(); } //_context.Update(studentEnrollCourse); //await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CourseId"] = new SelectList(_context.Course, "Id", "Name", studentEnrollCourse.CourseId); ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Name", studentEnrollCourse.StudentId); return(View(studentEnrollCourse)); }
public ActionResult AssignGrade(StudentEnrollCourse student) { ViewBag.Message = astudentBll.UpdateGrade(student); ViewBag.Student = astudentBll.GetStudents(); ViewBag.Grade = GetGrades(); return(View()); }
public ActionResult StudentEnrollCourse(StudentEnrollCourse studentEnrollCourse) { if (astudentBll.SaveStudentEnrollCourse(studentEnrollCourse) > 0) { ViewBag.Message = "Save"; } ViewBag.Student = astudentBll.GetStudents(); return(View()); }
public string UpdateGrade(StudentEnrollCourse student) { if (astudentGetway.UpdateGrade(student) > 0) { return("Save"); } else { return("Error"); } }
public int UpdateGrade(StudentEnrollCourse student) { SqlConnection con = new SqlConnection(ConnectinString); con.Open(); string query = "Update StudentEnrollCourse set Grade = @Grade where StudentId = @StudentId And CourseId = @CourseId "; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("Grade", student.Grade); cmd.Parameters.AddWithValue("StudentId", student.StudentId); cmd.Parameters.AddWithValue("CourseId", student.CourseId); int rowCount = cmd.ExecuteNonQuery(); con.Close(); return(rowCount); }
public int SaveStudentEnrollCourse(StudentEnrollCourse student) { //SqlConnection con = new SqlConnection(@"Data Source=LAPTOP-NQGNJQ07\SQLEXPRESS;Initial Catalog=StockManagement;Integrated Security=True"); SqlConnection con = new SqlConnection(ConnectinString); con.Open(); string query = "insert into StudentEnrollCourse(StudentId,CourseId,Date,DepartmentId) values(@StudentId,@CourseId,@Date,@DepartmentId)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("StudentId", student.StudentId); cmd.Parameters.AddWithValue("CourseId", student.CourseId); cmd.Parameters.AddWithValue("DepartmentId", student.DepartmentId); cmd.Parameters.AddWithValue("Date", student.Date); int rowCount = cmd.ExecuteNonQuery(); con.Close(); return(rowCount); }
public int SaveStudentEnrollCourse(StudentEnrollCourse student) { return(astudentGetway.SaveStudentEnrollCourse(student)); }