public ObservableCollection<Model.Person> SelectStudentsMemberInAllCourses()
{
using (var db=new EducationCourses())
{
return new ObservableCollection<Person>(db.StudentsMemberInAllCourses());
}
}
public System.Collections.ObjectModel.ObservableCollection<Model.Person> SelectStudentsMemberInCoursesThatTeacherGood()
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Person>(db.StudentsMemberInCoursesThatTeacherGood());
}
}
public List<Person> SelectAllStudents()
{
using (var db=new EducationCourses())
{
return db.Persons.Where(p => p.Type == PersonType.Student).ToList();
}
}
public void Update(Guid oldPersonID, Person newPerson)
{
using (var db = new EducationCourses())
{
Person oldPerson = db.Persons.SingleOrDefault(person => person.ID == oldPersonID);
oldPerson.Name = newPerson.Name;
oldPerson.Family = newPerson.Family;
oldPerson.Account = newPerson.Account;
oldPerson.Address = newPerson.Address;
oldPerson.BirthDay = newPerson.BirthDay;
oldPerson.Type = newPerson.Type;
oldPerson.Tel = newPerson.Tel;
oldPerson.Cities_ID = newPerson.Cities_ID;
oldPerson.Tel = newPerson.Tel;
oldPerson.Gender = newPerson.Gender;
oldPerson.Level = newPerson.Level;
oldPerson.Gender = newPerson.Gender;
oldPerson.NationalCode = newPerson.NationalCode;
db.SaveChanges();
if (this.PersonUpdated != null)
this.PersonUpdated(this, new CustomEventArgs<Person>(newPerson));
}
}
public List<State> SelectAllStates()
{
using (var db = new EducationCourses())
{
return db.States.ToList();
}
}
public List<Model.Person> SelectPersons()
{
using (var db = new EducationCourses())
{
return new List<Person>(db.Persons.ToList());
}
}
public Person SelectByID(Guid id)
{
using (var db = new EducationCourses())
{
return db.Persons.SingleOrDefault(person => person.ID == id);
}
}
public System.Collections.ObjectModel.ObservableCollection<Model.Person> SelectThreeFirstTeacherWithHighPrice()
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Person>(db.ThreeFirstTeacherWithHighPrice());
}
}
public System.Collections.ObjectModel.ObservableCollection<Model.Person> SelectTeachersThatTeachAllLessons()
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Person>(db.TeachersThatTeachAllLessons());
}
}
public ObservableCollection<Person> SelectTeachers()
{
using (var db=new EducationCourses())
{
return new ObservableCollection<Person>(db.Persons.Where(p => p.Type == PersonType.Teacher));
}
}
public List<Model.Location> SelectAll()
{
using (var db = new EducationCourses())
{
return db.Locations.ToList();
}
}
public List<Person> SelectStudentsOfCourse(Course course)
{
using (var db = new EducationCourses())
{
return new List<Person>(db.SelectStudentsByCourseNo(course.ID));
}
}
public ObservableCollection<Model.Course> SelectAll()
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Course>(db.Courses.Include("Location").Include("Person").Include("Lesson").ToList());
}
}
public ObservableCollection<Model.Person> SelectStudentsMemberInCoursesOfSpecialTeacher(Model.Person teacher)
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Person>(db.StudentsMemberInCoursesOfSpecialTeacher(teacher.ID));
}
}
public ObservableCollection<Location> SelectAllLocations()
{
using (var db = new EducationCourses())
{
return new ObservableCollection<Location>(db.Locations.ToList());
}
}
public List<Course> SelectAllCourses()
{
using (var db = new EducationCourses())
{
return new List<Course>
(db.Courses.Include("Person").Include("Lesson").Include("Location").ToList());
}
}
public void Insert(Course course,Person student)
{
using (var db=new EducationCourses())
{
db.MemberShips.Add(new MemberShip {ID=Guid.NewGuid(), Courses_ID = course.ID, Persons_ID = student.ID,
MemberShipDate = PersianDateTime.Now.Date.ToString().Substring(0,10)});
db.SaveChanges();
}
}
public List<Course> SelectAllCourses()
{
using (var db = new EducationCourses())
{
//return db.CoursesThatHaveCapacity().ToList();
return db.Courses.Include("Person").Include("Lesson").Where(c => c.Capacity > db.MemberShips.Where(m => m.Courses_ID == c.ID).Count()).ToList();
}
}
public void Insert(Model.Person person)
{
using (var db = new EducationCourses())
{
db.Persons.Add(person);
db.SaveChanges();
if (this.PersonAdded != null)
this.PersonAdded(this, new CustomEventArgs<Person>(person));
}
}
public void Delete(Person person)
{
using (var db=new EducationCourses())
{
db.Persons.Remove(db.Persons.SingleOrDefault(p => p.ID == person.ID));
db.SaveChanges();
if (this.PersonDeleted != null)
this.PersonDeleted(this, new CustomEventArgs<Person>(person));
}
}
public void Delete(Model.Course course)
{
using (var db = new EducationCourses())
{
db.Courses.Attach(course);
db.Courses.Remove(course);
db.SaveChanges();
if (this.CourseDeleted != null)
this.CourseDeleted(this, new CustomEventArgs<Course>(course));
}
}
public void Insert(string name)
{
using (var db=new EducationCourses())
{
Lesson lesson = new Lesson { ID = Guid.NewGuid(), Name = name };
db.Lessons.Add(lesson);
db.SaveChanges();
if (this.LessonAdded != null)
this.LessonAdded(this, new CustomEventArgs<Lesson>(lesson));
}
}
public void Insert(Model.Location location)
{
using (var db=new EducationCourses())
{
location.ID = Guid.NewGuid();
db.Locations.Add(location);
db.SaveChanges();
if (this.Added != null)
this.Added(this, new CustomEventArgs<Location>(location));
}
}
public void Delete(Model.Location location)
{
using (var db = new EducationCourses())
{
db.Locations.Attach(location);
db.Locations.Remove(location);
db.SaveChanges();
if (this.Deleted != null)
this.Deleted(this, new CustomEventArgs<Location>(location));
}
}
public void Insert(Model.Course course)
{
using (var db = new EducationCourses())
{
course.Location = null;
course.Lesson = null;
course.Person = null;
db.Courses.Add(course);
db.SaveChanges();
if (this.CourseAdded != null)
this.CourseAdded(this, new CustomEventArgs<Course>(course));
}
}
public void Update(Model.Course course, Guid id)
{
using (var db = new EducationCourses())
{
Course temp = db.Courses.Find(id);
temp.LengthClassTime = course.LengthClassTime;
temp.Lessons_ID = course.Lesson.ID;
temp.Persons_ID = course.Person.ID;
temp.StartTime = course.StartTime;
temp.Duration = course.Duration;
temp.Locations_ID = course.Location.ID;
temp.Cost = course.Cost;
temp.Capacity = course.Capacity;
temp.LengthClassTime = course.LengthClassTime;
db.SaveChanges();
if (this.CourseUpdated != null)
this.CourseUpdated(this, new CustomEventArgs<Course>(temp));
}
}
public List<Person> SearchPersonByName(string name)
{
using (var db = new EducationCourses())
{
return new List<Person>(db.Persons.Where(person => person.Name.StartsWith(name)).ToList());
}
}
public List<City> SelectCitiesByState(int stateId)
{
using (var db = new EducationCourses())
{
return db.Cities.Where(city=>city.States_ID==stateId).Select(c=>c).ToList();
}
}