public List <CoreModels> GetsCoreForUserID(IConnectToDB _Connect, List <CoreModels> Cores, int identity_id) { //Get Cores for user. CoreHelper CoreHelper = new CoreHelper(); DataTable CoreTable = CoreHelper.FindAll(_Connect); foreach (DataRow CoreRow in CoreTable.Rows) { //Instantiate New Models CoreModels CoreModel = new CoreModels(); CoreModel.Core = new CoreStruct(); CoreModel.Core.Core = new CoreTableModel(); CoreModel.Core.Core.core_name = CoreRow.Field <string>("core_name"); CoreModel.Core.Core.dt_created = CoreRow.Field <DateTime>("dt_created"); CoreModel.Core.Core.cores_id = CoreRow.Field <long?>("cores_id"); CoreModel.Core.Core.object_type = CoreRow.Field <string>("object_type"); CoreModel.Core.Core.dt_available = CoreRow.Field <DateTime?>("dt_available"); CoreModel.Core.Core.dt_end = CoreRow.Field <DateTime?>("dt_end"); CoreModel.Core.Core.enabled = CoreRow.Field <string>("enabled"); //Get Applications belonging to Each Core. CoreModel.applications = GetApplicationsForUserID(_Connect, CoreModel, new List <ApplicationModels>(), identity_id); Cores.Add(CoreModel); } return(Cores); }
public List <ApplicationModels> GetApplicationsForUserID(IConnectToDB _Connect, CoreModels CoreModel, List <ApplicationModels> Applications, int identity_id) { AppHelper applicationhelper = new AppHelper(); DataTable CoreApplications = applicationhelper.FindbyColumnID(_Connect, "Cores_ID", CoreModel.Core.Core.cores_id.ToString()); ApplicationModels applicationModel = new ApplicationModels(); foreach (DataRow AppRows in CoreApplications.Rows) { applicationModel = new ApplicationModels(); applicationModel.AppView = new ViewApplicationModel(); applicationModel.AppView.application_name = AppRows.Field <string>("application_name"); applicationModel.AppView.applications_id = AppRows.Field <long?>("applications_id"); applicationModel.AppView.cores_id = AppRows.Field <long?>("cores_id"); applicationModel.stages = GetStagesForAppandUserID(_Connect, new List <StageModels>(), applicationModel, identity_id); Applications.Add(applicationModel); } return(Applications); }