public Employee FindEmployee(int EmployeeID)
{
Employee Employee;
string FN = "";
string SN = "";
string Ad = "";
string StringID = "";
int ID = 0;
string StringPC = "";
int PC;
string StringPhone = "";
int Phone;
double Salary;
string StringSalary = "";
DateTime Seniority;
string StringSeniority = "";
string Profesion = "";
bool SaleEmployee = false;
List<int> PhoneNumbers = new List<int>();
List<EmployeeAdress> Adresses = new List<EmployeeAdress>();
string FindEmployee = "select * from Employee where EmployeeID = " + EmployeeID;
conn.Open();
SqlCommand com = new SqlCommand(@FindEmployee, conn);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
FN = reader["FirstName"].ToString();
SN = reader["SurName"].ToString();
StringID = reader["EmployeeID"].ToString();
StringSalary = reader["Salary"].ToString();
StringSeniority = reader["Seniority"].ToString();
}
conn.Close();
string FindPhone = "select * from EmployeePhone where EmployeeID= " + EmployeeID;
conn.Open();
SqlCommand com2 = new SqlCommand(@FindPhone, conn);
SqlDataReader reader2 = com2.ExecuteReader();
while (reader2.Read())
{
StringPhone = reader2["Number"].ToString();
Int32.TryParse(StringPhone, out Phone);
PhoneNumbers.Add(Phone);
}
conn.Close();
string FindAdress = "select * from EmployeeAdress where EmployeeID= " + EmployeeID;
conn.Open();
SqlCommand com3 = new SqlCommand(@FindAdress, conn);
SqlDataReader reader3 = com3.ExecuteReader();
while (reader3.Read())
{
Ad = reader3["Adress"].ToString();
StringPC = reader3["PostalCode"].ToString();
Int32.TryParse(StringPC, out PC);
EmployeeAdress ea = new EmployeeAdress(Ad, PC);
Adresses.Add(ea);
}
conn.Close();
string FindCraftsman = "select * from CraftsmanEmployee where EmployeeID= " + EmployeeID;
conn.Open();
SqlCommand com4 = new SqlCommand(FindCraftsman, conn);
SqlDataReader reader4 = com4.ExecuteReader();
while (reader4.Read())
{
Profesion = reader4["Profesion"].ToString();
}
conn.Close();
string FindSalesman = "select * from SalesEmployee where EmployeeID= " + EmployeeID;
conn.Open();
SqlCommand com5 = new SqlCommand(@FindSalesman, conn);
SqlDataReader reader5 = com5.ExecuteReader();
while (reader5.Read())
{
SaleEmployee = true;
}
conn.Close();
DateTime.TryParse(StringSeniority, out Seniority);
double.TryParse(StringSalary, out Salary);
Int32.TryParse(StringID, out ID);
Employee = new Employee(ID, FN, SN, Seniority, Salary, PhoneNumbers, Adresses, SaleEmployee, Profesion);
return Employee;
}
public void AddAdress(string NewAdress, int NewPostalCode)
{
EmployeeAdress Adress = new EmployeeAdress(NewAdress, NewPostalCode);
Adresses.Add(Adress);
DBC.EDB.CreateEmployeeAdress(EmployeeId, NewAdress, NewPostalCode);
}
