public ActionResult StudentAction(int?id)
{
ViewBag.drpStudentRole = CommonController.drpStudentRole();
if (id != 0)
{
Student datasetStudent = entities.Students.Find(id);
User datsetUser = entities.Users.Find(datasetStudent.UserID);
UserStudent dataset = new UserStudent();
dataset.UserID = datsetUser.UserID;
dataset.FirstName = datsetUser.FirstName;
dataset.LastName = datsetUser.LastName;
dataset.DOB = datsetUser.DOB;
dataset.Email = datsetUser.Email;
dataset.Phone = datsetUser.Phone;
dataset.Password = datsetUser.Password;
dataset.Address = datsetUser.Address;
dataset.StudentID = datasetStudent.StudentID;
dataset.ParentName = datasetStudent.ParentName;
dataset.ParentEmail = datasetStudent.ParentEmail;
dataset.ParentPhone = datasetStudent.ParentPhone;
dataset.ParentAddrsss = datasetStudent.ParentAddrsss;
dataset.UserRoleID = datasetStudent.User.UserRoleID;
return(PartialView(dataset));
}
else
{
return(PartialView());
}
}
static void Main(string[] args)
{
Popullate.AddRandomData();
Popullate.AddRandomData2();
Console.WriteLine("###passwords for evaluator:");
Console.WriteLine("###Head-Master account - surname:Pasparakis password:giopas");
Console.WriteLine("###Student account - surname:Georgilas password:vasgeo");
Console.WriteLine("###Trainer account - surname:Nikolaidis password:micnik");
Console.WriteLine("###Trainer account - surname:Vasileiadis password:vyrvas");
Console.WriteLine("###You can also see the class POPULLATE to see all the initial data and passwords");
Console.WriteLine("\n");
Passwords P = new Passwords();
P.PasswordTry();
if (P.type_user == "Student")
{
UserStudent.MenouStudent(P.user_id);
}
if (P.type_user == "Trainer")
{
UserTrainer.MenouTrainer(P.user_id);
}
if (P.type_user == "Head_Master")
{
UserHeadMaster.MenouHeadMaster(P.user_id);
}
}
public async Task <Student> AddStudentAsync(Guid userId, Student newStudent)
{
Student studentFullEqual = await _db.Students.Where(
s => s.Name == newStudent.Name &&
s.Patronymic == newStudent.Patronymic &&
s.Sex == newStudent.Sex &&
s.Surname == newStudent.Surname &&
s.StudentID == newStudent.StudentID).FirstOrDefaultAsync();
Student studentWithEqualStudentId = null;
if (newStudent.StudentID != null)
{
studentWithEqualStudentId = await _db.Students.Where(s => s.StudentID == newStudent.StudentID).FirstOrDefaultAsync();
}
if (studentFullEqual == null && studentWithEqualStudentId != null)
{
return(null);
}
UserStudent currentUserStudentDependence = null;
if (studentFullEqual != null)
{
currentUserStudentDependence = await _db.UserStudents.Where(us => us.UserId == userId && us.StudentId == studentFullEqual.Id).FirstOrDefaultAsync();
}
if (currentUserStudentDependence != null && studentFullEqual != null)
{
return(studentFullEqual);
}
if (studentFullEqual == null)
{
studentFullEqual = new Student()
{
Id = Guid.NewGuid(),
Name = newStudent.Name,
Patronymic = newStudent.Patronymic,
Sex = newStudent.Sex,
StudentID = newStudent.StudentID,
Surname = newStudent.Surname
};
_db.Students.Add(studentFullEqual);
}
_db.UserStudents.Add(new UserStudent()
{
StudentId = studentFullEqual.Id, UserId = userId
});
await _db.SaveChangesAsync();
return(studentFullEqual);
}
public void TestSayGoodmorning()
{
// Arrange
var student = new UserStudent();
// Act
var result = student.SayGoodmorning();
// Assert
Assert.IsNotNull(result);
}
public async Task <UserStudent> postAsync(UsersRequest request)
{
scriptPass script = new scriptPass();
UserStudent model = new UserStudent();
model.Email = request.Email;
model.Role = await _roleRepository.GetByIdAsync(request.RoleId);
model.Password = script.script(request.Password);
return(await _repository.PostAsync(model));
}
private bool addProfile()
{
DBCContext db = new DBCContext();
if ((textBoxFName.Text == "") || (textBoxLName.Text == "") || (passwordBoxPassword.Password == "") || (passwordBoxPasswordrepeat.Password == "") || (textBoxLogin.Text == ""))
{
MessageBox.Show("Необходимо заполнить все поля!");
return(false);
}
else
{
if ((passwordBoxPassword.Password == passwordBoxPasswordrepeat.Password) && (passwordBoxPassword.Password != "") && (passwordBoxPasswordrepeat.Password != ""))
{
var authoriz = from p in db.Users
where p.Login == textBoxLogin.Text
select p;
if (authoriz.Count() > 0)
{
MessageBox.Show("Введеный Логин уже занять.");
return(false);
}
else
{
try
{
User u1 = new User {
Login = textBoxLogin.Text, Password = passwordBoxPassword.Password, IDRole = 2
};
db.Users.Add(u1);
UserStudent uS1 = new UserStudent {
IDUser = u1.IDUser, FirstName = textBoxFName.Text, LastName = textBoxLName.Text, IDGroup = comboBoxGroup.SelectedIndex + 1
};
db.UserStudents.Add(uS1);
db.SaveChanges();
MessageBox.Show("Регистрация прошла успешно!");
return(true);
}
catch
{
MessageBox.Show("Возникло исключение!");
return(false);
}
}
}
else
{
MessageBox.Show("Введеные пароли не совпадают! Пожалуйста, убедитесь в правильности ввода паролей.");
return(false);
}
}
}
public async Task <ActionResult> Edit([Bind(Include = "user,student,ClassID, ParentID")] UserStudent us)
{
if (ModelState.IsValid)
{
//putting RoleID of student in User
var role = db.Roles.Where(x => x.RoleName == "Student").FirstOrDefault();
us.user.RoleID = role.RoleID;
us.student.UserID = us.user.UserID;
db.Entry(us.student).State = EntityState.Modified;
db.Entry(us.user).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ClassID = new SelectList(db.Classes, "ClassID", "ClassName", us.student.ClassID);
ViewBag.ParentID = new SelectList(db.Parents, "ParentID", "FatherName", us.student.ParentID);
return(View(us));
}
// GET: Students/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = await db.Users.FindAsync(id);
Student student = await db.Students.SingleOrDefaultAsync(x => x.UserID == id);
UserStudent us = new UserStudent();
us.user = user;
us.student = student;
if (user == null && student == null)
{
return(HttpNotFound());
}
return(View(us));
}
public async Task <bool> Login(UsersRequest request)
{
UserStudent model = await _repository.GetByEmail(request.Email);
if (model == null)
{
return(false);
}
scriptPass script = new scriptPass();
request.Password = script.script(request.Password);
if (model.Password != request.Password)
{
return(false);
}
return(true);
}
// GET: Students/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = await db.Users.FindAsync(id);
Student student = await db.Students.Where(x => x.UserID == id).FirstOrDefaultAsync();
if (user == null)
{
return(HttpNotFound());
}
UserStudent us = new UserStudent();
us.user = user;
us.student = student;
ViewBag.ClassID = new SelectList(db.Classes, "ClassID", "ClassName", us.student.ClassID);
ViewBag.ParentID = new SelectList(db.Parents, "ParentID", "FatherName", us.student.ParentID);
return(View(us));
}
public ActionResult StudentAction(UserStudent userstudent)
{
ModelState.Remove("UserID");
ModelState.Remove("StudentID");
if (ModelState.IsValid)
{
string msg = "";
if (userstudent.StudentID > 0)
{
var datasetStudent = entities.Students.Where(f => f.StudentID == userstudent.StudentID).FirstOrDefault();
var datasetUser = entities.Users.Where(f => f.UserID == datasetStudent.UserID).FirstOrDefault();
if (datasetStudent != null && datasetUser != null)
{
datasetStudent.ParentName = userstudent.ParentName;
datasetStudent.ParentAddrsss = userstudent.ParentAddrsss;
datasetStudent.ParentEmail = userstudent.ParentEmail;
datasetStudent.ParentPhone = userstudent.ParentPhone;
datasetUser.FirstName = userstudent.FirstName;
datasetUser.LastName = userstudent.LastName;
datasetUser.DOB = userstudent.DOB;
datasetUser.Email = userstudent.Email;
datasetUser.Phone = userstudent.Phone;
datasetUser.Address = userstudent.Address;
datasetUser.Password = userstudent.Password;
datasetUser.UserRoleID = userstudent.UserRoleID;
entities.SaveChanges();
msg = "Student details Updated Successfully";
}
}
else
{
User datasetUser = new User();
datasetUser.FirstName = userstudent.FirstName;
datasetUser.LastName = userstudent.LastName;
datasetUser.DOB = userstudent.DOB;
datasetUser.Email = userstudent.Email;
datasetUser.Phone = userstudent.Phone;
datasetUser.Address = userstudent.Address;
datasetUser.Password = userstudent.Password;
datasetUser.UserRoleID = userstudent.UserRoleID;
entities.Users.Add(datasetUser);
Student datasetStudent = new Student();
int id = userstudent.UserID;
datasetStudent.UserID = id;
datasetStudent.ParentName = userstudent.ParentName;
datasetStudent.ParentAddrsss = userstudent.ParentAddrsss;
datasetStudent.ParentEmail = userstudent.ParentEmail;
datasetStudent.ParentPhone = userstudent.ParentPhone;
entities.Students.Add(datasetStudent);
entities.SaveChanges();
msg = "New Student Added successfully";
}
return(new JsonResult
{
Data = new
{
success = true,
action = "Student",
message = msg
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
ViewBag.drpStudentRole = CommonController.drpStudentRole();
return(PartialView(userstudent));
}
public async Task <ActionResult> ConfirmStudentEnrollment(StudentRegistrationViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser
{
FirstName = model.FirstName,
LastName = model.LastName,
DateOfBirth = model.DateOfBirth,
Nationality = model.Nationality,
CityOfBirth = model.CityOfBirth,
Email = model.Email,
Address = model.Address,
CityOfResidence = model.CityOfResidence,
PhoneNumber = model.PhoneNumber,
UserName = model.Email,
HighSchool = model.HighSchool,
HighSchoolOption = model.HighSchoolOption,
HighSchoolMark = model.HighSchoolMark,
HighSchoolGraduateYear = model.HighSchoolGraduateYear,
CurrentYear = model.CurrentYear,
Department = model.Department,
Faculty = model.Faculty,
YearOfEnrolement = model.YearOfEnrolement,
SerialNumber = model.SerialNumber,
};
var optionsBuilder = new DbContextOptionsBuilder <AppDbContext>();
var unitOfWork = new UnitOfWork(new AppDbContext(optionsBuilder.Options));
var result = await userManager.CreateAsync(user, "Fantabamba25?!1_");
if (result.Succeeded)
{
TempData["enrolementState"] = "succeed";
TempData["Message"] = $"L'inscription de l'étudiant {user.FirstName} {user.LastName} a été completée avec succes";
var student = new UserStudent();
var department = unitOfWork.Departments.Find(d => d.DepartmentName == model.Department).FirstOrDefault();
student.DepartmentCode = department.DepartmentCode;
// student.Department = department;
student.SerialNumber = model.SerialNumber;
student.Profile = model.StudentProfile;
student.PartTime = model.PartTime == "SI" ? true : false;
student.Email = model.Email;
student.DepartmentCode = department.DepartmentCode;
unitOfWork.UserStudents.Add(student);
var role = await roleManager.FindByNameAsync("Student");
if (role == null)
{
role = new IdentityRole();
role.Name = "Student";
var result1 = await roleManager.CreateAsync(role);
if (!result1.Succeeded)
{
ViewBag.Error = $"Une erreur est survenue durant la creation du role Etudiant!";
return(View(model));
}
}
var result2 = await userManager.AddToRoleAsync(user, "Student");
if (!result2.Succeeded)
{
ViewBag.Error = $"Impossible d'ajouter l'utilisateur {user.FirstName} {user.LastName} au role Secrétaire";
return(View(model));
}
unitOfWork.Complete();
// SendEmailConfirmation(student.Email);
return(RedirectToAction("Index", "StudentRegistration"));
}
}
return(View());
}
