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); }