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