private ph_assignments Gen_Assigments(GenericPersonViewModel gen, int id)
{
var query = Ph_Assigments.GetAll();
var result = query.FirstOrDefault(f => f.id_person == id);
if (result != null)
{
result.id_department = gen.PHDAssignmentViewModel.id_department;
result.id_phdAssignment = gen.PHDAssignmentViewModel.id_phdAssignment;
result.id_educationDuration = gen.PHDAssignmentViewModel.id_educationDuration;
result.id_person = gen.PHDAssignmentViewModel.id_person;
result.id_educationForm = gen.PHDAssignmentViewModel.id_educationForm;
result.id_module = gen.PHDAssignmentViewModel.id_module;
result.id_speciality = gen.PHDAssignmentViewModel.id_speciality;
result.StartDate = gen.PHDAssignmentViewModel.StartDate;
result.EndDate = gen.PHDAssignmentViewModel.EndDate;
result.id_acceptanceReason = gen.PHDAssignmentViewModel.id_acceptanceReason;
result.UseDormitory = gen.PHDAssignmentViewModel.UseDormitory;
//result.PHDCode = gen.PHDAssignmentViewModel.PhdCode;
result.StartOrderNumber = gen.PHDAssignmentViewModel.StartOrderNumber;
result.StartOrderDate = gen.PHDAssignmentViewModel.StartOrderDate;
result.EndOrderDate = gen.PHDAssignmentViewModel.EndOrderDate;
result.UseScholarship = gen.PHDAssignmentViewModel.UseScholarship;
result.id_status = gen.PHDAssignmentViewModel.id_status;
result.id_studyType = gen.PHDAssignmentViewModel.id_studyType;
result.UseHolidayFacilities = gen.PHDAssignmentViewModel.UseHolidayFacilities;
}
return(result);
}
public GenericPersonViewModel InitGPVM(int id_person)
{
GenericPersonViewModel vm = new GenericPersonViewModel();
this.InitPersonViewModel(id_person, vm);
this.InitContractsViewModel(id_person, vm);
return(vm);
}
//private ph_topics Gen_Topic(GenericPersonViewModel gen)
//{
// ph_topics result = new ph_topics();
// result.Name =
//}
//private ph_tutors Gen_Tutor(GenericPersonViewModel gen)
//{
//}
private un_contactdata Gen_ContactData(GenericPersonViewModel gen, int id)
{
var query = Contacts.GetAll();
var result = query.FirstOrDefault(f => f.id_person == id);
if (result != null && gen.ContactDataViewModel != null)
{
result.Phone = gen.ContactDataViewModel.Phone;
result.email = gen.ContactDataViewModel.email;
result.id_person = gen.ContactDataViewModel.id_person;
}
return(result);
}
private un_citizenship Gen_Citizenship(GenericPersonViewModel gen, int id)
{
var query = Citizenship.GetAll();
var result = query.FirstOrDefault(f => f.id_person == id);
if (result != null)
{
result.id_person = gen.CitizenshipViewModel.id_person;
result.id_country = gen.CitizenshipViewModel.id_country;
result.id_citizenship = gen.CitizenshipViewModel.id_citizenship;
}
return(result);
}
private void InitPersonViewModel(int id_person, GenericPersonViewModel vm)
{
vm.PersonViewModel = this._databaseContext.UN_Persons.Where(a => a.id_person == id_person)
.Select(a => new PersonViewModel
{
Address = a.Address,
EGN = a.EGN,
GSM = a.GSM,
id_person = a.id_person,
id_gender = a.id_gender,
Name = a.Name
}).Single();
}
private un_personlanguages Gen_Languages(GenericPersonViewModel gen, int id)
{
var query = Person_Language.GetAll();
var result = query.FirstOrDefault(f => f.id_person == id);
if (result != null && gen.PersonLanguagesViewModel != null)
{
result.id_language = gen.PersonLanguagesViewModel.id_language;
result.id_person = gen.PersonLanguagesViewModel.id_person;
result.id_languageLevel = gen.PersonLanguagesViewModel.id_languageLevel;
result.id_personLanguage = gen.PersonLanguagesViewModel.id_personLanguage;
}
return(result);
}
public GenericPersonViewModel All(int id)
{
GenericPersonViewModel generic = new GenericPersonViewModel();
generic.CitizenshipViewModel = CitizenshipView(id);
generic.PHDAssignmentViewModel = Assigment_View(id);
generic.PHDDiplomDataViewModel = Diplom_Data(id);
generic.PersonIDCardViewModel = Id_Card(id);
generic.PersonLanguagesViewModel = LanguagesView(id);
generic.PersonsViewModel = person_View(id);
generic.PhdPersonViewModel = Phd_Person_View(generic.PHDAssignmentViewModel);
return(generic);
}
public TableUpdateViewModel GenUpdate(GenericPersonViewModel generic, int id)
{
TableUpdateViewModel data = new TableUpdateViewModel();
data.Persons = Gen_Person(generic, id);
data.PHAssigments = Gen_Assigments(generic, id);
data.DiplomData = Gen_DiplomData(generic, id);
data.Citizenship = Gen_Citizenship(generic, id);
data.Identitycards = Gen_Identitycards(generic, id);
data.ContactData = Gen_ContactData(generic, id);
data.Languages = Gen_Languages(generic, id);
//data.Topics = Gen_Topic(generic);
// data.Tutors = Gen_Tutor(generic);
return(data);
}
private ph_diplomdata Gen_DiplomData(GenericPersonViewModel gen, int id)
{
var assigm_all = Ph_Assigments.GetAll();
var assigm = assigm_all.FirstOrDefault(s => s.id_person == id);
var query = Diploma.GetAll();
var result = query.FirstOrDefault(f => assigm != null && f.id_pdhAssignment == assigm.id_phdAssignment);
if (result != null)
{
result.id_diplomData = gen.PHDDiplomDataViewModel.id_phdDiplomData;
result.id_pdhAssignment = gen.PHDDiplomDataViewModel.id_phdAssignment;
//result.id_person = id_person;
result.id_countryLastEducation = gen.PHDDiplomDataViewModel.id_countryLastEducation;
result.id_citiesLastEducation = gen.PHDDiplomDataViewModel.id_citiesLastEducation;
result.id_educationLast = gen.PHDDiplomDataViewModel.id_educationLast;
}
return(result);
}
private un_persons Gen_Person(GenericPersonViewModel gen, int id)
{
var query = Person.GetAll();
var per = query.FirstOrDefault(f => f.id_person == id);
if (per != null)
{
per.id_person = gen.PersonsViewModel.id_person;
per.FirstName = gen.PersonsViewModel.FirstName;
per.SirName = gen.PersonsViewModel.SirName;
per.LastName = gen.PersonsViewModel.LastName;
per.id_gender = gen.PersonsViewModel.id_gender;
per.id_module = gen.PersonsViewModel.id_module;
per.FirstName = gen.PersonsViewModel.FirstName;
per.FirstName = gen.PersonsViewModel.FirstName;
}
return(per);
}
public PersonFolder(int id_person)
{
InitializeComponent();
if (id_person != 0)
{
using (var logic = new PersonalLogic())
{
this.gPVM = logic.InitGPVM(id_person);
}
}
else
{
this.gPVM = new GenericPersonViewModel();
this.gPVM.PersonViewModel = new PersonViewModel();
}
this.DataContext = this.gPVM;
}
private un_identitycards Gen_Identitycards(GenericPersonViewModel gen, int id)
{
var query = ID_Cards.GetAll();
var result = query.FirstOrDefault(f => f.id_person == id);
if (result != null)
{
result.Address = gen.PersonIDCardViewModel.Address;
result.EGN = gen.PersonIDCardViewModel.EGN;
result.BirthDate = gen.PersonIDCardViewModel.BirthDate;
result.ExpiryDate = gen.PersonIDCardViewModel.ExpiryDate;
result.IssueDate = gen.PersonIDCardViewModel.IssueDate;
result.id_cityBirth = gen.PersonIDCardViewModel.id_cityBirth;
result.id_egnType = gen.PersonIDCardViewModel.id_egnType;
result.id_identityCard = gen.PersonIDCardViewModel.id_identityCard;
result.id_city = gen.PersonIDCardViewModel.id_city;
result.id_person = gen.PersonIDCardViewModel.id_person;
result.id_module = gen.PersonIDCardViewModel.id_module;
}
return(result);
}
private void Add_New_Person_OnLoaded(object sender, RoutedEventArgs e)
{
Fill_Generic_Data fill = new Fill_Generic_Data();
ComboBoxLogic comboboxLogic = new ComboBoxLogic();
List <ph_tutors> tutor = new List <ph_tutors>();
TXTLogic txtLogic = new TXTLogic();
if (EditData == null)
{
_generic = new GenericPersonViewModel();
cmbUniversity.ItemsSource = comboboxLogic.Unis();
}
else
{
_generic = fill.All(EditData.id);
tutor = txtLogic.Tutor(EditData.id);
// topic = txtLogic.Topic(editData.id);
}
cmbSpecialty.ItemsSource = comboboxLogic.SpecialtyList();
cmbUniversity.ItemsSource = comboboxLogic.Unis();
cmbCurrentMunicipality.ItemsSource = comboboxLogic.Regions();
cmbMunicipality.ItemsSource = comboboxLogic.Regions();
cmbGender.ItemsSource = comboboxLogic.Gender();
cmbCountry.ItemsSource = comboboxLogic.ReadCountry();
cmbEgnType.ItemsSource = comboboxLogic.Id_Types();
cmbAccReason.ItemsSource = comboboxLogic.AccReason();
cmbFormEdu.ItemsSource = comboboxLogic.FormEdu();
cmbTypeEdu.ItemsSource = comboboxLogic.Type();
cmbStatus.ItemsSource = comboboxLogic.Status();
cmbLastLevel.ItemsSource = comboboxLogic.Levels();
cmbLastEdu.ItemsSource = comboboxLogic.ReadCountry();
cmbUniversity.DataContext = EditData;
dtgrdTutor.DataContext = tutor;
// txtTopic.DataContext = topic;
this.DataContext = _generic;
//identitycards.un_persons = personView;
}
public void Update_Entry(GenericPersonViewModel _generic, int id)
{
BaseLogic baselogic = new BaseLogic();
var data = GenUpdate(_generic, id);
if (_generic.IsModified)
{
baselogic.Person.Update(data.Persons);
baselogic.Ph_Assigments.Update(data.PHAssigments);
baselogic.ID_Cards.Update(data.Identitycards);
baselogic.Diploma.Update(data.DiplomData);
baselogic.Person_Language.Update(data.Languages);
baselogic.Citizenship.Update(data.Citizenship);
baselogic.Contacts.Update(data.ContactData);
}
try
{
baselogic.Save();
}
catch
{
}
}
public void Insert_Entry(GenericPersonViewModel generic)
{
un_persons person = new un_persons();
ph_assignments assigment = new ph_assignments();
ph_diplomdata diplomData = new ph_diplomdata();
un_citizenship citizenship = new un_citizenship();
un_identitycards idCards = new un_identitycards();
un_contactdata contactData = new un_contactdata();
un_personlanguages perLanguages = new un_personlanguages();
person.FirstName = generic.PersonsViewModel.FirstName;
person.SirName = generic.PersonsViewModel.SirName;
person.LastName = generic.PersonsViewModel.LastName;
person.id_gender = generic.PersonsViewModel.id_gender;
assigment.id_department = generic.PHDAssignmentViewModel.id_department;
assigment.id_phdAssignment = generic.PHDAssignmentViewModel.id_phdAssignment;
assigment.id_educationDuration = generic.PHDAssignmentViewModel.id_educationDuration;
assigment.id_person = generic.PHDAssignmentViewModel.id_person;
assigment.id_educationForm = generic.PHDAssignmentViewModel.id_educationForm;
assigment.id_module = generic.PHDAssignmentViewModel.id_module;
assigment.id_speciality = generic.PHDAssignmentViewModel.id_speciality;
assigment.StartDate = generic.PHDAssignmentViewModel.StartDate;
assigment.EndDate = generic.PHDAssignmentViewModel.EndDate;
assigment.id_acceptanceReason = generic.PHDAssignmentViewModel.id_acceptanceReason;
assigment.UseDormitory = generic.PHDAssignmentViewModel.UseDormitory;
assigment.StartOrderNumber = generic.PHDAssignmentViewModel.StartOrderNumber;
assigment.StartOrderDate = generic.PHDAssignmentViewModel.StartOrderDate;
assigment.EndOrderDate = generic.PHDAssignmentViewModel.EndOrderDate;
assigment.UseScholarship = generic.PHDAssignmentViewModel.UseScholarship;
assigment.id_status = generic.PHDAssignmentViewModel.id_status;
assigment.id_studyType = generic.PHDAssignmentViewModel.id_studyType;
assigment.UseHolidayFacilities = generic.PHDAssignmentViewModel.UseHolidayFacilities;
diplomData.id_diplomData = generic.PHDDiplomDataViewModel.id_phdDiplomData;
diplomData.id_pdhAssignment = generic.PHDDiplomDataViewModel.id_phdAssignment;
//diplomData.id_person = id_person;
diplomData.id_countryLastEducation = generic.PHDDiplomDataViewModel.id_countryLastEducation;
diplomData.id_citiesLastEducation = generic.PHDDiplomDataViewModel.id_citiesLastEducation;
diplomData.id_educationLast = generic.PHDDiplomDataViewModel.id_educationLast;
citizenship.id_person = generic.CitizenshipViewModel.id_person;
citizenship.id_country = generic.CitizenshipViewModel.id_country;
citizenship.id_citizenship = generic.CitizenshipViewModel.id_citizenship;
idCards.Address = generic.PersonIDCardViewModel.Address;
idCards.EGN = generic.PersonIDCardViewModel.EGN;
idCards.BirthDate = generic.PersonIDCardViewModel.BirthDate;
idCards.ExpiryDate = generic.PersonIDCardViewModel.ExpiryDate;
idCards.IssueDate = generic.PersonIDCardViewModel.IssueDate;
idCards.id_cityBirth = generic.PersonIDCardViewModel.id_cityBirth;
idCards.id_egnType = generic.PersonIDCardViewModel.id_egnType;
idCards.id_identityCard = generic.PersonIDCardViewModel.id_identityCard;
idCards.id_city = generic.PersonIDCardViewModel.id_city;
idCards.id_person = generic.PersonIDCardViewModel.id_person;
idCards.id_module = generic.PersonIDCardViewModel.id_module;
contactData.Phone = generic.ContactDataViewModel.Phone;
contactData.email = generic.ContactDataViewModel.email;
contactData.id_person = generic.ContactDataViewModel.id_person;
perLanguages.id_language = generic.PersonLanguagesViewModel.id_language;
perLanguages.id_person = generic.PersonLanguagesViewModel.id_person;
perLanguages.id_languageLevel = generic.PersonLanguagesViewModel.id_languageLevel;
perLanguages.id_personLanguage = generic.PersonLanguagesViewModel.id_personLanguage;
// assigment.un_persons = person;
citizenship.un_persons = person;
perLanguages.un_persons = person;
diplomData.ph_assignments = assigment;
contactData.un_persons = person;
idCards.un_persons = person;
Person.Insert(person);
Ph_Assigments.Insert(assigment);
Citizenship.Insert(citizenship);
Person_Language.Insert(perLanguages);
Diploma.Insert(diplomData);
ID_Cards.Insert(idCards);
Contacts.Insert(contactData);
}
private void InitContractsViewModel(int id_person, GenericPersonViewModel vm)
{
var lstContracts = this._databaseContext.HR_Contracts.Where(c => c.id_person == id_person);
vm.lstContracts = new ObservableCollection <ContractsViewModel>();
foreach (var contract in lstContracts)
{
var lstAssignments = this._databaseContext.HR_Assignments.Where(a => a.id_contract == contract.id_contract).ToList();
var baseAssignment = lstAssignments.Single(a => a.IsAdditionalAssignment == false);
ContractsViewModel cvm = new ContractsViewModel();
cvm.ActiveFrom = baseAssignment.AssignmentDate;
cvm.ContractDate = baseAssignment.ContractDate;
cvm.ContractNumber = baseAssignment.ContractNumber;
cvm.Level1 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 2) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 1) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level2 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 2) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level3 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level4 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.StructurePosition = baseAssignment.HR_StructurePositions.HR_GlobalPositions.Name;
var lstAdditionalAssignments = lstAssignments.Where(a => a.IsAdditionalAssignment == true).ToList();
foreach (var ass in lstAdditionalAssignments)
{
ContractsViewModel cam = new ContractsViewModel();
cam.ActiveFrom = ass.AssignmentDate;
cam.ContractDate = ass.ContractDate;
cam.ContractNumber = ass.ContractNumber;
cam.Level1 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 2) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 1) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level2 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 2) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level3 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level4 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.StructurePosition = ass.HR_StructurePositions.HR_GlobalPositions.Name;
cvm.lstAdditionalAssignments.Add(cam);
}
vm.lstContracts.Add(cvm);
}
}
