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