public List <StudentRegisterModel> GetAllRegNo()
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "SELECT StudentRegId FROM [Student.Register]";
SqlCommand command = new SqlCommand(query, connection);
List <StudentRegisterModel> RegNoList = new List <StudentRegisterModel>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// if (reader.HasRows)
//{
while (reader.Read())
{
StudentRegisterModel viewResult = new StudentRegisterModel();
//studentRegister.StudentId = int.Parse(reader["StudentId"].ToString());
//registerStudent.GradeLaterId = Convert.ToInt32(reader["GradeLaterId"]);
viewResult.StudentRegId = reader["StudentRegId"].ToString();
RegNoList.Add(viewResult);
}
reader.Close();
// }
connection.Close();
return(RegNoList);
}
public IActionResult Register()
{
StudentRegisterModel model = new StudentRegisterModel();
model = LoadModel(ref model);
return(View(model));
}
protected StudentRegisterModel LoadModel(ref StudentRegisterModel model)
{
model.States = _classBookModelFactory.PrepareStateDropDown();
model.GenderList = _classBookModelFactory.PrepareGenderDropDown();
model.BoardList = _classBookModelFactory.PrepareBoardDropDown();
model.MediumList = _classBookModelFactory.PrepareMediumDropDown();
model.StandardList = _classBookModelFactory.PrepareStandardDropDown();
return(model);
}
public IActionResult Register(StudentRegisterModel model)
{
try
{
if (ModelState.IsValid)
{
var singleUser = _context.Users.Where(x => x.Email == model.Email).AsNoTracking();
if (!singleUser.Any())
{
List <IFormFile> list = new List <IFormFile>();
if (model.ImageFile != null)
{
list.Add(model.ImageFile);
}
Student studentData = new Student()
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
Email = model.Email,
Gender = Enum.GetName(typeof(Gender), model.GenderId),
DOB = model.DOB,
StateId = model.StateId,
CityId = model.CityId,
ContactNo = model.ContactNo,
Pincode = model.PincodeId,
BoardId = model.BoardId,
MediumId = model.MediumId,
StandardId = model.StandardId
};
(int studentId, string uniqueNo) = _classBookService.SaveStudent(studentData, list);
string UserName = studentData.FirstName + studentData.LastName + uniqueNo;
var user = _classBookService.SaveUserData(studentId, Module.Student, UserName, studentData.Email);
_classBookService.SendVerificationLinkEmail(studentData.Email, user.Password, Module.Student.ToString());
return(RedirectToAction("Register"));
}
else
{
ModelState.AddModelError("Email", "Email Id Already Exist");
model = LoadModel(ref model);
}
return(View(model));
}
else
{
model = LoadModel(ref model);
return(View(model));
}
}
catch (Exception ex)
{
_logsService.InsertLogs("Student", ex, "Student", 0);
return(RedirectToAction("Register"));
}
}
//registration service funtion
public async Task <bool> RegistrationService(StudentRegisterModel registerModel)
{
try
{
//validation functions
var context = new ValidationContext(registerModel, serviceProvider: null, items: null);
var results = new List <ValidationResult>();
if (Validator.TryValidateObject(registerModel, context, results, true))
{
if (CheckEmailAvailability(registerModel.Email))
{
if (registerModel.Password != registerModel.ConfirmPassword)
{
return(false);
}
Student student = new Student
{
FirstName = registerModel.FirstName,
LastName = registerModel.LastName,
Email = registerModel.Email,
Guardian = registerModel.Guardian,
Address = new Address
{
Number = registerModel.Address1,
Street = registerModel.Address2,
Town = registerModel.Address3
},
DateOfBirth = registerModel.DateOfBirth,
AdminPermition = false
};
User user = new User
{
Email = registerModel.Email,
Password = Encoder(registerModel.Password),
UserRole = Role.Student
};
_context.Add(student);
_context.Add(user);
await _context.SaveChangesAsync();
return(true);
}
}
return(false);
}
catch
{
return(false);
}
}
public int SaveStudent(StudentRegisterModel student, string registrationNo)
{
int rowAffected = 0;
SqlConnection connection = new SqlConnection(connectionDB);
string query = @"INSERT INTO [Student.Register] (StudentRegId,StudentName,Email,ContactNo,RegisterDate,Address,DepartmentId,InsertDate)
VALUES ('" + registrationNo + "','" + student.StudentName + "','" + student.Email + "','" + student.ContactNo + "','" + student.RegisterDate + "','" + student.Address + "','" + student.DepartmentId + "',GETDATE())";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public IActionResult RegisterStudent([FromBody] StudentRegisterModel model)
{
var student = _mapper.Map <Student>(model);
try
{
_studentService.Create(student, model.Password);
return(Ok());
}
catch (AppException ex)
{
return(BadRequest(new { message = ex.Message }));
}
}
public async Task <ActionResult> Register([FromBody] StudentRegisterModel studentRegisterModel)
{
try
{
if (await _accountService.RegistrationService(studentRegisterModel))
{
return(Ok());
}
return(BadRequest());
}
catch
{
return(BadRequest());
}
}
public ActionResult Add(StudentRegisterModel modelStudent)
{
var studentModel = Mapper.Map <StudentRegisterModel, Student>(modelStudent);
studentModel.Tutor1 = _parentRepository.GetById(modelStudent.FirstParent);
studentModel.Tutor2 = _parentRepository.GetById(modelStudent.SecondParent);
var myStudent = _studentRepository.GenerateStudentFromRegisterModel(studentModel);
myStudent.MyUser = studentModel.Tutor1.MyUser;
_studentRepository.Create(myStudent);
const string title = "Estudiante Agregado";
var content = "El estudiante " + myStudent.FullName + " ha sido agregado exitosamente.";
_viewMessageLogic.SetNewMessage(title, content, ViewMessageType.SuccessMessage);
return(RedirectToAction("Index"));
}
public ActionResult StudentRegister(StudentRegisterModel student)
{
string registrationNo = "";
string registerYear = studentRegisterManager.GetStudentRegisteryear(student.DepartmentId);
string currentYear = DateTime.Now.Year.ToString();
if (registerYear == currentYear)
{
string deppartmentCode = studentRegisterManager.GetDepartmentCode(student.DepartmentId);
//generate registration number
var code = deppartmentCode.Substring(0, 3);
var year = DateTime.Now.Year;
int no = studentRegisterManager.GetNo(student.DepartmentId);
//int no = studentRegisterManager.GetNo(student);
no = no + 1;
registrationNo = (code + "-" + year + "-") + (no.ToString().PadLeft(3, '0'));
}
else
{
string deppartmentCode = studentRegisterManager.GetDepartmentCode(student.DepartmentId);
//generate registration number
var code = deppartmentCode.Substring(0, 3);
var year = DateTime.Now.Year;
int no = 0;
//studentRegisterManager.GetNo(student.DepartmentId);
//int no = studentRegisterManager.GetNo(student);
no = no + 1;
registrationNo = (code + "-" + year + "-") + (no.ToString().PadLeft(3, '0'));
}
//-----------------------
if (student.ContactNo.Length == 11)
{
studentRegisterManager.SaveStudent(student, registrationNo);
ViewBag.message = "Saved Successfully";
StudentRegisterViewModel allRegisterStudent = studentRegisterManager.GetAllStudentRegister(registrationNo);
ViewBag.AllRegisterStudent = allRegisterStudent;
}
else
{
ViewBag.message = "Enter a valid 11 digit number";
}
ViewBag.Departments = departmentManager.GetDepartment();
//ViewBag.PostBack = true;
return(View());
}
private async Task AddStudent(StudentRegisterModel studentRegisterModel)
{
var student = await _applicationDbContext.TbStudent.FindAsync(studentRegisterModel.StudentId);
if (student == null)
{
throw new ArgumentException($"Invalid student {studentRegisterModel.StudentId}");
}
await _applicationDbContext.AddAsync(new TbStudentAttendance
{
Attended = studentRegisterModel.Present,
StudentId = studentRegisterModel.StudentId,
Date = DateTime.Now
});
}
public ActionResult Add(StudentRegisterModel modelStudent)
{
var studentModel = Mapper.Map <StudentRegisterModel, Student>(modelStudent);
if (
_studentRepository.Filter(
x => x.AccountNumber.Equals(modelStudent.AccountNumber) || x.IdNumber.Equals(modelStudent.IdNumber))
.Any())
{
_viewMessageLogic.SetNewMessage("Dato Inválido", "Ya existe un estudiante con ese número de Identidad o de cuenta", ViewMessageType.ErrorMessage);
return(RedirectToAction("Index"));
}
_studentRepository.Create(studentModel);
const string title = "Estudiante Agregado";
var content = "El estudiante " + studentModel.FullName + " ha sido agregado exitosamente.";
_viewMessageLogic.SetNewMessage(title, content, ViewMessageType.SuccessMessage);
return(RedirectToAction("Add"));
}
public ActionResult Create(StudentRegisterModel student)
{
if (ModelState.IsValid)
{
try
{
WebSecurity.CreateUserAndAccount(student.UserName, student.Password, new { Discriminator = "Student",
Name = student.Name,
Surname = student.Surname,
Email = student.Email, });
Roles.AddUserToRole(student.UserName, "Student");
return(RedirectToAction("List", "Student"));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", LoginMessagesHelper.ErrorCodeToString(e.StatusCode));
}
}
ViewBag.ClassId = new SelectList(context.Classes, "Id", "Name");
return(View(student));
}
public ActionResult Register(StudentRegisterModel model)
{
using (var client = new HttpClient())
{
var json = JsonConvert.SerializeObject(model);
var data = new StringContent(json, Encoding.UTF8, "application/json");
//HTTP POST
var postTask = client.PostAsync("Student/Register", data);
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Login"));
}
}
ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
return(View(model));
}
public async Task <IActionResult> StudentRegister(StudentRegisterModel model)
{
if (ModelState.IsValid)
{
Student student = await db.Students.FirstOrDefaultAsync(s => s.StudentId == model.StudentId);
if (student == null)
{
if (HttpContext.Session.Keys.Contains("student"))
{
await LogoutWithoutRedirect();
HttpContext.Session.Remove("student");
}
Student s = new Student {
StudentId = model.StudentId, Email = model.Email, Password = HashPassword(model.Password)
};
db.Students.Add(s);
await db.SaveChangesAsync();
await Authenticate(model.StudentId.ToString());
TempData.Put("studentik", s);
if (s.Email != null)
{
// SendEmailAsync(s.Email, false).GetAwaiter();
}
return(RedirectToAction("Personal", "Student"));
}
else
{
ViewBag.ErrorMessage = $"Student with Id = {student.StudentId} already exists.";
}
}
return(View(model));
}
public async Task <ResponseModel> RegisterAsync(StudentRegisterModel studentRegisterModel)
{
var student = _mapper.Map <Student>(studentRegisterModel);
studentRegisterModel.Password.GeneratePassword(out string saltKey, out string hashPass);
student.Password = hashPass;
student.PasswordSalt = saltKey;
// tạo CertificateStatus cho student
var certificateStatus = new CertificateStatus();
// gán id cho student
student.CertificateStatusId = certificateStatus.Id;
_certificateStatusRepository.GetDbContext().CertificateStatuses.Add(certificateStatus);
await _certificateStatusRepository.GetDbContext().SaveChangesAsync();
await _studentRepository.InsertAsync(student);
//var studentInRoles = new List<StudentInRole>();
//foreach (var roleId in studentRegisterModel.RoleIds)
//{
// studentInRoles.Add(new StudentInRole()
// {
// StudentId = student.Id,
// RoleId = roleId
// });
//}
//_studentInRoleRepository.GetDbContext().StudentInRoles.AddRange(studentInRoles);
//await _studentInRoleRepository.GetDbContext().SaveChangesAsync();
student = await GetAll().FirstOrDefaultAsync(x => x.Id == student.Id);
return(new ResponseModel()
{
StatusCode = System.Net.HttpStatusCode.OK,
Data = new StudentViewModel(student),
});
}
public ActionResult StudentRegister()
{
var studentRegisterModel = new StudentRegisterModel
{
SchoolName = new List <SelectListItem>()
{
// First element has to be empty in order to display placeholder, otherwise it would automatically select the first option
new SelectListItem()
{
},
new SelectListItem()
{
Selected = false, Text = "Ostrava", Value = "1"
},
new SelectListItem()
{
Selected = false, Text = "Opava", Value = "2"
}
},
ClassName = new List <SelectListItem>()
{
// First element has to be empty in order to display placeholder, otherwise it would automatically select the first option
new SelectListItem()
{
},
new SelectListItem()
{
Selected = false, Text = "1A", Value = "1"
},
new SelectListItem()
{
Selected = false, Text = "2A", Value = "2"
}
}
};
return(View(studentRegisterModel));
}
public Student GenerateStudentFromRegisterModel(StudentRegisterModel studentRegisterModel)
{
return(new Student
{
FirstName = studentRegisterModel.FirstName,
LastName = studentRegisterModel.LastName,
FullName = (studentRegisterModel.FirstName + " " + studentRegisterModel.LastName).Trim(),
IdNumber = studentRegisterModel.IdNumber,
BirthDate = studentRegisterModel.BirthDate,
Gender = Utilities.IsMasculino(studentRegisterModel.Gender),
Nationality = studentRegisterModel.Nationality,
State = studentRegisterModel.State,
Country = studentRegisterModel.Country,
City = studentRegisterModel.City,
Address = studentRegisterModel.Address,
Biography = studentRegisterModel.Biography,
StartDate = studentRegisterModel.StartDate,
BloodType = studentRegisterModel.BloodType,
AccountNumber = studentRegisterModel.AccountNumber,
Tutor1 = studentRegisterModel.FirstParent,
Tutor2 = studentRegisterModel.SecondParent,
});
}
public ActionResult StudentRegister()
{
var userId = User.Identity.GetUserId();
return(View(StudentRegisterModel.StudentRegister(userId)));
}
public async Task <IActionResult> RegisterStudent([FromBody] StudentRegisterModel studentRegisterModel)
{
var responseModel = await _studentService.RegisterAsync(studentRegisterModel);
return(new CustomActionResult(responseModel));
}
public int SaveStudent(StudentRegisterModel student, string registrationNo)
{
return(studentRegisterGateway.SaveStudent(student, registrationNo));
}
