/// <summary> /// This method deletes a 'Enumeration' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Enumeration' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject DeleteEnumeration(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 DeleteEnumerationStoredProcedure deleteEnumerationProc = null; // verify the first parameters is a(n) 'Enumeration'. if (parameters[0].ObjectValue as Enumeration != null) { // Create Enumeration Enumeration enumeration = (Enumeration)parameters[0].ObjectValue; // verify enumeration exists if (enumeration != null) { // Now create deleteEnumerationProc from EnumerationWriter // The DataWriter converts the 'Enumeration' // to the SqlParameter[] array needed to delete a 'Enumeration'. deleteEnumerationProc = EnumerationWriter.CreateDeleteEnumerationStoredProcedure(enumeration); } } // Verify deleteEnumerationProc exists if (deleteEnumerationProc != null) { // Execute Delete Stored Procedure bool deleted = this.DataManager.EnumerationManager.DeleteEnumeration(deleteEnumerationProc, 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 'NotificationHistory' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'NotificationHistory' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindNotificationHistory(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals NotificationHistory notificationHistory = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindNotificationHistoryStoredProcedure findNotificationHistoryProc = null; // verify the first parameters is a 'NotificationHistory'. if (parameters[0].ObjectValue as NotificationHistory != null) { // Get NotificationHistoryParameter NotificationHistory paramNotificationHistory = (NotificationHistory)parameters[0].ObjectValue; // verify paramNotificationHistory exists if (paramNotificationHistory != null) { // Now create findNotificationHistoryProc from NotificationHistoryWriter // The DataWriter converts the 'NotificationHistory' // to the SqlParameter[] array needed to find a 'NotificationHistory'. findNotificationHistoryProc = NotificationHistoryWriter.CreateFindNotificationHistoryStoredProcedure(paramNotificationHistory); } // Verify findNotificationHistoryProc exists if (findNotificationHistoryProc != null) { // Execute Find Stored Procedure notificationHistory = this.DataManager.NotificationHistoryManager.FindNotificationHistory(findNotificationHistoryProc, dataConnector); // if dataObject exists if (notificationHistory != null) { // set returnObject.ObjectValue returnObject.ObjectValue = notificationHistory; } } } 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 'RawImport' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'RawImport' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindRawImport(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals RawImport rawImport = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindRawImportStoredProcedure findRawImportProc = null; // verify the first parameters is a 'RawImport'. if (parameters[0].ObjectValue as RawImport != null) { // Get RawImportParameter RawImport paramRawImport = (RawImport)parameters[0].ObjectValue; // verify paramRawImport exists if (paramRawImport != null) { // Now create findRawImportProc from RawImportWriter // The DataWriter converts the 'RawImport' // to the SqlParameter[] array needed to find a 'RawImport'. findRawImportProc = RawImportWriter.CreateFindRawImportStoredProcedure(paramRawImport); } // Verify findRawImportProc exists if (findRawImportProc != null) { // Execute Find Stored Procedure rawImport = this.DataManager.RawImportManager.FindRawImport(findRawImportProc, dataConnector); // if dataObject exists if (rawImport != null) { // set returnObject.ObjectValue returnObject.ObjectValue = rawImport; } } } 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 'Adverb' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Adverb' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindAdverb(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Adverb adverb = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindAdverbStoredProcedure findAdverbProc = null; // verify the first parameters is a 'Adverb'. if (parameters[0].ObjectValue as Adverb != null) { // Get AdverbParameter Adverb paramAdverb = (Adverb)parameters[0].ObjectValue; // verify paramAdverb exists if (paramAdverb != null) { // Now create findAdverbProc from AdverbWriter // The DataWriter converts the 'Adverb' // to the SqlParameter[] array needed to find a 'Adverb'. findAdverbProc = AdverbWriter.CreateFindAdverbStoredProcedure(paramAdverb); } // Verify findAdverbProc exists if (findAdverbProc != null) { // Execute Find Stored Procedure adverb = this.DataManager.AdverbManager.FindAdverb(findAdverbProc, dataConnector); // if dataObject exists if (adverb != null) { // set returnObject.ObjectValue returnObject.ObjectValue = adverb; } } } 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 'Method' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Method' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindMethod(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Method method = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindMethodStoredProcedure findMethodProc = null; // verify the first parameters is a 'Method'. if (parameters[0].ObjectValue as Method != null) { // Get MethodParameter Method paramMethod = (Method)parameters[0].ObjectValue; // verify paramMethod exists if (paramMethod != null) { // Now create findMethodProc from MethodWriter // The DataWriter converts the 'Method' // to the SqlParameter[] array needed to find a 'Method'. findMethodProc = MethodWriter.CreateFindMethodStoredProcedure(paramMethod); } // Verify findMethodProc exists if (findMethodProc != null) { // Execute Find Stored Procedure method = this.DataManager.MethodManager.FindMethod(findMethodProc, dataConnector); // if dataObject exists if (method != null) { // set returnObject.ObjectValue returnObject.ObjectValue = method; } } } 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 'FirstName' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'FirstName' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindFirstName(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals FirstName firstName = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindFirstNameStoredProcedure findFirstNameProc = null; // verify the first parameters is a 'FirstName'. if (parameters[0].ObjectValue as FirstName != null) { // Get FirstNameParameter FirstName paramFirstName = (FirstName)parameters[0].ObjectValue; // verify paramFirstName exists if (paramFirstName != null) { // Now create findFirstNameProc from FirstNameWriter // The DataWriter converts the 'FirstName' // to the SqlParameter[] array needed to find a 'FirstName'. findFirstNameProc = FirstNameWriter.CreateFindFirstNameStoredProcedure(paramFirstName); } // Verify findFirstNameProc exists if (findFirstNameProc != null) { // Execute Find Stored Procedure firstName = this.DataManager.FirstNameManager.FindFirstName(findFirstNameProc, dataConnector); // if dataObject exists if (firstName != null) { // set returnObject.ObjectValue returnObject.ObjectValue = firstName; } } } 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 'Enumeration' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Enumeration' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindEnumeration(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Enumeration enumeration = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindEnumerationStoredProcedure findEnumerationProc = null; // verify the first parameters is a 'Enumeration'. if (parameters[0].ObjectValue as Enumeration != null) { // Get EnumerationParameter Enumeration paramEnumeration = (Enumeration)parameters[0].ObjectValue; // verify paramEnumeration exists if (paramEnumeration != null) { // Now create findEnumerationProc from EnumerationWriter // The DataWriter converts the 'Enumeration' // to the SqlParameter[] array needed to find a 'Enumeration'. findEnumerationProc = EnumerationWriter.CreateFindEnumerationStoredProcedure(paramEnumeration); } // Verify findEnumerationProc exists if (findEnumerationProc != null) { // Execute Find Stored Procedure enumeration = this.DataManager.EnumerationManager.FindEnumeration(findEnumerationProc, dataConnector); // if dataObject exists if (enumeration != null) { // set returnObject.ObjectValue returnObject.ObjectValue = enumeration; } } } 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 'ToDo' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'ToDo' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindToDo(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals ToDo toDo = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindToDoStoredProcedure findToDoProc = null; // verify the first parameters is a 'ToDo'. if (parameters[0].ObjectValue as ToDo != null) { // Get ToDoParameter ToDo paramToDo = (ToDo)parameters[0].ObjectValue; // verify paramToDo exists if (paramToDo != null) { // Now create findToDoProc from ToDoWriter // The DataWriter converts the 'ToDo' // to the SqlParameter[] array needed to find a 'ToDo'. findToDoProc = ToDoWriter.CreateFindToDoStoredProcedure(paramToDo); } // Verify findToDoProc exists if (findToDoProc != null) { // Execute Find Stored Procedure toDo = this.DataManager.ToDoManager.FindToDo(findToDoProc, dataConnector); // if dataObject exists if (toDo != null) { // set returnObject.ObjectValue returnObject.ObjectValue = toDo; } } } 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 'CustomReader' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'CustomReader' to delete. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject FindCustomReader(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals CustomReader customReader = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Find StoredProcedure FindCustomReaderStoredProcedure findCustomReaderProc = null; // verify the first parameters is a 'CustomReader'. if (parameters[0].ObjectValue as CustomReader != null) { // Get CustomReaderParameter CustomReader paramCustomReader = (CustomReader)parameters[0].ObjectValue; // verify paramCustomReader exists if (paramCustomReader != null) { // Now create findCustomReaderProc from CustomReaderWriter // The DataWriter converts the 'CustomReader' // to the SqlParameter[] array needed to find a 'CustomReader'. findCustomReaderProc = CustomReaderWriter.CreateFindCustomReaderStoredProcedure(paramCustomReader); } // Verify findCustomReaderProc exists if (findCustomReaderProc != null) { // Execute Find Stored Procedure customReader = this.DataManager.CustomReaderManager.FindCustomReader(findCustomReaderProc, dataConnector); // if dataObject exists if (customReader != null) { // set returnObject.ObjectValue returnObject.ObjectValue = customReader; } } } 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 'CustomReader' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'CustomReader' to delete. /// <returns>A PolymorphicObject object with all 'CustomReaders' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <CustomReader> customReaderListCollection = null; // Create FetchAll StoredProcedure FetchAllCustomReadersStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get CustomReaderParameter // Declare Parameter CustomReader paramCustomReader = null; // verify the first parameters is a(n) 'CustomReader'. if (parameters[0].ObjectValue as CustomReader != null) { // Get CustomReaderParameter paramCustomReader = (CustomReader)parameters[0].ObjectValue; } // Now create FetchAllCustomReadersProc from CustomReaderWriter fetchAllProc = CustomReaderWriter.CreateFetchAllCustomReadersStoredProcedure(paramCustomReader); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure customReaderListCollection = this.DataManager.CustomReaderManager.FetchAllCustomReaders(fetchAllProc, dataConnector); // if dataObjectCollection exists if (customReaderListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = customReaderListCollection; } } 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 'RawImport' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'RawImport' to delete. /// <returns>A PolymorphicObject object with all 'RawImports' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <RawImport> rawImportListCollection = null; // Create FetchAll StoredProcedure FetchAllRawImportsStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get RawImportParameter // Declare Parameter RawImport paramRawImport = null; // verify the first parameters is a(n) 'RawImport'. if (parameters[0].ObjectValue as RawImport != null) { // Get RawImportParameter paramRawImport = (RawImport)parameters[0].ObjectValue; } // Now create FetchAllRawImportsProc from RawImportWriter fetchAllProc = RawImportWriter.CreateFetchAllRawImportsStoredProcedure(paramRawImport); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure rawImportListCollection = this.DataManager.RawImportManager.FetchAllRawImports(fetchAllProc, dataConnector); // if dataObjectCollection exists if (rawImportListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = rawImportListCollection; } } 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 'ToDo' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'ToDo' to delete. /// <returns>A PolymorphicObject object with all 'ToDos' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <ToDo> toDoListCollection = null; // Create FetchAll StoredProcedure FetchAllToDosStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get ToDoParameter // Declare Parameter ToDo paramToDo = null; // verify the first parameters is a(n) 'ToDo'. if (parameters[0].ObjectValue as ToDo != null) { // Get ToDoParameter paramToDo = (ToDo)parameters[0].ObjectValue; } // Now create FetchAllToDosProc from ToDoWriter fetchAllProc = ToDoWriter.CreateFetchAllToDosStoredProcedure(paramToDo); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure toDoListCollection = this.DataManager.ToDoManager.FetchAllToDos(fetchAllProc, dataConnector); // if dataObjectCollection exists if (toDoListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = toDoListCollection; } } 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 'NotificationHistory' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'NotificationHistory' to delete. /// <returns>A PolymorphicObject object with all 'NotificationHistorys' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <NotificationHistory> notificationHistoryListCollection = null; // Create FetchAll StoredProcedure FetchAllNotificationHistorysStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get NotificationHistoryParameter // Declare Parameter NotificationHistory paramNotificationHistory = null; // verify the first parameters is a(n) 'NotificationHistory'. if (parameters[0].ObjectValue as NotificationHistory != null) { // Get NotificationHistoryParameter paramNotificationHistory = (NotificationHistory)parameters[0].ObjectValue; } // Now create FetchAllNotificationHistorysProc from NotificationHistoryWriter fetchAllProc = NotificationHistoryWriter.CreateFetchAllNotificationHistorysStoredProcedure(paramNotificationHistory); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure notificationHistoryListCollection = this.DataManager.NotificationHistoryManager.FetchAllNotificationHistorys(fetchAllProc, dataConnector); // if dataObjectCollection exists if (notificationHistoryListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = notificationHistoryListCollection; } } 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 'FirstName' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'FirstName' to delete. /// <returns>A PolymorphicObject object with all 'FirstNames' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <FirstName> firstNameListCollection = null; // Create FetchAll StoredProcedure FetchAllFirstNamesStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get FirstNameParameter // Declare Parameter FirstName paramFirstName = null; // verify the first parameters is a(n) 'FirstName'. if (parameters[0].ObjectValue as FirstName != null) { // Get FirstNameParameter paramFirstName = (FirstName)parameters[0].ObjectValue; } // Now create FetchAllFirstNamesProc from FirstNameWriter fetchAllProc = FirstNameWriter.CreateFetchAllFirstNamesStoredProcedure(paramFirstName); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure firstNameListCollection = this.DataManager.FirstNameManager.FetchAllFirstNames(fetchAllProc, dataConnector); // if dataObjectCollection exists if (firstNameListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = firstNameListCollection; } } 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 'Enumeration' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Enumeration' to delete. /// <returns>A PolymorphicObject object with all 'Enumerations' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <Enumeration> enumerationListCollection = null; // Create FetchAll StoredProcedure FetchAllEnumerationsStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get EnumerationParameter // Declare Parameter Enumeration paramEnumeration = null; // verify the first parameters is a(n) 'Enumeration'. if (parameters[0].ObjectValue as Enumeration != null) { // Get EnumerationParameter paramEnumeration = (Enumeration)parameters[0].ObjectValue; } // Now create FetchAllEnumerationsProc from EnumerationWriter fetchAllProc = EnumerationWriter.CreateFetchAllEnumerationsStoredProcedure(paramEnumeration); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure enumerationListCollection = this.DataManager.EnumerationManager.FetchAllEnumerations(fetchAllProc, dataConnector); // if dataObjectCollection exists if (enumerationListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = enumerationListCollection; } } 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 'Method' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Method' to delete. /// <returns>A PolymorphicObject object with all 'Methods' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <Method> methodListCollection = null; // Create FetchAll StoredProcedure FetchAllMethodsStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get MethodParameter // Declare Parameter Method paramMethod = null; // verify the first parameters is a(n) 'Method'. if (parameters[0].ObjectValue as Method != null) { // Get MethodParameter paramMethod = (Method)parameters[0].ObjectValue; } // Now create FetchAllMethodsProc from MethodWriter fetchAllProc = MethodWriter.CreateFetchAllMethodsStoredProcedure(paramMethod); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure methodListCollection = this.DataManager.MethodManager.FetchAllMethods(fetchAllProc, dataConnector); // if dataObjectCollection exists if (methodListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = methodListCollection; } } 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 'Adverb' objects. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Adverb' to delete. /// <returns>A PolymorphicObject object with all 'Adverbs' objects. internal PolymorphicObject FetchAll(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals List <Adverb> adverbListCollection = null; // Create FetchAll StoredProcedure FetchAllAdverbsStoredProcedure fetchAllProc = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Get AdverbParameter // Declare Parameter Adverb paramAdverb = null; // verify the first parameters is a(n) 'Adverb'. if (parameters[0].ObjectValue as Adverb != null) { // Get AdverbParameter paramAdverb = (Adverb)parameters[0].ObjectValue; } // Now create FetchAllAdverbsProc from AdverbWriter fetchAllProc = AdverbWriter.CreateFetchAllAdverbsStoredProcedure(paramAdverb); } // Verify fetchAllProc exists if (fetchAllProc != null) { // Execute FetchAll Stored Procedure adverbListCollection = this.DataManager.AdverbManager.FetchAllAdverbs(fetchAllProc, dataConnector); // if dataObjectCollection exists if (adverbListCollection != null) { // set returnObject.ObjectValue returnObject.ObjectValue = adverbListCollection; } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } // return value return(returnObject); }
/// <summary> /// This method inserts a 'UIField' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'UIField' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertUIField(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals UIField uIField = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertUIFieldStoredProcedure insertUIFieldProc = null; // verify the first parameters is a(n) 'UIField'. if (parameters[0].ObjectValue as UIField != null) { // Create UIField Parameter uIField = (UIField)parameters[0].ObjectValue; // verify uIField exists if (uIField != null) { // Now create insertUIFieldProc from UIFieldWriter // The DataWriter converts the 'UIField' // to the SqlParameter[] array needed to insert a 'UIField'. insertUIFieldProc = UIFieldWriter.CreateInsertUIFieldStoredProcedure(uIField); } // Verify insertUIFieldProc exists if (insertUIFieldProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.UIFieldManager.InsertUIField(insertUIFieldProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// This method inserts a 'Member' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Member' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertMember(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Member member = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertMemberStoredProcedure insertMemberProc = null; // verify the first parameters is a(n) 'Member'. if (parameters[0].ObjectValue as Member != null) { // Create Member Parameter member = (Member)parameters[0].ObjectValue; // verify member exists if (member != null) { // Now create insertMemberProc from MemberWriter // The DataWriter converts the 'Member' // to the SqlParameter[] array needed to insert a 'Member'. insertMemberProc = MemberWriter.CreateInsertMemberStoredProcedure(member); } // Verify insertMemberProc exists if (insertMemberProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.MemberManager.InsertMember(insertMemberProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// This method inserts a 'StreetName' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'StreetName' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertStreetName(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals StreetName streetName = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertStreetNameStoredProcedure insertStreetNameProc = null; // verify the first parameters is a(n) 'StreetName'. if (parameters[0].ObjectValue as StreetName != null) { // Create StreetName Parameter streetName = (StreetName)parameters[0].ObjectValue; // verify streetName exists if (streetName != null) { // Now create insertStreetNameProc from StreetNameWriter // The DataWriter converts the 'StreetName' // to the SqlParameter[] array needed to insert a 'StreetName'. insertStreetNameProc = StreetNameWriter.CreateInsertStreetNameStoredProcedure(streetName); } // Verify insertStreetNameProc exists if (insertStreetNameProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.StreetNameManager.InsertStreetName(insertStreetNameProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// This method inserts a 'Artist' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Artist' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertArtist(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Artist artist = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertArtistStoredProcedure insertArtistProc = null; // verify the first parameters is a(n) 'Artist'. if (parameters[0].ObjectValue as Artist != null) { // Create Artist Parameter artist = (Artist)parameters[0].ObjectValue; // verify artist exists if (artist != null) { // Now create insertArtistProc from ArtistWriter // The DataWriter converts the 'Artist' // to the SqlParameter[] array needed to insert a 'Artist'. insertArtistProc = ArtistWriter.CreateInsertArtistStoredProcedure(artist); } // Verify insertArtistProc exists if (insertArtistProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.ArtistManager.InsertArtist(insertArtistProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// This method inserts a 'Notification' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Notification' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertNotification(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Notification notification = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertNotificationStoredProcedure insertNotificationProc = null; // verify the first parameters is a(n) 'Notification'. if (parameters[0].ObjectValue as Notification != null) { // Create Notification Parameter notification = (Notification)parameters[0].ObjectValue; // verify notification exists if (notification != null) { // Now create insertNotificationProc from NotificationWriter // The DataWriter converts the 'Notification' // to the SqlParameter[] array needed to insert a 'Notification'. insertNotificationProc = NotificationWriter.CreateInsertNotificationStoredProcedure(notification); } // Verify insertNotificationProc exists if (insertNotificationProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.NotificationManager.InsertNotification(insertNotificationProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// This method inserts a 'Verb' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'Verb' to insert. /// <returns>A PolymorphicObject object with a Boolean value. internal PolymorphicObject InsertVerb(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals Verb verb = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Insert StoredProcedure InsertVerbStoredProcedure insertVerbProc = null; // verify the first parameters is a(n) 'Verb'. if (parameters[0].ObjectValue as Verb != null) { // Create Verb Parameter verb = (Verb)parameters[0].ObjectValue; // verify verb exists if (verb != null) { // Now create insertVerbProc from VerbWriter // The DataWriter converts the 'Verb' // to the SqlParameter[] array needed to insert a 'Verb'. insertVerbProc = VerbWriter.CreateInsertVerbStoredProcedure(verb); } // Verify insertVerbProc exists if (insertVerbProc != null) { // Execute Insert Stored Procedure returnObject.IntegerValue = this.DataManager.VerbManager.InsertVerb(insertVerbProc, dataConnector); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } // return value return(returnObject); }
/// <summary> /// Tests the connection to the database /// </summary> internal PolymorphicObject TestDataConnection(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // Create returnObject.Boolean returnObject.Boolean = new NullableBoolean(); // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Set Boolean To True returnObject.Boolean.Value = NullableBooleanEnum.True; } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } // return value return(returnObject); }
/// <summary> /// This method updates a 'FirstName' object. /// </summary> /// <param name='List<PolymorphicObject>'>The 'FirstName' to update. /// <returns>A PolymorphicObject object with a value. internal PolymorphicObject UpdateFirstName(List <PolymorphicObject> parameters, DataConnector dataConnector) { // Initial Value PolymorphicObject returnObject = new PolymorphicObject(); // locals FirstName firstName = null; // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create Update StoredProcedure UpdateFirstNameStoredProcedure updateFirstNameProc = null; // verify the first parameters is a(n) 'FirstName'. if (parameters[0].ObjectValue as FirstName != null) { // Create FirstName Parameter firstName = (FirstName)parameters[0].ObjectValue; // verify firstName exists if (firstName != null) { // Now create updateFirstNameProc from FirstNameWriter // The DataWriter converts the 'FirstName' // to the SqlParameter[] array needed to update a 'FirstName'. updateFirstNameProc = FirstNameWriter.CreateUpdateFirstNameStoredProcedure(firstName); } // Verify updateFirstNameProc exists if (updateFirstNameProc != null) { // Execute Update Stored Procedure bool saved = this.DataManager.FirstNameManager.UpdateFirstName(updateFirstNameProc, dataConnector); // Create returnObject.Boolean returnObject.Boolean = new NullableBoolean(); // If save was successful if (saved) { // 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 is used to execute a query that does not return a value. /// To call this method, you must set following: /// </summary> /// <param name="parameters">The parameters must be set to call this method. /// 1. 'ProcedureName' - The String value must be set for this parameter. /// 2. 'SqlParameters' (Optional) - If the stored procedure to be called requires parameters /// then you must pass in the SqlParameters[] array as this parameter. /// It does not matter the order of these parameters. /// </param> /// <param name="dataConnector">The database connection to use to execute this procedure.</param> /// A successful will call will set returnValue.Boolean to true (executed) /// In the event the procedure does not execute (returnValue.Boolean = false) /// check the following: /// returnValue.Name = 'Error" - Will be set to error /// returnValue.Text = Will be set to the Exception.ToString(); /// returnValue.Object = Will Contain the Exception that occurred. public PolymorphicObject ExecuteNonQuery(List <PolymorphicObject> parameters, DataConnector dataConnector) { // initial value PolymorphicObject returnValue = new PolymorphicObject(); // Set to false returnValue.Boolean = new NullableBoolean(false); // locals bool executed = false; try { // If the data connection is connected if ((dataConnector != null) && (dataConnector.Connected == true)) { // Create a StoredProcedure StoredProcedure storedProcedure = new StoredProcedure(); // Create a StoredProcedure object storedProcedure.ProcedureName = FindProcedureName(parameters); // Set the Parameters for the StoredProcedure storedProcedure.Parameters = FindSqlParameters(parameters); // if the ProcedureName is set if (!String.IsNullOrEmpty(storedProcedure.ProcedureName)) { // Create an instance of the DataHelper DataHelper dataHelper = new DataHelper(); // Perform an update executed = dataHelper.UpdateRecord(storedProcedure, dataConnector); // set the return value returnValue.Boolean = new NullableBoolean(executed); } } else { // Raise Error Data Connection Not Available throw new Exception("The database connection is not available."); } } catch (Exception error) { // for debugging only string err = error.ToString(); // Set the text of the returnValue.Name = "Error"; // Set the text for the returnValue returnValue.Text = err; // set the return value returnValue.ObjectValue = error; } // return value return(returnValue); }