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 ph_assignments GetAssignment(int id) { var assigm = Ph_Assigments.GetAll(); ph_assignments result = assigm.FirstOrDefault(f => f.id_person == id); return(result); }
public PHDAssignmentViewModel Assigment_View(int id_person) { PHDAssignmentViewModel result = new PHDAssignmentViewModel(); var assigments = Ph_Assigments.GetAll(); var assigm = assigments.FirstOrDefault(g => g.id_person == id_person); if (assigm != null) { result.id_department = assigm.id_department; result.id_phdAssignment = assigm.id_phdAssignment; result.id_educationDuration = assigm.id_educationDuration; result.id_person = assigm.id_person; result.id_educationForm = assigm.id_educationForm; result.id_module = assigm.id_module; result.id_speciality = assigm.id_speciality; result.StartDate = assigm.StartDate; result.EndDate = assigm.EndDate; result.id_acceptanceReason = assigm.id_acceptanceReason; result.UseDormitory = assigm.UseDormitory; result.PHDCode = assigm.PhdCode; result.StartOrderNumber = assigm.StartOrderNumber; result.StartOrderDate = assigm.StartOrderDate; result.EndOrderDate = assigm.EndOrderDate; result.UseScholarship = assigm.UseScholarship; result.id_status = assigm.id_status; result.id_studyType = assigm.id_studyType; result.UseHolidayFacilities = assigm.UseHolidayFacilities; } return(result); }
public ph_topics Topic(int id) { ph_topics result = new ph_topics(); if (id != 0) { var topic = Topics.GetAll(); var ph = Ph_Assigments.GetAll(); var query = ph.FirstOrDefault(f => f.id_person == id); result = topic.FirstOrDefault(f => f.id_phdAssignment == query.id_phdAssignment); } return(result); }
public List <ph_tutors> Tutor(int id) { List <ph_tutors> result = new List <ph_tutors>(); if (id != 0) { var tutor = Tutors.GetAll(); var ph = Ph_Assigments.GetAll(); var query = ph.FirstOrDefault(f => f.id_person == id); result = tutor.Where(f => query != null && f.id_phdAssignment == query.id_phdAssignment).ToList(); } return(result); }
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); }
public List <General_View> JoinTables() { List <General_View> Complete_Data = new List <General_View>(); var personal = Person.GetAll(); var assigments = Ph_Assigments.GetAll(); var country = Citizenship.GetAll(); var Tree = Dep_Tree.GetAll(); var identityCard = ID_Cards.GetAll(); var result = (from per in personal join ass in assigments on per.id_person equals ass.id_person into assG from ass1 in assG.DefaultIfEmpty() join id in identityCard on per.id_person equals id.id_person into idG from id1 in idG.DefaultIfEmpty() join cit in country on per.id_person equals cit.id_person into citG from cit1 in citG.DefaultIfEmpty() join dt in Tree on ass1?.id_department equals dt.id_department into dtG from dt1 in dtG.DefaultIfEmpty() select new General_View() { EGN = (id1 != null) ? id1.EGN : null, id_dep = (ass1 != null) ? ass1.id_department : 0, id_fac = (dt1 != null) ? dt1.un_departmenttree2.id_department : 0, id_uni = (dt1 != null) ? dt1.un_departmenttree2.un_departmenttree2.id_department : 0, id_educationform = (ass1 != null) ? ass1.id_educationForm : 0, Start = (ass1 != null) ? ass1.StartDate : null, End = (ass1 != null) ? ass1.EndDate : null, FirstName = per.FirstName, SirName = per.SirName, LastName = per.LastName, id = per.id_person, id_gender = per.id_gender, id_city = (cit1 != null) ? cit1.id_country : 0, }).GroupBy(p => p.id); foreach (var data in result) { Complete_Data.Add(data.FirstOrDefault()); } return(Complete_Data); }
public PHDDiplomDataViewModel Diplom_Data(int id_person) { PHDDiplomDataViewModel result = new PHDDiplomDataViewModel(); var assigment = Ph_Assigments.GetAll(); var diploma = Diploma.GetAll(); var query = assigment.FirstOrDefault(f => f.id_person == id_person); var query1 = diploma.FirstOrDefault(f => query != null && f.id_pdhAssignment == query.id_phdAssignment); if (query1 != null) { result.id_phdDiplomData = query1.id_diplomData; result.id_phdAssignment = query1.id_pdhAssignment; result.id_person = id_person; result.id_countryLastEducation = query1.id_countryLastEducation; result.id_citiesLastEducation = query1.id_citiesLastEducation; result.id_educationLast = query1.id_educationLast; } return(result); }
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); }