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