public void GetEmployments()
{
JobBoardDataContext db = new JobBoardDataContext();
List<EmploymentHistory> emp_history = new List<EmploymentHistory>();
emp_history = db.EmploymentHistories.Where(x => x.app_id.Equals(this.id)).ToList<EmploymentHistory>();
}
private void SendNotifications()
{
try {
JobBoardDataContext db = new JobBoardDataContext();
SmtpClient SmtpServer = new SmtpClient();
Job job = db.Jobs.Where(x => x.id.Equals(this.job_id)).FirstOrDefault<Job>();
List<Contact> receivers = job.Notifications.Select(x => x.Contact).ToList<Contact>();
foreach (Contact receiver in receivers) {
MailMessage mail = new MailMessage();
mail.To.Add(receiver.email);
mail.Subject = "New Application Submitted for " + job.title;
mail.IsBodyHtml = true;
Uri url = HttpContext.Current.Request.Url;
string path = "http://" + url.Host + ((url.Port != 80) ? ":" + url.Port.ToString() : "") + "/Admin/Application/" + this.id;
string htmlBody = "<p>Hi " + receiver.name + ",</p>";
htmlBody += "<p>Someone has submitted a new application for the " + job.title + " position.<br /><br />";
htmlBody += "<a href=\"" + path + "\">View Application</a>";
mail.Body = htmlBody;
SmtpServer.Send(mail);
}
} catch { }
}
public void DeleteEmployment(Guid id)
{
JobBoardDataContext db = new JobBoardDataContext();
EmploymentHistory emp = db.EmploymentHistories.Where(x => x.id.Equals(id)).FirstOrDefault<EmploymentHistory>();
db.EmploymentHistories.DeleteOnSubmit(emp);
db.SubmitChanges();
}
public void Submit()
{
JobBoardDataContext db = new JobBoardDataContext();
Application app = new Application();
app = db.Applications.Where(x => x.id.Equals(this.id)).FirstOrDefault<Application>();
app.dateSubmitted = DateTime.Now;
db.SubmitChanges();
SendNotifications();
}
public void Get(Guid id = new Guid())
{
JobBoardDataContext db = new JobBoardDataContext();
Application app = db.Applications.Where(x => x.id.Equals(id)).FirstOrDefault<Application>();
var props = this.GetType().GetProperties();
foreach (PropertyInfo prop in props) {
if (app != null) {
prop.SetValue(this, app.GetType().GetProperty(prop.Name).GetValue(app, null), null);
}
}
}
public Category(Guid id = new Guid())
{
if (id != null) {
JobBoardDataContext db = new JobBoardDataContext();
Category cat = db.Categories.Where(x => x.id.Equals(id)).FirstOrDefault<Category>();
this.id = cat.id;
this.name = cat.name;
this.short_desc = cat.short_desc;
this.long_desc = cat.long_desc;
this.date_added = cat.date_added;
this.parent = cat.parent;
}
}
public void LoadJobs()
{
JobBoardDataContext db = new JobBoardDataContext();
List<Guid> job_ids = (from jc in db.JobCategories
join j in db.Jobs on jc.job equals j.id
where jc.cat.Equals(this.id) && j.jobState.Equals(JobState.PUBLISHED.ToString())
select jc.job).ToList<Guid>();
List<DisplayableJob> cat_jobs = new List<DisplayableJob>();
foreach (Guid j in job_ids) {
DisplayableJob job = JobModel.Get(j);
if (job != null) {
cat_jobs.Add(job);
}
}
cat_jobs.OrderBy(x => x.date_added);
this.jobs = cat_jobs;
}
public void SetMilitary(string branch, string start, string end, string rank_duties, string additional_info)
{
Application app = new Application();
JobBoardDataContext db = new JobBoardDataContext();
DateTime? startdate = null;
DateTime? enddate = null;
try {
startdate = Convert.ToDateTime(start);
} catch {}
try {
enddate = Convert.ToDateTime(end);
} catch { }
app = db.Applications.Where(x => x.id.Equals(this.id)).FirstOrDefault<Application>();
app.service_branch = branch;
app.service_start = startdate;
app.service_end = enddate;
app.rank_duties = rank_duties;
app.additional_info = additional_info;
db.SubmitChanges();
}
public void Save()
{
JobBoardDataContext db = new JobBoardDataContext();
// Attempt to find a record with this ID
HR.Reference existing = db.References.Where(x => x.id.Equals(this.id)).FirstOrDefault<HR.Reference>();
if (existing == null) {
db.References.InsertOnSubmit(this);
} else {
existing.name = this.name;
existing.job_title = this.job_title;
existing.phone = this.phone;
existing.years_known = this.years_known;
}
db.SubmitChanges();
}
public void Delete()
{
JobBoardDataContext db = new JobBoardDataContext();
HR.Reference refer = db.References.Where(x => x.id.Equals(this.id)).FirstOrDefault<HR.Reference>();
db.References.DeleteOnSubmit(refer);
db.SubmitChanges();
}
public void Save()
{
JobBoardDataContext db = new JobBoardDataContext();
// Attempt to find a record with this ID
EducationalBackground existing = db.EducationalBackgrounds.Where(x => x.id.Equals(this.id)).FirstOrDefault<EducationalBackground>();
if (existing == null) { // Insert
db.EducationalBackgrounds.InsertOnSubmit(this);
} else { // Update
existing.school_type = this.school_type;
existing.name = this.name;
existing.address = this.address;
existing.city = this.city;
existing.state_id = this.state_id;
existing.years_completed = this.years_completed;
existing.gpa = this.gpa;
existing.degree = this.degree;
existing.app_id = this.app_id;
existing.description = this.ParseNameLocation();
}
db.SubmitChanges();
}
public string ParseNameLocation(int max_length = 500)
{
JobBoardDataContext db = new JobBoardDataContext();
string state_abbr = db.States.Where(x => x.id.Equals(this.state_id)).Select(x => x.abbr).FirstOrDefault<string>();
string full_desc = String.Format("{0}: {1} {2}, {3}", this.name, this.address, this.city, state_abbr);
if (full_desc.Length > max_length) {
return full_desc.Substring(0, 500) + "...";
} else {
return full_desc;
}
}
public void Delete()
{
JobBoardDataContext db = new JobBoardDataContext();
EducationalBackground edu = db.EducationalBackgrounds.Where(x => x.id.Equals(this.id)).FirstOrDefault<EducationalBackground>();
db.EducationalBackgrounds.DeleteOnSubmit(edu);
db.SubmitChanges();
}
public void LoadSubs()
{
JobBoardDataContext db = new JobBoardDataContext();
List<Category> cats = db.Categories.Where(x => x.parent.Equals(this.id)).ToList<Category>();
this.subs = cats;
}
public void LoadParent()
{
JobBoardDataContext db = new JobBoardDataContext();
Category parent = db.Categories.Where(x => x.id.Equals(this.parent)).FirstOrDefault<Category>();
this.parentCategory = parent;
}
