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 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; }
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 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); }
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 { } }
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; }
//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_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 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; }