public ActionResult EditStudent(Studentlist stu)
{
if (ModelState.IsValid)
{
StudentBAL studentBAL = new StudentBAL();
studentBAL.Update_Student(stu.StudentID, stu.StudentName, stu.StudentEmail, stu.StudentMobile, stu.StudentAddress, stu.Birthday);
return(RedirectToAction("StudentList"));
}
return(View(stu));
}
public ActionResult StudentDetail(int id)
{
var user = from Students in db.Students
join Users in db.Users on Students.id equals Users.PersonId
join StudentAssgins in db.StudentAssgins on Students.id equals StudentAssgins.StudentId
join Projects in db.Projects on StudentAssgins.ProjectId equals Projects.id
where Users.Role == "S"
select new Studentlist
{
StudentId = Students.id,
UserId = Users.id,
ProjectId = Projects.id,
StudentName = Students.StudentName,
StudentNum = Students.StudentNum,
ProjectName = Projects.ProjectName,
Gender = Students.Gender,
Mobile = Students.Mobile,
Password = Users.Password,
StartDate = Users.StartDate,
Birthday = Students.Birthday,
Collegue = Students.Collegue,
Nationality = Students.Nationality,
HeadImage = Students.HeadImage,
Comments = Students.Comments
};
var a = user.Where(x => x.StudentId == id).FirstOrDefault();
Studentlist userone = new Studentlist();
userone.StudentId = a.StudentId;
userone.UserId = a.UserId;
userone.ProjectId = a.ProjectId;
userone.StudentName = a.StudentName;
userone.StudentNum = a.StudentNum;
userone.ProjectName = a.ProjectName;
if (a.Gender == "0")
{
userone.Gender = "男";
}
if (a.Gender == "1")
{
userone.Gender = "女";
}
userone.Mobile = a.Mobile;
userone.Password = a.Password;
userone.StartDate = a.StartDate;
userone.Birthday = a.Birthday;
userone.Collegue = a.Collegue;
userone.Nationality = a.Nationality;
userone.HeadImage = a.HeadImage;
userone.Comments = a.Comments;
return(View(userone));
}
public ActionResult StudentList(Studentlist stu, string searchString)
{
StudentBAL bal = new StudentBAL();
var result = bal.GetAllStudentOnSearch(searchString).Select(s => new Studentlist
{
StudentID = s.StudentID,
StudentName = s.StudentName,
StudentEmail = s.StudentEmail,
StudentMobile = s.StudentMobile,
StudentAddress = s.StudentAddress,
Birthday = s.Birthday,
Age = s.Age
});
return(View(result.ToList()));
}
public ActionResult add_new_student(Studentlist stu)
{
if (ModelState.IsValid)
{
StudentBAL bal = new StudentBAL();
if (bal.Check_user_input(stu.StudentName, stu.StudentEmail))
{
bal.Add_Student(stu.StudentName, stu.StudentEmail, stu.StudentMobile, stu.StudentAddress, stu.Birthday);
}
else
{
ModelState.AddModelError("StudentName", SiteResource.ExistsStudent);
return(View(stu));
}
return(RedirectToAction("StudentList"));
}
return(View(stu));
}
public IWebElement GetStudentRow(int row)
{
ReadOnlyCollection <IWebElement> readOnlyCollection = Studentlist.FindElements((By.XPath(StudentTableXpath)));
return(readOnlyCollection[row]);
}
public ActionResult StudentEdit(int id)
{
var user = from Students in db.Students
join Users in db.Users on Students.id equals Users.PersonId
join StudentAssgins in db.StudentAssgins on Students.id equals StudentAssgins.StudentId
join Projects in db.Projects on StudentAssgins.ProjectId equals Projects.id
where Users.Role == "S"
select new Studentlist
{
StudentId = Students.id,
UserId = Users.id,
ProjectId = Projects.id,
StudentName = Students.StudentName,
StudentNum = Students.StudentNum,
ProjectName = Projects.ProjectName,
Gender = Students.Gender,
Mobile = Students.Mobile,
Password = Users.Password,
StartDate = Users.StartDate,
Birthday = Students.Birthday,
Collegue = Students.Collegue,
Nationality = Students.Nationality,
HeadImage = Students.HeadImage,
Comments = Students.Comments
};
var a = user.Where(x => x.StudentId == id).FirstOrDefault();
Studentlist userone = new Studentlist();
userone.StudentId = a.StudentId;
userone.UserId = a.UserId;
userone.ProjectId = a.ProjectId;
userone.StudentName = a.StudentName;
userone.StudentNum = a.StudentNum;
userone.ProjectName = a.ProjectName;
userone.Gender = a.Gender;
userone.Mobile = a.Mobile;
userone.Password = a.Password;
userone.StartDate = a.StartDate;
userone.Birthday = a.Birthday;
userone.Collegue = a.Collegue;
userone.Nationality = a.Nationality;
userone.HeadImage = a.HeadImage;
userone.Comments = a.Comments;
//初始化项目名称下拉列表
List <SelectListItem> projectList = new List <SelectListItem>();
foreach (var item in db.Projects)
{
SelectListItem listItem = new SelectListItem();
listItem.Text = item.ProjectName;
listItem.Value = item.id.ToString();
projectList.Add(listItem);
}
ViewData["ProjectList"] = projectList;
ViewData["ProjectId"] = a.ProjectId;
if (a.Birthday != null)
{
ViewData["Birthday"] = Convert.ToDateTime(a.Birthday).ToString("yyyy-MM-dd");
}
else
{
ViewData["Birthday"] = null;
}
return(View(userone));
}
