public static StudentDTO GetStudentDetailsByStudentId(int id)
{
using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities())
{
Student student = new Student();
student = GSDE.Students.FirstOrDefault(x => x.Id == id);
return(StudentDTO.Convert(student));
}
}
public static List <StudentDTO> GetStudentsListByKind(string studentKind)
{
using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities())
{
List <Student> studentList = new List <Student>();
studentList = GSDE.Students.Where(x => x.StudentKind == studentKind).ToList();
return(StudentDTO.Convert(studentList));
}
}
public static List <StudentDTO> GetStudentsList()
{
using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities())
{
List <Student> studentList = new List <Student>();
studentList = GSDE.Students.ToList();
return(StudentDTO.Convert(studentList));
}
}
public static List <StudentDTO> GetStudentsListByDetails(StudentDTO studentDTO)
{
using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities())
{
List <Student> studentList = GSDE.Students.Where(x =>
(string.IsNullOrEmpty(studentDTO.FirstName) || x.FirstName == studentDTO.FirstName) &&
(string.IsNullOrEmpty(studentDTO.LastName) || x.LastName == studentDTO.LastName) &&
(string.IsNullOrEmpty(studentDTO.PhoneNumber) || x.PhoneNumber == studentDTO.PhoneNumber) &&
(string.IsNullOrEmpty(studentDTO.IdentityNumber) || x.PhoneNumber == studentDTO.IdentityNumber)).ToList();
//if (studentDTO.FirstName != "")
// studentList = GetStudentsListByFirstName(studentList, studentDTO.FirstName);
//if (studentDTO.LastName != "")
// studentList = GetStudentsListByLastName(studentList, studentDTO.LastName);
//if (studentDTO.PhoneNumber != "")
// studentList = GetStudentsListByBuyPhoneNumber(studentList, studentDTO.PhoneNumber);
//if (studentDTO.IdentityNumber != "")
// studentList = GetStudentsListByIdentityNumber(studentList, studentDTO.IdentityNumber);
return(StudentDTO.Convert(studentList));
}
}