%@ include file="!include/var.jsp" %>
<% order.setConnectionPool(htnPool); %>
<%@ include file="checkSession.jsp" %>
<%
DBResult dbresult = order.selOrder();
int iRowCount = dbresult.getRowCount();
String action = request.getParameter("action");
if(action==null)
{
action = "";
}
%>
display orders
|
<%--| id | --%>
date |
time |
contact |
company |
address |
city |
postcode |
country |
phone |
fax |
email |
product |
quantity |
per |
delivery |
destination |
comment |
delete |
<%
//SiteDirectory siteDir = new SiteDirectory();
for(int i=0; i
<%--| <%=clientId %> | --%>
<%=orderDay %>_<%=orderMonth %>_<%=orderYear %> |
<%=orderHour %>:<%=orderMinute %> |
<%=orderGender %> <%=orderContact %> |
<%=orderCompany %> |
<%=orderAddress %> |
<%=orderCity %> |
<%=orderPostal %> |
<%=orderCountry %> |
<%=orderPhone %> |
<%=orderFax %> |
<%=orderEmail %> |
<%=orderProduct %> |
<%=orderQuantity %> |
<%=orderPer %> |
<%=orderDelivery %> |
<%=orderDestination %> |
<%=orderComment %> |
delete |
<%
}
%>
<%
if(action.equals("delete"))
{
//SiteDirectory siteDir = new SiteDirectory();
String strOrderId = request.getParameter("orderId");
int order_id = Integer.parseInt(strOrderId);
if(order.delete(order_id))
{
%>
<%-- --%>
Successful deletion of order record
<%
response.sendRedirect("dispOrder.jsp");
}
}
%>