public async Task <IActionResult> PutTblTransportation(long id, TblTransportation tblTransportation)
{
if (id != tblTransportation.Id)
{
return(BadRequest());
}
_context.Entry(tblTransportation).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblTransportationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <TblTransportation> > PostTblTransportation(TblTransportation tblTransportation)
{
_context.TblTransportation.Add(tblTransportation);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblTransportation", new { id = tblTransportation.Id }, tblTransportation));
}
public async Task <ApiResponse> TransportationByPortAuction(TblTransportation tbltransportation)
{
var companylist = await _context.TblCompany.Distinct().ToListAsync();
var transportList = await _context.TblTransportation.Where(i => i.SourceId == tbltransportation.SourceId && i.DesstinationId == tbltransportation.DesstinationId && i.TypeId == tbltransportation.TypeId).ToListAsync();
var items = (from tl in transportList
select new
{
id = tl.Id,
name = companylist.Where(i => i.Id == tl.CompanyId).Select(i => i.CompanyName).FirstOrDefault()
}).ToList();
var ApiResponse = await response.ApiResult("OK", items, "Record Found");
return(ApiResponse);
}
