private void EditStudentFromDB(University_Student obj)
{
var childWindow = new EditStudentWindow() { DataContext = this, Title="Edit Student" };
CloseCommand = new Action(() => childWindow.Close());
StudentName = obj.First_Name;
StudentLastName = obj.Last_Name;
StudentEmail = obj.Email;
StudentBirthdate = obj.Birthday;
if (obj.Photo == null)
StudentPhoto = null;
else
StudentPhoto = ByteToImage(obj.Photo);
ButtonName = "Edit";
SaveButton = new Command<object>(UpdateStudent,
(s)=>!string.IsNullOrWhiteSpace(StudentName)
&& !string.IsNullOrWhiteSpace(StudentLastName)&& StudentBirthdate!=null);
childWindow.ShowDialog();
}
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 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 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 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 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();
}
}
private bool CanSaveStudentState(University_Student obj)
{
int tmpMark=0;
bool pars = int.TryParse(StudentMark,out tmpMark);
return CanPutStudentMark()||(pars&&tmpMark>=0&&tmpMark<=5);
}
