/// <summary>
/// This method creates an instance of a
/// 'FindFieldSetFieldStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'FieldSetField_Find'.
/// </summary>
/// <param name="fieldSetField">The 'FieldSetField' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindFieldSetFieldStoredProcedure CreateFindFieldSetFieldStoredProcedure(FieldSetField fieldSetField)
{
// Initial Value
FindFieldSetFieldStoredProcedure findFieldSetFieldStoredProcedure = null;
// verify fieldSetField exists
if (fieldSetField != null)
{
// Instanciate findFieldSetFieldStoredProcedure
findFieldSetFieldStoredProcedure = new FindFieldSetFieldStoredProcedure();
// if fieldSetField.FindByFieldSetId is true
if (fieldSetField.FindByFieldSetId)
{
// Change the procedure name
findFieldSetFieldStoredProcedure.ProcedureName = "FieldSetField_FindByFieldSetId";
// Create the @FieldSetId parameter
findFieldSetFieldStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@FieldSetId", fieldSetField.FieldSetId);
}
else
{
// Now create parameters for this procedure
findFieldSetFieldStoredProcedure.Parameters = CreatePrimaryKeyParameter(fieldSetField);
}
}
// return value
return(findFieldSetFieldStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindMethodStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Method_Find'.
/// </summary>
/// <param name="method">The 'Method' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindMethodStoredProcedure CreateFindMethodStoredProcedure(Method method)
{
// Initial Value
FindMethodStoredProcedure findMethodStoredProcedure = null;
// verify method exists
if (method != null)
{
// Instanciate findMethodStoredProcedure
findMethodStoredProcedure = new FindMethodStoredProcedure();
// if method.FindByName is true
if (method.FindByName)
{
// Change the procedure name
findMethodStoredProcedure.ProcedureName = "Method_FindByName";
// Create the @Name parameter
findMethodStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@Name", method.Name);
}
else
{
// Now create parameters for this procedure
findMethodStoredProcedure.Parameters = CreatePrimaryKeyParameter(method);
}
}
// return value
return(findMethodStoredProcedure);
}
/// <summary>
/// This method creates an instance of an
/// 'DeleteDTNTable'StoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'DTNTable_Delete'.
/// </summary>
/// <param name="dTNTable">The 'DTNTable' to Delete.</param>
/// <returns>An instance of a 'DeleteDTNTableStoredProcedure' object.</returns>
public static new DeleteDTNTableStoredProcedure CreateDeleteDTNTableStoredProcedure(DTNTable table)
{
// Initial Value
DeleteDTNTableStoredProcedure deleteDTNTableStoredProcedure = new DeleteDTNTableStoredProcedure();
// If the table object exists
if (table != null)
{
// if DeleteAllForProjectId is true and the ProjectId is set
if ((table.DeleteAllForProjectId) && (table.HasProjectId))
{
// change the procedureName
deleteDTNTableStoredProcedure.ProcedureName = "DTNTable_DeleteAllForProject";
// Set the @ProjectId parameter
deleteDTNTableStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", table.ProjectId);
}
else
{
// Now Create Parameters For The DeleteProc
deleteDTNTableStoredProcedure.Parameters = CreatePrimaryKeyParameter(table);
}
}
// return value
return(deleteDTNTableStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindUIFieldStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'UIField_Find'.
/// </summary>
/// <param name="uIField">The 'UIField' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindUIFieldStoredProcedure CreateFindUIFieldStoredProcedure(UIField uIField)
{
// Initial Value
FindUIFieldStoredProcedure findUIFieldStoredProcedure = null;
// verify uIField exists
if (uIField != null)
{
// Instanciate findUIFieldStoredProcedure
findUIFieldStoredProcedure = new FindUIFieldStoredProcedure();
// if uIField.FindByUserInterfaceId is true
if (uIField.FindByUserInterfaceId)
{
// Change the procedure name
findUIFieldStoredProcedure.ProcedureName = "UIField_FindByUserInterfaceId";
// Create the @UserInterfaceId parameter
findUIFieldStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@UserInterfaceId", uIField.UserInterfaceId);
}
else
{
// Now create parameters for this procedure
findUIFieldStoredProcedure.Parameters = CreatePrimaryKeyParameter(uIField);
}
}
// return value
return(findUIFieldStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllMethodsStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Method_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllMethodsStoredProcedure' object.</returns>
public static new FetchAllMethodsStoredProcedure CreateFetchAllMethodsStoredProcedure(Method method)
{
// Initial value
FetchAllMethodsStoredProcedure fetchAllMethodsStoredProcedure = new FetchAllMethodsStoredProcedure();
// If the method object exists
if (method != null)
{
if ((method.FetchAllForTable) && (method.HasTableId))
{
// change the procedureName
fetchAllMethodsStoredProcedure.ProcedureName = "Method_FetchAllForTable";
// create the @TableId parameter
fetchAllMethodsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@TableId", method.TableId);
}
// if method.LoadByProjectId is true
else if (method.LoadByProjectId)
{
// Change the procedure name
fetchAllMethodsStoredProcedure.ProcedureName = "Method_FetchAllByProjectId";
// Create the @ProjectId parameter
fetchAllMethodsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", method.ProjectId);
}
}
// return value
return(fetchAllMethodsStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindUserInterfaceStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'UserInterface_Find'.
/// </summary>
/// <param name="userInterface">The 'UserInterface' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindUserInterfaceStoredProcedure CreateFindUserInterfaceStoredProcedure(UserInterface userInterface)
{
// Initial Value
FindUserInterfaceStoredProcedure findUserInterfaceStoredProcedure = null;
// verify userInterface exists
if (userInterface != null)
{
// Instanciate findUserInterfaceStoredProcedure
findUserInterfaceStoredProcedure = new FindUserInterfaceStoredProcedure();
// if userInterface.FindByProjectId is true
if (userInterface.FindByProjectId)
{
// Change the procedure name
findUserInterfaceStoredProcedure.ProcedureName = "UserInterface_FindByProjectId";
// Create the @ProjectId parameter
findUserInterfaceStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", userInterface.ProjectId);
}
else
{
// Now create parameters for this procedure
findUserInterfaceStoredProcedure.Parameters = CreatePrimaryKeyParameter(userInterface);
}
}
// return value
return(findUserInterfaceStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindArtistStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Artist_Find'.
/// </summary>
/// <param name="artist">The 'Artist' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindArtistStoredProcedure CreateFindArtistStoredProcedure(Artist artist)
{
// Initial Value
FindArtistStoredProcedure findArtistStoredProcedure = null;
// verify artist exists
if (artist != null)
{
// Instanciate findArtistStoredProcedure
findArtistStoredProcedure = new FindArtistStoredProcedure();
// if artist.FindByEmailAddress is true
if (artist.FindByEmailAddress)
{
// Change the procedure name
findArtistStoredProcedure.ProcedureName = "Artist_FindByEmailAddress";
// Create the @EmailAddress parameter
findArtistStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@EmailAddress", artist.EmailAddress);
}
else
{
// Now create parameters for this procedure
findArtistStoredProcedure.Parameters = CreatePrimaryKeyParameter(artist);
}
}
// return value
return(findArtistStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindStateStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'State_Find'.
/// </summary>
/// <param name="state">The 'State' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindStateStoredProcedure CreateFindStateStoredProcedure(State state)
{
// Initial Value
FindStateStoredProcedure findStateStoredProcedure = null;
// verify state exists
if (state != null)
{
// Instanciate findStateStoredProcedure
findStateStoredProcedure = new FindStateStoredProcedure();
// if state.FindByName is true
if (state.FindByName)
{
// Change the procedure name
findStateStoredProcedure.ProcedureName = "State_FindByName";
// Create the @Name parameter
findStateStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@Name", state.Name);
}
else
{
// Now create parameters for this procedure
findStateStoredProcedure.Parameters = CreatePrimaryKeyParameter(state);
}
}
// return value
return(findStateStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllFieldSetsStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'FieldSet_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllFieldSetsStoredProcedure' object.</returns>
public static new FetchAllFieldSetsStoredProcedure CreateFetchAllFieldSetsStoredProcedure(FieldSet fieldSet)
{
// Initial value
FetchAllFieldSetsStoredProcedure fetchAllFieldSetsStoredProcedure = new FetchAllFieldSetsStoredProcedure();
// If the fieldSet object exists
if (fieldSet != null)
{
// if FetchAllForTable is true and the TableId is set
if ((fieldSet.FetchAllForTable) && (fieldSet.HasTableId))
{
// if ParameterMode is true, only FieldSets set to ParameterMode = true will be shown
if (fieldSet.ParameterMode)
{
// change the ProcedureName
fetchAllFieldSetsStoredProcedure.ProcedureName = "FieldSet_FetchAllInParameterModeForTable";
}
else
{
// change the ProcedureName
fetchAllFieldSetsStoredProcedure.ProcedureName = "FieldSet_FetchAllForTable";
}
// Create the TableId parameter
fetchAllFieldSetsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@TableId", fieldSet.TableId);
}
}
// return value
return(fetchAllFieldSetsStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllEnumerationsUsersStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Enumeration_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllEnumerationsStoredProcedure' object.</returns>
public new static FetchAllEnumerationsStoredProcedure CreateFetchAllEnumerationsStoredProcedure(Enumeration enumeration)
{
// Initial value
FetchAllEnumerationsStoredProcedure fetchAllEnumerationsStoredProcedure = new FetchAllEnumerationsStoredProcedure();
// if the ProjectId is set
if ((enumeration != null) && (enumeration.ProjectId > 0))
{
// set the procedure name
fetchAllEnumerationsStoredProcedure.ProcedureName = "Enumeration_FetchAllForProject";
// Create the parameters
fetchAllEnumerationsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", enumeration.ProjectId);
}
// return value
return(fetchAllEnumerationsStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllDTNDatabasesUsersStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'DTNDatabase_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllDTNDatabasesStoredProcedure' object.</returns>
public new static FetchAllDTNDatabasesStoredProcedure CreateFetchAllDTNDatabasesStoredProcedure(DTNDatabase database)
{
// Initial value
FetchAllDTNDatabasesStoredProcedure fetchAllDTNDatabasesStoredProcedure = new FetchAllDTNDatabasesStoredProcedure();
// verify the database exists
if ((database != null) && (database.ProjectId > 0))
{
// set the procedure name
fetchAllDTNDatabasesStoredProcedure.ProcedureName = "DTNDatabase_FetchAllForProject";
// create the parameters
fetchAllDTNDatabasesStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", database.ProjectId);
}
// return value
return(fetchAllDTNDatabasesStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllProjectReferencesUsersStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'ProjectReference_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllProjectReferencesStoredProcedure' object.</returns>
public static new FetchAllProjectReferencesStoredProcedure CreateFetchAllProjectReferencesStoredProcedure(ProjectReference projectReference)
{
// Initial value
FetchAllProjectReferencesStoredProcedure fetchAllProjectReferencesStoredProcedure = new FetchAllProjectReferencesStoredProcedure();
// if the projectReference exists
if ((projectReference != null) && (projectReference.ReferencesSetId > 0))
{
// set the procedure name
fetchAllProjectReferencesStoredProcedure.ProcedureName = "ProjectReference_FetchAllForReferencesSet";
// create the ReferencesSetID parameter
fetchAllProjectReferencesStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ReferencesSetID", projectReference.ReferencesSetId);
}
// return value
return(fetchAllProjectReferencesStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindUserStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'User_Find'.
/// </summary>
/// <param name="user">The 'User' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindUserStoredProcedure CreateFindUserStoredProcedure(User user)
{
// Initial Value
FindUserStoredProcedure findUserStoredProcedure = null;
// verify user exists
if (user != null)
{
// Instanciate findUserStoredProcedure
findUserStoredProcedure = new FindUserStoredProcedure();
// if user.FindByEmailAddress is true
if (user.FindByEmailAddress)
{
// Change the procedure name
findUserStoredProcedure.ProcedureName = "User_FindByEmailAddress";
// Create the @EmailAddress parameter
findUserStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@EmailAddress", user.EmailAddress);
}
// if user.FindByUserName is true
else if (user.FindByUserName)
{
// Change the procedure name
findUserStoredProcedure.ProcedureName = "User_FindByUserName";
// Create the @UserName parameter
findUserStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@UserName", user.UserName);
}
else
{
// Now create parameters for this procedure
findUserStoredProcedure.Parameters = CreatePrimaryKeyParameter(user);
}
}
// return value
return(findUserStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllDTNTablesStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'DTNTable_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllDTNTablesStoredProcedure' object.</returns>
public static new FetchAllDTNTablesStoredProcedure CreateFetchAllDTNTablesStoredProcedure(DTNTable dTNTable)
{
// Initial value
FetchAllDTNTablesStoredProcedure fetchAllDTNTablesStoredProcedure = new FetchAllDTNTablesStoredProcedure();
// if the dTNTable object exists
if (dTNTable != null)
{
// if LoadByProjectId is true
if (dTNTable.LoadByProjectId)
{
// Change the procedure name
fetchAllDTNTablesStoredProcedure.ProcedureName = "DTNTable_FetchAllByProjectId";
// Create the @ProjectId parameter
fetchAllDTNTablesStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@ProjectId", dTNTable.ProjectId);
}
}
// return value
return(fetchAllDTNTablesStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllImagesStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Image_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllImagesStoredProcedure' object.</returns>
public static new FetchAllImagesStoredProcedure CreateFetchAllImagesStoredProcedure(Image image)
{
// Initial value
FetchAllImagesStoredProcedure fetchAllImagesStoredProcedure = new FetchAllImagesStoredProcedure();
// if the image object exists
if (image != null)
{
// if LoadByOwnerId is true
if (image.LoadByOwnerId)
{
// Change the procedure name
fetchAllImagesStoredProcedure.ProcedureName = "Image_FetchAllForOwnerId";
// Create the @OwnerId parameter
fetchAllImagesStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@OwnerId", image.OwnerId);
}
}
// return value
return(fetchAllImagesStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllFieldSetFieldsStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'FieldSetField_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllFieldSetFieldsStoredProcedure' object.</returns>
public static new FetchAllFieldSetFieldsStoredProcedure CreateFetchAllFieldSetFieldsStoredProcedure(FieldSetField fieldSetField)
{
// Initial value
FetchAllFieldSetFieldsStoredProcedure fetchAllFieldSetFieldsStoredProcedure = new FetchAllFieldSetFieldsStoredProcedure();
// if the fieldSetField object exists
if (fieldSetField != null)
{
// if LoadByFieldSetId is true
if (fieldSetField.LoadByFieldSetId)
{
// Change the procedure name
fetchAllFieldSetFieldsStoredProcedure.ProcedureName = "FieldSetField_FetchAllForFieldSetId";
// Create the @FieldSetId parameter
fetchAllFieldSetFieldsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@FieldSetId", fieldSetField.FieldSetId);
}
}
// return value
return(fetchAllFieldSetFieldsStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FindNotificationStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'Notification_Find'.
/// </summary>
/// <param name="notification">The 'Notification' to use to
/// get the primary key parameter.</param>
/// <returns>An instance of an FetchUserStoredProcedure</returns>
public static new FindNotificationStoredProcedure CreateFindNotificationStoredProcedure(Notification notification)
{
// Initial Value
FindNotificationStoredProcedure findNotificationStoredProcedure = null;
// verify notification exists
if (notification != null)
{
// Instanciate findNotificationStoredProcedure
findNotificationStoredProcedure = new FindNotificationStoredProcedure();
// if notification.FindBy is true
if (notification.FindBy)
{
// Change the procedure name
findNotificationStoredProcedure.ProcedureName = "Notification_FindBy";
// Create the @EmailAddress parameter
findNotificationStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@EmailAddress", notification.EmailAddress);
}
// if notification.FindByEmailAddress is true
else if (notification.FindByEmailAddress)
{
// Change the procedure name
findNotificationStoredProcedure.ProcedureName = "Notification_FindByEmailAddress";
// Create the @EmailAddress parameter
findNotificationStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@EmailAddress", notification.EmailAddress);
}
else
{
// Now create parameters for this procedure
findNotificationStoredProcedure.Parameters = CreatePrimaryKeyParameter(notification);
}
}
// return value
return(findNotificationStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllDTNFieldsStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'DTNField_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllDTNFieldsStoredProcedure' object.</returns>
public static new FetchAllDTNFieldsStoredProcedure CreateFetchAllDTNFieldsStoredProcedure(DTNField field)
{
// Initial value
FetchAllDTNFieldsStoredProcedure fetchAllDTNFieldsStoredProcedure = new FetchAllDTNFieldsStoredProcedure();
// If the dTNField object exists
if (field != null)
{
// if FetchAllForTable is true and the TableId is set
if ((field.FetchAllForTable) && (field.HasTableId))
{
// change the procedure name
fetchAllDTNFieldsStoredProcedure.ProcedureName = "DTNField_FetchAllForTableId";
// create the @TableId parameter
fetchAllDTNFieldsStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@TableId", field.TableId);
}
}
// return value
return(fetchAllDTNFieldsStoredProcedure);
}
/// <summary>
/// This method creates an instance of a
/// 'FetchAllCustomReadersStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'CustomReader_FetchAll'.
/// </summary>
/// <returns>An instance of a(n) 'FetchAllCustomReadersStoredProcedure' object.</returns>
public static new FetchAllCustomReadersStoredProcedure CreateFetchAllCustomReadersStoredProcedure(CustomReader customReader)
{
// Initial value
FetchAllCustomReadersStoredProcedure fetchAllCustomReadersStoredProcedure = new FetchAllCustomReadersStoredProcedure();
// If the customReader object exists
if (customReader != null)
{
// if the TableId is set and FetchAllFortable is true
if ((customReader.HasTableId) && (customReader.FetchAllForTable))
{
// change the procedure name
fetchAllCustomReadersStoredProcedure.ProcedureName = "CustomReader_FetchAllForTable";
// create the @TableId parameter
fetchAllCustomReadersStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@TableId", customReader.TableId);
}
}
// return value
return(fetchAllCustomReadersStoredProcedure);
}
/// <summary>
/// This method creates an instance of an
/// 'DeleteFieldSetField'StoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'FieldSetField_Delete'.
/// </summary>
/// <param name="fieldSetField">The 'FieldSetField' to Delete.</param>
/// <returns>An instance of a 'DeleteFieldSetFieldStoredProcedure' object.</returns>
public static new DeleteFieldSetFieldStoredProcedure CreateDeleteFieldSetFieldStoredProcedure(FieldSetField fieldSetField)
{
// Initial Value
DeleteFieldSetFieldStoredProcedure deleteFieldSetFieldStoredProcedure = new DeleteFieldSetFieldStoredProcedure();
// If the fieldSetField object exists
if ((fieldSetField != null) && (fieldSetField.DeleteAllForFieldSet) && (fieldSetField.HasFieldSetId))
{
// Set the ProcedureName
deleteFieldSetFieldStoredProcedure.ProcedureName = "FieldSetField_DeleteAllForFieldSetId";
// Create the @FieldSetId parameter
deleteFieldSetFieldStoredProcedure.Parameters = SqlParameterHelper.CreateSqlParameters("@FieldSetId", fieldSetField.FieldSetId);
}
else
{
// Now Create Parameters For The DeleteProc
deleteFieldSetFieldStoredProcedure.Parameters = CreatePrimaryKeyParameter(fieldSetField);
}
// return value
return(deleteFieldSetFieldStoredProcedure);
}