private void AddSubjectFromList(University_Subject obj)
{
using (_ujc = new UniversityEntities())
{
var currsubj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault();
var currgroup = _ujc.University_Group.Where(t => t.Group_ID == SelectedGroup.Group_ID).FirstOrDefault();
currgroup.University_Subject.Add(currsubj);
_ujc.SaveChanges();
GetCurrentSubjects(SelectedGroup);
GetAllSubjects();
}
}
private void AddStudentToGroup (University_Student parameter)
{
using (_ujc = new UniversityEntities())
{
var _selstud = _ujc.University_Student.Where(s=>s.Student_ID == parameter.Student_ID).FirstOrDefault();
var _group = _ujc.University_Group.Where(gr => gr.Group_ID == SelectedGroup.Group_ID).FirstOrDefault();
_group.University_Student.Add(_selstud);
_ujc.SaveChanges();
}
GetAllStudents();
GetCurrentStudents(SelectedGroup);
}
private void EditGroupFromDB(University_Group obj)
{
try
{
using (_ujc = new UniversityEntities())
{
var _group = _ujc.University_Group.Where(s => s.Group_ID == obj.Group_ID).FirstOrDefault();
_group.Group_Name = GroupNameEdit;
_ujc.SaveChanges();
}
}
catch { }
finally
{
RefreshIt();
}
}
private void AddNewGroupToDB(string obj)
{
try
{
using (_ujc = new UniversityEntities())
{
University_Group _group = new University_Group();
_group.Group_Name = obj;
_ujc.University_Group.Add(_group);
_ujc.SaveChanges();
}
}
catch { }
finally
{
RefreshIt();
}
}
void AddNewSubjectToDB(object parameter)
{
using (_ujc = new UniversityEntities())
{
_ujc.University_Subject.Add(new University_Subject()
{Subject_Name = NewSubject });
_ujc.SaveChanges();
}
NewSubject = null;
UpdateSubjects();
}
//Command Methods
private void DeleteGroupFromDB(University_Group obj)
{
try
{
using (_ujc = new UniversityEntities())
{
var _group = _ujc.University_Group.Where(s => s.Group_ID == obj.Group_ID).FirstOrDefault();
_ujc.University_Group.Remove(_group);
_ujc.SaveChanges();
}
}
finally
{
RefreshIt();
}
}
private void SaveEditedTeacherToDB(University_Teacher obj)
{
try
{
using (_ujc = new UniversityEntities())
{
var _teach = _ujc.University_Teacher.Where(s => s.Teacher_ID == SelectedTeacher.Teacher_ID).Single();
_teach.First_Name = Tname;
_teach.Last_Name = Tlname;
_teach.Birthday = Tbdate;
_teach.Email = Temail;
if (Tphoto != null)
{
_teach.Photo = ImageToByte(Tphoto);
}
_teach.Login = Tlogin;
_teach.Password = Tpwd;
_ujc.SaveChanges();
}
}
finally
{
EditEnabled = false;
EditButtonName = "Edit";
_editTeacher = new Command<University_Teacher>(EditTeacherFromDB, (S) => SelectedTeacher != null);
RaisePropertyChanged("EditTeacher");
AllowAddButton = true;
BlockGrid = true;
RefreshIt();
}
}
private void UpdateStudent(object parameter)
{
using (_ujc = new UniversityEntities())
{
//try
{
University_Student tmp = _ujc.University_Student.Single((st) => st.Student_ID == SelectedStudent.Student_ID);
tmp.First_Name = StudentName;
tmp.Last_Name = StudentLastName;
tmp.Birthday = StudentBirthdate;
tmp.Email = StudentEmail;
if (StudentPhoto!=null)
{
tmp.Photo = ImageToByte(StudentPhoto);
}
else tmp.Photo = ImageToByte(new BitmapImage(new Uri(@"G:\Универ\GoogleDrive_oldan\Bionic Final Project\UniversityJournal\UniversityJournal\bin\Debug\no_img.jpg")));
_ujc.SaveChanges();
UpdateStudentsList();
CloseCommand();
}
//catch
{
}
}
}
private void AddLessonToSchedule(object parameter)
{
using (_ujc = new UniversityEntities())
{
var _newLes = new University_Schedule();
_newLes.Day_of_week = SelectedDay;
_newLes.LessonNo = SelectedLessonNo;
_newLes.Group_ID = SelectedGroup.Group_ID;
_newLes.Subject_ID = SelectedSubject.Subject_ID;
_newLes.Teacher_ID = SelectedTeacher.Teacher_ID;
_ujc.University_Schedule.Add(_newLes);
_ujc.SaveChanges();
}
SelectedLessonNo = 0;
RaisePropertyChanged("SelecteLessonNo");
SelectedDay = null;
OnSelectedLessonNo();
UpdateSchedule();
}
private void SaveNewTeacherToDB(object obj)
{
try
{
using (_ujc = new UniversityEntities())
{
University_Teacher _teach = new University_Teacher();
_teach.First_Name = Tname;
_teach.Last_Name = Tlname;
_teach.Birthday = Tbdate;
_teach.Email = Temail;
if (Tphoto != null)
{
_teach.Photo = ImageToByte(Tphoto);
}
_teach.Login = Tlogin;
_teach.Password = Tpwd;
_ujc.University_Teacher.Add(_teach);
_ujc.SaveChanges();
}
}
catch { }
finally
{
EditEnabled = false;
AddButtonName = "Add New...";
_addNewTeacher = new Command<object>(AddNewTeacherToDB);
RaisePropertyChanged("AddNewTeacher");
BlockGrid = true;
RefreshIt();
}
}
private void DeleteLessonFromSchedule(Schedule parameter)
{
using (_ujc = new UniversityEntities())
{
var _delLes = _ujc.University_Schedule.Where(s => s.Lesson_ID == parameter.Lesson_ID).FirstOrDefault();
_ujc.University_Schedule.Remove(_delLes);
_ujc.SaveChanges();
}
UpdateSchedule();
}
private void EditSubjectFromDB(University_Subject obj)
{
using (_ujc = new UniversityEntities())
{
var subj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault();
if (subj != null)
{
subj.Subject_Name = CurrentSubject;
_ujc.SaveChanges();
}
UpdateSubjects();
}
}
void DeleteSubjectFromDB(University_Subject parameter)
{
using (_ujc = new UniversityEntities())
{
var tmp = _ujc.University_Subject.Where(s => s.Subject_ID == parameter.Subject_ID).FirstOrDefault();
if (tmp != null)
{
_ujc.University_Subject.Remove(tmp);
_ujc.SaveChanges();
SelectedSubject = null;
UpdateSubjects();
}
}
}
private void RemoveStudentFromGroup(University_Student obj)
{
using (_ujc = new UniversityEntities())
{
var currstud = _ujc.University_Student.Where(s => s.Student_ID == obj.Student_ID).FirstOrDefault();
var currgroup = _ujc.University_Group.Where(t => t.Group_ID == SelectedGroup.Group_ID).FirstOrDefault();
currgroup.University_Student.Remove(currstud);
_ujc.SaveChanges();
GetAllStudents();
GetCurrentStudents(SelectedGroup);
}
}
private void DeleteTeacherFromDB(University_Teacher obj)
{
try
{
using (_ujc = new UniversityEntities())
{
var _teach = _ujc.University_Teacher.Where(s => s.Teacher_ID == obj.Teacher_ID).FirstOrDefault();
_ujc.University_Teacher.Remove(_teach);
_ujc.SaveChanges();
}
}
finally
{
RefreshIt();
}
}
private void DeleteStudentFromDB(University_Student obj)
{
_ujc = new UniversityEntities();
var removestud = _ujc.University_Student.Single((s) => s.Student_ID == SelectedStudent.Student_ID);
_ujc.University_Student.Remove(removestud);
_ujc.SaveChanges();
UpdateStudentsList();
}
private void RemoveSubjectFromList(University_Subject obj)
{
using (_ujc = new UniversityEntities())
{
var currsubj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault();
var currteach = _ujc.University_Teacher.Where(t => t.Teacher_ID == SelectedTeacher.Teacher_ID).FirstOrDefault();
currteach.University_Subject.Remove(currsubj);
_ujc.SaveChanges();
GetCurrentSubjects(SelectedTeacher);
GetAllSubjects();
}
}
private void AddStudent(object parameter)
{
using (_ujc = new UniversityEntities())
{
try
{
University_Student tmp = new University_Student();
tmp.First_Name = StudentName;
tmp.Last_Name = StudentLastName;
tmp.Birthday = StudentBirthdate;
tmp.Email = StudentEmail;
if (StudentPhoto == null)
tmp.Photo = null;
else
tmp.Photo = ImageToByte(StudentPhoto);
_ujc.University_Student.Add(tmp);
_ujc.SaveChanges();
UpdateStudentsList();
CloseCommand();
}
catch { }
}
}
private void SaveStudentPresenceAndMark(University_Student obj)
{
using (_ujc = new UniversityEntities())
{
var _StudState = _ujc.University_StudentPresence
.Where(ls => ls.LessonID == SelectedLesson.Lesson_ID)
.Where(st => st.StudentID == SelectedStudent.Student_ID)
.Where(dt => dt.Date == LessonDate.Date).FirstOrDefault();
if (_StudState != null)
{
_StudState.Present = StudentPresent;
_StudState.Mark = Convert.ToInt32(StudentMark);
}
else
{
University_StudentPresence tmp = new University_StudentPresence();
tmp.LessonID = SelectedLesson.Lesson_ID;
tmp.StudentID = SelectedStudent.Student_ID;
tmp.Date = LessonDate.Date;
tmp.Present = StudentPresent;
tmp.Mark = Convert.ToInt32(StudentMark);
_ujc.University_StudentPresence.Add(tmp);
}
_ujc.SaveChanges();
SaveInfo = String.Format("Information about {0} {1} has been saved", SelectedStudent.Last_Name, SelectedStudent.First_Name);
OnSelectedLessonChange();
}
}
