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