// GET: Students public async Task <IActionResult> Index(string courseName, string searchString) { ViewData["Courses"] = await _context.Courses.Select(c => c).ToListAsync(); // Use LINQ to get list of students. IQueryable <string> courseQuery = from c in _context.Students orderby c.Course.Name select c.Course.Name; var students = from m in _context.Students select m; if (!String.IsNullOrEmpty(searchString)) { students = students.Where(s => s.Name.Contains(searchString)); } if (!String.IsNullOrEmpty(courseName)) { students = students.Where(x => x.Course.Name == courseName); } var studentListingVM = new StudentListingViewModel(); studentListingVM.courses = new SelectList(await courseQuery.Distinct().ToListAsync()); studentListingVM.students = await students.ToListAsync(); return(View(studentListingVM)); }
public void StudentListingVMTest() { // arrange Student student1 = new Student(); student1.ID = 4; student1.Name = "Bill Test"; student1.Level = Level.Undergraduate; student1.CourseID = 1; student1.EnrollmentTerm = EnrollmentTerm.Summer2018; Student student2 = new Student(); student2.ID = 5; student2.Name = "Sally Testing"; student2.Level = Level.Graduate; student2.CourseID = 3; student2.EnrollmentTerm = EnrollmentTerm.Spring2019; StudentListingViewModel studentLVM = new StudentListingViewModel(); List <Student> demStudents = new List <Student>(); demStudents.Add(student1); demStudents.Add(student2); studentLVM.students = demStudents; List <SelectListItem> Courses = new List <SelectListItem>(); SelectListItem testSelectItem1 = new SelectListItem() { Text = "Biology", Value = "BIO" }; Courses.Add(testSelectItem1); SelectListItem testSelectItem2 = new SelectListItem() { Text = "Psychology", Value = "PSY" }; Courses.Add(testSelectItem2); SelectList datSelectList = new SelectList(Courses); studentLVM.courses = datSelectList; studentLVM.courseName = "Biology"; var result1 = studentLVM.students.FirstOrDefault(s => s.ID == 4); var result2 = studentLVM.students.FirstOrDefault(s => s.ID == 5); var result3 = studentLVM.courses.ToList(); Assert.Equal(student1, result1); Assert.Equal(student2, result2); Assert.Equal(2, result3.Count()); Assert.Equal("Biology", studentLVM.courseName); }
/// <summary> /// Load content for container /// </summary> /// <param name="tab">tab</param> /// <param name="userType">userType</param> /// <returns>Return list</returns> public SelectListInsatnceViewModel LoadContent(string tab, string userType) { SelectListInsatnceViewModel listType = new SelectListInsatnceViewModel(); listType.PatientListingInstance = new List <PatientListingViewModel>(); listType.MedicineListingInstance = new List <MedicineListingViewModel>(); listType.FoodListingInstance = new List <FoodListingViewModel>(); listType.ApplicantListingInstance = new List <FoodApplicantListingViewModel>(); listType.StudentListingInstance = new List <StudentListingViewModel>(); listType.TrainingListingInstance = new List <TrainingListingViewModel>(); if (tab == "patientListTab") { var itemList = this.unitOfWork.UserRepository.GetQuery(x => x.UserType.UserTypeCode != "ADMN" && x.WelfareSection != null && x.WelfareSection.Contains("M")).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var patient in itemList) { PatientListingViewModel patientInstance = new PatientListingViewModel(); patientInstance.PatientStringID = "EW_00" + patient.UserID; patientInstance.PatientID = patient.UserID; patientInstance.PatientName = patient.FirstName + " " + patient.MiddleName + " " + patient.LastName; patientInstance.RequstedDate = String.Format("{0:d}", patient.CreatedDate).Replace("-", "/"); patientInstance.DOB = String.Format("{0:d}", patient.DOB).Replace("-", "/"); //patientInstance.SectionName = patient.UserType.UserTypeCode; patientInstance.Attachment = patient.MedicineReceipt; patientInstance.Checked = false; if (!string.IsNullOrEmpty(patient.DeliveredSupport)) { patientInstance.DeliveryChecked = patient.DeliveredSupport.Contains("M"); } var valstring = this.GetAllMedicinesByUserID(patient.UserID); if (valstring != null && valstring.Count > 0) { patientInstance.MedicineString = (string.Join(",", valstring.Select(x => x.Text).ToArray())); } listType.PatientListingInstance.Add(patientInstance); } } } else if (tab == "medicineListTab") { var itemList = this.unitOfWork.MedicineRepository.GetQuery(null).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var medicine in itemList) { MedicineListingViewModel medicineInstance = new MedicineListingViewModel(); medicineInstance.MedicineStringID = "EW_00" + medicine.MedicineID; medicineInstance.MedicineID = medicine.MedicineID; medicineInstance.MedicineName = medicine.MedicineName; medicineInstance.Price = medicine.Price; medicineInstance.Quantity = medicine.Quantity.ToString(); medicineInstance.IssueDate = medicine.IssueDate.ToShortDateString(); listType.MedicineListingInstance.Add(medicineInstance); } } } else if (tab == "foodListTab") { var itemList = this.unitOfWork.FoodRepository.GetQuery(null).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var food in itemList) { FoodListingViewModel foodInstance = new FoodListingViewModel(); foodInstance.FoodStringID = "EW_00" + food.FoodID; foodInstance.FoodID = food.FoodID; foodInstance.FoodName = food.FoodName; foodInstance.Price = food.Price; foodInstance.Quantity = food.Quantity; foodInstance.IssueDate = food.IssueDate.ToShortDateString(); listType.FoodListingInstance.Add(foodInstance); } } } else if (tab == "foodApplicantListTab") { var itemList = this.unitOfWork.UserRepository.GetQuery(x => x.UserType.UserTypeCode != "ADMN" && x.WelfareSection != null && x.WelfareSection.Contains("F")).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var applicnt in itemList) { FoodApplicantListingViewModel applicantInstance = new FoodApplicantListingViewModel(); applicantInstance.ApplicantStringID = "EW_00" + applicnt.UserID; applicantInstance.ApplicantID = applicnt.UserID; applicantInstance.ApplicantName = applicnt.FirstName + " " + applicnt.MiddleName + " " + applicnt.LastName; applicantInstance.RequstedDate = String.Format("{0:d}", applicnt.CreatedDate).Replace("-", "/"); applicantInstance.DOB = String.Format("{0:d}", applicnt.DOB).Replace("-", "/"); //patientInstance.SectionName = patient.UserType.UserTypeCode; applicantInstance.Attachment = applicnt.MedicineReceipt; applicantInstance.Checked = false; if (!string.IsNullOrEmpty(applicnt.DeliveredSupport)) { applicantInstance.DeliveryChecked = applicnt.DeliveredSupport.Contains("M"); } var valstring = this.GetAllMedicinesByUserID(applicnt.UserID); if (valstring != null && valstring.Count > 0) { applicantInstance.FoodItemString = (string.Join(",", valstring.Select(x => x.Text).ToArray())); } listType.ApplicantListingInstance.Add(applicantInstance); } } } else if (tab == "trainingListTab") { var itemList = this.unitOfWork.TrainingRepository.GetQuery(null).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var training in itemList) { TrainingListingViewModel trainingInstance = new TrainingListingViewModel(); trainingInstance.TrainingStringID = "EW_00" + training.TrainingID; trainingInstance.TrainingID = training.TrainingID; trainingInstance.TrainingName = training.TrainingName; trainingInstance.StartDate = training.StartDate.Value.ToShortDateString(); trainingInstance.EndDate = training.EndDate.Value.ToShortDateString(); listType.TrainingListingInstance.Add(trainingInstance); } } } else if (tab == "studentListTab") { var itemList = this.unitOfWork.UserRepository.GetQuery(x => x.UserType.UserTypeCode != "ADMN" && x.WelfareSection != null && x.WelfareSection.Contains("E")).ToList(); if (itemList != null && itemList.Count > 0) { foreach (var applicnt in itemList) { StudentListingViewModel applicantInstance = new StudentListingViewModel(); applicantInstance.StudentStringID = "EW_00" + applicnt.UserID; applicantInstance.StudentID = applicnt.UserID; applicantInstance.StudentName = applicnt.FirstName + " " + applicnt.MiddleName + " " + applicnt.LastName; applicantInstance.RequstedDate = String.Format("{0:d}", applicnt.CreatedDate).Replace("-", "/"); applicantInstance.DOB = String.Format("{0:d}", applicnt.DOB).Replace("-", "/"); //patientInstance.SectionName = patient.UserType.UserTypeCode; applicantInstance.Attachment = applicnt.MedicineReceipt; applicantInstance.Checked = false; if (!string.IsNullOrEmpty(applicnt.DeliveredSupport)) { applicantInstance.DeliveryChecked = applicnt.DeliveredSupport.Contains("E"); } listType.StudentListingInstance.Add(applicantInstance); } } } return(listType); }
public StudentListing() { DataContext = new StudentListingViewModel(); InitializeComponent(); }
public StudentListing(DataCoordinator dataCoordinator, Navigator navigator) { DataContext = new StudentListingViewModel(DialogCoordinator.Instance, dataCoordinator, navigator); InitializeComponent(); }