/// <summary>
/// Active Dependent type names of this object
/// </summary>
public List <string> DependentObjectNames()
{
var dependentObjects = new List <string>();
if (Agreements.Any())
{
dependentObjects.Add(typeof(Agreement).Name);
}
if (FocusAreas.Any())
{
dependentObjects.Add(typeof(FocusArea).Name);
}
if (GrantAllocations.Any())
{
dependentObjects.Add(typeof(GrantAllocation).Name);
}
if (PersonStewardRegions.Any())
{
dependentObjects.Add(typeof(PersonStewardRegion).Name);
}
if (ProjectRegions.Any())
{
dependentObjects.Add(typeof(ProjectRegion).Name);
}
if (ProjectRegionUpdates.Any())
{
dependentObjects.Add(typeof(ProjectRegionUpdate).Name);
}
return(dependentObjects.Distinct().ToList());
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in Agreements.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in FocusAreas.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in GrantAllocations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in PersonStewardRegions.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectRegions.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectRegionUpdates.ToList())
{
x.DeleteFull(dbContext);
}
}
/// <summary>
/// Focuses the areas delete dal.
/// </summary>
/// <param name="_objFocusAreas">The object focus areas.</param>
/// <returns>System.Int32.</returns>
public int FocusAreas_DeleteDAL(FocusAreas _objFocusAreas)
{
return(ExecuteScalarInt32Sp("FocusAreas_Delete",
ParamBuilder.Par("ID", _objFocusAreas.ID),
ParamBuilder.Par("UpdatedBy", _objFocusAreas.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objFocusAreas.UpdatedDate)));
}
public int TMS_CourseFocusArea_DublicationDAL(FocusAreas _focusarea, long CourseId)
{
return(ExecuteScalarSPInt32("TMS_CourseFocus_DublicationCheck",
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("FocusID", _focusarea.ID),
ParamBuilder.Par("CreatedBy", _focusarea.CreatedBy)
));
}
/// <summary>
/// Focuses the areas duplication check dal.
/// </summary>
/// <param name="_objFocusAreas">The object focus areas.</param>
/// <returns>System.Int32.</returns>
public int FocusAreas_DuplicationCheckDAL(FocusAreas _objFocusAreas)
{
return(ExecuteScalarSPInt32("FocusAreas_DuplicationCheck",
ParamBuilder.Par("ID", _objFocusAreas.ID),
ParamBuilder.Par("PrimaryFocusAreaName", _objFocusAreas.PrimaryFocusAreaName),
ParamBuilder.Par("OrganizationID", _objFocusAreas.OrganizationID)
));
}
public int TMS_CourseFocusArea_UpdateDAL(FocusAreas _Coordinate, long CourseId)
{
return(ExecuteScalarInt32Sp("TMS_CourseFocusArea_Update",
ParamBuilder.Par("FocusID", _Coordinate.ID),
ParamBuilder.Par("OldID", _Coordinate.OLdID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("ModifiedBy", _Coordinate.UpdatedBy),
ParamBuilder.Par("ModifiedDate", _Coordinate.UpdatedDate)));
}
/// <summary>
/// Focuses the areas update dal.
/// </summary>
/// <param name="_objFocusAreas">The object focus areas.</param>
/// <returns>System.Int32.</returns>
public int FocusAreas_UpdateDAL(FocusAreas _objFocusAreas)
{
return(ExecuteScalarInt32Sp("FocusAreas_Update",
ParamBuilder.Par("ID", _objFocusAreas.ID),
ParamBuilder.Par("PrimaryFocusAreaName", _objFocusAreas.PrimaryFocusAreaName),
ParamBuilder.Par("SecondaryFocusAreaName", _objFocusAreas.SecondaryFocusAreaName),
ParamBuilder.Par("UpdatedBy", _objFocusAreas.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objFocusAreas.UpdatedDate)));
}
public long TMS_CourseFocusArea_CreateDAL(FocusAreas _Coordinate, long CourseId)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_CourseFocus_Create", parameters,
ParamBuilder.Par("FocusID", _Coordinate.ID),
ParamBuilder.Par("CourseID", CourseId),
ParamBuilder.Par("CreatedBy", _Coordinate.CreatedBy),
ParamBuilder.Par("CreatedDate", _Coordinate.CreatedDate)));
}
/// <summary>
/// Focuses the areas create dal.
/// </summary>
/// <param name="_objFocusAreas">The object focus areas.</param>
/// <returns>System.Int64.</returns>
public long FocusAreas_CreateDAL(FocusAreas _objFocusAreas)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("FocusAreas_Create", parameters,
ParamBuilder.Par("PrimaryFocusAreaName", _objFocusAreas.PrimaryFocusAreaName),
ParamBuilder.Par("SecondaryFocusAreaName", _objFocusAreas.SecondaryFocusAreaName),
ParamBuilder.Par("OrganizationID", _objFocusAreas.OrganizationID),
ParamBuilder.Par("CreatedBy", _objFocusAreas.CreatedBy),
ParamBuilder.Par("CreatedDate", _objFocusAreas.CreatedDate)));
}
/// <summary> /// Focuses the areas duplication check bal. /// </summary> /// <param name="_objFocusAreas">The object focus areas.</param> /// <returns>System.Int32.</returns> public int FocusAreas_DuplicationCheckBAL(FocusAreas _objFocusAreas) => _ConfigurationDAL.FocusAreas_DuplicationCheckDAL(_objFocusAreas);
/// <summary> /// Focuses the areas delete bal. /// </summary> /// <param name="_objFocusAreas">The object focus areas.</param> /// <returns>System.Int32.</returns> public int FocusAreas_DeleteBAL(FocusAreas _objFocusAreas) => _ConfigurationDAL.FocusAreas_DeleteDAL(_objFocusAreas);
/// <summary> /// Focuses the areas create bal. /// </summary> /// <param name="_objFocusAreas">The object focus areas.</param> /// <returns>System.Int64.</returns> public long FocusAreas_CreateBAL(FocusAreas _objFocusAreas) => _ConfigurationDAL.FocusAreas_CreateDAL(_objFocusAreas);
/// <summary>
/// Does this object have any dependent objects? (If it does have dependent objects, these would need to be deleted before this object could be deleted.)
/// </summary>
/// <returns></returns>
public bool HasDependentObjects()
{
return(Agreements.Any() || FocusAreas.Any() || GrantAllocations.Any() || PersonStewardRegions.Any() || ProjectRegions.Any() || ProjectRegionUpdates.Any());
}
public int TMS_CourseFocusArea_DeleteDAL(FocusAreas _focusarea, long CourseId)
{
return(_CourseDAL.TMS_CourseFocusArea_DeleteDAL(_focusarea, CourseId));
}
public long TMS_CourseFocusArea_CreateBAL(FocusAreas _focusarea, long CourseId)
{
return(_CourseDAL.TMS_CourseFocusArea_CreateDAL(_focusarea, CourseId));
}
