/// <summary>
/// This method finds a 'FieldSetField' object.
/// This method uses the 'FieldSetField_Find' procedure.
/// </summary>
/// <returns>A 'FieldSetField' object.</returns>
/// </summary>
public FieldSetField FindFieldSetField(FindFieldSetFieldStoredProcedure findFieldSetFieldProc, DataConnector databaseConnector)
{
// Initial Value
FieldSetField fieldSetField = null;
// Verify database connection is connected
if ((databaseConnector != null) && (databaseConnector.Connected))
{
// First Get Dataset
DataSet fieldSetFieldDataSet = this.DataHelper.LoadDataSet(findFieldSetFieldProc, databaseConnector);
// Verify DataSet Exists
if (fieldSetFieldDataSet != null)
{
// Get DataTable From DataSet
DataRow row = this.DataHelper.ReturnFirstRow(fieldSetFieldDataSet);
// if row exists
if (row != null)
{
// Load FieldSetField
fieldSetField = FieldSetFieldReader.Load(row);
}
}
}
// return value
return(fieldSetField);
}
/// <summary>
/// This method returns the Field
/// </summary>
public static FieldSetField FindFieldSetField(List <FieldSetField> fields, int fieldId)
{
// initial value
FieldSetField field = null;
// If the fields collection exists and has one or more items
if ((ListHelper.HasOneOrMoreItems(fields)) && (fieldId > 0))
{
// Iterate the collection of DTNField objects
foreach (FieldSetField tempField in fields)
{
// if this is the field being sought
if (tempField.FieldId == fieldId)
{
// set the return value
field = tempField;
// break;
break;
}
}
}
// return value
return(field);
}
/// <summary>
/// This method loads a 'FieldSetField' object
/// from the dataRow passed in.
/// </summary>
/// <param name='dataRow'>The 'DataRow' to load from.</param>
/// <returns>A 'FieldSetField' DataObject.</returns>
public static FieldSetField Load(DataRow dataRow)
{
// Initial Value
FieldSetField fieldSetField = new FieldSetField();
// Create field Integers
int fieldIdfield = 0;
int fieldOrdinalfield = 1;
int fieldSetFieldIdfield = 2;
int fieldSetIdfield = 3;
int orderByDescendingfield = 4;
try
{
// Load Each field
fieldSetField.FieldId = DataHelper.ParseInteger(dataRow.ItemArray[fieldIdfield], 0);
fieldSetField.FieldOrdinal = DataHelper.ParseInteger(dataRow.ItemArray[fieldOrdinalfield], 0);
fieldSetField.UpdateIdentity(DataHelper.ParseInteger(dataRow.ItemArray[fieldSetFieldIdfield], 0));
fieldSetField.FieldSetId = DataHelper.ParseInteger(dataRow.ItemArray[fieldSetIdfield], 0);
fieldSetField.OrderByDescending = DataHelper.ParseBoolean(dataRow.ItemArray[orderByDescendingfield], false);
}
catch
{
}
// return value
return(fieldSetField);
}
/// <summary>
/// Saves a 'FieldSetField' object into the database.
/// This method calls the 'Insert' or 'Update' method.
/// </summary>
/// <param name='fieldSetField'>The 'FieldSetField' object to save.</param>
/// <returns>True if successful or false if not.</returns>
public bool Save(ref FieldSetField fieldSetField)
{
// Initial value
bool saved = false;
// If the fieldSetField exists.
if (fieldSetField != null)
{
// Is this a new FieldSetField
if (fieldSetField.IsNew)
{
// Insert new FieldSetField
int newIdentity = this.Insert(fieldSetField);
// if insert was successful
if (newIdentity > 0)
{
// Update Identity
fieldSetField.UpdateIdentity(newIdentity);
// Set return value
saved = true;
}
}
else
{
// Update FieldSetField
saved = this.Update(fieldSetField);
}
}
// return value
return(saved);
}
/// <summary>
/// This method deletes a 'FieldSetField' object.
/// </summary>
/// <param name='List<PolymorphicObject>'>The 'FieldSetField' to delete.
/// <returns>A PolymorphicObject object with a Boolean value.
internal PolymorphicObject DeleteFieldSetField(List <PolymorphicObject> parameters, DataConnector dataConnector)
{
// Initial Value
PolymorphicObject returnObject = new PolymorphicObject();
// If the data connection is connected
if ((dataConnector != null) && (dataConnector.Connected == true))
{
// Create Delete StoredProcedure
DeleteFieldSetFieldStoredProcedure deleteFieldSetFieldProc = null;
// verify the first parameters is a(n) 'FieldSetField'.
if (parameters[0].ObjectValue as FieldSetField != null)
{
// Create FieldSetField
FieldSetField fieldSetField = (FieldSetField)parameters[0].ObjectValue;
// verify fieldSetField exists
if (fieldSetField != null)
{
// Now create deleteFieldSetFieldProc from FieldSetFieldWriter
// The DataWriter converts the 'FieldSetField'
// to the SqlParameter[] array needed to delete a 'FieldSetField'.
deleteFieldSetFieldProc = FieldSetFieldWriter.CreateDeleteFieldSetFieldStoredProcedure(fieldSetField);
}
}
// Verify deleteFieldSetFieldProc exists
if (deleteFieldSetFieldProc != null)
{
// Execute Delete Stored Procedure
bool deleted = this.DataManager.FieldSetFieldManager.DeleteFieldSetField(deleteFieldSetFieldProc, dataConnector);
// Create returnObject.Boolean
returnObject.Boolean = new NullableBoolean();
// If delete was successful
if (deleted)
{
// Set returnObject.Boolean.Value to true
returnObject.Boolean.Value = NullableBooleanEnum.True;
}
else
{
// Set returnObject.Boolean.Value to false
returnObject.Boolean.Value = NullableBooleanEnum.False;
}
}
}
else
{
// Raise Error Data Connection Not Available
throw new Exception("The database connection is not available.");
}
// return value
return(returnObject);
}
/// <summary>
/// This method finds a 'FieldSetField' object.
/// </summary>
/// <param name='List<PolymorphicObject>'>The 'FieldSetField' to delete.
/// <returns>A PolymorphicObject object with a Boolean value.
internal PolymorphicObject FindFieldSetField(List <PolymorphicObject> parameters, DataConnector dataConnector)
{
// Initial Value
PolymorphicObject returnObject = new PolymorphicObject();
// locals
FieldSetField fieldSetField = null;
// If the data connection is connected
if ((dataConnector != null) && (dataConnector.Connected == true))
{
// Create Find StoredProcedure
FindFieldSetFieldStoredProcedure findFieldSetFieldProc = null;
// verify the first parameters is a 'FieldSetField'.
if (parameters[0].ObjectValue as FieldSetField != null)
{
// Get FieldSetFieldParameter
FieldSetField paramFieldSetField = (FieldSetField)parameters[0].ObjectValue;
// verify paramFieldSetField exists
if (paramFieldSetField != null)
{
// Now create findFieldSetFieldProc from FieldSetFieldWriter
// The DataWriter converts the 'FieldSetField'
// to the SqlParameter[] array needed to find a 'FieldSetField'.
findFieldSetFieldProc = FieldSetFieldWriter.CreateFindFieldSetFieldStoredProcedure(paramFieldSetField);
}
// Verify findFieldSetFieldProc exists
if (findFieldSetFieldProc != null)
{
// Execute Find Stored Procedure
fieldSetField = this.DataManager.FieldSetFieldManager.FindFieldSetField(findFieldSetFieldProc, dataConnector);
// if dataObject exists
if (fieldSetField != null)
{
// set returnObject.ObjectValue
returnObject.ObjectValue = fieldSetField;
}
}
}
else
{
// Raise Error Data Connection Not Available
throw new Exception("The database connection is not available.");
}
}
// return value
return(returnObject);
}
/// <summary>
/// This method fetches all 'FieldSetField' objects.
/// </summary>
/// <param name='List<PolymorphicObject>'>The 'FieldSetField' to delete.
/// <returns>A PolymorphicObject object with all 'FieldSetFields' objects.
internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector)
{
// Initial Value
PolymorphicObject returnObject = new PolymorphicObject();
// locals
List <FieldSetField> fieldSetFieldListCollection = null;
// Create FetchAll StoredProcedure
FetchAllFieldSetFieldsStoredProcedure fetchAllProc = null;
// If the data connection is connected
if ((dataConnector != null) && (dataConnector.Connected == true))
{
// Get FieldSetFieldParameter
// Declare Parameter
FieldSetField paramFieldSetField = null;
// verify the first parameters is a(n) 'FieldSetField'.
if (parameters[0].ObjectValue as FieldSetField != null)
{
// Get FieldSetFieldParameter
paramFieldSetField = (FieldSetField)parameters[0].ObjectValue;
}
// Now create FetchAllFieldSetFieldsProc from FieldSetFieldWriter
fetchAllProc = FieldSetFieldWriter.CreateFetchAllFieldSetFieldsStoredProcedure(paramFieldSetField);
}
// Verify fetchAllProc exists
if (fetchAllProc != null)
{
// Execute FetchAll Stored Procedure
fieldSetFieldListCollection = this.DataManager.FieldSetFieldManager.FetchAllFieldSetFields(fetchAllProc, dataConnector);
// if dataObjectCollection exists
if (fieldSetFieldListCollection != null)
{
// set returnObject.ObjectValue
returnObject.ObjectValue = fieldSetFieldListCollection;
}
}
else
{
// Raise Error Data Connection Not Available
throw new Exception("The database connection is not available.");
}
// return value
return(returnObject);
}
/// <summary>
/// Deletes a 'FieldSetField' from the database
/// This method calls the DataBridgeManager to execute the delete using the
/// procedure 'FieldSetField_Delete'.
/// </summary>
/// <param name='fieldsetfield'>The 'FieldSetField' to delete.</param>
/// <returns>True if the delete is successful or false if not.</returns>
public bool Delete(FieldSetField tempFieldSetField)
{
// locals
bool deleted = false;
// Get information for calling 'DataBridgeManager.PerformDataOperation' method.
string methodName = "DeleteFieldSetField";
string objectName = "ApplicationLogicComponent.Controllers";
try
{
// verify tempfieldSetField exists before attemptintg to delete
if (tempFieldSetField != null)
{
// Create Delegate For DataOperation
ApplicationController.DataOperationMethod deleteFieldSetFieldMethod = this.AppController.DataBridge.DataOperations.FieldSetFieldMethods.DeleteFieldSetField;
// Create parameters for this method
List <PolymorphicObject> parameters = CreateFieldSetFieldParameter(tempFieldSetField);
// Perform DataOperation
PolymorphicObject returnObject = this.AppController.DataBridge.PerformDataOperation(methodName, objectName, deleteFieldSetFieldMethod, parameters);
// If return object exists
if (returnObject != null)
{
// Test For True
if (returnObject.Boolean.Value == NullableBooleanEnum.True)
{
// Set Deleted To True
deleted = true;
}
}
}
}
catch (Exception error)
{
// If ErrorProcessor exists
if (this.ErrorProcessor != null)
{
// Log the current error
this.ErrorProcessor.LogError(methodName, objectName, error);
}
}
// return value
return(deleted);
}
/// <summary>
/// This method creates the parameter for a 'FieldSetField' data operation.
/// </summary>
/// <param name='fieldsetfield'>The 'FieldSetField' to use as the first
/// parameter (parameters[0]).</param>
/// <returns>A List<PolymorphicObject> collection.</returns>
private List <PolymorphicObject> CreateFieldSetFieldParameter(FieldSetField fieldSetField)
{
// Initial Value
List <PolymorphicObject> parameters = new List <PolymorphicObject>();
// Create PolymorphicObject to hold the parameter
PolymorphicObject parameter = new PolymorphicObject();
// Set parameter.ObjectValue
parameter.ObjectValue = fieldSetField;
// Add userParameter to parameters
parameters.Add(parameter);
// return value
return(parameters);
}
/// <summary>
/// This method creates the sql Parameter[] array
/// that holds the primary key value.
/// </summary>
/// <param name='fieldSetField'>The 'FieldSetField' to get the primary key of.</param>
/// <returns>A SqlParameter[] array which contains the primary key value.
/// to delete.</returns>
internal static SqlParameter[] CreatePrimaryKeyParameter(FieldSetField fieldSetField)
{
// Initial Value
SqlParameter[] parameters = new SqlParameter[1];
// verify user exists
if (fieldSetField != null)
{
// Create PrimaryKey Parameter
SqlParameter @FieldSetFieldId = new SqlParameter("@FieldSetFieldId", fieldSetField.FieldSetFieldId);
// Set parameters[0] to @FieldSetFieldId
parameters[0] = @FieldSetFieldId;
}
// return value
return(parameters);
}
/// <summary>
/// Finds a 'FieldSetField' object by the primary key.
/// This method used the DataBridgeManager to execute the 'Find' using the
/// procedure 'FieldSetField_Find'</param>
/// </summary>
/// <param name='tempFieldSetField'>A temporary FieldSetField for passing values.</param>
/// <returns>A 'FieldSetField' object if found else a null 'FieldSetField'.</returns>
public FieldSetField Find(FieldSetField tempFieldSetField)
{
// Initial values
FieldSetField fieldSetField = null;
// Get information for calling 'DataBridgeManager.PerformDataOperation' method.
string methodName = "Find";
string objectName = "ApplicationLogicComponent.Controllers";
try
{
// If object exists
if (tempFieldSetField != null)
{
// Create DataOperation
ApplicationController.DataOperationMethod findMethod = this.AppController.DataBridge.DataOperations.FieldSetFieldMethods.FindFieldSetField;
// Create parameters for this method
List <PolymorphicObject> parameters = CreateFieldSetFieldParameter(tempFieldSetField);
// Perform DataOperation
PolymorphicObject returnObject = this.AppController.DataBridge.PerformDataOperation(methodName, objectName, findMethod, parameters);
// If return object exists
if ((returnObject != null) && (returnObject.ObjectValue as FieldSetField != null))
{
// Get ReturnObject
fieldSetField = (FieldSetField)returnObject.ObjectValue;
}
}
}
catch (Exception error)
{
// If ErrorProcessor exists
if (this.ErrorProcessor != null)
{
// Log the current error
this.ErrorProcessor.LogError(methodName, objectName, error);
}
}
// return value
return(fieldSetField);
}
/// <summary>
/// Insert a 'FieldSetField' object into the database.
/// This method uses the DataBridgeManager to execute the 'Insert' using the
/// procedure 'FieldSetField_Insert'.</param>
/// </summary>
/// <param name='fieldSetField'>The 'FieldSetField' object to insert.</param>
/// <returns>The id (int) of the new 'FieldSetField' object that was inserted.</returns>
public int Insert(FieldSetField fieldSetField)
{
// Initial values
int newIdentity = -1;
// Get information for calling 'DataBridgeManager.PerformDataOperation' method.
string methodName = "Insert";
string objectName = "ApplicationLogicComponent.Controllers";
try
{
// If FieldSetFieldexists
if (fieldSetField != null)
{
ApplicationController.DataOperationMethod insertMethod = this.AppController.DataBridge.DataOperations.FieldSetFieldMethods.InsertFieldSetField;
// Create parameters for this method
List <PolymorphicObject> parameters = CreateFieldSetFieldParameter(fieldSetField);
// Perform DataOperation
PolymorphicObject returnObject = this.AppController.DataBridge.PerformDataOperation(methodName, objectName, insertMethod, parameters);
// If return object exists
if (returnObject != null)
{
// Set return value
newIdentity = returnObject.IntegerValue;
}
}
}
catch (Exception error)
{
// If ErrorProcessor exists
if (this.ErrorProcessor != null)
{
// Log the current error
this.ErrorProcessor.LogError(methodName, objectName, error);
}
}
// return value
return(newIdentity);
}
/// <summary>
/// This method Updates a 'FieldSetField' object in the database.
/// This method used the DataBridgeManager to execute the 'Update' using the
/// procedure 'FieldSetField_Update'.</param>
/// </summary>
/// <param name='fieldSetField'>The 'FieldSetField' object to update.</param>
/// <returns>True if successful else false if not.</returns>
public bool Update(FieldSetField fieldSetField)
{
// Initial value
bool saved = false;
// Get information for calling 'DataBridgeManager.PerformDataOperation' method.
string methodName = "Update";
string objectName = "ApplicationLogicComponent.Controllers";
try
{
if (fieldSetField != null)
{
// Create Delegate
ApplicationController.DataOperationMethod updateMethod = this.AppController.DataBridge.DataOperations.FieldSetFieldMethods.UpdateFieldSetField;
// Create parameters for this method
List <PolymorphicObject> parameters = CreateFieldSetFieldParameter(fieldSetField);
// Perform DataOperation
PolymorphicObject returnObject = this.AppController.DataBridge.PerformDataOperation(methodName, objectName, updateMethod, parameters);
// If return object exists
if ((returnObject != null) && (returnObject.Boolean != null) && (returnObject.Boolean.Value == NullableBooleanEnum.True))
{
// Set saved to true
saved = true;
}
}
}
catch (Exception error)
{
// If ErrorProcessor exists
if (this.ErrorProcessor != null)
{
// Log the current error
this.ErrorProcessor.LogError(methodName, objectName, error);
}
}
// return value
return(saved);
}
/// <summary>
/// This method creates the sql Parameters[] needed for
/// update an existing fieldSetField.
/// </summary>
/// <param name="fieldSetField">The 'FieldSetField' to update.</param>
/// <returns></returns>
internal static SqlParameter[] CreateUpdateParameters(FieldSetField fieldSetField)
{
// Initial Values
SqlParameter[] parameters = new SqlParameter[5];
SqlParameter param = null;
// verify fieldSetFieldexists
if (fieldSetField != null)
{
// Create parameter for [FieldId]
param = new SqlParameter("@FieldId", fieldSetField.FieldId);
// set parameters[0]
parameters[0] = param;
// Create parameter for [FieldOrdinal]
param = new SqlParameter("@FieldOrdinal", fieldSetField.FieldOrdinal);
// set parameters[1]
parameters[1] = param;
// Create parameter for [FieldSetId]
param = new SqlParameter("@FieldSetId", fieldSetField.FieldSetId);
// set parameters[2]
parameters[2] = param;
// Create parameter for [OrderByDescending]
param = new SqlParameter("@OrderByDescending", fieldSetField.OrderByDescending);
// set parameters[3]
parameters[3] = param;
// Create parameter for [FieldSetFieldId]
param = new SqlParameter("@FieldSetFieldId", fieldSetField.FieldSetFieldId);
parameters[4] = param;
}
// return value
return(parameters);
}
/// <summary>
/// This method returns the Field Set Field View
/// </summary>
public static FieldSetField ConvertFieldSetFieldView(FieldSetFieldView fieldSetFieldView)
{
// initial value
FieldSetField field = null;
// If the fieldSetFieldView object exists
if (NullHelper.Exists(fieldSetFieldView))
{
// Create a new instance of a 'FieldSetField' object.
field = new FieldSetField();
// set each property
field.FieldId = fieldSetFieldView.FieldId;
field.FieldOrdinal = fieldSetFieldView.FieldOrdinal;
field.FieldSetId = fieldSetFieldView.FieldSetId;
field.OrderByDescending = fieldSetFieldView.OrderByDescending;
}
// return value
return(field);
}
/// <summary>
/// This method loads a collection of 'FieldSetField' objects.
/// from the dataTable.Rows object passed in.
/// </summary>
/// <param name='dataTable'>The 'DataTable.Rows' to load from.</param>
/// <returns>A FieldSetField Collection.</returns>
public static List <FieldSetField> LoadCollection(DataTable dataTable)
{
// Initial Value
List <FieldSetField> fieldSetFields = new List <FieldSetField>();
try
{
// Load Each row In DataTable
foreach (DataRow row in dataTable.Rows)
{
// Create 'FieldSetField' from rows
FieldSetField fieldSetField = Load(row);
// Add this object to collection
fieldSetFields.Add(fieldSetField);
}
}
catch
{
}
// return value
return(fieldSetFields);
}
/// <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 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);
}
/// <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 FetchAllFieldSetFieldsStoredProcedure CreateFetchAllFieldSetFieldsStoredProcedure(FieldSetField fieldSetField)
{
// Initial value
FetchAllFieldSetFieldsStoredProcedure fetchAllFieldSetFieldsStoredProcedure = new FetchAllFieldSetFieldsStoredProcedure();
// return value
return(fetchAllFieldSetFieldsStoredProcedure);
}
/// <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 FindFieldSetFieldStoredProcedure CreateFindFieldSetFieldStoredProcedure(FieldSetField fieldSetField)
{
// Initial Value
FindFieldSetFieldStoredProcedure findFieldSetFieldStoredProcedure = null;
// verify fieldSetField exists
if (fieldSetField != null)
{
// Instanciate findFieldSetFieldStoredProcedure
findFieldSetFieldStoredProcedure = new FindFieldSetFieldStoredProcedure();
// Now create parameters for this procedure
findFieldSetFieldStoredProcedure.Parameters = CreatePrimaryKeyParameter(fieldSetField);
}
// return value
return(findFieldSetFieldStoredProcedure);
}
/// <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 DeleteFieldSetFieldStoredProcedure CreateDeleteFieldSetFieldStoredProcedure(FieldSetField fieldSetField)
{
// Initial Value
DeleteFieldSetFieldStoredProcedure deleteFieldSetFieldStoredProcedure = new DeleteFieldSetFieldStoredProcedure();
// Now Create Parameters For The DeleteProc
deleteFieldSetFieldStoredProcedure.Parameters = CreatePrimaryKeyParameter(fieldSetField);
// return value
return(deleteFieldSetFieldStoredProcedure);
}
/// <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 an
/// 'UpdateFieldSetFieldStoredProcedure' object and
/// creates the sql parameter[] array needed
/// to execute the procedure 'FieldSetField_Update'.
/// </summary>
/// <param name="fieldSetField"The 'FieldSetField' object to update</param>
/// <returns>An instance of a 'UpdateFieldSetFieldStoredProcedure</returns>
public static UpdateFieldSetFieldStoredProcedure CreateUpdateFieldSetFieldStoredProcedure(FieldSetField fieldSetField)
{
// Initial Value
UpdateFieldSetFieldStoredProcedure updateFieldSetFieldStoredProcedure = null;
// verify fieldSetField exists
if (fieldSetField != null)
{
// Instanciate updateFieldSetFieldStoredProcedure
updateFieldSetFieldStoredProcedure = new UpdateFieldSetFieldStoredProcedure();
// Now create parameters for this procedure
updateFieldSetFieldStoredProcedure.Parameters = CreateUpdateParameters(fieldSetField);
}
// return value
return(updateFieldSetFieldStoredProcedure);
}
