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