public List <General_View> Initialize_Grid()
{
List <General_View> Complete_Data = new List <General_View>();
General_View Current = new General_View();
string department, faculty, university;
var personal = Person.GetAll();
var assigments = ph_assigments.GetAll();
// var wherefrom = citizenship.GetAll();
var identityCard = ID_Cards.GetAll();
for (int i = 0; i < personal.Count; i++)
{
Complete_Data.Add(new General_View());
Complete_Data[i].FirstName = personal[i].FirstName;
Complete_Data[i].LastName = personal[i].LastName;
Complete_Data[i].SirName = personal[i].SirName;
Complete_Data[i].id = personal[i].id_person;
//Complete_Data[i].EGN = identityCard.Where(w=> w.id_person == Complete_Data[i].id).Select(s => s.EGN).ToString();
//Complete_Data[i].Start = assigments.Where(w => w.id_person == Complete_Data[i].id).Select(s => s.StartDate).ToString();
//Complete_Data[i].End = assigments.Where(w => w.id_person == Complete_Data[i].id).Select(s => s.EndDate).ToString();
FindDep(Complete_Data[i].id, assigments, out department, out faculty, out university);
Complete_Data[i].Department = department;
Complete_Data[i].Faculty = faculty;
Complete_Data[i].University = university;
}
return(Complete_Data);
}
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);
}
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);
}
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);
}
