Esempio n. 1
0
        public bool UpdateCurrentStudenNotes(decimal note1, decimal note2, decimal note3, decimal note4, int currentId, ref string error)
        {
            bool    Isupdate  = false;
            decimal TopeCorte = 1.25M;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    DetalleNotas detalleNotas = context.DetalleNotas.SingleOrDefault(e => e.IdDetalleNotas == currentId);
                    if (detalleNotas != null)
                    {
                        detalleNotas.Nota1     = note1;
                        detalleNotas.Nota2     = note2;
                        detalleNotas.Nota3     = note3;
                        detalleNotas.Nota4     = note4;
                        detalleNotas.TotalNota = ((note1 * TopeCorte) / 5) + (note2 * TopeCorte) / 5 + (note3 * TopeCorte) / 5 + (note4 * TopeCorte) / 5;
                        context.SaveChanges();
                        return(true);
                    }
                    return(Isupdate);
                }
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(Isupdate);
            }
        }
Esempio n. 2
0
        public DataTable GetCurrentStudensByMatter(int idMatter, int currentGroup, ref string error)
        {
            DataTable CurrentTable;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    var currentMatter = (from dn in context.DetalleNotas
                                         join e in context.Estudiante on dn.Id_Fr_Estudiantes_N equals e.IdEstudiante
                                         where dn.Id_Fr_Materia_N == idMatter && dn.Grupo == currentGroup
                                         select new { dn.IdDetalleNotas, e.Nombres, e.Apellidos, e.IdEstudiante, dn.Nota1, dn.Nota2, dn.Nota3, dn.Nota4, dn.TotalNota }).ToList();

                    CurrentTable = new DataTable();
                    CurrentTable.Columns.Add("Id", typeof(int));
                    CurrentTable.Columns.Add("IdStuden", typeof(int));
                    CurrentTable.Columns.Add("StudenName", typeof(string));
                    CurrentTable.Columns.Add("Note1", typeof(string));
                    CurrentTable.Columns.Add("Note2", typeof(string));
                    CurrentTable.Columns.Add("Note3", typeof(string));
                    CurrentTable.Columns.Add("Note4", typeof(string));
                    CurrentTable.Columns.Add("NoteTotal", typeof(string));

                    foreach (var item in currentMatter)
                    {
                        var row = CurrentTable.NewRow();
                        row["Id"]         = item.IdDetalleNotas;
                        row["IdStuden"]   = item.IdEstudiante;
                        row["StudenName"] = item.Nombres + " " + item.Apellidos;
                        row["Note1"]      = item.Nota1.ToString().Replace(",", ".");
                        row["Note2"]      = item.Nota2.ToString().Replace(",", ".");
                        row["Note3"]      = item.Nota3.ToString().Replace(",", ".");
                        row["Note4"]      = item.Nota4.ToString().Replace(",", ".");
                        row["NoteTotal"]  = item.TotalNota.ToString().Replace(",", ".");
                        CurrentTable.Rows.Add(row);
                    }
                }

                return(CurrentTable);
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(null);

                throw;
            }
        }
Esempio n. 3
0
        public bool UpdateCurrentUser(int idUser, string typeUser, string celular, string email, string facultad, string grado, string profesion, string idioma, string password, ref string error)
        {
            bool Isupdate = false;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    if (typeUser.Equals("student"))
                    {
                        Estudiante estudiante = context.Estudiante.SingleOrDefault(e => e.IdEstudiante == idUser);
                        if (estudiante != null)
                        {
                            estudiante.Telefono = celular;
                            estudiante.Email    = email;
                            estudiante.Clave    = password;
                            context.SaveChanges();
                            return(true);
                        }
                        return(Isupdate);
                    }
                    else
                    {
                        Profesor profesor = context.Profesor.SingleOrDefault(e => e.IdProfesor == idUser);
                        if (profesor != null)
                        {
                            profesor.Telefono          = celular;
                            profesor.Email             = email;
                            profesor.Facultad          = facultad;
                            profesor.TituloProfesional = profesion;
                            profesor.GradoEscolaridad  = grado;
                            profesor.Idiomas           = idioma;
                            profesor.Clave             = password;
                            context.SaveChanges();
                            return(true);
                        }
                        return(Isupdate);
                    }
                }
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(Isupdate);
            }
        }
Esempio n. 4
0
        public PLogin Login(string user, string password, string typeUser, ref string error)
        {
            PLogin CurrentStudent = new PLogin();

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    if (typeUser.Equals("student"))
                    {
                        Estudiante estudiante = (from p in context.Estudiante
                                                 where p.Documento == user & p.Clave == password
                                                 select p).FirstOrDefault();

                        if (estudiante != null)
                        {
                            CurrentStudent.IdCurrentUser   = estudiante.IdEstudiante;
                            CurrentStudent.CurrentUser     = estudiante.Nombres + " " + estudiante.Apellidos;
                            CurrentStudent.CurrentUserType = studen;
                        }
                    }
                    else
                    {
                        Profesor profesor = (from p in context.Profesor
                                             where p.Documento == user & p.Clave == password
                                             select p).FirstOrDefault();

                        if (profesor != null)
                        {
                            CurrentStudent.IdCurrentUser   = profesor.IdProfesor;
                            CurrentStudent.CurrentUser     = profesor.Nombres + " " + profesor.Apellidos;
                            CurrentStudent.CurrentUserType = teacher;
                        }
                    }
                }
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
            }
            return(CurrentStudent);
        }
Esempio n. 5
0
        public bool SendEmail(int idStudent, ref string error)
        {
            try
            {
                string Email = string.Empty;
                string Name  = string.Empty;
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    Estudiante estudiante = context.Estudiante.SingleOrDefault(e => e.IdEstudiante == idStudent);
                    if (estudiante != null)
                    {
                        Email = estudiante.Email;
                        Name  = estudiante.Nombres + " " + estudiante.Apellidos;
                    }
                }

                SmtpClient SmtpServer = new SmtpClient("smtp.live.com");
                var        mail       = new MailMessage();
                mail.From = new MailAddress("*****@*****.**");
                mail.To.Add(Email);
                mail.Subject    = "Notas académicas";
                mail.IsBodyHtml = true;
                string htmlBody;
                htmlBody = "Hola,\n" + Name + ", Se ha ingresado una nueva calificación, ingresa al portal de Notas académicas!\n"
                           + "link:http://*****:*****@hotmail.com", "Yosaberla2020");
                SmtpServer.EnableSsl             = true;
                SmtpServer.Send(mail);
                return(true);
            }
            catch (Exception ex)
            {
                error = ex.ToString();
                return(false);
            }
        }
Esempio n. 6
0
        public List <PCurrentMatterView> GetCurrentMattersTeacher(int idCurrentUser, ref string error)
        {
            List <PCurrentMatterView> pCurrentMatterViewList = new List <PCurrentMatterView>();
            PCurrentMatterView        pCurrentMatterView;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    var currentMatter = (from mt in context.Matricula
                                         join dm in context.DetalleMatricula on mt.IdMatricula equals dm.Id_Fr_Matricula
                                         join de in context.DetalleEstudiantes on dm.Id_Fr_Matricula equals de.Id_Fr_Matricula_E
                                         join Materia m in context.Materia on dm.IdMateria equals m.IdMateria
                                         join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                                         where dm.IdProfesor == idCurrentUser
                                         select new { dm.Id_Fr_Matricula, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor }).ToList();

                    foreach (var item in currentMatter)
                    {
                        pCurrentMatterView = new PCurrentMatterView();
                        pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
                        pCurrentMatterView.IdMatter       = item.IdMateria.ToString();
                        pCurrentMatterView.NameMatter     = item.Nombre;
                        pCurrentMatterView.NamberCredits  = (int)item.NumeroCredito;
                        pCurrentMatterView.Code           = item.Codigo;
                        pCurrentMatterView.IdTeacher      = item.IdProfesor.ToString();
                        pCurrentMatterViewList.Add(pCurrentMatterView);
                    }
                }
                return(pCurrentMatterViewList);
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(null);

                throw;
            }
        }
Esempio n. 7
0
        public PProfile GetCurrentProfileUser(int idCurrentUser, string typeUser, ref string error)
        {
            PProfile pProfile = new PProfile();

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    if (typeUser.Equals("student"))
                    {
                        Estudiante estudiante = (from p in context.Estudiante
                                                 where p.IdEstudiante == idCurrentUser
                                                 select p).FirstOrDefault();

                        if (estudiante != null)
                        {
                            pProfile.UserName       = estudiante.Nombres;
                            pProfile.LastName       = estudiante.Apellidos;
                            pProfile.DocumentType   = estudiante.TipoDocumento;
                            pProfile.Document       = estudiante.Documento;
                            pProfile.Gender         = estudiante.Sexo;
                            pProfile.Email          = estudiante.Email;
                            pProfile.PhoneNumber    = estudiante.Telefono;
                            pProfile.Birthdate      = Convert.ToDateTime(estudiante.FechaNacimiento).ToString("yyyy-MM-dd");
                            pProfile.Nationality    = estudiante.Nacionalidad;
                            pProfile.Career         = estudiante.ProgramaAcademico;
                            pProfile.CurrentLevel   = estudiante.NivelActual.ToString();
                            pProfile.GeneralAverage = 3.4;
                            pProfile.AdmissionDate  = Convert.ToDateTime(estudiante.FechaIngreso).ToString("yyyy-MM-dd");
                            pProfile.Headquarters   = estudiante.Sede;
                            pProfile.Password       = estudiante.Clave;
                            pProfile.PhoneNumber    = estudiante.Telefono;
                        }
                    }
                    else
                    {
                        Profesor profesor = (from p in context.Profesor
                                             where p.IdProfesor == idCurrentUser
                                             select p).FirstOrDefault();

                        if (profesor != null)
                        {
                            pProfile.UserName      = profesor.Nombres;
                            pProfile.LastName      = profesor.Apellidos;
                            pProfile.DocumentType  = profesor.TipoDocumento;
                            pProfile.Document      = profesor.Documento;
                            pProfile.Gender        = profesor.Sexo;
                            pProfile.Email         = profesor.Email;
                            pProfile.profession    = profesor.TituloProfesional;
                            pProfile.Address       = profesor.Direccion;
                            pProfile.PhoneNumber   = profesor.Telefono;
                            pProfile.Birthdate     = Convert.ToDateTime(profesor.FechaNacimiento).ToString("yyyy-MM-dd");
                            pProfile.AdmissionDate = Convert.ToDateTime(profesor.FechaIngreso).ToString("yyyy-MM-dd");
                            pProfile.Nationality   = profesor.Nacionalidad;
                            pProfile.CurrentLevel  = profesor.GradoEscolaridad;
                            pProfile.Password      = profesor.Clave;
                            pProfile.Faculty       = profesor.Facultad;
                        }
                    }
                }

                return(pProfile);
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(null);

                throw;
            }
        }
Esempio n. 8
0
        public List <PCMatterView> GetCurrentMatter(int idCurrentID, int idCurrentMatter, int idRegistration, int currentGroup, string typeUser, ref string error)
        {
            List <PCMatterView> pcMatterViewList = new List <PCMatterView>();
            PCMatterView        pCMatterView;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    if (typeUser.Equals("student"))
                    {
                        //var currentMatter = (from dn in context.DetalleNotas
                        //                     join m in context.Materia on dn.Id_Fr_Materia_N equals m.IdMateria
                        //                     join e in context.Estudiante on dn.Id_Fr_Estudiantes_N equals e.IdEstudiante
                        //                     join dm in context.DetalleMatricula on dn.Id_Fr_Matricula_N equals dm.Id_Fr_Matricula
                        //                     join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                        //                     join mt in context.Matricula on dn.Id_Fr_Matricula_N equals mt.IdMatricula
                        //                     where dn.Id_Fr_Estudiantes_N == idCurrentID && dn.Id_Fr_Matricula_N == idRegistration && dn.Id_Fr_Materia_N == idCurrentMatter
                        //                     select new { dm.Horario, m.Nivel, mt.PeriodoAcademico, m.IdMateria, m.Nombre, m.Codigo, p.Nombres, p.Apellidos, m.NumeroCredito, dn.Nota1, dn.Nota2, dn.Nota3, dn.Nota4 }).ToList();

                        var currentMatter = (from dn in context.DetalleNotas
                                             join m in context.Materia on dn.Id_Fr_Materia_N equals m.IdMateria
                                             join mt in context.Matricula on dn.Id_Fr_Matricula_N equals mt.IdMatricula
                                             where dn.Id_Fr_Estudiantes_N == idCurrentID && dn.Id_Fr_Matricula_N == idRegistration && dn.Id_Fr_Materia_N == idCurrentMatter && dn.Grupo == currentGroup
                                             select new { m.Nivel, m.IdMateria, mt.PeriodoAcademico, m.Nombre, m.Codigo, m.NumeroCredito, dn.Nota1, dn.Nota2, dn.Nota3, dn.Nota4 }).ToList();

                        var currentDetMat = (from dm in context.DetalleMatricula
                                             join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                                             where dm.IdMateria == idCurrentMatter && dm.Id_Fr_Matricula == idRegistration && dm.Grupo == currentGroup
                                             select new { dm.Horario, p.Nombres, p.Apellidos }).ToList();

                        foreach (var item in currentMatter)
                        {
                            pCMatterView = new PCMatterView();
                            pCMatterView.Qualifications = new List <string>();
                            pCMatterView.Level          = (int)item.Nivel;
                            pCMatterView.Schedule       = currentDetMat[0].Horario;
                            pCMatterView.CademicPeriod  = item.PeriodoAcademico;
                            pCMatterView.IdMatter       = item.IdMateria.ToString();
                            pCMatterView.Name           = item.Nombre;
                            pCMatterView.NamberCredits  = (int)item.NumeroCredito;
                            pCMatterView.Code           = item.Codigo;
                            pCMatterView.TeacherName    = currentDetMat[0].Nombres + " " + currentDetMat[0].Apellidos;
                            pCMatterView.Qualifications.Add(item.Nota1.ToString().Replace(",", "."));
                            pCMatterView.Qualifications.Add(item.Nota2.ToString().Replace(",", "."));
                            pCMatterView.Qualifications.Add(item.Nota3.ToString().Replace(",", "."));
                            pCMatterView.Qualifications.Add(item.Nota4.ToString().Replace(",", "."));
                            pcMatterViewList.Add(pCMatterView);
                        }
                    }
                    else
                    {
                        var currentMatter = (from dm in context.DetalleMatricula
                                             join m in context.Materia on dm.IdMateria equals m.IdMateria
                                             join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                                             join mt in context.Matricula on dm.Id_Fr_Matricula equals mt.IdMatricula
                                             where dm.IdMateria == idCurrentMatter && dm.Id_Fr_Matricula == idRegistration
                                             select new { dm.Grupo, m.Nivel, mt.PeriodoAcademico, m.IdMateria, dm.Horario, m.Nombre, m.Codigo, p.Nombres, p.Apellidos, m.NumeroCredito }).ToList();


                        foreach (var item in currentMatter)
                        {
                            pCMatterView               = new PCMatterView();
                            pCMatterView.Level         = (int)item.Nivel;
                            pCMatterView.Schedule      = item.Horario;
                            pCMatterView.CademicPeriod = item.PeriodoAcademico;
                            pCMatterView.IdMatter      = item.IdMateria.ToString();
                            pCMatterView.Name          = item.Nombre;
                            pCMatterView.NamberCredits = (int)item.NumeroCredito;
                            pCMatterView.Code          = item.Codigo;
                            pCMatterView.TeacherName   = item.Nombres + " " + item.Apellidos;
                            pcMatterViewList.Add(pCMatterView);
                        }
                    }
                }

                return(pcMatterViewList);
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(null);

                throw;
            }
        }
Esempio n. 9
0
        public List <PCurrentMatterView> GetCurrentMattersByUser(int idCurrentUser, string typeUser, ref string error)
        {
            List <PCurrentMatterView> pCurrentMatterViewList = new List <PCurrentMatterView>();
            PCurrentMatterView        pCurrentMatterView;

            try
            {
                using (NotasAcademicasEntities context = new NotasAcademicasEntities())
                {
                    if (typeUser.Equals("student"))
                    {
                        var currentMatter = (from mt in context.Matricula
                                             join dm in context.DetalleMatricula on mt.IdMatricula equals dm.Id_Fr_Matricula
                                             join de in context.DetalleEstudiantes on dm.Id_Fr_Matricula equals de.Id_Fr_Matricula_E
                                             join Materia m in context.Materia on dm.IdMateria equals m.IdMateria
                                             join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                                             where de.Id_Fr_Estudiantes_E == idCurrentUser & de.Estado == true && mt.Estado == true
                                             select new { dm.Id_Fr_Matricula, dm.Grupo, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor, p.Nombres, p.Apellidos }).ToList();

                        foreach (var item in currentMatter)
                        {
                            pCurrentMatterView = new PCurrentMatterView();
                            pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
                            pCurrentMatterView.IdMatter       = item.IdMateria.ToString();
                            pCurrentMatterView.NameMatter     = item.Nombre;
                            pCurrentMatterView.NamberCredits  = (int)item.NumeroCredito;
                            pCurrentMatterView.Code           = item.Codigo;
                            pCurrentMatterView.IdTeacher      = item.IdProfesor.ToString();
                            pCurrentMatterView.NameTeacher    = item.Nombres + " " + item.Apellidos;
                            pCurrentMatterView.Group          = item.Grupo.ToString();
                            pCurrentMatterViewList.Add(pCurrentMatterView);
                        }
                    }
                    else
                    {
                        var currentMatter = (from dm in context.DetalleMatricula
                                             join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
                                             join m in context.Materia on dm.IdMateria equals m.IdMateria
                                             join mt in context.Matricula on dm.Id_Fr_Matricula equals mt.IdMatricula
                                             where dm.IdProfesor == idCurrentUser && mt.Estado == true
                                             select new { dm.Grupo, dm.Id_Fr_Matricula, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor }).ToList();

                        foreach (var item in currentMatter)
                        {
                            pCurrentMatterView = new PCurrentMatterView();
                            pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
                            pCurrentMatterView.IdMatter       = item.IdMateria.ToString();
                            pCurrentMatterView.NameMatter     = item.Nombre + "(" + item.Grupo + ")";
                            pCurrentMatterView.NamberCredits  = (int)item.NumeroCredito;
                            pCurrentMatterView.Code           = item.Codigo;
                            pCurrentMatterView.IdTeacher      = item.IdProfesor.ToString();
                            pCurrentMatterView.Group          = item.Grupo.ToString();
                            pCurrentMatterViewList.Add(pCurrentMatterView);
                        }
                    }
                }
                return(pCurrentMatterViewList);
            }
            catch (System.Exception ex)
            {
                error = ex.ToString();
                return(null);

                throw;
            }
        }