/// <summary>
/// Default contructor
/// </summary>
private StudentListDesignModel()
{
mItems = SqlDbConnect.CreateStudentsListViewModel();
FilteredItems = mItems;
SearchCommand = new RelayCommand(Search);
}
/// <summary>
/// Delete Student from data base
/// </summary>
public void Delete()
{
// Check if delete is
if (SqlDbConnect.DeleteInformation(int.Parse(StudentID.OriginalText)))
{
// Shows message that update was success
IoC.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Congratulation!",
Message = "Student was successfully deleted!",
OkText = "OK"
});
// Gets all new items from data base
StudentListDesignModel.Instance.Items = SqlDbConnect.CreateStudentsListViewModel();
// Shows block screen
IoC.Application.BlockScreenVisible = true;
}
}
/// <summary>
/// Save the student and close add student menu
/// </summary>
public void Save()
{
if (EntryBoxesValueCheck.Check(new List <TextEntryViewModel>
{
// Order is importnant
StudentProfilePhoto,
StudentFirstName,
StudentMiddleName,
StudentLastName,
StudentBirthDate,
StudentRegistration,
StudentCourse,
StudentGroup,
StudentFaculty,
StudentGender,
StudentINN,
StudentSNILS,
StudentProfilePhoto,
PassportNumber,
PassportSeries,
PassportIssuedBy,
PassportIssuedDate,
ParentLastName,
ParentFirstName,
ParentMiddleName,
ParentPhone,
SecondParentLastName,
SecondParentFirstName,
SecondParentMiddleName,
SecondParentPhone,
InsurencePolicyNumber,
InsurencePolicyCompany,
EducationFile1,
EducationEndDate1,
EducationFile2,
EducationEndDate2,
EducationFile3,
EducationEndDate3
}))
{
if (SqlDbConnect.CreateStudent(StudentLastName.OriginalText, StudentFirstName.OriginalText,
StudentGroup.OriginalText, StudentFaculty.OriginalText, StudentCourse.OriginalText,
StudentINN.OriginalText, StudentSNILS.OriginalText, PassportNumber.OriginalText,
PassportSeries.OriginalText, PassportIssuedBy.OriginalText, PassportIssuedDate.OriginalText,
InsurencePolicyNumber.OriginalText, InsurencePolicyCompany.OriginalText, _parents, _educations, StudentGender.OriginalText,
StudentRegistration.OriginalText, StudentBirthDate.OriginalText, StudentMiddleName.OriginalText))
{
IoC.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Congratulation!",
Message = "The student successfully added to data base!",
OkText = "OK"
});
IoC.Application.AddStudentMenuVisible = false;
IoC.Application.PictureControlVisible = false;
StudentListDesignModel.Instance.Items = SqlDbConnect.CreateStudentsListViewModel();
IoC.Application.SideMenuVisible = true;
}
}
else
{
IoC.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Error!",
Message = "The student hand't added to data base!",
OkText = "OK"
});
}
}
/// <summary>
/// When the save button is clicked, saves corrected information
/// </summary>
public void Save()
{
// Order is important
if (EntryBoxesValueCheck.Check(new List <TextEntryViewModel>
{
StudentID,
StudentFirstName,
StudentMiddleName,
StudentLastName,
StudentBirthDate,
StudentRegistration,
StudentCourse,
StudentGroup,
StudentFaculty,
StudentGender,
StudentINN,
StudentSNILS,
StudentProfilePhoto,
PassportNumber,
PassportSeries,
PassportIssuedBy,
PassportIssuedDate,
ParentLastName,
ParentFirstName,
ParentMiddleName,
ParentPhone,
SecondParentLastName,
SecondParentFirstName,
SecondParentMiddleName,
SecondParentPhone,
InsurencePolicyNumber,
InsurencePolicyCompany,
EducationFile1,
EducationEndDate1,
EducationFile2,
EducationEndDate2,
EducationFile3,
EducationEndDate3
}))
{
// Order is important
SqlDbConnect.UpdateInfromation(new List <TextEntryViewModel>
{
// Student table info
StudentID,
StudentLastName,
StudentFirstName,
StudentMiddleName,
StudentBirthDate,
StudentRegistration,
StudentCourse,
StudentGroup,
StudentFaculty,
StudentGender,
StudentINN,
StudentSNILS,
StudentProfilePhoto,
PassportNumber,
PassportSeries,
PassportIssuedBy,
PassportIssuedDate,
InsurencePolicyNumber,
InsurencePolicyCompany
}, new List <TextEntryViewModel>
{
// Parent table info
ParentLastName,
ParentFirstName,
ParentMiddleName,
ParentPhone,
SecondParentLastName,
SecondParentFirstName,
SecondParentMiddleName,
SecondParentPhone
}, new List <TextEntryViewModel>
{
// Education table info
EducationFile1,
EducationEndDate1,
EducationFile2,
EducationEndDate2,
EducationFile3,
EducationEndDate3
});
// Shows message that update was success
IoC.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Congratulation!",
Message = "Student information was successfully updated!",
OkText = "OK"
});
// Gets all new items from data base
StudentListDesignModel.Instance.Items = SqlDbConnect.CreateStudentsListViewModel();
}
else
{
// Shows message that update failed
IoC.UI.ShowMessage(new MessageBoxDialogViewModel
{
Title = "Error!",
Message = "Information didn't updated!",
OkText = "OK"
});
}
}
/// <summary>
/// Default contructer
/// </summary>
public StudentsInformationViewModel()
{
// Create commands
AttachmentButtonCommand = new RelayCommand(AttachmentButton);
PopupClickawayCommand = new RelayCommand(PopupClickaway);
SaveChangesCommand = new RelayCommand(Save);
DeleteCommand = new RelayCommand(Delete);
// Make a default menu
AttachmentMenu = new StudentInformationAttachmentPopupMenuViewModel();
StudentInformation = StudentInformation ?? SqlDbConnect.TakeStudents().FirstOrDefault();
teParents = _parents.Where(x => x.StudentId == StudentInformation.StudentID).ToList();
tempEducations = _educations.Where(x => x.StudentID == StudentInformation.StudentID).ToList();
// Student textboxes
StudentID = new TextEntryViewModel {
Label = "ID", OriginalText = StudentInformation.StudentID.ToString()
};
StudentFirstName = new TextEntryViewModel {
Label = "First Name", OriginalText = StudentInformation.StudentFirstName
};
StudentMiddleName = new TextEntryViewModel {
Label = "Middle Name", OriginalText = StudentInformation.StudentMiddleName
};
StudentLastName = new TextEntryViewModel {
Label = "Last Name", OriginalText = StudentInformation.StudentLastName
};
StudentBirthDate = new TextEntryViewModel {
Label = "Birth date", OriginalText = StudentInformation.StudentBirthDate.ToString("dd/M/yyyy")
};
StudentRegistration = new TextEntryViewModel {
Label = "Registration", OriginalText = StudentInformation.StudentRegistration
};
StudentCourse = new TextEntryViewModel {
Label = "Course", OriginalText = StudentInformation.StudentCourse.ToString()
};
StudentGroup = new TextEntryViewModel {
Label = "Group", OriginalText = StudentInformation.StudentGroup.ToString()
};
StudentFaculty = new TextEntryViewModel {
Label = "Faculty", OriginalText = StudentInformation.StudentFaculty.ToString()
};
StudentGender = new TextEntryViewModel {
Label = "Gender", OriginalText = StudentInformation.StudentGender
};
StudentINN = new TextEntryViewModel {
Label = "INN", OriginalText = StudentInformation.StudentINN.ToString()
};
StudentSNILS = new TextEntryViewModel {
Label = "SNILS", OriginalText = StudentInformation.StudentSNILS.ToString()
};
StudentProfilePhoto = new TextEntryViewModel {
Label = "Profile Photo", OriginalText = "lico.png"
};
//// Passport textboxes
PassportNumber = new TextEntryViewModel {
Label = "Number", OriginalText = StudentInformation.PassportNumber.ToString()
};
PassportSeries = new TextEntryViewModel {
Label = "Series", OriginalText = StudentInformation.PassportSeries.ToString()
};
PassportIssuedBy = new TextEntryViewModel {
Label = "Issued By", OriginalText = StudentInformation.PassportIssuedBy
};
PassportIssuedDate = new TextEntryViewModel {
Label = "Issued Date", OriginalText = StudentInformation.PassportIssuedDate.ToString("dd/M/yyyy")
};
// Parent textboxes
ParentLastName = new TextEntryViewModel {
Label = "Last Name", OriginalText = teParents.Count > 0 ? teParents[0].ParentLastName : " "
};
ParentFirstName = new TextEntryViewModel {
Label = "First Name", OriginalText = teParents.Count > 0 ? teParents[0].ParentFirstName : " "
};
ParentMiddleName = new TextEntryViewModel {
Label = "Middle Name", OriginalText = teParents.Count > 0 ? teParents[0].ParentMiddleName : " "
};
ParentPhone = new TextEntryViewModel {
Label = "Phone", OriginalText = teParents.Count > 0 ? teParents[0].ParentPhone.ToString() : " "
};
SecondParentLastName = new TextEntryViewModel {
Label = "Last Name", OriginalText = teParents.Count > 1 ? teParents[1].ParentLastName : " "
};
SecondParentFirstName = new TextEntryViewModel {
Label = "First Name", OriginalText = teParents.Count > 1 ? teParents[1].ParentFirstName : " "
};
SecondParentMiddleName = new TextEntryViewModel {
Label = "Middle Name", OriginalText = teParents.Count > 1 ? teParents[1].ParentMiddleName : " "
};
SecondParentPhone = new TextEntryViewModel {
Label = "Phone", OriginalText = teParents.Count > 1 ? teParents[1].ParentPhone.ToString() : " "
};
//// Insurance Policy textboxes
InsurencePolicyNumber = new TextEntryViewModel {
Label = "Number", OriginalText = StudentInformation.InsuranceNumber.ToString()
};
InsurencePolicyCompany = new TextEntryViewModel {
Label = "Company", OriginalText = StudentInformation.InsuranceCompany
};
//// Documents On Education textboxes
EducationFile1 = new TextEntryViewModel {
Label = "File", OriginalText = tempEducations.Count > 0 ? tempEducations[0].EducationFile : " "
};
EducationEndDate1 = new TextEntryViewModel {
Label = "Date Of End", OriginalText = tempEducations.Count > 0 ? tempEducations[0].EducationDateOfEnd.ToString("dd/M/yyyy") : " "
};
EducationFile2 = new TextEntryViewModel {
Label = "File", OriginalText = tempEducations.Count > 1 ? tempEducations[1].EducationFile : " "
};
EducationEndDate2 = new TextEntryViewModel {
Label = "Date Of End", OriginalText = tempEducations.Count > 1 ? tempEducations[1].EducationDateOfEnd.ToString("dd/M/yyyy") : " "
};
EducationFile3 = new TextEntryViewModel {
Label = "File", OriginalText = tempEducations.Count > 2 ? tempEducations[2].EducationFile : " "
};
EducationEndDate3 = new TextEntryViewModel {
Label = "Date Of End", OriginalText = tempEducations.Count > 2 ? tempEducations[2].EducationDateOfEnd.ToString("dd/M/yyyy") : " "
};
}
