public async Task <IActionResult> PutPhieuDanhGia(int id, PhieuDanhGia phieuDanhGia)
{
if (id != phieuDanhGia.Id)
{
return(BadRequest());
}
phieuDanhGia.NgayCapNhat = DateTime.Now;
_context.Entry(phieuDanhGia).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PhieuDanhGiaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void deletePhieuDanhGia(PhieuDanhGia p)
{
try
{
openConnection();
SqlCommand cmd = new SqlCommand("XoaPDG", Conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_PhieuDanhGia", p.ID_PhieuDanhGia);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
new Exception("Error: " + ex.Message);
}
finally
{
closeConnection();
}
}
public void editPhieuDanhGia(PhieuDanhGia p)
{
try
{
openConnection();
SqlCommand cmd = new SqlCommand("SuaPDG", Conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_PhieuDanhGia", p.ID_PhieuDanhGia);
cmd.Parameters.AddWithValue("@ID_PhieuKhaoSat", p.ID_PhieuKhaoSat);
cmd.Parameters.AddWithValue("@TinhTrangXe", p.TinhTrangXe);
cmd.Parameters.AddWithValue("@MaBaoHiem", p.MaBaoHiem);
cmd.Parameters.AddWithValue("@ThongBaoGia", p.BaoGia);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
new Exception("Error: " + ex.Message);
}
finally
{
closeConnection();
}
}
