public async Task <IActionResult> Edit(int id, [Bind("Id,TypeTravel,DayCount,Premium,AgreeDate,InsuredId,PolicyId")] TravelPolicy travelPolicy)
{
if (id != travelPolicy.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(travelPolicy);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TravelPolicyExists(travelPolicy.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["InsuredId"] = new SelectList(_context.User, "Id", "EMBG", travelPolicy.InsuredId);
ViewData["PolicyId"] = new SelectList(_context.Policy, "Id", "PolicyNumber", travelPolicy.PolicyId);
return(View(travelPolicy));
}
public async Task <int> Create(TravelPolicy itm)
{
string query = @"Insert into TravelPolicy values (@CustomerId , @PolicyNo, @ProductName, @Status, @Amount, @CoverStarts, @CoverEnds);
select Cast(Scope_Identity() as int)";
var id = await _dbConnection.QueryAsync <int>(query, itm);
return(id.Single());
}
public async Task <IActionResult> Create([Bind("Id,TypeTravel,DayCount,Premium,AgreeDate,InsuredId,PolicyId")] TravelPolicy travelPolicy)
{
if (ModelState.IsValid)
{
_context.Add(travelPolicy);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["InsuredId"] = new SelectList(_context.User, "Id", "EMBG", travelPolicy.InsuredId);
ViewData["PolicyId"] = new SelectList(_context.Policy, "Id", "PolicyNumber", travelPolicy.PolicyId);
return(View(travelPolicy));
}
