iitguide.com - Student Login
<%@ page import="java.sql.*, java.lang.*, com.iitguide.utils.dbutils.*, java.io.File, java.util.*, java.text.*" %> <%@ page errorPage="error.jsp" %>

The VIDEO CHAT way of coaching!
Contact us at - Tel: 91-8954000504  or   e-mail: contact@iitguide.com

                                                           

<% if (session.getAttribute("isstudentsession")!=null){ ResultSet rs1; try { //Change these strings for yearly assignment changes String chemistry_course_id = "chemistry_main_2014_1"; String mathematics_course_id = "mathematics_main_2014_1"; String physics_course_id = "physics_main_2014_1"; String windowsDirectory = "/webapps/iitguide/Version_2014-2015/"; String Assignmentloc = null; String strsql = null; boolean nonMobile = true; //require this attribute to behave differently in mobile and non mobile devices. boolean assignmentaccess = false; Connection connDB=new DBConnection().getConnection(); Statement stmt1 = connDB.createStatement(); //Giving access to the students who has either paid or AssignmentAccess is true.. Only way students can get access to assignments, if they are paid or AllowAssignments. Remove Registered after sometime strsql = "select * from registrationdetailspackage where email_id='"+session.getAttribute("isstudentsession")+"' and registration_status = 'Paid' or email_id='"+session.getAttribute("isstudentsession")+"' and registration_status = 'AllowAssignments'"; //out.println(strsql); rs1=stmt1.executeQuery(strsql); while (rs1.next() ) { assignmentaccess = true; } String chapter_code = null; File directoryCheck = null; String DirectoryAbsolute = null; String tomcatbaseDir = System.getProperty("catalina.base"); if (System.getProperty("os.name").equals("Linux")) { DirectoryAbsolute = tomcatbaseDir+ "/webapps/ROOT/StudentLogin/Assignments/"; } else{ DirectoryAbsolute = tomcatbaseDir+ windowsDirectory + "/StudentLogin/Assignments/"; } %>
Selected Title
<% strsql = "select * from courses, offeredcourses where offered_course_package_code='"+chemistry_course_id+"' and courses.chapter_code=offeredcourses.chapter_code"; rs1=stmt1.executeQuery(strsql); while (rs1.next()) { chapter_code=rs1.getString("chapter_code"); directoryCheck = new File(DirectoryAbsolute+chapter_code); Assignmentloc = DirectoryAbsolute+chapter_code+"/index.html"; if (directoryCheck.exists() && assignmentaccess ) { %>
">
<% } }%>
<% strsql = "select * from courses, offeredcourses where offered_course_package_code='"+mathematics_course_id+"' and courses.chapter_code=offeredcourses.chapter_code"; rs1=stmt1.executeQuery(strsql); while (rs1.next()) { chapter_code=rs1.getString("chapter_code"); directoryCheck = new File(DirectoryAbsolute+chapter_code); Assignmentloc = DirectoryAbsolute+chapter_code+"/index.html"; if (directoryCheck.exists() && assignmentaccess) { %>
">
<%} }%>
<% strsql = "select * from courses, offeredcourses where offered_course_package_code='"+physics_course_id+"' and courses.chapter_code=offeredcourses.chapter_code"; rs1=stmt1.executeQuery(strsql); while (rs1.next()) { chapter_code=rs1.getString("chapter_code"); directoryCheck = new File(DirectoryAbsolute+chapter_code); Assignmentloc = DirectoryAbsolute+chapter_code+"/index.html"; if (directoryCheck.exists() && assignmentaccess) { %>
">
<%} }%>

user: <%=session.getAttribute("isstudentsession")%> | Change Password | Log Out

<% stmt1.close(); connDB.close(); } catch(SQLException r){out.println("no"+r); throw r;} } else { %> <% } %>