public void deletePhieuKhaoSat(PhieuKhaoSat p)
{
try
{
openConnection();
SqlCommand cmd = new SqlCommand("XoaPKS", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_PhieuKhaoSat", p.ID_PhieuKhaoSat);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
new Exception("Error: " + ex.Message);
}
finally
{
closeConnection();
}
}
public void insertPhieuKhaoSat(PhieuKhaoSat p)
{
try
{
openConnection();
SqlCommand cmd = new SqlCommand("ThemPKS", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_PhieuKhaoSat", p.ID_PhieuKhaoSat);
cmd.Parameters.AddWithValue("@ID_KhachHang", p.ID_KhachHang);
cmd.Parameters.AddWithValue("@ID_Xe", p.ID_Xe);
cmd.Parameters.AddWithValue("@YeuCau", p.YeuCau);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
new Exception("Error: " + ex.Message);
}
finally
{
closeConnection();
}
}
