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); }