Sradha WebCreations | mobile app designing Company In Cuttack,Bhubaneswar odisha: Employee management system asp & sql server

how to create registration wizard in any website

Design Common Application Form (CAF) for any website

(ASP.NET + SQL SERVER)

EMPLOYEE INFORMATION WIZARD Or CAF

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<div>

<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="3" Height="443px"

Width="881px">

<asp:WizardStep ID="EmployeeInformation" runat="server" title="Step 1">

<tr>

<strong>              Employee Information</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Name</td>

<td>

<asp:TextBox ID="TextBoxNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Designation</td>

<td>

<asp:TextBox ID="TextBoxDESIGNATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Remunaretion</td>

<td>

<asp:TextBox ID="TextBoxREMUNARETION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Qualification</td> <asp:TextBox ID="TextBoxQUALIFICATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Reg by</td>

<td>

<asp:TextBox ID="TextBoxREG_BY" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Date Of Birth</td>

<td>

<asp:TextBox ID="TextBoxDOB" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Joining Date</td> <asp:TextBox ID="TextBoxJOINDATE" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Now Posting</td>

<td>

<asp:TextBox ID="TextBoxNOWPOSTING" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="LeaveStatus" runat="server" title="Step 2">

<tr>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Department</td>

<td>

<asp:DropDownList ID="DropDownListDEPARTMENT" runat="server" Width="124px">

<asp:ListItem>Select 1</asp:ListItem>

<asp:ListItem>Sales</asp:ListItem>

<asp:ListItem>Production</asp:ListItem>

<asp:ListItem>Administrative</asp:ListItem>

<asp:ListItem>Transport</asp:ListItem>

<asp:ListItem>Purchase</asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

Employee Name</td>

<td>

<asp:TextBox ID="TextBoxEMPNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Area Of Posting</td>

<td>

asp:TextBox ID="TextBoxAREAOFPOSTING" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="PostingDetails" runat="server" Title="Step 3">

<tr>

<strong>               Posting  Details</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Employee Name</td>

<td>

<asp:TextBox ID="TextBoxEMPLOYEENAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Designation</td>

<td>

<asp:TextBox ID="TextBoxEMPDESIGNATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Date Of Join</td>

<td>

<asp:TextBox ID="TextBoxDOBJOIN" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<strong>Conformation</strong></td>

<td>

<asp:TextBox ID="TextBoxCONFORMATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

(Tranfer)</td>

<td>

 </td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="CurrentSalary" runat="server" Title="Step 4">

<tr>

<strong>                  Current Salary</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Emp Name</td>

<asp:TextBox ID="TextBoxEMPLOYEEFULLNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Remunaretion</td>

<td>

<asp:TextBox ID="TextBoxEMPREMUNARETION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Basic</td>

<td>

<asp:TextBox ID="TextBoxBASIC" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

PF</td>

<td>

<asp:TextBox ID="TextBoxPF" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

ESI</td>

<td>

<asp:TextBox ID="TextBoxESI" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

TDS</td>

<td>

<asp:TextBox ID="TextBoxTDS" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Year Leave No.</td>

<td>

<asp:TextBox ID="TextBoxYEARLEAVE" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

</WizardSteps>

</asp:Wizard>

</div>

</form>

</body>

</html>

Create Database store data in SQl Server

Code View

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Web.Security;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class Wizard_employee : System.Web.UI.Page

{

protected void ButtonSAVE_Click(object sender, EventArgs e)

{

string sName = TextBoxNAME.Text;

string sDesignation = TextBoxDESIGNATION.Text;

string sRemunaretion = TextBoxREMUNARETION.Text;

string sQualification = TextBoxQUALIFICATION.Text;

string sRegBy = TextBoxREG_BY.Text;

string sDob = TextBoxDOB.Text;

string sJoinDate = TextBoxJOINDATE.Text;

string sNowPosting = TextBoxNOWPOSTING.Text;

string sDepartment = DropDownListDEPARTMENT.Text;

string sEmpName = TextBoxEMPNAME.Text;

string sAreaOfPosting = TextBoxAREAOFPOSTING.Text;

string sEmployeeName = TextBoxEMPLOYEENAME.Text;

string sEmpDesignation = TextBoxEMPDESIGNATION.Text;

string sDOJoin = TextBoxDOBJOIN.Text;

string sConformation = TextBoxCONFORMATION.Text;

string sEmpNamee = TextBoxEMPLOYEEFULLNAME.Text;

string sEremunaretion = TextBoxEMPREMUNARETION.Text;

string sEbasic = TextBoxBASIC.Text;

string sEpf = TextBoxPF.Text;

string sEESI = TextBoxESI.Text;

string sETDS = TextBoxTDS.Text;

string sYearOfLeave = TextBoxYEARLEAVE.Text;

string connectionString = ConfigurationManager.ConnectionStrings["DataBaseConnection"].ConnectionString;

string insertSql = "INSERT INTO EMPLOYEE_INFORMATIOIN(NAME,DESIGNATION,remunaretion,qualification,reg_by,dob,joindate,nowposting,department,employeeName,areaOfPosting,EmpName,Edesignation,dojoin,conformation,Empnamee,ERemunaretion,Ebasic,Epf,EESI,ETDS,YearOfLeave) VALUES(@NAME,@DESIGNATION,@remunaretion,@qualification,@reg_by,@dob,@joindate,@nowposting,@department,@employeeName,@areaOfPosting,@EmpName,@Edesignation,@dojoin,@conformation,@Empnamee,@ERemunaretion,@Ebasic,@Epf,@EESI,@ETDS,@YearOfLeave)";

using (SqlConnection myConnection = new SqlConnection(connectionString))

{

myConnection.Open();

SqlCommand myCommand = new SqlCommand(insertSql, myConnection);

myCommand.Parameters.AddWithValue("@NAME", TextBoxNAME.Text);

myCommand.Parameters.AddWithValue("@Designation",TextBoxDESIGNATION.Text);

myCommand.Parameters.AddWithValue("@REMUNARETION",TextBoxREMUNARETION.Text);

myCommand.Parameters.AddWithValue("@Qualification",TextBoxQUALIFICATION.Text);

myCommand.Parameters.AddWithValue("@REG_BY",TextBoxREG_BY.Text);

myCommand.Parameters.AddWithValue("@dob",TextBoxDOB.Text);

myCommand.Parameters.AddWithValue("@joindate",TextBoxJOINDATE.Text);

myCommand.Parameters.AddWithValue("@nowposting",TextBoxNOWPOSTING.Text);

myCommand.Parameters.AddWithValue("@department",DropDownListDEPARTMENT.SelectedValue);

myCommand.Parameters.AddWithValue("@employeeName",TextBoxEMPNAME.Text);

myCommand.Parameters.AddWithValue("@areaOfPosting",TextBoxAREAOFPOSTING.Text);

myCommand.Parameters.AddWithValue("@EmpName",TextBoxEMPLOYEENAME.Text);

myCommand.Parameters.AddWithValue("@Edesignation",TextBoxEMPDESIGNATION.Text);

myCommand.Parameters.AddWithValue("@dojoin",TextBoxDOBJOIN.Text);

myCommand.Parameters.AddWithValue("@conformation",TextBoxCONFORMATION.Text);

myCommand.Parameters.AddWithValue("@empNamee",TextBoxEMPLOYEEFULLNAME.Text);

myCommand.Parameters.AddWithValue("@ERemunaretion",TextBoxEMPREMUNARETION.Text);

myCommand.Parameters.AddWithValue("@Ebasic",TextBoxBASIC.Text);

myCommand.Parameters.AddWithValue("@Epf",TextBoxPF.Text);

myCommand.Parameters.AddWithValue("@EESI",TextBoxESI.Text);

myCommand.Parameters.AddWithValue("@ETDS",TextBoxTDS.Text);

myCommand.Parameters.AddWithValue("@YearOfLeave",TextBoxYEARLEAVE.Text);

myCommand.ExecuteNonQuery();

myConnection.Close();

}

// "Reset" the Subject and Body TextBoxes

TextBoxNAME.Text= string.Empty;

TextBoxDESIGNATION.Text= string.Empty;

TextBoxREMUNARETION.Text= string.Empty;

TextBoxQUALIFICATION.Text= string.Empty;

TextBoxREG_BY.Text= string.Empty;

TextBoxDOB.Text= string.Empty;

TextBoxJOINDATE.Text= string.Empty;

TextBoxNOWPOSTING.Text= string.Empty;

// DropDownListDEPARTMENT.Text= string.Empty;

TextBoxEMPNAME.Text= string.Empty;

TextBoxAREAOFPOSTING.Text= string.Empty;

TextBoxEMPLOYEENAME.Text= string.Empty;

TextBoxEMPDESIGNATION.Text= string.Empty;

TextBoxDOBJOIN.Text= string.Empty;

TextBoxCONFORMATION.Text= string.Empty;

TextBoxEMPLOYEEFULLNAME.Text= string.Empty;

TextBoxEMPREMUNARETION.Text= string.Empty;

TextBoxBASIC.Text= string.Empty;

TextBoxPF.Text= string.Empty;

TextBoxESI.Text= string.Empty;

TextBoxTDS.Text= string.Empty;

TextBoxYEARLEAVE.Text= string.Empty;

}

#SradhaWebCreations Contact : +91-9040573923, +91-7008182025 http://sradhawebcreations.com/ http://sradhawebcreations.blogspot.in/ https://facebook.com/sradhawebcreations https://www.facebook.com/Sradhawebeducation/

Pages

Friday, August 10, 2018

how to create registration wizard in any website | CAF | Sradha Webcreations