Online job portal project code in asp net c# free download or Online Job Recruitment System Free Source Code Download
This project is a web application helps to allows users to register and log-in. It then allows users to post daily jobs available, and for job seekers to place a bid on the job. Essentially a job website for contracts (done by the day), for a very specific industry, and makes the job seeker do the bidding as opposed to the job poster. All bids need to be seen by the poster when they re-login, but the computer program needs to make no decisions on which bid is better or organize the bids.
The Following are the functionalities implement
1. Provided Login.
2. Registration.
3. Job poster Registration
4. Job Seeker Registration
5. Forgot password
6. Post a new Job
7. Search jobs
7.a Bid on job
7.b Contact us
8. Change password
9. Update User Details.
10. Job Seeker Applied Jobs
11. Job Seeker Applied Job Details
12. List of Posted Jobs
13. Posted Job Details
14. Search jobs
15. Bid on Job.
16. Submit Bid
1. Provided Login.
Home.aspx
<%@ Page Language="C#" MasterPageFile="MainMasterPage.master" AutoEventWireup="true"
CodeFile="Home1.aspx.cs"
Inherits="Home1"
Title="Untitled
Page" %>
<asp:Content ID="Content1"
ContentPlaceHolderID="head"
Runat="Server">
<link type="text/css" rel="stylesheet" href="style.css"/>
<style type="text/css">
.style1
{
width:
418px;
height:
256px;
}
.style2
{
width:
316px;
height:
256px;
}
.style3
{
height:
97px;
}
</style>
<script language="javascript" type="text/javascript">
function
validate()
{
var
id=document.getElementById ("ctl00_ContentPlaceHolder1_txt_user").value;
var
pwd=document.getElementById ("ctl00_ContentPlaceHolder1_txt_pwd").value;
//user
apos=id.indexOf("@");
dotpos=id.lastIndexOf(".");
if(id=="")
{
alert("Enter
Email id");
return false;
}
else if(apos<1||dotpos-apos<2)
{
alert("Enter
Valid Email Id");
return false;
}
//password
if(pwd=="")
{
alert("Enter
the password");
return false;
}
}
</script>
</asp:Content>
<asp:Content ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<body>
<form id="form1" >
<div id="wrapper">
<div id="main1">
<table>
<tr>
<td class="style1" align="center" valign="bottom">
<asp:Image ID="Image2" runat="server" Width="283px" Height="235px"
ImageUrl="images/login.png" />
</td>
<td class="style2">
<table border="0" cellpadding="0" cellspacing="2" width="35%">
<tr>
<td align="center" valign="middle" class="style3">
<asp:Label ID="lbl_message"
runat="server"
CssClass="label"></asp:Label>
</td>
</tr>
<tr>
<td align="left" valign="middle">
<img height="21" src="images/notloggedin_img_05.png"
width="59"
/></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0"
cellspacing="0"
width="314">
<tr>
<td align="center"
bgcolor="#F0F8FF"
bordercolor="#d6d9dc"
height="130"
valign="middle">
<table align="center"
border="0"
cellpadding="0"
cellspacing="0"
width="300">
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table
border="0"
cellpadding="0"
cellspacing="0"
width="100%">
<tr>
<td
align="right"
class="Username"
width="36%">
Email id : </td>
<td
align="left"
height="30"
valign="middle"
width="64%">
<asp:TextBox ID="txt_user"
runat="server"
CssClass="textbox"
Width="131px"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table
border="0"
cellpadding="0"
cellspacing="0"
width="100%">
<tr>
<td
align="right"
class="Username"
width="36%">
Password : </td>
<td align="left" height="30" valign="middle" width="64%">
<asp:TextBox ID="txt_pwd"
runat="server"
CssClass="textbox"
TextMode="Password"
Width="131px"></asp:TextBox></td>
</tr>
</table>
<table
width="100%">
<tr>
<td
width="35%"></td>
<td
align ="left" width="65%">
<asp:CheckBox ID="ChkBxRemMe"
runat="server"
Text="Remember
me?" ForeColor="black" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td
align="right"
width="36%">
</td>
<td
align="left"
height="30"
valign="middle"
width="64%">
<asp:ImageButton ID="btn_login"
runat="server"
ImageUrl="images/login_btn_10.jpg"
OnClick="btn_login_Click" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" bgcolor="#F0F8FF"
class="forgotpassword"
valign="middle">
<asp:LinkButton ID="lbtn_pwd"
runat="server"
Font-Bold="True"
Height="17px"
OnClick="lbtn_pwd_Click"
Width="118px"
CssClass="forgotpassword">Forgot
Password?</asp:LinkButton>
<asp:LinkButton ID="lbtnsignup"
runat="server"
Font-Bold="True"
Height="17px"
OnClick="lbtnsignup_Click"
Width="48px"
CssClass="forgotpassword">SignUp!</asp:LinkButton><a href="#"><span
style="color: #0000ff; text-decoration:
underline"></span></a></td>
</tr>
<tr>
<td align="left" class="forgotpassword" valign="middle" style="height: 50;">
<br />
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div id="container" align="center">
<asp:Image ID="Image1" runat="server" Height="220px"
ImageUrl="images/job2.jpg" Width="782px" />
</div>
</div>
</form>
</body>
</asp:Content>
========================================================================================
Home.aspx.cs
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
public partial class Home1 : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
txt_pwd.Attributes.Add("OnFocus", "javascript:readCookie('"
+ this.Request.Cookies + "');");
lbl_message.Text = "";
}
protected void btn_login_Click(object
sender, ImageClickEventArgs e)
{
Session["UserName"]
= txt_user.Text;
if
(ChkBxRemMe.Checked)
{
HttpCookie
cookie = new HttpCookie(txt_user.Text);
Response.Cookies.Add(cookie);
cookie.Values.Add("", txt_pwd.Text + ";");
Response.Cookies[txt_user.Text].Expires = DateTime.Now.AddDays(15);
}
string
uname = info.Login(txt_user.Text, txt_pwd.Text);
if
(uname == "Poster")
{
Response.Redirect("UserHome.aspx");
}
else if (uname == "Seeker")
{
Response.Redirect("UserHome.aspx");
}
else
{
lbl_message.Text = "Invalid EmailId/Password";
}
}
protected void lbtn_pwd_Click(object
sender, EventArgs e)
{
Response.Redirect("Forgotpassword.aspx");
}
protected void lbtnsignup_Click(object
sender, EventArgs e)
{
Response.Redirect("Registration.aspx");
}
}
=================================================================================
3. Job poster Registration
JobPosterRegistration.aspx
JobPosterRegistration.aspx
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Net.Mail;
public partial class JobPosterRegistration : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
}
protected void btn_submit_Click(object
sender, EventArgs e)
{
try
{
if
(checkbox_term.Checked == true)
{
int
count = Convert.ToInt32(info.JobEmailCount(txt_email.Text));
if
(count == 1)
{
//
Response.Write("<script language='javascript'>alert('Email Already
Exists');</script>");
lbl_mes.Visible = true;
lbl_mes.Text = "Email Already Exists";
}
else
{
string
Type = Request.QueryString["RegType"];
info.InsertJobRegistration(txt_dname.Text,
txt_email.Text, txt_pwd.Text, txt_fname.Text, txt_lname.Text, txt_add.Text,
txt_city.Text, txt_State.Text, ddl_state.SelectedValue, Type);
string
strbody = "<table align=center style=width:
710px; height: 143px><tr><td colspan=3>";
strbody += "<h1 align=center>Welcome To Job Website
</h1></td></tr><tr><td colspan=3>";
strbody += "<tr><td align=center>“You have
Registered Succesfully…”</td></tr>";
strbody += "<tr><td>Thanks for registering your
account. The Job Web Website Adminisrtator will verfity and approve your
account. You will recevie a confrimation
email within 24-72hrs.</td></tr>";
strbody += "</td></tr><tr><td
style=font-weight:bolder; font-family:Verdana; colspan=3>Your Registration
Details:";
strbody += "</td></tr><tr><td colspan=3
style=font-family:Tahoma;font-weight:bold;font-size:small;>Emailid: "
+ txt_email.Text;
strbody += "</td></tr><tr><td colspan=3
style=font-family:Tahoma;font-weight:bold;font-size:small;>Password: "
+ txt_pwd.Text + "</td>";
strbody += "<tr> <td > To activate your Job website
account, please click this link:<a href='projects/JobWebsite/UserHome.aspx'>Click
here</a></td></tr><br/>";
strbody += "</tr><tr><td colspan=3>Have a
Good Day.</td></tr>";
strbody += "<tr><td
align='left'>Sincerely,</td></tr>";
strbody += "<tr><td align='left'> Website
Adminisrtator</td></tr></table>";
System.Net.Mail.MailMessage msg = new
System.Net.Mail.MailMessage();
msg.From = new MailAddress("test@gmail.com");
msg.To.Add(txt_email.Text);//Text Box for To Address
msg.Subject = "kjndkbnkdf"; //Text
Box for subject
msg.IsBodyHtml = true;
msg.Body = strbody;//Text Box for body
msg.Priority = MailPriority.High;
SmtpClient
smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("test@gmail.com", "testeetet");
smtp.EnableSsl = true;
smtp.Send( msg);
Page.RegisterStartupScript("err1", "<script
language='javascript'>alert('Registration
Successfull');</script>");
txt_dname.Text = "";
txt_email.Text = "";
txt_fname.Text = "";
txt_lname.Text = "";
txt_add.Text = "";
txt_city.Text = "";
txt_State.Text = "";
ddl_state.ClearSelection();
checkbox_term.Checked = false;
mess.Visible = true;
lblmesg.Text = "Your Account will be activated within 24
hours";
}
}
else
{
lblmesg.Visible = true;
lblmesg.Text = "Please check the terms and conditions check
box";
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void btn_cancel_Click(object
sender, EventArgs e)
{
txt_dname.Text = "";
txt_email.Text = "";
txt_fname.Text = "";
txt_lname.Text = "";
txt_add.Text = "";
txt_city.Text = "";
txt_State.Text = "";
ddl_state.ClearSelection();
checkbox_term.Checked = false;
lblmesg.Text = "";
lbl_mes.Text = "";
}
protected void ImageButton1_Click(object
sender, ImageClickEventArgs e)
{
Response.Redirect("Registration.aspx");
}
}
}
=================================================================================
5. Forgot password
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Net.Mail;
public partial class JobPosterRegistration : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
}
protected void btn_submit_Click(object
sender, EventArgs e)
{
try
{
if
(checkbox_term.Checked == true)
{
int
count = Convert.ToInt32(info.JobEmailCount(txt_email.Text));
if
(count == 1)
{
//
Response.Write("<script language='javascript'>alert('Email Already
Exists');</script>");
lbl_mes.Visible = true;
lbl_mes.Text = "Email Already Exists";
}
else
{
string
Type = Request.QueryString["RegType"];
info.InsertJobRegistration(txt_dname.Text,
txt_email.Text, txt_pwd.Text, txt_fname.Text, txt_lname.Text, txt_add.Text,
txt_city.Text, txt_State.Text, ddl_state.SelectedValue, Type);
string
strbody = "<table align=center style=width:
710px; height: 143px><tr><td colspan=3>";
strbody += "<h1 align=center>Welcome To Job Website
</h1></td></tr><tr><td colspan=3>";
strbody += "<tr><td align=center>“You have
Registered Succesfully…”</td></tr>";
strbody += "<tr><td>Thanks for registering your
account. The Job Web Website Adminisrtator will verfity and approve your
account. You will recevie a confrimation
email within 24-72hrs.</td></tr>";
strbody += "</td></tr><tr><td
style=font-weight:bolder; font-family:Verdana; colspan=3>Your Registration
Details:";
strbody += "</td></tr><tr><td colspan=3
style=font-family:Tahoma;font-weight:bold;font-size:small;>Emailid: "
+ txt_email.Text;
strbody += "</td></tr><tr><td colspan=3
style=font-family:Tahoma;font-weight:bold;font-size:small;>Password: "
+ txt_pwd.Text + "</td>";
strbody += "<tr> <td > To activate your Job website
account, please click this link:<a href='projects/JobWebsite/UserHome.aspx'>Click
here</a></td></tr><br/>";
strbody += "</tr><tr><td colspan=3>Have a
Good Day.</td></tr>";
strbody += "<tr><td
align='left'>Sincerely,</td></tr>";
strbody += "<tr><td align='left'> Website
Adminisrtator</td></tr></table>";
System.Net.Mail.MailMessage msg = new
System.Net.Mail.MailMessage();
msg.From = new MailAddress("test@gmail.com");
msg.To.Add(txt_email.Text);//Text Box for To Address
msg.Subject = "kjndkbnkdf"; //Text
Box for subject
msg.IsBodyHtml = true;
msg.Body = strbody;//Text Box for body
msg.Priority = MailPriority.High;
SmtpClient
smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("test@gmail.com", "testeetet");
smtp.EnableSsl = true;
smtp.Send( msg);
Page.RegisterStartupScript("err1", "<script
language='javascript'>alert('Registration
Successfull');</script>");
txt_dname.Text = "";
txt_email.Text = "";
txt_fname.Text = "";
txt_lname.Text = "";
txt_add.Text = "";
txt_city.Text = "";
txt_State.Text = "";
ddl_state.ClearSelection();
checkbox_term.Checked = false;
mess.Visible = true;
lblmesg.Text = "Your Account will be activated within 24
hours";
}
}
else
{
lblmesg.Visible = true;
lblmesg.Text = "Please check the terms and conditions check
box";
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void btn_cancel_Click(object
sender, EventArgs e)
{
txt_dname.Text = "";
txt_email.Text = "";
txt_fname.Text = "";
txt_lname.Text = "";
txt_add.Text = "";
txt_city.Text = "";
txt_State.Text = "";
ddl_state.ClearSelection();
checkbox_term.Checked = false;
lblmesg.Text = "";
lbl_mes.Text = "";
}
protected void ImageButton1_Click(object
sender, ImageClickEventArgs e)
{
Response.Redirect("Registration.aspx");
}
}
=======================================================================
6. Post a new Job
PostaJob.aspx
<%@ Page Language="C#" MasterPageFile="MainMaster1.master" AutoEventWireup="true"
CodeFile="PostaJob.aspx.cs" Inherits="PostaJob" Title="Untitled
Page" %>
<asp:Content ID="Content1"
ContentPlaceHolderID="head"
runat="Server">
<style type="text/css">
.style1
{
width:
100%;
height:
705px;
}
.style7
{
font-family:
"Century Gothic";
color:
#1E90FF;
font-size:
12px;
font-weight:
bold;
height:
27px;
}
.style8
{
width:
261px;
}
</style>
<link href="CalendarControl.css" rel="stylesheet"
type="text/css"
/>
<script src="js/CalendarControl.js" type="text/javascript"></script>
</asp:Content>
<asp:Content ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
runat="Server">
<table align="center" class="style1">
<tr>
<td align="center" valign="middle">
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td class="style8">
<asp:Image ID="Image1" runat="server"
Height="335px"
ImageUrl="images/u15.png"
Width="220px"
/>
</td>
<td valign="top">
<table cellpadding="0"
cellspacing="0">
<tr align="center">
<td class="mainheadings">
<br />
Information needed by job poster<br />
</td>
</tr>
<tr>
<td>
<table align="center"
border="0">
<tr class="style7">
<td>
<asp:HyperLink ID="HyperLink1"
runat="server"
NavigateUrl="SearchJob.aspx">Click
here to
view the Posted Jobs</asp:HyperLink>
</td>
</tr>
<tr>
<td
align="left"
colspan="4"
height="30">
<asp:Label ID="lblmesg"
runat="server"
CssClass="label"
Width="352px"></asp:Label>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
Email Address :
</td>
<td align="left"
colspan="3"
height="30">
<asp:TextBox ID="txt_email"
runat="server"
CssClass="textbox"
Width="139px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txt_email"
CssClass="validator"
Display="Dynamic"
ToolTip="Email id
Required!" ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator
ID="RegularExpressionValidator1"
runat="server"
ControlToValidate="txt_email"
CssClass="validator"
ErrorMessage="Valid
Email Id Please!" ToolTip="Valid Email Id Please!"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
ValidationGroup="valid"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
Company Name :
</td>
<td
align="left"
colspan="3"
height="30">
<asp:TextBox ID="txt_CompanyName"
runat="server"
CssClass="textbox"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator2"
runat="server"
ControlToValidate="txt_CompanyName"
CssClass="validator"
ToolTip="First
Name Required!" ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
Date :
</td>
<td
align="left"
colspan="3"
height="30">
<asp:TextBox ID="txt_liendate"
runat="server"
onfocus="showCalendarControl(this)"
Text='<%# Bind("LienDate") %>'></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator3"
runat="server"
ControlToValidate="txt_liendate"
CssClass="validator"
ToolTip="Age
Required!" ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
City :
</td>
<td
align="left"
colspan="3">
<asp:TextBox ID="txt_city"
runat="server"
CssClass="textbox"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator4"
runat="server"
ControlToValidate="txt_city"
CssClass="validator"
ToolTip="City
Required!" ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
Country :
</td>
<td
align="left"
colspan="3"
height="30">
<asp:DropDownList ID="ddl_Country"
runat="server">
<asp:ListItem Selected="True"
Value="0">Choose
Country</asp:ListItem>
<asp:ListItem>United States</asp:ListItem>
<asp:ListItem>Canada</asp:ListItem>
<asp:ListItem>Afghanistan
</asp:ListItem>
<asp:ListItem>Yugoslavia
</asp:ListItem>
<asp:ListItem>Zambia
</asp:ListItem>
<asp:ListItem>Zimbabwe
</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator6"
runat="server"
ControlToValidate="ddl_Country"
CssClass="validator"
Display="Dynamic"
InitialValue="0"
ToolTip="Country
Required!"
ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="Username">
Type of Job :
</td>
<td align="left" colspan="3" height="30">
<asp:DropDownList ID="ddl_JobType" runat="server">
<asp:ListItem Selected="True"
Value="0">Select
Type of Job</asp:ListItem>
<asp:ListItem>Data Entry</asp:ListItem>
<asp:ListItem>Software</asp:ListItem>
<asp:ListItem>Bpo</asp:ListItem>
<asp:ListItem>Other</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator7"
runat="server"
ControlToValidate="ddl_JobType"
CssClass="validator"
Display="Dynamic"
InitialValue="0"
ToolTip="Type of
Request Required!"
ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="center"
class="Username"
colspan="4"
height="30">
Enter your Job Description here, please make it brief and do not use all
CAPS
<asp:RequiredFieldValidator
ID="RequiredFieldValidator8"
runat="server"
ControlToValidate="txt_description"
CssClass="validator"
Display="Dynamic"
ToolTip="Job
Description Requierd!" ValidationGroup="valid"><img
height="15px"
src="images/question.gif"
width="15px"
/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="center"
colspan="4">
<asp:TextBox ID="txt_description" runat="server" CssClass="textbox" Height="170px"
Rows="5" TextMode="MultiLine"
Width="365px"></asp:TextBox>
</td>
</tr>
<tr>
<td
align="center"
colspan="4"
height="30">
<asp:Button ID="btn_sub"
runat="server"
OnClick="btn_sub_Click"
Text="Post
Job" ValidationGroup="valid"
Width="151px"
/>
<asp:Button ID="Button1"
runat="server"
OnClick="Button1_Click"
Text="Reset
Form" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</asp:Content>
PostaJob.aspx.cs
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
public partial class PostaJob : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
if
(Session["UserName"].ToString() ==
"")
{
Response.Redirect("Home1.aspx");
}
HyperLink1.Visible = false;
}
protected void btn_sub_Click(object
sender, EventArgs e)
{
info.InsertJobDetails(txt_email.Text,
txt_CompanyName.Text, Convert.ToDateTime(txt_liendate.Text),
txt_city.Text, ddl_Country.SelectedValue, ddl_JobType.SelectedValue,
txt_description.Text);
lblmesg.Text = "Your
Job Details Posted Succesfully";
HyperLink1.Visible = true;
txt_email.Text = "";
txt_CompanyName.Text = "";
txt_liendate.Text = "";
txt_city.Text = "";
ddl_Country.ClearSelection();
ddl_JobType.ClearSelection();
txt_description.Text = "";
}
protected void Button1_Click(object
sender, EventArgs e)
{
txt_email.Text = "";
txt_CompanyName.Text = "";
txt_liendate.Text = "";
txt_city.Text = "";
ddl_Country.ClearSelection();
ddl_JobType.ClearSelection();
txt_description.Text = "";
HyperLink1.Visible = false;
}
}
=======================================================================================
7. Search jobs
SearchJob.aspx
===================================================================
SearchJob.aspx.cs
<%@ Page Language="C#" MasterPageFile="MainMaster1.master" AutoEventWireup="true"
CodeFile="SearchJob.aspx.cs" Inherits="SearchJob"
Title="Untitled
Page" %>
<asp:Content ID="Content1"
ContentPlaceHolderID="head"
runat="Server">
<style type="text/css">
.style1
{
width:
100%;
height:
404px;
}
.style2
{
width:
62px;
}
</style>
</asp:Content>
<asp:Content ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
runat="Server">
<table align="center" class="style1">
<tr class="mainheadings" align="center">
<td>
<br />
List of Posted Jobs
<br />
<br />
</td>
</tr>
<tr align="center">
<td>
<asp:DataList ID="ddl_PostedJobs" ForeColor="#000000" BackColor="#ffffff" CellPadding="3"
GridLines="Both" runat="server" RepeatColumns="1" RepeatDirection="vertical"
OnItemCommand="ddl_PostedJobs_ItemCommand">
<ItemStyle font-name="tahoma,arial,sans-serif" Font-Size="10"
BackColor="#ffffff"
/>
<AlternatingItemStyle font-name="tahoma,arial,sans-serif" Font-Size="10"
BackColor="#F0F8FF"
/>
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#738A9C"></SelectedItemStyle>
<ItemTemplate>
<table>
<tr>
<td>
<h5 align="right">
Company
Name :</h5>
</td>
<td align="left"
valign="middle">
<asp:Label runat="server"
ID="NameLabel"
Text='<%# Eval("JP_Company") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5 align="right">
DatePosted :</h5>
</td>
<td align="left"
valign="middle">
<asp:Label ID="Label1" runat="server" Text='<%# Eval("JP_DatePosted") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5 align="right">
Country Name :</h5>
</td>
<td align="left" valign="middle">
<asp:Label ID="Label2" runat="server"
Text='<%# Eval("JP_Country") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5
align="right">
Job Type :</h5>
</td>
<td align="left"
valign="middle">
<asp:Label ID="Label3" runat="server"
Text='<%# Eval("JP_JobType") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5
align="right">
Description :</h5>
</td>
<td align="left"
valign="middle">
<asp:Label ID="Label4" runat="server"
Text='<%# Eval("JP_Description") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<asp:ImageButton ID="ImageButton1"
CommandName="test"
runat="server"
Height="57px"
ImageUrl="images/sb.jpg"
Width="166px"
/>
</td>
</tr>
<caption>
<tr>
<td>
<asp:Label ID="JobPostedID"
Visible="false"
runat="server"
Text='<%# Eval("JP_Id") %>' />
</td>
</tr>
</caption>
</caption>
</caption>
</caption>
</caption>
</caption>
</table>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
<tr>
<td class="style2">
</td>
</tr>
</table>
</asp:Content>
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
public partial class SearchJob : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
if
(Session["UserName"].ToString() ==
"")
{
Response.Redirect("Home1.aspx");
}
if
(!IsPostBack)
{
PostedJobs();
}
}
private void PostedJobs()
{
DataSet
PostedJob = info.BindPostedJobs();
ddl_PostedJobs.DataSource = PostedJob;
ddl_PostedJobs.DataBind();
}
protected void ddl_PostedJobs_ItemCommand(object source, DataListCommandEventArgs
e)
{
if
(e.CommandName == "test")
{
Label
lab1 = (Label)ddl_PostedJobs.Items[e.Item.ItemIndex].FindControl("JobPostedID");
string
id = lab1.Text;
Response.Redirect("BidJob.aspx?SelectedJob=" + id);
}
}
}
=================================================================================
click here This is code for change password
9. Update User Details.
UpdateProfile.aspx
<%@ Page Language="C#" MasterPageFile="MainMaster1.master" AutoEventWireup="true"
CodeFile="UpdateProfile.aspx.cs" Inherits="UpdateProfile"
%>
<asp:Content ID="Content1"
ContentPlaceHolderID="head"
runat="Server">
<style type="text/css">
.style1
{
width:
184px;
}
</style>
</asp:Content>
<asp:Content ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
runat="Server">
<table align="center"
border="0"
cellpadding="0"
cellspacing="0">
<tr>
<td class="style1">
</td>
<td align="center" valign="middle">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="width: 328px">
<tr>
<td align="center" colspan="4" style="font-size: 12pt; color: #ffffff; height: 19px">
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="4" style="font-size: 12pt; color: #ffffff">
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="4" style="font-size: 14pt; text-align: center">
<span style="font-size: 14pt; color: #006600; text-decoration:
underline"><strong
style="color: #800080">Personal
Information<br
/>
<br />
</strong></span>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="4" style="font-size: 14pt">
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 24px;">
<strong style="color: #800080">Display
Name:<span
style="color: #ffcc00"></span></strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; color: #ffffff; width: 13px;
height: 24px;">
<span style="color: #ff0000; font-weight: bold;"></span>
</td>
<td align="left" colspan="2" style="height: 24px">
<asp:TextBox ID="txtDName"
runat="server"
ValidationGroup="g1"
Width="189px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff">
<strong style="color: #800080">Email:</strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; color: #ffffff; width: 13px;">
<span style="color: #ff0000; font-weight:
bold;"></span>
</td>
<td align="left" colspan="2">
<asp:TextBox ID="txteMail"
runat="server"
ValidationGroup="g1"
Width="189px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 24px;">
<strong style="color: #800080">FirstName:</strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; color: #ffffff; width: 13px;
height: 24px;">
<span style="color: #ff0000; font-weight:
bold;"></span>
</td>
<td align="left" colspan="2" style="height: 24px">
<asp:TextBox ID="txtFname"
runat="server"
Style="position: relative"
Width="189px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 24px;">
<strong style="color: #800080">LastName:</strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; color: #ffffff; width: 13px;
height: 24px;">
<span style="color: #ff0000; font-weight:
bold;"></span>
</td>
<td align="left" colspan="2" style="height: 24px">
<asp:TextBox ID="txtLname"
runat="server"
Style="position: relative"
Width="189px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 79px;">
<strong style="color: #800080">Address:<span style="color: #ffcc00"></span></strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; color: #ffffff; height: 79px;
width: 13px;">
<span style="color: #ff0000; font-weight:
bold;"></span>
</td>
<td align="left" colspan="2" style="height: 79px">
<asp:TextBox ID="txtAddress"
runat="server"
Height="71px"
TextMode="MultiLine"
ValidationGroup="g1"
Width="189px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 7px">
<strong><span style="color: #800080">City:</span></strong>
</td>
<td align="left" colspan="1" style="font-size: 12pt; width: 13px; color: #ffffff;
height: 7px">
</td>
<td align="left" colspan="2" style="height: 7px">
<asp:TextBox ID="txtCity"
runat="server"
Style="position: relative"
Width="208px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 7px">
<strong><span style="color: #800080">State:</span></strong><span style="color: #ffcc00"><br />
</span>
</td>
<td align="left" colspan="1" style="font-size: 12pt; width: 13px; color: #ffffff;
height: 7px">
</td>
<td align="left" colspan="2" style="height: 7px">
<asp:TextBox ID="txtState"
runat="server"
Style="position: relative"
Width="207px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 7px">
<strong><span style="color: #800080">Country:</span></strong><span style="color: #ffcc00"><br />
</span>
</td>
<td align="left" colspan="1" style="font-size: 12pt; width: 13px; color: #ffffff;
height: 7px">
</td>
<td align="left" colspan="2" style="height: 7px">
<asp:TextBox ID="txtCountry"
runat="server"
Style="position: relative"
Width="207px"></asp:TextBox>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="left" colspan="1" style="font-size: 12pt; width: 151px; color: #ffffff;
height: 7px">
</td>
<td align="left" colspan="1" style="font-size: 12pt; width: 13px; color: #ffffff;
height: 7px">
</td>
<td align="left" colspan="2" style="height: 7px">
</td>
</tr>
<tr style="font-size: 12pt">
<td align="center" colspan="4">
</td>
</tr>
<tr style="font-size: 12pt">
<td align="center" colspan="4">
<asp:Button ID="btnUpdate"
runat="server"
OnClick="btnUpdate_Click"
Text="Update"
Width="55px"
/> <asp:Button ID="btnBack"
runat="server"
OnClick="btnBack_Click"
Text="Back" Width="55px"
/>
<br />
</td>
</tr>
<tr style="font-size: 12pt">
<td align="center" colspan="5" style="font-size: 12pt; color: #ffffff">
<asp:Label ID="lblMsg" runat="server"
Font-Bold="True"
Font-Size="13pt"
ForeColor="#C000C0"
Width="484px"></asp:Label>
</td>
</tr>
<tr style="font-size: 12pt">
<td align="center" colspan="5" style="font-size: 12pt; color: #ffffff">
<br />
<br />
<br />
<br />
<br />
<br />
</td>
</tr>
</table>
</td>
<td>
</td>
</tr>
</table>
</asp:Content>
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
public partial class UpdateProfile : System.Web.UI.Page
{
AdminDal
AdmDal = new AdminDal();
protected void Page_Load(object
sender, EventArgs e)
{
if
(Session["UserName"].ToString() ==
"")
{
Response.Redirect("Home1.aspx");
}
if
(!IsPostBack)
{
BindData();
}
}
private void BindData()
{
AdmDal.JobSeekerId = Session["UserName"].ToString();
DataSet
ds = new DataSet();
ds = AdmDal.GetAdminRegisteredUser();
if
(ds.Tables[0].Rows.Count > 0)
{
txtDName.Text =
ds.Tables[0].Rows[0]["JR_DisplayName"].ToString();
txteMail.Text =
ds.Tables[0].Rows[0]["JR_Email"].ToString();
txtFname.Text =
ds.Tables[0].Rows[0]["JR_FirstName"].ToString();
txtLname.Text =
ds.Tables[0].Rows[0]["JR_LastName"].ToString();
txtAddress.Text =
ds.Tables[0].Rows[0]["JR_Address"].ToString();
txtCity.Text =
ds.Tables[0].Rows[0]["JR_City"].ToString();
txtState.Text =
ds.Tables[0].Rows[0]["JR_State"].ToString();
txtCountry.Text =
ds.Tables[0].Rows[0]["JR_Country"].ToString();
}
}
protected void btnUpdate_Click(object
sender, EventArgs e)
{
if
(Session["UserName"].ToString() ==
txteMail.Text)
{
AdmDal.UpdateUser(txtDName.Text,
txteMail.Text, txtFname.Text, txtLname.Text, txtAddress.Text, txtCity.Text,
txtState.Text, txtCountry.Text);
txtDName.Text = "";
txteMail.Text = "";
txtFname.Text = "";
txtLname.Text = "";
txtAddress.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtCountry.Text = "";
lblMsg.Text = "Your Account Updated Succesfully";
}
else{
int
count = Convert.ToInt32(AdmDal.JobEmailCount(txteMail.Text));
if
(count == 1)
{
lblMsg.Text = "Email Already Exists";
}
else
{
AdmDal.UpdateUser(txtDName.Text,
txteMail.Text, txtFname.Text, txtLname.Text, txtAddress.Text, txtCity.Text,
txtState.Text, txtCountry.Text);
txtDName.Text = "";
txteMail.Text = "";
txtFname.Text = "";
txtLname.Text = "";
txtAddress.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtCountry.Text = "";
lblMsg.Text = "Your Account Updated Succesfully";
}
}
}
protected void btnBack_Click(object
sender, EventArgs e)
{
Response.Redirect("UserHome.aspx");
}
}
=================================================================================
10. Bid on job:
BidJob.aspx
<%@ Page Language="C#" MasterPageFile="MainMaster1.master" AutoEventWireup="true"
CodeFile="BidJob.aspx.cs" Inherits="BidJob" Title="Untitled Page" %>
<asp:Content ID="Content1"
ContentPlaceHolderID="head"
runat="Server">
<style type="text/css">
.style1
{
width:
100%;
height:
544px;
}
.style2
{
width:
100%;
height:
612px;
}
.style3
{
height:
200px;
width:
853px;
}
.style4
{
width:
100%;
height:
483px;
}
.style5
{
width:
182px;
}
.style10
{
font-family:
Tahoma;
font-size:
11px;
font-weight:
bold;
color:
#000000;
width:
28%;
}
.style11
{
width: 518px;
}
.style12
{
width:
853px;
}
.style13
{
height:
58px;
width:
372px;
}
.style14
{
width:
372px;
}
.style15
{
height:
158px;
}
.style16
{
height:
53px;
}
</style>
<link href="CalendarControl.css" rel="stylesheet"
type="text/css"
/>
<script src="js/CalendarControl.js" type="text/javascript"></script>
<script type="text/javascript">
function
allowonlynumbers() {
if
(event.keyCode >= 48 && event.keyCode <= 57) {
return
true;
}
else
{
alert('Only
numbers can be entered.'); return false;
}
}
</script>
</asp:Content>
<asp:Content ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
runat="Server">
<table border="1" align="center" class="style1">
<tr>
<td align="center">
<table align="center" class="style2">
<tr valign="top">
<td align="center" class="style3">
<table>
<tr class="mainheadings"
align="center">
<td class="style16">
<br />
Information needed by job Bidder
</td>
</tr>
<tr>
<td class="style15">
<asp:DataList ID="DtlBidJob"
ForeColor="#000000"
BackColor="#ffffff"
CellPadding="3"
GridLines="Both"
runat="server">
<ItemStyle font-name="tahoma,arial,sans-serif"
Font-Size="10"
BackColor="#ffffff"
/>
<ItemTemplate>
<table>
<tr>
<td>
<h5
align="right">
Company Name :</h5>
</td>
<td
align="left"
valign="middle">
<asp:Label runat="server"
ID="NameLabel"
Text='<%# Eval("JP_Company") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5
align="right">
DatePosted :</h5>
</td>
<td
align="left"
valign="middle">
<asp:Label ID="Label1" runat="server"
Text='<%# Eval("JP_DatePosted") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5
align="right">
Country Name :</h5>
</td>
<td
align="left"
valign="middle">
<asp:Label ID="Label2" runat="server"
Text='<%# Eval("JP_Country") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5
align="right">
Job Type :</h5>
</td>
<td
align="left"
valign="middle">
<asp:Label ID="Label3" runat="server"
Text='<%# Eval("JP_JobType") %>' />
</td>
</tr>
<caption>
<tr>
<td>
<h5 align="right">
Description :</h5>
</td>
<td
align="left"
valign="middle">
<asp:Label ID="Label4" runat="server"
Text='<%# Eval("JP_Description") %>' />
</td>
</tr>
<caption>
<caption>
</caption>
</caption>
</caption>
</caption>
</caption>
</caption>
</table>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="style12">
<table border="0" align="center"
class="style4">
<tr>
<td class="style5"
align="right">
<asp:Image ID="Image1" runat="server"
Height="303px"
ImageUrl="images/u25.jpg"
Width="373px"
/>
</td>
<td align="left"
class="style11">
<table>
<tr>
<td class="style13" align="center">
<asp:Label ID="lblmesg"
runat="server"
CssClass="label"
Width="352px"></asp:Label>
</td>
</tr>
<tr>
<td
class="style14">
<table>
<tr>
<td
align="right"
class="style10">
Bid Date :
</td>
<td
align="left"
style="width: 50%">
<asp:TextBox ID="txt_liendate"
runat="server"
onfocus="showCalendarControl(this)"
Text='<%# Bind("LienDate") %>'></asp:TextBox>
<asp:RequiredFieldValidator
ID="rfvemail0"
runat="server"
ControlToValidate="txt_liendate"
ToolTip="Email
Required!" Display="Dynamic" ValidationGroup="valid"><img
src="images/question.gif"
width="15px"
height="15px"/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="style10">
Bid Rate :
</td>
<td
align="left"
style="width: 50%">
<asp:TextBox ID="txt_BidRate"
runat="server"
CssClass="textbox"
onkeypress="return
allowonlynumbers();"></asp:TextBox><%--onkeydown=" if ( !isAlpha ( event ) ) { alert ( 'Oops! Alphabets only please.'
); return
false; }"--%>
<asp:RequiredFieldValidator
ID="rfvfname"
runat="server"
ControlToValidate="txt_BidRate"
ToolTip="First
Name Required!" ValidationGroup="valid"><img
src="images/question.gif"
width="15px"
height="15px"/></asp:RequiredFieldValidator>
<br
/>
</td>
</tr>
<tr>
<td
align="right"
class="style10">
Work Type :
</td>
<td
align="left"
style="width: 50%">
<asp:DropDownList ID="ddl_Rate"
runat="server"
OnTextChanged="ddl_Rate_TextChanged">
<asp:ListItem Value="" Selected="True">--
Select --</asp:ListItem>
<asp:ListItem Value="Hourly
Rate">Hourly Rate</asp:ListItem>
<asp:ListItem Value="Daily
Rate">Daily Rate</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator3"
runat="server"
ControlToValidate="ddl_Rate"
ToolTip="work
type Required!" ValidationGroup="valid"><img
src="images/question.gif"
width="15px"
height="15px"/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="style10">
Description:
</td>
<td
align="left"
style="width: 50%">
<asp:TextBox ID="Txt_Description"
runat="server"
CssClass="textbox"
Height="66px"
Width="259px"
TextMode="MultiLine"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1"
runat="server"
ControlToValidate="Txt_Description"
ToolTip="Description
Required!" ValidationGroup="valid"><img
src="images/question.gif"
width="15px"
height="15px"/></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td
align="right"
class="style10">
</td>
<td
align="left"
style="width: 50%">
<asp:Button ID="btn_submit" runat="server" OnClick="btn_submit_Click" Text="Submit"
ValidationGroup="valid"
/>
<asp:Button ID="btn_cancel"
runat="server"
OnClick="btn_cancel_Click"
Text="Reset"
/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</asp:Content>
BidJob.aspx.cs
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
public partial class BidJob : System.Web.UI.Page
{
Dal info
= new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
if(
Session["UserName"].ToString() =="")
{
Response.Redirect("Home1.aspx");
}
if
(Request.QueryString["SelectedJob"]
!= null)
{
if
(!IsPostBack)
{
BindSelectedJob();
}
}
else
{
Response.Redirect("SearchJob.aspx");
}
}
private void BindSelectedJob()
{
string
Jid = Request.QueryString["SelectedJob"];
DataSet
SelectedJob = info.SelectedBidJob(Jid);
DtlBidJob.DataSource = SelectedJob;
DtlBidJob.DataBind();
}
protected void btn_submit_Click(object
sender, EventArgs e)
{
string
Jid = Request.QueryString["SelectedJob"];
string
UserEmail = Session["UserName"].ToString();
info.JobBidInsertion(Jid, UserEmail, Convert.ToDateTime(txt_liendate.Text),
txt_BidRate.Text + " " + ddl_Rate.SelectedValue,
Txt_Description.Text);
lblmesg.Text="Your
bid Details Posted Succesfully";
txt_liendate.Text = "";
txt_BidRate.Text="";
ddl_Rate.ClearSelection();
Txt_Description.Text = "";
}
protected void btn_cancel_Click(object
sender, EventArgs e)
{
lblmesg.Text = "";
txt_liendate.Text = "";
txt_BidRate.Text = "";
ddl_Rate.ClearSelection();
Txt_Description.Text = "";
}
protected void ddl_Rate_TextChanged(object
sender, EventArgs e)
{
if
(txt_BidRate.Text.Trim().Length == 0)
{
Page.RegisterStartupScript("err1", "<script
language='javascript'>alert('Select Bid Rate !');</script>");
}
else
{
}
}
}
=================================================================================
Dal info = new Dal();
protected void Page_Load(object
sender, EventArgs e)
{
}
protected void btnsubmit_Click(object
sender, EventArgs e)
{
try
{
info.InsertContactUsDetails(ddltopic.SelectedValue,
txtname.Text,txtemail.Text, txtmsg.Text);
string
strbody = "<table align=center style=width:
710px; height: 143px><tr><td colspan=3>";
strbody += "<h1
align=center>Welcome To Job Website
</h1></td></tr><tr><td colspan=3>";
strbody += "<tr><td
align=center>“Thanks for sending…”</td></tr>";
strbody += "</td></tr><tr><td
colspan=3
style=font-family:Tahoma;font-size:small;><b>Topic:</b> "
+ ddltopic.SelectedValue;
strbody += "</td></tr><tr><td
colspan=3
style=font-family:Tahoma;font-size:small;><b>Name:</b> "
+ txtname.Text + "</td>";
strbody += "</td></tr><tr><td
colspan=3
style=font-family:Tahoma;font-size:small;><b>Message:</b> "
+ txtmsg.Text + "</td>";
strbody += "</td></tr><tr><td
colspan=3 style=font-family:Tahoma;font-size:small;>We will Contact you soon
! ! ! </td>";
const
string server = "relay-hosting.secureserver.net";
MailMessage
omail = new System.Web.Mail.MailMessage();
omail.From = "test@gmail.com";
omail.To = txtemail.Text;
omail.Subject = "WelCome to Job Website";
omail.BodyFormat = MailFormat.Html; //
enumeration
omail.Priority = MailPriority.High; //
enumeration
omail.Body = strbody;
SmtpMail.SmtpServer
= server;
SmtpMail.Send(omail);
txtmsg.Text = "";
txtname.Text = "";
txtemail.Text = "";
ddltopic.SelectedValue = "I have a general question or inquiry";
lblmsg.Text = "Your Query has been sent ";
}
catch
{
txtmsg.Text = "";
txtname.Text = "";
txtemail.Text = "";
ddltopic.SelectedValue = "I have a general question or inquiry";
lblmsg.Text = "Your Query has not sent ";
}
}
================================================================================
code for dal.cs :
public static string
username;
public static string
password;
#region Global Declaration
SqlConnection
con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString);
SqlCommand
cmd, cmd1, cmd2;
SqlCommand
cmdlogin, cmdlogin1;
DataTable
dt = new DataTable();
SqlDataAdapter
da;
#endregion
public string Login(string
Email, string Password)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommand
cmdlogin1 = new SqlCommand("JB_loginuser", con);
cmdlogin1.CommandType = CommandType.StoredProcedure;
cmdlogin1.Parameters.AddWithValue("@P_userid", Email);
cmdlogin1.Parameters.AddWithValue("@P_password", Password);
SqlDataReader
dr = cmdlogin1.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
Email = dr[0].ToString();
dr.Close();
SqlCommand
cmd1 = new SqlCommand("select JR_Type from JobRegistration where
JR_Email='" + Email + "'",
con);
SqlDataAdapter
da1 = new SqlDataAdapter(cmd1);
DataSet
ds1 = new DataSet();
da1.Fill(ds1);
string
str = ds1.Tables[0].Rows[0]["JR_Type"].ToString();
if
(str == "Poster")
{
return
"Poster";
}
else
{
return
"Seeker";
}
}
else
{
return
"Invalid Username/Password.....";
}
}
public void InsertJobRegistration(string
DisplayName, string Email, string Password, string
FirstName, string LastName, string Address, string
City, string State, string
Country, string Type)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("Job_Registration_Insertion",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_DisplayName", DisplayName);
cmd.Parameters.AddWithValue("@P_Email", Email);
cmd.Parameters.AddWithValue("@P_Password", Password);
cmd.Parameters.AddWithValue("@P_FirstName", FirstName);
cmd.Parameters.AddWithValue("@P_LastName", LastName);
cmd.Parameters.AddWithValue("@P_Address", Address);
cmd.Parameters.AddWithValue("@P_City", City);
cmd.Parameters.AddWithValue("@P_State", State);
cmd.Parameters.AddWithValue("@P_Country", Country);
cmd.Parameters.AddWithValue("@P_Type", Type);
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertJobDetails(string
Email, string CompanyName, DateTime Date, string
City, string Country, string
TypeOfJob, string Description)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("PostedJobs_Insertion",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_Email", Email);
cmd.Parameters.AddWithValue("@P_Company", CompanyName);
cmd.Parameters.AddWithValue("@P_DatePosted", Date);
cmd.Parameters.AddWithValue("@P_City", City);
cmd.Parameters.AddWithValue("@P_Country", Country);
cmd.Parameters.AddWithValue("@P_JobType", TypeOfJob);
cmd.Parameters.AddWithValue("@P_Description", Description);
cmd.ExecuteNonQuery();
con.Close();
}
public void JobBidInsertion(string
Jid, string Email, DateTime
Date,string
BidRate, string Description)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("BiddedJob_Insertion",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_JobId", Jid);
cmd.Parameters.AddWithValue("@P_UserEmail", Email);
cmd.Parameters.AddWithValue("@P_BiddedDate", Date);
cmd.Parameters.AddWithValue("@P_BidRate", BidRate);
cmd.Parameters.AddWithValue("@P_Description", Description);
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet BindPostedJobs()
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = new
SqlCommand("Get_PostedJobs",
con);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataAdapter
da = new SqlDataAdapter(cmd1);
DataSet
ds = new DataSet();
da.Fill(ds);
return
ds;
}
public DataSet SelectedBidJob(string
JobId)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = new
SqlCommand("Get_SelectedBidJob",
con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@P_JobId", JobId);
//cmd1.ExecuteNonQuery();
SqlDataAdapter
da = new SqlDataAdapter(cmd1);
DataSet
ds = new DataSet();
da.Fill(ds);
return
ds;
}
public bool Passworddetails(string
Email)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmdlogin = new
SqlCommand("JB_forgotpwd",
con);
cmdlogin.CommandType = CommandType.StoredProcedure;
cmdlogin.Parameters.AddWithValue("@P_email", Email);
SqlDataReader
dr = cmdlogin.ExecuteReader();
if
(dr.HasRows)
{
dr.Read();
username = dr[0].ToString();
password = dr[2].ToString();
return
true;
}
else
{
return
false;
}
}
public int JobEmailCount(string
Email)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("Job_EmailCount",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar).Value = Email;
int
count = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return
count;
}
public void InsertContactUsDetails(string
Topic, string Name, string
Email, string Message)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("ContactUS_Details",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_Topic", Topic);
cmd.Parameters.AddWithValue("@P_Name", Name);
cmd.Parameters.AddWithValue("@P_Email", Email);
cmd.Parameters.AddWithValue("@P_Message", Message);
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet UserPasswordVerify(string UserEmail)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd1 = new
SqlCommand("Get_UserPasswordVerify",
con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@UserName", UserEmail);
SqlDataAdapter
da = new SqlDataAdapter(cmd1);
DataSet
ds = new DataSet();
da.Fill(ds);
return
ds;
}
public void ModifyUserLoginInfo(string
Email, string PassWord)
{
if
(con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
cmd = new
SqlCommand("Update_UserLoginInfo",
con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", Email);
cmd.Parameters.AddWithValue("@Password", PassWord);
cmd.ExecuteNonQuery();
con.Close();
}







