//Rückgabe des Anfangsdatums für den Job
public string getJobDate(int jobID)
{
string date = "";
using (DataConnection context = new DataConnection())
{
Stellen stellen = new Stellen {
};
stellen = context.Stellens.FirstOrDefault(s => s.StellenID == jobID);
date = stellen.Einstellungsdatum;
};
return(date);
}
//Rückgabe aller hinterlegten, offenen Stellen
public String[] getStellenDBEntry()
{
String[] jobs;
int count;
using (DataConnection context = new DataConnection())
{
Stellen stellen = new Stellen {
};
count = context.Stellens.Count();
jobs = new String[count];
var list = context.Stellens.ToList();
int i = 0;
foreach (var bl in list)
{
jobs[i] = bl.Stellenname;
i++;
}
};
return(jobs);
}
//Zusammenfassung aller hinterlegten Daten des Bewerbers
public string[] getData(int appID)
{
string[] data = new string[] { "", "Anzahl Bewerber auf diese Stelle: ", "Job: ", "Name: ", "Adress: ", "PostalCode: ", "Place: ", "PhoneNumber: ", "Email: ",
"Birthday: ", "Career: ", "EducationalBackground: ", "ProgrammingLanguage: ", "SocialEngagement: ", "Language: ", "PrivateProjects: ", "StartDate: ", "Score: " };
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
int jobID = applicant.Job ?? 0;
int count = context.BewerberdatenLuis.Where(c => c.Job == applicant.Job).Count();
data[1] = data[1] + count.ToString();
data[2] = data[2] + applicant.Job ?? "";
data[3] = data[3] + applicant.Name ?? "";
data[4] = data[4] + applicant.Adress ?? "";
data[5] = data[5] + applicant.PostalCode ?? "";
data[6] = data[6] + applicant.Place ?? "";
data[7] = data[7] + applicant.PhoneNumber ?? "";
data[8] = data[8] + applicant.Email ?? "";
data[9] = data[9] + applicant.Birthday ?? "";
data[10] = data[10] + applicant.Career ?? "";
data[11] = data[11] + applicant.EducationalBackground ?? "";
data[12] = data[12] + applicant.ProgrammingLanguage ?? "";
data[13] = data[13] + applicant.SocialEngagement ?? "";
data[14] = data[14] + applicant.Language ?? "";
data[15] = data[15] + applicant.PrivateProjects ?? "";
data[16] = data[16] + applicant.StartDate ?? "";
data[17] = data[17] + applicant.Score ?? "";
using (DataConnection ctx = new DataConnection()) {
Stellen job = new Stellen {
};
job = ctx.Stellens.FirstOrDefault(j => j.StellenID == jobID);
data[0] = "Beworbene Stelle: " + job.Stellenname ?? "";
};
};
return(data);
}