public StudentEntity Create(StudentExcelModel StudentExcelModel) { var userEntity = new UserEntity(); userEntity.Password = StudentExcelModel.Password; userEntity.Username = StudentExcelModel.UserName.Trim(); UserService.Create(userEntity); var users = context.Users.Where(u => u.Username == userEntity.Username).ToList(); if (users.Count > 1) { throw new BadRequestException("Trung sinh vien"); } var user = users.FirstOrDefault(); user.Role = 8; context.SaveChanges(); //Create User var newStudentEntity = new StudentEntity(); newStudentEntity = StudentExcelModel.ToEntity(newStudentEntity); newStudentEntity.Id = user.Id; var newStudent = new Student(newStudentEntity); context.Students.Add(newStudent); context.SaveChanges(); return(newStudentEntity); }
public List <StudentEntity> CreateFromExcel(byte[] data) { List <StudentEntity> StudentEntities = new List <StudentEntity>(); if (data != null) { List <StudentExcelModel> StudentExcelModels = ConvertToIEnumrable <StudentExcelModel>(data).ToList(); foreach (var StudentExcelModel in StudentExcelModels.Where(sem => sem.Name != null)) { //Create user var userEntity = new UserEntity(); userEntity.Password = StudentExcelModel.Password; userEntity.Username = StudentExcelModel.UserName.Trim(); UserService.Create(userEntity); context.SaveChanges(); var users = context.Users.Where(u => u.Username == userEntity.Username).ToList(); if (users.Count > 1) { throw new BadRequestException("Trung sinh vien co MSSV la " + userEntity.Username); } var user = users.First(); user.Role = 8; context.SaveChanges(); //Create Entity var newStudentEntity = new StudentEntity(); newStudentEntity = StudentExcelModel.ToEntity(newStudentEntity); newStudentEntity.Id = user.Id; var newStudent = new Student(newStudentEntity); context.Students.Add(newStudent); StudentEntities.Add(new StudentEntity(newStudent)); } context.SaveChanges(); } return(StudentEntities); }