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 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 bool CanSaveStudentState(University_Student obj)
{
int tmpMark = 0;
bool pars = int.TryParse(StudentMark, out tmpMark);
return(CanPutStudentMark() || (pars && tmpMark >= 0 && tmpMark <= 5));
}
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 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 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);
}
