A Summer Internship Project Report

On

Resolt – Result and Profile Management Website

Carried out at the

BSES YAMUNA POWER LIMITED

During 15th June-15th July 2016

Submitted by Under Guidance ofSATISH HARESH PADNANI Mr. Samir Banger3rd Year CSE (Dy. General Manager)Krishna Engg. College Mr. Rohan

CERTIFICATE

This is to certify that the summer internship project report entitled “Resolt – Result and

Profile Management Website” submitted by SATISH HARESH PADNANI, B.Tech

(CSE) 3rd Year, Krishna Engineering College to BSES YAMUNA POWER LIMITED

(BYPL),New Delhi is a record of bonafide work carried out by his under my supervision

and guidance during 15th June 2016 to 15th July 2016.

(Mr.Samir Banger)Dy. General Manager ITProject Guide

Acknowledgment

First, and foremost I would like to thank my project supervisor Mr.Samir Banger, who

guided me all through the project and showed me the right path. His engagement in my

project and his stream of ideas has been absolutely essential for my results presented

here. I am thankful that he has spent so much time with me during my project work.

My honorable thanks to Mr.Rohan BSES for providing excellent Guidance.

I thank BSES for providing me with necessary infrastructure and technical support that

was required for this project.

Special thanks to all GIS Dept. for their valuable suggestions and moral support.

Finally I express my gratitude to my parents and friends for their love and affection,

without which this work would not have been possible.

SATISH HARESH PADNANI

B.Tech 3rd year

Department of CSE

Krishna Engineering College

Email: satishpadnani2015@gmail.com

Ph: +91-9650039601

DECLARATION

I SATISH HARESH PADNANI hereby declare that this Dissertation entitled

“Resolt – Result and Profile Management Website” submitted by me under the

guidance and supervision of Mr. Samir Banger, Dy. General Manager, BSES is a

bonafide work. I also declare that it has not been submitted previously in part or in full to

this University or other University or Institution for the award of any degree or diploma.

Date:15/07/2016 SATISH HARESH PADNANI

6

Abstract

The Degree Thesis in Computer Science focuses on development of Web Development to

be used on a handheld device running the Any Operating system(OS). It covers the basics

such as setting up a development environment, downloading appropriate tools and add-

ons. The thesis serves as a guideline to intermediate developers, seeking solutions to

problems not discussed in available textbooks.

The development for an Website and its data traffic characteristics is of interest, which is

also included in this thesis.

Connectivity and communication like connecting to Server and pulling data from

connected data web server, is discussed.

The main purpose of this project is to manage the Job Profiles and give a platform to

users demand on College level. This web-app helps college student and staff to check

query and information related to college Students using this Web-App using this app

every student will get a platform to store and maintain their college profile, marks and

College Event Wall. Student can also view, comment and check easily on way. Using this

web-app gives a better platform for Job Profiles.

7

TABLE OF CONTENTS NO. TITLE

1. CERTIFICATE2. ACKNOWLEDGMENT3. DECLARATION4. ABSTRACT5. CHAPTER 1: INTRODUCTION6. CHAPTER 2: PROBLEM DEFINITION7. 2.1 EXISTING APPLICATION8. 2.2 PROPOSED APPLICATION9. 2.3 FEATURES OF PROPOSED APPLICATION10. CHAPTER 3: APPLICATION REQUIREMENTS11. CHAPTER 4:PRIOR KNOWLEDGE12. 4.1 WHAT IS VISUAL STUDIO13. 4.2 WHY VISUAL STUDIO14. 4.3 FEATURES OF VISUAL STUDIO15. CHAPTER 5:DESIGN16. 5.1 LOGIN PAGE17. 5.2 INSERTING DETAILS18. 5.3 PROFILE PAGE19. 5.4 WALL POST WITHOUT LOGIN20. 5.5 WALL POST AFTER LOGIN21 5.6 RANKS WITHOUT LOGIN22. 5.7 RANKS AFTER LOGIN23.24.

5.8 ALL USERS PROFILE 5.9 REGISTER USERCHAPTER 6:IMPLEMENTATION

25. 6.1 PREREQUISITE26. 6.2 IMPLEMENTATION ISSUE27. CHAPTER 7:CODING28. 7.1 LOGIN ERRORS – VALIDATION29. 7.2 RANKS ERROR MESSAGES30. CHAPTER 8:TESTING AND RESULTS31. CHAPTER 9:CONCLUSION32. CHAPTER10:REFERENCES33.

8

CHAPTER 1

INTRODUCTION

College Result management website is an application that enables user to interact with

college recent activities that helps in managing the ranking and extra user details that can

help in getting job this can works as College Level LinkedIn where students can also

keep track on their stored results .This application is helpful for the department of the

colleges which maintains results of students by branch.

C# is a Excellent and Highly Integrated Language. Its creates programming more easy by

providing so many inbuilt tags of libraries as well as a distributed network. More over

web applications developed in c# can be extended to System Based applications. Thus c#

was chosen as background to design this application.

College WebApp refers to the process by which individuals apply to gain entry into a

college or university. Although specific details vary by country and institution,

applications generally require basic background information of the applicant, such as

family background, and academic or qualifying exam details such as grade point average

in secondary school and standardized testing scores. But we maintain the exit of student

from college by providing a valuable profile for job interviews.

The process of constructing such kind of systems is not so simple. It involves a mutual

development of application program and database. The application program is actually

the bridge between the users and the database, where the data is stored. Thus, the well-

developed application program and database are very important for the reliability,

flexibility and functionality of the system. The so defined systems differentiate to each

other and their development comprises a great variety of tasks to be resolved and

implemented.

9

CHAPTER 2

PROBLEM DEFINITION

The problem definition for designing the application for the college purpose so that

everyone of that college will be able to use it. It is used for taking information about

college students, knowing latest news in college in the wall post; student can see their

results and rankings from this web-app. Another advantage of this web-app is that student

informs other college students about any complaint and gives their valuable suggestions.

Student have to uploads their resume and submit it to many places like for internship,

training & jobs etc. To eliminate or reduce as much as possible the hardships of existing

application and avoid high scale while entering data. No formal knowledge is needed for

user to use the application. Whole system is completely protected.

10

2.1 EXISTING APPLICATION

The website which existed earlier is now getting high scaled and I want this to be on

college level.

As the time progressed, the technology has developed and there was a need to bring

new application for handling College student profiles for Job Recruitments.

New servers were procured and the same code could not be migrated because of its

incompatibility of the existing code with the virtualized environment.

2.2 PROPOSED APPLICATION

The proposed application is a Web application which is used to maintain the records of

college students profile into database. The student and faculty can log in to the system

with a valid password, The specific user can manipulate or see the database depending

upon his/her authorization.

2.3 FEATURE OF PROPOSED APPLICATION

The user can login with the valid username and password. This is very effective, fast and

cost effective method for recording the data of the college to manage the results and

profiles for job.

11

CHAPTER 3

APPLICATION REQUIREMENT

The following are the system requirements for college web application.

Hardware RequirementsAny Device that has internet and a browser.

Software Requirements

Microsoft Visual Studio

Oracle 10g

Toad

12

CHAPTER 4

PRIOR KNOWLEDGE

4.1 What is Visual Studio?

Visual Studio is a complete set of development tools for building ASP.NET Web applications, XML Web Services, desktop applications, and mobile applications. Visual Basic, Visual C#, and Visual C++ all use the same integrated development environment (IDE), which enables tool sharing and eases the creation of mixed-language solutions. In addition, these languages use the functionality of the .NET Framework, which provides access to key technologies that simplify the

development of ASP Web applications and XML Web Services.

4.2 Why Visual Studio ?

Visual Studio Code provides developers with a new choice of developer tool that combines the simplicity and streamlined experience of a code editor with the best of what developers need for their core code-build-debug cycle. Visual Studio Code is the first code editor, and first cross-platform development tool - supporting OS X, Linux, and Windows - in the Visual Studio family.

13

CHAPTER 5

DESIGN

5.1 LOGIN PAGE

A Login Page is a Door to Resolt that controls the Entry of the user by checking and

validating details from the database details and if that goes correct then you are logged

in.

Login Page includes of the two inputs and a button, One for RollNo. input and one for

password.

Fig 1.1: Basic view of Login

The basic Form used to having header to move into pages but to enjoy services of this website you must login first.

14

5.2 INSERTING DETAILS

Fig. Screen shot of Login Screen Inserting Details

Login screen shows door of the website. It provides good Validation of the Website.

It contains CSS Styling to manage the frames and position of every text.

Here this Rollno and Password is first register through Register Page.

15

5.3 PROFILE PAGE

Here at the Profile Page it shows all the details of User that is already registered it Is the

profile page of the user shows every details including profile picture and Link to

download the Resume.

16

5.4 WALL POST WITHOUT LOGIN

Fig: Wall Post without Login

17

Above is the student Wall Post Section in the fig, from which student can check all the

details Comments recently posted.

In student wall section, student can check for the comments, any current

announcement but cannot comment until student is logged in only registered can

comment.

Comment will show timing and along with the user profile picture when it is posted

and by whom it is posted.

You Need To Be Login to access the other features.

18

5.5 WALL POST AFTER LOGIN

Fig: Wall Post After Login

19

Above is the Wall Posts of the students after login. They can comment whenever they

want and they will also be able to get more options like Friends and other users.

This is all designed by using CSS.

It is designed in such a way it fetches data from database in ascending order of time.

This also includes the current time using Datetime function this all uses .net and c#.

20

5.6 RANKS WITHOUT LOGIN

You can only check for specific results when you are logged in.

When logged out user can not check for his/her specific result he needs to login or

register first.

Student can check for result or rankings of specific department and semester.

If results are not available in the database it will give an error message.

21

5.7 RANKS AFTER LOGIN

Fig: Ranking After Login

After Login User can view his specific ranks of each semester separately irrespective

of department and when roll no label is there he or she can only view the Personal

result.

As we show the department the rollno label will hide as student can have only single

department.

It is a best way to manage the results and check rankings at college level when results

database is attached with college result database the algorithm helps to set ranks for

toppers.

22

Hide Department – Here this shows the results by branch and semester by clicking on

show department link button on previous page it disables the rollno label that lets you

allow to check rankings from every branch and semester.

23

5.8 ALL USERS PROFILE

Fig: All Users Profile

This activity shows checking all the registered students from the college of the

Branch and Specific semester.

This shows that about all users whose data is successfully saved in the database.

24

5.9 REGISTER USERS

Above image shows the register form for this website.

This register form includes many textboxes that means all the details including

password .

Most Importantly there is a button to upload resume and image of specific extension .

25

CHAPTER 6

IMPLEMENTATION

This section deals with the implementation details of the application designed in the

previous section. Implementation is the process of converting design to code. The entities

identified from design are to be implemented considering the association between them

and how they communicate with each other.

6.1 Prerequisite

The interface for this application has been designed using Microsoft Visual Studio and

Oracle 10g has been used as data storage.

6.2 Implementation Issue This section deals with the discussion of the implementation issues that are found in the

application. All aspects of the system are not discussed in this section. Only important

aspects of the system are discussed.

The implementation issue has to be discussed mainly on the following aspects:

1. Storage issues.

26

CHAPTER 7

CODING

Basic Rank Grid View coding:-

<asp:GridView ID="ranks_grid" runat="server" AutoGenerateColumns="false" AllowPaging="false" Width="100%" > <RowStyle BackColor="White" ForeColor="Black" /> <HeaderStyle BackColor="#D61919" ForeColor="White" /> <Columns> <asp:TemplateField HeaderText="RollNo." HeaderStyle-CssClass="grid" ItemStyle-CssClass="grid"> <ItemTemplate> <%#Eval("rollno") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Result" HeaderStyle-CssClass="grid" ItemStyle-CssClass="grid"> <ItemTemplate> <%#Eval("Result") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Branch" HeaderStyle-CssClass="grid" ItemStyle-CssClass="grid"> <ItemTemplate> <%#Eval("Branch") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Year" HeaderStyle-CssClass="grid" ItemStyle-CssClass="grid"> <ItemTemplate> <%#Eval("yearr") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Semester" HeaderStyle-CssClass="grid" ItemStyle-CssClass="grid"> <ItemTemplate> <%#Eval("semester") %> </ItemTemplate> </asp:TemplateField> </Columns>

</asp:GridView>

27

Login Form Coding:-

<form runat="server"> <asp:TextBox type="text" ID="txtRoll" Name="Roll No"

placeholder="University RollNo." runat="server" Width="223px" ></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" ErrorMessage="Required" ForeColor="Red" ControlToValidate="txtRoll" runat="server" /><br /> <asp:TextBox type="password" ID="txtPassword" Name="Password" placeholder="Password" runat="server" Width="206px" ></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" ErrorMessage="Required" ForeColor="Red" ControlToValidate="txtPassword" runat="server" /> <br /> <div id="message" style="color:darkorange;"> <asp:Literal ID="Error" runat="server" ></asp:Literal></div> <br /><asp:Button ID="Button3" Text="Submit" runat="server" OnClick="RegisterCheck" />

</form>

Login C# Coding:- con.Open(); str = "Select * from Users where username='"+UserName+"' and password='"+Password+"'"; str2 = "Select * from Users where username='"+UserName+"'"; //OleDbCommand com = new OleDbCommand(str,con); OleDbDataAdapter adp = new OleDbDataAdapter(str,con); con.Close(); adp.Fill(dt);

OleDbDataAdapter adp2 = new OleDbDataAdapter(str2, con); con.Close(); adp2.Fill(dt2);

if (dt != null && dt.Rows.Count > 0) { Session["txtRoll"] = UserName.ToString(); Session["txtPassword"] = Password.ToString();

Response.Redirect("Profile.aspx"); } else { if (dt2 != null && dt2.Rows.Count > 0) { Error.Text = "<font style='text-color: orange;'>Invalid User Name or Password! Please try again!</font>"; } else

28

{ Error.Text = "Username Not Registered Please Register!";}Register Form Coding:- <div class="register">

<center><form id="Form1" runat="server"> <table > <tr><td> <asp:Literal ID="Error" runat="server"></asp:Literal> </td></tr> <tr>

<td> <asp:TextBox type="text" ID="txtRoll" Name="RollNo" placeholder="University RollNo." runat="server" ></asp:TextBox> </td> <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" ErrorMessage="Required" ForeColor="Red" ControlToValidate="txtRoll" runat="server" /></td> </tr> <tr><td><asp:TextBox type="password" ID="txtPassword" Name="Password" placeholder="Password" runat="server" ></asp:TextBox> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" ErrorMessage="Required" ForeColor="Red" ControlToValidate="txtPassword" runat="server" /></td> </tr> <tr> <td> <asp:TextBox type="password" ID="txtConfirmPassword" Name="Password" class="lessgap" placeholder="Confirm Password" runat="server" Width="243px" /> </td> <td> <asp:CompareValidator ID="CompareValidator2" ErrorMessage="Passwords do not match." ForeColor="Red" ControlToCompare="txtPassword" ControlToValidate="txtConfirmPassword" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ErrorMessage="Required" ForeColor="Red" ControlToValidate="txtConfirmPassword" runat="server" /></td> </tr> <tr><td> <asp:TextBox type="text" ID="txtEmail" Name="Email" placeholder="Email" runat="server" Width="249px" ></asp:TextBox> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" ErrorMessage="Required" Display="Dynamic" ForeColor="Red" ControlToValidate="txtEmail" runat="server" /></td> <td> <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" Display="Dynamic" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ControlToValidate="txtEmail" ForeColor="Red" ErrorMessage="Invalid email address." />

</td></tr> <tr><td> <asp:TextBox type="text" ID="ye" Name="Ye" placeholder="Current Year" runat="server" ></asp:TextBox> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator8" ErrorMessage="Required" ForeColor="Red" ControlToValidate="ye"

29

runat="server" /></td> </tr> <tr><td><asp:TextBox type="text" ID="Br" Name="Br" placeholder="Branch" runat="server" ></asp:TextBox> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator9" ErrorMessage="Required" ForeColor="Red" ControlToValidate="Br" runat="server" /></td> </tr> <tr><td><asp:TextBox type="text" ID="Sem" Name="Sem" placeholder="Current Semester" runat="server" ></asp:TextBox> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator10" ErrorMessage="Required" ForeColor="Red" ControlToValidate="Sem" runat="server" /></td> </tr> <tr><td> <asp:RadioButtonList ItemType="radio" ID=RadioButtonList1 runat="server"> <asp:ListItem>Male</asp:ListItem> <asp:ListItem>Female</asp:ListItem> </asp:RadioButtonList></td><td> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" ErrorMessage="Required" Display="Dynamic" ForeColor="Red" ControlToValidate="RadioButtonList1" runat="server" /> <br /></td> </tr> <tr> <td> <asp:FileUpload ID="Resume" runat="server" BackColor="WindowFrame" Font-Bold="true" ></asp:FileUpload> </td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ErrorMessage="Required" Display="Dynamic" ForeColor="Red" ControlToValidate="Resume" runat="server" /> </td> <td><asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" ControlToValidate="Resume" ErrorMessage="Invalid extension" ForeColor="Red" ValidationExpression="([a-zA-Z0-9\s_\\.\-:])+(.doc|.pdf|.DOC|.PDF)$"></asp:RegularExpressionValidator><br /></td> </tr> <tr> <td> <asp:FileUpload ID="Profilepic" runat="server" placeholder="Upload Picture" BackColor="WindowFrame" Font-Bold="true" ></asp:FileUpload></td> <td> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" ErrorMessage="Required" Display="Dynamic" ForeColor="Red" ControlToValidate="Profilepic" runat="server" /> </td> <td><asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="Profilepic" ErrorMessage="Invalid extension" ForeColor="Red" ValidationExpression="([a-zA-Z0-9\s_\\.\-:])+(.jpg|.jpeg|.gif|.png|.JPG|.JPEG|.GIF|.PNG)$"></asp:RegularExpressionValidator><br /></td> </tr>

30

<tr> <td><asp:Button ID="Button3" Text="Register" runat="server" OnClick="RegisterUser" /> </td> </tr> </table> </form> </center> </div>

CHAPTER 8

TESTING AND RESULTS

The Application developed has to be tested to check whether it conforms to the

specification. The testing is done to guarantee that the application is functioning as

defined in the requirements specification and is free of known errors and bugs. Using test

data and examining the outputs of the system helps to track errors that may present in the

system. This is done at various stages of development to ensure that each stage is free of

errors

The different testing strategies used are:

1. Unit testing

Different units of the application are tested separately. Certain set of inputs are

given to the different modules of the application, and output from each module is

verified.

2. System testing Entire application is tested as a whole unit. Selected set of inputs are given to the

application .Some feedback forms are filled by entering in to the application in user

login, then the feedbacks are verified, by analyzing them, by login in to system as

administrator .

3. Black box testing

31

Various inputs are given and the outputs are verified. Here the functionality of the

application is verified, by giving certain feedback as input, and verifying the

retrieved feedback, which is the output. The functionality of the application is tested

without referring to the source code of the system.

4. White box testing

Different sections of the code is analyzed and tested, that it will work correctly,

without any errors and bugs

Results:

The results are verified by observing the input and output. Following are the screen shots

of the College Website Application.

32

Screenshots:

Here are some screenshots of the project for better understanding Screen shot

of Invalid Userid or Password Message

33

Screen Shot of Invalid User

Screen shot of unfilled Register form

.

34

Screenshot of Unfilled Register Form

35

36

Screen Shot of Invalid Department and Semester

37

CHAPTER-9

CONCLUSION

An Application interface for providing a better platform for students of colleges and

universities, which recorders data of employees makes easy. An Application interface for

recording the records is developed. A System interface for giving information of an student is

developed. Each user of the system is authenticated using password.

For accessing information of the college student, an application is introduced so that they can

get excellent platform specific for college users in maintaining results and their Job

profiles .It takes lesser time than that of website.

Future Works

Enhance the existing application, by storing student results in to a database using

live web service, so that the statistics about the information obtained can be easily

analyzed. As a future work, some additional stuff could be implemented and

integrated into the application code making it much more reliable and flexible;

especially what concerns a pay-roll module, for instance.

Apparently, the role of such application is basic and essential within each college that

wants to keep a really good control and record concerning its personnel data,

functionality and performance on all levels in its structure. Every organization, in

nowadays, has the necessity of managing its student records for placement on a really

good level as the student has definitely the greatest merit of building up a profiles as

such as it is.

The well managed student profile means giving the appropriate financial award-

ness and all kind of benefits as such as they have been deserved. That’s why the

development of such application is not just a programming business – a lot of people

are ordinarily involved in such projects and one of the basic requirements is the

reliability of the application, especially what concerns the storage of data and all of

the operations that will be performed upon it.

38

CHAPTER-10

REFERENCES

http://www.google.com

http://www.codeproject.com

http://www.asp.net

http://www.aspsnippets.com

xxxix