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