/// <summary>
/// 学生选课
/// </summary>
/// <param name="course"></param>
/// <returns></returns>
public IActionResult Insertcourse(Course course)
{
StudentMethod userfunction = new StudentMethod();
this.Request.Cookies.TryGetValue("Sno", out string value);
var score = new Score
{
Cno = course.Cno,
Sno = value
};
using (var dbcontext = new srContext())
{
var infor = dbcontext.Score.FirstOrDefault(u => u == score);
if (infor != null)
{
return(Content("<script>alert('选课失败，请勿重复选课');history.go(-1);</script>", "text/html;charset=UTF-8"));
}
else
{
Student student = dbcontext.Student.FirstOrDefault(u => u.Sno == value);
student.Score.Add(score);
dbcontext.SaveChanges();
return(Content("<script>alert('选课成功');window.location.href='/Student/Showcourses';</script>", "text/html;charset=UTF-8"));
}
}
}
public IActionResult Changestudent(Student stu)
{
StudentMethod method = new StudentMethod();
method.Change(stu);
return(RedirectToAction("Showstu", "Administrator", stu));
}
public IActionResult Changestu(Student student)
{
StudentMethod method = new StudentMethod();
var stu = method.FindStudent(student.Sno);
ViewBag.student = stu;
return(View());
}
public IActionResult ShowDep(string Depname)
{
StudentMethod method = new StudentMethod();
var Lists = method.Static(Depname);
ViewBag.students = Lists;
return(View());
}
public IActionResult Showallstudent()
{
StudentMethod method = new StudentMethod();
var students = method.ReadDB();
ViewBag.students = students;
return(View());
}
public IActionResult PInputscore()
{
StudentMethod method = new StudentMethod();
var students = method.ReadDB();
ViewBag.students = students;
return(View());
}
public IActionResult Pirntcer()
{
StudentMethod function = new StudentMethod();
List <Student> lists = function.ReadDB();
ViewBag.lists = lists;
return(View());
}
public IActionResult ChangeInformation()
{
StudentMethod userfunction = new StudentMethod();
this.Request.Cookies.TryGetValue("Sno", out string value);
string no = value;
Student student = userfunction.FindStudent(no);
ViewBag.student = student;
return(View());
}
/// <summary>
/// 学生信息统计页面
/// </summary>
/// <returns></returns>
public IActionResult Stastudent()
{
StudentMethod method = new StudentMethod();
List <List <Student> > students = new List <List <Student> >();
List <string> Dep = method.Getdep();
foreach (var infor in Dep)
{
students.Add(method.Static(infor));
}
ViewBag.students = students;
return(View());
}
/// <summary>
/// 增加一个学生
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public IActionResult Addstu(Student student)
{
StudentMethod method = new StudentMethod();
if (method.Addstudent(student))
{
return(Content("<script>alert('添加成功');window.location.href='../Administrator/Index';</script>", "text/html;charset=UTF-8"));
}
else
{
return(Content("<script>alert('添加失败');history.go(-1);</script>", "text/html;charset=UTF-8"));
}
}
/// <summary>
/// 删除一个学生
/// </summary>
/// <param name="student_id"></param>
/// <returns></returns>
public IActionResult Delstudent(string student_id)
{
using (var dbcontext = new srContext())
{
var infor = dbcontext.Student.FirstOrDefault(u => u.Sno == student_id);
if (infor != null)
{
StudentMethod student = new StudentMethod();
student.Delete(student_id);
return(Content("<script>alert('删除成功');history.go(-1);</script>", "text/html;charset=UTF-8"));
}
else
{
return(Content("<script>alert('该学生不存在');history.go(-1);</script>", "text/html;charset=UTF-8"));
}
}
}
public IActionResult Showstu(Student student)
{
using (var dbcontext = new srContext())
{
var infor = dbcontext.Student.FirstOrDefault(u => u.Sno == student.Sno);
if (infor != null)
{
StudentMethod method = new StudentMethod();
var stu = method.FindStudent(student.Sno);
ViewBag.student = stu;
return(View());
}
else
{
return(Content("<script>alert('该学生不存在');history.go(-1);</script>", "text/html;charset=UTF-8"));
}
}
}
