public async Task <IActionResult> PutPhieuThuChiTiet([FromRoute] int id, [FromBody] PhieuThuChiTiet phieuthuchitiet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != phieuthuchitiet.PhieuThuChiTietId)
{
return(BadRequest());
}
_context.Entry(phieuthuchitiet).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhieuThuChiTietExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostPhieuThuChiTiet([FromBody] PhieuThuChiTiet phieuthuchitiet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.PhieuThuChiTiets.Add(phieuthuchitiet);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPhieuThuChiTiet", new { id = phieuthuchitiet.PhieuThuChiTietId }, phieuthuchitiet));
}
public IEnumerable <TheXe> GetItems([FromRoute] int start, int count, string orderBy, [FromBody] string whereClause)
{
orderBy = orderBy != "x" ? orderBy : "";
var thexes = _context.Set <TheXe>().FromSql($"tbl_TheXe_GetItemsByRange {start},{count},{whereClause},{orderBy}").ToList <TheXe>();
for (int i = 0; i < thexes.Count(); i++)
{
thexes[i].LoaiXes = _context.LoaiXes.SingleOrDefault(o => o.LoaiXeId == thexes[i].LoaiXeId);
PhieuThuChiTiet pt = _context.PhieuThuChiTiets.Where(o => o.TheXeId == thexes[i].TheXeId).OrderByDescending(o => o.HanDenNgay).FirstOrDefault();
thexes[i].PhieuThuChiTiets = pt;
}
return(thexes);
}
