/// <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);
}
/// <summary>
/// Get a single Jurisdiction Profile by Guid
/// </summary>
/// <param name="rowId"></param>
/// <returns></returns>
public static ThisEntity Get(Guid rowId)
{
ThisEntity entity = new ThisEntity();
using (var context = new EntityContext())
{
DBEntity item = context.Entity_JurisdictionProfile
.SingleOrDefault(s => s.RowId == rowId);
if (item != null && item.Id > 0)
{
MapFromDB(item, entity, 1);
}
}
return(entity);
}
/// <summary>
/// Add a jurisdiction profile
/// </summary>
/// <param name="entity"></param>
/// <param name="property">Can be blank. Set to a property where additional validation is necessary</param>
/// <param name="messages"></param>
/// <returns></returns>
public bool Add(ThisEntity entity, string property, ref SaveStatus status, int assertedInTypeId = 0)
{
bool isValid = true;
using (var context = new EntityContext())
{
if (entity == null || !IsValidGuid(entity.ParentEntityUid))
{
status.AddWarning("Error - missing an identifier for the JurisdictionProfile");
return(false);
}
//ensure we have a parentId/EntityId
Entity parent = EntityManager.GetEntity(entity.ParentEntityUid);
if (parent == null || parent.Id == 0)
{
status.AddWarning("Error - the parent entity was not found.");
return(false);
}
//check for Empty
//==> not sure what is the minimum required fields!
bool isEmpty = false;
if (ValidateProfile(entity, property, ref isEmpty, ref status) == false)
{
return(false);
}
if (isEmpty)
{
//status.AddWarning( "Error - Jurisdiction profile is empty. " );
return(false);
}
//id = JurisdictionProfile_Add( entity, ref status );
DBEntity efEntity = new DBEntity();
MapToDB(entity, efEntity);
efEntity.EntityId = parent.Id;
if (IsValidGuid(entity.RowId))
{
efEntity.RowId = entity.RowId;
}
else
{
efEntity.RowId = Guid.NewGuid();
}
entity.RowId = efEntity.RowId;
if (efEntity.JProfilePurposeId == null || efEntity.JProfilePurposeId == 0)
{
efEntity.JProfilePurposeId = 1;
}
efEntity.Created = efEntity.LastUpdated = DateTime.Now;
context.Entity_JurisdictionProfile.Add(efEntity);
int count = context.SaveChanges();
if (count > 0)
{
entity.Id = efEntity.Id;
//update parts
UpdateParts(entity, true, ref status);
//??????? why
//UpdateJPRegions( entity, ref status );
}
}
return(isValid);
}
private static void MapFromDB(DBEntity from, ThisEntity to, int count)
{
to.Id = from.Id;
to.RowId = from.RowId;
to.ParentId = (int)from.EntityId;
//these will probably no lonber be necessary
to.ParentTypeId = from.Entity.EntityTypeId;
to.ParentEntityUid = from.Entity.EntityUid;
to.JProfilePurposeId = from.JProfilePurposeId != null ? ( int )from.JProfilePurposeId : 1;
if (IsGuidValid(from.AssertedByAgentUid))
{
to.AssertedBy = ( Guid )from.AssertedByAgentUid;
to.AssertedByOrganization = OrganizationManager.GetBasics(to.AssertedBy);
}
if ((from.Description ?? "") == "Auto-saved Jurisdiction")
{
to.Description = "";
}
else
{
to.Description = from.Description;
}
if (from.Created != null)
{
to.Created = ( DateTime )from.Created;
}
if (from.LastUpdated != null)
{
to.LastUpdated = ( DateTime )from.LastUpdated;
}
List <MC.GeoCoordinates> regions = GetAll(to.Id, false);
if (regions != null && regions.Count > 0)
{
to.MainJurisdiction = regions[0];
}
to.JurisdictionException = GetAll(to.Id, true);
if (to.MainJurisdiction != null && to.MainJurisdiction.GeoNamesId > 0 && to.MainJurisdiction.Name != "Earth")
{
to.IsGlobalJurisdiction = false;
}
else
{
to.IsGlobalJurisdiction = from.IsGlobalJurisdiction;
}
if (!string.IsNullOrWhiteSpace(from.Description))
{
to.ProfileSummary = from.Description;
}
else
{
if (to.MainJurisdiction != null && to.MainJurisdiction.GeoNamesId > 0)
{
to.ProfileSummary = to.MainJurisdiction.ProfileSummary;
}
else
{
if ((bool)(to.IsGlobalJurisdiction ?? false))
{
to.ProfileSummary = "Global";
}
else
{
to.ProfileSummary = "JurisdictionProfile Summary - " + count.ToString();
}
}
}
if ((from.AssertedInTypeId ?? 0) > 0 && from.Codes_AssertionType != null)
{
to.AssertedInTypeId = (int)from.AssertedInTypeId;
to.AssertedInType = from.Codes_AssertionType.Title;
Enumeration ja = new Enumeration()
{
Name = "Jurisdiction Assertions"
};
EnumeratedItem ei = new EnumeratedItem()
{
Id = to.AssertedInTypeId, Name = to.AssertedInType
};
to.JurisdictionAssertion.Items.Add(ei);
}
//***TODO ** handle differently?
//use of properties, requires creating an Entity for Jurisdiction???
if (to.JProfilePurposeId == 3)
{
}
//to.JurisdictionAssertion = EntityPropertyManager.FillEnumeration( to.RowId, CodesManager.PROPERTY_CATEGORY_JurisdictionAssertionType );
} //
/// <summary>
/// Mapping from interface model to entity model
/// Assuming that for updates, the entity model is always populated from DB, so here we can make assumptions regarding what can be updated.
/// </summary>
/// <param name="from"></param>
/// <param name="to"></param>
private static void MapToDB(ThisEntity from, DBEntity to)
{
to.Id = from.Id;
//to.EntityId = from.ParentId;
//don't allow a change if an update
if (from.Id == 0)
{
to.JProfilePurposeId = from.JProfilePurposeId > 0 ? from.JProfilePurposeId : 1;
}
else
{
//handle unexpected
if (to.JProfilePurposeId == null)
{
to.JProfilePurposeId = 1;
}
}
//from.MainJurisdiction is likely null
if (from.MainJurisdiction != null && from.MainJurisdiction.GeoNamesId == 0)
{
//List<MC.GeoCoordinates> regions = GetAll( to.Id, false );
//if ( regions != null && regions.Count > 0 )
//{
// from.MainJurisdiction = regions[ 0 ];
//}
}
if (from.MainJurisdiction != null && !string.IsNullOrWhiteSpace(from.MainJurisdiction.Name))
{
to.Name = from.MainJurisdiction.Name;
}
else
{
to.Name = "Default jurisdiction";
}
to.Description = from.Description;
//TODO - if a main jurisdiction exists, then global should be false
//may not be available
if (from.MainJurisdiction != null &&
(from.MainJurisdiction.GeoURI ?? "").Length > 0 &&
from.MainJurisdiction.Name != "Earth")
{
to.IsGlobalJurisdiction = false;
}
else if (from.IsGlobalJurisdiction != null)
{
to.IsGlobalJurisdiction = from.IsGlobalJurisdiction;
}
else
{
to.IsGlobalJurisdiction = null;
}
if (!IsGuidValid(from.AssertedBy) && from.AssertedByList != null && from.AssertedByList.Count > 0)
{
from.AssertedBy = from.AssertedByList[0];
}
if (IsGuidValid(from.AssertedBy))
{
if (to.Id > 0 && to.AssertedByAgentUid != from.AssertedBy)
{
if (IsGuidValid(to.AssertedByAgentUid))
{
//need to remove the previous roles on change of asserted by
//string statusMessage = "";
//new Entity_AgentRelationshipManager().Delete( to.RowId, to.AssertedByAgentUid, Entity_AgentRelationshipManager.ROLE_TYPE_OWNER, ref statusMessage );
}
}
to.AssertedByAgentUid = from.AssertedBy;
}
else
{
to.AssertedByAgentUid = null;
}
if (from.AssertedInTypeId > 0)
{
to.AssertedInTypeId = ( int )from.AssertedInTypeId;
}
else
{
to.AssertedInTypeId = null;
}
}