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); }