public override List <StudentLists> getElementByTime(DateTime dtStartTime, DateTime dtEndTime) { TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount); if (mClasses != null) { var oData = oEntities.SP_GETLISTSTUDENT_NOTINCLASS_BYCLASSID_STUDENTS(dtStartTime.ToShortDateString(), mClasses.Id, dtEndTime.ToShortDateString()).ToList(); List <StudentLists> lisStudent = new List <StudentLists>(); Commons oCommons = new Commons(); foreach (var o in oData) { StudentLists oStudentLists = new StudentLists(); oStudentLists.Id = o.Id; oStudentLists.FullName = o.FullName; if (o.Sex == 0) { oStudentLists.SexString = "Nam"; } else { oStudentLists.SexString = "Nữ"; } oStudentLists.Sex = o.Sex; oStudentLists.Mobile = string.IsNullOrEmpty(o.Mobile) ? "" : /*o.Mobile*/ oCommons.DecryptInfo(o.Mobile); oStudentLists.DateBirthday = o.DateBirthday; oStudentLists.Email = string.IsNullOrEmpty(o.Email) ? "" : /*o.Email*/ oCommons.DecryptInfo(o.Email); oStudentLists.Address = o.Address; oStudentLists.DateBirthday = o.DateBirthday; oStudentLists.UserId = o.UserId; oStudentLists.UserName = o.UserName; oStudentLists.CourseId = o.CourseId; oStudentLists.CourseName = o.CourseName; oStudentLists.StatusId = o.StatusId; oStudentLists.StatusName = o.StatusName; oStudentLists.Description = o.Description; oStudentLists.DateCreate = (DateTime)o.DateCreate; lisStudent.Add(oStudentLists); } return(lisStudent.Count <= 0 ? null : lisStudent); } else { var oData = oEntities.SP_GETELEMENTS_BYDATE_STUDENTS(dtStartTime.ToShortDateString(), dtEndTime.ToShortDateString()).ToList(); List <StudentLists> lisStudent = new List <StudentLists>(); Commons oCommons = new Commons(); foreach (var o in oData) { StudentLists oStudentLists = new StudentLists(); oStudentLists.Id = o.Id; oStudentLists.FullName = o.FullName; if (o.Sex == 0) { oStudentLists.SexString = "Nam"; } else { oStudentLists.SexString = "Nữ"; } oStudentLists.Sex = o.Sex; oStudentLists.Mobile = string.IsNullOrEmpty(o.Mobile) ? "" : /*o.Mobile*/ oCommons.DecryptInfo(o.Mobile); oStudentLists.DateBirthday = o.DateBirthday; oStudentLists.Email = string.IsNullOrEmpty(o.Email) ? "" : /*o.Email*/ oCommons.DecryptInfo(o.Email); oStudentLists.Address = o.Address; oStudentLists.DateBirthday = o.DateBirthday; oStudentLists.UserId = o.UserId; oStudentLists.UserName = o.UserName; oStudentLists.CourseId = o.CourseId; oStudentLists.CourseName = o.CourseName; oStudentLists.StatusId = o.StatusId; oStudentLists.StatusName = o.StatusName; oStudentLists.Description = o.Description; oStudentLists.DateCreate = (DateTime)o.DateCreate; lisStudent.Add(oStudentLists); } return(lisStudent.Count <= 0 ? null : lisStudent); } }