package com.cargo.crotrol;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.cargo.filter.Line;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Collection;
import java.util.ArrayList;
import com.cargo.db.Cardb;
import com.cargo.db.Areadb;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */
public class CarAction extends Action {
    private ActionErrors errors = new ActionErrors();
    private ActionForward forward = new ActionForward();
    private Line line = new Line();
    private int t=0;
    private Collection coll=new ArrayList();
    private Cardb db=new Cardb();
    private Areadb areadb=new Areadb();
    public ActionForward perform(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest httpServletRequest,
                                 HttpServletResponse httpServletResponse) {
        /**@todo: complete the business logic here, this is just a skeleton.*/
        CarForm form=(CarForm)actionForm;
        HttpServletRequest request = httpServletRequest;
        String action = actionMapping.getParameter();
        forward = line.down("id", actionMapping, httpServletRequest,
                            "errors");
        if (forward != null && forward.getName().equals("errors")) {
            return forward;
        }
        if ("".equalsIgnoreCase(action)) {
            forward = actionMapping.findForward("errors");
        } else if ("view".equalsIgnoreCase(action)) {
            forward = View(actionMapping, form, request, httpServletResponse);
        } else if ("del".equalsIgnoreCase(action)) {
            forward = Del(actionMapping, form, request, httpServletResponse);
        } else if ("add".equalsIgnoreCase(action)) {
            forward = Add(actionMapping, form, request, httpServletResponse);
        } else if ("edit".equalsIgnoreCase(action)) {
            forward = Edit(actionMapping, form, request, httpServletResponse);
        } else if ("select".equalsIgnoreCase(action)) {
            forward = Select(actionMapping, form, request, httpServletResponse);
        } else {
            forward = actionMapping.findForward("errors");
        }
        return forward;
    }

    private ActionForward Del(ActionMapping actionMapping, CarForm form,
                              HttpServletRequest request,
                              HttpServletResponse response) {
       String id = request.getParameter("id").toString();
        t = db.delete(db.DELETE + "tb_car" + db.WHERE + "id=" + id);
        if (t <= 0) {
            errors.clear();
            errors.add("deletefail", new ActionError("error.delete.fail"));
            saveErrors(request, errors);
        }
        request.setAttribute("info","true");
        return actionMapping.findForward("success");
    }

    private ActionForward Add(ActionMapping actionMapping, CarForm form,
                              HttpServletRequest request,
                              HttpServletResponse response) {
        t=db.getRowCount("tb_car"+db.WHERE+"id='"+form.getCar().getId()+"'");
        if (t > 0) {
            errors.clear();
            errors.add("insertfail", new ActionError("error.insert.repeat"));
            saveErrors(request, errors);
            return (new ActionForward(actionMapping.getInput()));
        }
        t=db.insert(form.getCar());
        if(t<=0){
            errors.clear();
            errors.add("insertfail", new ActionError("error.insert.fail"));
            saveErrors(request, errors);
            return (new ActionForward(actionMapping.getInput()));
        }
        request.setAttribute("info","true");
        return actionMapping.findForward("success");
    }

    private ActionForward Edit(ActionMapping actionMapping, CarForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
        String id=request.getParameter("id").toString();
        t=db.update(form.getCar());
        if(t<=0){
            errors.clear();
            errors.add(Action.ERROR_KEY, new ActionError("error.update.fail"));
            saveErrors(request, errors);
        }
        return actionMapping.findForward("success");
    }

    private ActionForward Select(ActionMapping actionMapping, CarForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
        coll=areadb.select();
        if (coll == null || coll.isEmpty()) {
            errors.add("selectfail1", new ActionError("error.manage.addarea"));
            saveErrors(request, errors);
            return (new ActionForward(actionMapping.getInput()));
        }
        request.setAttribute("Area",coll);
        return actionMapping.findForward("success");
    }

    private ActionForward View(ActionMapping actionMapping, CarForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
        Collection collcar=new ArrayList();
        String id=null;
        try{
            id=request.getParameter("id").toString();
        }catch(Exception e){
            id=null;
        }
        if(id==null||id.length()<=0){
            collcar=db.select();
        }else{
            collcar=db.select(db.WHERE+"id='"+id+"'");
            ActionForward forward = Select( actionMapping, form,  request,response);
            if (forward.getName() == null ||
                !forward.getName().equalsIgnoreCase("success")) {
                errors.clear();
                errors.add("selectfail", new ActionError("error.manage.addarea"));
            }
        }
        if (collcar == null || collcar.isEmpty()) {
            errors.add("selectfail1", new ActionError("error.data.null"));
        }
        if(!errors.empty()){
            saveErrors(request, errors);
        }
        request.setAttribute("Car",collcar);
        return actionMapping.findForward("success");
    }
}