public static List <Secretary> GetAllSecretaries() { List <Secretary> secretaries = new List <Secretary>(); string sqlExpression = "SELECT * FROM Secretary WHERE Deleted = 0"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Person person = null; Company company = null; int id = (int)reader["Id"]; if (reader["PersonId"] != null) { int personId = (int)reader["PersonId"]; person = SqlPerson.GetPerson(personId); } if (reader["CompanyId"] != null) { int companyId = (int)reader["CompanyId"]; company = new Company() { Id = companyId, InitState = InitializationState.INITIALIZATION_NEEDED }; } int markerId = (int)reader["MarkerId"]; int salary = (int)reader["Salary"]; Marker marker = SqlMarker.GetMarker(markerId); List <Document> pendingDocuments = SqlSecretaryPendingDocuments.GetPendingDocuments(id); List <Document> createdDocuments = SqlSecretaryCreatedDocuments.GetCurrentDocuments(id); Secretary secretary = new Secretary(person, company, salary) { EmployeeId = id, Marker = marker, PendingDocuments = pendingDocuments, CreatedDocuments = createdDocuments }; secretaries.Add(secretary); } } } return(secretaries); }
public static List <MainSecretary> GetAllMainSecretaries() { List <MainSecretary> mainSecretaries = new List <MainSecretary>(); string sqlExpression = "SELECT * FROM MainSecretary WHERE Deleted = 0"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Person person = null; Company company = null; int id = (int)reader["Id"]; int salary = (int)reader["Salary"]; if (reader["PersonId"] != DBNull.Value) { int personId = (int)reader["PersonId"]; person = SqlPerson.GetPerson(personId); } if (reader["CompanyId"] != DBNull.Value) { int companyId = (int)reader["CompanyId"]; company = new Company() { Id = companyId, InitState = InitializationState.INITIALIZATION_NEEDED }; } MainSecretary mainSecretary = new MainSecretary(person, company, salary) { EmployeeId = id }; mainSecretaries.Add(mainSecretary); } } } return(mainSecretaries); }
public static MainSecretary GetMainSecretary(int id) { MainSecretary mainSecretary = null; string sqlExpression = "SELECT * FROM MainSecretary WHERE Id = @id AND Deleted = 0"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); command.Parameters.Add("@id", SqlDbType.Int); command.Parameters["@id"].Value = id; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Person person = null; Company company = null; int salary = (int)reader["Salary"]; if (reader["PersonId"] != DBNull.Value) { int personId = (int)reader["PersonId"]; person = SqlPerson.GetPerson(personId); } if (reader["CompanyId"] != DBNull.Value) { int companyId = (int)reader["CompanyId"]; company = new Company() { Id = companyId, InitState = InitializationState.INITIALIZATION_NEEDED }; } mainSecretary = new MainSecretary(person, company, salary) { EmployeeId = id }; } } } return(mainSecretary); }
public static Director GetDirector(int id) { Director director = null; string sqlExpression = "SELECT * FROM Director WHERE Id = @id AND Deleted = 0"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); command.Parameters.Add("@id", SqlDbType.Int); command.Parameters["@id"].Value = id; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Person person = null; byte[] signature = (byte[])reader["DirectorSignature"]; int salary = (int)reader["Salary"]; if (reader["PersonId"] != DBNull.Value) { int personId = (int)reader["PersonId"]; person = SqlPerson.GetPerson(personId); } Company company = new Company { Id = SqlCompany_Director.GetCompanyByDirector(id), InitState = InitializationState.INITIALIZATION_NEEDED }; List <Document> pendingDocuments = SqlDirectorPendingDocuments.GetPendingDocuments(id); director = new Director(person, company, signature, salary) { EmployeeId = id, PendingDocuments = pendingDocuments }; } } } return(director); }