public bool Validate(Draftee draftee)
{
if (draftee.FirstName.Length > 128)
{
Message = "Имя призывника не должно быть больше 128 символов!";
return(false);
}
if (draftee.LastName.Length > 128)
{
Message = "Фамилия призывника не должна быть больше 128 символов!";
return(false);
}
if (draftee.Patronymic.Length > 128)
{
Message = "Отчество призывника не должно быть больше 128 символов!";
return(false);
}
if (draftee.BirthPlace.Length > 512)
{
Message = "Место рождения призывника не должно быть больше 512 символов!";
return(false);
}
if (draftee.Category.Length > 64)
{
Message = "Категория призывника не должна быть больше 64 символов!";
return(false);
}
if (draftee.TroopType.Length > 512)
{
Message = "Роды войск призывника не должны быть больше 512 символов!";
return(false);
}
Message = "OK";
return(true);
}
private void FillData(Draftee draftee)
{
FirstNameValueLabel.Content = draftee.FirstName;
LastNameValueLabel.Content = draftee.LastName;
PatronymicValueLabel.Content = draftee.Patronymic;
BirthDateValueLabel.Content = draftee.BirthDate?.ToString("yyyy.MM.dd");
}
private static void OnDrafteePropertyChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
var view = (EditDrafteeCommonInfoWindow)sender;
Draftee draftee = view.Draftee;
if (e.Property == LastNameProperty)
{
draftee.LastName = (string)e.NewValue;
}
else if (e.Property == FirstNameProperty)
{
draftee.FirstName = (string)e.NewValue;
}
else if (e.Property == PatronymicProperty)
{
draftee.Patronymic = (string)e.NewValue;
}
else if (e.Property == BirthDateProperty)
{
draftee.BirthDate = (DateTime)e.NewValue;
}
else if (e.Property == BirthPlaceProperty)
{
draftee.BirthPlace = (string)e.NewValue;
}
else if (e.Property == CategoryProperty)
{
draftee.Category = (string)e.NewValue;
}
else if (e.Property == TroopTypeProperty)
{
draftee.TroopType = (string)e.NewValue;
}
}
private void FillData(Draftee draftee)
{
FirstNameValueLabel.Content = draftee.FirstName;
LastNameValueLabel.Content = draftee.LastName;
PatronymicValueLabel.Content = draftee.Patronymic;
BirthDateValueLabel.Content = draftee.BirthDate?.ToString("yyyy.MM.dd");
BirthPlaceValueLabel.Text = draftee.BirthPlace;
CategoryValueLabel.Text = draftee.Category;
TroopTypeValueLabel.Text = draftee.TroopType;
}
private void OnLoaded(object sender, RoutedEventArgs routedEventArgs)
{
draftee = GetCurrentDraftee();
LastNameValueLabel.Content = draftee.LastName;
FirstNameValueLabel.Content = draftee.FirstName;
PatronymicValueLabel.Content = draftee.Patronymic;
BirthDateValueLabel.Content = draftee.BirthDate?.ToString("yyyy.MM.dd");
foreach (var relative in GetCurrentRelatives())
{
AddRelative(relative);
}
}
private static void OnDrafteeChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
Draftee newDraftee = (Draftee)e.NewValue;
EditDrafteeAddressWindow view = (EditDrafteeAddressWindow)sender;
view.LastName = newDraftee.LastName;
view.FirstName = newDraftee.FirstName;
view.Patronymic = newDraftee.Patronymic;
if (newDraftee.BirthDate != null)
{
view.BirthDate = newDraftee.BirthDate;
}
}
private void OnLoaded(object sender, RoutedEventArgs routedEventArgs)
{
draftee = GetCurrentDraftee();
LastNameValueLabel.Content = draftee.LastName;
FirstNameValueLabel.Content = draftee.FirstName;
PatronymicValueLabel.Content = draftee.Patronymic;
BirthDateValueLabel.Content = draftee.BirthDate?.ToString("yyyy.MM.dd");
ForeignLanguagesText.Text = draftee.ForeignLanguages;
foreach (var place in GetCurrentEducationPlaces())
{
AddEducationPlace(place);
}
}
private void OnLoaded(object sender, RoutedEventArgs routedEventArgs)
{
Draftee draftee = GetCurrentDraftee();
if (draftee != null)
{
Draftee = draftee;
}
else
{
Draftee = new Draftee();
}
}
private static void OnDrafteeChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
Draftee newDraftee = (Draftee)e.NewValue;
EditDrafteeCommonInfoWindow view = (EditDrafteeCommonInfoWindow)sender;
view.LastName = newDraftee.LastName;
view.FirstName = newDraftee.FirstName;
view.Patronymic = newDraftee.Patronymic;
if (newDraftee.BirthDate != null)
{
view.BirthDate = newDraftee.BirthDate;
}
view.BirthPlace = newDraftee.BirthPlace;
view.Category = newDraftee.Category;
view.TroopType = newDraftee.TroopType;
}
public void Insert(Draftee draftee)
{
MySqlConnection connection = ConnectionUtils.GetConnection();
try
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder
.Append("INSERT INTO draftees ")
.Append("(last_name, first_name, patronymic, birth_date, birth_place, category, troop_type, foreign_languages) ")
.Append("VALUES (")
.Append("'")
.Append(draftee.LastName)
.Append("', ")
.Append("'")
.Append(draftee.FirstName)
.Append("', ")
.Append("'")
.Append(draftee.Patronymic)
.Append("', ")
.Append("'")
.Append(draftee.BirthDate?.ToString("yyyy-MM-dd"))
.Append("', ")
.Append("'")
.Append(draftee.BirthPlace)
.Append("', ")
.Append("'")
.Append(draftee.Category)
.Append("', ")
.Append("'")
.Append(draftee.TroopType)
.Append("', ")
.Append("'")
.Append(draftee.ForeignLanguages)
.Append("');");
connection.Open();
MySqlCommand drafteeCommand = new MySqlCommand(sqlBuilder.ToString(), connection);
drafteeCommand.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public void Update(Draftee draftee)
{
MySqlConnection connection = ConnectionUtils.GetConnection();
try
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder
.Append("UPDATE draftees SET ")
.Append("last_name='")
.Append(draftee.LastName)
.Append("', ")
.Append("first_name='")
.Append(draftee.FirstName)
.Append("', ")
.Append("patronymic='")
.Append(draftee.Patronymic)
.Append("', ")
.Append("birth_date='")
.Append(draftee.BirthDate?.ToString("yyyy-MM-dd"))
.Append("', ")
.Append("birth_place='")
.Append(draftee.BirthPlace)
.Append("', ")
.Append("category='")
.Append(draftee.Category)
.Append("', ")
.Append("troop_type='")
.Append(draftee.TroopType)
.Append("', ")
.Append("foreign_languages='")
.Append(draftee.ForeignLanguages)
.Append("' ")
.Append("WHERE id=")
.Append(draftee.Id)
.Append(";");
MySqlCommand command = new MySqlCommand(sqlBuilder.ToString(), connection);
connection.Open();
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public DataTable GetListByDraftee(Draftee draftee)
{
return(GetListByDraftee(draftee.Id));
}
public void Insert(Draftee draftee, Address address)
{
MySqlConnection connection = ConnectionUtils.GetConnection();
MySqlTransaction transaction = null;
try
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder
.Append("INSERT INTO draftees ")
.Append("(last_name, first_name, patronymic, birth_date, birth_place, category, troop_type, foreign_languages) ")
.Append("VALUES (")
.Append("'")
.Append(draftee.LastName)
.Append("', ")
.Append("'")
.Append(draftee.FirstName)
.Append("', ")
.Append("'")
.Append(draftee.Patronymic)
.Append("', ")
.Append("'")
.Append(draftee.BirthDate?.ToString("yyyy-MM-dd"))
.Append("', ")
.Append("'")
.Append(draftee.BirthPlace)
.Append("', ")
.Append("'")
.Append(draftee.Category)
.Append("', ")
.Append("'")
.Append(draftee.TroopType)
.Append("', ")
.Append("'")
.Append(draftee.ForeignLanguages)
.Append("');");
connection.Open();
transaction = connection.BeginTransaction();
MySqlCommand drafteeCommand = new MySqlCommand(sqlBuilder.ToString(), connection, transaction);
drafteeCommand.ExecuteNonQuery();
StringBuilder addressBuilder = new StringBuilder();
addressBuilder
.Append("INSERT INTO addresses ")
.Append("(draftee_id, municipal_district, mail_index, street_name, ")
.Append("house_number, housing_number, apartment, home_phone) ")
.Append("VALUES (")
.Append("last_insert_id()")
.Append(", '")
.Append(address.MunicipalDistrict)
.Append("', ")
.Append("'")
.Append(address.MailIndex)
.Append("', ")
.Append("'")
.Append(address.StreetName)
.Append("', ")
.Append("'")
.Append(address.HouseNumber)
.Append("', ")
.Append("'")
.Append(address.HousingNumber)
.Append("', ")
.Append("'")
.Append(address.Apartment)
.Append("', ")
.Append("'")
.Append(address.HomePhone)
.Append("');");
MySqlCommand addressCommand = new MySqlCommand(addressBuilder.ToString(), connection, transaction);
addressCommand.ExecuteNonQuery();
string documentSql = "INSERT INTO documents (draftee_id) VALUES (last_insert_id());";
MySqlCommand documentCommand = new MySqlCommand(documentSql, connection, transaction);
documentCommand.ExecuteNonQuery();
transaction.Commit();
}
catch
{
transaction?.Rollback();
}
finally
{
transaction?.Dispose();
connection.Close();
}
}
public void Delete(Draftee draftee)
{
Delete(draftee.Id);
}
