using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace IUDSparameterized
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection cn = new SqlConnection(dbcon.dbconnectivity());
SqlCommand cmd;
SqlDataReader dr;
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtEmpName.Text == "" || txtEmpDegn.Text == "" || txtSalary.Text == "")
{
MessageBox.Show("All Fields Are Compulsory");
}
else
{
cmd = new SqlCommand("Insert INTO EmployeeDetails Values(@P2,@P3,@P4)", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@P2", txtEmpName.Text);
cmd.Parameters.AddWithValue("@P3", txtEmpDegn.Text);
cmd.Parameters.AddWithValue("@P4", txtSalary.Text);
cn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Data Inserted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
try
{
if (txtempid.Text == "")
{
MessageBox.Show("Enter Employee Id To Search");
}
else
{
cmd = new SqlCommand("Select * From EmployeeDetails where EmpId=@id", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", txtempid.Text);
cn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
txtEmpName.Text = dr[1].ToString();
txtEmpDegn.Text = dr[2].ToString();
txtSalary.Text = dr[3].ToString();
}
dr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
private void btnReset_Click(object sender, EventArgs e)
{
foreach (Control T in Controls)
{
if (T is TextBox)
{
T.Text = "";
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtempid.Text == "")
{
MessageBox.Show("Enter Employee Id To Update");
}
else
{
cmd = new SqlCommand("Update EmployeeDetails SET EmpName=@P2, EmpDesgn=@P3, EmpSalary=@P4 where EmpId=@P1", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@P1", txtempid.Text);
cmd.Parameters.AddWithValue("@P2", txtEmpName.Text);
cmd.Parameters.AddWithValue("@P3", txtEmpDegn.Text);
cmd.Parameters.AddWithValue("@P4", txtSalary.Text);
cn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Data Updated");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
private void btnDel_Click(object sender, EventArgs e)
{
try
{
if (txtempid.Text == "")
{
MessageBox.Show("Enter Employee Id To Delete");
}
else
{
cmd = new SqlCommand("Delete EmployeeDetails where EmpId=@EmpId", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EmpId", txtempid.Text);
cn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Data Deleted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
}
}