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));
}
