public List <CompanyStructureNode> GetNodesByType(TypeOfNode typeOfNode) { List <CompanyStructureNode> nodes = new List <CompanyStructureNode>(); using (SqlConnection connection = new SqlConnection(Constants.CONNECTION_STRING)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.CommandText = "Select * from CompanyStructureNode where TypeOfNode = @typeOfNode"; command.Parameters.Add("@typeOfNode", SqlDbType.Int).Value = typeOfNode; command.Connection = connection; using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { CompanyStructureNode node = new CompanyStructureNode(); node.NodeId = reader.GetInt32(0); node.CodeOfNode = reader.GetString(1); node.NameOfNode = reader.GetString(2); node.TypeOfNode = (TypeOfNode)reader.GetInt32(3); node.HeadOfNodeId = reader.IsDBNull(5) ? 0 : reader.GetInt32(5); nodes.Add(node); } } } } return(nodes); }
public CompanyStructureNode GetNodeById(int nodeId) { CompanyStructureNode node = new CompanyStructureNode(); using (SqlConnection connection = new SqlConnection(Constants.CONNECTION_STRING)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.CommandText = "Select * from CompanyStructureNode where NodeId = @nodeId"; command.Parameters.Add("@nodeId", SqlDbType.Int).Value = nodeId; command.Connection = connection; using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { node.NodeId = reader.GetInt32(0); node.CodeOfNode = reader.GetString(1); node.NameOfNode = reader.GetString(2); node.TypeOfNode = (TypeOfNode)reader.GetInt32(3); } } } } return(node); }
public CompanyStructureNode CreateFirm(string codeOfNode, string nameOfNode, TypeOfNode typeOfNode) { CompanyStructureNode firm = new CompanyStructureNode(); firm.CodeOfNode = codeOfNode; firm.NameOfNode = nameOfNode; firm.TypeOfNode = typeOfNode; return(firm); }
public CompanyStructureNode CreateNode(string codeOfNode, string nameOfNode, TypeOfNode typeOfNode, int parentNode) { CompanyStructureNode node = new CompanyStructureNode(); node.CodeOfNode = codeOfNode; node.NameOfNode = nameOfNode; node.TypeOfNode = typeOfNode; node.NodeAboveId = parentNode; return(node); }
public void AddNode(TypeOfNode typeOfNode, int parentId) { CompanyStructureNode node = new CompanyStructureNode(); if (HeadOfNodeId == 0) { node = _nodeFactory.CreateNode(CodeOfNode, NameOfNode, typeOfNode, parentId); RepositoryManager.CompanyStructureNodeRepository.AddNode(node); } else { node = _nodeFactory.CreateNode(CodeOfNode, NameOfNode, typeOfNode, parentId, HeadOfNodeId); RepositoryManager.CompanyStructureNodeRepository.AddNodeWithHead(node); } }
public void AddFirm(CompanyStructureNode node) { using (SqlConnection connection = new SqlConnection(Constants.CONNECTION_STRING)) { connection.Open(); using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"insert into CompanyStructureNode (CodeOfNode, NameOfNode, TypeOfNode) values(@codeOfNode, @nameOfNode, @typeOfNode)"; command.Parameters.Add("@codeOfNode", SqlDbType.NVarChar).Value = node.CodeOfNode; command.Parameters.Add("@nameOfNode", SqlDbType.NVarChar).Value = node.NameOfNode; command.Parameters.Add("@typeOfNode", SqlDbType.Int).Value = node.TypeOfNode; command.ExecuteNonQuery(); } } }