private void ListView_TeamDetail_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
if (sender is ListViewItem item && item.IsMouseOver)
{
ViewModel.SelectedPersonFromTeam.IsSelected = true;
var sql = $"EXEC pr_AccountNumberRegisteredChanged \'{ViewModel.SelectedPersonFromTeam.PassportSerial}\', 1 ";
using (var sqlcmd = new SqlCommandExecutor(sql))
sqlcmd.TryExecuteNonQuery(out _);
}
}
// Убираем человека из команды
private void MenuItem_RemovePersonFromTeam_OnClick(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Вы уверены, что хотите убрать из команды призывника?", "Внимание!", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return;
}
using (var sqlcmd = new SqlCommandExecutor($"EXEC pr_DeassignTeam \'{ViewModel.SelectedPersonFromTeam.PassportSerial}\'"))
if (sqlcmd.TryExecuteNonQuery(out _))
{
ViewModel.PersonFromTeamList.Remove(ViewModel.SelectedPersonFromTeam);
}
}
// Убираем желтую полоску, т.е, что ему прописали в военнике карту
private void MenuItem_RevertAccountNumberAssigment_OnClick(object sender, RoutedEventArgs e)
{
ViewModel.SelectedPersonFromTeam.IsSelected = false;
var sql = $"EXEC pr_AccountNumberRegisteredChanged \'{ViewModel.SelectedPersonFromTeam.PassportSerial}\', 0 ";
using (var sqlcmd = new SqlCommandExecutor(sql))
sqlcmd.TryExecuteNonQuery(out _);
if (sender is ListView listView)
{
listView.SelectedIndex = -1;
}
}
// Создание новой команды
private void Button_CreateTeam_Click(object sender, EventArgs e)
{
if (ViewModel.CreateTeamOutgoing?.Length != 0 && ViewModel.CreateTeamTeam?.Length != 0)
{
var sql = $"EXEC pr_CreateTeam \'{ViewModel.CreateTeamOutgoing}\', \'{ViewModel.CreateTeamTeam}\' ";
using (var sqlcmd = new SqlCommandExecutor(sql))
{
if (sqlcmd.TryExecuteNonQuery(out _))
{
ViewModel.CreateTeamOutgoing = string.Empty;
ViewModel.CreateTeamTeam = string.Empty;
Button_RefreshTeamList_Click(sender, EventArgs.Empty);
}
}
}
}
// Изменение исходящего команды
private void MenuItem_ChangeOutgoing_OnClick(object sender, RoutedEventArgs e)
{
var outgoing = TextPopupWindow.Prompt("Введи номер нового исходника", "Внимание!");
if (outgoing == null)
{
return;
}
var newOutgoing = int.Parse(outgoing);
using (var sqlcmd = new SqlCommandExecutor($"EXEC pr_TransferTeam \'{ViewModel.SelectedTeam.Inventory}\', \'{newOutgoing}\'"))
if (sqlcmd.TryExecuteNonQuery(out _))
{
ViewModel.SelectedTeam.Inventory = newOutgoing.ToString();
}
Button_RefreshTeamList_Click(sender, e);
}
// Суем в команду по двойному щелчку
private void ListView_Item_DoubleClick(object sender, MouseButtonEventArgs e)
{
if (ViewModel.SelectedPersonToAssignTeam == null || ViewModel.SelectedTeam == null || e.ChangedButton == MouseButton.Right)
{
return;
}
var sql = $"EXEC pr_AssignTeam \'{ViewModel.SelectedPersonToAssignTeam.PassportSerial}\', \'{ViewModel.SelectedTeam.Inventory}\' ";
using (var sqlcmd = new SqlCommandExecutor(sql))
{
if (sqlcmd.TryExecuteNonQuery(out _))
{
ViewModel.PersonFromTeamList.Add(new PersonFromTeam(ViewModel.SelectedPersonToAssignTeam));
ViewModel.PersonToAssignTeamList.Remove(ViewModel.SelectedPersonToAssignTeam);
}
}
}
public void Drop(IDropInfo dropInfo)
{
if (TeamsViewModel.SelectedTeam == null)
{
return;
}
if (dropInfo.Data is PersonsWithCardList sourceItem && dropInfo.TargetCollection is IList targetCollection)
{
var sql = $"EXEC pr_AssignTeam \'{sourceItem.PassportSerial}\', \'{TeamsViewModel.SelectedTeam.Inventory}\' ";
using (var sqlcmd = new SqlCommandExecutor(sql))
{
if (sqlcmd.TryExecuteNonQuery(out _) && dropInfo.DragInfo.SourceCollection is IList sourceCollection)
{
targetCollection.Add(new PersonFromTeam(sourceItem));
sourceCollection.Remove(sourceItem);
}
}
}
}
// Удаление команды
private void MenuItem_DeleteTeam_OnClick(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Вы уверены, что хотите удалить команду?", "Внимание!", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return;
}
using (var sqlcmd = new SqlCommandExecutor($"EXEC pr_GetTeamPersonCount \'{ViewModel.SelectedTeam.Inventory}\'"))
if (sqlcmd.TryExecuteScalar(out var result) && result is int value && value > 0)
{
MessageBox.Show("В команде остались призывники!", "Ошибка!", MessageBoxButton.OK);
return;
}
using (var sqlcmd = new SqlCommandExecutor($"EXEC pr_DeleteTeam \'{ViewModel.SelectedTeam.Inventory}\'"))
if (sqlcmd.TryExecuteNonQuery(out _))
{
ViewModel.TeamList.Remove(ViewModel.SelectedTeam);
}
}
private void Button_Upload_Click(object sender, RoutedEventArgs e)
{
if (!ViewModel.Files.Any(f => f.IsSelected))
{
MessageBox.Show("Не выбран файл", "Внимание!");
return;
}
foreach (var file in ViewModel.Files.Where(f => f.IsSelected))
{
var hasError = false;
foreach (var person in ExcelUtils.LoadInputForm(file.Path))
{
var sql = $@"
EXECUTE pr_AddPerson
'{person.PassportSerial}'
,'{person.LastName}'
,'{person.FirstName}'
,'{person.Patronymic}'
,'{person.BirthDate}'
,'{person.BirthPlace}'
,'{person.PassportIssue}'
,'{person.PassportIssueDate}'
,'{person.PassportDivisionCode}'
,'{person.Address}'
,'{person.PhoneHome}'
,'{person.PhoneMobile}'
,{person.RecruitmentOfficeID}
,'{person.Codeword}'
,'{person.Comment}'
";
using (var sqlComm = new SqlCommandExecutor(sql))
if (!sqlComm.TryExecuteNonQuery(out _))
{
hasError = true;
}
}
file.IsImported = !hasError;
file.HasError = hasError;
}
}
