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);
}
