public List <ClientAllData> AddAllClientInfo() { DBOperations operations = new DBOperations(); DBClientConfidentialFields clientConfidentialFields = new DBClientConfidentialFields(); DBEmployeeConfidentialFields employeeConfidentialFields = new DBEmployeeConfidentialFields(); var allInfo = from mainFields in operations.GetClientFields() join confFields in clientConfidentialFields.GetClientConfidentialFields() on mainFields.ID equals confFields.ID join myManager in operations.GetEmployeeFields() on mainFields.Manager equals myManager.ID join managerInfo in employeeConfidentialFields.GetEmployeeConfidentialFields() on myManager.ID equals managerInfo.ID select new { ClientID = mainFields.ID, ClientName = mainFields.Name, ClientSurname = mainFields.Surname, ClientBirthday = mainFields.Birthday, ClientPhone = mainFields.Phone, InfoID = confFields.ID, Balance = confFields.Balance, Credit = confFields.Credit, Deposit = confFields.Deposit, Password = confFields.Password, ManagerName = myManager.Name, ManagerSurname = myManager.Surname, ManagerPhone = myManager.Phone, }; List <ClientAllData> list = new List <ClientAllData>(); foreach (var item in allInfo) { list.Add(new ClientAllData(item.ClientID, item.ClientName, item.ClientSurname, item.ClientBirthday, item.ClientPhone, item.InfoID, item.Balance, item.Credit, item.Deposit, item.Password, item.ManagerName, item.ManagerSurname, item.ManagerPhone)); } return(list); }
public void ShowEmployeeInfo() { var managers = from manager in operations.GetEmployeeFields() join details in employeeConfidentialFields.GetEmployeeConfidentialFields() on manager.ID equals details.ID select new { ID = manager.ID, Name = manager.Name, Surname = manager.Surname, Salary = details.Salary, Position = details.Position }; foreach (var item in managers) { Console.WriteLine($"\n{item.ID}. {item.Name} {item.Surname}\nЗарплата - {item.Salary}, Должность - {item.Position}\n"); Console.WriteLine(new string('-', 50)); } }