public string EditarUsuario()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
dynamic datos = DbContext.usuario.FirstOrDefault(x => (x.id == this.objUsuario.id));
datos.complete_name = this.objUsuario.complete_name;
datos.dpi = this.objUsuario.dpi;
datos.email = this.objUsuario.email;
datos.address = this.objUsuario.address;
datos.phone = this.objUsuario.phone;
datos.cell_phone = this.objUsuario.cell_phone;
DbContext.SaveChanges();
}
}
catch (Exception ex)
{
strResultado = "Error al Actualizar el Registro.";
}
return(strResultado);
}
public string AsignarCursoProfesor()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
var AsignacionExistente = DbContext.teacher_course_assignement.FirstOrDefault(x => (x.id_course == this.objAsignacion.id_course &&
(x.id_teacher == this.objAsignacion.id_teacher)));
if (AsignacionExistente != null)
{
strResultado = String.Format("El profesor actual ya tiene asignado el curso seleccionado.");
}
else
{
teacher_course_assignement newAsignation = new teacher_course_assignement();
newAsignation = this.objAsignacion;
DbContext.teacher_course_assignement.Add(newAsignation = this.objAsignacion);
DbContext.SaveChanges();
}
}
}
catch (Exception e)
{
strResultado = "Error al guardar la carrera ingresada: " + e.Message.ToString();
}
return(strResultado);
}
public string ActualizarNota()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
dynamic datos = DbContext.incription_course.FirstOrDefault(x => (x.id == this.objIns.id));
datos.note = objIns.note;
datos.observation = objIns.observation;
datos.id_state = objIns.id_state;
DbContext.SaveChanges();
}
}
catch (Exception ex)
{
strResultado = "Error al Actualizar el Registro.";
}
return(strResultado);
}
public ActionResult Login(string admin, string password)
{
try
{
using (universityEntities db = new universityEntities())
{
var lst = from d in db.admin
where d.user == admin && d.password == password && d.idTeacher == 1
select d;
if (lst.Count() > 0)
{
admin admin1 = lst.First();
Session["Admin"] = admin1;
return(Content("1"));
}
else
{
return(Content("Error, admin invalido"));
}
}
}
catch (Exception ex)
{
return(Content("Error" + ex.Message));
}
}
public string EliminarAsignacion()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
var AsignacionExistente = DbContext.incription_course.FirstOrDefault(x => (x.id == this.objIns.id));
if (AsignacionExistente.id_state == 1)
{
DbContext.incription_course.Remove(AsignacionExistente);
DbContext.SaveChanges();
}
else
{
strResultado = "El estado de la inscripción no es abierta, no se puede modificar la inscripción a este curso.";
}
}
}
catch (Exception ex)
{
strResultado = "Error al eliminar el registro.";
}
return(strResultado);
}
// GET: SemestersValues
public IHttpActionResult Get()
{
List <semester> semesterList = new List <semester>();
using (universityEntities db = new universityEntities())
{
semesterList = (from s in db.semesters
select s).ToList();
return(Ok(semesterList));
}
}
// GET: StudentsValues
public IHttpActionResult Get()
{
List <student> studentList = new List <student>();
using (universityEntities db = new universityEntities())
{
studentList = (from s in db.students
select s).ToList();
return(Ok(studentList));
}
}
// GET: MajorValues
public IHttpActionResult Get()
{
List <major> majorList = new List <major>();
using (universityEntities db = new universityEntities())
{
majorList = (from m in db.majors
select m).ToList();
return(Ok(majorList));
}
}
// GET: CoursesValues
public IHttpActionResult Get()
{
List <cours> coursesList = new List <cours>();
using (universityEntities db = new universityEntities())
{
coursesList = (from c in db.courses
select c).ToList();
return(Ok(coursesList));
}
}
// GET: TeachersValues
public IHttpActionResult Get()
{
List <teacher> teacherList = new List <teacher>();
using (universityEntities db = new universityEntities())
{
teacherList = (from t in db.teachers
select t).ToList();
return(Ok(teacherList));
}
}
// GET: AdminValues
public IHttpActionResult Get()
{
List <admin> adminList = new List <admin>();
using (universityEntities db = new universityEntities())
{
adminList = (from a in db.admins
select a).ToList();
return(Ok(adminList));
}
}
// POST: SemestersValues
public IHttpActionResult Post(InsertSemester value)
{
using (universityEntities db = new universityEntities())
{
semester semester = new semester();
semester.name = value.name;
db.semesters.Add(semester);
db.SaveChanges();
}
return(Ok());
}
public IHttpActionResult post(CheckUser value)
{
List <administrative> adminitrativeList = new List <administrative>();
List <admin> adminList = new List <admin>();
List <student> studentList = new List <student>();
List <teacher> teacherList = new List <teacher>();
using (universityEntities db = new universityEntities())
{
adminitrativeList = (from a in db.administratives
where a.username == value.username && a.password == value.password
select a).ToList();
adminList = (from a in db.admins
where a.username == value.username && a.password == value.password
select a).ToList();
studentList = (from s in db.students
where s.username == value.username && s.password == value.password
select s).ToList();
teacherList = (from t in db.teachers
where t.username == value.username && t.password == value.password
select t).ToList();
if (adminitrativeList.Count == 1 && adminList.Count == 0 && studentList.Count == 0 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Administrative", Message = adminitrativeList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 1 && studentList.Count == 0 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Admin", Message = adminList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 0 && studentList.Count == 1 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Student", Message = studentList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 0 && studentList.Count == 0 && teacherList.Count == 1)
{
var result = new { Success = true, Role = "Teacher", Message = teacherList[0] };
return(Json(result));
}
else
{
var result = new { Success = false, Error = "Authentication failed, incorrect username or password." };
return(Json(result));
}
}
}
// POST: MajorValues
public IHttpActionResult Post(InsertMajor value)
{
using (universityEntities db = new universityEntities())
{
major major = new major();
major.name = value.name;
major.numberOfCredits = value.numberOfCredits;
db.majors.Add(major);
db.SaveChanges();
}
return(Ok());
}
public string AgregarUsuario()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
var UsuarioExistente = DbContext.usuario.FirstOrDefault(x => (x.email == objUsuario.email && (x.is_enabled == true || x.is_enabled == false)));
if ((UsuarioExistente != null) && (UsuarioExistente.is_enabled == true))
{
strResultado = String.Format("El usuario: \"{0}\" ya está registrado en el sistema.", objUsuario.complete_name);
}
else if ((UsuarioExistente != null) && (UsuarioExistente.is_enabled == false))
{
dynamic objUpdate = DbContext.usuario.First(x => (x.email == this.objUsuario.email));
objUpdate.complete_name = this.objUsuario.complete_name;
objUpdate.dpi = this.objUsuario.dpi;
objUpdate.email = this.objUsuario.email;
objUpdate.password = this.objUsuario.password;
objUpdate.address = this.objUsuario.address;
objUpdate.birth_date = this.objUsuario.birth_date;
objUpdate.phone = this.objUsuario.phone;
objUpdate.cell_phone = this.objUsuario.cell_phone;
objUpdate.id_career = this.objUsuario.id_career;
objUpdate.id_type = this.objUsuario.id_type;
objUpdate.is_enabled = true;
DbContext.SaveChanges();
}
else
{
usuario newUser = new usuario();
newUser = this.objUsuario;
DbContext.usuario.Add(newUser);
DbContext.SaveChanges();
}
}
}
catch (Exception e)
{
strResultado = "Error al guardar el usuario ingresado: " + e.Message.ToString();
}
return(strResultado);
}
// POST: MajorStudentsValues
public IHttpActionResult Post(InsertMajorStudent value)
{
using (universityEntities db = new universityEntities())
{
major_student major_Student = new major_student();
major_Student.majorID = value.majorID;
major_Student.studentID = value.studentID;
major_Student.enrollmentDate = value.enrollmentDate;
major_Student.finishedMajor = value.finishedMajor;
db.major_student.Add(major_Student);
db.SaveChanges();
}
return(Ok());
}
public ActionResult Edit(int Id)
{
TeacherViewModel model = new TeacherViewModel();
using (var db = new universityEntities())
{
var oTeacher = db.teacher.Find(Id);
model.Name = oTeacher.name;
model.Dni = oTeacher.dni;
model.SurName = oTeacher.surname;
model.Active = oTeacher.active;
model.Id = oTeacher.id;
}
return(View(model));
}
public ActionResult Subject()
{
List <UserTableSubjet> lst = null;
using (universityEntities db = new universityEntities())
{
lst = (from d in db.subjet
orderby d.name
select new UserTableSubjet
{
Id = d.id, Info = d.info, MaxStudent = d.maxStudent, Name = d.name, Teacher = d.teacher, Time = d.time
}).ToList();
}
return(View(lst));
}
// POST: CoursesValues
public IHttpActionResult Post(InsertCours value)
{
using (universityEntities db = new universityEntities())
{
cours cours = new cours();
cours.name = value.name;
cours.description = value.description;
cours.numberOfCredits = value.numberOfCredits;
cours.majorID = value.majorID;
cours.teacherID = value.teacherID;
db.courses.Add(cours);
db.SaveChanges();
}
return(Ok());
}
// GET: Teacher
public ActionResult Index()
{
List <AdminTableTeacher> lst = null;
using (universityEntities db = new universityEntities())
{
lst = (from d in db.teacher
where d.active == 1
orderby d.name
select new AdminTableTeacher {
Name = d.name, Id = d.id, Dni = d.dni, Surname = d.surname, Active = d.active
}).ToList();
}
return(View(lst));
}
public ActionResult Add(AdminViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new universityEntities())
{
admin admin = new admin();
admin.password = model.Password;
admin.user = model.User;
db.admin.Add(admin);
db.SaveChanges();
}
return(Redirect(Url.Content("~/Admin/Index")));
}
// POST api/values
public void PostStudent(insertStudent value)
{
using (universityEntities db = new universityEntities())
{
student student = new student();
student.firstName = value.firstName;
student.lastName = value.lastName;
student.fatherName = value.fatherName;
student.username = value.username;
student.password = value.password;
student.passwordHash = value.passwordHash;
student.address = value.address;
student.mobileNumber = value.mobileNumber;
student.email = value.email;
student.enrollmentDate = value.enrollmentDate;
}
}
public usuario IniciarSesion()
{
usuario user = null;
try
{
using (universityEntities DbContext = new universityEntities())
{
var VerificarUsuario = DbContext.usuario.FirstOrDefault(x => (x.email == objUsuario.email && x.password == objUsuario.password));
user = VerificarUsuario;
}
}
catch (Exception e)
{
user = null;
}
return(user);
}
// POST: TeachersValues
public IHttpActionResult Post(InsertTeacher value)
{
using (universityEntities db = new universityEntities())
{
teacher teacher = new teacher();
teacher.firstName = value.firstName;
teacher.lastName = value.lastName;
teacher.username = value.username;
teacher.password = value.password;
teacher.passwordHash = value.passwordhash;
teacher.address = value.address;
teacher.mobileNumber = value.mobileNumber;
teacher.email = value.email;
db.teachers.Add(teacher);
db.SaveChanges();
}
return(Ok());
}
public ActionResult Edit(TeacherViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new universityEntities())
{
var oTeacher = db.teacher.Find(model.Id);
oTeacher.name = model.Name;
oTeacher.surname = model.SurName;
oTeacher.active = model.Active;
oTeacher.dni = model.Dni;
db.Entry(oTeacher).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect(Url.Content("~/Teacher/Index")));
}
// POST: AdminValues
public IHttpActionResult Post(InsertAdmin value)
{
using (universityEntities db = new universityEntities())
{
admin admin = new admin();
admin.firstName = value.firstName;
admin.lastName = value.lastName;
admin.username = value.username;
admin.password = value.password;
admin.passwordHash = value.passwordhash;
admin.address = value.address;
admin.mobileNumber = value.mobileNumber;
admin.email = value.email;
db.admins.Add(admin);
db.SaveChanges();
}
return(Ok());
}
// POST: CoursesStudentsValues
public IHttpActionResult Post(InsertCourseStudent value)
{
using (universityEntities db = new universityEntities())
{
course_student course_Students = new course_student();
course_Students.courseID = value.courseID;
course_Students.studentID = value.studentID;
course_Students.courseYearOfEnrollment = value.courseYearOfEnrollment;
course_Students.passed = value.passed;
course_Students.semesterID = value.semesterID;
course_Students.midtermGrade = value.midtermGrade;
course_Students.finalGrade = value.finalGrade;
course_Students.attendanceGrade = value.attendanceGrade;
course_Students.grade = value.grade;
db.course_student.Add(course_Students);
db.SaveChanges();
}
return(Ok());
}
// POST: AdministrativesValues
public IHttpActionResult Post(InsertAdministrative value)
{
using (universityEntities db = new universityEntities())
{
administrative adminitrative = new administrative();
adminitrative.firstName = value.firstName;
adminitrative.lastName = value.lastName;
adminitrative.username = value.username;
adminitrative.password = value.password;
adminitrative.passwordHash = value.passwordhash;
adminitrative.address = value.address;
adminitrative.mobileNumber = value.mobileNumber;
adminitrative.email = value.email;
adminitrative.privilegeLevel = value.privilegeLevel;
db.administratives.Add(adminitrative);
db.SaveChanges();
}
return(Ok());
}
public string AgregarCurso()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
var CursoExistente = DbContext.course.FirstOrDefault(x => (x.name == objCurso.name && (x.is_enabled == true || x.is_enabled == false)));
if ((CursoExistente != null) && (CursoExistente.is_enabled == true))
{
strResultado = String.Format("El curso: \"{0}\" ya está registrado en el sistema.", objCurso.name);
}
else if ((CursoExistente != null) && (CursoExistente.is_enabled == false))
{
dynamic objUpdate = DbContext.course.First(x => (x.name == this.objCurso.name));
objUpdate.name = this.objCurso.name;
objUpdate.id_career = this.objCurso.id_career;
objUpdate.is_enabled = true;
DbContext.SaveChanges();
}
else
{
course newCourse = new course();
newCourse = this.objCurso;
DbContext.course.Add(newCourse);
DbContext.SaveChanges();
}
}
}
catch (Exception e)
{
strResultado = "Error al guardar el curso ingresado: " + e.Message.ToString();
}
return(strResultado);
}
public string AgregarCarrera()
{
string strResultado = string.Empty;
try
{
using (universityEntities DbContext = new universityEntities())
{
var CarreraExistente = DbContext.career.FirstOrDefault(x => (x.name == objCareer.name && (x.is_enabled == true || x.is_enabled == false)));
if ((CarreraExistente != null) && (CarreraExistente.is_enabled == true))
{
strResultado = String.Format("La Carrera: \"{0}\" ya está registrado en el sistema.", objCareer.name);
}
else if ((CarreraExistente != null) && (CarreraExistente.is_enabled == false))
{
dynamic objUpdate = DbContext.career.First(x => (x.name == this.objCareer.name));
objUpdate.name = this.objCareer.name;
objUpdate.description = this.objCareer.description;
objUpdate.is_enabled = true;
DbContext.SaveChanges();
}
else
{
career newCareer = new career();
newCareer = this.objCareer;
DbContext.career.Add(newCareer);
DbContext.SaveChanges();
}
}
}
catch (Exception e)
{
strResultado = "Error al guardar la carrera ingresada: " + e.Message.ToString();
}
return(strResultado);
}
