public DataSet countOrders() //for create the id
{
OrderCAD c = new OrderCAD();
DataSet ds = c.countOrders();
return(ds);
}
public DataSet searchHistory(String user) //search history cart filter by users
{
OrderCAD c = new OrderCAD();
DataSet ds = c.searchUserHistory(user);
return(ds);
}
public DataSet showAllOrders() //show all the orders
{
OrderCAD c = new OrderCAD();
DataSet ds = c.showOrders(this);
return(ds);
}
public DataSet add_Order() //insert new order
{
OrderCAD c = new OrderCAD();
DataSet ds = c.addOrder(this);
return(ds);
}
public DataSet searchOrders(String user) //search orders filter by users
{
OrderCAD c = new OrderCAD();
DataSet ds = c.searchUserOrders(user);
return(ds);
}
public DataSet update_Order(int i) //update an existing order
{
OrderCAD c = new OrderCAD();
DataSet ds = c.updateOrder(this, i);
return(ds);
}
public ArrayList searchOrder()
{
ArrayList a = new ArrayList();
OrderCAD c = new OrderCAD();
a = c.searchOrder(this);
return(a);
}
public ArrayList showAllOrders()
{
ArrayList a = new ArrayList();
OrderCAD c = new OrderCAD();
a = c.showOrder();
return(a);
}
public void buy_Order(int i) //from the shopping cart to the history
{
OrderCAD c = new OrderCAD();
c.buyOrder(this, i);
}
public void update_Order()
{
OrderCAD c = new OrderCAD();
c.updateOrder(this);
}
public void delete_Order()
{
OrderCAD c = new OrderCAD();
c.deleteOrder(this);
}
public void add_Order()
{
OrderCAD c = new OrderCAD();
c.addOrder(this);
}