private static void PrintEmployee(int EmployeeID)
{
AccademyADODB db = new AccademyADODB();
AccademyEmployee emp = db.GetEmployeeByID(EmployeeID);
System.Console.WriteLine(emp);
}
public AccademyEmployee GetEmployeeByID(int EmployeeID)
{
AccademyEmployee result = new AccademyEmployee();
using (conn = new SqlConnection(connString))
{
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM Employees where EmployeeID = " + EmployeeID;
cmd.CommandType = System.Data.CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
AccademyEmployee temp = new AccademyEmployee()
{
IDAccademyEmployee = (int)dr["EmployeeID"],
Nome = dr["FirstName"] as String,
Cognome = dr["LastName"] as String,
Citta = dr["City"] as String,
};
result = temp;
}
conn.Close();
}
return(result);
}
public AccademyEmployee GetEmployeeByID(int EmployeeID)
{
AccademyEmployee result = new AccademyEmployee();
var entity = ctx.Employees
.Where(e => e.EmployeeID == EmployeeID)
.FirstOrDefault();
result = emp_factory.CreateDto(entity);
return(result);
}
public AccademyEmployee CreateDto(Employee entity)
{
AccademyEmployee dto = new AccademyEmployee()
{
IDAccademyEmployee = entity.EmployeeID,
Nome = entity.FirstName,
Cognome = entity.LastName,
Citta = entity.City
};
return(dto);
}
public List <AccademyEmployee> GetAllEmployees()
{
List <AccademyEmployee> resultList = new List <AccademyEmployee>();
using (conn = new SqlConnection(connString))
{
try
{
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM Employees";
cmd.CommandType = System.Data.CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
AccademyEmployee temp = new AccademyEmployee()
{
IDAccademyEmployee = (int)dr["EmployeeID"],
Nome = dr["FirstName"] as String,
Cognome = dr["LastName"] as String,
Citta = dr["City"] as String,
};
resultList.Add(temp);
}
}
catch (Exception excp)
{
var x = excp;
}
finally
{
conn.Close();
}
} // conn.Dispose();
return(resultList);
}
public Employee CreateEntity(AccademyEmployee dto)
{
throw new NotImplementedException();
}
