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