public SearchStudentList SearchStudentList(SearchStudentList obj)
{
var model = (dynamic)null;
try
{
var studentsList = _studentsRepo.GetAll().ToList();
var ClassList = _classesRepo.GetAll().ToList();
var GendersList = _GendersRepo.GetAll().ToList();
var query = (from _students in studentsList
where _students.RegistrationNo == obj.RegistrationId
join _Classes in ClassList on _students?.ClassId equals _Classes?.Id
join _Genders in GendersList on _students?.GenderId equals _Genders?.Id
orderby _students.ClassId, _students.FirstName ascending
select new { _students, _Classes, _Genders }).SingleOrDefault();
if (query != null)
{
var temp = new SearchStudentList_Students()
{
Id = query._students.Id,
RegistrationNo = query._students.RegistrationNo,
ClassId = query._Classes.Id,
ClassName = query._Classes.Name,
GenderId = query._Genders.Id,
GenderName = query._Genders.Name,
FirstName = query._students.FirstName,
LastName = query._students.LastName,
StudentName = query._students.FirstName + " " + query._students.LastName,
IP300X200 = query._students.IP300X200,
AdmittedYear = query._students.AdmittedYear,
PresentAddress = query._students.PresentAddress,
PermanentAddress = query._students.PermanentAddress,
DOB = query._students.DOB,
IsActive = query._students.IsActive,
AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
model = new SearchStudentList()
{
Students = temp
};
}
else
{
model = new SearchStudentList()
{
Students = null
};
}
}
catch (Exception)
{
}
return(model);
}
public async Task <IActionResult> SearchStudentList(string RegistrationId)
{
try
{
if (String.IsNullOrEmpty(RegistrationId))
{
var model = new IndexSearchStudentListVM()
{
//Students = null,
RegistrationId = null
};
return(View("SearchStudentList", model));
}
else
{
var result = new SearchStudentList()
{
RegistrationId = RegistrationId
};
var studentList = await Task.Run(() => _StudentPaymentsServ.SearchStudentList(result));
ViewBag.ddlClasses = _classesServ.dropdown_Class();
ViewBag.ddlGenders = _GendersServ.Dropdown_Genders();
if (studentList.Students != null)
{
var temp = new IndexSearchStudentListVM_Students()
{
Id = studentList.Students.Id,
ClassId = studentList.Students.ClassId,
RegistrationNo = studentList.Students.RegistrationNo,
ClassName = studentList.Students.ClassName,
GenderId = studentList.Students.GenderId,
GenderName = studentList.Students.GenderName,
FirstName = studentList.Students.FirstName,
LastName = studentList.Students.LastName,
StudentName = studentList.Students.StudentName,
IP300X200 = studentList.Students.IP300X200,
AdmittedYear = studentList.Students.AdmittedYear,
PresentAddress = studentList.Students.PresentAddress,
PermanentAddress = studentList.Students.PermanentAddress,
DOB = studentList.Students.DOB,
IsActive = studentList.Students.IsActive,
AddedBy = studentList.Students.AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
var model = new IndexSearchStudentListVM()
{
Students = temp,
RegistrationId = RegistrationId,
};
return(View("SearchStudentList", model));
}
else
{
var model = new IndexSearchStudentListVM()
{
Students = null,
RegistrationId = RegistrationId,
};
return(View("SearchStudentList", model));
}
}
}
catch (Exception)
{
return(BadRequest());
}
}
