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