public void Delete_Registered(int?enrolID) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { db.delete_registered(enrolID); } }
public void Registr_new_student(int?studentId, int?courseId, string regTime, double?courseFee) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { db.registeration(studentId, courseId, regTime, courseFee); } }
public void Update_Registered_Student(int?enrolID, int?studentId, int?courseId, string regTime, double?courseFee) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { db.update_registered(enrolID, studentId, courseId, regTime, courseFee); } }
public List <dynamic> Get_One_Registered(int id) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { return(db.Get_One_Registered(id).ToList <dynamic>()); } }
public void Update_Student(int id, string name, string email, string mobile, string address, DateTime?birthday) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { db.Update_Student(id, name, email, mobile, address, birthday); } }
public List <RegisterAll> edit_enrollment(int id) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var result = from r in db.Get_single_Registered(id) join s in db.Get_All_Student() on r.StudentID equals s.StudentID join c in db.Courses on r.CourseID equals c.CourseID select new RegisterAll { EnrollmentID = r.EnrollmentID, StudentID = r.StudentID, StudentName = s.StudentName, CourseName = c.CourseName, RegisterDate = r.RegisterDate, StudentFees = r.StudentFees, CourseID = r.CourseID }; //var result = GetEnrollments().Select(r=>new RegisterAll //{ // EnrollmentID = r.EnrollmentID, // StudentID = r.StudentID, // StudentName = r.StudentName, // CourseName = r.CourseName, // RegisterDate = r.RegisterDate, // StudentFees = r.StudentFees, // CourseID = r.CourseID //}); return(result.ToList()); } }
public List <Cours> GetCourse() { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { return(db.Courses.ToList()); } }
public List <Student> Get_All_Student() { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { return(db.Students.ToList()); } }
public List <RegisterAll> GetEnrollmentsOnSearch(string name) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var result = GetEnrollments().Where(s => s.StudentName.Contains(name)); return(result.ToList()); } }
public List <dynamic> GetOneStudent(int id) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { //var result = db.Students.Where(s=>s.StudentID==id); //return result.ToList(); return(db.Get_One_Student(id).ToList <dynamic>()); } //return db.Students.Where(s => s.StudentName.Contains(name)).ToList(); }
public List <Student> GetAllStudentOnSearch(string name) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var result = db.Students.Where(s => s.StudentName.Contains(name)); return(result.ToList()); } //return db.Students.Where(s => s.StudentName.Contains(name)).ToList(); }
public bool Check_user_input(int?studentID, int?course) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var select = from cour in db.Enrollments where (cour.CourseID == course && cour.StudentID == studentID) select cour; int count = select.Count(); if (count > 0) { return(false); } return(true); } }
public bool Check_user_input(string studentName, string studentEmail) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var select = from stu in db.Students where (stu.StudentName == studentName && stu.StudentEmail == studentEmail) select stu; int count = select.Count(); if (count > 0) { return(false); } return(true); } }
public void Delete_student(int id) { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { var select = db.Enrollments.Where(s => s.StudentID == id).Select(s => s.EnrollmentID); var count = select.Count(); for (int i = 0; i < count; i++) { var sel = (from e in db.Enrollments where e.StudentID == id select new { e.EnrollmentID }).FirstOrDefault(); db.delete_registered(sel.EnrollmentID); } db.Delete_Student(id); } }
public List <RegisterAll> GetEnrollments() { using (OmicronUniversityEntities db = new OmicronUniversityEntities()) { //return db.Enrollments.ToList(); StudentBAL stubal = new StudentBAL(); CourseBal courseBal = new CourseBal(); var Registrationlist = from s in stubal.Get_All_Student() join r in db.Enrollments on s.StudentID equals r.StudentID join c in courseBal.GetCourse() on r.CourseID equals c.CourseID select new RegisterAll { EnrollmentID = r.EnrollmentID, StudentID = r.StudentID, StudentName = s.StudentName, CourseName = c.CourseName, RegisterDate = r.RegisterDate, StudentFees = r.StudentFees, CourseID = r.CourseID }; return(Registrationlist.ToList()); } }