} // public static int GetAllTotal(Guid parentUid) { Entity parent = EntityManager.GetEntity(parentUid); if (parent == null || parent.Id == 0) { return(0); } //bool includingItems = true; try { using (var context = new EntityContext()) { context.Configuration.LazyLoadingEnabled = false; List <DBEntity> results = context.Entity_VerificationProfile .Where(s => s.EntityId == parent.Id) .OrderBy(s => s.Id) .ToList(); if (results != null && results.Any()) { return(results.Count); } } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".GetAll"); } return(0); } //
public static Entity GetEntity(int entityTypeId, int entityBaseId) { Entity entity = new Entity(); using (var context = new EntityContext()) { DBentity item = context.Entity .FirstOrDefault(s => s.EntityTypeId == entityTypeId && s.EntityBaseId == entityBaseId); if (item != null && item.Id > 0) { entity.Id = item.Id; entity.EntityTypeId = item.EntityTypeId; //not why this was commented. Reusing with care if (item.Codes_EntityTypes != null) { entity.EntityType = item.Codes_EntityTypes.Title; } else { entity.EntityType = GetEntityType(entity.EntityTypeId); } entity.EntityUid = item.EntityUid; entity.EntityBaseId = item.EntityBaseId ?? 0; entity.EntityBaseName = item.EntityBaseName; entity.Created = ( DateTime )item.Created; } return(entity); } }
public bool DeleteAll(Entity parent, ref SaveStatus status) { bool isValid = true; //Entity parent = EntityManager.GetEntity( parentUid ); if (parent == null || parent.Id == 0) { status.AddError(thisClassName + ". Error - the provided target parent entity was not provided."); return(false); } using (var context = new EntityContext()) { context.Entity_IdentifierValue.RemoveRange(context.Entity_IdentifierValue.Where(s => s.EntityId == parent.Id)); int count = context.SaveChanges(); if (count > 0) { isValid = true; } else { //if doing a delete on spec, may not have been any properties } } return(isValid); }
} // /// <summary> /// Get a competency record /// </summary> /// <param name="profileId"></param> /// <returns></returns> public static ThisEntity Get(int profileId) { ThisEntity entity = new ThisEntity(); if (profileId == 0) { return(entity); } try { using (var context = new EntityContext()) { DBEntity item = context.Reference_Frameworks .SingleOrDefault(s => s.Id == profileId); if (item != null && item.Id > 0) { MapFromDB(item, entity); } } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".Get"); } return(entity); } //
/// <summary> /// Delete all profiles for parent /// </summary> /// <param name="dataSetProfileId"></param> /// <param name="status"></param> /// <returns></returns> public bool DeleteAll(int dataSetProfileId, ref List <string> messages) { bool isValid = true; int count = 0; if (dataSetProfileId < 1) { messages.Add(thisClassName + "DeleteAll. Error - the dataSetProfileId was not provided."); return(false); } using (var context = new EntityContext()) { var results = context.DataSetTimeFrame .Where(s => s.DataSetProfileId == dataSetProfileId) .ToList(); if (results == null || results.Count == 0) { return(true); } foreach (var item in results) { //need to remove DataProfile new DataProfileManager().DeleteAll(item.Id, ref messages); context.DataSetTimeFrame.Remove(item); count = context.SaveChanges(); if (count > 0) { } } } return(isValid); }
public bool UpdateModifiedDate(Guid entityUid, ref SaveStatus status) { bool isValid = false; if (!IsValidGuid(entityUid)) { status.AddError(thisClassName + ".UpdateModifiedDate(). Error - missing a valid identifier for the Entity"); return(false); } using (var context = new EntityContext()) { DBentity efEntity = context.Entity .FirstOrDefault(s => s.EntityUid == entityUid); if (efEntity != null && efEntity.Id > 0) { efEntity.LastUpdated = DateTime.Now; int count = context.SaveChanges(); if (count >= 0) { isValid = true; LoggingHelper.DoTrace(7, thisClassName + string.Format(".UpdateModifiedDate - update last updated for TypeId: {0}, BaseId: {1}", efEntity.EntityTypeId, efEntity.EntityBaseId)); } } else { status.AddError(thisClassName + ".UpdateModifiedDate(). Error - Entity was not found."); LoggingHelper.LogError(thisClassName + string.Format(".UpdateModifiedDate - record was not found. entityUid: {0}", entityUid), true); } } return(isValid); }///
} // public bool SetImport_PendingRequestHandled(int recordId, bool importWasSuccessful) { bool isValid = false; if (recordId <= 0) { return(false); } using (var context = new EntityContext()) { var efEntity = context.Import_PendingRequest .FirstOrDefault(s => s.Id == recordId); if (efEntity != null && efEntity.Id > 0) { efEntity.WasProcessed = true; efEntity.ImportWasSuccessful = importWasSuccessful; if (importWasSuccessful) { efEntity.ImportedDate = DateTime.Now; } int count = context.SaveChanges(); if (count >= 0) { isValid = true; } } else { LoggingHelper.LogError(thisClassName + string.Format(".SetImport_PendingRequestHandled - record was not found. recordId: {0}", recordId), true); } } return(isValid); } ///
public static List <ThisEntity> GetAllPendingReindex(ref List <String> messages, int entityTypeId = 0) { List <ThisEntity> list = new List <ThisEntity>(); ThisEntity entity = new ThisEntity(); using (var context = new EntityContext()) { List <DBEntity> results = context.SearchPendingReindex .Where(s => s.IsUpdateOrDeleteTypeId == 1 && s.StatusId == 1 && (entityTypeId == 0 || s.EntityTypeId == entityTypeId) ) .OrderBy(s => s.EntityTypeId).ThenBy(s => s.Created) .ToList(); if (results != null && results.Count > 0) { foreach (var item in results) { entity = new ThisEntity(); MapFromDB(item, entity, true); list.Add(entity); } } } return(list); }
/// <summary> /// Delete a JurisdictionProfile /// </summary> /// <param name="Id"></param> /// <param name="statusMessage"></param> /// <returns></returns> public bool Delete(int Id, ref string statusMessage) { bool isValid = false; using (var context = new EntityContext()) { if (Id == 0) { statusMessage = "Error - missing an identifier for the JurisdictionProfile"; return(false); } DBEntity efEntity = context.Entity_JurisdictionProfile.SingleOrDefault(s => s.Id == Id); if (efEntity != null && efEntity.Id > 0) { context.Entity_JurisdictionProfile.Remove(efEntity); int count = context.SaveChanges(); if (count > 0) { isValid = true; } } else { statusMessage = string.Format("JurisdictionProfile record was not found: {0}", Id); isValid = false; } } return(isValid); }
} // public static List <ThisEntity> GetAllForList(Guid parentUid) { ThisEntity row = new ThisEntity(); DurationItem duration = new DurationItem(); List <ThisEntity> profiles = new List <ThisEntity>(); Entity parent = EntityManager.GetEntity(parentUid); using (var context = new EntityContext()) { List <DBEntity> results = context.Entity_CostProfile .Where(s => s.EntityId == parent.Id) .OrderBy(s => s.Id) .ToList(); if (results != null && results.Count > 0) { foreach (DBEntity item in results) { row = new ThisEntity(); MapFromDB(item, row, false); profiles.Add(row); } } return(profiles); } } //
public static bool IsParentBeingAddedAsChildToItself(int profileId, int childId, int childEntityTypeId) { bool isOk = false; using (var context = new EntityContext()) { //get the profile that is the parent of the child DBEntity efEntity = context.Entity_ProcessProfile .SingleOrDefault(s => s.Id == profileId); if (efEntity != null && efEntity.Id > 0 && efEntity.Entity != null) { //check if the parent entity is the same one being added as a child if (efEntity.Entity.EntityTypeId == childEntityTypeId && efEntity.Entity.EntityBaseId == childId) { return(true); } } } return(isOk); }
} // /// <summary> /// Get a single DurationProfile by integer Id /// </summary> /// <param name="id"></param> /// <returns></returns> /// public static WM.DurationItem GetRenewalDuration(Guid parentUid) { WM.DurationItem duration = new WM.DurationItem(); ThisEntity profile = new ThisEntity(); Entity parent = EntityManager.GetEntity(parentUid); if (parent == null || parent.Id == 0) { return(duration); } using (var context = new EntityContext()) { List <EM.Entity_DurationProfile> results = context.Entity_DurationProfile .Where(s => s.EntityId == parent.Id && (s.TypeId == 3)) .ToList(); if (results != null && results.Count > 0) { foreach (EM.Entity_DurationProfile item in results) { MapFromDB(item, duration); break; } } return(duration); } }
/// <summary> /// Retrieve and fill duration profiles for parent entity /// </summary> /// <param name="parentUid"></param> public static List <ThisEntity> GetAll(Guid parentUid, int typeId = 0) { ThisEntity row = new ThisEntity(); WM.DurationItem duration = new WM.DurationItem(); List <ThisEntity> profiles = new List <ThisEntity>(); Entity parent = EntityManager.GetEntity(parentUid); if (parent == null || parent.Id == 0) { return(profiles); } using (var context = new EntityContext()) { List <EM.Entity_DurationProfile> results = context.Entity_DurationProfile .Where(s => s.EntityId == parent.Id && ((typeId == 0 && s.TypeId < 3) || s.TypeId == typeId)) .OrderBy(s => s.Id) .ToList(); if (results != null && results.Count > 0) { foreach (EM.Entity_DurationProfile item in results) { row = new ThisEntity(); MapFromDB(item, row); profiles.Add(row); } } return(profiles); } } //
public void AssignDurationSummary( ) { ThisEntity row = new ThisEntity(); using (var context = new EntityContext()) { List <EM.Entity_DurationProfile> results = context.Entity_DurationProfile .OrderBy(s => s.Id) .ToList(); if (results != null && results.Count > 0) { foreach (EM.Entity_DurationProfile item in results) { row = new ThisEntity(); MapFromDB(item, row); if (row.ExactDuration.HasValue || row.IsRange) { item.DurationSummary = row.DurationSummary; if (HasStateChanged(context)) { //note: testing - the latter may be true if the child has changed - but shouldn't as the mapping only updates the parent //item.LastUpdated = System.DateTime.Now; context.SaveChanges(); } } } } } }
public static ThisEntity Get(int id, bool forEditView = false) { ThisEntity entity = new ThisEntity(); bool includingProfiles = false; if (forEditView) { includingProfiles = true; } using (var context = new EntityContext()) { DBEntity item = context.ConditionManifest .SingleOrDefault(s => s.Id == id); if (item != null && item.Id > 0) { MapFromDB(item, entity, true, //includingProperties includingProfiles, forEditView); } } return(entity); }
/// <summary> /// get all related JurisdictionProfiles for the parent /// </summary> /// <param name="parentUId"></param> /// <returns></returns> public static List <ThisEntity> Jurisdiction_GetAll(Guid parentUid, int jprofilePurposeId = 1) { //efEntity.JProfilePurposeId ThisEntity entity = new ThisEntity(); List <ThisEntity> list = new List <ThisEntity>(); int count = 0; MC.Entity parent = EntityManager.GetEntity(parentUid); if (parent == null || parent.Id == 0) { return(list); } using (var context = new EntityContext()) { List <DBEntity> Items = context.Entity_JurisdictionProfile .Where(s => s.EntityId == parent.Id && s.JProfilePurposeId == jprofilePurposeId) .OrderBy(s => s.Id).ToList(); if (Items.Count > 0) { foreach (DBEntity item in Items) { entity = new ThisEntity(); count++; //map and get regions MapFromDB(item, entity, count); list.Add(entity); } } } return(list); }
public static List <CostManifest> GetAllManifestInCommonCostsFor(int CostManifestId, int CostManifestBeingCheckedId) { List <CostManifest> list = new List <CostManifest>(); try { using (var context = new EntityContext()) { List <DBEntity> results = context.Entity_CommonCost .Where(s => s.CostManifestId == CostManifestId) .OrderBy(s => s.EntityId) .ToList(); if (results != null && results.Count > 0) { foreach (DBEntity item in results) { if (item.Entity.EntityBaseId == CostManifestBeingCheckedId) { } } } return(list); } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".GetAllManifestInCommonCostsFor"); } return(list); }
// /// <summary> /// get all related GeoCoordinates for the parent /// </summary> /// <param name="parentId"></param> /// <returns></returns> public static List <MC.GeoCoordinates> GetAll(int parentId, bool isException = false) { MC.GeoCoordinates entity = new MC.GeoCoordinates(); List <MC.GeoCoordinates> list = new List <MC.GeoCoordinates>(); if (parentId == 0) { return(list); } using (var context = new EntityContext()) { List <EM.GeoCoordinate> Items = context.GeoCoordinate .Where(s => s.JurisdictionId == parentId && s.IsException == isException) .OrderBy(s => s.Id).ToList(); if (Items.Count > 0) { foreach (EM.GeoCoordinate item in Items) { entity = new MC.GeoCoordinates(); MapFromDB(item, entity); list.Add(entity); } } } return(list); }
public static Entity GetEntity(Guid entityUid, bool includingAllChildren = true) { Entity entity = new Entity(); using (var context = new EntityContext()) { if (includingAllChildren == false) { context.Configuration.LazyLoadingEnabled = false; } DBentity item = context.Entity .FirstOrDefault(s => s.EntityUid == entityUid); if (item != null && item.Id > 0) { entity.Id = item.Id; entity.EntityTypeId = item.EntityTypeId; //entity.EntityType = item.Codes_EntityType.Title; entity.EntityUid = item.EntityUid; entity.EntityBaseId = item.EntityBaseId ?? 0; entity.EntityBaseName = item.EntityBaseName; entity.Created = (DateTime)item.Created; entity.LastUpdated = item.LastUpdated != null ?( DateTime )item.LastUpdated : entity.Created; } return(entity); } }
public static ThisEntity Get(int id, bool forEditView = false) { ThisEntity entity = new ThisEntity(); bool includingProfiles = false; if (forEditView) { includingProfiles = true; } using (var context = new EntityContext()) { DBEntity item = context.Entity_FinancialAlignmentProfile .SingleOrDefault(s => s.Id == id); if (item != null && item.Id > 0) { ToMap(item, entity, true, //includingProperties includingProfiles); } } return(entity); }
} // public static ThisEntity GetByUrl(string frameworkUrl) { ThisEntity entity = new ThisEntity(); if (string.IsNullOrWhiteSpace(frameworkUrl)) { return(entity); } try { using (var context = new EntityContext()) { DBEntity item = context.Reference_Frameworks .FirstOrDefault(s => s.TargetNode == frameworkUrl); if (item != null && item.Id > 0) { MapFromDB(item, entity); } } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".Get"); } return(entity); } //
public bool Delete(int Id, ref string statusMessage) { bool isValid = false; if (Id == 0) { statusMessage = "Error - missing an identifier for the PathwaySet"; return(false); } using (var context = new EntityContext()) { DBEntity efEntity = context.PathwaySet .SingleOrDefault(s => s.Id == Id); if (efEntity != null && efEntity.Id > 0) { context.PathwaySet.Remove(efEntity); int count = context.SaveChanges(); if (count > 0) { isValid = true; } } else { statusMessage = "Error - delete failed, as record was not found."; } } return(isValid); }
/// <summary> /// Check if the provided framework has already been sync'd. /// If not, it will be added. /// </summary> /// <param name="request"></param> /// <param name="userId"></param> /// <param name="messages"></param> /// <param name="frameworkId"></param> /// <returns></returns> //public bool HandleFrameworkRequest( CassFramework request, // int userId, // ref SaveStatus status, // ref int frameworkId ) //{ // bool isValid = true; // if ( request == null || string.IsNullOrWhiteSpace(request._IdAndVersion) ) // { // status.AddWarning( "The Cass Request doesn't contain a valid Cass Framework class." ); // return false; // } // ThisEntity item = Get( request._IdAndVersion ); // if (item != null && item.Id > 0) // { // //TODO - do we want to attempt an update - if changed // // - if we plan to implement a batch refresh of sync'd content, then not necessary // frameworkId = item.Id; // return true; // } // //add the framework... // ThisEntity entity = new ThisEntity(); // entity.Name = request.Name; // entity.Description = request.Description; // entity.FrameworkUrl = request.Url; // entity.RepositoryUri = request._IdAndVersion; // //TDO - need owning org - BUT, first person to reference a framework is not necessarily the owner!!!!! // //actually, we may not care here. Eventually get a ctid from CASS // //entity.OwningOrganizationId = 0; // isValid = Save( entity, userId, ref status ); // frameworkId = entity.Id; // return isValid; //} //actually not likely to have a separate list of frameworks //public bool SaveList( List<ThisEntity> list, ref SaveStatus status ) //{ // if ( list == null || list.Count == 0 ) // return true; // bool isAllValid = true; // foreach ( ThisEntity item in list ) // { // Save( item, ref status ); // } // return isAllValid; //} /// <summary> /// Add/Update a Reference_Framework /// </summary> /// <param name="entity"></param> /// <param name="messages"></param> /// <returns></returns> public bool Save(ThisEntity entity, ref SaveStatus status) { bool isValid = true; int count = 0; DBEntity efEntity = new DBEntity(); using (var context = new EntityContext()) { if (ValidateProfile(entity, ref status) == false) { return(false); } if (entity.Id == 0) { // - need to check for existance DoesItemExist(entity); } if (entity.Id == 0) { // - Add efEntity = new DBEntity(); MapToDB(entity, efEntity); efEntity.Created = DateTime.Now; //efEntity.RowId = Guid.NewGuid(); context.Reference_Frameworks.Add(efEntity); count = context.SaveChanges(); entity.Id = efEntity.Id; //entity.RowId = efEntity.RowId; if (count == 0) { status.AddWarning(string.Format(" Unable to add Profile: {0} <br\\> ", string.IsNullOrWhiteSpace(entity.Name) ? "no description" : entity.Name)); } } else { efEntity = context.Reference_Frameworks.SingleOrDefault(s => s.Id == entity.Id); if (efEntity != null && efEntity.Id > 0) { //entity.RowId = efEntity.RowId; //update MapToDB(entity, efEntity); //has changed? if (HasStateChanged(context)) { count = context.SaveChanges(); } } } } return(isValid); }
/// <summary> /// Get a basic PathwaySet by CTID /// </summary> /// <param name="ctid"></param> /// <returns></returns> public static ThisEntity GetByCtid(string ctid) { PathwaySet entity = new PathwaySet(); if (string.IsNullOrWhiteSpace(ctid)) { return(entity); } using (var context = new EntityContext()) { context.Configuration.LazyLoadingEnabled = false; EM.PathwaySet item = context.PathwaySet .FirstOrDefault(s => s.CTID.ToLower() == ctid.ToLower() && s.EntityStateId > 1 ); if (item != null && item.Id > 0) { MapFromDB(item, entity); } } return(entity); }
/// <summary> /// Get All for a DataSetProfileId /// </summary> /// <param name="dataSetProfileId"></param> /// <returns></returns> public static List <ThisEntity> GetAll(int dataSetProfileId) { var list = new List <ThisEntity>(); ThisEntity entity = new ThisEntity(); //Guid guid = new Guid( id ); using (var context = new EntityContext()) { var results = context.DataSetTimeFrame .Where(s => s.DataSetProfileId == dataSetProfileId) .OrderBy(s => s.Created) .ToList(); if (results != null && results.Count > 0) { foreach (var item in results) { entity = new ThisEntity(); MapFromDB(item, entity, true); list.Add(entity); } } } return(list); }
} // public static List <ThisEntity> GetAllManifests(Guid parentUid, bool forEditView) { List <ThisEntity> list = new List <ThisEntity>(); ThisEntity entity = new ThisEntity(); Entity parent = EntityManager.GetEntity(parentUid); try { using (var context = new EntityContext()) { List <EM.Entity_ConditionManifest> results = context.Entity_ConditionManifest .Where(s => s.EntityId == parent.Id) .OrderBy(s => s.ConditionManifestId) .ToList(); if (results != null && results.Count > 0) { foreach (EM.Entity_ConditionManifest item in results) { //TODO - optimize the appropriate MapFromDB methods entity = new ThisEntity(); MapFromDB(item.ConditionManifest, entity); list.Add(entity); } } return(list); } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".GetAllManifests"); } return(list); }
public static Entity EntityCacheGet(int entityTypeId, int entityBaseId) { Entity entity = new Entity(); using (var context = new EntityContext()) { var item = context.Entity_Cache .FirstOrDefault(s => s.EntityTypeId == entityTypeId && s.BaseId == entityBaseId); if (item != null && item.Id > 0) { entity.Id = item.Id; entity.EntityTypeId = item.EntityTypeId; entity.EntityType = item.EntityType; entity.EntityUid = item.EntityUid; entity.EntityBaseId = item.BaseId; entity.EntityBaseName = item.Name; entity.Created = ( DateTime )item.Created; entity.LastUpdated = ( DateTime )item.LastUpdated; if (item.parentEntityId > 0) { //NOTE - can use the included Entity to get more info // - although may want to turn off lazy loading entity.ParentEntity = new ThisEntity(); entity.ParentEntity.Id = item.parentEntityId ?? 0; entity.ParentEntity.EntityTypeId = item.parentEntityTypeId ?? 0; entity.ParentEntity.EntityType = item.parentEntityType; entity.ParentEntity.EntityUid = ( Guid )item.parentEntityUid; } } return(entity); } }
public static ThisEntity GetBySubjectWebpage(string swp) { ThisEntity entity = new ThisEntity(); using (var context = new EntityContext()) { context.Configuration.LazyLoadingEnabled = false; DBEntity from = context.ConditionManifest .FirstOrDefault(s => s.SubjectWebpage.ToLower() == swp.ToLower()); if (from != null && from.Id > 0) { entity.RowId = from.RowId; entity.Id = from.Id; entity.Name = from.Name; entity.EntityStateId = ( int )(from.EntityStateId ?? 1); entity.Description = from.Description; entity.SubjectWebpage = from.SubjectWebpage; entity.CTID = from.CTID; entity.CredentialRegistryId = from.CredentialRegistryId; } } return(entity); }
public static ThisEntity Get(int parentId, int recordId) { ThisEntity entity = new ThisEntity(); if (parentId < 1 || recordId < 1) { return(entity); } try { using (var context = new EntityContext()) { DBEntity from = context.Entity_IdentifierValue .SingleOrDefault(s => s.Id == recordId && s.EntityId == parentId); if (from != null && from.Id > 0) { MapFromDB(from, entity); } } } catch (Exception ex) { LoggingHelper.LogError(ex, thisClassName + ".Get"); } return(entity); } //
//public static List<ThisEntity> GetAll( ref int totalRecords, int maxRecords = 100 ) //{ // List<ThisEntity> list = new List<ThisEntity>(); // ThisEntity entity = new ThisEntity(); // using ( var context = new EntityContext() ) // { // List<DBEntity> results = context.OccupationProfile // .Where( s => s.EntityStateId > 2 ) // .OrderBy( s => s.Name ) // .ToList(); // if ( results != null && results.Count > 0 ) // { // totalRecords = results.Count(); // foreach ( DBEntity item in results ) // { // entity = new ThisEntity(); // MapFromDB( item, entity, false ); // list.Add( entity ); // if ( maxRecords > 0 && list.Count >= maxRecords ) // break; // } // } // } // return list; //} public static ThisEntity GetForDetail(int id) { ThisEntity entity = new ThisEntity(); using (var context = new EntityContext()) { DBEntity item = context.OccupationProfile .SingleOrDefault(s => s.Id == id); if (item != null && item.Id > 0) { //check for virtual deletes if (item.EntityStateId == 0) { return(entity); } MapFromDB(item, entity, true //includingProperties ); } } return(entity); }