private Project SelectProject(int pId) { Project project = null; string sqlText = "SELECT * FROM Projects WHERE id = @id"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand select = new OpenCbsCommand(sqlText, conn)) { select.AddParam("@id", pId); using (OpenCbsReader reader = select.ExecuteReader()) { if (reader != null) { if (!reader.Empty) { reader.Read(); project = GetProject(reader); } else { return(project); } } } if (project.District != null) { project.District = _locations.SelectDistrictById(project.District.Id); } if (project.Id != 0) { project.FollowUps.AddRange(SelectFollowUps(project.Id)); } if (project.Id != 0) { project.AddCredits(_creditManager.SelectLoansByProject(project.Id)); } } return(project); }