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