/* (non-Java-doc)
   * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
   */
  protected void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    // TODO Auto-generated method stub
    response.setContentType("text/html");
    PrintWriter kout = response.getWriter();
    kout.println("<html><head><title>Easy Deletion Of Offline Videos In VCS</title></head>");

    HttpSession my = request.getSession(false);
    String tdate = new Date().toGMTString().toString(),
        forrole = my.getAttribute("urole").toString();

    Connection mycon = null;
    Statement st;

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      mycon = DriverManager.getConnection("jdbc:odbc:myvcs");
      if (mycon != null) {
        try {
          kout.println(
              "<br><br><center>**************************************************************************************************************");
          kout.println("<table border=0>");
          kout.println(
              "<tr><td colspan=100%><center><h2>"
                  + Styles.ccase("Organisation : virtual class room system")
                  + "</center>");
          kout.println("<tr><td><br>");
          kout.println(
              "<tr><td colspan=75%><blockquote><h2>"
                  + Styles.ccase("Operation For : " + forrole)
                  + "<td><h2>"
                  + Styles.ccase(tdate));
          kout.println(
              "<tr><td colspan=75%><blockquote><h2>"
                  + Styles.ccase("Operation On : " + " Video")
                  + "<td><h2><a href='javascript:history.go(-1)'>Back</a>");
          kout.println("</table>");
          kout.println(
              "<br><br><br>**************************************************************************************************************</center><br>");

          st = mycon.createStatement();
          ResultSet rs = st.executeQuery("select * from library where status='video'");
          String fid = "", lpath = "", ltitle = "", cdate = "";
          int c = 1;
          kout.println("<body background='myreport1.jpg'>");
          kout.println("<center>");
          kout.println("<table border=0>");

          int k = 0;
          while (rs.next()) {
            c++;

            fid = rs.getString("fid");
            lpath = rs.getString("lpath");
            ltitle = rs.getString("ltitle");
            cdate = rs.getString("cdate");

            kout.println("<tr>");
            kout.println("<td>");
            kout.println(fid);
            kout.println("</td>");

            kout.println("<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
            kout.println("</td>");

            kout.println("<td>");
            kout.println(
                "<a href=\""
                    + lpath
                    + "\" title=\""
                    + ltitle
                    + "\" target=\"_blank\">"
                    + ltitle
                    + "</a>");
            kout.println("</td>");

            kout.println("<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
            kout.println("</td>");

            kout.println("<td>");
            kout.println(cdate);
            kout.println("</td>");

            kout.println("</tr>");
            kout.println("<tr><td colspan=100%><center>" + Fortable.display(33, "<<->>"));
          }
          rs.close();
          st.close();
          kout.println("</table><br>");
          if (c == 1) kout.println("<br><br><h1>Sorry No Videos Have Been Uploaded At Present");
        } catch (Exception k) {
          System.err.println(k);
          myerror = k.getMessage();

        } finally {
          mycon.close();
        }
      } else kout.println("<br><br><h2><center>Sorry Connection Is Not Active Now");
    } catch (Exception k) {
      System.err.println(k);
      myerror = myerror + "<br>" + k.getMessage();

    } finally {
      kout.println("<html><body background='myreport1.jpg'>");
      kout.println("</body></html>");

      if (myerror != null) kout.println("There Is A Error From Server-Side=" + myerror);

      kout.close();
    }
  }
  /* (non-Java-doc)
   * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
   */
  protected void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    // TODO Auto-generated method stub
    response.setContentType("text/html");
    PrintWriter kout = response.getWriter();
    kout.println("<html><head><title>View Blogs In VCS</title></head>");

    HttpSession my = request.getSession(false);

    String tdate = new Date().toGMTString().toString(),
        forrole = my.getAttribute("urole").toString();
    Connection mycon = null;
    Statement st;

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      mycon = DriverManager.getConnection("jdbc:odbc:myvcs");
      // kout.println("<br><br>**************************************************************************************************************");
      // kout.println("<br><h1>Your Connection With Mentioned DataSource Was Established
      // Successfully </h1>");
      // kout.println("<br><br>**************************************************************************************************************");
      if (mycon != null) {
        try {
          kout.println(
              "<br><br><center>**************************************************************************************************************");
          kout.println("<table border=0>");
          kout.println(
              "<tr><td colspan=100%><center><h2>"
                  + Styles.ccase("Organisation : virtual class room system")
                  + "</center>");
          kout.println("<tr><td><br>");
          kout.println(
              "<tr><td colspan=75%><blockquote><h2>"
                  + Styles.ccase("Report For : " + forrole)
                  + "<td><h2>"
                  + Styles.ccase(tdate));
          kout.println(
              "<tr><td colspan=75%><blockquote><h2>"
                  + Styles.ccase("Report Title : " + "View Blogs")
                  + "<td><h2><a href='javascript:history.go(-1)'>Back</a>");
          kout.println("</table>");
          kout.println(
              "<br><br><br>**************************************************************************************************************</center><br>");

          // kout.println("<br><br><h1>View Blogs In VCS</h1>");
          /*String trole,tuserid,tprior;
          trole=request.getAttribute("urole").toString();
          tuserid=request.getAttribute("uid").toString();
          tprior=request.getAttribute("uprior").toString();*/

          st = mycon.createStatement();
          ResultSet rs = st.executeQuery("select * from blog_master");

          int c = 1;
          kout.println("<center>");
          while (rs.next()) {
            kout.println("<center><table width=95% border=2 bordercolor=black>");
            String str = rs.getString("bid");
            kout.println("<tr><td colspan=100%><center>" + Fortable.display(153, "*"));

            if (c % 2 == 1)
              kout.println("<tr><td colspan=95%><center><h1>Blog Id :" + str + "</center></h1>");
            else kout.println("<tr><td colspan=95%><center><h2>Blog Id :" + str + "</center></h2>");

            kout.println(
                "<tr><td>Sr No:<td>"
                    + c
                    + "<tr><td>Given By:<td>"
                    + rs.getString("userid")
                    + "<tr><td>Blog Date & Time:<td>"
                    + rs.getString("bdate")
                    + "<tr><td>CourseName<td>"
                    + rs.getString("coursename"));
            kout.println("<tr><td colspan=11><center>Blog Message:</center>");
            kout.println("<tr><td colspan=11>" + rs.getString("bmsg"));
            c = c + 1;

            kout.println("<tr><td colspan=100%><center>" + Fortable.display(33, "<<->>"));
            kout.println("</table><br>");
          }
          rs.close();
          st.close();
          if (c == 1)
            kout.println("<br><br><h1>Sorry No Blog Have Been Created Or Available At Present");

        } catch (Exception k) {
          System.err.println(k);
          myerror = k.getMessage();
        } finally {
          mycon.close();
        }
      } else kout.println("<br><br><h2><center>Sorry Connection Is Not Active Now");
    } catch (Exception k) {
      System.err.println(k);
      myerror = myerror + "<br>" + k.getMessage();
    } finally {
      kout.println("<html><body background='myreport1.jpg'>");
      kout.println("</body></html>");

      if (myerror != null) kout.println("There Is A Error From Server-Side=" + myerror);

      kout.close();
    }
  }