public async Task <ActionResult <TblRequest> > PostTblRequest(TblRequest tblRequest) { _context.TblRequests.Add(tblRequest); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblRequest", new { id = tblRequest.RequestId }, tblRequest)); }
public async Task <IActionResult> PutTblRequest(int id, TblRequest tblRequest) { if (id != tblRequest.RequestId) { return(BadRequest()); } _context.Entry(tblRequest).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblRequestExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult> Edit([Bind(Include = "RequestId,Title,Description,Status,UserId")] TblRequest tblRequest) { if (ModelState.IsValid) { db.Entry(tblRequest).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(tblRequest)); }
public async Task <ActionResult> Create([Bind(Include = "Title,Description,Status")] TblRequest tblRequest) { if (ModelState.IsValid) { tblRequest.UserId = Convert.ToInt32(Session["UserId"]); db.TblRequests.Add(tblRequest); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.TblUsers, "UserId", "Name", tblRequest.UserId); return(View(tblRequest)); }
// GET: Request/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblRequest tblRequest = await db.TblRequests.FindAsync(id); if (tblRequest == null) { return(HttpNotFound()); } return(View(tblRequest)); }
// GET: TblRespons/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblRequest tblRequest = await db.TblRequests.FindAsync(id); if (tblRequest == null) { return(HttpNotFound()); } Session["RequestId"] = id; return(View()); }
public async Task <ActionResult> DeleteConfirmed(int id) { var responsesList = from responses in db.TblResponses where responses.RequestId.Equals(id) select responses; RequestViewModel requestViewModel = new RequestViewModel(); requestViewModel.Responses = await responsesList.ToListAsync(); foreach (TblRespons response in requestViewModel.Responses) { db.TblResponses.Remove(response); } TblRequest tblRequest = await db.TblRequests.FindAsync(id); db.TblRequests.Remove(tblRequest); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }