D:\NorthwindForWeb\Northwind\CS\DotNet\ADO.Net\Northwind\WebControls\ComboBoxManagerBase.cs
/*
* This file was generated by ProCG version 2.0
*
* File name: Northwind\WebControls\ComboBoxManagerBase.cs
* Language: C# - ADO.Net
* Database: My Sql
*
* Copyright (c) 2002-2019 iGenXSoft.
* For more information visit http://www.igenxsoft.com
*/
using System;
using System.Collections;
using System.Web.UI.WebControls;
using System.Data;
using Northwind.General;
using Northwind.Data;
#if (USE_DATA_MANAGER_REMOTE)
using Northwind.DataManagementRemote;
#endif // if (USE_DATA_MANAGER_REMOTE)
namespace Northwind.WebControls
{
/// Summary description for ComboBoxManagerBase.
public abstract class ComboBoxManagerBase : IDisposable
{
static protected ComboBoxManagerBase m_ComboBoxManagerBase = null;
protected DataManager m_DataManager = null;
protected bool m_bDataManagerWasCreatedByMe = false;
private bool disposed = false;
protected string m_EmptyOptionText = "";
protected bool m_NeedToAddExtraOption = true;
#if (USE_DATA_MANAGER_REMOTE)
protected DataManagerRemote m_DataManagerRemote = null;
#endif // if (USE_DATA_MANAGER_REMOTE)
public ComboBoxManagerBase()
{
}
public ComboBoxManagerBase(DataManager dataManager)
{
m_DataManager = dataManager;
m_bDataManagerWasCreatedByMe = false;
}
#if (USE_DATA_MANAGER_REMOTE)
public ComboBoxManagerBase(DataManagerRemote dataManagerRemote)
{
m_DataManagerRemote = dataManagerRemote;
}
#endif // if (USE_DATA_MANAGER_REMOTE)
// This destructor will run only if the Dispose method
// does not get called.
// It gives your base class the opportunity to finalize.
~ComboBoxManagerBase()
{
// Do not re-create Dispose clean-up code here.
// Calling Dispose(false) is optimal in terms of
// readability and maintainability.
Dispose(false);
}
public string EmptyOptionText
{
get { return m_EmptyOptionText; }
set { m_EmptyOptionText = value; }
}
public bool NeedToAddExtraOption
{
get { return m_NeedToAddExtraOption; }
set { m_NeedToAddExtraOption = value; }
}
public DataManager DataManager
{
get
{
if (m_DataManager == null)
{
m_DataManager = new DataManager();
m_bDataManagerWasCreatedByMe = true;
}
return m_DataManager;
}
set
{
m_DataManager = value;
}
}
//
// Table CCodes
// AnlRecord.CodeFieldIndex = 2
public virtual void SetDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, CCodesCollection codesCollection, bool needToAddExtraOption, string extraOptionText = null)
{
CCodesCollection tempCodesCollection = codesCollection;
if (needToAddExtraOption)
{
tempCodesCollection = (CCodesCollection)codesCollection.CloneForReadOnly();
CCodes codes = tempCodesCollection.InsertNewCodes(0);
if (extraOptionText == null)
codes.Description = EmptyOptionText;
else
codes.Description = extraOptionText;
}
dropDownList.DataValueField = "CodeNum";
dropDownList.DataTextField = "Description";
dropDownList.DataSource = tempCodesCollection;
try
{
if (dropDownList.Visible) // indication that it is inside databind event
dropDownList.DataBind();
}
catch (Exception ex)
{
dropDownList.SelectedIndex = -1;
}
}
// Table CCodes
// Access Method CodesByTableNum
public virtual void SetCodesByTableNumDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList,short tableNum, bool needToAddExtraOption)
{
CCodesCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.CodesRecord.GetCodesByTableNumCollection(tableNum);
else
collection = m_DataManagerRemote.GetCodesByTableNumCollection(tableNum);
#else
collection = DataManager.CodesRecord.GetCodesByTableNumCollection(tableNum);
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
// Table CCodes
// Access Method CodesTables
public virtual void SetCodesTablesDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, bool needToAddExtraOption)
{
CCodesCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.CodesRecord.GetCodesTablesCollection();
else
collection = m_DataManagerRemote.GetCodesTablesCollection();
#else
collection = DataManager.CodesRecord.GetCodesTablesCollection();
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
// Table CCodes
// Access Method AllCodes
public virtual void SetAllCodesDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, bool needToAddExtraOption)
{
CCodesCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.CodesRecord.GetAllCodesCollection();
else
collection = m_DataManagerRemote.GetAllCodesCollection();
#else
collection = DataManager.CodesRecord.GetAllCodesCollection();
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
//
// Table CCriteriaDefinition
// AnlRecord.CodeFieldIndex = 1
public virtual void SetDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, CCriteriaDefinitionCollection criteriaDefinitionCollection, bool needToAddExtraOption, string extraOptionText = null)
{
CCriteriaDefinitionCollection tempCriteriaDefinitionCollection = criteriaDefinitionCollection;
if (needToAddExtraOption)
{
tempCriteriaDefinitionCollection = new CCriteriaDefinitionCollection(criteriaDefinitionCollection);
CCriteriaDefinition criteriaDefinition = tempCriteriaDefinitionCollection.InsertNewCriteriaDefinition(0);
if (extraOptionText == null)
criteriaDefinition.Name = EmptyOptionText;
else
criteriaDefinition.Name = extraOptionText;
}
dropDownList.DataValueField = "Id";
dropDownList.DataTextField = "Name";
dropDownList.DataSource = tempCriteriaDefinitionCollection;
try
{
if (dropDownList.Visible) // indication that it is inside databind event
dropDownList.DataBind();
}
catch (Exception ex)
{
dropDownList.SelectedIndex = -1;
}
}
// Table CCriteriaDefinition
// Access Method CriteriaDefinitionsByUserIdRecordNum
public virtual void SetCriteriaDefinitionsByUserIdRecordNumDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList,int userId,int recordNum, bool needToAddExtraOption)
{
CCriteriaDefinitionCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.CriteriaDefinitionRecord.GetCriteriaDefinitionsByUserIdRecordNumCollection(userId, recordNum);
else
collection = m_DataManagerRemote.GetCriteriaDefinitionsByUserIdRecordNumCollection(userId, recordNum);
#else
collection = DataManager.CriteriaDefinitionRecord.GetCriteriaDefinitionsByUserIdRecordNumCollection(userId, recordNum);
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
//
// Table CNorthwindUser
// AnlRecord.CodeFieldIndex = 1
public virtual void SetDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, CNorthwindUserCollection northwindUserCollection, bool needToAddExtraOption, string extraOptionText = null)
{
CNorthwindUserCollection tempNorthwindUserCollection = northwindUserCollection;
if (needToAddExtraOption)
{
tempNorthwindUserCollection = new CNorthwindUserCollection(northwindUserCollection);
CNorthwindUser northwindUser = tempNorthwindUserCollection.InsertNewNorthwindUser(0);
if (extraOptionText == null)
northwindUser.FullName = EmptyOptionText;
else
northwindUser.FullName = extraOptionText;
}
dropDownList.DataValueField = "Id";
dropDownList.DataTextField = "FullName";
dropDownList.DataSource = tempNorthwindUserCollection;
try
{
if (dropDownList.Visible) // indication that it is inside databind event
dropDownList.DataBind();
}
catch (Exception ex)
{
dropDownList.SelectedIndex = -1;
}
}
// Table CNorthwindUser
// Access Method AllUsers
public virtual void SetAllUsersDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, bool needToAddExtraOption)
{
CNorthwindUserCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.NorthwindUserRecord.GetAllUsersCollection();
else
collection = m_DataManagerRemote.GetAllUsersCollection();
#else
collection = DataManager.NorthwindUserRecord.GetAllUsersCollection();
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
//
// Table CSupplier
// AnlRecord.CodeFieldIndex = 1
public virtual void SetDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, CSupplierCollection supplierCollection, bool needToAddExtraOption, string extraOptionText = null)
{
CSupplierCollection tempSupplierCollection = supplierCollection;
if (needToAddExtraOption)
{
tempSupplierCollection = new CSupplierCollection(supplierCollection);
CSupplier supplier = tempSupplierCollection.InsertNewSupplier(0);
if (extraOptionText == null)
supplier.CompanyName = EmptyOptionText;
else
supplier.CompanyName = extraOptionText;
}
dropDownList.DataValueField = "Id";
dropDownList.DataTextField = "CompanyName";
dropDownList.DataSource = tempSupplierCollection;
try
{
if (dropDownList.Visible) // indication that it is inside databind event
dropDownList.DataBind();
}
catch (Exception ex)
{
dropDownList.SelectedIndex = -1;
}
}
// Table CSupplier
// Access Method AllSuppliers
public virtual void SetAllSuppliersDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, bool needToAddExtraOption)
{
CSupplierCollection collection;
#if (USE_DATA_MANAGER_REMOTE)
if (m_DataManager != null)
collection = m_DataManager.SupplierRecord.GetAllSuppliersCollection();
else
collection = m_DataManagerRemote.GetAllSuppliersCollection();
#else
collection = DataManager.SupplierRecord.GetAllSuppliersCollection();
#endif // if (USE_DATA_MANAGER_REMOTE)
SetDropDownListInfo(dropDownList,collection,needToAddExtraOption);
}
//
// Table CTestTable
// AnlRecord.CodeFieldIndex = 1
public virtual void SetDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList, CTestTableCollection testTableCollection, bool needToAddExtraOption, string extraOptionText = null)
{
CTestTableCollection tempTestTableCollection = testTableCollection;
if (needToAddExtraOption)
{
tempTestTableCollection = new CTestTableCollection(testTableCollection);
CTestTable testTable = tempTestTableCollection.InsertNewTestTable(0);
if (extraOptionText == null)
testTable.Name = EmptyOptionText;
else
testTable.Name = extraOptionText;
}
dropDownList.DataValueField = "Id";
dropDownList.DataTextField = "Name";
dropDownList.DataSource = tempTestTableCollection;
try
{
if (dropDownList.Visible) // indication that it is inside databind event
dropDownList.DataBind();
}
catch (Exception ex)
{
dropDownList.SelectedIndex = -1;
}
}
public virtual void SetTabControlThemeDropDownListInfo(System.Web.UI.WebControls.DropDownList dropDownList)
{
dropDownList.Items.Clear();
dropDownList.Items.Add(new ListItem("XP", "ajax__tab_xp-theme"));
dropDownList.Items.Add(new ListItem("IE", "ajax__tab_ie-theme"));
dropDownList.Items.Add(new ListItem("Yahoo", "ajax__tab_yuitabview-theme"));
dropDownList.Items.Add(new ListItem("Technorati", "ajax__tab_technorati-theme"));
dropDownList.Items.Add(new ListItem("MSN", "ajax__tab_msngallery-theme"));
}
#region IDisposable Members
// Implement IDisposable.
// Do not make this method virtual.
// A derived class should not be able to override this method.
public void Dispose()
{
Dispose(true);
// This object will be cleaned up by the Dispose method.
// Therefore, you should call GC.SupressFinalize to
// take this object off the finalization queue
// and prevent finalization code for this object
// from executing a second time.
GC.SuppressFinalize(this);
}
// Dispose(bool disposing) executes in two distinct scenarios.
// If disposing equals true, the method has been called directly
// or indirectly by a user's code. Managed and unmanaged resources
// can be disposed.
// If disposing equals false, the method has been called by the
// runtime from inside the finalizer and you should not reference
// other objects. Only unmanaged resources can be disposed.
private void Dispose(bool disposing)
{
// Check to see if Dispose has already been called.
if(!this.disposed)
{
// If disposing equals true, dispose all managed
// and unmanaged resources.
if(disposing)
{
if (m_DataManager != null)
{
if (m_bDataManagerWasCreatedByMe)
{
m_DataManager.Dispose();
m_DataManager = null;
}
}
m_ComboBoxManagerBase = null;
}
}
disposed = true;
}
#endregion
}
}
// 12899 ProCG uses this line - don't edit it