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
{

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();



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.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;

con.Open();
cmd.ExecuteNonQuery();
label_insert.Visible = true;
con.Close();
}

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;

con.Open();
cmd.ExecuteNonQuery();
label_update.Visible = true;
con.Close();
}
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;

con.Open();
cmd.ExecuteNonQuery();
label_delete.Visible = true;
con.Close();
}

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;
}


}