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