public ActionResult Display(int id)
{
dbEntities db = new dbEntities();
JobSkillsModel jobSkills = new JobSkillsModel();
jobSkills.myJob = db.Jobs.Where(o => o.Id == id).Single();
List <JobRequirement> jobReqs = db.JobRequirements.Where(o => o.JobId == jobSkills.myJob.Id).ToList();
jobSkills.mySkillNames = new List <String>();
foreach (var req in jobReqs)
{
jobSkills.mySkillNames.Add(db.SkillsLogs.Where(o => o.Id == req.SkillId).Single().Name);
}
return(View("~/Views/Jobs/JobDisplay.cshtml", jobSkills));
}
public ActionResult putJobInfo(JobSkillsModel model)
{
if (ModelState.IsValid)
{
using (dbEntities db = new dbEntities())
{
model.myJob.EmployerId = (int)Session["loginid"];
User passIn = db.Users.Where(o => o.Id == model.myJob.EmployerId).Single();
var num2 = db.Jobs.LongCount();
db.Jobs.Add(new Job
{
Title = model.myJob.Title,
EmployerId = (int)Session["loginid"],
JobDec = model.myJob.JobDec,
Location = model.myJob.Location,
StartPrice = model.myJob.StartPrice,
CanBid = model.myJob.CanBid,
User = passIn,
Status = "Public",
StartDate = model.myJob.StartDate.ToLocalTime(),
BidEndDate = model.myJob.BidEndDate.ToLocalTime()
});
db.SaveChanges();
int jobCount = (int)db.Jobs.ToList().LongCount() + 2;
foreach (var skill in model.mySkillNames)
{
db.Jobs.Where(o => o.Id == jobCount).Single().JobRequirements.Add(new JobRequirement
{
JobId = jobCount,
SkillId = db.SkillsLogs.Where(o => o.Name.Equals(skill)).Single().Id,
Id = db.JobRequirements.Count() + 1
});
}
db.SaveChanges();
db.SaveChanges();
return(RedirectToAction("Display", "DisplayJob", new { id = jobCount }));
}
}
return(View(new HttpException("Model Invalid")));
}
