public ActionResult ViewBids(int?id) { var bids = db.Bids.Where(x => x.JobID == id); BiddersViewModel bidders = new BiddersViewModel(); bidders.Bids = bids; List <Person> people = new List <Person>(); foreach (Bid bid in bids) { Person p = db.People.FirstOrDefault(x => x.PersonId == bid.FreelancerID); people.Add(p); } bidders.People = people; bidders.Job = db.Jobs.FirstOrDefault(x => x.JobId == id); return(View(bidders)); }
public ActionResult ManageFreelancers(int?id) { string userId = User.Identity.GetUserId(); if (db.People.Any(x => x.User_AccountID == userId && x.Approved == false)) { ViewBag.Message = "Your Registration Request is pending..."; return(View("Info")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Job job = db.Jobs.FirstOrDefault(j => j.JobId == id); if (job == null) { return(HttpNotFound()); } var bids = db.Bids.Where(x => x.JobID == job.JobId && x.Active == 1 && x.Accepted == true); BiddersViewModel biddersViewModel = new BiddersViewModel(); biddersViewModel.Bids = bids; biddersViewModel.Job = job; List <Person> people = new List <Person>(); List <AspNetUser> users = new List <AspNetUser>(); foreach (Bid bid in bids) { Person person = db.People.FirstOrDefault(x => x.PersonId == bid.FreelancerID); people.Add(person); AspNetUser user = db.AspNetUsers.FirstOrDefault(x => x.Id == person.User_AccountID); users.Add(user); } biddersViewModel.People = people; biddersViewModel.AspNetUsers = users; return(View(biddersViewModel)); }