public string GetHubs(string value)
{
string hubs = string.Empty;
try
{
DbRequest request = new DbRequest();
request.isSelectQuery = true;
request.Query = "SELECT hub_code FROM OPN_HUBS";
DbResponse response = Database_Access.Execute_Db_Query(request);
if (null != response)
{
if (null != response.dataTable)
{
response.dataTable.Rows.Cast <DataRow>().ToList().ForEach(row =>
{
hubs = hubs + "," + Convert.ToString(row[0]);
});
}
}
}
catch (Exception ex)
{
hubs = "ERROR" + "," + ex.Message;
hubs = hubs + "," + ex.StackTrace;
}
return(hubs);
}
public ProjectRepository()
{
Database_Access DB = new Database_Access();
projects = DB.GetProjects();
}
public ProfileRepository()
{
Database_Access DB = new Database_Access();
profiles = DB.GetProfiles();
}
