public ActionResult TeacherIn(String fileName) //Excel导入教师信息
{
myTBsys.TeacherIn teacherIn = new TeacherIn();
bool res = teacherIn.Click(fileName);
db.SaveChanges();
return(RedirectToAction("DataIn"));
}
public async Task <IActionResult> TeacherRegister(TeacherIn teacher)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
foreach (var item in teacher.phones)
{
if (String.IsNullOrEmpty(item.phone_number))
{
return(BadRequest(new { errorText = "Empty phone field!" }));
}
}
byte[] salt = PasswordManager.GenerateSalt_128();
string saltStr = Encoding.ASCII.GetString(salt);
Teachers withId = new Teachers();
withId.name = teacher.name;
withId.surname = teacher.surname;
withId.lastname = teacher.lastname;
withId.email = teacher.email;
withId.work_begin = DateTime.Now;
withId.work_exp = 0;
withId.hash = PasswordManager.PasswordSaveHashing(teacher.Password_temp, salt);
withId.salt = saltStr;
_context.Teachers.Add(withId);
_context.SaveChanges();
int id = withId.id_teacher;
foreach (Models.Teacher.PhonesIn phone in teacher.phones)
{
await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO Teacher_phones VALUES ({phone.phone_number}, {id});");
}
//await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO Teachers VALUES ({null}, {teacher.name}, {teacher.surname}, {teacher.lastname}, {teacher.email}, {DateTime.Now}, {0}, {PasswordManager.PasswordSaveHashing(teacher.Password_temp, salt)} , {saltStr});");
return(Ok());
}
