//Update für die Akzeptanz des Newsletters
public void updateNewsletter(int appID)
{
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
applicant.Newsletter = "true";
};
}
//Setzen von Active des Bewerbers um ihn bei Inaktivität anzuschreiben
public void setActive(int appID, int active)
{
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
applicant.Active = active;
context.SaveChanges();
};
}
//Setzen des Levels des Bewerbers um ihn bei Inaktivität anzuschreiben
public void setLevel(int appID, string level)
{
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
applicant.Level = level;
context.SaveChanges();
};
}
//Abrufen von Active des Bewerbers um ihn bei Inaktivität anzuschreiben
public int getActive(int appID)
{
int active = 0;
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
active = applicant.Active ?? 0;
};
return(active);
}
//Abrufen des Levels des Bewerbers um ihn bei Inaktivität anzuschreiben
public string getLevel(int appID)
{
string level = "";
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
level = applicant.Level;
};
return(level);
}
//Rückgabe der BewerberID bei einer Wiederanmeldung eines bekannten Bewerbers
public int getApplicantIDMail(string name, string email)
{
int appID;
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.Where(n => n.Name == name).FirstOrDefault(e => e.Email == email);
appID = applicant.BewerberID;
};
return(appID);
}
//Rückgabe der hinterlegten Stadt
public string getPlace(int appID)
{
string dbEntry = "";
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
dbEntry = applicant.Place ?? "";
};
return(dbEntry);
}
//Setzen der letzten zeitlichen Eingabe des Bewerbers um ihn bei Inaktivität anzuschreiben
public void setTime(int appID)
{
DateTime time = new DateTime();
time = DateTime.Now;
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
applicant.Time = time;
context.SaveChanges();
};
}
//Rückgabe einer Liste für schon beantwortete Fragen
public List <bool> getMissing(int appID)
{
List <bool> Question = new List <bool>();
bool field;
Question.Add(true);
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
var list = context.BewerberdatenLuis.Where(i => i.BewerberID == appID).Select(i => new { i.Job, i.Name, i.Adress, i.PostalCode, i.Place,
i.PhoneNumber, i.Email, i.Birthday, i.Career, i.EducationalBackground, i.ProgrammingLanguage, i.SocialEngagement,
i.Language, i.PrivateProjects, i.StartDate }).ToList();
foreach (var bl in list)
{
field = bl.Job != null;
Question.Add(field);
field = bl.Name != null;
Question.Add(field);
field = bl.Adress != null;
Question.Add(field);
field = bl.PostalCode != null;
Question.Add(field);
field = bl.Place != null;
Question.Add(field);
field = bl.PhoneNumber != null;
Question.Add(field);
field = bl.Email != null;
Question.Add(field);
field = bl.Birthday != null;
Question.Add(field);
field = bl.Career != null;
Question.Add(field);
field = bl.EducationalBackground != null;
Question.Add(field);
field = bl.ProgrammingLanguage != null;
Question.Add(field);
field = bl.SocialEngagement != null;
Question.Add(field);
field = bl.Language != null;
Question.Add(field);
field = bl.PrivateProjects != null;
Question.Add(field);
field = bl.StartDate != null;
Question.Add(field);
}
};
return(Question);
}
//Abfrage ob Bewerbung vom Recruiter schon angesehen wurde
public bool checkReview(int appID)
{
bool review = false;
using (DataConnection context = new DataConnection()) {
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
int rev = applicant.ApplicationReviewed ?? 0;
if (rev != 0)
{
review = true;
}
};
return(review);
}
//Abruf der letzten zeitlichen Eingabe des Bewerbers um ihn bei Inaktivität anzuschreiben
public DateTime getTime(int appID)
{
DateTime time = new DateTime();
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
DateTime?dateOrNull = applicant.Time;
if (dateOrNull != null)
{
time = dateOrNull.Value;
}
};
return(time);
}
//Überprüfung ob Feld beschrieben ist
public bool checkNull(string column, int appID)
{
bool isNull = true;
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
int i = applicant.BewerberID;
var result = context.BewerberdatenLuis.Where(r => r.BewerberID == appID).Select(column);
string test = result == null ? null : result.ToString();
if (!String.IsNullOrEmpty(test))
{
isNull = false;
}
};
return(isNull);
}
//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);
}
//Anlegen eines neuen Bewerbers unter Angabe aller Standardwerte und IDs
public int insertNewApp(string conversationID, string userID, string channel)
{
DateTime time = new DateTime();
DateTime deftime = new DateTime(3018, 1, 1);
time = DateTime.Today;
int appID = 0;
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
ConversationID = conversationID
};
context.BewerberdatenLuis.Add(applicant);
applicant.UserID = userID;
applicant.ChannelId = channel;
applicant.Score = 0;
applicant.Newsletter = "false";
applicant.JobInterview = "false";
applicant.ApplicationReviewed = 0;
applicant.Active = 0;
applicant.TimeStamp = time;
applicant.InterviewDate = deftime;
if (channel.Equals("emulator") || channel.Equals("webchat"))
{
applicant.Level = "4";
}
else
{
applicant.Level = "0";
}
context.SaveChanges();
appID = applicant.BewerberID;
};
return(appID);
}
//Update-Funktion für die Angaben des Bewerbers
public void updateDB(string column, int appID, string dbEntry)
{
using (DataConnection context = new DataConnection())
{
BewerberdatenLui applicant = new BewerberdatenLui {
};
applicant = context.BewerberdatenLuis.FirstOrDefault(r => r.BewerberID == appID);
switch (column)
{
case "Name":
applicant.Name = dbEntry;
break;
case "Adress":
applicant.Adress = dbEntry;
break;
case "PostalCode":
applicant.PostalCode = dbEntry;
break;
case "Place":
applicant.Place = dbEntry;
break;
case "PhoneNumber":
applicant.PhoneNumber = dbEntry;
break;
case "Email":
applicant.Email = dbEntry;
break;
case "Birthday":
applicant.Birthday = dbEntry;
break;
case "Career":
applicant.Career = dbEntry;
break;
case "EducationalBackground":
applicant.EducationalBackground = dbEntry;
break;
case "ProgrammingLanguage":
applicant.ProgrammingLanguage = dbEntry;
break;
case "SocialEngagement":
applicant.SocialEngagement = dbEntry;
break;
case "Language":
applicant.Language = dbEntry;
break;
case "PrivateProjects":
applicant.PrivateProjects = dbEntry;
break;
case "StartDate":
applicant.StartDate = dbEntry;
break;
case "Job":
applicant.Job = Convert.ToInt32(dbEntry);
break;
case "ChannelID":
applicant.ChannelId = dbEntry;
break;
case "ConversationID":
applicant.ConversationID = dbEntry;
break;
}
context.SaveChanges();
};
}
