public List <GetNameSocialNetworks_Result> ListSocialNetworksCatalog()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
return(context.GetNameSocialNetworks().ToList());
}
}
public List <StudentApproval_Result> ListStudentApproval()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
return(context.StudentApproval().ToList());
}
}
public List <SelectAcademicDegree_Result> ListAcademicDegree()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
return(context.SelectAcademicDegree().ToList());
}
}
public List <GetProvinces_Result> ListAllProvinces()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
return(context.GetProvinces().ToList());
}
}
public int Add(Student student, Location location, User user)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.InsertUpdateStudent(student.Id,
user.Username,
user.Password,
user.IsAdministrator,
user.Status,
student.StudentCard,
student.StudentName,
student.LastName,
student.Birthday,
student.Mail,
student.Image,
student.RegistrationStatus,
location.ProvinceId,
location.CantonId,
location.DistrictId,
"Insert");
}
return(resultToReturn);
}
public List <SelectStudent_Result> ListAllStudents()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var students = context.SelectStudent().ToList();
return(students);
}
}
public GetAppointmentById_Result GetAppointmentById(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var appointment = context.GetAppointmentById(id).Single();
return(appointment);
}
}
public List <GetCantonsByIdProvince_Result> ListCantonsByIdProvince(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var cantons = context.GetCantonsByIdProvince(id).ToList();
return(cantons);
}
}
public List <GetSocialNetworksByIdProfessor_Result> GetSocialNetworksByIdProfessor(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var socialNetworks = context.GetSocialNetworksByIdProfessor(id).ToList();
return(socialNetworks);
}
}
public List <SelectProfessor_Result> ListAllProfessors()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var professors = context.SelectProfessor().ToList();
return(professors);
}
}
public List <SelectUsers_Result> ListAllUsers()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var users = context.SelectUsers().ToList();
return(users);
}
}
public List <GetProfessorByIdCourse_Result> GetProfessorByIdCourse(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var professorCourses = context.GetProfessorByIdCourse(id).ToList();
return(professorCourses);
}
}
public List <SelectCourse_Result> ListAllCourses()
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var courses = context.SelectCourse().ToList();
return(courses);
}
}
public GetCourseById_Result GetCourseById(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var course = context.GetCourseById(id).Single();
return(course);
}
}
public List <GetDistrictsByIdCanton_Result> ListDistrictsByIdCanton(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var districts = context.GetDistrictsByIdCanton(id).ToList();
return(districts);
}
}
public List <GetAppointmentProfessor_Result> GetAppointmentProfessor(int professorId, int courseId)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var appointment = context.GetAppointmentProfessor(professorId, courseId).ToList();
return(appointment);
}
}
public List <GetRepliesPrivateMessage_Result> GetRepliesPrivateMessage(int privateMessageId)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var replies = context.GetRepliesPrivateMessage(privateMessageId).ToList();
return(replies);
}
}
public GetProfessorById_Result GetProfessorById(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var professor = context.GetProfessorById(id).Single();
return(professor);
}
}
public List <GetRepliesPublicConsultation_Result> GetRepliesPublicConsultation(int publicConsultationId)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var replies = context.GetRepliesPublicConsultation(publicConsultationId).ToList();
return(replies);
}
}
public List <GetPrivateMessage_Result> GetPrivateMessage(int courseId, int professorId)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var privateMessage = context.GetPrivateMessage(courseId, professorId).ToList();
return(privateMessage);
}
}
public List <GetPublicConsultation_Result> GetPublicConsultation(int courseId, int professorId)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var publicConsultation = context.GetPublicConsultation(courseId, professorId).ToList();
return(publicConsultation);
}
}
public List <GetStudentCourses_Result> GetStudentCourses(int id)
{
using (var context = new MVC_IF4101MVCLPACEntities())
{
var studentCourses = context.GetStudentCourses(id).ToList();
return(studentCourses);
}
}
public int UpdateImage(Student student)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.UpdateStudentImage(student.Image, student.Id);
}
return(resultToReturn);
}
public int UpdateImage(Professor professor)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.UpdateProfessorImage(professor.Image, professor.Id);
}
return(resultToReturn);
}
public int UpdateStudentStatus(int id, String status)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.UpdateStatusStudent(id, status);
}
return(resultToReturn);
}
public int DeleteProfessor(int id)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.DeleteProfessor(id);
}
return(resultToReturn);
}
public int AddStudentCourse(StudentCourse studentCourse)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.InsertStudentCourse(studentCourse.StudentId,
studentCourse.CourseId);
}
return(resultToReturn);
}
public int AddProfessorCourse(ProfessorCourse professorCourse)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.InsertProfessorCourse(professorCourse.ProfessorId,
professorCourse.CourseId);
}
return(resultToReturn);
}
public int UpdateStatusAppointment(Appointment appointment)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.StatusAppointment(
appointment.Id,
appointment.Accepted);
}
return(resultToReturn);
}
public int AddSocialNetwork(SocialNetworksProfessor socialNetworksProfessor)
{
int resultToReturn;
using (var context = new MVC_IF4101MVCLPACEntities())
{
resultToReturn = context.InsertUpdateSocialNetworkProfessor(socialNetworksProfessor.Id,
socialNetworksProfessor.ProfessorId,
socialNetworksProfessor.Url,
socialNetworksProfessor.SocialNetworksNameId,
"Insert");
}
return(resultToReturn);
}
