Mithuninmca.weebly.com
Jobs Site Starter Kit (JSSK)IntroductionJobs Site Starter Kit is a web application that provides a platform for candidates seeking job and the employers to share their needs.The candidates seeking job (referred as job seekers now onwards) can perform following operations:Register with the web site.Post their resume.Modify their resume.Search for job postings.Browse searched job postings.Add job posting to their favorites list.Add frequently used searches to their favorites list.The employers can perform following operations:Register with the web site.?Enter profile of their company.?Post one or more job postings.?Modify the job postings.?Search the resume database.?Browse searched resumes.?Add resumes to their favorites list. 3.5 Feature utilization in JSSKJSSK is developed using 3.5 and uses following features:Completely based on n-tier architecture?Forms based authentication?User management via Membership providers?Role based security?Profiles?Themes?Master pages?New data source controls - ObjectDataSource?Data bound controls – GridView and DetailsViewLogin controls – Login, PasswordRecovery, LoginName and LoginStatus?Web parts for customization?User controls for reusing code and AJAX client script extensionsCalling web services via AJAXUpdatePanel and UpdateProgress controlsAJAX Control ToolkitThe Microsoft .Net FrameworkThe .NET Framework is the infrastructure for the Microsoft .NET platform.?The .NET Framework is an environment for building, deploying, and running Web applications and Web Services.Microsoft's first server technology ASP (Active Server Pages), was a powerful and flexible "programming language". But it was too code oriented. It was not an application framework and not an enterprise development tool.The Microsoft .NET Framework was developed to solve this problem..NET Frameworks keywords:Easier and quicker programmingReduced amount of codeDeclarative programming modelRicher server control hierarchy with eventsLarger class libraryBetter support for development toolsThe .NET Framework consists of 3 main parts:Programming languages:C# (Pronounced C sharp)Visual Basic (VB .NET)J# (Pronounced J sharp)Server technologies and client technologies:ASP .NET (Active Server Pages)Windows Forms (Windows desktop solutions)Compact Framework (PDA / Mobile solutions)Development environments:Visual Studio .NET (VS .NET)Visual Web DeveloperPROJECTCATEGORYRDBMS (Relational Database Management System):A Relational data model was invented by E.F. Code and is based on one simple concept i.e. Table. A RDBMS is a computer program for managing table. It has three major parts :Data that is presented as tables.Operators for manipulating tables.Integrity rules on tables.What Is SQL Server?SQL Server is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications that you and your people can use to take your business to the next level.The SQL Server data engine lies at the core of this enterprise data management solution. Additionally, SQL Server combines the best in analysis, reporting, integration, and notification. This enables your team to build and deploy cost-effective BI solutions with which they can drive data into every corner of your business through scorecards, dashboards, Windows services, and mobile devices.Close integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server provides innovative solutions that help you gain more value from your data.SQL Server Core Components Microsoft has listened to your feedback, researched the industry, challenged Microsoft Research teams around the world, and thought creatively to deliver SQL Server , which introduces hundreds of new and improved features. These features will help to advance your business in three key areas:?Enterprise Data Management. SQL Server delivers a more reliable, secure, and productive data platform for line-of-business and analytical applications. This version of SQL Server is the largest version of SQL Server ever, as well as the most dependable and secure version.?Developer Productivity. SQL Server provides an end-to-end development environment that includes many new technologies that empower developers and significantly increase their productivity.?Business Intelligence. The comprehensive analytical, integration, and data migration capabilities of SQL Server enable companies to extend the value of their existing applications, regardless of the underlying platform. BI solutions built on SQL Server put critical, timely information in the hands of all your people, empowering them to make better decisions faster.SQL Server Features at a GlanceThe following table provides an overview of several key enhancements in SQL Server , focusing on enterprise data management, developer productivity, and business intelligence. A wider range of compared features is available at the SQL Server Developer Center at MSDN.Enterprise Data ManagementTechnologyCapabilitiesHigh AvailabilityFailover clustering and database mirroring technology in SQL Server will enable enterprises to deliver highly reliable, available applications to employees, customers, and partners.Management ToolsSQL Server introduces an integrated suite of management tools and management application programming interfaces (APIs) to provide ease of use, manageability, and support for operating large-scale SQL Server deployments.Security EnhancementsSQL Server has been designed to help provide the highest level of security for enterprise data through features such as database encryption, more secure default settings, password policy enforcement, granular permissions control, and an enhanced security model.ScalabilityScalability advancements in SQL Server include table partitioning, replication enhancements, and 64-bit support.Developer ProductivityTechnologyCapabilitiesCommon Language Runtime (CLR) IntegrationSQL Server introduces the capability to develop database objects using any Microsoft .NET language.Deep XML IntegrationSQL Server delivers a new XML data type, enabling the storage of XML fragments or documents in SQL Server databases.Transact-SQL EnhancementsNew query types and the capability to use error handling in transactions provide developers with more flexibility and control in SQL Server query development.SQL Service BrokerSQL Service Broker provides an innovative distributed asynchronous application framework for new levels of scalability.Business IntelligenceTechnologyCapabilitiesAnalysis ServicesAnalysis Services delivers extensions to the scalability, manageability, reliability, availability, and programmability of data warehousing, business intelligence, and line-of-business solutions.Data Transformation Services (DTS)A complete redesign of the DTS architecture and tools provides developers and database administrators with increased flexibility and manageability.Reporting ServicesReporting Services is a new report server and tool set for building, managing, and deploying enterprise reports.Data MiningData mining is enhanced with four new algorithms as well as improved data modeling and manipulation tools.SQL Server OverviewPublished: November 7, organization today faces numerous data challenges. You need your people to make faster and more data-driven decisions, your developers to be more productive and flexible, and your managers to reduce their overall information technology (IT) budgets even as they scale your infrastructure to meet ever-increasing demands.SQL Server is designed to help enterprises address these challenges. This next-generation data management and analysis solution delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.Extending the strengths of SQL Server 2000, SQL Server provides an integrated data management and analysis solution that can help your staff do the following:?Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable.?Maximize IT productivity by reducing the complexity of developing and supporting database applications.?Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.?Control costs without sacrificing performance, availability, scalability, or security.SQL Server advances your data infrastructure in three key areas: it makes your enterprise data more manageable, your developers more productive, and your business intelligence (BI) more comprehensive. It also breaks new ground in affordable pricing and licensing, upgrade paths to SQL Server , and the Microsoft Windows Server System.On This PageSQL Server Data PlatformSQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications. SQL Server delivers powerful, familiar tools to IT professionals as well as to information workers, reducing the complexity of creating, deploying, managing, and using enterprise data and analytical applications on platforms ranging from mobile devices to enterprise data systems. Through a comprehensive feature set, interoperability with existing systems, and automation of routine tasks, SQL Server provides a complete data solution for enterprises of all sizes. Figure 1 shows the layout of the SQL Server data platform.?Relational Database. A more secure, reliable, scalable, highly available relational database engine with improved performance and support for structured and unstructured (XML) data.?Replication Services. Data replication for distributed or mobile data processing applications, high systems availability, scalable concurrency with secondary data stores for enterprise reporting solutions, and integration with heterogeneous systems, including existing Oracle databases.?Services. Advanced notification capabilities for the development and deployment of scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices.?Services. Data extraction, transformation, and loading (ETL) capabilities for data warehousing and enterprise-wide data integration.?Services. Online analytical processing (OLAP) capabilities for the rapid and sophisticated analysis of large and complex datasets using multidimensional storage.?Services. A comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Windows-based reports.?Management Tools. SQL Server includes integrated management tools for advanced database management and tuning as well as tight integration with tools such as Microsoft Operations Manager (MOM) and Microsoft Systems Management Server (SMS). Standard data access protocols drastically reduce the time it takes to integrate data in SQL Server with existing systems. In addition, native Windows service support is built into SQL Server to ensure interoperability with other applications and platforms.?Development Tools. SQL Server offers integrated development tools for the database engine, data extraction, transformation, and loading, data mining, OLAP, and reporting that are tightly integrated with Microsoft Visual Studio to provide end-to-end application development capabilities. Every major subsystem in SQL Server ships with its own object model and set of application program interfaces (APIs) to extend the data system in any direction that is unique to your business.The SQL Server data platform provides organizations of all sizes with the following benefits:?Capitalize on Data Assets. In addition to delivering a secure, reliable database for line-of-business and analytical applications, SQL Server enables your people to get more value from their data by including embedded functionality such as reporting, analysis, and data mining. You can take advantage of this power and flexibility to deliver data to every corner of your organization at a fraction of the cost of some other systems.?Increase Productivity. Through comprehensive BI capabilities and integration with familiar tools such as Microsoft Office System, SQL Server delivers timely business information to those who need it and tailors it to their specific needs. The goal is to extend BI to your entire staff and ultimately to help everyone, at all levels of the organization, make better business decisions based on one of their most valuable assets—their data.?Reduce IT Complexity. SQL Server simplifies the development, deployment, and management of line-of-business and analytical applications by providing a flexible development environment for developers and integrated, automated management tools for database administrators.?Lower Total Cost of Ownership (TCO). The integrated approach and focus on ease of use and deployment in SQL Server provides the industry's lowest upfront, implementation, and maintenance costs for rapid return on your database investment.SQL Server provides the technology and capabilities that your people can count on. With significant advancements in the key areas of enterprise data management, developer productivity, and BI, the benefits of upgrading or migrating to SQL Server are substantial.SQL Server has the potential to take your business to the next level—we encourage you to try it for yourself.What Is ??is a?web application framework?developed and marketed by?Microsoft?to allow?programmers?to build dynamic?web sites,?web applications?and?web services. It was first released in January 2002 with version 1.0 of the?.NET Framework, and is the successor to Microsoft's?Active Server Pages?(ASP) technology. is built on the?Common Language Runtime?(CLR), allowing programmers to write code using any supported?.NET language. The ?SOAP?extension framework allows components to process SOAP messages. compared with ASP simplifies developers' transition from?Windows?application development to web development by offering the ability to build pages composed of?controls?similar to a Windows?user interface. A web control, such as a?button?or?label, functions in very much the same way as its Windows counterpart: code can assign its properties and respond to its events. Controls know how to render themselves: whereas Windows controls draw themselves to the screen, web controls produce segments of?HTML?and?JavaScript?which form parts of the resulting page sent to the end-user's browser. encourages the programmer to develop applications using an?event-driven?GUI?model, rather than in conventional web-scripting?environments like ASP and?PHP. The framework combines existing technologies such as JavaScript with internal components like " HYPERLINK "" \o "ViewState" ViewState" to bring persistent (inter-request) state to the inherently?stateless?web environment.Other differences compared to?ASP classic?are:Compiled code means applications run faster with more design-time errors trapped at the development stage.Significantly improved run-time error handling, making use of?exception handling?using try-catch blocks.Similar metaphors to Microsoft Windows applications such as controls and events.An extensive set of controls and class libraries allows the rapid building of applications, plus user-defined controls allow commonly-used?web template, such as menus. Layout of these controls on a page is easier because most of it can be done visually in most editors. uses the multi-language abilities of the .NET?Common Language Runtime, allowing web pages to be coded in , C#, J#, , Chrome, etc.Ability to cache the whole page or just parts of it to improve performance.Ability to use the?code-behind?development model to separate business logic from presentation.Ability to use true?object-oriented?design for programming pages and controlsIf an application?leaks memory, the runtime unloads the AppDomain hosting the erring application and reloads the application in a new AppDomain.Session state?in can be saved in a?Microsoft SQL Server?database or in a separate process running on the same machine as the web server or on a different machine. That way session values are not lost when the web server is reset or the worker process is recycled.Versions of prior to 2.0 were criticized for their lack of standards compliance. The generated HTML and JavaScript sent to the client browser would not always validate against?W3C/ECMA standards. In addition, the framework's browser detection feature sometimes incorrectly identified web browsers other than Microsoft's own?Internet Explorer?as "downlevel" and returned HTML/JavaScript to these clients with some of the features removed, or sometimes crippled or broken. However, in version 2.0, all controls generate valid HTML 4.0, XHTML 1.0 (the default) or XHTML 1.1 output, depending on the site configuration. Detection of standards-compliant web browsers is more robust and support for?Cascading Style Sheets?is more extensive.Web Server Controls: these are controls introduced by for providing the UI for the web form. These controls are state managed controls and are?WYSIWYG?ANIZATION IN CLIENT-SERVER ARCHITECTUREData base is stored hereData base can be access from any node .NET AdvantagesMultiple LanguagesAnother benefit of .NET is the facility to program in multiple languages, which allows programmers to use their favorite languages. That is, different modules of an application can be coded in any of the DOT NET-compliant languages and can be integrated as a single application. Even classes defined in one language can be used in another language. Any language that can be compiled into Microsoft Intermediate Language (MSIL) is considered a .NET-compliant language.Following are a few of the popular .NET-compliant languages supported by CLR: APL , COBOL , Python , Component Pascal , Eiffel , Visual Basic , Fortran , JScript , Visual C++ , Mercury , Oberon , Smalltalk , Pascal , Perl , Visual C# Developed for the Internet AgeThe .NET platform has been designed particularly for the Internet age. and windows services enable programmers to build scalable applications for the future with less coding and better performance. Standard ToolsetMicrosoft Visual Studio .NET provides a unified, shared IDE for all DOT NET-compliant languages. Other companies can also plug their languages into the IDE and get all the support of the .NET tools. For example, Fujitsu has created NetCOBOL for DOT NET, which integrates directly into the IDE so you can write windows services and Windows applications in COBOL and receive the debugging and profiling tools provided by Microsoft. Automatic Memory provides a solution to the memory management problems faced by today's programmers, employing automatic garbage collection (which manages the allocation and release of memory for the application). This automatic memory management removes two common application errors: memory leaks and invalid memory references. Memory management is also a security feature, as it makes it harder for code in a process to misbehave.Versioning and Type Safety?.NET supports side-by-side execution, which enables installing and executing multiple versions of an application or component on the same computer; for example, you can run version 1 of your component together with version 2. The application that you wrote with version 1 doesn't deteriorate even when you improve your component to version 2. .NET is also strongly typed. The DOT NET Framework itself supports running multiple versions side by side.Security?The CLR and the .NET Framework afford handy classes and services that permit developers to develop secure applications. For example, the System.Security namespace provides the underlying structure of the CLR security system, including base classes for permissions. An important feature is the ability to run code with reduced permissions, depending on the source of the code (downloaded from URL or run from the file system) or the evidence it presents to the system (hash/certificate).Unified Programming ModelThe Microsoft .NET Compact Framework brings the CLR, Windows Forms controls, and other DOT NET Framework features to small devices such as the Pocket PC 2000, Pocket PC 2002, Pocket PC 2002 Phone Edition, and custom-designed embedded devices built with the Windows CE .NET operating system.PROBLEM DEFINITION :By doing each and every work manually, Installation of I-way & Maintenance Management System of Sify Technology Ltd. felt to have a system which can automate its manual work in some different way in spite of an existing system which is less efficient and reliable . By doing the work on exiting system , there were always great chances of errors and dissatisfactions among management also. The manual work is tedious and time consuming. It also get pressurize the employees & management as well regarding their efficiency. Therefore there was always need for a kind of software which can fulfill all the above requirement with accuracy in a minimum amount of time and sorting all relevant problems using less effort.System analysis and designAs a customer makes a call to the reception, the receptionist entertains his/her call and feeds the call details given by the customer. After entering the data the system will check whether the equipment of customer is under warranty period or not and if under warranty period, type of warranty is checked. If the type of warranty is “on-site” then a service record card is printed and is given to the service engineer. If warranty type is “in-workshop” type then the customer is asked to bring the equipment to the service center.When the customer brings the equipment to service center, the reception staff receives the equipment and checks the IRIS conditions of the equipment and other details. Then the customer is provided with a claim card against the receipt of the equipment. The equipment is then sent to workshop. It is corrected there. The service engineer gives the service report to the call reception and management department which feeds the data into the system and final billing and reporting is done.The following process must be taken care of :-SYSTEM DESIGNIn order to transform requirements into a working system, we must satisfy both the customer and the system builders on our development team .The customer understands what the system is to do .At the same time, the system builders must understand how the system will work. For this reason, system is really a two-part process. First, we produce a system specification that tells the customer exactly what the system will do. The specification is sometimes called a conceptual system design. Once the customer approves the conceptual design, we present the system builders with a technical design that allows them to build the actual hardware and software. This two-part design mirrors the two parts of requirement description. The conceptual design concentrates on the function of the system, while the technical design describes the form the system will take.REQUIREMENT SPECIFICATION:Since all the works are done with a less reliable system or manually, that’s why there is more time requires for little job. Always there is queue of (clients) waiting for their turn. The simple work looks like cumber someone. As a result employees get pressurize and clients get aggressive, because of suffering of a lot of time. This creates a little more dissatisfaction among clients. All either employees or clients want quick service, but this can’t be done manually. Therefore management decides to convert manual/less reliable system into electronic i.e. computerization is required with some advanced features. By computerization any type of query regarding engineer detail/client detail/the type of services provided by Installation of I-way & Maintenance Management System of Sify Technology Ltd., can be done instantly. Clients get information regarding any query of above mentioned services .Simultaneously; information can be viewed in graphical representation such that easy for understanding. Storing and retrieval of information are so fast that many jobs can be done in respectively lesser time. This increases satisfaction level of clients, simultaneously employees feel relax as service is going fast and hence the efficiency of employees relatively increases. Computerization makes information safer. Also, management can generate several reports, which will help him to plan future strategy for company behalf. Using RAD (Rapid Application Development) model can easily develop this system. This is an incremental software development process model that emphasizes an extremely sort development cycle.PROJECT PLANNINGAfter completion of preliminary investigation of the requirements of the client step by step the process of project planning is initiated. Project has complexity as there were several modules and time frame given to develop the project was 4-6 months and has to complete all the steps as well as follow every step of SDLC. The customer’s needs is GUI and have to develop the project in GUI, so the project front end chooses as Java with designing tools and back end as ORACLE. ORACLE is selected as backend because customer s needs data to stored in several forms and have security at several steps. And ORACLE is the best one to be selected as backend to store the data. After selecting the front end as well as backend of the software. And project is developed using the Spirals model as given in SDLC. And all the steps are planned accordingly to the model within given time frame.PROJECT SCHEDULINGProject planning and project scheduling are vice versa to each other because one have to maintain both to complete the customer requirements within the allotted time with everything to up to customer needs. So developed project scheduling is done according to planning as every steps of the SDLC are followed and are completed according to planned and it is described with the help of Gantt chart and Pert chart .And according to the time frame mentioned in Gantt chart and Pert chart is followed very strictly while developing the project and every phase is completed to its limit.PERT CHARTPERT (Project Evaluation and Review Technique) charts consist of a network of boxes and arrows. The boxes represent activities and the arrows represent task dependencies. PERT is organized by events and activities or tasks. PERT have more advantages and they are likely to be used for more complex projects.Through PERT chart the various task paths are defined. PERT enables the calculation of critical path. Each path consists of combination of tasks, which must be completed. The time and the cost associated with each task along a path are calculated, and the path that requires the greatest amount of elapsed time is the critical path. Calculation of the critical path enables project manager to monitor this series of task more closely than others to shift resources to it, if it begins to fall behind schedule.PERT controls time and cost during the project and also facilitate finding the right balance between completing a project on time and completing it within the budget.There are thus not one but many critical paths, depending on the permutations of the estimates for each task. This makes analysis of critical path in PERT charts very complex. The PERT chart representation of Automation of System call management, Samsung Electronic, JSR problem is shown below.09thJuly-19th Feb ju44154444444444444544425th4JJjUla,Ranchi Nov-27th Jan 21st July-28th Feb10th June-27th Jan2nd July-08th FebIntegrate and TestCode Database PartDesign Database PartAnalysis PartAug 4th Sep27th27thMa3rd Jan- o7th Jan May Finish15th Jul – 18th Jul StartReport Generation PartCode Part of IIMMS Design IIMMS PartDocumentation18th Oct-25th Oct11th Oct-13th Oct6th OCt-10th Oct01st OCt-5th OctWorking MethodologyMicrosoft Solutions Framework (MSF) Process Model defines the following working methodology which we implement in our company is as follows:??1. Gathering and Analyzing Information 2. Envisioning the Solution 3. Creating the Conceptual Design 4. Creating the Logical Design 5. Creating the Physical Design 6. Designing the Presentation Layer 7. Designing the Data Layer 8. Designing Security Specifications 9. Completing the Planning Phase 10. Stabilizing and Deploying the Solution TOOLS / PLATEFORM :Front-end Dot Net and Back-end SQL ServerSOFTWARE/HARDWARE REQUIREMENT : This application is being Developed using the following configuration.Hardware requirements:PROCESSORPENTIUM IVRAM1 GBHARD DISK DRIVE80 GBFLOPPY DISK DRIVE3 ? INCHES 1.44 MBCACHE MEMORY512 MBMONITORVGA with 800 X 600 Key board 108 Keys (Standard)mouseOptical Mouse Software require02ents: Operating system Windows 2000 Professional/windows 98 Back-end SQL Server 2008 Front end .Net 2008Cost analysisCost estimation is mainly involved the cost of effort to produce the software project.But its not limited to the effort only. It also includes the hardware and Software cost, training the employees and traveling to the customer, networking and communication costs. Cost estimation needs to be done well before the start of the project development. Failure of the budgeting for the cost of the project results in complete disaster. Hardware Cost HDD - 150 GB RAM - 512 MB CPU - P4 (Or Higher)Monitor - 17” LCDDVD WRITER - KEYBOARD - MultimediaMOUSE - USB OpticalApprox Cost - Rs. 24,000/-Software CostOPERATING SYSTEM - WINDOWS XP-SP2 VB STUDIO AND SQL SERVER-16000/-Approx Cost - Rs. 21000/-Development CostCosts of persons included in the development work - 23,000 Rs.Travel - 42,00 Rs.Approx Cost - 27200 Rs.Total Estimation In the project - 72,200 Rs.DesignWelcome ScreenLogin ScreenRegister PageChange pageAfter Login In Admin PageEducation LevelsExperience LevelsJob Seekers Page For Post ResumeJob Seekers Page For Search JobsJob Seekers Page For My FavoritesEmployers For Post JobsEmployers For Search ResumesEmployers For Company ProfileEmployers My FavoritesMasterPage.master<%@ Master Language="C#" CodeFile="MasterPage.master.cs" Inherits="MasterPage_master" %><%@ Register TagPrefix="uc3" TagName="LatestJobs" Src="UserControls/LatestJobs.ascx" %><%@ Register TagPrefix="uc2" TagName="Statistics" Src="UserControls/Statistics.ascx" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %><%@ Register src="UserControls/AJAXNavigation.ascx" tagname="AJAXNavigation" tagprefix="uc4" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" ""><html xmlns="" ><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <table width="100%" border=0 cellpadding=5 cellspacing=0> <tr> <td colspan=3 class="pagetop"> <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True"></asp:ScriptManager> <table width=100% border=0> <tr> <td><asp:HyperLink ID="HyperLink1" Runat="server" ImageUrl="~/Images/logo.gif" NavigateUrl="~/default.aspx"></asp:HyperLink></td> <td valign="bottom" align="right"> <asp:LoginName ID="LoginName1" Runat="server" SkinID="FormLabel" FormatString="Welcome {0} !" Font-Bold="True" /> [<asp:LoginStatus ID="LoginStatus1" Runat="server" LogoutPageUrl="~/default.aspx" LogoutAction="Redirect" />] </td> </tr> </table> </td> </tr> <tr> <td valign="top" width="20%" class="pageleft" height="600px" align="center"> <br /> <uc4:AJAXNavigation ID="AJAXNavigation1" runat="server" /> </td> <td valign="top" width="60%"> <asp:contentplaceholder id="ContentPlaceHolder1" runat="server"><br /> </asp:contentplaceholder> </td> <td valign="top" width="20%" class="pageright" align="center"> <br /> <uc2:statistics id="Statistics1" runat="server"></uc2:statistics><br /> <uc3:LatestJobs ID="LatestJobs1" Runat="server" /> </td> </tr> <tr> <td colspan=3 class="pagebottom" align="center"> <br /> Copyright (C) your copyright here. (C) your copyright here.<br /> <br /> <asp:HyperLink ID="lnkAds" Runat="server">Want to advertise with us?</asp:HyperLink> | <asp:HyperLink ID="lnkWebmaster" Runat="server">Problems with the site?</asp:HyperLink> <br /> <br /> </td> </tr> </table> </form></body></html>MasterPage.master.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class MasterPage_master : MasterPage{ protected void Page_Load(object sender, EventArgs e) { Page.Title = ConfigurationManager.AppSettings["pagetitle"]; HyperLink1.ImageUrl = "~/images/" + ConfigurationManager.AppSettings["sitelogo"]; lnkAds.NavigateUrl = "mailto:" + ConfigurationManager.AppSettings["advertiseemail"]; lnkWebmaster.NavigateUrl = "mailto:" + ConfigurationManager.AppSettings["webmasteremail"]; }}AdminMasterPage.master<%@ Master Language="C#" AutoEventWireup="true" CodeFile="AdminMasterPage.master.cs" Inherits="AdminMasterPage" %><%@ Register TagPrefix="uc3" TagName="LatestJobs" Src="UserControls/LatestJobs.ascx" %><%@ Register TagPrefix="uc2" TagName="Statistics" Src="UserControls/Statistics.ascx" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %><%@ Register src="UserControls/AJAXNavigation.ascx" tagname="AJAXNavigation" tagprefix="uc4" %><%@ Register src="UserControls/AJAXNavigationAdmin.ascx" tagname="AJAXNavigationAdmin" tagprefix="uc5" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" ""><html xmlns="" ><head id="Head1" runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <table width="100%" border=0 cellpadding=0 cellspacing=0> <tr> <td colspan=3 class="pagetop"> <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True"></asp:ScriptManager> <table width=100% border=0> <tr> <td><asp:HyperLink ID="HyperLink1" Runat="server" ImageUrl="~/Images/logo.gif" NavigateUrl="~/default.aspx"></asp:HyperLink></td> <td valign="bottom" align="right"> <asp:LoginName ID="LoginName1" Runat="server" SkinID="FormLabel" FormatString="Welcome {0} !" />[ <asp:LoginStatus ID="LoginStatus1" Runat="server" LogoutPageUrl="~/default.aspx" LogoutAction="Redirect" /> ] </td> </tr> </table> </td> </tr> <tr> <td valign="top" width="20%" class="pageleft" height="600px" align="center"> <br /> <uc5:AJAXNavigationAdmin ID="AJAXNavigationAdmin1" runat="server" /> </td> <td valign="top" width="60%"> <asp:contentplaceholder id="ContentPlaceHolder1" runat="server"><br /> </asp:contentplaceholder> </td> <td valign="top" width="20%" class="pageright" align="center"> <br /> <uc2:statistics id="Statistics1" runat="server"></uc2:statistics><br /> <uc3:LatestJobs ID="LatestJobs1" Runat="server" /> </td> </tr> <tr> <td colspan=3 class="pagebottom" align="center"> <br /> Copyright (C) your copyright here. (C) your copyright here.<br /> <br /> <asp:HyperLink ID="lnkAds" Runat="server">Want to advertise with us?</asp:HyperLink> | <asp:HyperLink ID="lnkWebmaster" Runat="server">Problems with the site?</asp:HyperLink> <br /> <br /> </td> </tr> </table> </form></body></html>AdminMasterPage.aspx.csusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class AdminMasterPage : System.Web.UI.MasterPage{ protected void Page_Load(object sender, EventArgs e) { Page.Title = ConfigurationManager.AppSettings["pagetitle"]; HyperLink1.ImageUrl = "~/images/" + ConfigurationManager.AppSettings["sitelogo"]; lnkAds.NavigateUrl = "mailto:" + ConfigurationManager.AppSettings["advertiseemail"]; lnkWebmaster.NavigateUrl = "mailto:" + ConfigurationManager.AppSettings["webmasteremail"]; }}Login.aspx<%@ Page Language="C#" CodeFile="login.aspx.cs" Inherits="login_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <script type="text/javascript"> var membership function DoLogin() { membership=new JSSK.Membership(); var uid=$get('Text2').value; var pwd=$get('Password2').value; var rememberme=$get('Checkbox2').checked; membership.set_WaitLabelId("waitmsg"); membership.BeginLogin(uid,pwd,rememberme); } </script><div align=center> <asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server"> <scripts> <asp:scriptreference Path="~/scripts/membership.js" /> <asp:scriptreference Path="~/scripts/progressmessage.js" /> </scripts> </asp:ScriptManagerProxy> <asp:Label ID="Label1" Runat="server" Text="Already Registered? Login Now!" SkinID="FormHeading"></asp:Label> <br /> <br /> <table align="center" cellpadding="3" cellspacing="0" style="width: 60%"> <tr> <td align="right"> <asp:Label ID="Label2" runat="server" Text="User ID :"></asp:Label> </td> <td align="left"> <input id="Text2" type="text" /></td> </tr> <tr> <td align="right"> <asp:Label ID="Label3" runat="server" Text="Password :"></asp:Label> </td> <td align="left"> <input id="Password2" type="password" /></td> </tr> <tr> <td colspan="2"> <input id="Button3" type="button" value="Login" class="dataentryformbutton" onclick="DoLogin()" /></td> </tr> <tr> <td colspan="2"> <input id="Checkbox2" type="checkbox" /><asp:Label ID="Label5" runat="server" Text="Remember Me"></asp:Label> </td> </tr> </table> <br /> <span id="waitmsg"> </span><br /> <asp:HyperLink ID="HyperLink1" Runat="server" NavigateUrl="~/register.aspx">New user? Register here!</asp:HyperLink> <br /> <br /> <asp:PasswordRecovery ID="PasswordRecovery1" Runat="server"> </asp:PasswordRecovery> </div> </asp:Content> Default.aspx<%@ Page Language="C#" CodeFile="default.aspx.cs" Inherits="default_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align=center> <asp:Label ID="Label1" Runat="server" Text="Welcome !!!" SkinID="FormHeading"></asp:Label> <br /> <br /> <p> <asp:Label CssClass="marketingtext" ID="Label2" runat="server" Text="Search for job openings, post resume, search resumes, post job openings and more..."></asp:Label> </p> <p> </p> <p> </p> <p> </p> <p> </p></div> </asp:Content>Default.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class default_aspx : System.Web.UI.Page{ public default_aspx() { Load += new EventHandler(Page_Load); } protected void Page_Load(object sender, EventArgs e) { }}AddEditPosting.aspx<%@ Page Language="C#" CodeFile="AddEditPosting.aspx.cs" Inherits="AddEditPosting_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div style="text-align: center"> <div align="center"> <asp:Label ID="Label14" Runat="server" Text="Add / Edit Job Posting" SkinID="FormHeading"></asp:Label> </div> <br /> <asp:HyperLink ID="HyperLink2" Runat="server" NavigateUrl="~/employer/jobpostings.aspx" ImageUrl="~/Images/JobPostings.gif"></asp:HyperLink><br /> <asp:Label ID="Label6" runat="server" Text="(All the fields are mandatory)"></asp:Label> <br /> <br /><asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><asp:DetailsView ID="DetailsView1" Runat="server" AutoGenerateRows="False" CellPadding="5" DataKeyNames="JobPostingID" DataSourceID="ObjectDataSource1" GridLines="None" HorizontalAlign="Center" OnDataBound="DetailsView1_DataBound" OnItemDeleted="DetailsView1_ItemDeleted" OnItemInserting="DetailsView1_ItemInserting" OnItemUpdating="DetailsView1_ItemUpdating" Width="100%"><rowstyle horizontalalign="Left" /><fieldheaderstyle horizontalalign="Right" Wrap="false" /><fields><asp:boundfield DataField="JobPostingID" HeaderText="Job Posting ID :" InsertVisible="False" ReadOnly="True" SortExpression="JobPostingID"><headerstyle cssclass="dataentryformlabel" wrap="False" /><itemstyle cssclass="dataentryformlabel" wrap="False" /></asp:boundfield><asp:boundfield DataField="Title" HeaderText="Title :" SortExpression="Title"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:templatefield HeaderText="Contact Person :" SortExpression="ContactPerson"><edititemtemplate><asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ContactPerson") %>'> </asp:TextBox></edititemtemplate><insertitemtemplate><asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ContactPerson") %>'> </asp:TextBox></insertitemtemplate><itemtemplate><asp:Label ID="Label6" Runat="server" Text='<%# Bind("ContactPerson") %>'></asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" wrap="False" /><itemstyle wrap="False" /></asp:templatefield><asp:boundfield DataField="Department" HeaderText="Department :" SortExpression="Department"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:boundfield DataField="JobCode" HeaderText="Job Code :" SortExpression="JobCode"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:templatefield HeaderText="Country :" SortExpression="CountryID"><edititemtemplate> <asp:DropDownList ID="ddlCountryUpdate" Runat="server" AutoPostBack="True" DataSourceID="ObjectDataSource3" DataTextField="CountryName" DataValueField="CountryID" OnSelectedIndexChanged="ddlCountryUpdate_SelectedIndexChanged" SelectedValue='<%# Bind("CountryID") %>'></asp:DropDownList></edititemtemplate><insertitemtemplate> <asp:DropDownList ID="ddlCountryInsert" Runat="server" AutoPostBack="True" DataSourceID="ObjectDataSource3" DataTextField="CountryName" DataValueField="CountryID" OnSelectedIndexChanged="ddlCountryInsert_SelectedIndexChanged" SelectedValue='<%# Bind("CountryID") %>'></asp:DropDownList></insertitemtemplate><itemtemplate><asp:Label ID="Label2" Runat="server" Text='<%# JobSiteStarterKit.BOL.Country.GetCountryName((int)Eval("CountryID")) %>'> </asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" /></asp:templatefield><asp:templatefield HeaderText="State :" SortExpression="StateID"><edititemtemplate><asp:DropDownList ID="ddlStateUpdate" Runat="server" DataSourceID="ObjectDataSource2" DataTextField="StateName" DataValueField="StateID"></asp:DropDownList></edititemtemplate><insertitemtemplate><asp:DropDownList ID="ddlStateInsert" Runat="server" DataSourceID="ObjectDataSource2" DataTextField="StateName" DataValueField="StateID"></asp:DropDownList></insertitemtemplate><itemtemplate><asp:Label ID="Label1" Runat="server" Text='<%# JobSiteStarterKit.BOL.State.GetStateName((int)Eval("StateID")) %>'> </asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" /></asp:templatefield><asp:boundfield DataField="City" HeaderText="City :" SortExpression="City"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:templatefield HeaderText="Education Level :" SortExpression="EducationLevelID"><edititemtemplate> <asp:DropDownList ID="ddlEduLevelUpdate" Runat="server" DataSourceID="ObjectDataSource4" DataTextField="EducationLevelName" DataValueField="EducationLevelID" SelectedValue='<%# Bind("EducationLevelID") %>'></asp:DropDownList></edititemtemplate><insertitemtemplate> <asp:DropDownList ID="ddlEduLevelInsert" Runat="server" DataSourceID="ObjectDataSource4" DataTextField="EducationLevelName" DataValueField="EducationLevelID" SelectedValue='<%# Bind("EducationLevelID") %>'></asp:DropDownList></insertitemtemplate><itemtemplate><asp:Label ID="Label3" Runat="server" Text='<%# JobSiteStarterKit.BOL.EducationLevel.GetEducationLevelName((int)Eval("EducationLevelID")) %>'> </asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" wrap="False" /><itemstyle wrap="False" /></asp:templatefield><asp:templatefield HeaderText="Job Type :" SortExpression="JobTypeID"><edititemtemplate> <asp:DropDownList ID="ddlJobTypeUpdate" Runat="server" DataSourceID="ObjectDataSource5" DataTextField="JobTypeName" DataValueField="JobTypeID" SelectedValue='<%# Bind("JobTypeID") %>'></asp:DropDownList></edititemtemplate><insertitemtemplate> <asp:DropDownList ID="ddlJobTypeInsert" Runat="server" DataSourceID="ObjectDataSource5" DataTextField="JobTypeName" DataValueField="JobTypeID" SelectedValue='<%# Bind("JobTypeID") %>'></asp:DropDownList></insertitemtemplate><itemtemplate><asp:Label ID="Label4" Runat="server" Text='<%# JobSiteStarterKit.BOL.JobType.GetJobTypeName((int)Eval("JobTypeID")) %>'> </asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" /></asp:templatefield><asp:boundfield DataField="MinSalary" HeaderText="Min Salary :" SortExpression="MinSalary"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:boundfield DataField="MaxSalary" HeaderText="Max Salary :" SortExpression="MaxSalary"><headerstyle cssclass="dataentryformlabel" /></asp:boundfield><asp:templatefield HeaderText="Description :" SortExpression="Description"><edititemtemplate><asp:TextBox ID="TextBox1" Runat="server" Rows="5" Text='<%# Bind("Description") %>' TextMode="MultiLine" Width="98%"> </asp:TextBox></edititemtemplate><insertitemtemplate><asp:TextBox ID="TextBox1" Runat="server" Rows="5" Text='<%# Bind("Description") %>' TextMode="MultiLine"> </asp:TextBox></insertitemtemplate><itemtemplate> <asp:Label ID="Label5" Runat="server" Text='<%# (Server.HtmlEncode(Eval("Description").ToString())).Replace("\r\n","<br>") %>'></asp:Label></itemtemplate><headerstyle cssclass="dataentryformlabel" verticalalign="Top" /></asp:templatefield><asp:commandfield ButtonType="Image" ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" CancelImageUrl="~/Images/CancelButton.gif" DeleteImageUrl="~/Images/DeleteButton.gif" EditImageUrl="~/Images/EditButton.gif" InsertImageUrl="~/Images/SaveButton.gif" NewImageUrl="~/Images/AddButton.gif" UpdateImageUrl="~/Images/SaveButton.gif"><controlstyle cssclass="dataentryformbutton" /><footerstyle horizontalalign="Center" /> <itemstyle horizontalalign="Center" /> </asp:commandfield></fields><headerstyle horizontalalign="Right" /><insertrowstyle horizontalalign="Left" /><editrowstyle horizontalalign="Left" /></asp:DetailsView></contenttemplate></asp:UpdatePanel><asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"><progresstemplate><asp:Image ID="Image1" runat="server" ImageUrl="~/images/progress.gif" /></progresstemplate></asp:UpdateProgress> <br /> <br /> <asp:HyperLink ID="HyperLink1" Runat="server" NavigateUrl="~/employer/jobpostings.aspx">Go to Listing Page</asp:HyperLink> <br /> <br /> <asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.JobPosting" DeleteMethod="Delete" InsertMethod="Insert" SelectMethod="GetPosting" UpdateMethod="Update" DataObjectTypeName="JobSiteStarterKit.BOL.JobPosting"> <DeleteParameters> <asp:Parameter Name="original_JobPostingID" Type="Int32" /> </DeleteParameters> <SelectParameters> <asp:QueryStringParameter Name="id" QueryStringField="id" Type="Int32"></asp:QueryStringParameter> </SelectParameters> </asp:ObjectDataSource><br /> <asp:ObjectDataSource ID="ObjectDataSource2" Runat="server" TypeName="JobSiteStarterKit.BOL.State" SelectMethod="GetStates"> <SelectParameters> <asp:Parameter Type="Int32" Name="countryid"></asp:Parameter> </SelectParameters> </asp:ObjectDataSource> <asp:ObjectDataSource ID="ObjectDataSource3" Runat="server" TypeName="JobSiteStarterKit.BOL.Country" SelectMethod="SelectCountries"> </asp:ObjectDataSource> <asp:ObjectDataSource ID="ObjectDataSource4" Runat="server" SelectMethod="GetEducationLevels" TypeName="JobSiteStarterKit.BOL.EducationLevel"> </asp:ObjectDataSource> <asp:ObjectDataSource ID="ObjectDataSource5" Runat="server" SelectMethod="GetJobTypes" TypeName="JobSiteStarterKit.BOL.JobType"> </asp:ObjectDataSource> </div></asp:Content>AddEditPosting.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class AddEditPosting_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { if (Company.GetCompany(User.Identity.Name) == null) { Response.Redirect("~/customerrorpages/profilenotfound.aspx"); } if (Request.QueryString["id"] == null) { DetailsView1.DefaultMode = DetailsViewMode.Insert; } else { DetailsView1.DefaultMode = DetailsViewMode.ReadOnly; } } } protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e) { DropDownList ddl; ddl = (DropDownList)DetailsView1.FindControl("ddlStateInsert"); e.Values["StateID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlCountryInsert"); e.Values["CountryID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlEduLevelInsert"); e.Values["EducationLevelID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlJobTypeInsert"); e.Values["JobTypeID"] = ddl.SelectedValue; e.Values["PostedBy"] = Profile.UserName; e.Values["CompanyID"]=Profile.panyID.ToString(); e.Values["PostingDate"]= DateTime.Today.ToString("MM/dd/yyyy"); } protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { DropDownList ddl; ddl = (DropDownList)DetailsView1.FindControl("ddlStateUpdate"); e.NewValues["StateID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlCountryUpdate"); e.NewValues["CountryID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlEduLevelUpdate"); e.NewValues["EducationLevelID"] = ddl.SelectedValue; ddl = (DropDownList)DetailsView1.FindControl("ddlJobTypeUpdate"); e.NewValues["JobTypeID"] = ddl.SelectedValue; e.NewValues["PostedBy"] = Profile.UserName; e.NewValues["CompanyID"] = Profile.panyID.ToString(); e.NewValues["PostingDate"] = DateTime.Today.ToString("MM/dd/yyyy"); } protected void DetailsView1_ItemDeleted(object sender, DetailsViewDeletedEventArgs e) { Response.Redirect("~/employer/jobpostings.aspx"); } protected void ddlCountryUpdate_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl; ddl = (DropDownList)sender; ObjectDataSource2.SelectParameters["countryid"].DefaultValue = ddl.SelectedValue; ObjectDataSource2.Select(); } protected void ddlCountryInsert_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl; ddl = (DropDownList)sender; ObjectDataSource2.SelectParameters["countryid"].DefaultValue = ddl.SelectedValue; ObjectDataSource2.Select(); } protected void DetailsView1_DataBound(object sender, EventArgs e) { DropDownList ddl; ddl = (DropDownList)DetailsView1.FindControl("ddlCountryUpdate"); if (ddl != null) { ObjectDataSource2.SelectParameters["countryid"].DefaultValue = ddl.SelectedValue; ObjectDataSource2.Select(); } } }CompanyProfile.aspx<%@ Page Language="C#" CodeFile="companyprofile.aspx.cs" Inherits="companyprofile_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align=center> <asp:Label ID="Label13" Runat="server" Text="Modify Your Company Profile" SkinID="formheading"></asp:Label></div> <br /> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <table style="width: 100%"> <tr> <td valign="top" align="left" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label14" Runat="server" Text="Introduce Your Company" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label1" Runat="server" Text="Company Name :"></asp:Label> </td> <td align="left" width="60%"> <asp:TextBox ID="txtCompanyName" Runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ErrorMessage="Please enter company name" ControlToValidate="txtCompanyName" Display="Dynamic"> *</asp:RequiredFieldValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label12" Runat="server" Text="Brief Profile :"></asp:Label> </td> <td align="left" width="60%"> <asp:TextBox ID="txtProfile" Runat="server" Width="100%" Rows="5" TextMode="MultiLine"></asp:TextBox> </td> </tr> <tr> <td valign="top" align="left" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label15" Runat="server" Text="Location" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label2" Runat="server" Text="Address 1 :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtAddress1" Runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" Runat="server" ErrorMessage="Please enter address" ControlToValidate="txtAddress1" Display="Dynamic"> *</asp:RequiredFieldValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label3" Runat="server" Text="Address 2 :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtAddress2" Runat="server"></asp:TextBox> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label4" Runat="server" Text="City :"></asp:Label></td> <td align="left" width="60%"><asp:TextBox ID="txtCity" Runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" Runat="server" ErrorMessage="Please enter city" ControlToValidate="txtCity" Display="Dynamic"> *</asp:RequiredFieldValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label6" Runat="server" Text="Country :"></asp:Label> </td> <td align="left" width="60%"> <asp:DropDownList ID="ddlCountry" Runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged"> </asp:DropDownList> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label5" Runat="server" Text="State :"></asp:Label> </td> <td align="left" width="60%"> <asp:DropDownList ID="ddlState" Runat="server"> </asp:DropDownList> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label7" Runat="server" Text="ZIP :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtZIP" Runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" Runat="server" ErrorMessage="Please enter ZIP code" ControlToValidate="txtZIP" Display="Dynamic"> *</asp:RequiredFieldValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidator1" Runat="server" ErrorMessage="Please enter valid ZIP code" ValidationExpression="\d{5}(-\d{4})?" ControlToValidate="txtZIP" Display="Dynamic"> *</asp:RegularExpressionValidator> </td> </tr> <tr> <td valign="top" align="left" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label16" Runat="server" Text="Contact Details" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label8" Runat="server" Text="Phone :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtPhone" Runat="server"></asp:TextBox><br /> <asp:Label ID="Label17" runat="server" Text="(e.g. 111-111-1111)"></asp:Label> <asp:RegularExpressionValidator ID="RegularExpressionValidator2" Runat="server" ErrorMessage="Please enter valid phone number" ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" ControlToValidate="txtPhone" Display="Dynamic"> *</asp:RegularExpressionValidator> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" Runat="server" ErrorMessage="Please enter phone number" ControlToValidate="txtProfile" Display="Dynamic"> *</asp:RequiredFieldValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label9" Runat="server" Text="Fax :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtFax" Runat="server"></asp:TextBox> <asp:RegularExpressionValidator ID="RegularExpressionValidator3" Runat="server" ErrorMessage="Please enter valid Fax number" ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}" ControlToValidate="txtFax" Display="Dynamic"> *</asp:RegularExpressionValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> <asp:Label ID="Label10" Runat="server" Text="Email :"></asp:Label></td> <td align="left" width="60%"> <asp:TextBox ID="txtEmail" Runat="server"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" Runat="server" ErrorMessage="Please enter email address" ControlToValidate="txtEmail" Display="Dynamic"> *</asp:RequiredFieldValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidator4" Runat="server" ErrorMessage="Please enter valid email address" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ControlToValidate="txtEmail" Display="Dynamic"> *</asp:RegularExpressionValidator> </td> </tr> <tr> <td style=" height: 26px;" valign="top" align="right" width="40%"> <asp:Label ID="Label11" Runat="server" Text="Web Site :"></asp:Label></td> <td style=" height: 26px;" align="left" width="60%"> <asp:TextBox ID="txtWebSiteUrl" Runat="server"></asp:TextBox><br /> <asp:Label ID="Label18" runat="server" Text="(e.g. )"></asp:Label> <asp:RegularExpressionValidator ID="RegularExpressionValidator5" Runat="server" ErrorMessage="Please enter valid web site URL" ValidationExpression="http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?" ControlToValidate="txtWebSiteUrl" Display="Dynamic"> *</asp:RegularExpressionValidator> </td> </tr> <tr> <td valign="top" align="right" width="40%"> </td> <td align="left" width="60%"> </td> </tr> <tr> <td valign="top" align="center" colspan="2" width="40%"> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/SaveButton.gif" onclick="ImageButton1_Click" /> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/Images/CancelButton.gif" onclick="ImageButton2_Click" /> </td> </tr> <tr> <td align="center" colspan="2" valign="top" width="40%"> <asp:Label ID="lblMsg" runat="server" SkinID="FormLabel"></asp:Label></td> </tr> <tr> <td valign="top" align="center" width="40%" colspan="2"> <asp:ValidationSummary ID="ValidationSummary1" Runat="server" /> </td> </tr></table> </ContentTemplate></asp:UpdatePanel> <br /> <asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"><progresstemplate> <center><asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Progress.gif" /></center></progresstemplate></asp:UpdateProgress></asp:Content>CompanyProfile.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class companyprofile_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { ddlCountry.DataSource = Country.GetCountries(); ddlCountry.DataTextField = "CountryName"; ddlCountry.DataValueField = "CountryID"; ddlCountry.DataBind(); Company objCompany = Company.GetCompany(Profile.UserName); if (objCompany != null) { ListItem li; txtCompanyName.Text = panyName; txtAddress1.Text = objCompany.Address1; txtAddress2.Text = objCompany.Address2; txtCity.Text = objCompany.City; li = ddlState.Items.FindByValue(objCompany.StateID.ToString()); if (li != null) { ddlState.ClearSelection(); li.Selected = true; } li = ddlCountry.Items.FindByValue(objCompany.CountryID.ToString()); if (li != null) { ddlCountry.ClearSelection(); li.Selected = true; ddlState.DataSource = State.GetStates(int.Parse(ddlCountry.SelectedValue)); ddlState.DataTextField = "StateName"; ddlState.DataValueField = "StateID"; ddlState.DataBind(); li = ddlState.Items.FindByValue(objCompany.StateID.ToString()); if (li != null) { ddlState.ClearSelection(); li.Selected = true; } } txtZIP.Text = objCompany.ZIP; txtPhone.Text = objCompany.Phone; txtFax.Text = objCompany.Fax; txtEmail.Text = objCompany.Email; txtWebSiteUrl.Text = objCompany.WebSiteUrl; txtProfile.Text = objCompany.BriefProfile; } } } protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { ddlState.DataSource = State.GetStates(int.Parse(ddlCountry.SelectedValue)); ddlState.DataTextField = "StateName"; ddlState.DataValueField = "StateID"; ddlState.DataBind(); } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Company objCompany = new Company(); panyName = txtCompanyName.Text; objCompany.Address1 = txtAddress1.Text; objCompany.Address2 = txtAddress2.Text; objCompany.City = txtCity.Text; objCompany.StateID = int.Parse(ddlState.SelectedValue); objCompany.CountryID = int.Parse(ddlCountry.SelectedValue); objCompany.ZIP = txtZIP.Text; objCompany.Phone = txtPhone.Text; objCompany.Fax = txtFax.Text; objCompany.Email = txtEmail.Text; objCompany.WebSiteUrl = txtWebSiteUrl.Text; objCompany.BriefProfile = txtProfile.Text; objCompany.UserName = Profile.UserName; if (Profile.panyID != -1) { panyID = (int)Profile.panyID; Company.Update(objCompany); } else { int i = Company.Insert(objCompany); Profile.panyID = i; } lblMsg.Text = "Your company profile is updated!"; } protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { Response.Redirect("~/default.aspx"); }}JobPostings.aspx<%@ Page Language="C#" CodeFile="jobpostings.aspx.cs" Inherits="postinglist_aspx" MasterPageFile="~/MasterPage.master" %><%@ Register assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.WebControls" tagprefix="asp" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div align="center"> <asp:Label ID="Label14" Runat="server" Text="List of Job Postings" SkinID="FormHeading"></asp:Label> <br /> <br /> <asp:HyperLink ID="HyperLink1" runat="server" ImageUrl="~/Images/AddJobPosting.gif" NavigateUrl="~/employer/AddEditPosting.aspx">HyperLink</asp:HyperLink> <br /> </div> <br /> <asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound" DataKeyNames="PostingID" Width="100%"> <Columns> <asp:BoundField HeaderText="Title" DataField="Title"></asp:BoundField> <asp:BoundField HeaderText="Job Code" DataField="JobCode"></asp:BoundField> <asp:BoundField HeaderText="Location" DataField="City"></asp:BoundField> <asp:BoundField HeaderText="Posted On" DataField="PostingDate" DataFormatString="{0:MM/dd/yyyy}"></asp:BoundField> <asp:ButtonField ButtonType="Image" ImageUrl="~/Images/ShowDetails.gif"> <ItemStyle Wrap="False"></ItemStyle> </asp:ButtonField> </Columns> </asp:GridView><br /> <asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.JobPosting" DeleteMethod="Delete" InsertMethod="Insert" SelectMethod="GetPostings" UpdateMethod="Update" DataObjectTypeName="JobSiteStarterKit.BOL.JobPosting"> <DeleteParameters> <asp:Parameter Type="Int32" Name="id"></asp:Parameter> </DeleteParameters> <UpdateParameters> <asp:Parameter Type="Int32" Name="JobPostingID"></asp:Parameter> <asp:Parameter Type="Int32" Name="CompanyID"></asp:Parameter> <asp:Parameter Type="String" Name="ContactPerson"></asp:Parameter> <asp:Parameter Type="String" Name="Title"></asp:Parameter> <asp:Parameter Type="String" Name="Department"></asp:Parameter> <asp:Parameter Type="String" Name="JobCode"></asp:Parameter> <asp:Parameter Type="String" Name="City"></asp:Parameter> <asp:Parameter Type="Int32" Name="StateID"></asp:Parameter> <asp:Parameter Type="Int32" Name="CountryID"></asp:Parameter> <asp:Parameter Type="Int32" Name="EducationLevelID"></asp:Parameter> <asp:Parameter Type="Int32" Name="JobTypeID"></asp:Parameter> <asp:Parameter Type="Decimal" Name="MinSalary"></asp:Parameter> <asp:Parameter Type="Decimal" Name="MaxSalary"></asp:Parameter> <asp:Parameter Type="String" Name="Description"></asp:Parameter> <asp:Parameter Type="DateTime" Name="PostingDate"></asp:Parameter> <asp:Parameter Type="String" Name="PostedBy"></asp:Parameter> </UpdateParameters> <SelectParameters> <asp:ProfileParameter Name="username" Type="String" PropertyName="UserName"></asp:ProfileParameter> </SelectParameters> <InsertParameters> <asp:Parameter Type="Int32" Name="JobPostingID"></asp:Parameter> <asp:Parameter Type="Int32" Name="CompanyID"></asp:Parameter> <asp:Parameter Type="String" Name="ContactPerson"></asp:Parameter> <asp:Parameter Type="String" Name="Title"></asp:Parameter> <asp:Parameter Type="String" Name="Department"></asp:Parameter> <asp:Parameter Type="String" Name="JobCode"></asp:Parameter> <asp:Parameter Type="String" Name="City"></asp:Parameter> <asp:Parameter Type="Int32" Name="StateID"></asp:Parameter> <asp:Parameter Type="Int32" Name="CountryID"></asp:Parameter> <asp:Parameter Type="Int32" Name="EducationLevelID"></asp:Parameter> <asp:Parameter Type="Int32" Name="JobTypeID"></asp:Parameter> <asp:Parameter Type="Decimal" Name="MinSalary"></asp:Parameter> <asp:Parameter Type="Decimal" Name="MaxSalary"></asp:Parameter> <asp:Parameter Type="String" Name="Description"></asp:Parameter> <asp:Parameter Type="DateTime" Name="PostingDate"></asp:Parameter> <asp:Parameter Type="String" Name="PostedBy"></asp:Parameter> </InsertParameters> </asp:ObjectDataSource></asp:Content>JobPosting.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class postinglist_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (mandName == "edit") { Response.Redirect("~/employer/addeditposting.aspx?id=" + mandArgument); } } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ImageButton b = (ImageButton)e.Row.Cells[4].Controls[0]; mandName = "edit"; mandArgument = GridView1.DataKeys[e.Row.RowIndex].Value.ToString(); } }}MyFavorite.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="MyFavorites.aspx.cs" Inherits="MyFavorites_aspx" Title="Untitled Page" %><%@ Register Src="../UserControls/DisplayModeController.ascx" TagName="DisplayModeController" TagPrefix="uc4" %><%@ Register Src="../UserControls/MyJobs.ascx" TagName="MyJobs" TagPrefix="uc3" %><%@ Register Src="../UserControls/MySearches.ascx" TagName="MySearches" TagPrefix="uc2" %><%@ Register TagPrefix="uc1" TagName="MyResumes" Src="../UserControls/MyResumes.ascx" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div align="center"> <asp:Label ID="Label14" Runat="server" SkinID="FormHeading" Text="My Favorites"></asp:Label> <br /> <asp:WebPartManager ID="WebPartManager1" runat="server"> </asp:WebPartManager> <br /> <uc4:DisplayModeController ID="DisplayModeController1" runat="server" /> <br /> <asp:CatalogZone ID="CatalogZone1" runat="server" HeaderText="" VerbButtonType="Link"> <ZoneTemplate> <asp:PageCatalogPart ID="PageCatalogPart1" runat="server" Title="Available Web Parts" /> </ZoneTemplate> </asp:CatalogZone> </div> <br /> <table style="width: 100%"> <tr> <td style="width: 100%"> <asp:WebPartZone HeaderText="My Resumes" ID="WebPartZone1" runat="server" WebPartVerbRenderMode="TitleBar" ShowTitleIcons="False" Width="100%"> <minimizeverb text="Collapse" ImageUrl="~/Images/CollapseButton.gif" /><restoreverb text="Expand" ImageUrl="~/Images/ExpandButton.gif" /> <closeverb imageurl="~/Images/CloseButton.gif" /> <ZoneTemplate> <uc1:MyResumes ID="MyResumes1" Runat="server" title="My Resumes" /> </ZoneTemplate> </asp:WebPartZone> </td> </tr> </table> <br /> <br /> </asp:Content>MyFavorite.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class MyFavorites_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } }}ResumeSearch.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="resumesearch.aspx.cs" Inherits="resumesearch_aspx" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align="center"> <asp:Label ID="Label14" Runat="server" Text="Search Resume Database" SkinID="FormHeading"></asp:Label> <br /> <asp:Label ID="lblResumeCount" Runat="server" SkinID="Slogan"></asp:Label><asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><table style="width: 100%"><tr><td align="right" valign="top" width="40%"><asp:Label ID="Label1" Runat="server" Text="Skills :"></asp:Label></td><td align="left" style="width: 100px"><asp:TextBox ID="txtSkills" Runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ControlToValidate="txtSkills" Display="Dynamic" ErrorMessage="Please enter skills to search for"> *</asp:RequiredFieldValidator></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label3" Runat="server" Text="Country :"></asp:Label></td><td align="left" style="width: 100px"><asp:DropDownList ID="ddlCountry" Runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged"></asp:DropDownList></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label4" Runat="server" Text="State :"></asp:Label></td><td align="left" style="width: 100px"><asp:DropDownList ID="ddlState" Runat="server" AutoPostBack="True" onselectedindexchanged="ddlState_SelectedIndexChanged"></asp:DropDownList></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label2" Runat="server" Text="City :"></asp:Label></td><td align="left" style="width: 100px"><asp:TextBox ID="txtCity" Runat="server" Enabled="False"></asp:TextBox></td></tr><tr><td align="center" colspan="2" valign="top"><asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/SearchButton.gif" onclick="ImageButton1_Click" /></td></tr><tr><td align="center" colspan="2" valign="top"><asp:Label ID="lblMsg" runat="server" SkinID="FormLabel"></asp:Label></td></tr><tr><td align="left" colspan="2" valign="top"><asp:ValidationSummary ID="ValidationSummary1" Runat="server" /></td></tr></table></contenttemplate></asp:UpdatePanel><asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"><progresstemplate><asp:Image ID="Image1" runat="server" ImageUrl="~/images/progress.gif" /></progresstemplate></asp:UpdateProgress><br /></div> <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional"><contenttemplate><asp:GridView ID="GridView1" Runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="ResumeID" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound" Width="100%"><columns><asp:boundfield DataField="JobTitle" HeaderText="Title"></asp:boundfield><asp:boundfield DataField="educationlevelid" HeaderText="Education" ShowHeader="False"></asp:boundfield><asp:boundfield DataField="experiencelevelid" HeaderText="Experience"></asp:boundfield><asp:boundfield DataField="TargetCity" HeaderText="Location"></asp:boundfield><asp:buttonfield CommandName="viewdetails" ButtonType="Image" ImageUrl="~/Images/ShowDetails.gif"></asp:buttonfield></columns></asp:GridView></contenttemplate></asp:UpdatePanel> <br /> <br /></asp:Content>ResumeSearch.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class resumesearch_aspx : Page{ private void BindGrid() { int countryid = -1, stateid = -1; if (ddlCountry.SelectedItem != null) countryid = int.Parse(ddlCountry.SelectedValue); if (ddlState.SelectedItem != null) stateid = int.Parse(ddlState.SelectedValue); DataSet ds = Resume.SearchResumes(txtSkills.Text, countryid, stateid,txtCity.Text); GridView1.DataSource = ds; GridView1.DataBind(); if (GridView1.Rows.Count <= 0) { lblMsg.Text = "No records found!"; } else { lblMsg.Text = ""; } UpdatePanel2.Update(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ImageButton b = (ImageButton)e.Row.Cells[4].Controls[0]; mandName = "viewdetails"; mandArgument = GridView1.DataKeys[e.Row.RowIndex].Value.ToString(); e.Row.Cells[1].Text = EducationLevel.GetEducationLevelName(int.Parse(e.Row.Cells[1].Text)); e.Row.Cells[2].Text = ExperienceLevel.GetExperienceLevelName(int.Parse(e.Row.Cells[2].Text)); } } protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { FillCountries(); FillStates(); lblResumeCount.Text = "(Currently we have " + Resume.GetResumeCount() + " resumes !!!)"; } } private void FillCountries() { ddlCountry.DataSource = Country.GetCountries(); ddlCountry.DataTextField = "CountryName"; ddlCountry.DataValueField = "CountryID"; ddlCountry.DataBind(); } private void FillStates() { ddlState.DataSource = State.GetStates(int.Parse(ddlCountry.SelectedValue)); ddlState.DataTextField = "StateName"; ddlState.DataValueField = "StateID"; ddlState.DataBind(); } protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { FillStates(); txtCity.Enabled = false; } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (mandName == "viewdetails") { Response.Redirect("~/employer/viewresume.aspx?id=" + mandArgument); } } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; BindGrid(); } protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { if (ddlState.SelectedIndex > 0) { txtCity.Enabled = true; } else { txtCity.Enabled = false; } } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { BindGrid(); }}ViewResume.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="viewresume.aspx.cs" Inherits="viewresume_aspx" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align="center"> <asp:Label ID="Label14" Runat="server" Text="View Resume" SkinID="FormHeading"></asp:Label><br /> </div> <table width="100%"><tr> <td> <asp:Label ID="lblName" Runat="server" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td> <asp:Label ID="lblEducation" Runat="server" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td> <asp:Label ID="lblExperience" Runat="server" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td> <asp:Label ID="lblCoveringLetter" Runat="server" Width="100%"></asp:Label> </td> </tr> <tr> <td> <asp:Label ID="lblResume" Runat="server" Width="100%"></asp:Label> </td> </tr> <tr> <td align="center"> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/BackButton.gif" onclick="ImageButton1_Click" /> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/Images/MyFavorite.gif" onclick="ImageButton2_Click" /> </td> </tr></table></asp:Content>ViewResume.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;using ASP;public partial class viewresume_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } Resume r = Resume.GetResume(int.Parse(Request.QueryString["id"])); ProfileCommon p = Profile.GetProfile(r.UserName); lblName.Text = "Full Name : " + p.FirstName + " " + p.LastName; lblEducation.Text = "Education Level : " + EducationLevel.GetEducationLevelName(r.EducationLevelID); lblExperience.Text = "Experience Level : " + ExperienceLevel.GetExperienceLevelName(r.ExperienceLevelID); lblCoveringLetter.Text = r.CoveringLetterText.Replace("\r\n", "<br>"); lblResume.Text = r.ResumeText.Replace("\r\n","<br>"); } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Response.Redirect("~/employer/resumesearch.aspx"); } protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { MyResume r = new MyResume(); r.ResumeID = int.Parse(Request.QueryString["id"]); r.UserName = Profile.UserName; MyResume.Insert(r); }}JobSearch.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="jobsearch.aspx.cs" Inherits="jobsearch_aspx" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align=center> <asp:Label ID="Label14" Runat="server" Text="Search Jobs!!!" SkinID="FormHeading"></asp:Label> <br /> <asp:Label ID="lblJobCount" Runat="server" SkinID="Slogan"></asp:Label><br /><br /></div> <asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><table style="width: 100%"><tr><td align="right" valign="top"><asp:Label ID="Label1" Runat="server" Text="Skills :" SkinID="FormLabel"></asp:Label></td><td align="left"><asp:TextBox ID="txtSkills" Runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ControlToValidate="txtSkills" Display="Dynamic" ErrorMessage="Please enter skills to search for"> *</asp:RequiredFieldValidator></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label3" Runat="server" Text="Country :" SkinID="FormLabel"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlCountry" Runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged"></asp:DropDownList></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label4" Runat="server" Text="State :" SkinID="FormLabel"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlState" Runat="server" AutoPostBack="True" onselectedindexchanged="ddlState_SelectedIndexChanged"></asp:DropDownList></td></tr><tr><td align="right" valign="top"><asp:Label ID="Label2" Runat="server" Text="City :" SkinID="FormLabel"></asp:Label></td><td align="left"><asp:TextBox ID="txtCity" Runat="server" Enabled="False"></asp:TextBox></td></tr><tr><td align="center" colspan="2" valign="top"><asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/SearchButton.gif" onclick="ImageButton1_Click" /> <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/Images/MyFavorite.gif" onclick="ImageButton3_Click" /></td></tr><tr><td align="center" colspan="2" valign="top"><asp:Label ID="lblMsg" runat="server" SkinID="FormLabel"></asp:Label></td></tr><tr><td align="left" colspan="2" valign="top"><asp:ValidationSummary ID="ValidationSummary1" Runat="server" /></td></tr></table></contenttemplate></asp:UpdatePanel><asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"><progresstemplate> <center><asp:Image ID="Image1" runat="server" ImageUrl="~/images/progress.gif" /></center></progresstemplate></asp:UpdateProgress> <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional"><contenttemplate><asp:GridView ID="GridView1" Runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="PostingID" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound" PageSize="3" Width="100%"><columns><asp:templatefield HeaderText="Date"><edititemtemplate><asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("PostingDate") %>'></asp:TextBox></edititemtemplate><itemtemplate><asp:Label ID="Label1" runat="server" Text='<%# Bind("PostingDate", "{0:MM/dd/yyyy}") %>'></asp:Label></itemtemplate></asp:templatefield><asp:boundfield DataField="Title" HeaderText="Title" SortExpression="title"></asp:boundfield><asp:boundfield DataField="City" HeaderText="Location" SortExpression="city"></asp:boundfield><asp:boundfield DataField="companyname" HeaderText="Company" ShowHeader="False" SortExpression="companyname"></asp:boundfield><asp:buttonfield CommandName="viewdetails" ButtonType="Image" ImageUrl="~/Images/ShowDetails.gif"><itemstyle wrap="False" /></asp:buttonfield></columns></asp:GridView></contenttemplate></asp:UpdatePanel> <br /> </asp:Content>JobSearch.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class jobsearch_aspx : Page{ protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ImageButton b = (ImageButton)e.Row.Cells[4].Controls[0]; mandName = "viewdetails"; mandArgument = GridView1.DataKeys[e.Row.RowIndex].Value.ToString(); } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (mandName == "viewdetails") { Response.Redirect("~/jobseeker/viewjobposting.aspx?id=" + mandArgument); } } protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["jobseekerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { FillCountries(); FillStates(); lblJobCount.Text = "(Currently we have " + JobPosting.GetJobPostingCount() + " jobs!!!)"; if (Request.QueryString["mysearchid"] != null) { MySearch s=MySearch.GetMySearch(int.Parse(Request.QueryString["mysearchid"])); txtSkills.Text = s.Criteria; txtCity.Text = s.City; ddlCountry.SelectedIndex = s.CountryID; FillStates(); ListItem li= ddlState.Items.FindByValue(s.StateID.ToString()); if (li != null) { ddlState.ClearSelection(); li.Selected = true; } } } } private void FillCountries() { ddlCountry.DataSource = Country.GetCountries(); ddlCountry.DataTextField = "CountryName"; ddlCountry.DataValueField = "CountryID"; ddlCountry.DataBind(); } private void FillStates() { ddlState.DataSource = State.GetStates(int.Parse(ddlCountry.SelectedValue)); ddlState.DataTextField = "StateName"; ddlState.DataValueField = "StateID"; ddlState.DataBind(); } protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { FillStates(); txtCity.Enabled = false; } private void BindGrid() { int countryid = -1, stateid = -1; if (ddlCountry.SelectedItem != null) countryid = int.Parse(ddlCountry.SelectedValue); if (ddlState.SelectedItem != null) stateid = int.Parse(ddlState.SelectedValue); DataSet ds = JobPosting.SearchJobs(txtSkills.Text, countryid, stateid,txtCity.Text); GridView1.DataSource = ds; GridView1.DataBind(); if (GridView1.Rows.Count <= 0) { lblMsg.Text = "No records found!"; } else { lblMsg.Text = ""; } UpdatePanel2.Update(); } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; BindGrid(); } protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { if (ddlState.SelectedIndex > 0) { txtCity.Enabled = true; } else { txtCity.Enabled = false; } } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { BindGrid(); } protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { MySearch s = new MySearch(); s.Criteria = txtSkills.Text; s.CountryID = int.Parse(ddlCountry.SelectedValue); s.StateID = int.Parse(ddlState.SelectedValue); s.City = txtCity.Text; s.UserName = Profile.UserName; MySearch.Insert(s); }}MyFavorites.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="MyFavorites.aspx.cs" Inherits="MyFavorites_aspx" Title="Untitled Page" %><%@ Register Src="../UserControls/DisplayModeController.ascx" TagName="DisplayModeController" TagPrefix="uc3" %><%@ Register Src="../UserControls/MyJobs.ascx" TagName="MyJobs" TagPrefix="uc1" %><%@ Register Src="../UserControls/MySearches.ascx" TagName="MySearches" TagPrefix="uc2" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><div align=center> <asp:Label ID="Label14" Runat="server" Text="My Favorites" SkinID="FormHeading"></asp:Label> <br /><br /> <asp:WebPartManager ID="WebPartManager1" runat="server"> </asp:WebPartManager> <uc3:DisplayModeController ID="DisplayModeController1" runat="server" /> <br /> <asp:CatalogZone ID="CatalogZone1" runat="server" HeaderText="" VerbButtonType="Link"> <ZoneTemplate> <asp:PageCatalogPart ID="PageCatalogPart1" runat="server" Title="Available Web Parts" /> </ZoneTemplate> </asp:CatalogZone></div> <br /> <table style="width: 100%" align="center"> <tr> <td style="width: 100%"> <asp:WebPartZone ID="WebPartZone1" runat="server" BorderStyle="NotSet" WebPartVerbRenderMode="TitleBar" Width="100%"> <minimizeverb text="Collapse" ImageUrl="~/Images/CollapseButton.gif" /><restoreverb text="Expand" ImageUrl="~/Images/ExpandButton.gif" /> <closeverb imageurl="~/Images/CloseButton.gif" /> <ZoneTemplate> <uc1:MyJobs ID="MyJobs1" runat="server" Title="My Jobs"/> </ZoneTemplate> </asp:WebPartZone> </td> </tr> <tr> <td style="width: 100%"> <asp:WebPartZone ID="WebPartZone2" runat="server" BorderStyle="NotSet" WebPartVerbRenderMode="TitleBar" Width="100%"> <minimizeverb text="Collapse" ImageUrl="~/Images/CollapseButton.gif" /><restoreverb text="Expand" ImageUrl="~/Images/ExpandButton.gif" /> <closeverb imageurl="~/Images/CloseButton.gif" /> <ZoneTemplate> <uc2:MySearches ID="MySearches1" runat="server" Title="My Searches" width="100%"/> </ZoneTemplate> </asp:WebPartZone> </td> </tr> </table></asp:Content>MyFavorites.aspx.csusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class MyFavorites_aspx : System.Web.UI.Page{ // Page events are wired up automatically to methods // with the following names: // Page_Load, Page_AbortTransaction, Page_CommitTransaction, // Page_DataBinding, Page_Disposed, Page_Error, Page_Init, // Page_Init Complete, Page_Load, Page_LoadComplete, Page_PreInit // Page_PreLoad, Page_PreRender, Page_PreRenderComplete, // Page_SaveStateComplete, Page_Unload protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["jobseekerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } }}PostResume.aspx<%@ Page Language="C#" CodeFile="postresume.aspx.cs" Inherits="postresume_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align=center><asp:Label ID="Label14" Runat="server" Text="Post Your Resume" SkinID="FormHeading"></asp:Label></div><br /><asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><table width="100%" cellpadding="3"><tr><td align="left" colspan="2" class="dataentryformlabelbig"><asp:Label ID="Label15" Runat="server" SkinID="FormGroupLabel" Text="Job Details"></asp:Label></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label1" Runat="server" Text="Job Title :"></asp:Label></td><td align="left"><asp:TextBox ID="txtJobTitle" Runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ControlToValidate="txtJobTitle" Display="Dynamic" ErrorMessage="Please enter job title"> *</asp:RequiredFieldValidator></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label6" Runat="server" Text="Desired Job Type :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlJobType" Runat="server"></asp:DropDownList></td></tr><tr><td align="left" colspan="2" class="dataentryformlabelbig"><asp:Label ID="Label16" Runat="server" SkinID="FormGroupLabel" Text="Location"></asp:Label></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label2" Runat="server" Text="Target City :"></asp:Label></td><td align="left"><asp:TextBox ID="txtCity" Runat="server"></asp:TextBox></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label3" Runat="server" Text="Target Country :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlCountry" Runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged"></asp:DropDownList></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label4" Runat="server" Text="Target State :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlState" Runat="server"></asp:DropDownList></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label5" Runat="server" Text="Acceptable Relocation :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlRelocationCountry" Runat="server"></asp:DropDownList></td></tr><tr><td align="left" colspan="2" class="dataentryformlabelbig"><asp:Label ID="Label17" Runat="server" SkinID="FormGroupLabel" Text="Education and Experience"></asp:Label> </td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label7" Runat="server" Text="Education Level :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlEduLevel" Runat="server"></asp:DropDownList></td></tr><tr><td align="right" nowrap width="10%"><asp:Label ID="Label8" Runat="server" Text="Experience Level :"></asp:Label></td><td align="left"><asp:DropDownList ID="ddlExpLevel" Runat="server"></asp:DropDownList></td></tr><tr><td align="left" colspan="2" class="dataentryformlabelbig"><asp:Label ID="Label9" Runat="server" SkinID="FormGroupLabel" Text="Resume :"></asp:Label></td></tr><tr><td align="right" colspan="2" valign="top"> <asp:TextBox ID="txtResume" Runat="server" Rows="15" TextMode="MultiLine" Width="98%"></asp:TextBox><br /><asp:RequiredFieldValidator ID="RequiredFieldValidator2" Runat="server" ControlToValidate="txtResume" Display="Dynamic" ErrorMessage="Please enter resume"> *</asp:RequiredFieldValidator></td></tr><tr><td align="left" colspan="2" valign="top" class="dataentryformlabelbig"><asp:Label ID="Label10" Runat="server" SkinID="FormGroupLabel" Text="Covering Letter Template :"></asp:Label></td></tr><tr><td align="right" colspan="2" valign="top"> <asp:TextBox ID="txtCoveringLetter" Runat="server" Rows="15" TextMode="MultiLine" Width="98%"></asp:TextBox></td></tr><tr><td align="center" colspan="2" width="10%"><asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/SaveButton.gif" onclick="ImageButton1_Click" /> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/Images/CancelButton.gif" onclick="ImageButton2_Click" /> </td></tr><tr><td align="center" colspan="2" width="10%"><asp:Label ID="lblMsg" runat="server" SkinID="FormLabel"></asp:Label></td></tr><tr><td align="center" colspan="2" width="10%"><asp:ValidationSummary ID="ValidationSummary1" Runat="server" /></td></tr></table></contenttemplate></asp:UpdatePanel><asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"><progresstemplate> <center><asp:Image ID="Image1" runat="server" ImageUrl="~/images/progress.gif" /></center></progresstemplate></asp:UpdateProgress><br /> <br /> </asp:Content>PostResume.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class postresume_aspx : Page{ private Resume r; protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["jobseekerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { if (Profile.JobSeeker.ResumeID != -1) { r = Resume.GetResume(Profile.UserName); txtJobTitle.Text = r.JobTitle; txtCity.Text = r.City; txtResume.Text = r.ResumeText; txtCoveringLetter.Text = r.CoveringLetterText; } FillCountries(); FillEduLevels(); FillExpLevels(); FillJobTypes(); FillStates(); } } private void FillCountries() { ddlCountry.DataSource = Country.GetCountries(); ddlCountry.DataTextField = "CountryName"; ddlCountry.DataValueField = "CountryID"; ddlCountry.DataBind(); ddlRelocationCountry.DataSource = Country.GetCountries(); ddlRelocationCountry.DataTextField = "CountryName"; ddlRelocationCountry.DataValueField = "CountryID"; ddlRelocationCountry.DataBind(); if (Profile.JobSeeker.ResumeID != -1) { ListItem li; li = ddlCountry.Items.FindByValue(r.CountryID.ToString()); if (li != null) { ddlCountry.ClearSelection(); li.Selected = true; } li = ddlRelocationCountry.Items.FindByValue(r.RelocationCountryID.ToString()); if (li != null) { ddlRelocationCountry.ClearSelection(); li.Selected = true; } } } private void FillStates() { r = Resume.GetResume(Profile.UserName); ddlState.DataSource = State.GetStates(int.Parse(ddlCountry.SelectedValue)); ddlState.DataTextField = "StateName"; ddlState.DataValueField = "StateID"; ddlState.DataBind(); if (Profile.JobSeeker.ResumeID != -1) { ListItem li; li = ddlState.Items.FindByValue(r.StateID.ToString()); if (li != null) { ddlState.ClearSelection(); li.Selected = true; } } } private void FillJobTypes() { ddlJobType.DataSource = JobType.GetJobTypes(); ddlJobType.DataTextField = "JobTypeName"; ddlJobType.DataValueField = "JobTypeID"; ddlJobType.DataBind(); if (Profile.JobSeeker.ResumeID != -1) { ListItem li; li = ddlJobType.Items.FindByValue(r.JobTypeID.ToString()); if (li != null) { ddlJobType.ClearSelection(); li.Selected = true; } } } private void FillEduLevels() { ddlEduLevel.DataSource = EducationLevel.GetEducationLevels(); ddlEduLevel.DataTextField = "EducationLevelName"; ddlEduLevel.DataValueField = "EducationLevelID"; ddlEduLevel.DataBind(); if (Profile.JobSeeker.ResumeID != -1) { ListItem li; li = ddlEduLevel.Items.FindByValue(r.EducationLevelID.ToString()); if (li != null) { ddlEduLevel.ClearSelection(); li.Selected = true; } } } private void FillExpLevels() { ddlExpLevel.DataSource = ExperienceLevel.GetExperienceLevels(); ddlExpLevel.DataTextField = "ExperienceLevelName"; ddlExpLevel.DataValueField = "ExperienceLevelID"; ddlExpLevel.DataBind(); if (Profile.JobSeeker.ResumeID != -1) { ListItem li; li = ddlExpLevel.Items.FindByValue(r.ExperienceLevelID.ToString()); if (li != null) { ddlExpLevel.ClearSelection(); li.Selected = true; } } } protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { FillStates(); } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Resume r = new Resume(); r.City = txtCity.Text; r.CountryID = int.Parse(ddlCountry.SelectedValue); r.CoveringLetterText = txtCoveringLetter.Text; r.EducationLevelID = int.Parse(ddlEduLevel.SelectedValue); r.ExperienceLevelID = int.Parse(ddlExpLevel.SelectedValue); r.JobTitle = txtJobTitle.Text; r.JobTypeID = int.Parse(ddlJobType.SelectedValue); r.RelocationCountryID = int.Parse(ddlRelocationCountry.SelectedValue); r.ResumeText = txtResume.Text; r.StateID = int.Parse(ddlState.SelectedValue); r.UserName = Profile.UserName; r.PostedDate = DateTime.Now; if (Profile.JobSeeker.ResumeID != -1) { r.ResumeID = Profile.JobSeeker.ResumeID; Resume.Update(r); } else { int retval = Resume.Insert(r); Profile.JobSeeker.ResumeID = retval; } lblMsg.Text = "Your resume is successfully updated!"; } protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { Response.Redirect("~/default.aspx"); }}ViewJobPosting.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" CodeFile="viewjobposting.aspx.cs" Inherits="viewjobposting_aspx" Title="Untitled Page" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div style="text-align: center"> <div align="center"> <asp:Label ID="Label14" Runat="server" Text="View Job Posting" SkinID="FormHeading"></asp:Label> </div> <br /> <table style="width: 100%" cellpadding="3"><tr> <td align="left" width="20%" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label16" Runat="server" Text="Contact Details" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label1" Runat="server" Text="Company :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblCompany" Runat="server" Text="Label"></asp:Label> <asp:LinkButton ID="btnViewProfile" runat="server">[View Profile]</asp:LinkButton></td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label2" Runat="server" Text="Contact Person :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblContactPerson" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="left" width="20%" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label17" Runat="server" Text="Job Details" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label3" Runat="server" Text="Job Title :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblTitle" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap valign="top"> <asp:Label ID="Label13" Runat="server" Text="Description :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblDesc" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label9" Runat="server" Text="Job Type :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblJobType" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label4" Runat="server" Text="Department :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblDept" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label5" Runat="server" Text="Job Code :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblJobCode" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label10" Runat="server" Text="Education Level :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblEduLevel" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="left" width="20%" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label18" Runat="server" Text="Location" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label6" Runat="server" Text="City :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblCity" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label7" Runat="server" Text="State :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblState" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label8" Runat="server" Text="Country :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblCountry" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="left" width="20%" colspan="2" class="dataentryformlabelbig"> <asp:Label ID="Label19" Runat="server" Text="Salary Details" SkinID="FormGroupLabel"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label11" Runat="server" Text="Min. Salary :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblMinSal" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label12" Runat="server" Text="Max. Salary :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblMaxSal" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="right" width="20%"> </td> <td align="left"> </td> </tr> <tr> <td align="right" width="20%" nowrap> <asp:Label ID="Label15" Runat="server" Text="Posting Date :" SkinID="FormLabel"></asp:Label> </td> <td align="left"> <asp:Label ID="lblPostDt" Runat="server" Text="Label"></asp:Label> </td> </tr> <tr> <td align="center" width="20%" nowrap colspan="2"> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/BackButton.gif" onclick="ImageButton1_Click" /> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/Images/MyFavorite.gif" onclick="ImageButton2_Click" /> </td> </tr></table> <br /><br /><br /><div align="left"><asp:Panel ID="Panel1" runat="server" SkinID="CompanyProfilePanel"> <asp:Label ID="Label20" runat="server" Text=""></asp:Label><br /><div align="right" width="100%"><asp:LinkButton ID="LinkButton1" runat="server" Font-Bold="True">Close</asp:LinkButton></div></asp:Panel></div><br /><cc1:ModalPopupExtender ID="ModalPopupExtender1" runat="server" TargetControlID="btnViewProfile" PopupControlID="Panel1" DynamicControlID="Label20" DynamicServicePath='<%# Page.ResolveClientUrl("~/WebService.asmx") %>' DynamicServiceMethod="GetCompanyProfile"OkControlID="LinkButton1"></cc1:ModalPopupExtender><br /><br /> </div></asp:Content>ViewJobPosting.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class viewjobposting_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["jobseekerrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (!Page.IsPostBack) { int postingid; postingid = int.Parse(Request.QueryString["id"]); JobPosting p=JobPosting.GetPosting(postingid); lblCity.Text = p.City; lblCompany.Text = Company.GetCompanyName(panyID); mandArgument=panyID.ToString(); ModalPopupExtender1.DynamicContextKey=panyID.ToString(); lblContactPerson.Text = p.ContactPerson; lblCountry.Text = Country.GetCountryName(p.CountryID); lblDept.Text = p.Department; lblDesc.Text = p.Description.Replace("\r\n","<br>"); lblEduLevel.Text = EducationLevel.GetEducationLevelName(p.EducationLevelID); lblJobCode.Text = p.JobCode; lblJobType.Text = JobType.GetJobTypeName(p.JobTypeID); lblMaxSal.Text = p.MaxSalary.ToString("C"); lblMinSal.Text = p.MinSalary.ToString("C"); lblPostDt.Text = p.PostingDate.ToShortDateString(); lblState.Text = State.GetStateName(p.StateID); lblTitle.Text = p.Title; } Page.DataBind(); } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Response.Redirect("~/jobseeker/jobsearch.aspx"); } protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { MyJob j = new MyJob(); j.PostingID = int.Parse(Request.QueryString["id"]); j.UserName = Profile.UserName; MyJob.Insert(j); }}CustomErrorPage.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="NotAuthorized.aspx.cs" Inherits="CustomErrorPages_NotAuthorized" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><center> <asp:Label ID="Label14" runat="server" SkinID="FormHeading" Text="You are not authorized to view this page!"></asp:Label><br /><br /> <asp:Label ID="Label1" runat="server" Text="You may not have appropriate access rights to view this page." SkinID="ErrorLabel"></asp:Label><br /><br /> <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/default.aspx">Go to Home Page</asp:HyperLink><br /></center> </asp:Content>ProfileNotFound.aspx<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="profilenotfound.aspx.cs" Inherits="CustomErrorPages_profilenotfound" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><center> <asp:Label ID="Label14" runat="server" SkinID="FormHeading" Text="Company Profile Not Found!"></asp:Label><br /><br /> <asp:Label ID="Label1" runat="server" Text="You can add job postings only after filling your company profile. Your company profile was not found. Please click on the following link to fill your company profile." SkinID="ErrorLabel"></asp:Label><br /><br /> <asp:HyperLink ID="HyperLink1" runat="server">Fill Company Profile</asp:HyperLink><br /></center> </asp:Content>ProfileNotFound.aspx.csusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class CustomErrorPages_profilenotfound : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { HyperLink1.NavigateUrl = "~/employer/companyprofile.aspx"; }}HoverButton.jsType.registerNamespace("JSSK");JSSK.HoverButton=function(imgId,anchorId,baseImage,navigateUrl){ this._elementId=imgId; this._baseImage=baseImage; $get(anchorId).href=navigateUrl; var element=$get(this._elementId); element.border=0; element.onmouseover=Function.createDelegate(this,this.SetHover); element.onmouseout=Function.createDelegate(this,this.SetNormal); element.onmousedown=Function.createDelegate(this,this.SetPressed); element.onmouseup=Function.createDelegate(this,this.SetNormal); this.SetNormal(); }JSSK.HoverButton.prototype={ SetNormal:function() { var element=$get(this._elementId); element.src=this._baseImage + "N.jpg" }, SetPressed:function() { var element=$get(this._elementId); element.src=this._baseImage + "P.jpg" }, SetHover:function() { var element=$get(this._elementId); element.src=this._baseImage + "H.jpg" }}JSSK.HoverButton.registerClass("JSSK.HoverButton");Membership.jsType.registerNamespace("JSSK");JSSK.Membership=function(){ this._waitId=""; this._waitmsg=null;}JSSK.Membership.prototype={ get_WaitLabelId:function() { return this._waitId; }, set_WaitLabelId:function(value) { this._waitId=value; }, BeginLogin:function(uid,pwd,rememberme) { this._waitmsg=new JSSK.ProgressMessage(this._waitId); this._waitmsg.ShowMessage("Signing in..."); Sys.Services.AuthenticationService.login(uid,pwd,rememberme,null,null,Function.createDelegate(this,this.EndLogin),Function.createDelegate(this,this.OnError),null); }, EndLogin:function(result,context,methodname) { if(result) { this.BeginRoleLoad(); } else { this._waitmsg.HideMessage(); alert("Invalid User ID or Password!"); } }, BeginLogout:function() { }, EndLogout:function(result,context,methodname) { }, BeginRoleLoad:function() { Sys.Services.RoleService.load(Function.createDelegate(this,this.EndRoleLoad),Function.createDelegate(this,this.OnError)); }, EndRoleLoad:function(result) { if(this.IsUserInRole("jobseeker")) { window.location.href="jobseeker/jobsearch.aspx"; } if(this.IsUserInRole("employer")) { window.location.href="employer/addeditposting.aspx"; } if(this.IsUserInRole("admin")) { window.location.href="admin/default.aspx"; } }, IsUserInRole:function(roleName) { return Sys.Services.RoleService.isUserInRole(roleName); }, OnError:function(result,context,methodname) { waitmsg.HideMessage(); alert(err.get_message()); }}JSSK.Membership.registerClass("JSSK.Membership");ProgressMessage.jsType.registerNamespace("JSSK");JSSK.ProgressMessage=function(id){ this._elementId=id; var element=$get(this._elementId); element.className="waitmessage"; element.style.position="absolute"; element.style.left=0; element.=0;}JSSK.ProgressMessage.prototype={ ShowMessage:function(message) { var element=$get(this._elementId); if(element.innerText) { element.innerText=message; } else { element.textContent=message; } element.style.visibility="visible"; }, HideMessage:function() { var element=$get(this._elementId); element.style.visibility="hidden"; }}JSSK.ProgressMessage.registerClass("JSSK.ProgressMessage");AJAXNavigation.aspx<%@ Control Language="C#" AutoEventWireup="true" CodeFile="AJAXNavigation.ascx.cs" Inherits="UserControls_AJAXNavigation" %><asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server"> <scripts> <asp:scriptreference Path="~/Scripts/HoverButton.js" /> </scripts></asp:ScriptManagerProxy><script type="text/javascript"> function pageLoad() { var path=window.location.pathname; path=path.substring(0,path.lastIndexOf("/")); path=path.replace("jobseeker",""); path=path.replace("employer",""); path=path.replace("admin",""); path=path.replace("customerrorpages",""); path = path + "/"; path=path.replace("//","/"); $get("tab1").src=path + "images/memberstab.jpg"; $get("tab2").src=path + "images/jobseekerstab.jpg"; $get("tab3").src=path + "images/employerstab.jpg"; var img1=new JSSK.HoverButton('img1','url1', path + 'images/login',path + 'login.aspx'); var img2=new JSSK.HoverButton('img2','url2',path + 'images/register',path + 'register.aspx'); var img3=new JSSK.HoverButton('img3','url3',path + 'images/changepassword',path + 'changepassword.aspx'); var img4=new JSSK.HoverButton('img4','url4',path +'images/postresume',path + 'jobseeker/postresume.aspx'); var img5=new JSSK.HoverButton('img5','url5',path +'images/searchjobs',path + 'jobseeker/jobsearch.aspx'); var img6=new JSSK.HoverButton('img6','url6',path +'images/favorites',path + 'jobseeker/MyFavorites.aspx'); var img7=new JSSK.HoverButton('img7','url7',path +'images/postjobs',path + 'employer/jobpostings.aspx'); var img8=new JSSK.HoverButton('img8','url8',path +'images/searchresumes',path + 'employer/resumesearch.aspx'); var img9=new JSSK.HoverButton('img9','url9',path +'images/companyprofile',path + 'employer/companyprofile.aspx'); var img10=new JSSK.HoverButton('img10','url10',path +'images/favorites',path + 'employer/MyFavorites.aspx'); }</script><img id="tab1" src="images/MembersTab.jpg" /><a id='url1'><img id='img1' /></a><br /><a id='url2'><img id='img2' /></a><br /><a id='url3'><img id='img3' /></a><br /><br /><img id="tab2" src="images/JobSeekersTab.jpg" /><a id='url4'><img id='img4' /></a><br /><a id='url5'><img id='img5' /></a><br /><a id='url6'><img id='img6' /></a><br /><br /><img id="tab3" src="images/EmployersTab.jpg" /><a id='url7'><img id='img7' /></a><br /><a id='url8'><img id='img8' /></a><br /><a id='url9'><img id='img9' /></a><br /><a id='url10'><img id='img10' /></a><br /><br />AJAXNavigationAdmin.aspx<%@ Control Language="C#" AutoEventWireup="true" CodeFile="AJAXNavigationAdmin.ascx.cs" Inherits="UserControls_AJAXNavigationAdmin" %><asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server"> <scripts> <asp:scriptreference Path="~/Scripts/HoverButton.js" /> </scripts></asp:ScriptManagerProxy><script type="text/javascript"> function pageLoad() { var path=window.location.pathname; path=path.substring(0,path.lastIndexOf("/")); path=path.replace("jobseeker",""); path=path.replace("employer",""); path=path.replace("admin",""); path=path.replace("CustomErrorPages"); path = path + "/"; path=path.replace("//","/"); $get("tab4").src=path + "images/administrationtab.jpg"; var img11=new JSSK.HoverButton('img11','url11',path +'images/edulevel',path + 'admin/educationlevelsmanager.aspx'); var img12=new JSSK.HoverButton('img12','url12',path +'images/explevel',path + 'admin/ExperienceLevelManager.aspx'); }</script><img id="tab4" src="images/AdministrationTab.jpg" /><a id='url11'><img id='img11' /></a><br /><a id='url12'><img id='img12' /></a><br />DisplayModeController.aspx<%@ Control Language="C#" AutoEventWireup="true" CodeFile="DisplayModeController.ascx.cs" Inherits="LayoutController" %><asp:Label ID="Label1" runat="server" Text="Customize MyFavorites :" ></asp:Label><asp:DropDownList ID="DisplayModeDropdown" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DisplayModeDropdown_SelectedIndexChanged1"></asp:DropDownList>DisplayModeController.aspx.csusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class LayoutController : System.Web.UI.UserControl{ WebPartManager manager; void Page_Init(object sender, EventArgs e) { Page.InitComplete += new EventHandler(InitComplete); } void InitComplete(object sender, System.EventArgs e) { manager = WebPartManager.GetCurrentWebPartManager(Page); String browseModeName = WebPartManager.BrowseDisplayMode.Name; foreach (WebPartDisplayMode mode in manager.SupportedDisplayModes) { String modeName = mode.Name; if (mode.IsEnabled(manager)) { ListItem item = new ListItem(modeName, modeName); DisplayModeDropdown.Items.Add(item); } } } protected void DisplayModeDropdown_SelectedIndexChanged1(object sender, EventArgs e) { String selectedMode = DisplayModeDropdown.SelectedValue; WebPartDisplayMode mode = manager.SupportedDisplayModes[selectedMode]; if (mode != null) manager.DisplayMode = mode; } protected void Page_Load(object sender, EventArgs e) { }}LatestJobs.aspx<%@ Control Language="C#" CodeFile="LatestJobs.ascx.cs" Inherits="LatestJobs_ascx" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %><asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server"><services><asp:servicereference Path="~/webservice.asmx" /></services></asp:ScriptManagerProxy><asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateColumns="False" Width="100%" DataKeyNames="PostingID" onrowdatabound="GridView1_RowDataBound" > <Columns> <asp:templatefield><itemtemplate> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/showdetails.jpg" ToolTip="Click here for more details" /><asp:Panel ID="pnlMsg" runat="server"></asp:Panel><cc1:PopupControlExtender ID="PopupControlExtender1" runat="server" DynamicContextKey='<%# Eval("PostingId") %>' DynamicControlID="Panel1" DynamicServiceMethod="GetToolTipText" PopupControlID="Panel1" TargetControlID="ImageButton1" Position="Left" ></cc1:PopupControlExtender></itemtemplate><itemstyle verticalalign="Top" width="5%" /></asp:templatefield> <asp:HyperLinkField HeaderText="Latest Jobs!!" NavigateUrl="~/jobseeker/viewjobposting.aspx?id=" DataNavigateUrlFields="postingid" DataNavigateUrlFormatString="~/jobseeker/viewjobposting.aspx?id={0}" DataTextField="Title"> <itemstyle horizontalalign="Left" /> </asp:HyperLinkField> </Columns></asp:GridView><asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.JobPosting" SelectMethod="GetLatest"></asp:ObjectDataSource><asp:Panel ID="Panel1" runat="server" SkinID="TooltipPanel" HorizontalAlign="Left"></asp:Panel>LatestJobs.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Web.Services;using JobSiteStarterKit.BOL;using System.Web.Script.Services;using AjaxControlToolkit;public partial class LatestJobs_ascx:UserControl{ protected void Page_Load(object sender, EventArgs e) { if (GridView1.Rows.Count == 0) { Panel1.Visible = false; } } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if(e.Row.RowType==DataControlRowType.DataRow) { PopupControlExtender popup=(PopupControlExtender)e.Row.FindControl("PopupControlExtender1"); popup.DynamicServicePath = "~/webservice.asmx"; } }}MyJobs.aspx<%@ Control Language="C#" CodeFile="MyJobs.ascx.cs" Inherits="MyJobs_ascx" %><asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateColumns="False" Width="100%" DataKeyNames="MyJobID"> <Columns> <asp:HyperLinkField Text="View" DataNavigateUrlFields="postingid" DataNavigateUrlFormatString="~/jobseeker/viewjobposting.aspx?id={0}"></asp:HyperLinkField> <asp:BoundField HeaderText="Date" DataField="PostingDate" DataFormatString="{0:MM/dd/yyyy}"></asp:BoundField> <asp:BoundField HeaderText="Title" DataField="Title"></asp:BoundField> <asp:BoundField HeaderText="Location" DataField="City"></asp:BoundField> <asp:BoundField HeaderText="Company" DataField="CompanyName"></asp:BoundField> <asp:CommandField ShowDeleteButton="True"></asp:CommandField> </Columns></asp:GridView><br /><asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.MyJob" DeleteMethod="Delete" SelectMethod="GetMyJobs" DataObjectTypeName="JobSiteStarterKit.BOL.MyJob"> <SelectParameters> <asp:ProfileParameter Name="username" Type="String" PropertyName="UserName"></asp:ProfileParameter> </SelectParameters></asp:ObjectDataSource>MyResume.aspx<%@ Control Language="C#" CodeFile="MyResumes.ascx.cs" Inherits="MyResumes_ascx" %><asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateColumns="False" Width="100%" DataKeyNames="MyResumeID"> <Columns> <asp:HyperLinkField Text="View" DataNavigateUrlFields="resumeid" DataNavigateUrlFormatString="~/employer/viewresume.aspx?id={0}"></asp:HyperLinkField> <asp:BoundField HeaderText="Title" DataField="JobTitle"></asp:BoundField> <asp:BoundField HeaderText="Education" DataField="EducationLevelName"></asp:BoundField> <asp:BoundField HeaderText="Experience" DataField="ExperienceLevelName"></asp:BoundField> <asp:BoundField HeaderText="Location" DataField="TargetCity"></asp:BoundField> <asp:CommandField ShowDeleteButton="True"></asp:CommandField> </Columns></asp:GridView><br /><asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.MyResume" DeleteMethod="Delete" SelectMethod="GetMyResumes" DataObjectTypeName="JobSiteStarterKit.BOL.MyResume"> <SelectParameters> <asp:ProfileParameter Name="username" Type="String" PropertyName="UserName"></asp:ProfileParameter> </SelectParameters></asp:ObjectDataSource>MySearches.aspx<%@ Control Language="C#" CodeFile="MySearches.ascx.cs" Inherits="MySearches_ascx" %><asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateColumns="False" Width="100%" DataKeyNames="MySearchID"> <Columns> <asp:HyperLinkField Text="View" DataNavigateUrlFields="mysearchid" DataNavigateUrlFormatString="~/jobseeker/jobsearch.aspx?mysearchid={0}"></asp:HyperLinkField> <asp:BoundField HeaderText="Criteria" DataField="SearchCriteria"></asp:BoundField> <asp:BoundField HeaderText="Country" DataField="countryname"></asp:BoundField> <asp:BoundField HeaderText="State" DataField="statename"></asp:BoundField> <asp:BoundField HeaderText="City" DataField="city"></asp:BoundField> <asp:CommandField ShowDeleteButton="True"></asp:CommandField> </Columns></asp:GridView><br /><asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.MySearch" DeleteMethod="Delete" SelectMethod="GetMySearches" DataObjectTypeName="JobSiteStarterKit.BOL.MySearch"> <SelectParameters> <asp:ProfileParameter Name="username" Type="String" PropertyName="UserName"></asp:ProfileParameter> </SelectParameters></asp:ObjectDataSource>Statistics.aspx<%@ Control Language="C#" CodeFile="Statistics.ascx.cs" Inherits="Statistics_ascx" %><table cellspacing="0" cellpadding="5" border="1"> <tr> <td nowrap="nowrap" align="center" colspan="2" > <asp:Label ID="Label4" Text="Jobs/Resumes Stats" Runat="server" SkinID="FormLabel"></asp:Label> </td> </tr> <tr> <td nowrap="nowrap" align="right" width="50%"> <asp:Label ID="Label1" Text="Total Jobs :" Runat="server" SkinID="FormLabel"></asp:Label> </td> <td align="left" width="50%"> <asp:Label ID="lblJobs" Text="Label" Runat="server" SkinID="FormLabel"></asp:Label> </td> </tr> <tr> <td nowrap="nowrap" align="right" width="50%"> <asp:Label ID="Label2" Text="Total Resumes :" Runat="server" SkinID="FormLabel"></asp:Label> </td> <td align="left" width="50%"> <asp:Label ID="lblResumes" Text="Label" Runat="server" SkinID="FormLabel"></asp:Label> </td> </tr> <tr> <td nowrap="nowrap" align="right" width="50%"> <asp:Label ID="Label3" Text="Total Companies :" Runat="server" SkinID="FormLabel"></asp:Label> </td> <td align="left" width="50%"> <asp:Label ID="lblCompanies" Text="Label" Runat="server" SkinID="FormLabel"></asp:Label> </td> </tr></table>Statistics.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using JobSiteStarterKit.BOL;public partial class Statistics_ascx : UserControl{ protected void Page_Load(object sender, EventArgs e) { lblCompanies.Text = Company.GetCompanyCount().ToString(); lblJobs.Text = JobPosting.GetJobPostingCount().ToString(); lblResumes.Text = Resume.GetResumeCount().ToString(); }}ChangePassword.aspx<%@ Page Language="C#" CodeFile="changepassword.aspx.cs" Inherits="changeregistrationinfo_aspx" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div align=center> <asp:Label ID="Label1" Runat="server" Text="Change your password!" SkinID="FormHeading"></asp:Label> <br /><br /><asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><asp:ChangePassword ID="ChangePassword1" Runat="server" ContinueDestinationPageUrl="~/default.aspx" OnContinueClick="ChangePassword1_ContinueClick"></asp:ChangePassword></contenttemplate></asp:UpdatePanel> <asp:updateprogress ID="UpdateProgress1" runat="server"> <ProgressTemplate> <asp:Label runat="server" Text="Please Wait..." > </asp:Label> </ProgressTemplate> </asp:updateprogress></div></asp:Content>ChangePassword.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class changeregistrationinfo_aspx : Page{ protected void ChangePassword1_ContinueClick(object sender, EventArgs e) { Response.Redirect("~/default.aspx"); }}EducationLevelManager.aspx<%@ Page Language="C#" MasterPageFile="~/AdminMasterPage.master" CodeFile="EducationLevelsManager.aspx.cs" Inherits="EducationLevelsManager_aspx" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div align="center"> <asp:Label ID="Label14" Runat="server" SkinID="FormHeading" Text="Education Levels Manager"></asp:Label> <br /> <br /> <asp:DetailsView ID="DetailsView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateRows="False" DataKeyNames="EducationLevelID" GridLines="None" CellPadding="5" SkinID="AdminEntry"> <PagerSettings Mode="NumericFirstLast"></PagerSettings> <CommandRowStyle HorizontalAlign="Left"></CommandRowStyle> <Fields> <asp:CommandField ButtonType="Image" ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True" CancelImageUrl="~/Images/CancelButton.gif" DeleteImageUrl="~/Images/DeleteButton.gif" EditImageUrl="~/Images/EditButton.gif" InsertImageUrl="~/Images/SaveButton.gif" NewImageUrl="~/Images/AddButton.gif" UpdateImageUrl="~/Images/SaveButton.gif"></asp:CommandField> <asp:BoundField HeaderText="Education Level ID :" DataField="educationlevelid" ReadOnly="True" InsertVisible="False"> <ItemStyle HorizontalAlign="Left"></ItemStyle> <HeaderStyle CssClass="dataentryformlabel"></HeaderStyle> </asp:BoundField> <asp:BoundField HeaderText="Education Level Name :" DataField="educationlevelname"> <HeaderStyle CssClass="dataentryformlabel"></HeaderStyle> </asp:BoundField> </Fields> <FieldHeaderStyle HorizontalAlign="Right"></FieldHeaderStyle> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <EditRowStyle HorizontalAlign="Left"></EditRowStyle> </asp:DetailsView><br /> <asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.EducationLevel" DataObjectTypeName="JobSiteStarterKit.BOL.EducationLevel" DeleteMethod="Delete" InsertMethod="Insert" SelectMethod="GetEducationLevels" UpdateMethod="Update"> </asp:ObjectDataSource></div></asp:Content>EducationLevelManager.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class EducationLevelsManager_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["adminrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (DetailsView1.Rows.Count < 1) { DetailsView1.DefaultMode = DetailsViewMode.Insert; } else { DetailsView1.DefaultMode = DetailsViewMode.ReadOnly; } }}ExperienceLevelManager.aspx<%@ Page Language="C#" MasterPageFile="~/AdminMasterPage.master" CodeFile="ExperienceLevelManager.aspx.cs" Inherits="ExperienceLevelManager_aspx" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"> <div align=center> <asp:Label ID="Label14" Runat="server" SkinID="FormHeading" Text="Experience Levels Manager"></asp:Label><br /> <br /> <asp:DetailsView ID="DetailsView1" Runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateRows="False" GridLines="None" CellPadding="5" DataKeyNames="ExperienceLevelID" SkinID="AdminEntry" OnDataBound="DetailsView1_DataBound" OnDataBinding="DetailsView1_DataBinding"> <PagerSettings Mode="NumericFirstLast"></PagerSettings> <CommandRowStyle HorizontalAlign="Left"></CommandRowStyle> <Fields> <asp:CommandField ButtonType="Image" ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True" CancelImageUrl="~/Images/CancelButton.gif" DeleteImageUrl="~/Images/DeleteButton.gif" EditImageUrl="~/Images/EditButton.gif" InsertImageUrl="~/Images/SaveButton.gif" NewImageUrl="~/Images/AddButton.gif" UpdateImageUrl="~/Images/SaveButton.gif"></asp:CommandField> <asp:BoundField ReadOnly="True" HeaderText="Experience Level ID :" InsertVisible="False" DataField="experiencelevelid"> <ItemStyle HorizontalAlign="Left"></ItemStyle> </asp:BoundField> <asp:BoundField HeaderText="Experience Level Name :" DataField="experiencelevelname"> <ItemStyle HorizontalAlign="Left"></ItemStyle> </asp:BoundField> </Fields> <FieldHeaderStyle HorizontalAlign="Right"></FieldHeaderStyle> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <EditRowStyle HorizontalAlign="Left"></EditRowStyle> </asp:DetailsView><br /> <asp:ObjectDataSource ID="ObjectDataSource1" Runat="server" TypeName="JobSiteStarterKit.BOL.ExperienceLevel" DataObjectTypeName="JobSiteStarterKit.BOL.ExperienceLevel" DeleteMethod="Delete" InsertMethod="Insert" SelectMethod="GetExperienceLevels" UpdateMethod="Update" OnSelected="ObjectDataSource1_Selected"> </asp:ObjectDataSource> </div> </asp:Content>ExperienceLevelManager.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class ExperienceLevelManager_aspx : Page{ protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["adminrolename"])) { Response.Redirect("~/customerrorpages/NotAuthorized.aspx"); } if (DetailsView1.Rows.Count < 1) { DetailsView1.DefaultMode = DetailsViewMode.Insert; } else { DetailsView1.DefaultMode = DetailsViewMode.ReadOnly; } } protected void DetailsView1_DataBound(object sender, EventArgs e) { } protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e) { } protected void DetailsView1_DataBinding(object sender, EventArgs e) { }}Company.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using JobSiteStarterKit.DAL;using System.Data;using System.Data.SqlClient;#endregionnamespace JobSiteStarterKit.BOL{ public class Company { private int intCompanyID; private string strUserName; private string strCompanyName; private string strBriefProfile; private string strAddress1; private string strAddress2; private string strCity; private int intStateID; private int intCountryID; private string strZIP; private string strPhone; private string strFax; private string strEmail; private string strWebSiteUrl; public int CompanyID { get { return intCompanyID; } set { intCompanyID = value; } } public string UserName { get { return strUserName; } set { strUserName = value; } } public string CompanyName { get { return strCompanyName; } set { strCompanyName = value; } } public string BriefProfile { get { return strBriefProfile; } set { strBriefProfile = value; } } public string Address1 { get { return strAddress1; } set { strAddress1 = value; } } public string Address2 { get { return strAddress2; } set { strAddress2 = value; } } public string City { get { return strCity; } set { strCity = value; } } public int StateID { get { return intStateID; } set { intStateID = value; } } public int CountryID { get { return intCountryID; } set { intCountryID = value; } } public string ZIP { get { return strZIP; } set { strZIP = value; } } public string Phone { get { return strPhone; } set { strPhone = value; } } public string Fax { get { return strFax; } set { strFax = value; } } public string Email { get { return strEmail; } set { strEmail = value; } } public string WebSiteUrl { get { return strWebSiteUrl; } set { strWebSiteUrl = value; } } public static int Insert(Company c) { DBAccess db = new DBAccess(); SqlParameter objParam = new SqlParameter("@iCompanyID",0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@sUserName", c.UserName)); db.Parameters.Add(new SqlParameter("@sCompanyName", panyName)); db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1)); db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2)); db.Parameters.Add(new SqlParameter("@sCity", c.City)); db.Parameters.Add(new SqlParameter("@iStateID", c.StateID)); db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID)); db.Parameters.Add(new SqlParameter("@sZip", c.ZIP)); db.Parameters.Add(new SqlParameter("@sPhone", c.Phone)); db.Parameters.Add(new SqlParameter("@sFax", c.Fax)); db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email)); db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl)); db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile)); db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery("JobsDb_Companies_Insert"); if (retval == 1) { return int.Parse(objParam.Value.ToString()); } else { return -1; } } public static int Update(Company c) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@iCompanyID", panyID)); db.Parameters.Add(new SqlParameter("@sUserName", c.UserName)); db.Parameters.Add(new SqlParameter("@sCompanyName", panyName)); db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1)); db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2)); db.Parameters.Add(new SqlParameter("@sCity", c.City)); db.Parameters.Add(new SqlParameter("@iStateID", c.StateID)); db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID)); db.Parameters.Add(new SqlParameter("@sZip", c.ZIP)); db.Parameters.Add(new SqlParameter("@sPhone", c.Phone)); db.Parameters.Add(new SqlParameter("@sFax", c.Fax)); db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email)); db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl)); db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile)); int retval = db.ExecuteNonQuery("JobsDb_Companies_Update"); return retval; } public static Company GetCompany(string username) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@sUserName", username)); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Companies_SelectByUserName"); if (dr.HasRows) { Company c = new Company(); while (dr.Read()) { panyID = dr.GetInt32(dr.GetOrdinal("companyid")); panyName = dr.GetString(dr.GetOrdinal("CompanyName")); c.BriefProfile = dr.GetString(dr.GetOrdinal("CompanyProfile")); c.WebSiteUrl = dr.GetString(dr.GetOrdinal("WebSiteUrl")); c.Address1 = dr.GetString(dr.GetOrdinal("Address1")); c.Address2 = dr.GetString(dr.GetOrdinal("Address2")); c.City = dr.GetString(dr.GetOrdinal("City")); c.StateID = dr.GetInt32(dr.GetOrdinal("StateID")); c.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID")); c.ZIP = dr.GetString(dr.GetOrdinal("ZIP")); c.Phone = dr.GetString(dr.GetOrdinal("Phone")); c.Fax = dr.GetString(dr.GetOrdinal("Fax")); c.Email = dr.GetString(dr.GetOrdinal("CompanyEmail")); c.UserName = dr.GetString(dr.GetOrdinal("UserName")); } dr.Close(); return c; } else { dr.Close(); return null; } } public static Company GetCompany(int companyid) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@iCompanyID", companyid)); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Companies_SelectOne"); if (dr.HasRows) { Company c = new Company(); while (dr.Read()) { panyID = dr.GetInt32(dr.GetOrdinal("companyid")); panyName = dr.GetString(dr.GetOrdinal("CompanyName")); c.BriefProfile = dr.GetString(dr.GetOrdinal("CompanyProfile")); c.WebSiteUrl = dr.GetString(dr.GetOrdinal("WebSiteUrl")); c.Address1 = dr.GetString(dr.GetOrdinal("Address1")); c.Address2 = dr.GetString(dr.GetOrdinal("Address2")); c.City = dr.GetString(dr.GetOrdinal("City")); c.StateID = dr.GetInt32(dr.GetOrdinal("StateID")); c.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID")); c.ZIP = dr.GetString(dr.GetOrdinal("ZIP")); c.Phone = dr.GetString(dr.GetOrdinal("Phone")); c.Fax = dr.GetString(dr.GetOrdinal("Fax")); c.Email = dr.GetString(dr.GetOrdinal("CompanyEmail")); c.UserName = dr.GetString(dr.GetOrdinal("UserName")); } dr.Close(); return c; } else { dr.Close(); return null; } } public static string GetCompanyName(int companyid) { DBAccess db = new DBAccess(); db.AddParameter("@iCompanyID", companyid); return (string)db.ExecuteScalar("JobsDb_Companies_SelectName"); } public static int GetCompanyCount() { DBAccess db = new DBAccess(); return (int)db.ExecuteScalar("JobsDb_Companies_GetCount"); } }}Country.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using JobSiteStarterKit.DAL;using System.Data.SqlClient;#endregionnamespace JobSiteStarterKit.BOL{ public class Country { public Country() { } private string strCountryName; private int intCountryID; public string CountryName { get { return strCountryName; } set { strCountryName = value; } } public int CountryID { get { return intCountryID; } set { intCountryID = value; } } public int InsertCountry(Country c) { DBAccess db = new DBAccess(); SqlParameter p = new SqlParameter("@iCountryID", 0); p.Direction = ParameterDirection.Output; db.AddParameter("@sCountryName", c.CountryName); db.AddParameter(p); return db.ExecuteNonQuery("JobsDb_Countries_Insert"); } public int UpdateCountry(Country c) { DBAccess db = new DBAccess(); db.AddParameter("@iCountryID", c.CountryID); db.AddParameter("@sCountryName", c.CountryName); return db.ExecuteNonQuery("JobsDb_Countries_Update"); } public DataSet SelectCountries() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_Countries_SelectAll"); } public static DataSet GetCountries() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_Countries_SelectAll"); } public static string GetCountryName(int id) { DBAccess db = new DBAccess(); db.AddParameter("@iCountryID", id); return db.ExecuteScalar("JobsDb_Countries_GetCountryName").ToString(); } }}EducationLevel.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using JobSiteStarterKit.DAL;#endregionnamespace JobSiteStarterKit.BOL{ public class EducationLevel { private int intEduLevelID; private string strEduLevelName; public int EducationLevelID { get { return intEduLevelID; } set { intEduLevelID=value; } } public string EducationLevelName { get { return strEduLevelName; } set { strEduLevelName=value; } } public static DataSet GetEducationLevels() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_EducationLevels_SelectAll"); } public static string GetEducationLevelName(int id) { DBAccess db = new DBAccess(); db.AddParameter("@iEducationLevelID", id); return db.ExecuteScalar("JobsDb_EducationLevels_GetLevelName").ToString(); } public static int Insert(EducationLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@sEducationLevelName", l.EducationLevelName); SqlParameter p = new SqlParameter("@iEducationLevelID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_EducationLevels_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } } public static int Update(EducationLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@iEducationLevelID", l.EducationLevelID); db.AddParameter("@sEducationLevelName", l.EducationLevelName); return db.ExecuteNonQuery("JobsDb_EducationLevels_Update"); } public static int Delete(EducationLevel e) { DBAccess db = new DBAccess(); db.AddParameter("@iEducationLevelID",e.EducationLevelID); return db.ExecuteNonQuery("JobsDb_EducationLevels_Delete"); } }}ExperienceLevel.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using JobSiteStarterKit.DAL;#endregionnamespace JobSiteStarterKit.BOL{ public class ExperienceLevel { private int intExpLevelID; private string strExpLevelName; public int ExperienceLevelID { get { return intExpLevelID; } set { intExpLevelID = value; } } public string ExperienceLevelName { get { return strExpLevelName; } set { strExpLevelName = value; } } public static DataSet GetExperienceLevels() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_ExperienceLevels_SelectAll"); } public static int Insert(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName); SqlParameter p = new SqlParameter("@iExperienceLevelID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_ExperienceLevels_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } } public static int Update(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@iExperienceLevelID", l.ExperienceLevelID); db.AddParameter("@sExperienceLevelName", l.ExperienceLevelName); return db.ExecuteNonQuery("JobsDb_ExperienceLevels_Update"); } public static int Delete(ExperienceLevel l) { DBAccess db = new DBAccess(); db.AddParameter("@iExperienceLevelID",l.ExperienceLevelID); return db.ExecuteNonQuery("JobsDb_ExperienceLevels_Delete"); } public static string GetExperienceLevelName(int id) { DBAccess db = new DBAccess(); db.AddParameter("@iExperienceLevelID", id); return db.ExecuteScalar("JobsDb_ExperienceLevels_GetLevelName").ToString(); } }}JobPosting.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using JobSiteStarterKit.DAL;using System.Data.SqlClient;using System.Web;#endregionnamespace JobSiteStarterKit.BOL{ public class JobPosting { #region Member Variables private int intJobPostingID; private int intCompanyID; private string strContactPerson; private string strTitle; private string strDepartment; private string strJobCode; private string strCity; private int intStateID; private int intCountryID; private int intEducationLevelID; private int intJobTypeID; private decimal dblMinSalary; private decimal dblMaxSalary; private string strDescription; private DateTime dtPostingDate=DateTime.Now; private string strPostedBy=HttpContext.Current.Profile.UserName; #endregion #region Public Properties public int JobPostingID { get { return intJobPostingID; } set { intJobPostingID=value; } } public int CompanyID { get { return intCompanyID; } set { intCompanyID = value; } } public string ContactPerson { get { return strContactPerson; } set { strContactPerson = value; } } public string Title { get { return strTitle; } set { strTitle = value; } } public string Department { get { return strDepartment; } set { strDepartment = value; } } public string JobCode { get { return strJobCode; } set { strJobCode = value; } } public string City { get { return strCity; } set { strCity = value; } } public int StateID { get { return intStateID; } set { intStateID = value; } } public int CountryID { get { return intCountryID; } set { intCountryID = value; } } public int EducationLevelID { get { return intEducationLevelID; } set { intEducationLevelID = value; } } public int JobTypeID { get { return intJobTypeID; } set { intJobTypeID = value; } } public decimal MinSalary { get { return dblMinSalary; } set { dblMinSalary = value; } } public decimal MaxSalary { get { return dblMaxSalary; } set { dblMaxSalary = value; } } public string Description { get { return strDescription; } set { strDescription = value; } } public DateTime PostingDate { get { return dtPostingDate; } set { dtPostingDate = value; } } public string PostedBy { get { return strPostedBy; } set { strPostedBy = value; } }#endregion #region Public Static Methods public static int Insert(JobPosting p) { DBAccess db = new DBAccess(); SqlParameter objParam = new SqlParameter("@iPostingID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@iCompanyID", panyID)); db.Parameters.Add(new SqlParameter("@sContactPerson", p.ContactPerson)); db.Parameters.Add(new SqlParameter("@sTitle", p.Title)); db.Parameters.Add(new SqlParameter("@sDepartment", p.Department)); db.Parameters.Add(new SqlParameter("@sJobCode", p.JobCode)); db.Parameters.Add(new SqlParameter("@sCity", p.City)); db.Parameters.Add(new SqlParameter("@iStateID", p.StateID)); db.Parameters.Add(new SqlParameter("@iCountryID", p.CountryID)); db.Parameters.Add(new SqlParameter("@iEducationLevelID", p.EducationLevelID)); db.Parameters.Add(new SqlParameter("@iJobTypeID", p.JobTypeID)); db.Parameters.Add(new SqlParameter("@curMinSalary", p.MinSalary)); db.Parameters.Add(new SqlParameter("@curMaxSalary", p.MaxSalary)); db.Parameters.Add(new SqlParameter("@sJobDescription", p.Description)); db.Parameters.Add(new SqlParameter("@daPostingDate", p.PostingDate)); db.Parameters.Add(new SqlParameter("@sPostedBy", p.PostedBy)); db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery("JobsDb_JobPostings_Insert"); if (retval == 1) { return int.Parse(objParam.Value.ToString()); } else { return -1; } } public static int Update(JobPosting p) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@iPostingID", p.JobPostingID)); db.Parameters.Add(new SqlParameter("@iCompanyID", panyID)); db.Parameters.Add(new SqlParameter("@sContactPerson", p.ContactPerson)); db.Parameters.Add(new SqlParameter("@sTitle", p.Title)); db.Parameters.Add(new SqlParameter("@sDepartment", p.Department)); db.Parameters.Add(new SqlParameter("@sJobCode", p.JobCode)); db.Parameters.Add(new SqlParameter("@sCity", p.City)); db.Parameters.Add(new SqlParameter("@iStateID", p.StateID)); db.Parameters.Add(new SqlParameter("@iCountryID", p.CountryID)); db.Parameters.Add(new SqlParameter("@iEducationLevelID", p.EducationLevelID)); db.Parameters.Add(new SqlParameter("@iJobTypeID", p.JobTypeID)); db.Parameters.Add(new SqlParameter("@curMinSalary", p.MinSalary)); db.Parameters.Add(new SqlParameter("@curMaxSalary", p.MaxSalary)); db.Parameters.Add(new SqlParameter("@sJobDescription", p.Description)); db.Parameters.Add(new SqlParameter("@daPostingDate", p.PostingDate)); db.Parameters.Add(new SqlParameter("@sPostedBy", p.PostedBy)); int retval = db.ExecuteNonQuery("JobsDb_JobPostings_Update"); return retval; } public static int Delete(JobPosting p) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@iPostingID", p.JobPostingID)); int retval = db.ExecuteNonQuery("JobsDb_JobPostings_Delete"); return retval; } public static JobPosting GetPosting(int id) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@iPostingID", id)); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_JobPostings_SelectOne"); if (dr.HasRows) { JobPosting objJobPosting = new JobPosting(); while (dr.Read()) { objJobPosting.JobPostingID = dr.GetInt32(dr.GetOrdinal("PostingID")); panyID = dr.GetInt32(dr.GetOrdinal("CompanyID")); objJobPosting.Title = dr.GetString(dr.GetOrdinal("Title")); objJobPosting.ContactPerson = dr.GetString(dr.GetOrdinal("ContactPerson")); objJobPosting.Department = dr.GetString(dr.GetOrdinal("Department")); objJobPosting.Description = dr.GetString(dr.GetOrdinal("JobDescription")); objJobPosting.City = dr.GetString(dr.GetOrdinal("City")); objJobPosting.StateID = dr.GetInt32(dr.GetOrdinal("StateID")); objJobPosting.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID")); objJobPosting.EducationLevelID = dr.GetInt32(dr.GetOrdinal("EducationLevelID")); objJobPosting.JobTypeID = dr.GetInt32(dr.GetOrdinal("JobTypeID")); objJobPosting.JobCode = dr.GetString(dr.GetOrdinal("JobCode")); objJobPosting.MinSalary = dr.GetDecimal(dr.GetOrdinal("MinSalary")); objJobPosting.MaxSalary = dr.GetDecimal(dr.GetOrdinal("MaxSalary")); objJobPosting.PostingDate = dr.GetDateTime(dr.GetOrdinal("PostingDate")); objJobPosting.PostedBy = dr.GetString(dr.GetOrdinal("PostedBy")); } dr.Close(); return objJobPosting; } else { dr.Close(); return new JobPosting(); } } public static DataSet GetPostings(string username) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@sUserName", username)); DataSet ds = db.ExecuteDataSet("JobsDb_JobPostings_SelectByUser"); return ds; } public static DataSet SearchJobs(string skills,int countryid,int stateid,string city) { string[] arr = skills.Split(' '); DataSet ds = new DataSet(); DataSet dsTemp = new DataSet(); bool flag = false; DBAccess db = new DBAccess(); foreach (string s in arr) { db.AddParameter("@sSkill", s); if (countryid == -1) { db.AddParameter("@iCountryID", DBNull.Value); } else { db.AddParameter("@iCountryID", countryid); } if (stateid == -1) { db.AddParameter("@iStateID", DBNull.Value); } else { db.AddParameter("@iStateID", stateid); } if (city=="") { db.AddParameter("@sCity", DBNull.Value); } else { db.AddParameter("@sCity", city); } dsTemp = db.ExecuteDataSet("JobsDb_JobPostings_SelectForMatchingSkills"); db.Parameters.Clear(); ds.Merge(dsTemp); if (flag == false) { DataColumn[] pk = new DataColumn[1]; pk[0] = ds.Tables[0].Columns["postingid"]; ds.Tables[0].PrimaryKey = pk; flag = true; } } return ds; } public static int GetJobPostingCount() { DBAccess db = new DBAccess(); return (int)db.ExecuteScalar("JobsDb_JobPostings_GetCount"); } public static DataSet GetLatest() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_JobPostings_GetLatest"); } #endregion }}JobType.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using JobSiteStarterKit.DAL;#endregionnamespace JobSiteStarterKit.BOL{ public class JobType { public JobType() { } public static DataSet GetJobTypes() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_JobTypes_SelectAll"); } public static string GetJobTypeName(int id) { DBAccess db = new DBAccess(); db.AddParameter("@iJobTypeID", id); return db.ExecuteScalar("JobsDb_JobTypes_GetTypeName").ToString(); } }}MyJob.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using JobSiteStarterKit.DAL;using System.Data;using System.Data.SqlClient;#endregionnamespace JobSiteStarterKit.BOL{ public class MyJob { private int intMyJobID; private int intPostingID; private string strUserName; public int MyJobID { get { return intMyJobID; } set { intMyJobID = value; } } public int PostingID { get { return intPostingID; } set { intPostingID = value; } } public string UserName { get { return strUserName; } set { strUserName = value; } } public static int Insert(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iPostingID", j.PostingID); db.AddParameter("@sUserName", j.UserName); SqlParameter p = new SqlParameter("@iMyJobID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_MyJobs_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } } public static int Delete(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iMyJobID",j.MyJobID); return db.ExecuteNonQuery("JobsDb_MyJobs_Delete"); } public static DataSet GetMyJobs(string username) { DBAccess db = new DBAccess(); db.AddParameter("@sUserName", username); return db.ExecuteDataSet("JobsDb_MyJobs_SelectForUser"); } }}MyResume.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using JobSiteStarterKit.DAL;#endregionnamespace JobSiteStarterKit.BOL{ public class MyResume { private int intMyResumeID; private int intResumeID; private string strUserName; public int MyResumeID { get { return intMyResumeID; } set { intMyResumeID = value; } } public int ResumeID { get { return intResumeID; } set { intResumeID = value; } } public string UserName { get { return strUserName; } set { strUserName = value; } } public static int Insert(MyResume r) { DBAccess db = new DBAccess(); db.AddParameter("@iResumeID", r.ResumeID); db.AddParameter("@sUserName", r.UserName); SqlParameter p = new SqlParameter("@iMyResumeID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_MyResumes_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } } public static int Delete(MyResume r) { DBAccess db = new DBAccess(); db.AddParameter("@iMyResumeID",r.MyResumeID); return db.ExecuteNonQuery("JobsDb_MyResumes_Delete"); } public static DataSet GetMyResumes(string username) { DBAccess db = new DBAccess(); db.AddParameter("@sUserName", username); return db.ExecuteDataSet("JobsDb_MyResumes_SelectForUser"); } }}MySearch.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using JobSiteStarterKit.DAL;#endregionnamespace JobSiteStarterKit.BOL{ public class MySearch { private int intMySearchID; private string strCriteria; private int intCountryID; private int intStateID; private string strCity; private string strUserName; public int MySearchID { get { return intMySearchID; } set { intMySearchID = value; } } public string Criteria { get { return strCriteria; } set { strCriteria = value; } } public int CountryID { get { return intCountryID; } set { intCountryID = value; } } public int StateID { get { return intStateID; } set { intStateID = value; } } public string City { get { return strCity; } set { strCity = value; } } public string UserName { get { return strUserName; } set { strUserName=value; } } public static int Insert(MySearch s) { DBAccess db = new DBAccess(); db.AddParameter("@sSearchCriteria", s.Criteria); db.AddParameter("@iCountryID", s.CountryID); db.AddParameter("@iStateID", s.StateID); db.AddParameter("@iCity", s.City); db.AddParameter("@sUserName", s.UserName); SqlParameter p = new SqlParameter("@iMySearchID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval=db.ExecuteNonQuery("JobsDb_MySearches_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } } public static DataSet GetMySearches(string username) { DBAccess db = new DBAccess(); db.AddParameter("@sUserName", username); return db.ExecuteDataSet("JobsDb_MySearches_SelectForUser"); } public static MySearch GetMySearch(int mysearchid) { DBAccess db = new DBAccess(); db.AddParameter("@iMySearchID", mysearchid); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_MySearches_SelectOne"); if (dr.HasRows) { MySearch s = new MySearch(); while (dr.Read()) { s.MySearchID = dr.GetInt32(dr.GetOrdinal("mysearchid")); s.Criteria = dr.GetString(dr.GetOrdinal("SearchCriteria")); s.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID")); s.StateID = dr.GetInt32(dr.GetOrdinal("StateID")); s.City = dr.GetString(dr.GetOrdinal("City")); s.UserName = dr.GetString(dr.GetOrdinal("UserName")); } dr.Close(); return s; } else { return null; } } public static int Delete(MySearch s) { DBAccess db = new DBAccess(); db.AddParameter("@iMySearchID", s.MySearchID); return db.ExecuteNonQuery("JobsDb_MySearches_Delete"); } }}Resume.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using JobSiteStarterKit.DAL;using System.Data;using System.Data.SqlClient;#endregionnamespace JobSiteStarterKit.BOL{ public class Resume { #region Member Variables private int intResumeID; private string strUserName; private string strJobTitle; private string strCity; private int intCountryID; private int intStateID; private int intRelocationCountryID; private int intJobTypeID; private int intEduLevelID; private int intExpLevelID; private string strResumeText; private string strCoveringLetterText; private DateTime dtPostedDate; #endregion #region Public Properties public int ResumeID { get { return intResumeID; } set { intResumeID = value; } } public string UserName { get { return strUserName; } set { strUserName = value; } } public string JobTitle { get { return strJobTitle; } set { strJobTitle = value; } } public string City { get { return strCity; } set { strCity = value; } } public int CountryID { get { return intCountryID; } set { intCountryID = value; } } public int StateID { get { return intStateID; } set { intStateID = value; } } public int RelocationCountryID { get { return intRelocationCountryID; } set { intRelocationCountryID = value; } } public int JobTypeID { get { return intJobTypeID; } set { intJobTypeID = value; } } public int EducationLevelID { get { return intEduLevelID; } set { intEduLevelID = value; } } public int ExperienceLevelID { get { return intExpLevelID; } set { intExpLevelID = value; } } public string ResumeText { get { return strResumeText; } set { strResumeText = value; } } public string CoveringLetterText { get { return strCoveringLetterText; } set { strCoveringLetterText = value; } } public DateTime PostedDate { get { return dtPostedDate; } set { dtPostedDate = value; } } #endregion #region Public Static Methods public static Resume GetResume(string username) { DBAccess db = new DBAccess(); db.AddParameter("@sUserName", username); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Resumes_SelectForUser"); if (dr.HasRows) { Resume r = new Resume(); while (dr.Read()) { r.ResumeID = dr.GetInt32(dr.GetOrdinal("ResumeID")); r.City = dr.GetString(dr.GetOrdinal("TargetCity")); r.CountryID = dr.GetInt32(dr.GetOrdinal("TargetCountryID")); r.CoveringLetterText = dr.GetString(dr.GetOrdinal("CoverLetterText")); r.EducationLevelID = dr.GetInt32(dr.GetOrdinal("EducationLevelID")); r.ExperienceLevelID = dr.GetInt32(dr.GetOrdinal("ExperienceLevelID")); r.JobTitle = dr.GetString(dr.GetOrdinal("JobTitle")); r.JobTypeID = dr.GetInt32(dr.GetOrdinal("TargetJobTypeID")); r.RelocationCountryID = dr.GetInt32(dr.GetOrdinal("RelocationCountryID")); r.ResumeText = dr.GetString(dr.GetOrdinal("ResumeText")); r.StateID = dr.GetInt32(dr.GetOrdinal("TargetStateID")); r.UserName = dr.GetString(dr.GetOrdinal("UserName")); r.PostedDate = dr.GetDateTime(dr.GetOrdinal("PostDate")); } dr.Close(); return r; } else { dr.Close(); Resume r = new Resume(); r.ResumeID = -1; return r; } } public static Resume GetResume(int resumeid) { DBAccess db = new DBAccess(); db.AddParameter("@iResumeID", resumeid); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Resumes_SelectOne"); if (dr.HasRows) { Resume r = new Resume(); while (dr.Read()) { r.ResumeID = dr.GetInt32(dr.GetOrdinal("ResumeID")); r.City = dr.GetString(dr.GetOrdinal("TargetCity")); r.CountryID = dr.GetInt32(dr.GetOrdinal("TargetCountryID")); r.CoveringLetterText = dr.GetString(dr.GetOrdinal("CoverLetterText")); r.EducationLevelID = dr.GetInt32(dr.GetOrdinal("EducationLevelID")); r.ExperienceLevelID = dr.GetInt32(dr.GetOrdinal("ExperienceLevelID")); r.JobTitle = dr.GetString(dr.GetOrdinal("JobTitle")); r.JobTypeID = dr.GetInt32(dr.GetOrdinal("TargetJobTypeID")); r.RelocationCountryID = dr.GetInt32(dr.GetOrdinal("RelocationCountryID")); r.ResumeText = dr.GetString(dr.GetOrdinal("ResumeText")); r.StateID = dr.GetInt32(dr.GetOrdinal("TargetStateID")); r.UserName = dr.GetString(dr.GetOrdinal("UserName")); r.PostedDate = dr.GetDateTime(dr.GetOrdinal("PostDate")); } dr.Close(); return r; } else { dr.Close(); return new Resume(); } } public static int Insert(Resume r) { DBAccess db = new DBAccess(); db.AddParameter("@sJobTitle", r.JobTitle); db.AddParameter("@sTargetCity", r.City); db.AddParameter("@iTargateStateID", r.StateID); db.AddParameter("@iTargetCountryID", r.CountryID); db.AddParameter("@iRelocationCountryID", r.RelocationCountryID); db.AddParameter("@iTargetJobTypeID", r.JobTypeID); db.AddParameter("@iEducationLevelID", r.EducationLevelID); db.AddParameter("@iExperienceLevelID", r.ExperienceLevelID); db.AddParameter("@sResumeText", r.ResumeText); db.AddParameter("@sCoverLetterText", r.CoveringLetterText); db.AddParameter("@sUserName", r.UserName); db.AddParameter("@dtPostDate", r.PostedDate); SqlParameter p=new SqlParameter("@iResumeID",SqlDbType.Int); p.Direction=ParameterDirection.Output; db.AddParameter(p); int retval=db.ExecuteNonQuery("JobsDb_Resumes_Insert"); if (retval <= 0) { return -1; } else { return (int)p.Value; } } public static int Update(Resume r) { DBAccess db = new DBAccess(); db.AddParameter("@iResumeID", r.ResumeID); db.AddParameter("@sJobTitle", r.JobTitle); db.AddParameter("@sTargetCity", r.City); db.AddParameter("@iTargateStateID", r.StateID); db.AddParameter("@iTargetCountryID", r.CountryID); db.AddParameter("@iRelocationCountryID", r.RelocationCountryID); db.AddParameter("@iTargetJobTypeID", r.JobTypeID); db.AddParameter("@iEducationLevelID", r.EducationLevelID); db.AddParameter("@iExperienceLevelID", r.ExperienceLevelID); db.AddParameter("@sResumeText", r.ResumeText); db.AddParameter("@sCoverLetterText", r.CoveringLetterText); db.AddParameter("@sUserName", r.UserName); db.AddParameter("@dtPostDate", r.PostedDate); return db.ExecuteNonQuery("JobsDb_Resumes_Update"); } public static int Delete(int ResumeID) { DBAccess db = new DBAccess(); db.AddParameter("@iResumeID", ResumeID); return db.ExecuteNonQuery("JobsDb_Resumes_Delete"); } public static int GetResumeID(string username) { DBAccess db = new DBAccess(); db.AddParameter("@sUserName", username); SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Resumes_SelectForUser"); int resumeid=-1; if (dr.HasRows) { while (dr.Read()) { resumeid = dr.GetInt32(dr.GetOrdinal("ResumeID")); } dr.Close(); } return resumeid; } public static DataSet SearchResumes(string skills,int countryid,int stateid,string city) { string[] arr=skills.Split(' '); DataSet ds=new DataSet(); DataSet dsTemp=new DataSet(); bool flag=false; DBAccess db=new DBAccess(); foreach(string s in arr) { db.AddParameter("@sSkill",s); if (countryid == -1) { db.AddParameter("@iCountryID",DBNull.Value); } else { db.AddParameter("@iCountryID", countryid); } if (stateid == -1) { db.AddParameter("@iStateID", DBNull.Value); } else { db.AddParameter("@iStateID", stateid); } if (city == "") { db.AddParameter("@sCity", DBNull.Value); } else { db.AddParameter("@sCity", city); } dsTemp = db.ExecuteDataSet("JobsDb_Resumes_SelectForMatchingSkills"); db.Parameters.Clear(); ds.Merge(dsTemp); if(flag==false) { DataColumn[] pk=new DataColumn[1]; pk[0]=ds.Tables[0].Columns["resumeid"]; ds.Tables[0].PrimaryKey=pk; flag=true; } } return ds; } public static int GetResumeCount() { DBAccess db = new DBAccess(); return (int)db.ExecuteScalar("JobsDb_Resumes_GetCount"); } #endregion }}State.cs#region Using directivesusing System;using System.Collections.Generic;using System.Text;using JobSiteStarterKit.DAL;using System.Data;#endregionnamespace JobSiteStarterKit.BOL{ public class State { public static DataSet GetStates() { DBAccess db = new DBAccess(); return db.ExecuteDataSet("JobsDb_States_SelectAll"); } public static DataSet GetStates(int countryid) { DBAccess db = new DBAccess(); db.AddParameter("@iCountryID", countryid); return db.ExecuteDataSet("JobsDb_States_SelectForCountry"); } public static string GetStateName(int id) { DBAccess db = new DBAccess(); db.AddParameter("@iStateID", id); return db.ExecuteScalar("JobsDb_States_GetStateName").ToString(); } }}DBAccess.csusing System;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace JobSiteStarterKit.DAL{public class DBAccess:IDisposable {private IDbCommand cmd=new SqlCommand();private string strConnectionString="";private bool handleErrors=false;private string strLastError="";public DBAccess(){ ConnectionStringSettings objConnectionStringSettings = ConfigurationManager.ConnectionStrings["connectionstring"]; strConnectionString = objConnectionStringSettings.ConnectionString; SqlConnection cnn=new SqlConnection();cnn.ConnectionString=strConnectionString;cmd.Connection=cnn; mandType = CommandType.StoredProcedure; }public IDataReader ExecuteReader(){IDataReader reader=null; try { this.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception ex) { if (handleErrors) strLastError = ex.Message; else throw; } catch { throw; }return reader;}public IDataReader ExecuteReader(string commandtext){IDataReader reader=null;try{mandText=commandtext;reader=this.ExecuteReader();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return reader;}public object ExecuteScalar(){object obj=null;try{this.Open();obj= cmd.ExecuteScalar(); this.Close();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return obj;}public object ExecuteScalar(string commandtext){object obj=null;try{mandText=commandtext;obj= this.ExecuteScalar();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return obj;}public int ExecuteNonQuery(){int i=-1;try{ this.Open();i=cmd.ExecuteNonQuery(); this.Close();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return i;}public int ExecuteNonQuery(string commandtext){int i=-1;try{mandText=commandtext;i=this.ExecuteNonQuery();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return i;}public DataSet ExecuteDataSet(){SqlDataAdapter da=null;DataSet ds=null;try{da=new SqlDataAdapter();da.SelectCommand=(SqlCommand)cmd;ds=new DataSet();da.Fill(ds);}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return ds;}public DataSet ExecuteDataSet(string commandtext){DataSet ds=null;try{mandText=commandtext;ds=this.ExecuteDataSet();}catch(Exception ex){if(handleErrors)strLastError=ex.Message;elsethrow;} catch { throw; }return ds;}public string CommandText{get{return mandText;}set{mandText=value;cmd.Parameters.Clear();}}public IDataParameterCollection Parameters{get{return cmd.Parameters;}} public void AddParameter(string paramname,object paramvalue){SqlParameter param=new SqlParameter(paramname,paramvalue);cmd.Parameters.Add(param);}public void AddParameter(IDataParameter param){cmd.Parameters.Add(param);}public string ConnectionString{get{return strConnectionString;}set{strConnectionString=value;}} private void Open() { cmd.Connection.Open(); } private void Close() { cmd.Connection.Close(); }public bool HandleExceptions{get{return handleErrors;}set{handleErrors=value;}}public string LastError{get{return strLastError;}} public void Dispose() { cmd.Dispose(); }}}WebService.csusing System;using System.Web;using System.Collections;using System.Web.Services;using System.Web.Services.Protocols;using System.Web.Script.Services;using JobSiteStarterKit.BOL;using System.Text;[WebService(Namespace = "")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)][ScriptService]public class WebService : System.Web.Services.WebService { [WebMethod] [ScriptMethod] public string GetToolTipText(int contextKey) { try { JobPosting job = JobPosting.GetPosting(contextKey); return job.Description; } catch (Exception ex) { return ex.Message; } } [WebMethod] [ScriptMethod] public string GetCompanyProfile(int contextKey) { Company c=Company.GetCompany(contextKey); StringBuilder sb=new StringBuilder(); sb.Append("<table width='100%'>"); sb.Append("<tr><td colspan='2' class='dataentryformlabelbig' align='left'>"); sb.Append("Company Details"); sb.Append("</td></tr>"); sb.Append("<tr><td nowrap align='right'>"); sb.Append("Company Name :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(panyName); sb.Append("</td></tr>"); sb.Append("<tr><td nowrap valign='top' align='right'>"); sb.Append("Brief Profile :"); sb.Append("</td>"); sb.Append("<td><textarea readonly='true' rows=5 cols=30>"); sb.Append(c.BriefProfile); sb.Append("</textarea></td></tr>"); sb.Append("<tr><td colspan='2' class='dataentryformlabelbig' align='left'>"); sb.Append("Location"); sb.Append("</td></tr>"); sb.Append("<tr><td valign='top' align='right'>"); sb.Append("Address 1 :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.Address1); sb.Append("</td></tr>"); sb.Append("<tr><td valign='top' align='right'>"); sb.Append("Address 2 :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.Address2); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("City :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.City); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("State :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(State.GetStateName(c.StateID)); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("Country :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(Country.GetCountryName(c.CountryID)); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("ZIP :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.ZIP); sb.Append("</td></tr>"); sb.Append("<tr><td colspan='2' class='dataentryformlabelbig' align='left'>"); sb.Append("Contact Details"); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("Phone :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.Phone); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("Fax :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.Fax); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("Email :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(c.Email); sb.Append("</td></tr>"); sb.Append("<tr><td align='right'>"); sb.Append("Web Site :"); sb.Append("</td>"); sb.Append("<td><a href='"); sb.Append(c.WebSiteUrl); sb.Append("'>"); sb.Append(c.WebSiteUrl); sb.Append("</a></td></tr>"); sb.Append("</table>"); return sb.ToString(); }}YellowShades.cssA:link{ font-weight: bold; font-size: 9pt; color: #800000; font-family: Verdana; text-decoration: none;}A:visited{font-weight: bold;font-size: 9pt; color: #800000;font-family: Verdana;text-decoration: none;}A:hover{ font-weight: bold; font-size: 9pt; color: #CC3300; font-family: Verdana; text-decoration: underline;}p{ font-size: 9pt; font-family: Verdana;}body{ font-size: 9pt; font-family: Verdana; margin: 0px;}.dataentryformlabel{ font-weight: bold; font-size: 9pt; color: #800000; font-family: Verdana;}.dataentryformerrormsg{ font-weight: bold; font-size: 9pt; color: darkorange; font-family: Verdana;}.dataentryformtextbox{ border-right: peru 1px solid; border-top: peru 1px solid; border-left: peru 1px solid; border-bottom: peru 1px solid;}.dataentryformbutton{ font-weight: bold; font-size: 9pt; color: ivory; font-family: Verdana; background-color: #FF9900; width: auto; border-bottom-style: outset; border-right-style: outset; border-top-style: solid; border-left-style: solid; border-top-color: #FF9966; border-left-color: #FF9966;}.pagetop{ background-color: lightyellow; padding-bottom: 5px; padding-left: 10px; border-bottom: gold thin solid;}.pageleft{ /* background-color: #FFFFCC; */ background-color: white; padding-right: 5px;}.pageright{ background-color: white;}.pagebottom{ background-color: lightyellow; border-top: gold thin solid; padding-top: 5px;}.dataentryformheading{ padding: 5px 10px 5px 10px; font-weight: bold; font-size: 11pt; vertical-align: middle; color: sienna; font-family: Verdana; background-color: khaki; text-align: center;}.biglabel{ padding-right: 2px; padding-left: 2px; font-weight: bold; font-size: 10pt; padding-bottom: 2px; vertical-align: middle; color: #CC6600; padding-top: 2px; font-family: Verdana; text-align: center; width: 100%;}.dataentryformlabelbig{ padding-right: 5px; padding-left: 5px; font-weight: bold; font-size: 10pt; padding-bottom: 2px; vertical-align: middle; color: sienna; padding-top: 2px; font-family: Verdana; text-align: left; width: 100%; font-style: normal; background-color: #FFE3AA;}.marketingtext{ padding-right: 2px; padding-left: 2px; font-size: 20px; padding-bottom: 2px; color: peru; padding-top: 2px; font-family: Arial;}.loginpanel{ padding: Same for all; border-style: Same for all; border-width: Same for all; border-color: Same for all; border-top-width: 2px; border-top-color: #FF9900; border-top-style: Solid; padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin-top: 3px; margin-right: 3px; margin-bottom: 3px; margin-left: 3px; background-color: #FFCC00; width: 300px; border-right-style: Solid; border-bottom-style: Solid; border-left-style: Solid; border-right-width: 2px; border-bottom-width: 2px; border-left-width: 2px; border-right-color: #FF9900; border-bottom-color: #FF9900; border-left-color: #FF9900;}.tooltippanel{ padding: Same for all; border-style: Same for all; border-width: Same for all; border-color: Same for all; border-top-width: 2px; border-top-color: #FF9900; border-top-style: Solid; padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin-top: 3px; margin-right: 3px; margin-bottom: 3px; margin-left: 3px; background-color: #FFCC00; width: 400px; border-right-style: Solid; border-bottom-style: Solid; border-left-style: Solid; border-right-width: 2px; border-bottom-width: 2px; border-left-width: 2px; border-right-color: #FF9900; border-bottom-color: #FF9900; border-left-color: #FF9900;}.companyprofilepanel{ padding: Same for all; border-style: Same for all; border-width: Same for all; border-color: Same for all; border-top-width: 2px; border-top-color: #FF9900; border-top-style: Solid; padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin-top: 3px; margin-right: 3px; margin-bottom: 3px; margin-left: 3px; background-color: #FFCC00; border-right-style: Solid; border-bottom-style: Solid; border-left-style: Solid; border-right-width: 2px; border-bottom-width: 2px; border-left-width: 2px; border-right-color: #FF9900; border-bottom-color: #FF9900; border-left-color: #FF9900;}.modalbackground{ background-color:Gray; filter:alpha(opacity=70); opacity:0.7;}.waitmessage{ border-style: ridge; border-color: #FF9900; padding: 10px; color: #FFFFFF; font-size: 12pt; font-weight: Bold; background-color: #FF6600; font-family: arial, Helvetica, sans-serif;}.errorlabel{ font-family: verdana; font-size: 12pt; font-weight: bold; color: #FF0000;}.activebutton{ border: 2px solid #FF9900;}.inactivebutton{ border: 2px solid #FFFFCC;}.statstable{ border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-width: 2px; border-color: #FF9900;}YellowShades.skin<asp:GridView Runat="server" BorderStyle="Solid" BorderColor="DarkGoldenrod"BorderWidth="1px" BackColor="White"GridLines="Vertical" CellPadding="4" ForeColor="Black"> <FooterStyle BackColor="#CCCC99"></FooterStyle> <PagerStyle ForeColor="Black" HorizontalAlign="Right" BackColor="#F7F7DE"></PagerStyle> <HeaderStyle ForeColor="White" Font-Bold="True" BackColor="#6B696B"></HeaderStyle> <AlternatingRowStyle BackColor="White"></AlternatingRowStyle> <SelectedRowStyle ForeColor="White" Font-Bold="True" BackColor="#CE5D5A"></SelectedRowStyle> <RowStyle BackColor="#F7F7DE"></RowStyle> </asp:GridView><asp:TextBox Runat="server" CssClass="dataentryformtextbox" BorderWidth="1px" BorderStyle="Solid" BorderColor="peru"></asp:TextBox><asp:Login Runat="server" BorderWidth="1px" BackColor="#F7F7DE" BorderStyle="Solid" BorderColor="#CCCC99" ForeColor="#333333" Font-Names="Verdana" Font-Size="10pt"> <TextBoxStyle CssClass="dataentryformtextbox"></TextBoxStyle> <TitleTextStyle Font-Bold="True" BackColor="#6B696B" ForeColor="#FFFFFF"></TitleTextStyle> </asp:Login><asp:PasswordRecovery Runat="server" BorderColor="#CCCC99" BorderStyle="Solid" BackColor="#F7F7DE" BorderWidth="1px" Font-Size="10pt" Font-Names="Verdana"> <TitleTextStyle Font-Bold="True" BackColor="#6B696B" ForeColor="#FFFFFF"></TitleTextStyle> <TextBoxStyle CssClass="dataentryformtextbox"></TextBoxStyle></asp:PasswordRecovery><asp:Label Runat="server" CssClass="dataentryformheading" SkinId="FormHeading"></asp:Label><asp:Label Runat="server" CssClass="dataentryformlabel" Width="100%" SkinId="FormLabel"></asp:Label><asp:Label Runat="server" CssClass="biglabel" Width="100%" SkinId="Slogan"></asp:Label><asp:Label Runat="server" CssClass="dataentryformlabelbig" SkinId="FormGroupLabel"></asp:Label><asp:Label Runat="server" CssClass="waitmessage" SkinId="WaitLabel"></asp:Label><asp:Label Runat="server" CssClass="errorlabel" SkinId="ErrorLabel"></asp:Label><asp:Button Runat="server" CssClass="dataentryformbutton" /><asp:CreateUserWizard Runat="server" BorderColor="#CCCC99" BorderStyle="Solid" BackColor="#F7F7DE" BorderWidth="1px" Font-Size="10pt" Font-Names="Verdana"> <StepStyle BorderColor="#CCCC99" Font-Names="Verdana" Font-Size="10pt" BackColor="#F7F7DE" BorderStyle="Solid" BorderWidth="1px"></StepStyle> <TitleTextStyle Font-Bold="True" BackColor="#6B696B" ForeColor="#FFFFFF"></TitleTextStyle></asp:CreateUserWizard><asp:ChangePassword Runat="server" BorderColor="#CCCC99" BorderStyle="Solid" BackColor="#F7F7DE" BorderWidth="1px" Font-Size="10pt" Font-Names="Verdana"> <TitleTextStyle Font-Bold="True" BackColor="#6B696B" ForeColor="#FFFFFF"></TitleTextStyle></asp:ChangePassword><asp:DetailsView SkinID="AdminEntry" CellPadding="5" Runat="server" ForeColor="Black" BorderColor="Tan" GridLines="None" BackColor="LightGoldenrodYellow" BorderWidth="1px"> <FooterStyle BackColor="Tan"></FooterStyle> <PagerStyle ForeColor="DarkSlateBlue" HorizontalAlign="Center" BackColor="PaleGoldenrod"></PagerStyle> <HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle> <AlternatingRowStyle BackColor="PaleGoldenrod"></AlternatingRowStyle></asp:DetailsView><asp:Panel runat="server" SkinId="LoginPanel" CssClass="loginpanel" /><asp:Panel runat="server" SkinId="CompanyProfilePanel" CssClass="companyprofilepanel" /><asp:Panel runat="server" SkinId="TooltipPanel" CssClass="tooltippanel" /><asp:WebPartZone runat="server" BorderStyle="NotSet" WebPartVerbRenderMode="TitleBar" BorderColor="#CCCCCC" Font-Names="Verdana" Padding="6"> <partchromestyle backcolor="#FFFBD6" bordercolor="#FFCC66" font-names="Verdana" forecolor="#333333" /><menulabelhoverstyle forecolor="#FFCC66" /><menulabelstyle forecolor="White" /><menuverbhoverstyle backcolor="#FFFBD6" bordercolor="#CCCCCC" borderstyle="Solid" borderwidth="1px" forecolor="#333333" /> <HeaderStyle HorizontalAlign="Center" forecolor="#CCCCCC" /><menuverbstyle bordercolor="#990000" borderstyle="Solid" borderwidth="1px" forecolor="White" /><partstyle forecolor="#333333" /><menupopupstyle backcolor="#990000" bordercolor="#CCCCCC" borderwidth="1px" font-names="Verdana" /><parttitlestyle backcolor="#990000" font-bold="True" forecolor="White" /></asp:WebPartZone>Register.aspx<%@ Page Language="C#" CodeFile="register.aspx.cs" Inherits="register_aspx" EnableTheming="true" MasterPageFile="~/MasterPage.master" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server"><div align=center> <asp:Label ID="Label2" Runat="server" Text="Employees/ Employers! Register here!!" SkinID="FormHeading"></asp:Label></div> <br /> Registration is a two step process:<br /> <ol> <li>Choose a user name and password</li><li>Choose whether you would like to register as an "Employee" or "Employer".</li></ol><p> Once you register with us you can access respective secured areas for posting resumes or posting jobs.</p> <div align=center> <asp:UpdatePanel ID="UpdatePanel1" runat="server"><contenttemplate><asp:CreateUserWizard ID="CreateUserWizard1" Runat="server" CreateUserButtonText="Register Me" OnActiveStepChanged="CreateUserWizard1_ActiveStepChanged" OnContinueButtonClick="CreateUserWizard1_ContinueButtonClick" OnNextButtonClick="CreateUserWizard1_NextButtonClick"><wizardsteps><asp:WizardStep ID="WizardStep2" Runat="server" Title="Please tell us about yourself"><table style="width: 100%"><tr><td align="right" contenteditable="true"><asp:Label ID="Label3" Runat="server" SkinID="FormLabel" Text="First Name :"></asp:Label></td><td align="left"><asp:TextBox ID="TextBox1" Runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="Please enter first name"></asp:RequiredFieldValidator></td></tr><tr><td align="right" contenteditable="true"><asp:Label ID="Label4" Runat="server" SkinID="FormLabel" Text="Last Name :"></asp:Label></td><td align="left"><asp:TextBox ID="TextBox2" Runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator2" Runat="server" ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="Please enter last name"></asp:RequiredFieldValidator></td></tr></table></asp:WizardStep><asp:CreateUserWizardStep ID="CreateUserWizardStep1" Runat="server" Title="Sign Up for Your New Account"></asp:CreateUserWizardStep><asp:WizardStep ID="WizardStep1" Runat="server" StepType="Step" Title="Choose your role"><table width="100%"><tr><td style="width: 100px"><asp:Label ID="Label1" Runat="server" Text="Register As :"></asp:Label></td></tr><tr><td style="width: 100px"><asp:DropDownList ID="DropDownList1" Runat="server" Height="22px" Width="135px"></asp:DropDownList></td></tr></table></asp:WizardStep><asp:CompleteWizardStep ID="CompleteWizardStep1" Runat="server" Title="Complete"></asp:CompleteWizardStep></wizardsteps><startnavigationtemplate><asp:Button ID="StartNextButton" Runat="server" CommandName="MoveNext" Text="Next" /></startnavigationtemplate></asp:CreateUserWizard></contenttemplate></asp:UpdatePanel><asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="100"><progresstemplate><br /><asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Progress.gif" /></progresstemplate></asp:UpdateProgress> </div> </asp:Content>Register.aspx.csusing System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class register_aspx : Page{ protected void CreateUserWizard1_ContinueButtonClick(object sender, EventArgs e) { Response.Redirect("~/default.aspx"); } protected void Page_Load(object sender, EventArgs e) { } protected void CreateUserWizard1_NextButtonClick(object sender, WizardNavigationEventArgs e) { if (CreateUserWizard1.ActiveStep.ID == "WizardStep2") { TextBox t = ((TextBox)CreateUserWizard1.ActiveStep.FindControl("TextBox1")); ViewState["firstname"]=t.Text; t = ((TextBox)CreateUserWizard1.ActiveStep.FindControl("TextBox2")); ViewState["lastname"]=t.Text; } if (CreateUserWizard1.ActiveStep.ID == "WizardStep1") { MembershipUser objUser = Membership.GetUser(); DropDownList ddl = ((DropDownList)CreateUserWizard1.ActiveStep.FindControl("DropDownList1")); if (ddl != null) { Roles.AddUserToRole(objUser.UserName, ddl.SelectedValue); } Profile.UserName = objUser.UserName; Profile.Email = objUser.Email; Profile.FirstName=ViewState["firstname"].ToString(); Profile.LastName=ViewState["lastname"].ToString(); Profile.JobSeeker.ResumeID = -1; Profile.panyID = -1; } } protected void CreateUserWizard1_ActiveStepChanged(object sender, EventArgs e) { if (CreateUserWizard1.ActiveStep.ID == "WizardStep1") { DropDownList ddl = ((DropDownList)CreateUserWizard1.ActiveStep.FindControl("DropDownList1")); if (ddl != null) { ListItem li1 = new ListItem("Job Seeker", ConfigurationManager.AppSettings["jobseekerrolename"]); ListItem li2 = new ListItem("Employer", ConfigurationManager.AppSettings["employerrolename"]); ddl.Items.Add(li1); ddl.Items.Add(li2); } } }}Primary ObjectivesTesting is a process of executing a software program with the intention of finding an error.A good test case is one that has a high probability of Finding an as-yet undiscovered error.A successful test is one that uncovers an as-yet undiscovered error.Secondary objectiveDesign tests that systematically uncover different classes of errors.Do so with a minimum of time and effort.Provide reliable indication of software quality.Test Techniques 1 Classified according to the criterion used to measure the adequacy of a set of test cases:-Coverage-based testingTesting requirement are classified in terms of the coverage of the product to be tested.-Fault-based testingFault detecting the ability of the test set determines the adequacy. -Error-based testingFocus on error-prone points, based on knowledge of the typical errors that people make.Exception handling is used to capture:ErrorsFaultsFailuresI am still sleeping … Test technique 2Test techniques are classified based on the source of the information used to derive test cases:white (glass) box testingAlso called structural or program-based testingBlack box testingAlso called functional or specification based testingBlack box testingAn approach to testing where the program is considered as a ‘black-box’The program test cases are based on the system specificationTest planning can begin early in the software process Input data and output results often fall into different classes where all members of a class are relatedEach of these classes is an equivalence portion where the program behaves in an equivalent way for each class memberTest cases should be chosen from each part ion. White Box TestingAlso called structural testingDerivation of test cases according to program structure. knowledge of the program is used to identify additional test cases.Objective is to exercise all program statements. Exercise all independent paths within a module at least once.Exercise all logical decision on their true and false sides.Exercise all loops at their boundaries and within their operational bounds.Exercise all internal data structures to assure their validity.Testing Level:Three levels of testing were carried out in the each phase:Unit testing: It tests a code function.Integration function: It checks interdependency of different modules.System Testing: It tests the applications’ functionality as was specified in the detailed functionality detail.The testing level situation is illustrated below:Unit Testing: - It is normally performed on individual module as each module of the proposed system has been developed, the modules are being tested .at the times coding there are so many errors inside the unit modules and it was removed while testing that particular unit module s. inside the unit modules , when the unit module does not match with our target it will be placed into Black box Testing , while if there is only “syntax errors” it is just removed and we can placed that errors into white-box errors. The syntax erros while coding the project will be placed in white-box testing because this type of errors is just syntax errors. It can be removed while executing the unit modules.Integration Testing: - It is performed after unit testing. Integration testing is a systematic technique for constructing the programe structure while conducting tests to uncover errors associated with interfacing. It is a systematic technique for constructing the program structure while at the same time conducting tests to uncover errors associated with interfacing. Integration testing divided into the following test phases:User interactionData manipulation and analysisDisplay processing and generationDatabase management.In Integration testing I have gone through “Smoke Testing”. Smoke testing provides a number of benefits when it is applied on complex, time critical projects:Integration risk is minimized. Because it is conducted daily.The quality of the end-product is improved. Because the approach is construction oriented.Error diagnosis and correction are simplified.Progress is easier to assess.System Testing:System testing makes a logical assumption that if all the parts of the system are correct, the goal will be successfully achieved. A small error can conceivably explode into a much larger problem. The best program is worthless if it does not meet user needs. Through System testing these problems can be reduced. System testing is actually series of different tests whose primary purpose is to fully exercise the computer –based system. Although, each test has been properly integrated and perform the allocated functions.Following major guidelines were taken under consideration while framing test cases for system testing:We anticipated the potentials interfacing problems that might occur in our application.We designed error-handling paths that tested all information coming from different elements of the system.We conducted a series of tests that simulated bad data or other potential errors at the software interface.Results of the entire test were recorded to use them as “evidence” if finger pointing occurred.Types of Test:There are four types of tests that IIMMS must satisfy:Functional TestsPerformance TestsStress Tests 5. structural testsFunctional Test:Functional test cases specify typical operating conditions, typical input values, and typical expected results.In case of IIMMS, we conduct the functionality test on these phases:Assumed initial values and system defaults.Special values such as files containing identical values.Boundary conditions just inside and just beyond the boundaries.The nominal input values for which the expected results were known.Performance Testing:Performance testing is designed to verify response time, execution time,Throughput and traffic rates on data channels.Performance testing in IIMMS was carried out in multi user mode and data was entered manually. After testing the results, it was found that the program and the system as a whole meet all the specified requirements.Stress Testing:Stress testing are designed to overload a system in the various ways, such as attempting to sign on more than the maximum allowed number of terminals, processing more than the allowed number of identifiers or static levels, or disconnecting a communication link. The purpose of the stress testing is to determine the limitations of the IIMMS application.The IIMMS application was executed with resources in abnormal quantity, frequency and volume:Test cases that required maximum memory /resources. The test case tested no. of installed IIMMS applications that could be opened on a 8MB RAM system with different login passwords and different arbitrary operations were performed on each.Test cases that causes thrashing in virtual operating system were constructed. Too many IIMMS applications were opened one system till it gave the message that the system was running on virtual memory.Input data rates were increased to large extent to see how inputs affected the outputs.Structural Testing:Structural tests are concerned with examining the internal processing logic of a software system. The particular routines called and the logical paths traversed through the routines are the objects of interest. The goal of structural testing is to traverse a specified number of paths through each routine in the IIMMS application to establish thoroughness to testing.All testing was done manually and manually entered test data were used. During the various test, bugs were fixed.SYSTEM SECURITY MEASURESThere are several aspects of the system security: -Hardware Security: -Only limited and authenticated person will be allowed to access the system. The system administrator will take care of all these things.Software Security: -Two level of software security can be provided, which is the operating system level and the database level. Every user will be provided unique user-id and confidential password in order to log into the system. Windows XP operating system has been adopted in the proposed system, which is highly secured and does not allow unauthorized users. Again it restricts the function of users.By granting them proper access control mechanism. Similarly the Oracle database server can provide an additional level of software or user security also so that unauthorized user can’t access the database. The authorized user can access only that part of the database for which they are granted access privilegesApplication Level Security: -User authentication and validation have also been defined additionally in the application level. The users have been provided user name and password facility. The users have been categorized into administrator officer assistant and operator. The role of each type of user has been defined and fixed and user can’t violate these security rules.Data Level Security: -Data validation rules and constraints have been properly defined both at the database level and the application level. Due to this only valid data can be entered. Apart from this, background audit mechanisms have been properly defined so as to track all the activities related to data management. For example, data insertion is recorded along with the user name and date & time of insert. Similarly data updation and deletion are also recorded with the user name and date & time in effect. A separate copy of the original data will be stored in a separate audit table during its updation & deletion. This is done along with the recording of user performing the updation & deletion and date & time. From this audit table the original data can be recorded as and when required and user can be made responsible. The application also keeps tracks of all the users’ activities. Hence the data itself is completely secured.MASTERING IN C#.NET 2008BLACK BOOK FOR 3.5LEARN SQL SERVER 2008 IN 21 DAYS.TMH MS SQL SERVER 2008 ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- getroman com reviews
- acurafinancialservices.com account management
- acurafinancialservices.com account ma
- getroman.com tv
- http cashier.95516.com bing
- http cashier.95516.com bingprivacy notice.pdf
- connected mcgraw hill com lausd
- education.com games play
- rushmorelm.com one time payment
- autotrader.com used cars
- b com 2nd year syllabus
- gmail.com sign in