private void btn_Submit_Click(object sender, EventArgs e)
{
Global_Function_Varaible.Con_Open();
SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM tbl_Login_Emp WHERE Username = '******' AND Password = '******'", Global_Function_Varaible.con);
if (Convert.ToInt32(cmd.ExecuteScalar()) > 0)
{
MessageBox.Show("Login Successfull", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
Global_Function_Varaible.UName = tb_Username.Text;
MDI_Employee_Details MObj = new MDI_Employee_Details();
MObj.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid Username or Password", "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Global_Function_Varaible.Con_Close();
tb_Username.Text = "";
tb_Password.Text = "";
tb_Username.Focus();
}
private void btn_Save_Click(object sender, EventArgs e)
{
Global_Function_Varaible.Con_Open();
if (tb_ID.Text != "" && tb_Name.Text != "")
{
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO tbl_Add_Qualification VALUES(" + tb_ID.Text + ",'" + tb_Name.Text + "')", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
MessageBox.Show("Data Added Successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("1st Fill All The Fields", "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Global_Function_Varaible.Con_Close();
tb_ID.Text = Convert.ToString(Auto_Increment());
tb_Name.Text = "";
tb_Name.Focus();
}
private void frm_View_All_Employee_Load(object sender, EventArgs e)
{
Global_Function_Varaible.Con_Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tbl_Add_Emp", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
dgv_View_All_Emp.DataSource = dt;
Global_Function_Varaible.Con_Close();
}
private void cmb_Qualification_SelectedIndexChanged(object sender, EventArgs e)
{
Global_Function_Varaible.Con_Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tbl_Add_Emp WHERE Qualification = '" + cmb_Qualification.Text + "'", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
dgv_View_All_Emp.DataSource = dt;
Global_Function_Varaible.Con_Close();
}
int Auto_Increment()
{
int iCnt = 0;
Global_Function_Varaible.Con_Open();
SqlCommand cmd = new SqlCommand("SELECT COUNT(ID) FROM tbl_Add_Qualification", Global_Function_Varaible.con);
iCnt = Convert.ToInt32(cmd.ExecuteScalar());
iCnt = 101 + iCnt;
Global_Function_Varaible.Con_Close();
return(iCnt);
}
private void btn_Reset_Click(object sender, EventArgs e)
{
tb_ID.Text = "";
cmb_Qualification.SelectedIndex = -1;
Global_Function_Varaible.Con_Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tbl_Add_Emp", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
dgv_View_All_Emp.DataSource = dt;
Global_Function_Varaible.Con_Close();
}
private void Add_Employee_Detail_Load(object sender, EventArgs e)
{
tb_Employee_ID.Text = Convert.ToString(Auto_Increment());
Global_Function_Varaible.Con_Open();
SqlCommand cmd = new SqlCommand("SELECT Name FROM tbl_Add_Qualification", Global_Function_Varaible.con);
var obj = cmd.ExecuteReader();
while (obj.Read())
{
cmb_Qualification.Items.Add(obj.GetString(obj.GetOrdinal("Name")));
}
Global_Function_Varaible.Con_Close();
tb_Name.Focus();
}
private void frm_View_Emolyee_Detail_Dynamic_Load(object sender, EventArgs e)
{
Global_Function_Varaible.Con_Open();
SqlCommand cmd = new SqlCommand("SELECT DISTINCT(Name) FROM tbl_Add_Qualification", Global_Function_Varaible.con);
var obj = cmd.ExecuteReader();
while (obj.Read())
{
cmb_Qualification.Items.Add(obj.GetString(obj.GetOrdinal("Name")));
}
obj.Dispose();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tbl_Add_Emp", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
dgv_View_All_Emp.DataSource = dt;
Global_Function_Varaible.Con_Close();
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (tb_Name.Text != "" && tb_MobNo.Text != "" && cmb_Qualification.Text != "")
{
Global_Function_Varaible.Con_Open();
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO tbl_Add_Emp VALUES(" + tb_Employee_ID.Text + ",'" + tb_Name.Text + "'," + tb_MobNo.Text + ",'" + dtp_DOB.Text + "','" + cmb_Qualification.Text + "')", Global_Function_Varaible.con);
DataTable dt = new DataTable();
sda.Fill(dt);
MessageBox.Show("Record Filled Successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
Global_Function_Varaible.Con_Close();
}
else
{
MessageBox.Show("1st Fill All The Fields", "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Clear_Controls();
tb_Employee_ID.Text = Convert.ToString(Auto_Increment());
tb_Name.Focus();
}