public async Task <IActionResult> Edit(int id, [Bind("Id,Luggage,OrderId,VisitorId")] qvVisitorLuggage qvVisitorLuggage)
{
if (id != qvVisitorLuggage.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(qvVisitorLuggage);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!qvVisitorLuggageExists(qvVisitorLuggage.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
ViewData["OrderId"] = new SelectList(_context.Orders, "Id", "Order", qvVisitorLuggage.OrderId);
ViewData["VisitorId"] = new SelectList(_context.Visitors, "Id", "Visitor", qvVisitorLuggage.VisitorId);
return(View(qvVisitorLuggage));
}
public async Task <IActionResult> Create([Bind("Id,Luggage,OrderId,VisitorId")] qvVisitorLuggage qvVisitorLuggage)
{
if (ModelState.IsValid)
{
_context.Add(qvVisitorLuggage);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewData["OrderId"] = new SelectList(_context.Orders, "Id", "Order", qvVisitorLuggage.OrderId);
ViewData["VisitorId"] = new SelectList(_context.Visitors, "Id", "Visitor", qvVisitorLuggage.VisitorId);
return(View(qvVisitorLuggage));
}
public async Task <IActionResult> Create([Bind("Id,Luggage,OrderId,VisitorId")] qvVisitorLuggage qvVisitorLuggage)
{
if (ModelState.IsValid)
{
_context.Add(qvVisitorLuggage);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "qvOrders", new { id = qvVisitorLuggage.OrderId }));
}
ViewData["OrderId"] = new SelectList(_context.Orders, "Id", "Id", qvVisitorLuggage.OrderId);
ViewData["VisitorId"] = new SelectList((from s in _context.refOrderVisitor.Include(q => q.Order).Include(q => q.Visitor)
where s.OrderId == qvVisitorLuggage.OrderId
select
new { Id = s.Visitor.Id, FullName = s.Visitor.surname + " " + s.Visitor.name + " " + s.Visitor.patronymic }), "Id", "FullName");
ViewData["RefOrdId"] = qvVisitorLuggage.OrderId;
ViewData["RefVisId"] = qvVisitorLuggage.VisitorId;
return(RedirectToAction("Create", "qvVisitorLuggages", new { visid = qvVisitorLuggage.VisitorId, ordid = qvVisitorLuggage.OrderId }));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Luggage,OrderId,VisitorId")] qvVisitorLuggage qvVisitorLuggage)
{
if (id != qvVisitorLuggage.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(qvVisitorLuggage);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!qvVisitorLuggageExists(qvVisitorLuggage.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Details", "qvOrders", new { id = qvVisitorLuggage.OrderId }));
}
ViewData["RefOrdId"] = qvVisitorLuggage.OrderId;
ViewData["RefVisId"] = qvVisitorLuggage.VisitorId;
ViewData["OrderId"] = new SelectList(_context.Orders, "Id", "Id", qvVisitorLuggage.OrderId);
ViewData["VisitorId"] = new SelectList((from s in _context.refOrderVisitor.Include(q => q.Order).Include(q => q.Visitor)
where s.OrderId == qvVisitorLuggage.OrderId
select
new { Id = s.Visitor.Id, FullName = s.Visitor.surname + " " + s.Visitor.name + " " + s.Visitor.patronymic }), "Id", "FullName");
var cn = from c in _context.Visitors
where c.Id == qvVisitorLuggage.VisitorId
select new { FullName = c.surname + " " + c.name + " " + c.patronymic };
ViewData["VisitorName"] = cn.Select(e => e.FullName).ToList()[0];
return(View(qvVisitorLuggage));
}