public async Task <IActionResult> Students(StudentsSearchRequest searchRequest) { var model = new StudentSearchModel(); if (searchRequest != null) { var searchParameters = RequestParameters.CreateFromModel(searchRequest); // Generates url parameters from searchRequest object searchParameters.Add("Test", true); // Also, you can specify additional parameters var response = await GetRequest($@"{_settings.Value.ApiUrl}/api/Student/search", searchParameters); var responseObject = JsonConvert.DeserializeObject <StudentsSearchResponse>( await response.Content.ReadAsStringAsync()); model.SearchResult = responseObject.Students; } model.SearchParameters = searchRequest; var gradeResponse = await GetRequest($@"{_settings.Value.ApiUrl}/api/Grade/get-all"); var greadesList = JsonConvert.DeserializeObject <List <Grade> >( await gradeResponse.Content.ReadAsStringAsync()); model.AvailableGrades = greadesList.Select(x => new SelectListItem(x.GradeName, x.Id.ToString(), searchRequest.SelectedGradeIds == null ? false : searchRequest.SelectedGradeIds.Contains(x.Id))).ToList(); return(View(model)); }
public IQueryable <Student> GetProducts(StudentSearchModel searchModel) { var result = Context.Student.AsQueryable(); if (searchModel != null) { if (searchModel.ID.HasValue) { result = result.Where(x => x.ID == searchModel.ID); } if (!string.IsNullOrEmpty(searchModel.Name)) { result = result.Where(x => x.Name.Contains(searchModel.Name)); } if (!string.IsNullOrEmpty(searchModel.Course)) { result = result.Where(x => x.Course.Contains(searchModel.Course)); } if (searchModel.Paid) { result = result.Where(x => x.Paid == searchModel.Paid); } } return(result); }
public IActionResult Index(StudentSearchModel searchData) { StudentJoinSearchModel studentResult = new StudentJoinSearchModel(); List <DataAndTranscationsModel> studentAllDetails = studentResult.SearchStudentData(searchData); return(PartialView("_StudentPartialView", studentAllDetails)); }
public ViewResult Index(int Page = 1, string Name = null) { var model = new StudentSearchModel() { Name = Name, Students = studentRepository.ByNameLike(Name).AsPagination(Page) }; return(View(model)); }
public ActionResult <StudentSearchResModel> GetListByParas(StudentSearchModel model) { var lists = _studentService.GetListByParas(model); StudentSearchResModel resModel = new StudentSearchResModel(); resModel.IsSuccess = true; resModel.viewModels = lists; resModel.TotalNum = lists.Count; resModel.baseViewModel.Message = "查询成功"; resModel.baseViewModel.ResponseCode = 200; return(resModel); }
//获取该年级班级的 学生总数 public BaseViewModel GetStudentTotalByGC(string GradeCode, string ClassCode) { BaseViewModel baseView = new BaseViewModel(); StudentSearchModel student = new StudentSearchModel(); student.GradeCode = GradeCode; student.ClassCode = ClassCode; var lists = _studentInfoRepository.GetByModel(student); baseView.Message = lists.Count.ToString(); baseView.ResponseCode = 0; return(baseView); }
//根据条件查询 public List <Student_Info> GetByModel(StudentSearchModel model) { //查询条件 var predicate = WhereExtension.True <Student_Info>();//初始化where表达式 //姓名 if (!String.IsNullOrEmpty(model.Name)) { predicate = predicate.And(p => p.Name.Contains(model.Name)); } //身份证 if (!String.IsNullOrEmpty(model.IdNumber)) { predicate = predicate.And(p => Dtol.Helper.MD5.Decrypt(p.IdNumber).Contains(model.IdNumber)); } //学校 if (!String.IsNullOrEmpty(model.SchoolCode)) { predicate = predicate.And(p => p.SchoolCode.Equals(model.SchoolCode)); } //年级 if (!String.IsNullOrEmpty(model.GradeCode)) { predicate = predicate.And(p => p.GradeCode.Equals(model.GradeCode)); } //班级 if (!String.IsNullOrEmpty(model.ClassCode)) { predicate = predicate.And(p => p.ClassCode.Equals(model.ClassCode)); } //住址 if (!String.IsNullOrEmpty(model.PermanentAddress)) { predicate = predicate.And(p => p.PermanentAddress.Contains(model.PermanentAddress)); } var result = DbSet.Where(predicate).ToList(); return(result); }
//根据条件查询 public List <StudentMiddle> GetListByParas(StudentSearchModel model) { List <Student_Info> lists = new List <Student_Info>(); List <StudentMiddle> nlists = new List <StudentMiddle>(); //if (!string.IsNullOrEmpty(model.IdNumber)) //{ // model.IdNumber = Dtol.Helper.MD5.Md5Hash(model.IdNumber); //} lists = _studentInfoRepository.GetByModel(model); foreach (var item in lists) { var info = _IMapper.Map <Student_Info, StudentMiddle>(item); info.IdNumber = Dtol.Helper.MD5.Decrypt(info.IdNumber); nlists.Add(info); } return(nlists); }
public IActionResult Get([FromQuery] StudentSearchModel pretraga) { var query = db.Student.AsQueryable(); if (pretraga.labVezbaId != null) { query = query.Where(s => s.LabVezbaStudent.Any(x => x.LabVezbaId == pretraga.labVezbaId)); } query = query.OrderBy(x => x.Indeks); var list = query.Select(studentDB => new Student { Id = studentDB.Id, Ime = studentDB.Ime, Indeks = studentDB.Indeks, Prezime = studentDB.Prezime, Username = studentDB.Username, Notifikacije = studentDB.Notifikacije }).ToList(); return(Ok(list)); }
// GET: Student public ActionResult Index() { try { using (var context = new BaseDbContext()) { var lst = (from u in context.Users join ut in context.UserTypes on u.UserTypeId equals ut.Id select ut).ToList(); var temp = context.Users.ToList(); //var temp2 = context.UserTypes.Where(x => x.Users.Select(y => y.Id).ToList().Contains("b426d975-311a-4a44-ad8f-86a68c903f86")).ToList(); var xy = 1; xy += 10; } } catch (Exception) { throw; } InitData(); var data = new StudentSearchModel(); return(View(data)); }