public override bool InsertElement(RecruitmentInfo oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Creat_Recruitment(oT.Name, oT.Description, oT.Contents, DateTime.Now, oT.DateStart,
oT.DateEnd, oT.Number, oT.Request, oT.CenterId, oT.OrderNumber, oT.Avatar, oT.ImagePath, oT.Status) > 0?
true:false);
}
public override bool InsertAndUpdate(Employee oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Update_Employee(oT.Id, oT.EmployeeName, oT.Sex, oT.DateBirhday, oT.Mobile, oT.Phone, oT.Email, oT.UniversityName, oT.Address
, oT.IdentityNumber, oT.DateOfIssue, oT.PlaceOfIssue, oT.PlaceBirthday, oT.PersonalTaxCode, oT.Description, null, oT.DateCreate, oT.DateRegister, oT.JobTitleId,
oT.CenterId, oT.OuId, oT.EmployeeCV) > 0?true:false);
}
public override bool InsertAndUpdate(Candidate oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Update_Candidate(oT.Id, null, null, oT.FullName, oT.DateBirthday, oT.Sex, oT.Address, oT.Description,
oT.YearsExperience, oT.UniversityDegree, oT.CenterId, null, oT.ImagePath, oT.Contents, oT.DocumentPath,
DateTime.Now, DateTime.Now, null, oT.DateSent, oT.Notes, oT.RecruitmentId, null, oT.JobTitleId, null)
> 0 ? true : false);
}
public override bool InsertAndUpdate(ExpertInfo oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
Commons oCommons = new Commons();
if (oT.sSex == "Nam") oT.Sex = 1; else oT.Sex = 0;
oT.Email = oCommons.EncryptInfo(oT.Email);
oT.Mobile = oCommons.EncryptInfo(oT.Mobile);
return oEntities.SP_INSERTUPDATE_EXPERT_INFO(oT.iFlag, oT.Id, oT.ExpertName, oT.DateBirthday, oT.Sex, oT.Address, oT.Description, oT.YearsExperience, oT.UniversityDegree, oT.CenterId, oT.Email, oT.Mobile, oT.ExpertCV) > 0 ? true : false;
}
public override Student_Register_Online getElementById(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_IMIC_Check_RegisterByTime().FirstOrDefault();
Student_Register_Online oRegister = new Student_Register_Online
{
CreatedTime = (DateTime)oData.CreatedTime,
UpdateDateTime = (DateTime)oData.UpdateDateTime,
UserName = oData.UserName
};
return(oRegister);
}
public List <Candidate> GetElementByIDRecruitment(int id)
{
List <Candidate> lstCan = new List <Candidate>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetCandidate_ByIdRecruitmentV2(id);
foreach (var item in lst)
{
Candidate oCan = new Candidate();
oCan.Id = item.Id;
oCan.FirstName = item.FirstName;
oCan.LastName = item.LastName;
oCan.FullName = item.FullName;
oCan.DateBirthday = item.DateBirthday;
oCan.Sex = item.Sex;
oCan.Address = item.Address;
oCan.Description = item.Description;
oCan.YearsExperience = item.YearsExperience;
oCan.UniversityDegree = item.UniversityDegree;
oCan.CenterId = item.CenterId;
oCan.Avatar = item.Avatar;
oCan.ImagePath = item.ImagePath;
oCan.Contents = item.Contents;
oCan.DocumentPath = item.DocumentPath;
oCan.DateCreate = item.DateCreate;
oCan.DateLastUpdate = item.DateLastUpdate;
oCan.DateInterview = item.DateInterview;
oCan.DateSent = item.DateSent;
oCan.Notes = item.Notes;
oCan.RecruitmentId = item.RecruitmentId;
oCan.OrderNumber = item.OrderNumber;
oCan.JobTitleId = item.JobTitleId;
oCan.Status = item.Status;
oCan.JobTitle = item.JobTitle;
oCan.Name = item.Name;
if (item.Sex == 0)
{
oCan.SexString = "Nữ";
}
else if (item.Sex == 1)
{
oCan.SexString = "Nam";
}
lstCan.Add(oCan);
}
return(lstCan);
}
public override List <CenterInfo> getElements()
{
List <CenterInfo> lstCenter = new List <CenterInfo>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_TrungTam();
foreach (var item in lst)
{
CenterInfo Center = new CenterInfo();
Center.Id = item.Id;
Center.CenterName = item.CenterName;
lstCenter.Add(Center);
}
return(lstCenter);
}
public Employee getElementById(int id)
{
Employee oEmp = new Employee()
{
Id = id
};
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var data = oEntity.SP_GetByID_Employee(oEmp.Id);
foreach (var item in data)
{
oEmp.EmployeeName = item.EmployeeName;
oEmp.Email = item.Email;
oEmp.Address = item.Address;
oEmp.Mobile = item.Mobile;
oEmp.Phone = item.Phone;
oEmp.IdentityNumber = item.IdentityNumber;
oEmp.PersonalTaxCode = item.PersonalTaxCode;
oEmp.Description = item.Description;
oEmp.PlaceOfIssue = item.PlaceOfIssue;
oEmp.PlaceBirthday = item.PlaceBirthday;
oEmp.EmployeeCV = item.EmployeeCV;
oEmp.UniversityName = item.UniversityName;
oEmp.Sex = item.Sex;
if (item.Sex == 0)
{
oEmp.SexString = "Nữ";
}
else
{
oEmp.SexString = "Nam";
}
oEmp.DateBirhday = item.DateBirhday;
oEmp.DateOfIssue = item.DateOfIssue;
oEmp.OuId = item.OuId;
oEmp.CenterId = item.CenterId;
oEmp.JobTitleId = item.JobTitleId;
return(oEmp);
}
return(null);
}
public override List <Cours> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETALL_COURSE().ToList();
List <Cours> lisCourse = new List <Cours>();
foreach (var o in oData)
{
Cours oCourse = new Cours
{
Id = o.Id,
CourseName = o.CourseName
};
lisCourse.Add(oCourse);
}
return(lisCourse.Count <= 0 ? null : lisCourse);
}
public override List <Status> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_IMIC_Get_Status().ToList();
List <Status> lisStatus = new List <Status>();
foreach (var o in oData)
{
Status oStatus = new Status
{
Id = o.Id,
StatusName = o.StatusName
};
lisStatus.Add(oStatus);
}
return(lisStatus.Count <= 0 ? null : lisStatus);
}
public override List <Ou> getElements()
{
List <Ou> lstOu = new List <Ou>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_PhongBan();
foreach (var item in lst)
{
Ou ou = new Ou();
ou.Id = item.Id;
ou.OuName = item.OuName;
lstOu.Add(ou);
}
return(lstOu);
}
public override List <Employee> getElements()
{
List <Employee> listEmployee = new List <Employee>();
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var list = oEntities.SP_GetAll_Employees();
foreach (var item in list)
{
Employee employee = new Employee();
employee.Id = item.Id;
employee.Sex = item.Sex;
if (item.Sex == 0)
{
employee.SexString = "Nữ";
}
else
{
employee.SexString = "Nam";
}
employee.Mobile = item.Mobile;
employee.Address = item.Address;
employee.CenterId = item.CenterId;
employee.DateBirhday = item.DateBirhday;
employee.DateCreate = item.DateCreate;
employee.DateLastUpdate = item.DateLastUpdate;
employee.DateOfIssue = item.DateOfIssue;
employee.DateRegister = item.DateRegister;
employee.Description = item.Description;
employee.Email = item.Email;
employee.EmployeeCV = item.EmployeeCV;
employee.EmployeeName = item.EmployeeName;
employee.CenterName = item.CenterName;
employee.OuName = item.OuName;
listEmployee.Add(employee);
}
return(listEmployee);
}
public override List <JobTitle> getElements()
{
List <JobTitle> lstJob = new List <JobTitle>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_ChucVu();
foreach (var item in lst)
{
JobTitle Job = new JobTitle();
Job.Id = item.Id;
Job.JobTitle1 = item.JobTitle;
Job.ImageName = item.ImageName;
Job.ImagePath = item.ImagePath;
Job.OrderNumber = item.OrderNumber;
lstJob.Add(Job);
}
return(lstJob);
}
public override List <RecruitmentInfo> getElements()
{
List <RecruitmentInfo> lstRec = new List <RecruitmentInfo>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_RecruitmentV2();
foreach (var item in lst)
{
RecruitmentInfo oRec = new RecruitmentInfo();
oRec.Avatar = item.Avatar;
oRec.CenterId = item.CenterId;
oRec.Contents = item.Contents;
oRec.DateCreate = item.DateCreate;
oRec.DateEnd = item.DateEnd;
oRec.DateStart = item.DateStart;
oRec.Description = item.Description;
oRec.Id = item.Id;
oRec.ImagePath = item.ImagePath;
oRec.Name = item.Name;
oRec.OrderNumber = item.OrderNumber;
oRec.Request = item.Request;
oRec.Status = item.Status;
oRec.Number = item.Number;
oRec.CenterName = item.CenterName;
if (DateTime.Compare(item.DateEnd.Value, DateTime.Now) < 0)
{
oRec.strTrangThai = "Đã hết hạn";
}
else
{
oRec.strTrangThai = "Đang diễn ra";
}
lstRec.Add(oRec);
}
return(lstRec);
}
public override List <CenterInfo> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GetAll_TrungTam().ToList();
List <CenterInfo> lstCen = new List <CenterInfo>();
foreach (var item in oData)
{
CenterInfo oCen = new CenterInfo();
oCen.Id = item.Id;
oCen.CenterName = item.CenterName;
oCen.Email = item.Email;
oCen.Description = item.Description;
oCen.Address = item.Address;
oCen.Fax = item.Fax;
oCen.Phone = item.Phone;
oCen.Mobile = item.Mobile;
oCen.Website = item.Website;
lstCen.Add(oCen);
}
return(lstCen);
}
public override StudentLists getElementById(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETSTUDENT_BYID_STUDENTS(int.Parse("" + id)).FirstOrDefault();
StudentLists oStudentLists = null;
if (oData != null || oData.Id > 0)
{
oStudentLists = new StudentLists
{
Id = oData.Id,
FullName = oData.FullName,
Sex = oData.Sex,
Mobile = oData.Mobile,
DateBirthday = oData.DateBirthday,
Email = oData.Email,
Address = oData.Address,
DateCreate = (DateTime)oData.DateCreate,
UserId = oData.UserId,
UserName = oData.UserName,
CourseId = oData.CourseId,
CourseName = oData.CourseName,
StatusId = oData.StatusId,
StatusName = oData.StatusName,
Description = oData.Description
};
if (oStudentLists.Sex == 0)
{
oStudentLists.SexString = "Nam";
}
else
{
oStudentLists.SexString = "Nữ";
}
}
return(oStudentLists);
}
public override List <Candidate> getElements()
{
List <Candidate> lstCandidate = new List <Candidate>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_Candidates();
foreach (var item in lst)
{
Candidate oCan = new Candidate();
oCan.Address = item.Address;
oCan.Avatar = item.Avatar;
oCan.CenterId = item.CenterId;
oCan.Contents = item.Contents;
oCan.DateBirthday = item.DateBirthday;
oCan.DateCreate = item.DateCreate;
oCan.DateInterview = item.DateInterview;
oCan.DateLastUpdate = item.DateLastUpdate;
oCan.DateSent = item.DateSent;
oCan.Description = item.Description;
oCan.DocumentPath = item.DocumentPath;
oCan.FirstName = item.FirstName;
oCan.FullName = item.FullName;
oCan.Id = item.Id;
oCan.ImagePath = item.ImagePath;
oCan.JobTitleId = item.JobTitleId;
oCan.LastName = item.LastName;
oCan.Notes = item.Notes;
oCan.OrderNumber = item.OrderNumber;
oCan.RecruitmentId = item.RecruitmentId;
oCan.Sex = item.Sex;
oCan.UniversityDegree = item.UniversityDegree;
oCan.YearsExperience = item.YearsExperience;
lstCandidate.Add(oCan);
}
return(lstCandidate);
}
public override List <StudentClasses> CheckElementByObject(StudentClasses oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETLITSTUDENT_BYID_CLASS_02(oT.ClassId).ToList();
List <StudentClasses> olisStudentClasses = new List <StudentClasses>();
Commons oCommons = new Commons();
foreach (var o in oData)
{
StudentClasses oStudentClasses = new StudentClasses();
oStudentClasses.Id = o.Id;
oStudentClasses.ClassId = (int)o.ClassId;
//oStudentClasses.ClassName = o.ClassName;
oStudentClasses.DateStart = (DateTime)o.DateStart;
oStudentClasses.FullName = o.FullName;
oStudentClasses.Email = string.IsNullOrEmpty(o.Email) ? "" : oCommons.DecryptInfo(o.Email);
//oStudentClasses.FullName = o.FullName;
oStudentClasses.Mobile = string.IsNullOrEmpty(o.Mobile) ? "" : oCommons.DecryptInfo(o.Mobile);
oStudentClasses.Sex = (int)o.Sex;
if (oStudentClasses.Sex == 0)
{
oStudentClasses.sSex = "Nam";
}
else
{
oStudentClasses.sSex = "Nữ";
}
//oStudentClasses.sSex = o.sSex;
oStudentClasses.StudentId = (int)o.StudentId;
oStudentClasses.TotalPrice = string.IsNullOrEmpty("" + o.TotalPrice) ? 0 : (int)o.TotalPrice;
oStudentClasses.Price1 = string.IsNullOrEmpty("" + o.Price1) ? 0 : (int)o.Price1;
oStudentClasses.Price2 = string.IsNullOrEmpty("" + o.Price2) ? 0 : (int)o.Price2;
oStudentClasses.Price3 = string.IsNullOrEmpty("" + o.Price3) ? 0 : (int)o.Price3;
oStudentClasses.MustPay = string.IsNullOrEmpty("" + o.MustPay) ? 0 : (int)o.MustPay;
olisStudentClasses.Add(oStudentClasses);
}
return(olisStudentClasses);
}
public override Candidate getElementById(object id)
{
Candidate oCan = new Candidate();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var data = oEntity.SP_GetByID_CandidateV2(int.Parse("" + id));
foreach (var item in data)
{
oCan.Id = item.Id;
oCan.FirstName = item.FirstName;
oCan.LastName = item.LastName;
oCan.FullName = item.FullName;
oCan.DateBirthday = item.DateBirthday;
oCan.Sex = item.Sex;
oCan.Address = item.Address;
oCan.Description = item.Description;
oCan.YearsExperience = item.YearsExperience;
oCan.UniversityDegree = item.UniversityDegree;
oCan.CenterId = item.CenterId;
oCan.Avatar = item.Avatar;
oCan.ImagePath = item.ImagePath;
oCan.Contents = item.Contents;
oCan.DocumentPath = item.DocumentPath;
oCan.DateCreate = item.DateCreate;
oCan.DateLastUpdate = item.DateLastUpdate;
oCan.DateInterview = item.DateInterview;
oCan.DateSent = item.DateSent;
oCan.Notes = item.Notes;
oCan.RecruitmentId = item.RecruitmentId;
oCan.OrderNumber = item.OrderNumber;
oCan.JobTitleId = item.JobTitleId;
oCan.Status = item.Status;
oCan.JobTitle = item.JobTitle;
}
return(oCan);
}
public override Classes getElementById(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETELEMENT_BYID_CLASSES((int)id).ToList();
List <Classes> lisClasses = new List <Classes>();
foreach (var o in oData)
{
Classes oClasses = new Classes
{
Id = o.Id,
ClassName = o.ClassName,
FromDate = o.FromDate,
ToDate = o.ToDate,
PlaceTraining = o.PlaceTraining,
NumberStudents = o.NumberStudents,
Description = o.Description,
Status = o.Status
};
return(oClasses);
}
return(null);
}
public override List <Classes> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETALL_AYEAR_CLASS().ToList();
List <Classes> lisClasses = new List <Classes>();
foreach (var o in oData)
{
Classes oClasses = new Classes
{
Id = o.Id,
ClassName = o.ClassName,
FromDate = o.FromDate,
ToDate = o.ToDate,
PlaceTraining = o.PlaceTraining,
NumberStudents = o.NumberStudents,
Description = o.Description,
Status = o.Status
};
lisClasses.Add(oClasses);
}
return(lisClasses);
}
public override List <CommentSupport> CheckElementById(object Id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETELEMENTSBYIDSTUDENT_COMMONTSUPPORT((int)Id).ToList();
List <CommentSupport> lisComment = new List <CommentSupport>();
foreach (var o in oData)
{
CommentSupport oComment = new CommentSupport
{
Id = o.Id,
CommentName = o.CommentName,
Desription = o.Desription,
UserId = o.UserId,
UserName = o.UserName,
DateLastUpdate = o.DateLastUpdate
};
lisComment.Add(oComment);
}
return(lisComment.Count <= 0 ? null : lisComment);
}
public bool InsertAndUpdateNoEncrypt(StudentLists oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
byte bOption = 0;
if (oT.Id == 0)
{
bOption = 1; //Insert
}
else
{
bOption = 0; //Update
}
Commons oCommons = new Commons();
oEntities.SP_Insert_Update_Student(bOption, oT.Id, oT.FirstName, oT.LastName, oT.FullName, oT.Sex,
string.IsNullOrEmpty(oT.Mobile) ? ""
: oT.Mobile, oT.DateBirthday,
string.IsNullOrEmpty(oT.Email) ? ""
: oT.Email, oT.Address,
oT.DateCreate, oT.UserId, oT.CourseId, oT.StatusId,
oT.Description);
return(true);
}
public override List <OfflineStudentRegisters> getElementByTime(DateTime dtStartTime, DateTime dtEndTime)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_IMIC_Student_Register_Offline_ByTimes(dtStartTime, dtEndTime).ToList();
List <OfflineStudentRegisters> lisOffRegister = new List <OfflineStudentRegisters>();
Commons oCommons = new Commons(mAcount);
foreach (var o in oData)
{
OfflineStudentRegisters oRegister = new OfflineStudentRegisters();
oRegister.RegisterDetailId = o.RegisterDetailId;
oRegister.FullName = o.FullName;
oRegister.Email = oCommons.DecryptInfo(o.Email);
oRegister.Phone = oCommons.DecryptInfo(o.Phone);
oRegister.Message = o.Message;
oRegister.Address = o.Address;
oRegister.CreatedTime = (DateTime)o.CreatedTime;
oRegister.UpdateDateTime = (DateTime)o.UpdateDateTime;
oRegister.UserName = o.UserName;
lisOffRegister.Add(oRegister);
}
return(lisOffRegister.Count <= 0 ? null : lisOffRegister);
}
public override bool DeleteElement(object id)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Delete_Candidate(int.Parse("" + id)) > 0?true:false);
}
public override bool DeleteElement(Employee oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Delete_Employee(oT.Id) > 0?true:false);
}
public override bool UpdateElement(stanfTabPermission o)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_UPDATE_TABPERMISSION(o.TabPermissionId, o.LastModifiedByUserId, o.IsList, o.IsAdd, o.IsEdit, o.IsDelete, o.IsReport) > 0);
}
public override bool DeleteElement(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
return oEntities.SP_DELETE_EXPERTINFO_XOA((int)id) > 0 ? true : false ;
}
public override bool DeleteElement(Account oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntities.SP_DELETE_USER(oT.UserId) > 0);
}
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);
}
}
