private void DbFillEmployees(SqlConnector connector, ADepartament departament, int index) { var sqlQuery = $@"SELECT * FROM Employees WHERE DepartamentId = {index}"; using (var reader = connector.GetData(sqlQuery)) { while (reader.Read()) { var currentEmployee = ConvertSqlData.ToEmployee(reader, departament); if (currentEmployee != null) { departament.AddEmployee(currentEmployee); } } } }
/// <summary> /// Конвертирует данные Сотрудника /// </summary> /// <param name="reader"></param> /// <param name="departament"></param> /// <returns></returns> public static Employee ToEmployee(SqlDataReader reader, ADepartament departament) { try { var id = (int)reader[0]; var fName = (string)reader[1]; var lName = (string)reader[2]; var phone = (long)reader[3]; return(new Employee(departament, fName, lName, phone, id)); } catch (Exception e) { MessageBox.Show(e.Message); } return(null); }
public static Employee GetLastEmployee(SqlConnectionStringBuilder stringBuilder, ADepartament departament) { var sqlQuery = @"SELECT TOP 1 * FROM Employees ORDER BY ID DESC"; Employee lastEmployee = null; using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { lastEmployee = ConvertSqlData.ToEmployee(reader, departament); } } return(lastEmployee); }
public static Employee GetEmployeeById(SqlConnectionStringBuilder stringBuilder, int id, ADepartament departament) { var sqlQuery = $@"SELECT * FROM Employees WHERE Id = {id}"; Employee lastEmployee = null; using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { lastEmployee = ConvertSqlData.ToEmployee(reader, departament); } } return(lastEmployee); }