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