private void EditMissingPeople()
{
var context = new PSOConnect();
var checkExistPeople = context.people.FirstOrDefault(peoples => peoples.family.Equals(FamilyField.Text) && peoples.name.Equals(NameField.Text) && peoples.middleName.Equals(MiddleNameField.Text) && EntityFunctions.TruncateTime(peoples.dateOfBirth.Value) == EntityFunctions.TruncateTime(DateOfBirthField.Value));
var checkExistMissingPeople = context.missingPeople.FirstOrDefault(missingPeoples => missingPeoples.specialSign.Equals(SpecialSignField.Text) && missingPeoples.lastLocation.Equals(LastLocationField.Text) && EntityFunctions.TruncateTime(missingPeoples.dateOfLoss.Value) == EntityFunctions.TruncateTime(DateOfLossField.Value));
var people = context.people.FirstOrDefault(peoples => peoples.idPeople == _idPeople);
var missingPeople = context.missingPeople.FirstOrDefault(missingPeoples => missingPeoples.idPeople == _idPeople);
if (checkExistMissingPeople != null && checkExistPeople != null && checkExistMissingPeople.idPeople != _idPeople && checkExistPeople.idPeople != _idPeople)
{
_deletedElementInListInfo?.Invoke();
context.people.Remove(people);
context.missingPeople.Remove(missingPeople);
context.SaveChanges();
return;
}
people.family = FamilyField.Text;
people.name = NameField.Text;
people.middleName = MiddleNameField.Text;
people.dateOfBirth = DateOfBirthField.Value;
missingPeople.specialSign = SpecialSignField.Text;
missingPeople.lastLocation = LastLocationField.Text;
missingPeople.dateOfLoss = DateOfLossField.Value;
_updatedListInfo?.Invoke($"{people.idPeople}-ФАМИЛИЯ: {FamilyField.Text} ИМЯ: {NameField.Text} ОТЧЕСТВО: {MiddleNameField.Text} ДАТА РОЖДЕНИЯ: {DateOfBirthField.Value.ToLongDateString()}\n ДАТА ПРОПАЖИ: {DateOfLossField.Value.ToLongDateString()} ПОСЛЕДНЕЕ МЕСТО: {LastLocationField.Text} ОПИСАНИЕ: {SpecialSignField.Text}");
context.SaveChanges();
}
private void AddMissingPeople()
{
var context = new PSOConnect();
var people = context.people.FirstOrDefault(peoples => peoples.family.Equals(FamilyField.Text) && peoples.name.Equals(NameField.Text) && peoples.middleName.Equals(MiddleNameField.Text) && EntityFunctions.TruncateTime(peoples.dateOfBirth.Value) == EntityFunctions.TruncateTime(DateOfBirthField.Value));
var missingPeople = context.missingPeople.FirstOrDefault(missingPeoples => missingPeoples.specialSign.Equals(SpecialSignField.Text) && missingPeoples.lastLocation.Equals(LastLocationField.Text) && EntityFunctions.TruncateTime(missingPeoples.dateOfLoss.Value) == EntityFunctions.TruncateTime(DateOfLossField.Value));
if (people == null || missingPeople == null)
{
var newPeople = new people
{
idPeople = context.people.Count() > 0 ? context.people.Max(idPeople => idPeople.idPeople) + 1 : 1,
family = FamilyField.Text,
name = NameField.Text,
middleName = MiddleNameField.Text,
dateOfBirth = DateOfBirthField.Value
};
var newMissingPeople = new missingPeople
{
idPeople = context.missingPeople.Count() > 0 ? context.missingPeople.Max(idPeople => idPeople.idPeople) + 1 : 1,
specialSign = SpecialSignField.Text,
lastLocation = LastLocationField.Text,
dateOfLoss = DateOfLossField.Value
};
context.people.Add(newPeople);
context.missingPeople.Add(newMissingPeople);
context.SaveChanges();
}
}
private void AddDepartment()
{
var context = new PSOConnect();
var mainDepartment = context.mainDepartment.FirstOrDefault(mainDepartments => mainDepartments.address.Equals(MainDepartmentField.Text));
mainDepartment currentMainDepartment = null;
if (mainDepartment == null)
{
currentMainDepartment = new mainDepartment
{
idMainDepartment = context.mainDepartment.Count() > 0 ? context.mainDepartment.Max(mainDepartments => mainDepartments.idMainDepartment) + 1 : 1,
address = MainDepartmentField.Text
};
context.mainDepartment.Add(currentMainDepartment);
}
var idMainDepartment = mainDepartment == null ? currentMainDepartment.idMainDepartment : mainDepartment.idMainDepartment;
var department = context.department.FirstOrDefault(departments => departments.address.Equals(DepartmentField.Text) && departments.idMainDepartment == idMainDepartment);
department currentDepartment = null;
if (department == null)
{
currentDepartment = new department
{
idDepartment = context.department.Count() > 0 ? context.department.Max(departments => departments.idDepartment) + 1 : 1,
address = DepartmentField.Text,
};
context.department.Add(currentDepartment);
var mainDep = mainDepartment == null ? currentMainDepartment : mainDepartment;
mainDep.department.Add(currentDepartment);
}
var idDepartment = department == null ? currentDepartment.idDepartment : department.idDepartment;
var region = context.region.FirstOrDefault(regions => regions.address.Equals(RegionField.Text) && regions.idDepartment == idDepartment);
region currentRegion = null;
if (region == null)
{
currentRegion = new region
{
idRegion = context.region.Count() > 0 ? context.region.Max(regions => regions.idRegion) + 1 : 1,
address = RegionField.Text
};
context.region.Add(currentRegion);
var depart = department == null ? currentDepartment : department;
depart.region.Add(currentRegion);
}
context.SaveChanges();
}
private void DeleteDepartmentButtonClick(object sender, EventArgs e)
{
if (ListInfo.Items.Count == 0)
{
MessageBox.Show("Список пропавших людей пуст!");
return;
}
if (ListInfo.SelectedItems.Count == 0)
{
MessageBox.Show("Не выбрано ни одного элемента! Пожалуйста, выберите пропавшего человека");
return;
}
var context = new PSOConnect();
var count = ListInfo.SelectedItems.Count;
for (var i = 0; i < count; i++)
{
var idRegion = int.Parse(ListInfo.SelectedItems[i].ToString().Split('-')[0].Split('{')[1]);
var region = context.region.FirstOrDefault(regions => regions.idRegion == idRegion);
var department = context.department.FirstOrDefault(departmanets => departmanets.idDepartment == region.idDepartment);
var mainDepartment = context.mainDepartment.FirstOrDefault(mainDepartments => mainDepartments.idMainDepartment == department.idMainDepartment);
foreach (var coordinator in context.coordinator)
{
if (coordinator.idRegion == idRegion)
{
coordinator.idRegion = null;
}
}
ListInfo.Items.Remove(ListInfo.SelectedItems[i]);
context.region.Remove(region);
if (department.region.Count < 1)
{
context.department.Remove(department);
}
if (mainDepartment.department.Count < 1)
{
context.mainDepartment.Remove(mainDepartment);
}
}
context.SaveChanges();
var message = count > 1 ? "Департамены успешно удалены" : "Департамент успешно удалён";
MessageBox.Show(message);
}
private void DeleteDisasterButtonClick(object sender, EventArgs e)
{
if (ListInfo.Items.Count == 0)
{
MessageBox.Show("Список катастроф пуст!");
return;
}
if (ListInfo.SelectedItems.Count == 0)
{
MessageBox.Show("Не выбрано ни одного элемента! Пожалуйста, выберите катастрофу");
return;
}
var context = new PSOConnect();
var count = ListInfo.SelectedItems.Count;
for (var i = 0; i < count; i++)
{
var idReason = int.Parse(ListInfo.SelectedItems[0].ToString().Split('-')[0].Split('{')[1]);
var reason = context.reason.FirstOrDefault(reasons => reasons.idReason == idReason);
var disaster = context.disaster.FirstOrDefault(disasters => disasters.idDisaster == reason.idDisaster);
foreach (var team in context.team)
{
if (team.idDisaster == disaster.idDisaster && disaster.reason.Count < 1)
{
team.idDisaster = null;
}
}
context.reason.Remove(reason);
if (disaster.reason.Count < 1)
{
context.disaster.Remove(disaster);
}
ListInfo.Items.Remove(ListInfo.SelectedItems[0]);
context.SaveChanges();
}
var message = count > 1 ? "Катастрофы успешно удалены" : "Катастрофа успешно удалёна";
MessageBox.Show(message);
}
private void RegistrationUser()
{
var context = new PSOConnect();
var user = context.user.FirstOrDefault(findUser => findUser.login.Equals(LoginField.Text));
if (user != null)
{
MessageBox.Show("Пользователь с таким логином уже существует, измените логин!");
return;
}
var lastIdUser = context.user.Count() > 0 ? context.user.Max(users => users.idUser) : 0;
var idProfession = context.profession.FirstOrDefault(profession => profession.position.Equals(ProfessionField.SelectedItem.ToString())).idProfession;
var currentUser = new user
{
idUser = lastIdUser + 1,
login = LoginField.Text,
password = PasswordField.Text,
family = FamilyField.Text,
name = NameField.Text,
middleName = MiddleNameField.Text,
idProfession = idProfession
};
Login.CurrentUser = currentUser;
context.user.Add(currentUser);
context.SaveChanges();
MessageBox.Show("Пользователь успешно добавлен!");
if (ProfessionField.SelectedItem.Equals(Admin))
{
new AdminMenu(_loginForm);
}
else if (ProfessionField.SelectedItem.Equals(Coordinator))
{
new CoordinatorMenu(_loginForm);
}
else
{
new OtherUsersMenu(_loginForm);
}
ResetFields();
Hide();
}
private bool CheckExist()
{
var context = new PSOConnect();
var checkExist = false;
var department = from region in context.region
join departments in context.department on region.idDepartment equals departments.idDepartment
join mainDepartment in context.mainDepartment on departments.idMainDepartment equals mainDepartment.idMainDepartment
select new
{
AddressRegion = region.address,
AddressDepartment = departments.address,
AddressMainDepartment = mainDepartment.address
};
foreach (var depart in department)
{
if (depart.AddressRegion.Equals(RegionField.Text) && depart.AddressDepartment.Equals(DepartmentField.Text) && depart.AddressMainDepartment.Equals(MainDepartmentField.Text))
{
checkExist = true;
break;
}
}
if (checkExist)
{
var region = context.region.FirstOrDefault(regions => regions.idRegion == _idRegion);
var dep = context.department.FirstOrDefault(departments => departments.idDepartment == region.idDepartment);
var mainDepartment = context.mainDepartment.FirstOrDefault(mainDepartments => mainDepartments.idMainDepartment == dep.idMainDepartment);
context.region.Remove(region);
if (dep.region.Count < 1)
{
context.department.Remove(dep);
}
if (mainDepartment.department.Count < 1)
{
context.mainDepartment.Remove(mainDepartment);
}
context.SaveChanges();
_deletedElementInListInfo?.Invoke();
return(true);
}
return(false);
}
private void EditDisaster()
{
if (CheckExist())
{
return;
}
var context = new PSOConnect();
var reason = context.reason.FirstOrDefault(reasons => reasons.idReason == _idReason);
var disaster = context.disaster.FirstOrDefault(disasters => disasters.idDisaster == reason.idDisaster);
var checkExistDisaster = context.disaster.FirstOrDefault(disasters => disasters.country.Equals(CountryField.Text) && disasters.city.Equals(CityField.Text) && EntityFunctions.TruncateTime(disasters.date.Value) == EntityFunctions.TruncateTime(DateField.Value));
disaster currentDisaster;
reason.reason1 = ReasonField.Text;
reason.typeReason = TypeField.SelectedItem.ToString();
if (disaster.reason.Count == 1)
{
currentDisaster = disaster;
currentDisaster.country = CountryField.Text;
currentDisaster.city = CityField.Text;
currentDisaster.date = DateField.Value;
}
else if (checkExistDisaster != null)
{
currentDisaster = checkExistDisaster;
checkExistDisaster.reason.Add(reason);
}
else
{
currentDisaster = new disaster
{
idDisaster = context.disaster.Count() > 0 ? context.disaster.Max(idDisaster => idDisaster.idDisaster) + 1 : 1,
country = CountryField.Text,
city = CityField.Text,
date = DateField.Value
};
currentDisaster.reason.Add(reason);
context.disaster.Add(currentDisaster);
}
_updatedListInfo?.Invoke($"{reason.idReason}-ТИП: {TypeField.SelectedItem} ПРИЧИНА: {ReasonField.Text} СТРАНА: {CountryField.Text} ГОРОД: {CityField.Text} ДАТА: {DateField.Value.ToLongDateString()}");
context.SaveChanges();
}
private void EditProfesson()
{
if (CheckExist())
{
return;
}
var context = new PSOConnect();
var equipment = context.equipment.FirstOrDefault(equipments => equipments.idEquipment == _idEquipment);
equipment.equipmentName = NameEquipmentField.Text;
equipment.type = TypeEqupmentField.SelectedItem.ToString();
equipment.description = DescriptionEqupmentField.Text;
var profession = context.profession.FirstOrDefault(professions => professions.idProfession == equipment.idProfession);
var checkExistProfession = context.profession.FirstOrDefault(professions => professions.position.Equals(ProfessionField.Text));
profession currentProfession = null;
if (profession.equipment.Count == 1)
{
currentProfession = profession;
profession.position = ProfessionField.Text;
}
else if (checkExistProfession != null)
{
currentProfession = checkExistProfession;
checkExistProfession.equipment.Add(equipment);
}
else
{
currentProfession = new profession
{
idProfession = context.profession.Count() > 0 ? context.profession.Max(idProfession => idProfession.idProfession) + 1 : 1,
position = ProfessionField.Text
};
currentProfession.equipment.Add(equipment);
context.profession.Add(currentProfession);
}
_updatedListInfo?.Invoke($"{equipment.idEquipment}-ТИП: {TypeEqupmentField.SelectedItem} НАЗВАНИЕ: {NameEquipmentField.Text} ОПИСАНИЕ: {DescriptionEqupmentField.Text} ПРОФЕССИИ: {ProfessionField.Text}");
context.SaveChanges();
}
private void CompletedButtonClick(object sender, EventArgs e)
{
var context = new PSOConnect();
var idPeople = int.Parse(IdPeopleText.Text);
var missingPeople = context.missingPeople.FirstOrDefault(missinpPeoples => missinpPeoples.idPeople == idPeople);
var people = context.people.FirstOrDefault(peoples => peoples.idPeople == idPeople);
missingPeople.team.Clear();
context.missingPeople.Remove(missingPeople);
context.people.Remove(people);
context.SaveChanges();
MessageBox.Show("Поздравляем с выполненым заданием!");
ResetField();
InitFields();
}
private bool CheckExist()
{
var context = new PSOConnect();
var checkExist = false;
var disasters = from reason in context.reason
join disaster in context.disaster on reason.idDisaster equals disaster.idDisaster
select new
{
Id = reason.idReason,
Type = reason.typeReason,
Reason = reason.reason1,
County = disaster.country,
City = disaster.city,
Date = disaster.date,
};
foreach (var disaster in disasters)
{
if (disaster.Type.Equals(TypeField.SelectedItem.ToString()) && disaster.Reason.Equals(ReasonField.Text) && disaster.County.Equals(CountryField.Text) && disaster.City.Equals(CityField.Text) && EntityFunctions.TruncateTime(disaster.Date.Value) == EntityFunctions.TruncateTime(DateField.Value))
{
checkExist = true;
break;
}
}
if (checkExist)
{
var reason = context.reason.FirstOrDefault(reasons => reasons.idReason == _idReason);
var disaster = context.disaster.FirstOrDefault(dis => dis.idDisaster == reason.idDisaster);
context.reason.Remove(reason);
if (disaster.reason.Count < 1)
{
context.disaster.Remove(disaster);
}
context.SaveChanges();
_deletedListInfo?.Invoke();
return(true);
}
return(false);
}
private bool CheckExist()
{
var context = new PSOConnect();
var checkExist = false;
var equipments = from equipment in context.equipment
join profession in context.profession on equipment.idProfession equals profession.idProfession
select new
{
Id = equipment.idEquipment,
Type = equipment.type,
EquipmentName = equipment.equipmentName,
Description = equipment.description,
Profession = profession.position
};
foreach (var equipment in equipments)
{
if (equipment.Type.Equals(TypeEqupmentField.SelectedItem.ToString()) && equipment.EquipmentName.Equals(NameEquipmentField.Text) && equipment.Description.Equals(DescriptionEqupmentField.Text) && equipment.Profession.Equals(ProfessionField.Text))
{
checkExist = true;
break;
}
}
if (checkExist)
{
var equipment = context.equipment.FirstOrDefault(equip => equip.idEquipment == _idEquipment);
var profession = context.profession.FirstOrDefault(professions => professions.idProfession == equipment.idProfession);
context.equipment.Remove(equipment);
if (profession.equipment.Count < 1)
{
context.profession.Remove(profession);
}
context.SaveChanges();
_deletedListInfo?.Invoke();
return(true);
}
return(false);
}
private void AddDisaster()
{
var context = new PSOConnect();
var disaster = context.disaster.FirstOrDefault(disasters => disasters.country.Equals(CountryField.Text) && disasters.city.Equals(CityField.Text) && EntityFunctions.TruncateTime(disasters.date.Value) == EntityFunctions.TruncateTime(DateField.Value));
disaster currentDisaster = null;
if (disaster == null)
{
currentDisaster = new disaster
{
idDisaster = context.disaster.Count() > 0 ? context.disaster.Max(disasters => disasters.idDisaster) + 1 : 1,
country = CountryField.Text,
city = CityField.Text,
date = DateField.Value
};
context.disaster.Add(currentDisaster);
}
else
{
currentDisaster = disaster;
}
var reason = context.reason.FirstOrDefault(reasons => reasons.typeReason.Equals(TypeField.SelectedItem.ToString()) && reasons.reason1.Equals(ReasonField.Text) && reasons.idDisaster == currentDisaster.idDisaster);
reason currentReason = null;
if (reason == null)
{
currentReason = new reason
{
idReason = context.reason.Count() > 0 ? context.reason.Max(reasons => reasons.idReason) + 1 : 1,
typeReason = TypeField.Text,
reason1 = ReasonField.Text,
};
currentDisaster.reason.Add(currentReason);
context.reason.Add(currentReason);
}
context.SaveChanges();
}
private void DeleteMissingPeopleButtonClick(object sender, EventArgs e)
{
if (ListInfo.Items.Count == 0)
{
MessageBox.Show("Список пропавших людей пуст!");
return;
}
if (ListInfo.SelectedItems.Count == 0)
{
MessageBox.Show("Не выбрано ни одного элемента! Пожалуйста, выберите пропавшего человека");
return;
}
var context = new PSOConnect();
var count = ListInfo.SelectedItems.Count;
for (var i = 0; i < count; i++)
{
var idPeople = int.Parse(ListInfo.SelectedItems[i].ToString().Split('-')[0].Split('{')[1]);
var people = context.people.FirstOrDefault(peoples => peoples.idPeople == idPeople);
var missingPeople = context.missingPeople.FirstOrDefault(missingPeoples => missingPeoples.idPeople == idPeople);
foreach (var team in context.team)
{
if (team.idPeople == missingPeople.idPeople)
{
team.idPeople = null;
}
}
ListInfo.Items.Remove(ListInfo.SelectedItems[i]);
context.people.Remove(people);
context.missingPeople.Remove(missingPeople);
context.SaveChanges();
}
var message = count > 1 ? "Пропавшие люди успешно удалены" : "Пропавший человек успешно удалён";
MessageBox.Show(message);
}
private void SelectButtonClick(object sender, EventArgs e)
{
if (NoFoundMissingPeopleText.Visible)
{
MessageBox.Show("Выбор невозможен, нет пропавших людей, с чем вас и поздравляем :)");
return;
}
var context = new PSOConnect();
var team = context.team.FirstOrDefault(teams => teams.idTeam == Login.CurrentUser.idTeam);
var idPeople = int.Parse(SelectMissingPeopleField.SelectedItem.ToString().Split('-')[0]);
team.idPeople = idPeople;
context.SaveChanges();
MessageBox.Show("Не подведите, родственники хотят, чтобы вы его нашли!");
ResetField();
InitFields();
}
private void SelectButtonClick(object sender, EventArgs e)
{
if (NoFoundDisasterText.Visible)
{
MessageBox.Show("Выбор невозможен, нет катастроф, с чем вас и поздравляем :)");
return;
}
var context = new PSOConnect();
var team = context.team.FirstOrDefault(teams => teams.idTeam == Login.CurrentUser.idTeam);
var idDisaster = int.Parse(SelectDisasterField.SelectedItem.ToString().Split('-')[0]);
team.idDisaster = idDisaster;
context.SaveChanges();
MessageBox.Show("Не подведите, катастрофа слишком серьёзна, сделайте всё, что в ваших силах!");
ResetField();
InitFields();
}
private void DeleteEquipmentButtonClick(object sender, EventArgs e)
{
if (ListInfo.Items.Count == 0)
{
MessageBox.Show("Список оборудования пуст!");
return;
}
if (ListInfo.SelectedItems.Count == 0)
{
MessageBox.Show("Не выбрано ни одного элемента! Пожалуйста, выберите оборудование");
return;
}
var context = new PSOConnect();
var count = ListInfo.SelectedItems.Count;
for (var i = 0; i < count; i++)
{
var idEquipment = int.Parse(ListInfo.SelectedItems[0].ToString().Split('-')[0].Split('{')[1]);
var equipment = context.equipment.FirstOrDefault(equipments => equipments.idEquipment == idEquipment);
var profession = context.profession.FirstOrDefault(professions => professions.idProfession == equipment.idProfession);
context.equipment.Remove(equipment);
if (profession.equipment.Count < 1)
{
context.profession.Remove(profession);
}
ListInfo.Items.Remove(ListInfo.SelectedItems[0]);
context.SaveChanges();
}
var message = count > 1 ? "Оборудования успешно удалены" : "Оборудование успешно удалёно";
MessageBox.Show(message);
}
private void CompletedButtonClick(object sender, EventArgs e)
{
var context = new PSOConnect();
var disaster = context.disaster.FirstOrDefault(disasters => disasters.idDisaster == _disaster.idDisaster);
var reasons = context.reason.Where(reason => reason.idDisaster == disaster.idDisaster);
foreach (var reason in reasons)
{
context.reason.Remove(reason);
}
disaster.team.Clear();
disaster.reason.Clear();
context.disaster.Remove(disaster);
context.SaveChanges();
MessageBox.Show("Поздравляем с выполненым заданием!");
ResetField();
InitFields();
}
private void AddProfession()
{
var context = new PSOConnect();
var profession = context.profession.FirstOrDefault(professions => professions.position.Equals(ProfessionField.Text));
if (profession == null)
{
var currentProfession = new profession
{
idProfession = context.profession.Count() > 0 ? context.profession.Max(professions => professions.idProfession) + 1 : 1,
position = ProfessionField.Text
};
foreach (var equipment in _equipment)
{
currentProfession.equipment.Add(equipment);
context.equipment.Add(equipment);
}
context.profession.Add(currentProfession);
}
else
{
foreach (var equipment in _equipment)
{
if (profession.equipment.Contains(equipment))
{
continue;
}
profession.equipment.Add(equipment);
}
}
context.SaveChanges();
}
private void SaveDepartmentButtonClick(object sender, EventArgs e)
{
if (NoFoundRegionText.Visible)
{
MessageBox.Show("Сохранение невозможно, нет региона");
return;
}
if (!SelectRegionField.Visible)
{
MessageBox.Show("Невозможно сохранить, перед сохранением нажмите на редактирование!");
return;
}
var context = new PSOConnect();
var coordinator = context.coordinator.FirstOrDefault(coord => coord.idTeam == Login.CurrentUser.idTeam);
var idRegion = int.Parse(SelectRegionField.SelectedItem.ToString().Split('-')[0]);
var region = context.region.FirstOrDefault(regions => regions.idRegion == idRegion);
region.coordinator.Add(coordinator);
context.SaveChanges();
ResetField();
InitFields();
}
private void SaveButtonClick(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TeamNameResultText.Text) && string.IsNullOrEmpty(TeamNameField.Text))
{
MessageBox.Show("Введите название команды!");
return;
}
var context = new PSOConnect();
var lol = DoctorField.SelectedItem.ToString().Split('-');
var lol2 = int.Parse(string.IsNullOrEmpty(DoctorResultText.Text)? DoctorField.SelectedItem.ToString().Split('-')[0] : DoctorResultText.Text.Split('-')[0]);
var searchTeam = context.teamPosition.FirstOrDefault(team => team.idTeam == Login.CurrentUser.idTeam);
var idSeniorLifeguard = SeniorLifeguardField.Items.Count == 0 && string.IsNullOrEmpty(SeniorLifeguardResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(SeniorLifeguardResultText.Text) ? SeniorLifeguardField.SelectedItem.ToString().Split('-')[0] : SeniorLifeguardResultText.Text.Split('-')[0]);
var idDoctor = DoctorField.Items.Count == 0 && string.IsNullOrEmpty(DoctorResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(DoctorResultText.Text) ? DoctorField.SelectedItem.ToString().Split('-')[0] : DoctorResultText.Text.Split('-')[0]);
var idParamedic = ParamedicField.Items.Count == 0 && string.IsNullOrEmpty(ParamedicResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(ParamedicResultText.Text) ? ParamedicField.SelectedItem.ToString().Split('-')[0] : ParamedicResultText.Text.Split('-')[0]);
var idDriver = DriverField.Items.Count == 0 && string.IsNullOrEmpty(DriverResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(DriverResultText.Text) ? DriverField.SelectedItem.ToString().Split('-')[0] : DriverResultText.Text.Split('-')[0]);
var idPyrotechnic = PyrotechnicField.Items.Count == 0 && string.IsNullOrEmpty(PyrotechnicResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(PyrotechnicResultText.Text) ? PyrotechnicField.SelectedItem.ToString().Split('-')[0] : PyrotechnicResultText.Text.Split('-')[0]);
var idGasWelder = GasWelderField.Items.Count == 0 && string.IsNullOrEmpty(GasWelderResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(GasWelderResultText.Text) ? GasWelderField.SelectedItem.ToString().Split('-')[0] : GasWelderResultText.Text.Split('-')[0]);
var idCraneOperator = CraneOperatorField.Items.Count == 0 && string.IsNullOrEmpty(CraneOperatorResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(CraneOperatorResultText.Text) ? CraneOperatorField.SelectedItem.ToString().Split('-')[0] : CraneOperatorResultText.Text.Split('-')[0]);
var idDiver = DiverField.Items.Count == 0 && string.IsNullOrEmpty(DiverResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(DiverResultText.Text) ? DiverField.SelectedItem.ToString().Split('-')[0] : DiverResultText.Text.Split('-')[0]);
var idHydraulic = HydraulicField.Items.Count == 0 && string.IsNullOrEmpty(HydraulicResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(HydraulicResultText.Text) ? HydraulicField.SelectedItem.ToString().Split('-')[0] : SeniorLifeguardResultText.Text.Split('-')[0]);
var idScout = ScoutField.Items.Count == 0 && string.IsNullOrEmpty(ScoutResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(ScoutResultText.Text) ? ScoutField.SelectedItem.ToString().Split('-')[0] : ScoutResultText.Text.Split('-')[0]);
var idElectrician = ElectricianField.Items.Count == 0 && string.IsNullOrEmpty(ElectricianResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(ElectricianResultText.Text) ? ElectricianField.SelectedItem.ToString().Split('-')[0] : ElectricianResultText.Text.Split('-')[0]);
var idRescuer = RescuerField.Items.Count == 0 && string.IsNullOrEmpty(RescuerResultText.Text) ? null : (int?)int.Parse(string.IsNullOrEmpty(RescuerResultText.Text) ? RescuerField.SelectedItem.ToString().Split('-')[0] : RescuerResultText.Text.Split('-')[0]);
var teamName = string.IsNullOrEmpty(TeamNameResultText.Text) ? TeamNameField.Text : TeamNameResultText.Text;
if (searchTeam == null)
{
var teamPosition = new teamPosition
{
idTeam = context.teamPosition.Count() > 0 ? context.teamPosition.Max(team => team.idTeam) + 1 : 1,
seniorLifeguard = idSeniorLifeguard,
doctor = idDoctor,
paramedic = idParamedic,
driver = idDriver,
pyrotechnist = idPyrotechnic,
gasWelder = idGasWelder,
craneOperator = idCraneOperator,
scubaDriver = idDiver,
hydraulicEquipmentTechnician = idHydraulic,
scout = idScout,
electrician = idElectrician,
rescuer = idRescuer
};
var currentTeam = new team
{
idTeam = context.team.Count() > 0 ? context.team.Max(team => team.idTeam) + 1 : 1,
teamName = teamName
};
var coordinator = new coordinator
{
idTeam = context.coordinator.Count() > 0 ? context.coordinator.Max(team => team.idTeam) + 1 : 1,
};
var currentCoordinator = context.user.FirstOrDefault(user => user.login.Equals(Login.CurrentUser.login));
currentCoordinator.idTeam = currentTeam.idTeam;
Login.CurrentUser = currentCoordinator;
context.coordinator.Add(coordinator);
context.team.Add(currentTeam);
context.teamPosition.Add(teamPosition);
}
else
{
searchTeam.seniorLifeguard = idSeniorLifeguard;
searchTeam.doctor = idDoctor;
searchTeam.paramedic = idParamedic;
searchTeam.driver = idDriver;
searchTeam.pyrotechnist = idPyrotechnic;
searchTeam.gasWelder = idGasWelder;
searchTeam.craneOperator = idCraneOperator;
searchTeam.scubaDriver = idDiver;
searchTeam.hydraulicEquipmentTechnician = idHydraulic;
searchTeam.scout = idScout;
searchTeam.electrician = idElectrician;
searchTeam.rescuer = idRescuer;
var currentTeam = context.team.FirstOrDefault(team => team.idTeam == Login.CurrentUser.idTeam);
currentTeam.teamName = teamName;
}
context.SaveChanges();
ResetField();
InitFields();
MessageBox.Show("Команда успешно зарегистрирована!");
}
private void EditDepartement()
{
if (CheckExist())
{
return;
}
var context = new PSOConnect();
var region = context.region.FirstOrDefault(regions => regions.idRegion == _idRegion);
region.address = RegionField.Text;
var department = context.department.FirstOrDefault(departments => departments.idDepartment == region.idDepartment);
var checkExistDepartment = context.department.FirstOrDefault(departments => departments.address.Equals(DepartmentField.Text));
department currentDepartment = null;
if (department.region.Count == 1)
{
currentDepartment = department;
department.address = DepartmentField.Text;
}
else if (checkExistDepartment != null)
{
currentDepartment = checkExistDepartment;
checkExistDepartment.region.Add(region);
}
else
{
currentDepartment = new department
{
idDepartment = context.department.Count() > 0 ? context.department.Max(departments => departments.idDepartment) + 1 : 1,
address = DepartmentField.Text
};
currentDepartment.region.Add(region);
context.department.Add(currentDepartment);
}
var mainDepartment = context.mainDepartment.FirstOrDefault(mainDepartments => mainDepartments.idMainDepartment == department.idMainDepartment);
var checkExistMainDepartment = context.mainDepartment.FirstOrDefault(mainDepartments => mainDepartments.address.Equals(MainDepartmentField.Text));
mainDepartment currentMainDepartment = null;
if (mainDepartment.department.Count == 1)
{
currentMainDepartment = mainDepartment;
mainDepartment.address = MainDepartmentField.Text;
}
else if (checkExistMainDepartment != null)
{
currentMainDepartment = checkExistMainDepartment;
checkExistMainDepartment.department.Add(currentDepartment);
}
else
{
currentMainDepartment = new mainDepartment
{
idMainDepartment = context.mainDepartment.Count() > 0 ? context.mainDepartment.Max(mainDepartments => mainDepartments.idMainDepartment) + 1 : 1,
address = MainDepartmentField.Text
};
currentMainDepartment.department.Add(currentDepartment);
context.mainDepartment.Add(currentMainDepartment);
}
_updatedListInfo?.Invoke($"{region.idRegion}-АДРЕС РЕГИОНА: {region.address} АДРЕС ДЕПАРТАМЕНТА: {currentDepartment.address} АДРЕС ГЛАВНОГО ДЕПАРТАМЕНТА: {currentMainDepartment.address}");
context.SaveChanges();
}