public JobSearchModel GetActive(string personId, string placeholder)
{
var activeSobSearchModel = new JobSearchModel();
try
{
using (var db = new GetaJobContext())
{
var dbJobSearch = db.JobSearches.Where(s => s.PersonId == personId && s.Abandoned == null).FirstOrDefault();
if (dbJobSearch == null)
{
activeSobSearchModel.SearchName = "No Active Search Found";
}
else
{
activeSobSearchModel.Id = dbJobSearch.Id;
activeSobSearchModel.SearchName = dbJobSearch.SearchName;
activeSobSearchModel.PersonId = dbJobSearch.PersonId;
activeSobSearchModel.Initiated = dbJobSearch.Initiated.ToShortDateString();
}
}
}
catch (Exception ex) { activeSobSearchModel.SearchName = Helpers.ErrorDetails(ex); }
return(activeSobSearchModel);
}
public List <JobRefModel> Get(string refType)
{
var refs = new List <JobRefModel>();
try
{
using (var db = new GetaJobContext())
{
IList <JobRef> dbrefs = db.JobRefs.Where(r => r.RefType == refType).OrderBy(r => r.RefDescription).ToList();
foreach (JobRef r in dbrefs)
{
refs.Add(new JobRefModel()
{
RefCode = r.RefCode, RefDescription = r.RefDescription
});
}
}
}
catch (Exception ex)
{
refs.Add(new JobRefModel()
{
RefCode = "ERR", RefType = "ERR", RefDescription = Helpers.ErrorDetails(ex)
});
}
return(refs);
}
public List <JobSkillModel> Get()
{
var skillModels = new List <JobSkillModel>();
try
{
using (var db = new GetaJobContext())
{
skillModels =
(from skils in db.JobSkills
join crefs in db.JobRefs on skils.SkillType equals crefs.RefCode into sr
from xrefs in sr.DefaultIfEmpty()
select new JobSkillModel
{
Id = skils.Id,
Name = skils.SkillName,
Category = skils.SkillType,
Proficiency = skils.Proficiency,
FontSize = skils.SortOrder,
CategoryDescription = xrefs.RefDescription == null ? "" : xrefs.RefDescription,
Narrative = skils.Narrative
}).ToList();
}
}
catch (Exception ex) { skillModels.Add(new JobSkillModel()
{
Name = Helpers.ErrorDetails(ex)
}); }
return(skillModels.OrderBy(s => s.Name).ToList());
}
public string Put(AgencyModel agencyModel)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
Agency agency = db.Agencies.Where(a => a.Id == agencyModel.Id).FirstOrDefault();
JobCompany jobCompany = db.JobCompanies.Where(j => j.Id == agency.CompanyId).FirstOrDefault();
jobCompany.CompanyName = agencyModel.CompanyName;
jobCompany.CompanyAddress = agencyModel.CompanyAddress;
jobCompany.Email = agencyModel.Email;
jobCompany.OfficePhone = agencyModel.Phone;
jobCompany.CompanyZip = agencyModel.CompanyZip;
jobCompany.Website = agencyModel.Website;;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public string Post(AgentModel agentModel)
{
string success = "ERROR: ";
try
{
using (GetaJobContext db = new GetaJobContext())
{
Person person = new Person()
{
Id = Guid.NewGuid().ToString(),
FName = agentModel.FName,
LName = agentModel.LName,
CellPhone = agentModel.Cell,
OfficePhone = agentModel.Phone,
Email = agentModel.Email
};
db.People.Add(person);
Agent agent = new Agent()
{
Id = Guid.NewGuid().ToString(),
PersonId = person.Id,
AgencyId = agentModel.AgencyId
};
db.Agents.Add(agent);
db.SaveChanges();
success = agent.Id;
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public string Put(AgentModel agentModel)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
Agent agent = db.Agents.Where(a => a.Id == agentModel.Id).FirstOrDefault();
//agent.AgencyId
Person person = db.People.Where(p => p.Id == agent.PersonId).FirstOrDefault();
person.FName = agentModel.FName;
person.LName = agentModel.LName;
person.CellPhone = agentModel.Cell;
person.OfficePhone = agentModel.Phone;
person.Email = agentModel.Email;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public List <JobSearchModel> GetMany(string personId)
{
var jobSearchModels = new List <JobSearchModel>();
try
{
using (var db = new GetaJobContext())
{
var dbJobSearches = db.JobSearches.Where(s => s.PersonId == personId).ToList();
foreach (JobSearch jobSearch in dbJobSearches)
{
//jobSearchModels.Add(new JobSearchModel()
JobSearchModel jobSearchModel = new JobSearchModel();
jobSearchModel.Id = jobSearch.Id;
jobSearchModel.SearchName = jobSearch.SearchName;
jobSearchModel.PersonId = jobSearch.PersonId;
jobSearchModel.Initiated = jobSearch.Initiated.ToShortDateString();
if (jobSearch.Abandoned != null)
{
jobSearchModel.Abandoned = jobSearch.Abandoned.Value.ToShortDateString();
}
jobSearchModels.Add(jobSearchModel);
}
}
}
catch (Exception ex) { jobSearchModels.Add(new JobSearchModel()
{
SearchName = Helpers.ErrorDetails(ex)
}); }
return(jobSearchModels);
}
public string Post(JobListingModel newJobListing)
{
string success = "ERROR: ";
try
{
JobListing dbJobListing = new JobListing();
dbJobListing.Id = Guid.NewGuid().ToString();
dbJobListing.JobSearchId = newJobListing.JobSearchId;
dbJobListing.PostedDate = DateTime.Parse(newJobListing.PostedDate);
dbJobListing.JobTitle = newJobListing.JobTitle;
dbJobListing.AgentId = newJobListing.AgentId;
dbJobListing.TargetCompanyId = newJobListing.TargetCompanyId;
dbJobListing.Comments = newJobListing.Comments;
dbJobListing.Rate = newJobListing.Rate;
dbJobListing.Distance = newJobListing.Distance;
dbJobListing.JobLocation = newJobListing.Location;
dbJobListing.ListingStatusRef = newJobListing.Status;
dbJobListing.EmploymentTypeRef = newJobListing.EmploymentType;
dbJobListing.ListingSourceRef = newJobListing.ListingSource;
dbJobListing.DesirabilityRef = newJobListing.Desirability;
dbJobListing.FitnessRef = newJobListing.Fit;
using (GetaJobContext db = new GetaJobContext())
{
db.JobListings.Add(dbJobListing);
db.SaveChanges();
success = dbJobListing.Id.ToString();
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public JobSkillModel Get(string skillId)
{
var skill = new JobSkillModel();
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbSkill = db.JobSkills.Where(s => s.Id == skillId).FirstOrDefault();
if (dbSkill != null)
{
skill.Name = dbSkill.SkillName;
skill.Category = dbSkill.SkillType;
skill.Proficiency = dbSkill.Proficiency;
if (dbSkill.Proficiency != null)
{
skill.ProficiencyDescription = db.JobRefs.Where(r => r.RefCode == dbSkill.Proficiency).FirstOrDefault().RefDescription;
}
skill.FontSize = dbSkill.SortOrder;
skill.Narrative = dbSkill.Narrative;
}
}
}
catch (Exception ex) { skill.Name = Helpers.ErrorDetails(ex); }
return(skill);
}
public string Post(AgencyModel agencyModel)
{
string success = "ERROR: ";
try
{
using (GetaJobContext db = new GetaJobContext())
{
JobCompany jobCompany = new JobCompany()
{
Id = Guid.NewGuid().ToString(),
CompanyTypeRef = "AGE",
CompanyName = agencyModel.CompanyName,
CompanyAddress = agencyModel.CompanyAddress,
CompanyZip = agencyModel.CompanyZip,
Email = agencyModel.Email,
OfficePhone = agencyModel.Phone,
Website = agencyModel.Website
};
db.JobCompanies.Add(jobCompany);
db.SaveChanges();
Agency agency = new Agency();
agency.Id = Guid.NewGuid().ToString();
agency.CompanyId = jobCompany.Id;
db.Agencies.Add(agency);
db.SaveChanges();
success = agency.Id;
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public string Put(JobSearchModel searchModel)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
JobSearch dbJobSearch = db.JobSearches.Where(j => j.Id == searchModel.Id).FirstOrDefault();
if (dbJobSearch != null)
{
dbJobSearch.Initiated = DateTime.Parse(searchModel.Initiated);
if (searchModel.Abandoned != null)
{
dbJobSearch.Abandoned = DateTime.Parse(searchModel.Abandoned);
}
dbJobSearch.SearchName = searchModel.SearchName;
db.SaveChanges();
success = "ok";
}
else
{
success = "Id: " + searchModel.Id + " not found";
}
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public JobSearchModel GetOne(string jobSearchId)
{
var jobSearch = new JobSearchModel();
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbJobSearch = db.JobSearches.Where(s => s.Id == jobSearchId).FirstOrDefault();
if (dbJobSearch != null)
{
jobSearch.Id = jobSearchId;
jobSearch.SearchName = dbJobSearch.SearchName;
jobSearch.PersonId = dbJobSearch.PersonId;
jobSearch.Initiated = dbJobSearch.Initiated.ToShortDateString();
if (dbJobSearch.Abandoned != null)
{
jobSearch.Abandoned = dbJobSearch.Abandoned.Value.ToShortDateString();
}
}
}
}
catch (Exception ex) { jobSearch.SearchName = Helpers.ErrorDetails(ex); }
return(jobSearch);
}
public string Put(JobRefModel refModel)
{
string success = "";
try
{
using (var db = new GetaJobContext())
{
JobRef @ref = db.JobRefs.Where(r => r.RefCode == refModel.RefCode).First();
@ref.RefDescription = refModel.RefDescription;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = ex.Message; }
return(success);
}
public List <JobListingModel> GetMany(string jobSearchId, string kludge)
{
var jobListingModels = new List <JobListingModel>();
try
{
using (var db = new GetaJobContext())
{
var dbJobListings = db.JobListings.Where(l => l.JobSearchId == jobSearchId).ToList();
foreach (JobListing dbListing in dbJobListings)
{
// just need items for list
JobListingModel jobListingModel = new JobListingModel();
jobListingModel.Id = dbListing.Id;
jobListingModel.PostedDate = dbListing.PostedDate.ToShortDateString();
jobListingModel.Location = dbListing.JobLocation;
var dbstatusRef = db.JobRefs.Where(r => r.RefCode == dbListing.ListingStatusRef).FirstOrDefault();
if (dbstatusRef != null)
{
jobListingModel.StatusText = dbstatusRef.RefDescription;
}
//dbJobListing.JobSearchId = newJobListing.JobSearchId;
//jobListingModel.JobTitle = listing.JobTitle;
//jobListingModel.AgentId = listing.AgentId;
//jobListingModel.TargetCompanyId = listing.TargetCompanyId;
//jobListingModel.Comments = listing.Comments;
//jobListingModel.Rate = listing.Rate;
//jobListingModel.Status = listing.ListingStatusRef;
//jobListingModel.EmploymentType = listing.EmploymentTypeRef;
//jobListingModel.Distance = listing.Distance;
//jobListingModel.ListingSource = listing.ListingSourceRef;
//jobListingModel.Desirability = listing.DesirabilityRef;
//jobListingModel.Fit = listing.FitnessRef;
jobListingModels.Add(jobListingModel);
}
}
}
catch (Exception ex) { jobListingModels.Add(new JobListingModel()
{
Id = Helpers.ErrorDetails(ex)
}); }
return(jobListingModels);
}
public string Put(JobSkillModel editedSkill)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbSkill = db.JobSkills.Where(j => j.Id == editedSkill.Id).FirstOrDefault();
dbSkill.SkillName = editedSkill.Name;
dbSkill.SkillType = editedSkill.Category;
dbSkill.Narrative = editedSkill.Narrative;
dbSkill.Proficiency = editedSkill.Proficiency;
dbSkill.SortOrder = editedSkill.FontSize;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public JobListingModel GetOne(string jobListingId)
{
var jobListing = new JobListingModel();
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbJobListing = db.JobListings.Where(s => s.Id == jobListingId).FirstOrDefault();
if (dbJobListing != null)
{
jobListing.Id = dbJobListing.Id;
jobListing.PostedDate = dbJobListing.PostedDate.ToShortDateString();
jobListing.JobTitle = dbJobListing.JobTitle;
jobListing.AgentId = dbJobListing.AgentId;
if (dbJobListing.AgentId != null)
{
jobListing.AgentId = dbJobListing.AgentId;
jobListing.AgencyId = dbJobListing.Agent.AgencyId;
}
jobListing.TargetCompanyId = dbJobListing.TargetCompanyId;
jobListing.Comments = dbJobListing.Comments;
jobListing.Status = dbJobListing.ListingStatusRef;
jobListing.Rate = dbJobListing.Rate;
jobListing.EmploymentType = dbJobListing.EmploymentTypeRef;
jobListing.Distance = dbJobListing.Distance;
jobListing.ListingSource = dbJobListing.ListingSourceRef;
jobListing.Desirability = dbJobListing.DesirabilityRef;
jobListing.Fit = dbJobListing.FitnessRef;
jobListing.Location = dbJobListing.JobLocation;
}
}
}
catch (Exception ex) { jobListing.Id = Helpers.ErrorDetails(ex); }
return(jobListing);
}
public string Post(JobSearchModel searchModel)
{
string success = "ERROR: ";
try
{
var jobSearch = new JobSearch();
jobSearch.Id = Guid.NewGuid().ToString();
jobSearch.PersonId = searchModel.PersonId;
jobSearch.SearchName = searchModel.SearchName;
jobSearch.Initiated = DateTime.Parse(searchModel.Initiated);
using (GetaJobContext db = new GetaJobContext())
{
db.JobSearches.Add(jobSearch);
db.SaveChanges();
success = jobSearch.Id.ToString();
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public AgencyModel GetOne(string Id)
{
var agency = new AgencyModel();
using (GetaJobContext db = new GetaJobContext())
{
var dbAgency = db.Agencies.Where(a => a.Id == Id).FirstOrDefault();
if (dbAgency == null)
{
agency.CompanyName = "not found";
}
else
{
agency.CompanyName = dbAgency.JobCompany.CompanyName;
agency.CompanyAddress = dbAgency.JobCompany.CompanyAddress;
agency.CompanyZip = dbAgency.JobCompany.CompanyZip;
agency.Email = dbAgency.JobCompany.Email;
agency.Phone = dbAgency.JobCompany.OfficePhone;
agency.Website = dbAgency.JobCompany.Website;
}
}
return(agency);
}
public JobRefModel Post(JobRefModel refModel)
{
try
{
using (var db = new GetaJobContext())
{
var @ref = new JobRef();
@ref.RefType = refModel.RefType;
@ref.RefCode = GetUniqueRefCode(refModel.RefDescription, db);
@ref.RefDescription = refModel.RefDescription;
db.JobRefs.Add(@ref);
db.SaveChanges();
refModel.RefCode = @ref.RefCode;
refModel.Success = "ok";
}
}
catch (Exception ex)
{
refModel.Success = ex.Message;
}
return(refModel);
}
public List <AgentModel> GetMany(string agencyId, string patch)
{
var agents = new List <AgentModel>();
using (var db = new GetaJobContext())
{
var dbAgents = db.Agents.Where(a => a.AgencyId == agencyId).ToList();
foreach (Agent dbAgent in dbAgents)
{
agents.Add(new AgentModel()
{
Id = dbAgent.Id,
FName = dbAgent.Person.FName,
LName = dbAgent.Person.LName,
Cell = dbAgent.Person.CellPhone,
Email = dbAgent.Person.Email,
Phone = dbAgent.Person.OfficePhone,
AgencyId = dbAgent.AgencyId
});
}
}
return(agents);
}
public AgentModel GetOne(string Id)
{
var agent = new AgentModel();
using (GetaJobContext db = new GetaJobContext())
{
var dbAgent = db.Agents.Where(a => a.Id == Id).FirstOrDefault();
if (dbAgent == null)
{
agent.FName = "not found";
}
else
{
agent.FName = dbAgent.Person.FName;
agent.LName = dbAgent.Person.LName;
agent.Cell = dbAgent.Person.CellPhone;
agent.Email = dbAgent.Person.Email;
agent.Phone = dbAgent.Person.OfficePhone;
agent.AgencyId = dbAgent.AgencyId;
}
}
return(agent);
}
public string Put(JobListingModel editJobListing)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
JobListing dbJobListing = db.JobListings.Where(j => j.Id == editJobListing.Id).FirstOrDefault();
if (dbJobListing != null)
{
dbJobListing.PostedDate = DateTime.Parse(editJobListing.PostedDate);
dbJobListing.JobLocation = editJobListing.Location;
dbJobListing.JobTitle = editJobListing.JobTitle;
dbJobListing.AgentId = editJobListing.AgentId;
dbJobListing.TargetCompanyId = editJobListing.TargetCompanyId;
dbJobListing.Comments = editJobListing.Comments;
dbJobListing.ListingStatusRef = editJobListing.Status;
dbJobListing.Rate = editJobListing.Rate;
dbJobListing.EmploymentTypeRef = editJobListing.EmploymentType;
dbJobListing.Distance = editJobListing.Distance;
dbJobListing.ListingSourceRef = editJobListing.ListingSource;
dbJobListing.DesirabilityRef = editJobListing.Desirability;
dbJobListing.FitnessRef = editJobListing.Fit;
db.SaveChanges();
success = "ok";
}
else
{
success = "Id: " + editJobListing.Id + " not found";
}
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public List <AgencyModel> GetMany()
{
var agencys = new List <AgencyModel>();
try
{
using (var db = new GetaJobContext())
{
var dbAgencies = db.Agencies.ToList();
foreach (Agency dbAgency in dbAgencies)
{
var agency = new AgencyModel();
agency.Id = dbAgency.Id;
agency.CompanyName = dbAgency.JobCompany.CompanyName;
agency.CompanyAddress = dbAgency.JobCompany.CompanyAddress;
//CompanyZip = dbAgency.JobCompany.CompanyZip,
//Email = dbAgency.JobCompany.Email,
//Phone = dbAgency.JobCompany.OfficePhone,
//Website = dbAgency.JobCompany.Website
foreach (Agent dbAgent in dbAgency.Agents)
{
var agent = new AgentModel();
agent.FName = dbAgent.Person.FName;
agent.LName = dbAgent.Person.LName;
agency.Agents.Add(agent);
}
agencys.Add(agency);
}
}
}
catch (Exception ex) { agencys.Add(new AgencyModel()
{
CompanyName = Helpers.ErrorDetails(ex)
}); }
return(agencys);
}
public string Post(JobSkillModel newSkill)
{
string success = "";
try
{
var dbSkill = new JobSkill();
dbSkill.Id = Guid.NewGuid().ToString();
dbSkill.Narrative = newSkill.Narrative;
dbSkill.SkillName = newSkill.Name;
dbSkill.Proficiency = newSkill.Proficiency;
dbSkill.SortOrder = newSkill.FontSize;
dbSkill.SkillType = newSkill.Category;
using (GetaJobContext db = new GetaJobContext())
{
db.JobSkills.Add(dbSkill);
db.SaveChanges();
success = dbSkill.Id;
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
