// Populate Student View Model
public StudentViewModel PopulateViewModel(StudentViewModel viewModel)
{
viewModel.CourseOfferings = _courseService.GetAllCourseOfferings();
viewModel.CourseOfferings.Sort(new CourseOfferingComparer());
return viewModel;
}
public ActionResult Add(StudentViewModel input)
{
// Populate VM
var viewModel = PopulateViewModel(input);
// Validate model state
if (!ModelState.IsValid) return View(input);
// Attempt to add the student to the database/course offering
try
{
// Get the created student from the factory
var studentFactory = new StudentFactory();
var student = studentFactory.CreateStudent(input.Number, input.Name, input.Type);
// Get the course offering
var offering = _courseService.GetCourseOffering(input.SelectedCourseId, input.SelectedYear, input.SelectedSemester);
// Add the student
_courseService.AddStudent(student, offering);
}
catch (Exception)
{
TempData["Error"] = "Something went wrong";
}
return RedirectToAction("Add", viewModel);
}
// GET: Students/Create
public ActionResult Create()
{
var viewModel = new StudentViewModel();
var classes = db.SchoolClasses.ToList();
viewModel.Classes = db.SchoolClasses.Select(x => new SelectListItem { Value=x.SchoolClassId.ToString(), Text=x.Name }).ToList<SelectListItem>();
return View(viewModel);
}
public ActionResult Edit(StudentViewModel model)
{
if (!ModelState.IsValid)
return View(model);
var edited = DecomposeStudentViewModel(model);
StudentManager.Update(edited);
return RedirectToAction("List");
}
public PartialViewResult GetStudentsInOffering(string offeringId, int year, string semester)
{
// Get the selected course offering
var offering = _courseService.GetCourseOffering(offeringId, year, semester);
// Get students in offering and sort based out custom comparer
var students = _courseService.GetAllStudentsByOffering(offering);
students.Sort(StudentComparer.CustomSort);
// Update view model with students in course offering
var viewModel = new StudentViewModel()
{
Students = students
};
return PartialView("_DisplayStudents", viewModel);
}
public ActionResult StudentsUpdate([DataSourceRequest]DataSourceRequest request, StudentViewModel student)
{
StudentViewModel result = null;
if (this.ModelState.IsValid)
{
var entity = this.Mapper.Map<StudentInfo>(student);
this.students.Update(entity);
result = this.Mapper.Map<StudentViewModel>(this.students.GetById(entity.StudentId));
}
if (result != null)
{
return this.Json(new[] { result }.ToDataSourceResult(request, this.ModelState));
}
return this.Json(new[] { student }.ToDataSourceResult(request, this.ModelState));
}
public ApplicationViewModel(MainWindow mainWindow, IEventAggregator eventAggregator, ISettingsService settingsService,
CollegeViewModel collegeVM, StudentViewModel studentVM,
Func<IndividualCollegeViewModel> individualCollegeVM, Func<IndividualStudentViewModel> individualStudentVM)
{
this.CurrentView = mainWindow;
this.CurrentView.DataContext = this;
this._eventAggregator = eventAggregator;
this._settingsService = settingsService;
this._collegeVM = collegeVM;
this._studentVM = studentVM;
this._individualCollegeVMFactory = individualCollegeVM;
this._individualStudentVMFactory = individualStudentVM;
AddColleges();
AddStudentsToColleges();
UserControl ucStudentDetails = this.CurrentView.FindName("ucStudentDetails") as UserControl;
_studentGridView = ucStudentDetails.FindName("rgvStudentList") as RadGridView;
this.CurrentView.Show();
}
public void GivenBuilder_WhenCallingBuildImplicitly_ThenReturnAnObject()
{
StudentViewModel viewModel = Builder <StudentViewModel> .CreateNew();
viewModel.ShouldBeOfType <StudentViewModel>();
}
public MainViewModel()
{
StudentViewModel = new StudentViewModel();
}
public async Task <IActionResult> UpdateStudent(Int64 id)
{
//GEt the List of class
var i = _context.Class.ToList();
ViewBag.Class = i;
//Get the specific student
var std = await _context.Student.Where(s => s.StudentId == id).ToListAsync();
var grd = await _context.GuardianInfo.Where(a => a.StudentID == id).ToListAsync();
var query = (from st in std
join g in grd on st.StudentId equals g.StudentID
where st.StudentId == g.StudentID
select new
{
stdntid = st.StudentId,
stdntname = st.StudentName,
stdntcls = st.StudentClass,
stdntgender = st.StudentGender,
stdntphoto = st.StudentPhoto,
stdntcaddrss = st.StudentCAddress,
stdntpaddrss = st.StudentPAddress,
stdntdoa = st.DateOfAdmission,
stdntnation = st.StudentNationality,
stdntyear = st.Year,
dob = st.StudentDOB,
stdntbg = st.StudentBG,
//Guardian Info
GNameMA = g.GNameF,
GNameMO = g.GNameM,
GPhoneFA = g.GPhoneF,
GPhoneMO = g.GPhoneM,
GEmailMO = g.GEmailM,
GEmailFA = g.GEmailF,
GOccupationFA = g.GOccupationF,
GOccupationMO = g.GOccupationM,
GOrganisationFA = g.GOrganisationF,
GOrganisationMO = g.GOrganisationM,
GDesignationFA = g.GDesignationF,
GDesignationMO = g.GDesignationM
}).FirstOrDefault();
StudentViewModel svm = new StudentViewModel()
{
stdntnameVM = query.stdntname,
stdntidVM = query.stdntid,
stdntclsVM = query.stdntcls,
stdntgenderVM = query.stdntgender,
stdntphotoVM = query.stdntphoto,
stdntcaddrssVM = query.stdntcaddrss,
stdntpaddrssVM = query.stdntpaddrss,
stdntdoaVM = query.stdntdoa,
stdntnationVM = query.stdntnation,
stdntyearVM = query.stdntyear,
dobVM = query.dob,
///Guardian info
gnameFVM = query.GNameMA,
gnameMVM = query.GNameMA,
gphoneFVM = query.GPhoneFA,
gphoneMVM = query.GPhoneMO,
gemailFVM = query.GEmailFA,
gemailMVM = query.GEmailMO,
goccupationFVM = query.GOccupationFA,
goccupationMVM = query.GOccupationMO,
gorganisationFVM = query.GOrganisationFA,
gorganisationMVM = query.GOrganisationMO,
gdesignationFVM = query.GDesignationFA,
gdesignationsMVM = query.GDesignationMO
};
return(View(svm));
}
public async Task <int> UpdateStudent(StudentViewModel instructor)
{
_dbContext.Students.Update(_map.Map <Student>(instructor));
return(await _dbContext.SaveChangesAsync().ConfigureAwait(false));
}
public ActionResult Index(long?courseId, long?specialtyId, long?groupId, int?yearOfEntrance)
{
var courses = _courseService.Queryable().ToList();
if (courseId == null)
{
var firstCourse = courses.FirstOrDefault();
courseId = firstCourse == null ? -1 : firstCourse.CourseId;
}
var specialties = _specialtyService
.Query(specialty => specialty.CourseId == (long)courseId)
.Select()
.ToList();
if (specialtyId == null)
{
var firstSpecialty = specialties.FirstOrDefault();
specialtyId = firstSpecialty == null ? -1 : firstSpecialty.SpecialtyId;
}
var groups = _groupService.Query(group => group.SpecialtyId == (long)specialtyId &&
group.Specialty.CourseId == (long)courseId)
.Select()
.ToList();
if (groupId == null)
{
var firstGroup = groups.FirstOrDefault();
groupId = firstGroup == null ? -1 : firstGroup.GroupId;
}
var yearOfEntrances = new List <int>();
var temp = _studentService
.Query(student => student.GroupId == (long)groupId)
.Select(student => student.YearOfEntrance).ToList();
foreach (var value in temp.Where(value => !yearOfEntrances.Contains(value)))
{
yearOfEntrances.Add(value);
}
yearOfEntrances = yearOfEntrances.OrderBy(i => i).ToList();
if (yearOfEntrance == null)
{
var firstYearOfEntrance = yearOfEntrances.FirstOrDefault();
yearOfEntrance = firstYearOfEntrance;
}
var model = new StudentViewModel
{
Courses = new SelectList(courses, "CourseId", "CourseNumber", courseId),
Specialties = new SelectList(specialties, "SpecialtyId", "Name", specialtyId),
Groups = new SelectList(groups, "GroupId", "GroupNumber", groupId),
YearOfEntrances = new SelectList(yearOfEntrances),
YearOfEntrance = (int)yearOfEntrance,
GroupId = (long)groupId,
Students = _studentService.Query(student => student.GroupId == groupId && student.YearOfEntrance == yearOfEntrance)
.Select(student => new StudentRowViewModel
{
CourseNumber = student.Group.Specialty.Course.CourseNumber,
GroupNumber = student.Group.GroupNumber,
SpecialtyName = student.Group.Specialty.Name,
FirstName = student.FirstName,
YearOfEntrance = student.YearOfEntrance,
LastName = student.LastName,
MiddleName = student.MiddleName,
StudentId = student.StudentId,
Login = student.Login,
Password = student.Password
}).ToList()
};
var gv = new GridView {
DataSource = model.Students
};
gv.DataBind();
Session["Students"] = gv;
return(View(model));
}
public IActionResult Add(StudentViewModel student)
{
db.Student.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Vulnerabilities(StudentViewModel student)
{
//solo si se ha iniciado sesion
if (Session["UserGroup"] != null)
{
//se crea un student del viewModel
VulnerabilitiesViewModel objVulnerabilities = new VulnerabilitiesViewModel();
//se guarda el nombre y la matricula
objVulnerabilities.Nombre = student.Nombre;
objVulnerabilities.Matricula = student.Matricula;
//se guarda la matricula en una variable
string registration = student.Matricula;
#region GUARDAR VULNERABILIDADES YA CONSULTADAS
//convertimos a string para poder usarlas como radio buttons
objVulnerabilities.Vul1 = student.Vul1.ToString();
objVulnerabilities.Vul2 = student.Vul2.ToString();
objVulnerabilities.Vul3 = student.Vul3.ToString();
objVulnerabilities.Vul4 = student.Vul4.ToString();
#endregion
#region OBTENER COMENTARIOS DE VULNERABILIDADES
//se obtienen los comentarios de cada una de las vulnerabilidades
var queryVul1 = (from sv in dbCtx.StudentVulnerabilities
join s in dbCtx.Students on sv.StudentID equals s.ID
where s.Registration == registration && sv.VulnerabilityID == 1
select new
{
coments = sv.VulComments
}).SingleOrDefault();
var queryVul2 = (from sv in dbCtx.StudentVulnerabilities
join s in dbCtx.Students on sv.StudentID equals s.ID
where s.Registration == registration && sv.VulnerabilityID == 2
orderby sv.VulnerabilityID
select new
{
coments = sv.VulComments
}).SingleOrDefault();
var queryVul3 = (from sv in dbCtx.StudentVulnerabilities
join s in dbCtx.Students on sv.StudentID equals s.ID
where s.Registration == registration && sv.VulnerabilityID == 3
orderby sv.VulnerabilityID
select new
{
coments = sv.VulComments
}).SingleOrDefault();
var queryVul4 = (from sv in dbCtx.StudentVulnerabilities
join s in dbCtx.Students on sv.StudentID equals s.ID
where s.Registration == registration && sv.VulnerabilityID == 4
orderby sv.VulnerabilityID
select new
{
coments = sv.VulComments
}).SingleOrDefault();
//agregar valores de los comentarios
objVulnerabilities.ComentsVul1 = queryVul1.coments;
objVulnerabilities.ComentsVul2 = queryVul2.coments;
objVulnerabilities.ComentsVul3 = queryVul3.coments;
objVulnerabilities.ComentsVul4 = queryVul4.coments;
#endregion
//se retorna la vista
return(View(objVulnerabilities));
}
else
{
//si no se ha hecho login entonces regresa al login
return(RedirectToAction("Login", "Login"));
}
}
public StudentDTO AddToWaitingList(int courseId, StudentViewModel waiting)
{
// Student needs to be a registered user
// Check if student exists
var studentExistsInDatabase = (from c in _db.Students
where c.SSN == waiting.SSN
select c).SingleOrDefault();
// If the student does not exist in database
// Throw exception
if (studentExistsInDatabase == null)
{
throw new StudentNotExistsException();
}
// Check if course exist
var courseExistsInDatabase = (from c in _db.Courses
where c.Id == courseId
select c).SingleOrDefault();
// If the course does not exist
// Throw exception
if (courseExistsInDatabase == null)
{
throw new CourseNotExistsException();
}
// Check if student is already on waiting list
var StudentStatus = (from c in _db.Enrollments
where c.StudentSSN == waiting.SSN &&
c.CourseId == courseId
select c.Status).SingleOrDefault();
// If the student is on the waiting list
// Throw exception
if (StudentStatus == "Waiting")
{
throw new DuplicateWaitingException();
}
// If the student is enrolled in course
// Throw exception
if (StudentStatus == "Enrolled")
{
throw new DublicateEnrolledException();
}
if (StudentStatus == "Deleted")
{
var FindStudent = (from c in _db.Enrollments
where c.StudentSSN == waiting.SSN &&
c.CourseId == courseId
select c).SingleOrDefault();
FindStudent.Status = "Waiting";
_db.Enrollments.Update(FindStudent);
}
else
{
_db.Enrollments.Add(
new Enrollment {
CourseId = courseId, StudentSSN = waiting.SSN, Status = "Waiting"
});
}
_db.SaveChanges();
return(new StudentDTO
{
SSN = waiting.SSN,
Name = (from st in _db.Students
where st.SSN == waiting.SSN
select st).SingleOrDefault().Name
});
}
public StudentDTO AddStudentToCourse(int courseId, StudentViewModel newStudent)
{
// Student needs to be a registered user
// Check if student exists
var studentExistsInDatabase = (from c in _db.Students
where c.SSN == newStudent.SSN
select c).SingleOrDefault();
if (studentExistsInDatabase == null)
{
throw new StudentNotExistsException();
}
// Check if course exists in database
var courseExistsInDatabase = (from c in _db.Courses
where c.Id == courseId
select c).SingleOrDefault();
if (courseExistsInDatabase == null)
{
throw new CourseNotExistsException();
}
// Check if student is already enrolled in course
var studentIsEnrolled = (from c in _db.Enrollments
where c.StudentSSN == newStudent.SSN &&
c.CourseId == courseId &&
c.Status == "Enrolled"
select c).SingleOrDefault();
if (studentIsEnrolled != null)
{
throw new DublicateEnrolledException();
}
// Check course max capacity
var studentCapacity = (from c in _db.Courses
where c.Id == courseId
select c).SingleOrDefault();
// Check course capacity status
int studentCapacityStatus = (from c in _db.Enrollments
where c.CourseId == courseId &&
c.Status == "Enrolled"
select c).Count();
if (studentCapacity.MaxStudents == studentCapacityStatus)
{
throw new MaxCapacityException();
}
// Check if student is already on the waiting list
// before enrolling him
var studentIsWaiting = (from c in _db.Enrollments
where c.StudentSSN == newStudent.SSN &&
c.CourseId == courseId &&
c.Status == "Waiting"
select c).SingleOrDefault();
// Check if student is deleted
// before enrolling him
var studentIsDeleted = (from c in _db.Enrollments
where c.StudentSSN == newStudent.SSN &&
c.CourseId == courseId &&
c.Status == "Deleted"
select c).SingleOrDefault();
// Removing deleted status
if (studentIsDeleted != null)
{
studentIsDeleted.Status = "Enrolled";
_db.Enrollments.Update(studentIsDeleted);
// Removing waiting status
}
else if (studentIsWaiting != null)
{
studentIsWaiting.Status = "Enrolled";
_db.Enrollments.Update(studentIsWaiting);
}
else
{
_db.Enrollments.Add(new Enrollment {
CourseId = courseId, StudentSSN = newStudent.SSN, Status = "Enrolled"
});
}
_db.SaveChanges();
return(new StudentDTO
{
SSN = newStudent.SSN,
Name = (from st in _db.Students
where st.SSN == newStudent.SSN
select st).SingleOrDefault().Name
});
}
public IActionResult UpdateStudent(StudentViewModel update)
{
Student s = new Student();
s.StudentHallID = update.studenthallidVM;
s.DOB = update.dobVM;
s.StudentName = update.studentnameVM;
s.Department = update.departmentVM;
s.ContactNo = update.contactnoVM;
s.Date = DateTime.Now;
dbc.Student.Update(s);
dbc.SaveChanges();
ModelState.Clear();
var x = dbc.User.Where(q => q.UserID == update.studenthallidVM).FirstOrDefault();
if (x != null)
{
x.UserName = update.studentnameVM;
dbc.User.Update(x);
dbc.SaveChanges();
}
else
{
return(RedirectToAction("StudentList"));
}
var y = dbc.Payment.Where(q => q.StudentHallID == update.studenthallidVM).FirstOrDefault();
if (y != null)
{
y.StudentName = update.studentnameVM;
y.Department = update.departmentVM;
dbc.Payment.Update(y);
dbc.SaveChanges();
}
else
{
return(RedirectToAction("StudentList"));
}
var z = dbc.AssignedRoom.Where(q => q.StudentHallID == update.studenthallidVM).FirstOrDefault();
if (z != null)
{
z.StudentName = update.studentnameVM;
z.Department = update.departmentVM;
dbc.AssignedRoom.Update(z);
dbc.SaveChanges();
}
var u = dbc.MealDistribution.Where(q => q.StudentHallID == update.studenthallidVM).ToList();
if (u != null)
{
foreach (var item in u)
{
item.StudentName = update.studentnameVM;
dbc.MealDistribution.Update(item);
dbc.SaveChanges();
}
}
else
{
return(RedirectToAction("StudentList"));
}
return(RedirectToAction("StudentList"));
}
public async Task <HttpResponseMessage> AddStudentToGroup(Guid groupId, [FromBody] StudentViewModel student)
{
await _groupService.AddStudentToGroup(groupId, Mapper.Map <StudentDto>(student));
return(Request.CreateResponse(HttpStatusCode.OK));
}
public IActionResult UpdateStudent(StudentViewModel student)
{
var std = university.UpdateStudent(student);
return(RedirectToAction("Students"));
}
// get student info by id
public JsonResult GetStudentInfoById(int id)
{
StudentViewModel student = studentManager.GetStudentById(id);
return(Json(student));
}
// get student info by studentId
public JsonResult GetStudentById(int studentId)
{
StudentViewModel studentViewModel = studentManager.GetStudentById(studentId);
return(Json(studentViewModel));
}
//Vamos a obtener como parametros la matricula del estudante selecionado
public ActionResult Student(StudentsViewModel student)
{
//Se valida si se ha iniciado sesion
if (Session["UserGroup"] != null)
{
//Se crea un student del viewModel
StudentViewModel objEstudiante = new StudentViewModel();
//Se guarda el nombre y la matricula
objEstudiante.Nombre = student.Nombre;
objEstudiante.Matricula = student.Matricula;
//Se guarda la matricula en una variable
string matricula = student.Matricula;
#region OBTENER FOTO DE ESTUDIANTE EN BASE A MATRICULA
//como tenemos las fotos guardadas con matricula no necesitamos hacer un query
//a la matricula se le agrega el .jpg
string path = matricula + ".jpg";
//se agrega al ViewModel
objEstudiante.Matricula = matricula;
objEstudiante.PhotoPath = path;
#endregion
#region OBTENER DATOS ESTUDIANTE EN BASE A MATRICULA
//se obtiene la informacion del alumno
var queryStudent = (from s in dbCtx.Students
join cg in dbCtx.ClassGroups on s.ClassGroupID equals cg.ID
join ms in dbCtx.MaritalStatuses on s.MaritalStatusID equals ms.ID
join c in dbCtx.Careers on s.CareerID equals c.ID
join m in dbCtx.Modalities on s.ModalityID equals m.ID
join tu in dbCtx.Turns on s.TurnID equals tu.ID
join si in dbCtx.Situations on s.SituationID equals si.ID
where s.Registration == matricula
select new
{
nombre = s.FirstMidName,
apellidoP = s.LastNameP,
apellidoM = s.LastNameM,
birthDate = s.BirthDate,
curp = s.CURP,
rfc = s.RFC,
maritalStatus = ms.Description,
perPhone = s.PersonalPhone,
perEmail = s.PersonalEmail,
emerPhone = s.EmergencyPhone,
academEmail = s.AcademicEmail,
carrera = c.Description,
modalidad = m.Description,
turno = tu.Description,
cuatrimestre = cg.Term,
situacion = si.Description,
seccion = cg.Section
}).SingleOrDefault();
//se le agregan los valores
objEstudiante.FirstMidName = queryStudent.nombre;
objEstudiante.LastNameP = queryStudent.apellidoP;
objEstudiante.LastNameM = queryStudent.apellidoM;
objEstudiante.BirthDate = queryStudent.birthDate;
objEstudiante.CURP = queryStudent.curp;
objEstudiante.RFC = queryStudent.rfc;
objEstudiante.MaritalStatus = queryStudent.maritalStatus;
objEstudiante.PersonalPhone = queryStudent.perPhone;
objEstudiante.PersonalEmail = queryStudent.perEmail;
objEstudiante.EmergencyPhone = queryStudent.emerPhone;
objEstudiante.AcademicEmail = queryStudent.academEmail;
objEstudiante.Career = queryStudent.carrera;
objEstudiante.Modality = queryStudent.modalidad;
objEstudiante.Turn = queryStudent.turno;
objEstudiante.Term = queryStudent.cuatrimestre;
objEstudiante.Section = queryStudent.seccion;
objEstudiante.Situation = queryStudent.situacion;
//se agregan al objEstudiante las vulnerabilidades del parametro student
objEstudiante.Vul1 = student.Vul1;
objEstudiante.Vul2 = student.Vul2;
objEstudiante.Vul3 = student.Vul3;
objEstudiante.Vul4 = student.Vul4;
#endregion
#region OBTENER MATERIAS
// se buscan las materias que lleva el alumno
var queryMaterias = (from sc in dbCtx.StudentCourses
join c in dbCtx.Courses on sc.CourseID equals c.ID
join s in dbCtx.Students on sc.StudentID equals s.ID
where s.Registration == matricula
//para obtener solo una vez la materia y no por cada unidad
group sc by c.Description into g
select new
{
materia = g.Key
}).ToList();
//lista para almacenar las materias
List <string> materias = new List <string>();
//por cada materia se agrega un elemento a la lista
foreach (var materia in queryMaterias)
{
materias.Add(materia.materia);
}
//se guarda la lista en un view bag
ViewBag.Materias = materias;
#endregion
//Se retorna la vista con el estudiante de StudentViewModel
return(View(objEstudiante));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public StudentGateway()
{
studentModel = new StudentModel();
studentViewModel = new StudentViewModel();
}
public ActionResult Index(StudentViewModel model, int?page, string searchCheck, string Semester_ID)
{
List <Student> students = new List <Student>();
string SearchString = model.Email;
if (searchCheck != null)
{
students = unitOfWork.Students.GetPageList();
}
else
{
page = 1;
}
if (!String.IsNullOrEmpty(searchCheck))
{
if (!String.IsNullOrWhiteSpace(SearchString))
{
students = students.Where(s => s.Email.Trim().ToUpper().Contains(SearchString.Trim().ToUpper())).ToList();
}
if (!String.IsNullOrWhiteSpace(model.Semester_ID))
{
students = students.Where(s => s.Semester_ID.Trim().Equals(model.Semester_ID.Trim())).ToList();
}
if (!String.IsNullOrWhiteSpace(model.Campus_ID))
{
students = students.Where(s => s.Campus_ID.Trim().Equals(model.Campus_ID.Trim())).ToList();
}
if (students.Count == 0)
{
ViewBag.Nodata = "Showing 0 results";
}
else
{
ViewBag.Nodata = "";
}
}
List <SelectListItem> semesterList = new List <SelectListItem>();
var semester = unitOfWork.Semesters.GetAll();
foreach (var sem in semester)
{
semesterList.Add(new SelectListItem
{
Text = sem.Semester_Name,
Value = sem.Semester_ID
});
}
List <SelectListItem> campusList = new List <SelectListItem>();
var campus = unitOfWork.Campus.GetAll();
foreach (var cam in campus)
{
campusList.Add(new SelectListItem
{
Text = cam.Campus_Name,
Value = cam.Campus_ID
});
}
model.lstSemester = semesterList;
model.lstCampus = campusList;
model.searchCheck = searchCheck;
int pageSize = 30;
int pageNumber = (page ?? 1);
List <StudentSubjectView> lst = new List <StudentSubjectView>();
foreach (var stud in students)
{
lst.Add(new StudentSubjectView
{
Roll = stud.Roll,
Full_Name = stud.Full_Name,
Email = stud.Email,
Campus_ID = stud.Campus_ID,
Semester = stud.Semester,
Subject = unitOfWork.SubjectStudent.getListSubject(stud.Roll + "^" + stud.Semester_ID).ToString()
});
}
model.PageList = lst.ToList().ToPagedList(pageNumber, pageSize);
ViewBag.Count = lst.Count();
return(View(model));
}
public StudentViewModel Update(Guid idEnvironment, StudentViewModel studentViewModel)
{
Student student = _mapper.Map <Student>(studentViewModel);
return(_mapper.Map <StudentViewModel>(_studentService.Update(idEnvironment, student)));
}
public IActionResult Edit(StudentViewModel student)
{
db.Entry(student).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> CreateStudent(StudentViewModel oStudentVM)
{
TempData["UserMessage"] = new MessageVM()
{
IsSuccessful = false, Title = "Error!", Message = "Something went wrong."
};
if (Helpers.Helpers.IsStaff(User))
{
return(RedirectToAction("Index", "Staff"));
}
if (!ModelState.IsValid)
{
return(View(oStudentVM));
}
Parent oParent = db.Parents.Include("Children").SingleOrDefault(p => p.ParentId == SessionSingleton.Current.ParentId);
if (oParent == null) //Error. Parent DNE.
{
throw new ArgumentException("CreateStudent(StudentViewModel oStudentVM) - Parent DNE");
}
Student oStudent = new Student()
{
//-- Default values --
Username = User.Identity.Name,
Email = User.Identity.Name,
Active = 1,
DateCreated = DateTime.Now,
LastActive = DateTime.Now,
//-- end of Default values --
//-- VM to Model --
FirstName = oStudentVM.FirstName,
LastName = oStudentVM.LastName,
Gender = oStudentVM.Gender,
Phone = oStudentVM.Phone,
Courses = new List <Course>(),
Teachers = new List <Teacher>(),
//WeeklyQuestions = new List<QuestionHistory>(),
//QuestionHistorys = new List<QuestionHistory>()
//-- end of VM to Model --
};
oParent.Children.Add(oStudent);//Add Student to Parent
try
{
if (db.SaveChanges() <= 0)
{
return(View(oStudent));
}
}
catch (Exception e)
{
return(View(oStudent));
}
TempData["UserMessage"] = new MessageVM()
{
IsSuccessful = true, Title = "Success!", Message = "Your child has been successfully added."
};
return(RedirectToAction("Index", new { StudentId = oStudent.StudentId, CourseId = 0 }));
}
public StudentAddView()
{
InitializeComponent();
BindingContext = StudentViewModel.GetInstance();
}
public static StudentViewModel Sort(List <Student> students, SortingEnum sortState)
{
var model = new StudentViewModel
{
LastNameSortState = sortState == SortingEnum.LastNameAsc
? SortingEnum.LastNameDesc
: SortingEnum.LastNameAsc,
CreatedDateSortState = sortState == SortingEnum.CreatedDateAsc
? SortingEnum.CreatedDateDesc
: SortingEnum.CreatedDateAsc,
DateOfBirthdaySortState = sortState == SortingEnum.DateOfBirthdayAsc
? SortingEnum.DateOfBirthdayDesc
: SortingEnum.DateOfBirthdayAsc,
ParentLastNameSortState = sortState == SortingEnum.ParentLastNameAsc
? SortingEnum.ParentLastNameDesc
: SortingEnum.ParentLastNameAsc,
PhoneNumberSortState = sortState == SortingEnum.PhoneNumberAsc
? SortingEnum.PhoneNumberDesc
: SortingEnum.PhoneNumberAsc,
StatusSortState = sortState == SortingEnum.StatusAsc
? SortingEnum.StatusDesc
: SortingEnum.StatusAsc,
GroupSortState = sortState == SortingEnum.GroupAsc
? SortingEnum.GroupDesc
: SortingEnum.GroupAsc,
TrialDateSortState = sortState == SortingEnum.TrialDateAsc
? SortingEnum.TrialDateDesc
: SortingEnum.TrialDateAsc,
LevelSortState = sortState == SortingEnum.LevelAsc
? SortingEnum.LevelDesc
: SortingEnum.LevelAsc,
CommentSortState = sortState == SortingEnum.CommentAsc
? SortingEnum.CommentDesc
: SortingEnum.CommentAsc,
ChangeStatusSortState = sortState == SortingEnum.ChangeStatusAsc
? SortingEnum.ChangeStatusDesc
: SortingEnum.ChangeStatusAsc
};
switch (sortState)
{
case SortingEnum.LastNameAsc:
students = students.OrderBy(s => s.LastName ?? s.Name ?? s.FatherName).ToList();
break;
case SortingEnum.LastNameDesc:
students = students.OrderByDescending(s => s.LastName ?? s.Name ?? s.FatherName).ToList();
break;
case SortingEnum.CreatedDateAsc:
students = students.OrderBy(s => s.CreatedDate).ToList();
break;
case SortingEnum.CreatedDateDesc:
students = students.OrderByDescending(s => s.CreatedDate).ToList();
break;
case SortingEnum.DateOfBirthdayAsc:
students = students.OrderBy(s => s.DateOfBirthday).ToList();
break;
case SortingEnum.DateOfBirthdayDesc:
students = students.OrderByDescending(s => s.DateOfBirthday).ToList();
break;
case SortingEnum.ParentLastNameAsc:
students = students.OrderBy(s => s.ParentLastName).ToList();
break;
case SortingEnum.ParentLastNameDesc:
students = students.OrderByDescending(s => s.ParentLastName).ToList();
break;
case SortingEnum.PhoneNumberAsc:
students = students.OrderBy(s => s.PhoneNumber).ToList();
break;
case SortingEnum.PhoneNumberDesc:
students = students.OrderByDescending(s => s.PhoneNumber).ToList();
break;
case SortingEnum.StatusAsc:
students = students.OrderBy(s => s.Status).ToList();
break;
case SortingEnum.StatusDesc:
students = students.OrderByDescending(s => s.Status).ToList();
break;
case SortingEnum.GroupAsc:
students = students.OrderBy(s => s.Group).ToList();
break;
case SortingEnum.GroupDesc:
students = students.OrderByDescending(s => s.Group).ToList();
break;
case SortingEnum.TrialDateAsc:
students = students.OrderBy(s => s.TrialDate).ToList();
break;
case SortingEnum.TrialDateDesc:
students = students.OrderByDescending(s => s.TrialDate).ToList();
break;
case SortingEnum.LevelAsc:
students = students.OrderBy(s => s.Level).ToList();
break;
case SortingEnum.LevelDesc:
students = students.OrderByDescending(s => s.Level).ToList();
break;
case SortingEnum.CommentAsc:
students = students.OrderBy(s => s.Comments).ToList();
break;
case SortingEnum.CommentDesc:
students = students.OrderByDescending(s => s.Comments).ToList();
break;
case SortingEnum.ChangeStatusAsc:
students = students.OrderBy(s => s.ChangeStatusDate).ToList();
break;
case SortingEnum.ChangeStatusDesc:
students = students.OrderByDescending(s => s.ChangeStatusDate).ToList();
break;
}
model.Student = students;
return(model);
}
public async Task <IActionResult> AddStudent(StudentViewModel std)
{
//GEt the List of class
var i = _context.Class.ToList();
//Insert a new element in position 0
i.Insert(0, new Class {
ClassId = 0, ClassName = "Select"
});
ViewBag.Class = i;
// Create a student and save to the database
Student st = new Student()
{
StudentId = std.stdntidVM,
StudentName = std.stdntnameVM,
StudentCAddress = std.stdntcaddrssVM,
StudentPAddress = std.stdntpaddrssVM,
StudentNationality = std.stdntnationVM,
StudentDOB = std.dobVM,
StudentGender = std.stdntgenderVM,
DateOfAdmission = DateTime.Now.Date,
StudentClass = std.stdntclsVM,
StudentPhoto = std.stdntphotoVM,
Year = DateTime.Now.Year
};
_context.Student.Add(st);
await _context.SaveChangesAsync();
//Get the id of saved student
var StudentId = st.StudentId;
//Create guradian info for that student and save it
GuardianInfo gi = new GuardianInfo()
{
SL = 0,
StudentID = StudentId,
GNameF = std.gnameFVM,
GNameM = std.gnameMVM,
GPhoneF = std.gphoneFVM,
GPhoneM = std.gphoneMVM,
GEmailF = std.gemailFVM,
GEmailM = std.gemailMVM,
GOccupationF = std.goccupationFVM,
GOccupationM = std.goccupationMVM,
GOrganisationF = std.gorganisationFVM,
GOrganisationM = std.gorganisationMVM,
GDesignationF = std.gdesignationFVM,
GDesignationM = std.gdesignationsMVM
};
_context.GuardianInfo.Add(gi);
await _context.SaveChangesAsync();
// Create random password
PasswordCreator ps = new PasswordCreator();
//Insert the login information for student login and save
Login lg = new Login()
{
SL = 0,
Username = StudentId.ToString(),
Password = ps.RandomPassword(),
FirstLoginStatus = true,
ActiveStatus = true,
RoleId = 1,
DistinguishId = StudentId,
};
lg.CurrentPassword = lg.Password;
_context.Login.Add(lg);
await _context.SaveChangesAsync();
//Clear the modelstate
ModelState.Clear();
return(View());
}
private StudentBo BuiltStudentBo(StudentViewModel studentViewModel)
{
return((StudentBo) new StudentBo().InjectFrom(studentViewModel));
}
public IActionResult Details(Int64 id)
{
var std = _context.Student.Where(s => s.StudentId == id).ToList();
if (std.Count != 0)
{
var grd = _context.GuardianInfo.Where(a => a.StudentID == id).ToList();
if (grd.Count != 0)
{
var query = (from st in std
join g in grd on st.StudentId equals g.StudentID
where st.StudentId == g.StudentID
select new
{
stdntid = st.StudentId,
stdntname = st.StudentName,
stdntcls = st.StudentClass,
stdntgender = st.StudentGender,
stdntphoto = st.StudentPhoto,
stdntcaddrss = st.StudentCAddress,
stdntpaddrss = st.StudentPAddress,
stdntdoa = st.DateOfAdmission,
stdntnation = st.StudentNationality,
stdntyear = st.Year,
dob = st.StudentDOB,
stdntbg = st.StudentBG,
//Guardian Info
GNameMA = g.GNameF,
GNameMO = g.GNameM,
GPhoneFA = g.GPhoneF,
GPhoneMO = g.GPhoneM,
GEmailMO = g.GEmailM,
GEmailFA = g.GEmailF,
GOccupationFA = g.GOccupationF,
GOccupationMO = g.GOccupationM,
GOrganisationFA = g.GOrganisationF,
GOrganisationMO = g.GOrganisationM,
GDesignationFA = g.GDesignationF,
GDesignationMO = g.GDesignationM
}).FirstOrDefault();
StudentViewModel svm = new StudentViewModel()
{
stdntnameVM = query.stdntname,
stdntidVM = query.stdntid,
stdntclsVM = query.stdntcls,
stdntgenderVM = query.stdntgender,
stdntphotoVM = query.stdntphoto,
stdntcaddrssVM = query.stdntcaddrss,
stdntpaddrssVM = query.stdntpaddrss,
stdntdoaVM = query.stdntdoa,
stdntnationVM = query.stdntnation,
stdntyearVM = query.stdntyear,
dobVM = query.dob,
///Guardian info
gnameFVM = query.GNameMA,
gnameMVM = query.GNameMA,
gphoneFVM = query.GPhoneFA,
gphoneMVM = query.GPhoneMO,
gemailFVM = query.GEmailFA,
gemailMVM = query.GEmailMO,
goccupationFVM = query.GOccupationFA,
goccupationMVM = query.GOccupationMO,
gorganisationFVM = query.GOrganisationFA,
gorganisationMVM = query.GOrganisationMO,
gdesignationFVM = query.GDesignationFA,
gdesignationsMVM = query.GDesignationMO
};
return(View(svm));
}
else
{
return(NotFound());
}
}
else
{
return(NotFound());
}
}
public StudentViewModel GetStudentInformationById(int id)
{
try
{
CommandObj.CommandText = "spGetStudentInformationById";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@Id", id);
StudentViewModel student = null;
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
if (reader.Read())
{
student = new StudentViewModel
{
Id = Convert.ToInt32(reader["Id"].ToString()),
RegNo = reader["RegNo"].ToString(),
Name = reader["Name"].ToString(),
Email = reader["Email"].ToString(),
ContactNo = reader["ContactNo"].ToString(),
RegisterationDate = Convert.ToDateTime(reader["RegisterationDate"].ToString()),
Address = reader["Address"].ToString(),
Department = reader["Department"].ToString()
};
}
reader.Close();
return student;
}
catch (Exception exception)
{
throw new Exception("Unable to get student information",exception);
}
finally
{
CommandObj.Dispose();
ConnectionObj.Close();
}
}
public JsonResult GetStudentById(int studentId)
{
StudentViewModel student = studentManager.GetStudentInformationById(studentId);
return(Json(student, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ApplicationUser currentUser = db.Users.Find(User.Identity.GetUserId());
var popularTutorials = db.Tutorials.OrderByDescending(x => x.Votes).Take(5).ToList();
if (currentUser.LearningPathModel == null)
{
currentUser.LearningPathModel = new LearningPathModel();
}
if (isStudent())
{
StudentViewModel studentVM = new StudentViewModel
{
CurrentUser = currentUser,
PopularTutorials = popularTutorials
};
return View("Student", studentVM);
}
else
{
var educatorsTutorials = db.Tutorials.Where(x => x.EducatorId == currentUser.Id).ToList();
educatorsTutorials.ForEach(x => currentUser.Points += x.Votes);
var educatorsQuizzes = db.Quiz.Where(x => x.EducatorId == currentUser.Id).ToList();
List<CollaborativeTutorial> acttt = GetAddedCollaboratorsList(educatorsTutorials);
EducatorViewModel eduViewModel = new EducatorViewModel()
{
EducatorTutorials = educatorsTutorials,
CollaborativeTutorials = GetCollabTutorials(),
EducatorQuizzes = educatorsQuizzes,
Points = currentUser.Points,
PopularTutorials = popularTutorials,
AddedCollaboratorsToTheseTutorials = acttt
};
return View("Educator", eduViewModel);
}
}
public async Task <IActionResult> UpdateStudent(int id, [FromBody] StudentViewModel model)
{
Result result = await _studentGateway.Update(id, model.FirstName, model.LastName, model.BirthDate, model.GitHubLogin);
return(this.CreateResult(result));
}
public MainWindow()
{
InitializeComponent();
DataContext = new StudentViewModel();
}
// GET: Students/Edit/5
public ActionResult Edit(Guid? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Student student = db.Students.Find(id);
if (student == null)
{
return HttpNotFound();
}
StudentViewModel studentVM = new StudentViewModel();
studentVM.Name = student.Name;
studentVM.Email = student.Email;
studentVM.ParentEmail = student.ParentEmail;
studentVM.PhoneNumber = student.PhoneNumber;
studentVM.StudentId = student.StudentId;
studentVM.StudentClassId = student.StudentClassId;
studentVM.Classes = db.SchoolClasses.Select(x => new SelectListItem { Text = x.Name, Value = x.SchoolClassId.ToString() });
return View(studentVM);
}
public ActionResult Create()
{
var viewModel = new StudentViewModel();
return View(viewModel);
}
public int?UpdateStudent(StudentViewModel student)
{
throw new NotImplementedException();
}
public ActionResult Create(StudentViewModel model)
{
var student = DecomposeStudentViewModel(model);
StudentManager.Create(student);
return RedirectToAction("List");
}
public EditStudent(StudentViewModel student)
{
InitializeComponent();
this.student = student;
grid.DataContext = student;
}
private Student DecomposeStudentViewModel(StudentViewModel Student)
{
var student = Map<StudentViewModel, Student>(Student);
var group = Site.GroupManager.Get(Student.GroupId);
student.Group = group;
student.Image = SaveImage(Student.ImageFile, Student.Id).Or(Student.Image);
return student;
}
