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