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