public async Task <IActionResult> Edit(int id, [Bind("PkWkspcId,FkWkspcBid,WkspcStartTime,WkspcExpectendEndTime,WkspcActualEndTime,WkspcRating,WkspcStatus,WkspcFeedback,WkspcAmountAgreed")] TblWorkspace tblWorkspace) { if (id != tblWorkspace.PkWkspcId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblWorkspace); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblWorkspaceExists(tblWorkspace.PkWkspcId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FkWkspcBid"] = new SelectList(_context.TblBid, "PkBidId", "BidOfferInformation", tblWorkspace.FkWkspcBid); return(View(tblWorkspace)); }
public async Task <IActionResult> Create([Bind("PkWkspcId,FkWkspcBid,WkspcStartTime,WkspcExpectendEndTime")] TblWorkspace tblWorkspace) { var bidupdate = _context.TblBid; var job_edit = _context.TblJob.SingleOrDefault(z => z.PkJobId == bidupdate.SingleOrDefault(x => x.PkBidId == tblWorkspace.FkWkspcBid).FkJobBidded); tblWorkspace.WkspcAmountAgreed = "0"; tblWorkspace.WkspcStatus = "Started"; if (ModelState.IsValid) { var update_bid = bidupdate.SingleOrDefault(x => x.PkBidId == tblWorkspace.FkWkspcBid); _context.Add(tblWorkspace); if (update_bid != null) { update_bid.BidStatus = "Granted"; } if (update_bid != null) { update_bid.BidAwardTime = DateTime.Now.ToString(CultureInfo.InvariantCulture); } if (job_edit != null) { job_edit.JobStatus = "Granted"; } foreach (var deniedbid in bidupdate.Where(x => x.PkBidId != tblWorkspace.FkWkspcBid && x.FkJobBidded == job_edit.PkJobId)) { deniedbid.BidStatus = "Denied"; } await _context.SaveChangesAsync(); /*return RedirectToAction(nameof(Index),new {tblWorkspace.FkWkspcBid});*/ return(RedirectToAction("Bidusers", "TblBids")); } ViewData["FkWkspcBid"] = new SelectList(_context.TblBid, "PkBidId", "BidOfferInformation", tblWorkspace.FkWkspcBid); return(View(tblWorkspace)); }
public async Task <IActionResult> Create([Bind("PkWkspcId,FkWkspcBid,WkspcStartTime,WkspcExpectendEndTime,WkspcActualEndTime,WkspcRating,WkspcStatus,WkspcFeedback,WkspcAmountAgreed")] TblWorkspace tblWorkspace) { if (ModelState.IsValid) { _context.Add(tblWorkspace); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index), new { tblWorkspace.FkWkspcBid })); } ViewData["FkWkspcBid"] = new SelectList(_context.TblBid, "PkBidId", "BidOfferInformation", tblWorkspace.FkWkspcBid); return(View(tblWorkspace)); }