private static void OnEducationPlacePropertyChanged(DependencyObject sender,
DependencyPropertyChangedEventArgs e)
{
var view = (EducationPlaceView)sender;
EducationPlace place = view.EducationPlace;
if (e.Property == EducationProperty)
{
place.Education = (string)e.NewValue;
}
else if (e.Property == EducationNameProperty)
{
place.Name = (string)e.NewValue;
}
else if (e.Property == InstitutionTypeProperty)
{
place.InstitutionType = (string)e.NewValue;
}
else if (e.Property == EndDateProperty)
{
place.EndDate = (DateTime?)e.NewValue;
}
else if (e.Property == FacultyProperty)
{
place.Faculty = (string)e.NewValue;
}
else if (e.Property == SpecialtyProperty)
{
place.Specialty = (string)e.NewValue;
}
}
private void AddEducationPlace(EducationPlace place)
{
educationPlaces.Add(place);
var view = new EducationPlaceView();
view.Margin = new Thickness(5);
view.CollapseButtons = false;
view.EducationPlace = place;
view.DeleteButtonClicked += (sender, args) =>
{
if (view.EducationPlace.Id > 0)
{
idsForDelete.Add(view.EducationPlace.Id);
}
EducationPlacePanel.Children.Remove(view);
educationPlaces.Remove(view.EducationPlace);
};
view.EditButtonClicked += (sender, args) =>
{
var window = new EditEducationWindow();
window.Owner = this;
window.EducationPlaceView = view;
window.ShowDialog();
};
EducationPlacePanel.Children.Add(view);
}
private void FillData(EducationPlace place)
{
EducationText.Text = place.Education;
EducationPlaceNameText.Text = place.Name;
InstitutionTypeText.Text = place.InstitutionType;
if (place.EndDate != null)
{
EndDateText.Text = place.EndDate.Value.ToString("yyyy.MM.dd");
}
FacultyText.Text = place.Faculty;
SpecialtyText.Text = place.Specialty;
}
public void Update(EducationPlace educationPlace)
{
MySqlConnection connection = ConnectionUtils.GetConnection();
try
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder
.Append("UPDATE study_places SET ")
.Append("name='")
.Append(educationPlace.Name)
.Append("', ")
.Append("education='")
.Append(educationPlace.Education)
.Append("', ")
.Append("institution_type='")
.Append(educationPlace.InstitutionType)
.Append("', ");
if (educationPlace.EndDate != null)
{
sqlBuilder.Append("end_date='")
.Append(educationPlace.EndDate.Value.ToString("yyyy-MM-dd"))
.Append("', ");
}
else
{
sqlBuilder.Append("end_date=")
.Append("NULL")
.Append(", ");
}
sqlBuilder.Append("faculty='")
.Append(educationPlace.Faculty)
.Append("', ")
.Append("specialty='")
.Append(educationPlace.Specialty)
.Append("' ")
.Append("WHERE id=")
.Append(educationPlace.Id)
.Append(";");
MySqlCommand command = new MySqlCommand(sqlBuilder.ToString(), connection);
connection.Open();
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
private static void OnEducationPlaceChanged(DependencyObject sender,
DependencyPropertyChangedEventArgs e)
{
EducationPlace newPlace = (EducationPlace)e.NewValue;
EducationPlaceView view = (EducationPlaceView)sender;
view.Education = newPlace.Education;
view.EducationName = newPlace.Name;
view.InstitutionType = newPlace.InstitutionType;
if (newPlace.EndDate != null)
{
view.EndDate = newPlace.EndDate.Value;
}
view.Faculty = newPlace.Faculty;
view.Specialty = newPlace.Specialty;
}
public void Insert(EducationPlace educationPlace)
{
MySqlConnection connection = ConnectionUtils.GetConnection();
try
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder
.Append("INSERT INTO study_places ")
.Append("(draftee_id, name, education, institution_type, end_date, faculty, specialty) ")
.Append("VALUES (")
.Append(educationPlace.DrafteeId)
.Append(", ")
.Append("'")
.Append(educationPlace.Name)
.Append("', ")
.Append("'")
.Append(educationPlace.Education)
.Append("', ")
.Append("'")
.Append(educationPlace.InstitutionType)
.Append("', ");
if (educationPlace.EndDate != null)
{
sqlBuilder.Append("'")
.Append(educationPlace.EndDate.Value.ToString("yyyy-MM-dd"))
.Append("', ");
}
else
{
sqlBuilder.Append("NULL, ");
}
sqlBuilder.Append("'")
.Append(educationPlace.Faculty)
.Append("', ")
.Append("'")
.Append(educationPlace.Specialty)
.Append("');");
connection.Open();
MySqlCommand drafteeCommand = new MySqlCommand(sqlBuilder.ToString(), connection);
drafteeCommand.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
private void AddEducationPlaceButton_OnClick(object sender, RoutedEventArgs e)
{
EducationPlace place = new EducationPlace();
place.DrafteeId = DrafteeId;
EducationPlaceView view = new EducationPlaceView();
view.EducationPlace = place;
var window = new EditEducationWindow();
window.EducationPlaceView = view;
window.Owner = this;
window.ShowDialog();
if (window.ApplyClicked)
{
AddEducationPlace(place);
}
}
public void Delete(EducationPlace educationPlace)
{
Delete(educationPlace.Id);
}
