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