fnlcss

body
{
PADDING-RIGHT: 10px;
PADDING-LEFT: 10px;
padding-top :10px;

FONT-SIZE: 11px;
PADDING-BOTTOM: 10px;
MARGIN: 2px 5px 0px;

COLOR: Black;
/*SCROLLBAR-3DLIGHT-COLOR: #fff0c1;
SCROLLBAR-ARROW-COLOR: white;
SCROLLBAR-HIGHLIGHT-COLOR: #dbdac4;
SCROLLBAR-FACE-COLOR: #dbdac4;*/

/*#c1dad0*/

FONT-FAMILY: Verdana;
BACKGROUND-COLOR: #EFDAF2;
}
.Txtb
{

background-color:Gray;
font-style:italic;
font-family:Verdana;
font-size:medium;
color : White;

}
.Err
{
/*font-weight: bold;
font-size: 11px;
color: red;
font-family: Tahoma,Verdana;
background-color: transparent;*/
}

fnlc

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Text.RegularExpressions;
using System.Text;
using System.Globalization;
using System.Data.Sql;
using System.Data.SqlClient;




public partial class Empform : System.Web.UI.Page
{
int output;
DataSet ds = new DataSet();
SqlConnection con;
//Here we declare the parameter which we have to use in our application
SqlCommand cmd = new SqlCommand();
SqlParameter sp1 = new SqlParameter();
SqlParameter sp2 = new SqlParameter();
SqlParameter sp3 = new SqlParameter();
SqlParameter sp4 = new SqlParameter();
SqlParameter sp5 = new SqlParameter();
SqlParameter sp6 = new SqlParameter();
SqlParameter sp7 = new SqlParameter();
SqlParameter sp8 = new SqlParameter();
SqlParameter sp9 = new SqlParameter();
SqlParameter op = new SqlParameter();



protected void button_submit_Click(object sender, EventArgs e)
{
con = new SqlConnection("server=10.4.141.46 ; database = HRSS; uid = hrss ; pwd= hrss01");
cmd = new SqlCommand("Emp_info_Insert", con);
cmd.CommandType = CommandType.StoredProcedure;

sp1 = cmd.Parameters.Add("@emp_no", SqlDbType.VarChar, 10);
sp1.Direction = ParameterDirection.Output;

sp2 = cmd.Parameters.Add("@emp_name", SqlDbType.VarChar, 12);
sp2.Value = txt_emp_name.Text;
sp3 = cmd.Parameters.Add("@dob", SqlDbType.DateTime);
sp3.Value = txt_dob.Text;
sp4 = cmd.Parameters.Add("@email_id", SqlDbType.VarChar, 20);
sp4.Value = txt_email_id.Text;
sp5 = cmd.Parameters.Add("@date_joining", SqlDbType.DateTime);
sp5.Value = txt_date_of_joining.Text;
sp6 = cmd.Parameters.Add("@contact_no", SqlDbType.VarChar, 12);
sp6.Value = txt_contact_no.Text;
sp7 = cmd.Parameters.Add("@address", SqlDbType.VarChar, 30);
sp7.Value = txt_address.Text;
sp8 = cmd.Parameters.Add("@gender", SqlDbType.VarChar, 30);
sp8.Value = radio_gender.SelectedValue;
sp9 = cmd.Parameters.Add("@department", SqlDbType.VarChar, 30);
sp9.Value = dropdown_dept.SelectedValue;



con.Open();
cmd.ExecuteNonQuery();
con.Close();
label_insert.Visible = true;
txt_emp_no_asgnd.Visible = true;
txt_emp_no_asgnd.Text = cmd.Parameters["@emp_no"].Value.ToString();
Txt_Emp_no.Text = txt_emp_no_asgnd.Text;

}

protected void Button1_Click(object sender, EventArgs e)
{

con = new SqlConnection("server=10.4.141.46 ; database = HRSS; uid = hrss ; pwd= hrss01");
cmd = new SqlCommand("Emp_info_Update", con);
cmd.CommandType = CommandType.StoredProcedure;

sp1 = cmd.Parameters.Add("@emp_no", SqlDbType.VarChar, 10);
sp1.Value = Txt_Emp_no.Text;
sp2 = cmd.Parameters.Add("@emp_name", SqlDbType.VarChar, 12);
sp2.Value = txt_emp_name.Text;
sp3 = cmd.Parameters.Add("@dob", SqlDbType.DateTime);
sp3.Value = txt_dob.Text;
sp4 = cmd.Parameters.Add("@email_id", SqlDbType.VarChar, 20);
sp4.Value = txt_email_id.Text;
sp5 = cmd.Parameters.Add("@date_joining", SqlDbType.DateTime);
sp5.Value = txt_date_of_joining.Text;
sp6 = cmd.Parameters.Add("@contact_no", SqlDbType.VarChar, 12);
sp6.Value = txt_contact_no.Text;
sp7 = cmd.Parameters.Add("@address", SqlDbType.VarChar, 30);
sp7.Value = txt_address.Text;
sp8 = cmd.Parameters.Add("@gender", SqlDbType.VarChar, 30);
sp8.Value = radio_gender.SelectedValue;
sp9 = cmd.Parameters.Add("@department", SqlDbType.VarChar, 30);
sp9.Value = dropdown_dept.SelectedValue;


op = cmd.Parameters.Add("@op", SqlDbType.VarChar, 1);

op.Direction = ParameterDirection.Output;


con.Open();
cmd.ExecuteNonQuery();
label_update.Visible = true;

con.Close();
output = Convert.ToInt32((cmd.Parameters["@op"].Value));
if (output == 1)
{
label_update.Text = "Entry Updated successfully ! ";
clearall();
}
else
label_update.Text = "No record found, please enter correct Employee number";
}

protected void Button2_Click(object sender, EventArgs e)
{

con = new SqlConnection("server=10.4.141.46 ; database = HRSS; uid = hrss ; pwd= hrss01");
cmd = new SqlCommand("Emp_info_Delete", con);
cmd.CommandType = CommandType.StoredProcedure;

sp1 = cmd.Parameters.Add("@emp_no", SqlDbType.VarChar, 10);
sp1.Value = Txt_Emp_no.Text;


op = cmd.Parameters.Add("@op", SqlDbType.Int);

op.Direction = ParameterDirection.Output;

con.Open();
cmd.ExecuteNonQuery();
label_delete.Visible = true;
con.Close();
output = Convert.ToInt32((cmd.Parameters["@op"].Value));
if (output == 1)
{
label_delete.Text = "Entry deleted successfully ! ";
clearall();
}
else
label_delete.Text = "No record found, please enter correct Employee number";


}

protected void cal_date_of_joining_SelectionChanged(object sender, EventArgs e)
{
txt_date_of_joining.Text = cal_date_of_joining.SelectedDate.ToString("MM/dd/yyyy");
}
protected void cal_dob_SelectionChanged(object sender, EventArgs e)
{
txt_dob.Text = cal_dob.SelectedDate.ToString("MM/dd/yyyy");
}



protected void Page_Load(object sender, EventArgs e)
{
CompareValidator_dob.ValueToCompare = DateTime.Now.AddYears(-18).ToShortDateString();
label_delete.Visible = false;
label_insert.Visible = false;
label_update.Visible = false;
txt_emp_no_asgnd.Visible = false;

if (!Page.IsPostBack )
Txt_Emp_no.Text = "000000";

}

protected void clearall()
{
Txt_Emp_no.Text = "";
txt_emp_name.Text = "";
txt_email_id.Text = "";
txt_dob.Text = "";
txt_date_of_joining.Text = "";
txt_contact_no.Text = "";
txt_address.Text = "";
}


}

fnl

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Emp_form.aspx.cs" Inherits="Empform" %>

Please enter your details:

* Only Emp_no needs to provided in case of deleting a record.

* In case of inserting a new record use New Entry button. Don't Enter any value
in Employee number column.

* In case of changing an already exixsting record, use the Update button.

Employee number                   
:

ErrorMessage= "*The Entry cannot be left blank"
ControlToValidate= "Txt_Emp_no" SetFocusOnError="True" />


ErrorMessage= "*Entry should be a six digit number only"
ControlToValidate="Txt_Emp_no"
ValidationExpression = "\d\d\d\d\d\d" CssClass="Err" />


Employee name                   
    :

ErrorMessage= "*The Entry cannot be left blank"
ControlToValidate= "Txt_emp_name" SetFocusOnError="True" CssClass="Err" />



Date of Birth                   
         :
  (MM/dd/yyyy) 
ErrorMessage = "*You must be atleast 18years old to be employed! "

Operator = "LessThan"
Type= "Date" ControlToValidate="txt_dob" SetFocusOnError="True" CssClass="Err" />

Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="250px" NextPrevFormat="ShortMonth"
OnSelectionChanged="cal_dob_SelectionChanged" Width="330px" BorderStyle="Solid" CellSpacing="1">





Font-Size="12pt" ForeColor="White" BorderStyle="Solid" Height="12pt" />


 




Gender                 
                      
:   RepeatLayout="Flow" Width="150px" CausesValidation="True">
Male
Female

ErrorMessage= "*The Entry cannot be left blank"
ControlToValidate= "radio_gender" SetFocusOnError="True" CssClass="Err" />



Department                 
                :

RCB
IT
CES
FCC
RTF




Email address                    
          :

ErrorMessage= "*The Entry cannot be left blank"
ControlToValidate= "Txt_email_id" SetFocusOnError="True" CssClass="Err" />

ErrorMessage="*Email address is not valid."
ControlToValidate= "txt_email_id"
ValidationExpression= "[\w.]+@[\w.]+\.[\w.]+" CssClass="Err" />

 

Date of joining                   
         :
(MM/dd/yyyy) 
ErrorMessage = "*Date of joining cannot be before the Date of birth !"
ControlToCompare = "txt_dob"
Operator = "GreaterThan"
Type= "Date" ControlToValidate="txt_date_of_joining" SetFocusOnError="True" CssClass="Err" />


NextPrevFormat="ShortMonth"
Width="330px" OnSelectionChanged="cal_date_of_joining_SelectionChanged" BorderStyle="Solid" CellSpacing="1" >





Font-Size="12pt" ForeColor="White" BorderStyle="Solid" Height="12pt" />


 


Contact number            +91  :



ErrorMessage="*Entry should only be a 10 digit number"
ControlToValidate= "txt_contact_no"
ValidationExpression= "\d\d\d\d\d\d\d\d\d\d" CssClass="Err" />

 

Address                      
          :








Text="Delete" />