private void ReportValidationCheckbox_Checked(object sender, RoutedEventArgs e) { if (pageIsLoad && userSesion.Kind != "Student") { reportSelected = ((FrameworkElement)sender).DataContext as Reporte; try { if (reportSelected != null) { using (SCPPContext context = new SCPPContext()) { var fileInDB = context.Archivo.Find(reportSelected.ArchivoID); if (fileInDB.Validado == 1) { fileInDB.Validado = 0; } else { fileInDB.Validado = 1; } context.SaveChanges(); } } } catch (EntityException) { Restarter.RestarSCPP(); } } }
private object UpdateProfesor() { Profesor profesor; using (SCPPContext context = new SCPPContext()) { profesor = context.Profesor.FirstOrDefault(s => s.Numtrabajador == actualProfesor.Numtrabajador); profesor.Nombre = TextBoxName.Text; profesor.Apellidopaterno = TextBoxApellidoPaterno.Text; profesor.Apellidomaterno = TextBoxApellidoMaterno.Text; profesor.Telefono = TextBoxPhone.Text; profesor.Correopersonal = TextBoxEmail.Text; if (ComboBoxState.Text.Equals("Activo")) { profesor.Activo = 1; } else { profesor.Activo = 0; } context.SaveChanges(); } actualProfesor = profesor; return(profesor); }
private void RegisterButton_Click(object sender, RoutedEventArgs e) { try { using (SCPPContext context = new SCPPContext()) { var proyecto = context.Proyecto.FirstOrDefault(s => s.Nombre == TextBoxNombre.Text); if (proyecto == null) { var proyectRegistered = RegisterNewProyect(); MessageBoxResult confirmation = CustomMessageBox.ShowYesNo("El registro se ha realizado con éxito", "Registro exitoso", "Gestionar proyecto", "Finalizar"); if (confirmation == MessageBoxResult.Yes) { var mainWindow = (MainWindow)Application.Current.MainWindow; mainWindow?.ChangeView(new GestionarProyecto(proyecto)); } else { CancelButton_Click(new object(), new RoutedEventArgs()); } } else { CustomMessageBox.ShowOK("Ya existe un proyecto registrado con el nombre ingresado con clave: " + proyecto.Clave, "Proyecto ya registrado", "Aceptar"); } } } catch (EntityException) { Restarter.RestarSCPP(); } }
private void GetStudentActualExpediente() { using (SCPPContext context = new SCPPContext()) { expediente = context.Expediente.FirstOrDefault(i => i.InscripciónID == inscription.InscripciónID); } }
private void GetGroups() { try { using (SCPPContext context = new SCPPContext()) { var profesor = context.Profesor.FirstOrDefault(c => c.Numtrabajador.Equals(_user)); if (profesor != null) { isCoordinator = false; } else { isCoordinator = true; } groupsCollection = GetList(isCoordinator, profesor); } GroupList.ItemsSource = groupsCollection; DataContext = groupsCollection; } catch (Exception) { Restarter.RestarSCPP(); } }
private void SpecificSearch(string searchText) { organizationCollection.Clear(); using (SCPPContext context = new SCPPContext()) { var organizationBySearch = context.Organización.Where( o => o.Nombre.Contains(searchText) || o.Correo.Contains(searchText) || o.Telefono.Contains(searchText) || o.Sector.Contains(searchText) || o.Calle.Contains(searchText)); if (organizationBySearch != null) { foreach (Organización organization in organizationBySearch) { if (organization != null) { organizationCollection.Add(organization); } } } SetFilter(); } }
private void RegisterButton_Click(object sender, RoutedEventArgs e) { try { if (VerificateFields()) { using (SCPPContext context = new SCPPContext()) { var student = context.Estudiante.Find(TextBoxMatricula.Text); if (student == null) { var studentRegistered = RegisterNewStudent(); SendEmail(); StudentRegisteredMessage(studentRegistered); } else { CustomMessageBox.ShowOK("Ya existe un estudiante registrado con la matrícula ingresada con nombre: " + student.Nombre, "Estudiante ya registrado", "Aceptar"); } } } } catch (EntityException) { Restarter.RestarSCPP(); } }
private void ChangeStudentStatus() { ObservableCollection <Estudiante> studentList = new ObservableCollection <Estudiante>(); try { using (SCPPContext context = new SCPPContext()) { foreach (var student in selectedStudents) { var foundStudent = context.Estudiante.Where(s => s.Matricula.Equals(student.Matricula)). FirstOrDefault(); if (foundStudent != null) { foundStudent.Estado = "Inscrito"; context.SaveChanges(); } studentList.Add(student); } } foreach (var student in studentList) { studentsCollection.Remove(student); } ConfirmedRegistrationMessage(); } catch (EntityException) { Restarter.RestarSCPP(); } }
private void GetStudentActualInscription() { using (SCPPContext context = new SCPPContext()) { inscription = context.Inscripción.FirstOrDefault(i => i.Matriculaestudiante == student.Matricula && i.Estatus.Equals("Cursando")); } }
private void RegisterButton_Click(object sender, RoutedEventArgs e) { try { if (VerificateFields()) { using (SCPPContext context = new SCPPContext()) { var organization = context.Organización.FirstOrDefault(s => s.Nombre == NameTextBox.Text); if (organization == null) { Organización organizationRegistered = (Organización)RegisterNewOrganization(); OrganizationRegisteredMessage(organizationRegistered); } else { CustomMessageBox.ShowOK("Organización ya registrada", "Registro repetido", "Aceptar"); } } } } catch (EntityException) { Restarter.RestarSCPP(); } }
private bool VerificateGroupCapacity() { var selectedGroup = (Grupo)GroupComboBox.SelectedItem; bool isAvailable; using (SCPPContext context = new SCPPContext()) { var studentsAlreadyInTheGroup = context.Estudiante.Join( context.Inscripción, e => e.Matricula, i => i.Matriculaestudiante, (e, i) => new { e, i }) .Where(x => x.i.GrupoID == selectedGroup.GrupoID); int totalStudents = studentsAlreadyInTheGroup.Count() + selectedStudents.Count(); if (totalStudents <= selectedGroup.Cupo) { isAvailable = true; } else { isAvailable = false; } } return(isAvailable); }
private void ComboBoxOrganization_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { var organization = (Organización)ComboBoxOrganization.SelectedItem; responsablesCollection = new ObservableCollection <Responsableproyecto>(); using (SCPPContext context = new SCPPContext()) { var responsablesList = context.Responsableproyecto.Where(r => r.OrganizaciónID == organization.OrganizaciónID); if (responsablesList != null) { foreach (Responsableproyecto responsableProyecto in responsablesList) { if (responsableProyecto != null) { responsablesCollection.Add(responsableProyecto); } } } } ComboBoxResponsable.ItemsSource = responsablesCollection; } catch (EntityException) { Restarter.RestarSCPP(); } }
private void SpecificSearch(string searchText) { profesorsCollection.Clear(); using (SCPPContext context = new SCPPContext()) { var profesorsBySearch = context.Profesor.Where( s => s.Numtrabajador.Contains(searchText) || s.Nombre.Contains(searchText) || s.Apellidomaterno.Contains(searchText) || s.Apellidopaterno.Contains(searchText) || s.Correopersonal.Contains(searchText)); if (profesorsBySearch != null) { foreach (Profesor profesor in profesorsBySearch) { if (profesor != null) { profesorsCollection.Add(profesor); } } } SetFilter(); } }
private void GetStudents() { studentsCollection = new ObservableCollection <Estudiante>(); using (SCPPContext context = new SCPPContext()) { var students = context.Estudiante.Join( context.Inscripción, e => e.Matricula, i => i.Matriculaestudiante, (e, i) => new { e, i }) .Where(x => x.i.Claveproyecto == actualProject.Clave) .Select(x => x.e); if (students != null) { foreach (Estudiante estudiante in students) { if (estudiante != null) { studentsCollection.Add(estudiante); } } } } StudentsList.ItemsSource = studentsCollection; DataContext = studentsCollection; }
private object UpdateProject() { Proyecto project; using (SCPPContext context = new SCPPContext()) { var organization = (Organización)ComboBoxOrganization.SelectedItem; Responsableproyecto responsable; if (ComboBoxResponsable.SelectedItem == null) { responsable = actualResponsableProyecto; } else { responsable = (Responsableproyecto)ComboBoxResponsable.SelectedItem; } project = context.Proyecto.FirstOrDefault(p => p.Clave == actualProject.Clave); project.Actividades = TextBoxActividades.Text; project.Descripcion = TextBoxDescription.Text; project.Noestudiantes = Int32.Parse(ComboBoxCapacidad.Text); project.Nombre = TextBoxName.Text; project.OrganizaciónID = organization.OrganizaciónID; project.ResponsableproyectoID = responsable.ResponsableproyectoID; context.SaveChanges(); } actualProject = project; return(project); }
private void Search(string searchText) { studentsCollection.Clear(); using (SCPPContext context = new SCPPContext()) { var studentsBySearch = context.Estudiante.Where( s => s.Matricula.Contains(searchText) || s.Nombre.Contains(searchText) || s.Apellidomaterno.Contains(searchText) || s.Apellidopaterno.Contains(searchText) || s.Correopersonal.Contains(searchText) || s.Telefono.Contains(searchText)); if (studentsBySearch != null) { foreach (Estudiante student in studentsBySearch) { if (student != null) { studentsCollection.Add(student); } } } } }
private void GetStudents() { studentsCollection = new ObservableCollection <Estudiante>(); IQueryable <Estudiante> studentsInDB = null; using (SCPPContext context = new SCPPContext()) { studentsInDB = context.Estudiante.Join( context.Inscripción, s => s.Matricula, i => i.Matriculaestudiante, (s, i) => new { student = s, inscription = i }) .Where(j => j.inscription.Periodo.Equals(period) && j.student.Estado.Equals("Inscrito")) .Select(j => j.student); if (studentsInDB != null) { foreach (Estudiante student in studentsInDB) { if (student != null) { studentsCollection.Add(student); } } } } StudentList.ItemsSource = studentsCollection; DataContext = studentsCollection; }
private Estudiante RegisterNewStudent() { var student = new Estudiante { Matricula = TextBoxEnrrollment.Text, Nombre = TextBoxName.Text, Apellidopaterno = TextBoxLastName.Text, Apellidomaterno = TextBoxMothersLastName.Text, Telefono = TextBoxPhone.Text, Correopersonal = TextBoxEMail.Text, Promedio = Convert.ToDouble(TextBoxAverage.Text), Estado = "Preinscrito", Genero = ComboBoxGender.Text, Activo = 1, Contraseña = Encrypt.GetSHA256(TextBoxPassword.Password) }; try { using (SCPPContext context = new SCPPContext()) { context.Estudiante.Add(student); context.SaveChanges(); } } catch (EntityException) { Restarter.RestarSCPP(); } return(student); }
private void CoordinatorSearch(string searchText) { groupsCollection.Clear(); using (SCPPContext context = new SCPPContext()) { var groupsBySearch = context.Grupo.Where(s => (s.Nrc.ToString().Contains(searchText) || s.Cupo.ToString().Contains(searchText) || s.Bloque.Contains(searchText) || s.Seccion.Contains(searchText) || s.Periodo.Contains(searchText)) ); if (groupsBySearch != null) { foreach (Grupo group in groupsBySearch) { if (group != null) { groupsCollection.Add(group); } } } } SetFilter(); }
private void RegisterButton_Click(object sender, RoutedEventArgs e) { try { using (SCPPContext context = new SCPPContext()) { var foundResposable = context.Responsableproyecto.Where(s => s.Correopersonal.Equals(TextBoxEMail.Text)).FirstOrDefault(); if (foundResposable == null) { if (VerificateFields()) { var resposableRegistered = RegisterNewResposable(); ResposableRegisteredMessage(resposableRegistered); } } else { CustomMessageBox.ShowOK("Ya existe un resposable registrado con el correo ingresado: " + foundResposable.Nombre, "Resposable ya registrado", "Aceptar"); } } } catch (EntityException) { Restarter.RestarSCPP(); } }
private void GetInscriptions() { inscriptionsCollection = new ObservableCollection <Inscripción>(); using (SCPPContext context = new SCPPContext()) { var inscriptionsList = context.Inscripción.Where(i => i.Matriculaestudiante == actualStudent.Matricula) .Include(i => i.Proyecto) .Include(i => i.Proyecto.Organización) .Include(i => i.Expediente) .Include(i => i.Grupo); if (inscriptionsList != null) { foreach (Inscripción inscription in inscriptionsList) { if (inscription != null) { inscriptionsCollection.Add(inscription); } } } } if (userSesion.Kind == "Coordinator") { DeleteStudentButton.Visibility = Visibility.Visible; } ProyectColumn.Binding = new Binding("Proyecto.Nombre"); OrganizationColumn.Binding = new Binding("Proyecto.Organización.Nombre"); InscriptionList.ItemsSource = inscriptionsCollection; DataContext = inscriptionsCollection; }
private Responsableproyecto RegisterNewResposable() { var organization = (Organización)ComboBoxOrganizacion.SelectedItem; Responsableproyecto responsable = new Responsableproyecto { Nombre = TextBoxName.Text, Apellidopaterno = TextBoxLastName.Text, Apellidomaterno = TextBoxMothersLastName.Text, Correopersonal = TextBoxEMail.Text, Telefono = TextBoxPhone.Text, Activo = 1, OrganizaciónID = organization.OrganizaciónID }; try { using (SCPPContext context = new SCPPContext()) { context.Responsableproyecto.Add(responsable); context.SaveChanges(); } } catch (EntityException) { Restarter.RestarSCPP(); } return(responsable); }
private void GetStudents() { studentsCollection = new ObservableCollection <Estudiante>(); using (SCPPContext context = new SCPPContext()) { var studentsWithoutGroupList = context.Estudiante.Join( context.Inscripción, e => e.Matricula, i => i.Matriculaestudiante, (e, i) => new { e, i }) .Where(x => x.i.GrupoID == null) .Select(x => x.e); if (studentsWithoutGroupList != null) { foreach (Estudiante estudiante in studentsWithoutGroupList) { if (estudiante != null) { studentsCollection.Add(estudiante); } } } } StudentList.ItemsSource = studentsCollection; DataContext = studentsCollection; }
private int countStudentsByGender(string sector, string gender) { int totalStudents = 0; using (SCPPContext context = new SCPPContext()) { var studentsList = context.Estudiante.Join( context.Inscripción, s => s.Matricula, i => i.Matriculaestudiante, (s, i) => new { student = s, inscription = i }) .Join( context.Proyecto, j => j.inscription.Claveproyecto, p => p.Clave, (j, p) => new { join = j, project = p }) .Join( context.Organización, j2 => j2.project.OrganizaciónID, o => o.OrganizaciónID, (j2, o) => new { join2 = j2, organization = o }) .Where(q => q.organization.Sector.Equals(sector)) .Where(q => q.join2.join.student.Genero.Equals(gender)) .Select(q => q.join2.join.student); totalStudents = studentsList.Count(); } return(totalStudents); }
private void ChangeStudentsGroups() { ObservableCollection <Estudiante> studentList = new ObservableCollection <Estudiante>(); try { using (SCPPContext context = new SCPPContext()) { foreach (var student in selectedStudents) { var foundInscription = context.Inscripción.Where(i => i.Matriculaestudiante.Equals(student.Matricula)).FirstOrDefault(); if (foundInscription != null) { foundInscription.GrupoID = _groupID; context.SaveChanges(); } studentList.Add(student); } } foreach (var student in studentList) { studentsCollection.Remove(student); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void RegisterButton_Click(object sender, RoutedEventArgs e) { try { using (SCPPContext context = new SCPPContext()) { var foundProfessor = context.Profesor.Find(TextBoxWorkerNumber.Text); if (foundProfessor == null) { if (VerificateFields()) { var professorRegistered = RegisterNewProfessor(); SendEmail(); ProfessorRegisteredMessage(professorRegistered); } } else { CustomMessageBox.ShowOK("Ya existe un profesor registrado con la matrícula ingresada con nombre: " + foundProfessor.Nombre, "Profesor ya registrado", "Aceptar"); } } } catch (EntityException) { Restarter.RestarSCPP(); } }
private void GetStudents() { studentsCollection = new ObservableCollection <Estudiante>(); using (SCPPContext context = new SCPPContext()) { var studentsListWithLessThan2Periods = context.Estudiante.Where(s => s.Inscripción.Count < 2); studentsListWithLessThan2Periods = studentsListWithLessThan2Periods.Where(s => s.Estado == "Inscrito"); var studentsListAlreadyAttending = context.Estudiante.Join( context.Inscripción, s => s.Matricula, i => i.Matriculaestudiante, (s, i) => new { student = s, inscription = i }) .Where(s2 => s2.inscription.Periodo == periodo) .Select(s2 => s2.student); var studentsList = studentsListWithLessThan2Periods.Except(studentsListAlreadyAttending); if (studentsList != null) { foreach (Estudiante student in studentsList) { if (student != null) { studentsCollection.Add(student); } } } } StudentsList.ItemsSource = studentsCollection; DataContext = studentsCollection; }
private Profesor RegisterNewProfessor() { Profesor professor = new Profesor { Nombre = TextBoxName.Text, Apellidopaterno = TextBoxLastName.Text, Apellidomaterno = TextBoxMothersLastName.Text, Numtrabajador = TextBoxWorkerNumber.Text, Correopersonal = TextBoxEMail.Text, Telefono = TextBoxPhone.Text, Contraseña = Encrypt.GetSHA256(TextBoxPassword.Password), Activo = 1 }; try { using (SCPPContext context = new SCPPContext()) { context.Profesor.Add(professor); context.SaveChanges(); } } catch (EntityException) { Restarter.RestarSCPP(); } return(professor); }
private void GetOrganization() { using (SCPPContext context = new SCPPContext()) { //recupera el id del responsable var resposable = context.Responsableproyecto.FirstOrDefault(a => a.Correopersonal.Equals(actualResposable.Correopersonal)); var proyectsList = context.Proyecto.Where(p => p.ResponsableproyectoID == resposable.ResponsableproyectoID); if (proyectsList != null) { foreach (var proyects in proyectsList) { if (proyects != null) { proyectsCollection.Add(proyects); } } } ProyectsList.ItemsSource = proyectsCollection; DataContext = ProyectsList; if (proyectsCollection.Count == 0) { Label.Content = "El resposable aun no cuenta con proyectos"; } } }
private void UploadFileButton_Click(object sender, RoutedEventArgs e) { OpenFileDialog dialog = new OpenFileDialog { Filter = "Report files | *.pdf; *.doc; *.docs; *.docx", FilterIndex = 1, InitialDirectory = new KnownFolder(KnownFolderType.Documents).Path, RestoreDirectory = true }; dialog.ShowDialog(); string filePath = dialog.FileName; Console.WriteLine(filePath); Stream myStream = null; try { myStream = dialog.OpenFile(); } catch (InvalidOperationException) { // Por si cancela el dialogo } if (myStream != null) { try { using (MemoryStream ms = new MemoryStream()) { myStream.CopyTo(ms); byte[] file = ms.ToArray(); using (SCPPContext context = new SCPPContext()) { Archivo oDocument = new Archivo { ExpedienteID = inscription.Expediente.First().ExpedienteID, Archivo1 = file, Fechaentrega = DateTime.Today, Titulo = dialog.SafeFileName, Validado = 0 }; context.Archivo.Add(oDocument); context.SaveChanges(); filesCollection.Add(oDocument); } CustomMessageBox.ShowOK("Archivo agregado con éxito.", "Éxito.", "Aceptar"); } } catch (EntityException) { Restarter.RestarSCPP(); } } }