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);
}
}
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;
}
}
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);
}
}
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);
}
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);
}
}
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;
}
}
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;
}
}
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;
}
}
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;
}
}