/// <summary> /// Update the definintion for a PickList /// </summary> /// <param name="category"></param> /// <returns></returns> public int PickListUpdate(PickList aPickList) { if (isDebugEnabled) { logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in"); } if (compactDatabaseType) { try { using (SqlCeConnection conn = DatabaseConnection.CreateOpenCEConnection()) { string commandText = "UPDATE PICKLISTS SET " + "_NAME = @cName " + "WHERE " + "_PICKLISTID = @nPicklistID"; SqlCeParameter[] spParams = new SqlCeParameter[2]; spParams[0] = new SqlCeParameter("@nPicklistID", aPickList.PicklistID); spParams[1] = new SqlCeParameter("@cName", aPickList.Name); using (SqlCeCommand command = new SqlCeCommand(commandText, conn)) { command.Parameters.AddRange(spParams); command.ExecuteNonQuery(); } } } catch (SqlCeException ex) { Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine + "Please see the log file for further details."); logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex); } catch (Exception ex) { Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine + "Please see the log file for further details."); logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex); } } else { AuditWizardDataAccess lAuditWizardDataAccess = new AuditWizardDataAccess(); lAuditWizardDataAccess.PickListUpdate(aPickList); } if (isDebugEnabled) { logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out"); } return(0); }
/// <summary> /// Equality test - check to see if this instance matches another /// </summary> /// <param name="obj"></param> /// <returns></returns> public override bool Equals(object obj) { if (obj != null && obj.GetType().Equals(this.GetType())) { PickList other = obj as PickList; if ((object)other != null) { bool equality; equality = other.PicklistID == PicklistID && other.Name == Name; return(equality); } } return(base.Equals(obj)); }
/// <summary> /// Copy constructor /// </summary> /// <param name="other"></param> public PickList(PickList other) { _picklistID = other._picklistID; _name = other._name; }
/// <summary> /// Add a new PickList to the database /// </summary> /// <param name="theAlert"></param> /// <returns></returns> public int PickListAdd(PickList aPickList) { if (isDebugEnabled) { logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in"); } int lItemID = 0; if (compactDatabaseType) { try { using (SqlCeConnection conn = DatabaseConnection.CreateOpenCEConnection()) { string commandText = "INSERT INTO PICKLISTS " + "(_NAME ,_PARENTID) " + "VALUES " + "(@cName, @nParentID)"; SqlCeParameter[] spParams = new SqlCeParameter[2]; spParams[0] = new SqlCeParameter("@cName", aPickList.Name); spParams[1] = new SqlCeParameter("@nParentID", DBNull.Value); using (SqlCeCommand command = new SqlCeCommand(commandText, conn)) { command.Parameters.AddRange(spParams); command.ExecuteNonQuery(); } using (SqlCeCommand command = new SqlCeCommand("SELECT @@IDENTITY", conn)) { lItemID = Convert.ToInt32(command.ExecuteScalar()); } } } catch (SqlCeException ex) { Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine + "Please see the log file for further details."); logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex); } catch (Exception ex) { Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine + "Please see the log file for further details."); logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex); } } else { AuditWizardDataAccess lAuditWizardDataAccess = new AuditWizardDataAccess(); lItemID = lAuditWizardDataAccess.PickListAdd(aPickList); } if (isDebugEnabled) { logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out"); } return(lItemID); }