public int Update(Employee objEmp)
{
using (SqlConnection sqlConn = DBEmployee.GetConnection())
{
SqlCommand cmd = new SqlCommand("UPDATE Employee SET Name = @Name, EmpAddress = @EmpAddress, Dob = @Dob, Salary = @Salary WHERE EmpID = @EmpId", sqlConn);
//SqlParameter[] param =
//{
// new SqlParameter("@EmpId", objEmp.EmpId),
// new SqlParameter("@Name", objEmp.Name),
// new SqlParameter("@Empaddress", objEmp.EmpAddress),
// new SqlParameter("@Dob", objEmp.Dob),
// new SqlParameter("@Salary", objEmp.Salary)
//};
//cmd.Parameters.AddRange(param);
cmd.Parameters.Add(new SqlParameter("@EmpId", objEmp.EmpId));
cmd.Parameters.Add(new SqlParameter("@Name", objEmp.Name));
cmd.Parameters.Add(new SqlParameter("@Empaddress", objEmp.EmpAddress));
cmd.Parameters.Add(new SqlParameter("@Dob", objEmp.Dob));
cmd.Parameters.Add(new SqlParameter("@Salary", objEmp.Salary));
sqlConn.Open();
return(cmd.ExecuteNonQuery());
}
}
public int Delete(int empId)
{
using (SqlConnection sqlConn = DBEmployee.GetConnection())
{
SqlCommand cmd = new SqlCommand("DELETE Employee WHERE EmpID = @EmpId", sqlConn);
cmd.Parameters.Add(new SqlParameter("@EmpId", empId));
sqlConn.Open();
return(cmd.ExecuteNonQuery());
}
}
public DataTable GetAllEmployee()
{
using (SqlConnection sqlConn = DBEmployee.GetConnection())
{
SqlCommand cmd = new SqlCommand("SELECT EmpID, Name, EmpAddress, Dob, Salary FROM Employee", sqlConn);
sqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
}
public DataTable GetEmployee(int empId)
{
using (SqlConnection sqlConn = DBEmployee.GetConnection())
{
SqlCommand cmd = new SqlCommand("SELECT EmpID, Name, EmpAddress, Dob, Salary FROM Employee WHERE EmpID = @EmpId", sqlConn);
cmd.Parameters.Add(new SqlParameter("@EmpId", empId));
sqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
}
public int Insert(Employee objEmp)
{
using (SqlConnection sqlConn = DBEmployee.GetConnection())
{
SqlCommand cmd = new SqlCommand("INSERT Employee(Name,EmpAddress,Dob,Salary) VALUES (@Name,@EmpAddress,@Dob,@Salary)", sqlConn);
SqlParameter[] param =
{
new SqlParameter("@Name", objEmp.Name),
new SqlParameter("@Empaddress", objEmp.EmpAddress),
new SqlParameter("@Dob", objEmp.Dob),
new SqlParameter("@Salary", objEmp.Salary)
};
cmd.Parameters.AddRange(param);
sqlConn.Open();
return(cmd.ExecuteNonQuery());
}
}
