package DefServlet;

import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import org.omg.CORBA.DATA_CONVERSION;

public class InvServlet extends HttpServlet
{


    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

        String reqType = request.getParameter("rtype");
        if(reqType.equals("send"))
        {

                String eid = null, ecustomer= null, equantity= null, etype= null, efromdate= null, etodate= null, eprice= null, etotalamount= null, epayment= null;
                eid = request.getParameter("eid");
                ecustomer = request.getParameter("ecustomer");
                equantity = request.getParameter("equantity");
                etype = request.getParameter("etype");
                efromdate = "datefrom";//request.getParameter("efromdate");
                etodate = "dateto";//request.getParameter("etodate");
                eprice = request.getParameter("eprice");
                etotalamount = request.getParameter("etotalamount");
                epayment = request.getParameter("epayment");

                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection conn = DriverManager.getConnection("jdbc:odbc:inventoryh", "sa", "qazwsx");
                    Statement st = conn.createStatement();
                    String q1 = "INSERT INTO Entry (eid, ecustomer, equantity, etype, efromdate, etodate, eprice, etotalamount, epayment )";
                    String q2 = "VALUES ('"+ eid + "', '" + ecustomer +"', '" + equantity +"', '" +
                                                    etype +"', '" + efromdate + "', '" + etodate + "', '"  +
                                                    eprice +"', '" + etotalamount + "', '" + epayment +"')";

                    String query = q1 + q2;
                    st.execute(query);
                }
                catch(Exception ex)
                {
                    String msg = ex.getMessage();
                }
        }
        else if(reqType.equals("get"))
        {
             String eid = request.getParameter("eid");
             String ecustomer= null, equantity= null, etype= null, efromdate= null, etodate= null, eprice= null, etotalamount= null, epayment= null;
             String data = "";
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection conn = DriverManager.getConnection("jdbc:odbc:inventoryh", "sa", "qazwsx");
                Statement st = conn.createStatement();
                String query = "SELECT * FROM entry WHERE eid='" + eid + "'";
                ResultSet set = st.executeQuery(query);

                while(set.next())
                {

                ecustomer = set.getString("ecustomer");
                equantity = set.getString("equantity");
                etype = set.getString("etype");
                efromdate =set.getString("efromdate");
                etodate = set.getString("etodate");
                eprice = set.getString("eprice");
                etotalamount = set.getString("etotalamount");
                epayment = set.getString("epayment");
                }

                data = ecustomer+","+equantity+","+etype+","+efromdate+","+etodate+","+eprice+","+
                        etotalamount+","+ epayment;
            }
            catch(Exception ex)
            {
                String msg = ex.getMessage();
            }

                response.setContentType("text/plain");
                response.setContentLength(data.length());
                PrintWriter out = response.getWriter();
                out.println(data);
                out.flush();

                if(out != null){
                    out.close();
                }

    }
 }


    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException
    {
    }
    // </editor-fold>
}