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(); } }