public EmpDto getEmployee(int id)
{
EmpDto employee = new EmpDto();
using (SqlConnection sqlConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand getEmp = new SqlCommand("Select Name from Employees where Id = " + id, sqlConnection))
{
sqlConnection.Open();
var reader = getEmp.ExecuteReader();
while (reader.Read())
{
employee.Id = reader.GetInt32(0);
employee.Name = reader.GetString(1);
employee.Department = reader.GetString(2);
}
}
}
return(employee);
}
public List <EmpDto> GetEmps()
{
List <EmpDto> emps = new List <EmpDto>();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
using (SqlCommand getAll = new SqlCommand("Select * From Employees", conn))
{
conn.Open();
var reader = getAll.ExecuteReader();
while (reader.Read())
{
EmpDto employee = new EmpDto();
employee.Id = reader.GetInt32(0);
employee.Name = reader.GetString(1);
employee.Department = reader.GetString(2);
emps.Add(employee);
}
}
}
return(emps);
}