private void bindDropDownLists()
{
#region Bind Default Child Data
msPromotionRank.Items.Add(new ListItem("Null", "Null"));
DojoRankManager promotionRankManager = new DojoRankManager();
DojoRankCollection promotionRankCollection = promotionRankManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoRank promotionRank in promotionRankCollection)
{
ListItem i = new ListItem(promotionRank.ToString(), promotionRank.ID.ToString());
msPromotionRank.Items.Add(i);
}
#endregion
#region Bind Rappahanock Child Data
msItem.Items.Add(new ListItem("Null", "Null"));
RHItemManager itemManager = new RHItemManager();
RHItemCollection itemCollection = itemManager.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem item in itemCollection)
{
ListItem i = new ListItem(item.ToString(), item.ID.ToString());
msItem.Items.Add(i);
}
#endregion
}
private void bind()
{
#region Bind Default Child Data
DojoRankManager dojoRankManager = new DojoRankManager();
DojoRankCollection dojoRankCollection = dojoRankManager.GetCollection(string.Empty, string.Empty);
ddPromotionRank.Items.Add(new ListItem(" ", "null"));
foreach (DojoRank itemObject in dojoRankCollection)
ddPromotionRank.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString()));
#endregion
#region Bind Rappahanock Child Data
RHItemManager rHItemManager = new RHItemManager();
RHItemCollection rHItemCollection = rHItemManager.GetCollection(string.Empty, string.Empty);
ddItem.Items.Add(new ListItem(" ", "null"));
foreach (RHItem itemObject in rHItemCollection)
ddItem.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString()));
#endregion
}
private void bind()
{
#region Bind Default Child Data
string[] classUnitTypeNames;
byte[] classUnitTypeValues;
msOptions.Items.Clear();
DojoSeminarOptionManager optionsManager =
new DojoSeminarOptionManager();
DojoSeminarOptionCollection optionsCollection =
optionsManager.GetCollection(string.Empty, string.Empty);
foreach (DojoSeminarOption options in optionsCollection)
{
ListItem i = new ListItem(options.Name +
" (" + options.Fee.ToString("c") + ")", options.ID.ToString());
msOptions.Items.Add(i);
}
GreyFoxContactManager locationManager =
new GreyFoxContactManager("kitTessen_Locations");
GreyFoxContactCollection locationCollection =
locationManager.GetCollection(string.Empty, string.Empty);
foreach (GreyFoxContact location in locationCollection)
{
ComboBoxItem item = new ComboBoxItem();
item.Text = location.BusinessName;
item.Value = location.ID.ToString();
comboLocation.Items.Add(item);
}
RHItemManager rhim = new RHItemManager();
RHItemCollection rhItems =
rhim.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem rhItem in rhItems)
{
ComboBoxItem item = new ComboBoxItem();
item.Text = rhItem.Name;
item.Value = rhItem.ID.ToString();
comboRappahanockItem.Items.Add(item);
}
//
// Bind Class Unit Types
//
ddClassUnitType.Items.Clear();
classUnitTypeNames = Enum.GetNames(typeof(DojoSeminarClassUnitType));
classUnitTypeValues = (byte[])Enum.GetValues(typeof(DojoSeminarClassUnitType));
for (int i = 0; i <= classUnitTypeNames.GetUpperBound(0); i++)
{
ddClassUnitType.Items.Add(new ListItem(
classUnitTypeNames[i],
classUnitTypeValues[i].ToString()));
}
#endregion
}
private void bindDropDownLists()
{
#region Bind Rappahanock Child Data
msItem.Items.Add(new ListItem("Null", "Null"));
RHItemManager itemManager = new RHItemManager();
RHItemCollection itemCollection = itemManager.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem item in itemCollection)
{
ListItem i = new ListItem(item.ToString(), item.ID.ToString());
msItem.Items.Add(i);
}
#endregion
}
private void bindDropDownLists()
{
#region Bind General Child Data
msLocation.Items.Add(new ListItem("Null", "Null"));
GreyFoxContactManager locationManager = new GreyFoxContactManager("kitTessen_Locations");
GreyFoxContactCollection locationCollection = locationManager.GetCollection(string.Empty, string.Empty);
foreach (GreyFoxContact location in locationCollection)
{
ListItem i = new ListItem(location.ToString(), location.ID.ToString());
msLocation.Items.Add(i);
}
#endregion
#region Bind Registration Child Data
msOptions.Items.Add(new ListItem("Null", "Null"));
DojoSeminarOptionManager optionsManager = new DojoSeminarOptionManager();
DojoSeminarOptionCollection optionsCollection = optionsManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoSeminarOption options in optionsCollection)
{
ListItem i = new ListItem(options.ToString(), options.ID.ToString());
msOptions.Items.Add(i);
}
#endregion
#region Bind Rappahanock Child Data
msItem.Items.Add(new ListItem("Null", "Null"));
RHItemManager itemManager = new RHItemManager();
RHItemCollection itemCollection = itemManager.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem item in itemCollection)
{
ListItem i = new ListItem(item.ToString(), item.ID.ToString());
msItem.Items.Add(i);
}
#endregion
}
public DojoSeminarRegistrationOptionCollection GetCollection(int topCount, string whereClause, string sortClause, params DojoSeminarRegistrationOptionFlags[] optionFlags)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
IDataReader r;
DojoSeminarRegistrationOptionCollection dojoSeminarRegistrationOptionCollection;
int hashcode;
// Cache Handling
hashcode = 0;
if (cacheEnabled)
{
hashcode = topCount.GetHashCode() +
whereClause.GetHashCode() +
sortClause.GetHashCode() +
tableName.GetHashCode();
DojoSeminarRegistrationOptionCollection collection = cacheFindCollection(hashcode);
if (collection != null)
{
return(collection);
}
}
int innerJoinOffset;
query = new StringBuilder("SELECT ");
if (topCount > 0)
{
query.Append("TOP ");
query.Append(topCount);
query.Append(" ");
}
foreach (string columnName in InnerJoinFields)
{
query.Append("DojoSeminarRegistrationOption.");
query.Append(columnName);
query.Append(",");
}
innerJoinOffset = InnerJoinFields.GetUpperBound(0) + 1;
int parentOptionOffset = -1;
int parentOptionItemOffset = -1;
int parentRegistrationOffset = -1;
int parentRegistrationParentSeminarOffset = -1;
int parentRegistrationContactOffset = -1;
int parentRegistrationInvoiceLineOffset = -1;
int parentRegistrationSalesOrderLineOffset = -1;
int parentRegistrationCustomerOffset = -1;
//
// Append Option Flag Fields
//
if (optionFlags != null)
{
for (int x = 0; x < optionFlags.Length; x++)
{
switch (optionFlags[x])
{
case DojoSeminarRegistrationOptionFlags.ParentOption:
for (int i = 0; i <= DojoSeminarOptionManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentOption.");
query.Append(DojoSeminarOptionManager.InnerJoinFields[i]);
query.Append(",");
}
parentOptionOffset = innerJoinOffset;
innerJoinOffset = parentOptionOffset + DojoSeminarOptionManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentOptionItem:
for (int i = 0; i <= RHItemManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentOption_Item.");
query.Append(RHItemManager.InnerJoinFields[i]);
query.Append(",");
}
parentOptionItemOffset = innerJoinOffset;
innerJoinOffset = parentOptionItemOffset + RHItemManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistration:
for (int i = 0; i <= DojoSeminarRegistrationManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration.");
query.Append(DojoSeminarRegistrationManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationOffset + DojoSeminarRegistrationManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationParentSeminar:
for (int i = 0; i <= DojoSeminarManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration_ParentSeminar.");
query.Append(DojoSeminarManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationParentSeminarOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationParentSeminarOffset + DojoSeminarManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationContact:
for (int i = 0; i <= GreyFoxContactManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration_Contact.");
query.Append(GreyFoxContactManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationContactOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationContactOffset + GreyFoxContactManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationInvoiceLine:
for (int i = 0; i <= RHInvoiceLineManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration_InvoiceLine.");
query.Append(RHInvoiceLineManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationInvoiceLineOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationInvoiceLineOffset + RHInvoiceLineManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationSalesOrderLine:
for (int i = 0; i <= RHSalesOrderLineManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration_SalesOrderLine.");
query.Append(RHSalesOrderLineManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationSalesOrderLineOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationSalesOrderLineOffset + RHSalesOrderLineManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationCustomer:
for (int i = 0; i <= RHCustomerManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("ParentRegistration_Customer.");
query.Append(RHCustomerManager.InnerJoinFields[i]);
query.Append(",");
}
parentRegistrationCustomerOffset = innerJoinOffset;
innerJoinOffset = parentRegistrationCustomerOffset + RHCustomerManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
}
}
}
//
// Remove trailing comma
//
query.Length--;
if (optionFlags != null)
{
query.Append(" FROM ");
//
// Start INNER JOIN expressions
//
for (int x = 0; x < optionFlags.Length; x++)
{
query.Append("(");
}
query.Append("kitTessen_SeminarRegistrationOptions AS DojoSeminarRegistrationOption");
}
else
{
query.Append(" FROM kitTessen_SeminarRegistrationOptions AS DojoSeminarRegistrationOption");
}
//
// Finish INNER JOIN expressions
//
if (optionFlags != null)
{
for (int x = 0; x < optionFlags.Length; x++)
{
switch (optionFlags[x])
{
case DojoSeminarRegistrationOptionFlags.ParentOption:
query.Append(" LEFT JOIN kitTessen_SeminarOptions AS ParentOption ON DojoSeminarRegistrationOption.ParentOptionID = ParentOption.DojoSeminarOptionID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentOptionItem:
query.Append(" LEFT JOIN RH_Items AS ParentOption_Item ON ParentOption.ItemID = ParentOption_Item.RHItemID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistration:
query.Append(" LEFT JOIN kitTessen_SeminarRegistrations AS ParentRegistration ON DojoSeminarRegistrationOption.ParentRegistrationID = ParentRegistration.DojoSeminarRegistrationID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationParentSeminar:
query.Append(" LEFT JOIN kitTessen_Seminars AS ParentRegistration_ParentSeminar ON ParentRegistration.ParentSeminarID = ParentRegistration_ParentSeminar.DojoSeminarID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationContact:
query.Append(" LEFT JOIN kitTessen_SeminarRegistrations_Contacts AS ParentRegistration_Contact ON ParentRegistration.ContactID = ParentRegistration_Contact.GreyFoxContactID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationInvoiceLine:
query.Append(" LEFT JOIN RH_InvoiceLines AS ParentRegistration_InvoiceLine ON ParentRegistration.InvoiceLineID = ParentRegistration_InvoiceLine.RHInvoiceLineID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationSalesOrderLine:
query.Append(" LEFT JOIN RH_SalesOrderLines AS ParentRegistration_SalesOrderLine ON ParentRegistration.SalesOrderLineID = ParentRegistration_SalesOrderLine.RHSalesOrderLineID)");
break;
case DojoSeminarRegistrationOptionFlags.ParentRegistrationCustomer:
query.Append(" LEFT JOIN RH_Customers AS ParentRegistration_Customer ON ParentRegistration.CustomerID = ParentRegistration_Customer.RHCustomerID)");
break;
}
}
}
//
// Render where clause
//
if (whereClause != string.Empty)
{
query.Append(" WHERE ");
query.Append(whereClause);
}
//
// Render sort clause
//
if (sortClause != string.Empty)
{
query.Append(" ORDER BY ");
query.Append(sortClause);
}
//
// Render final semicolon
//
query.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
#if DEBUG
try
{
r = database.ExecuteReader(dbCommand);
}
catch (Exception e)
{
string msg = e.Message;
throw(new Exception(msg + " --- Query: " + query.ToString()));
}
#else
r = database.ExecuteReader(dbCommand);
#endif
dojoSeminarRegistrationOptionCollection = new DojoSeminarRegistrationOptionCollection();
while (r.Read())
{
DojoSeminarRegistrationOption dojoSeminarRegistrationOption = ParseFromReader(r, 0, 1);
// Fill ParentOption
if (parentOptionOffset != -1 && !r.IsDBNull(parentOptionOffset))
{
DojoSeminarOptionManager.FillFromReader(dojoSeminarRegistrationOption.parentOption, r, parentOptionOffset, parentOptionOffset + 1);
// Fill
if (parentOptionItemOffset != -1 && !r.IsDBNull(parentOptionItemOffset))
{
RHItemManager.FillFromReader(dojoSeminarRegistrationOption.parentOption.Item, r, parentOptionItemOffset, parentOptionItemOffset + 1);
}
}
// Fill ParentRegistration
if (parentRegistrationOffset != -1 && !r.IsDBNull(parentRegistrationOffset))
{
DojoSeminarRegistrationManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration, r, parentRegistrationOffset, parentRegistrationOffset + 1);
// Fill
if (parentRegistrationParentSeminarOffset != -1 && !r.IsDBNull(parentRegistrationParentSeminarOffset))
{
DojoSeminarManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.ParentSeminar, r, parentRegistrationParentSeminarOffset, parentRegistrationParentSeminarOffset + 1);
}
// Fill
if (parentRegistrationContactOffset != -1 && !r.IsDBNull(parentRegistrationContactOffset))
{
GreyFoxContactManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.Contact, "kitTessen_SeminarRegistrations_Contacts", r, parentRegistrationContactOffset, parentRegistrationContactOffset + 1);
}
// Fill Invoice Line
if (parentRegistrationInvoiceLineOffset != -1 && !r.IsDBNull(parentRegistrationInvoiceLineOffset))
{
RHInvoiceLineManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.InvoiceLine, r, parentRegistrationInvoiceLineOffset, parentRegistrationInvoiceLineOffset + 1);
}
// Fill Sales Order Line
if (parentRegistrationSalesOrderLineOffset != -1 && !r.IsDBNull(parentRegistrationSalesOrderLineOffset))
{
RHSalesOrderLineManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.SalesOrderLine, r, parentRegistrationSalesOrderLineOffset, parentRegistrationSalesOrderLineOffset + 1);
}
// Fill Registrant
if (parentRegistrationCustomerOffset != -1 && !r.IsDBNull(parentRegistrationCustomerOffset))
{
RHCustomerManager.FillFromReader(dojoSeminarRegistrationOption.parentRegistration.Customer, r, parentRegistrationCustomerOffset, parentRegistrationCustomerOffset + 1);
}
}
dojoSeminarRegistrationOptionCollection.Add(dojoSeminarRegistrationOption);
}
// Microsoft DAAB still needs to close readers.
r.Close();
if (cacheEnabled)
{
cacheStoreCollection(hashcode, dojoSeminarRegistrationOptionCollection);
}
return(dojoSeminarRegistrationOptionCollection);
}
private void bindDropDownLists()
{
#region Bind General Child Data
msParentTemplate.Items.Add(new ListItem("Null", "Null"));
DojoMembershipTemplateManager parentTemplateManager = new DojoMembershipTemplateManager();
DojoMembershipTemplateCollection parentTemplateCollection = parentTemplateManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMembershipTemplate parentTemplate in parentTemplateCollection)
{
ListItem i = new ListItem(parentTemplate.ToString(), parentTemplate.ID.ToString());
msParentTemplate.Items.Add(i);
}
#endregion
#region Bind Member Types Child Data
msMemberType1.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType1Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType1Collection = memberType1Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType1 in memberType1Collection)
{
ListItem i = new ListItem(memberType1.ToString(), memberType1.ID.ToString());
msMemberType1.Items.Add(i);
}
msMemberType2.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType2Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType2Collection = memberType2Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType2 in memberType2Collection)
{
ListItem i = new ListItem(memberType2.ToString(), memberType2.ID.ToString());
msMemberType2.Items.Add(i);
}
msMemberType3.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType3Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType3Collection = memberType3Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType3 in memberType3Collection)
{
ListItem i = new ListItem(memberType3.ToString(), memberType3.ID.ToString());
msMemberType3.Items.Add(i);
}
msMemberType4.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType4Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType4Collection = memberType4Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType4 in memberType4Collection)
{
ListItem i = new ListItem(memberType4.ToString(), memberType4.ID.ToString());
msMemberType4.Items.Add(i);
}
msMemberType5.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType5Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType5Collection = memberType5Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType5 in memberType5Collection)
{
ListItem i = new ListItem(memberType5.ToString(), memberType5.ID.ToString());
msMemberType5.Items.Add(i);
}
msMemberType6.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType6Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType6Collection = memberType6Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType6 in memberType6Collection)
{
ListItem i = new ListItem(memberType6.ToString(), memberType6.ID.ToString());
msMemberType6.Items.Add(i);
}
msMemberType7.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType7Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType7Collection = memberType7Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType7 in memberType7Collection)
{
ListItem i = new ListItem(memberType7.ToString(), memberType7.ID.ToString());
msMemberType7.Items.Add(i);
}
msMemberType8.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager memberType8Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection memberType8Collection = memberType8Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType memberType8 in memberType8Collection)
{
ListItem i = new ListItem(memberType8.ToString(), memberType8.ID.ToString());
msMemberType8.Items.Add(i);
}
#endregion
#region Bind Rappahanock Child Data
msItem.Items.Add(new ListItem("Null", "Null"));
RHItemManager itemManager = new RHItemManager();
RHItemCollection itemCollection = itemManager.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem item in itemCollection)
{
ListItem i = new ListItem(item.ToString(), item.ID.ToString());
msItem.Items.Add(i);
}
#endregion
}
private void bind()
{
GreyFoxContactManager locationManager = new GreyFoxContactManager("kitTessen_Locations");
GreyFoxContactCollection locationCollection = locationManager.GetCollection(string.Empty, string.Empty);
foreach (GreyFoxContact itemObject in locationCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.BusinessName;
item.Value = itemObject.ID.ToString();
comboLocation.Items.Add(item);
}
DojoMemberTypeManager dojoMemberTypeManager = new DojoMemberTypeManager();
DojoMemberTypeCollection dojoMemberTypeCollection = dojoMemberTypeManager.GetCollection(string.Empty, string.Empty);
foreach (DojoMemberType itemObject in dojoMemberTypeCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.Name;
item.Value = itemObject.ID.ToString();
comboListMemberType1.Items.Add(item);
}
foreach (DojoMemberType itemObject in dojoMemberTypeCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.Name;
item.Value = itemObject.ID.ToString();
comboListMemberType2.Items.Add(item);
}
foreach (DojoMemberType itemObject in dojoMemberTypeCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.Name;
item.Value = itemObject.ID.ToString();
comboListMemberType3.Items.Add(item);
}
DojoMemberManager dojoMemberManager = new DojoMemberManager();
DojoMemberCollection dojoMemberCollection = dojoMemberManager.GetCollection(
"UserAccountID IS NOT NULL", string.Empty);
ddPanelChief.Items.Add(new ListItem(" ", "null"));
foreach (DojoMember itemObject in dojoMemberCollection)
{
ddPanelChief.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString()));
}
foreach (DojoMember itemObject in dojoMemberCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.UserAccount.UserName;
item.Value = itemObject.ID.ToString();
comboPanelMembers.Items.Add(item);
}
DojoTestListStatusManager dojoTestListStatusManager = new DojoTestListStatusManager();
DojoTestListStatusCollection dojoTestListStatusCollection = dojoTestListStatusManager.GetCollection(string.Empty, string.Empty);
foreach (DojoTestListStatus itemObject in dojoTestListStatusCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.ToString();
item.Value = itemObject.ID.ToString();
comboStatus.Items.Add(item);
}
DojoTestListManager dojoTestListManager = new DojoTestListManager();
DojoTestListCollection dojoTestListCollection = dojoTestListManager.GetCollection(string.Empty, string.Empty);
ddActiveTestList.Items.Add(new ListItem(" ", "null"));
foreach (DojoTestList itemObject in dojoTestListCollection)
{
ddActiveTestList.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString()));
}
RHItemManager rHItemManager = new RHItemManager();
RHItemCollection rHItemCollection = rHItemManager.GetCollection(string.Empty, string.Empty);
foreach (RHItem itemObject in rHItemCollection)
{
ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem();
item.Text = itemObject.ToString();
item.Value = itemObject.ID.ToString();
comboItem.Items.Add(item);
}
}
private void bindDropDownLists()
{
#region Bind Default Child Data
msLocation.Items.Add(new ListItem("Null", "Null"));
GreyFoxContactManager locationManager = new GreyFoxContactManager("kitTessen_Locations");
GreyFoxContactCollection locationCollection = locationManager.GetCollection(string.Empty, string.Empty);
foreach (GreyFoxContact location in locationCollection)
{
ListItem i = new ListItem(location.ToString(), location.ID.ToString());
msLocation.Items.Add(i);
}
#endregion
#region Bind List Generator Child Data
msListMemberType1.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager listMemberType1Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection listMemberType1Collection = listMemberType1Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType listMemberType1 in listMemberType1Collection)
{
ListItem i = new ListItem(listMemberType1.ToString(), listMemberType1.ID.ToString());
msListMemberType1.Items.Add(i);
}
msListMemberType2.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager listMemberType2Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection listMemberType2Collection = listMemberType2Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType listMemberType2 in listMemberType2Collection)
{
ListItem i = new ListItem(listMemberType2.ToString(), listMemberType2.ID.ToString());
msListMemberType2.Items.Add(i);
}
msListMemberType3.Items.Add(new ListItem("Null", "Null"));
DojoMemberTypeManager listMemberType3Manager = new DojoMemberTypeManager();
DojoMemberTypeCollection listMemberType3Collection = listMemberType3Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMemberType listMemberType3 in listMemberType3Collection)
{
ListItem i = new ListItem(listMemberType3.ToString(), listMemberType3.ID.ToString());
msListMemberType3.Items.Add(i);
}
#endregion
#region Bind Administration Child Data
msPanelChief.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelChiefManager = new DojoMemberManager();
DojoMemberCollection panelChiefCollection = panelChiefManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelChief in panelChiefCollection)
{
ListItem i = new ListItem(panelChief.ToString(), panelChief.ID.ToString());
msPanelChief.Items.Add(i);
}
msPanelMember1.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelMember1Manager = new DojoMemberManager();
DojoMemberCollection panelMember1Collection = panelMember1Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelMember1 in panelMember1Collection)
{
ListItem i = new ListItem(panelMember1.ToString(), panelMember1.ID.ToString());
msPanelMember1.Items.Add(i);
}
msPanelMember2.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelMember2Manager = new DojoMemberManager();
DojoMemberCollection panelMember2Collection = panelMember2Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelMember2 in panelMember2Collection)
{
ListItem i = new ListItem(panelMember2.ToString(), panelMember2.ID.ToString());
msPanelMember2.Items.Add(i);
}
msPanelMember3.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelMember3Manager = new DojoMemberManager();
DojoMemberCollection panelMember3Collection = panelMember3Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelMember3 in panelMember3Collection)
{
ListItem i = new ListItem(panelMember3.ToString(), panelMember3.ID.ToString());
msPanelMember3.Items.Add(i);
}
msPanelMember4.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelMember4Manager = new DojoMemberManager();
DojoMemberCollection panelMember4Collection = panelMember4Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelMember4 in panelMember4Collection)
{
ListItem i = new ListItem(panelMember4.ToString(), panelMember4.ID.ToString());
msPanelMember4.Items.Add(i);
}
msPanelMember5.Items.Add(new ListItem("Null", "Null"));
DojoMemberManager panelMember5Manager = new DojoMemberManager();
DojoMemberCollection panelMember5Collection = panelMember5Manager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoMember panelMember5 in panelMember5Collection)
{
ListItem i = new ListItem(panelMember5.ToString(), panelMember5.ID.ToString());
msPanelMember5.Items.Add(i);
}
#endregion
#region Bind System Child Data
msStatus.Items.Add(new ListItem("Null", "Null"));
DojoTestListStatusManager statusManager = new DojoTestListStatusManager();
DojoTestListStatusCollection statusCollection = statusManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoTestListStatus status in statusCollection)
{
ListItem i = new ListItem(status.ToString(), status.ID.ToString());
msStatus.Items.Add(i);
}
msActiveTestList.Items.Add(new ListItem("Null", "Null"));
DojoTestListManager activeTestListManager = new DojoTestListManager();
DojoTestListCollection activeTestListCollection = activeTestListManager.GetCollection(string.Empty, string.Empty, null);
foreach (DojoTestList activeTestList in activeTestListCollection)
{
ListItem i = new ListItem(activeTestList.ToString(), activeTestList.ID.ToString());
msActiveTestList.Items.Add(i);
}
#endregion
#region Bind Rappahanock Child Data
msItem.Items.Add(new ListItem("Null", "Null"));
RHItemManager itemManager = new RHItemManager();
RHItemCollection itemCollection = itemManager.GetCollection(string.Empty, string.Empty, null);
foreach (RHItem item in itemCollection)
{
ListItem i = new ListItem(item.ToString(), item.ID.ToString());
msItem.Items.Add(i);
}
#endregion
}
public DojoSeminarOptionCollection GetCollection(int topCount, string whereClause, string sortClause, params DojoSeminarOptionFlags[] optionFlags)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
IDataReader r;
DojoSeminarOptionCollection dojoSeminarOptionCollection;
int hashcode;
// Cache Handling
hashcode = 0;
if (cacheEnabled)
{
hashcode = topCount.GetHashCode() +
whereClause.GetHashCode() +
sortClause.GetHashCode() +
tableName.GetHashCode();
DojoSeminarOptionCollection collection = cacheFindCollection(hashcode);
if (collection != null)
{
return(collection);
}
}
int innerJoinOffset;
query = new StringBuilder("SELECT ");
if (topCount > 0)
{
query.Append("TOP ");
query.Append(topCount);
query.Append(" ");
}
foreach (string columnName in InnerJoinFields)
{
query.Append("DojoSeminarOption.");
query.Append(columnName);
query.Append(",");
}
innerJoinOffset = InnerJoinFields.GetUpperBound(0) + 1;
int itemOffset = -1;
int itemParentItemOffset = -1;
int itemPurchaseVendorOffset = -1;
int itemPurchaseAccountOffset = -1;
int itemInventoryAccountOffset = -1;
int itemTaxOffset = -1;
int itemSalesIncomeAccountOffset = -1;
//
// Append Option Flag Fields
//
if (optionFlags != null)
{
for (int x = 0; x < optionFlags.Length; x++)
{
switch (optionFlags[x])
{
case DojoSeminarOptionFlags.Item:
for (int i = 0; i <= RHItemManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item.");
query.Append(RHItemManager.InnerJoinFields[i]);
query.Append(",");
}
itemOffset = innerJoinOffset;
innerJoinOffset = itemOffset + RHItemManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemParentItem:
for (int i = 0; i <= RHItemManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_ParentItem.");
query.Append(RHItemManager.InnerJoinFields[i]);
query.Append(",");
}
itemParentItemOffset = innerJoinOffset;
innerJoinOffset = itemParentItemOffset + RHItemManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemPurchaseVendor:
for (int i = 0; i <= RHVendorManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_PurchaseVendor.");
query.Append(RHVendorManager.InnerJoinFields[i]);
query.Append(",");
}
itemPurchaseVendorOffset = innerJoinOffset;
innerJoinOffset = itemPurchaseVendorOffset + RHVendorManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemPurchaseAccount:
for (int i = 0; i <= RHAccountManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_PurchaseAccount.");
query.Append(RHAccountManager.InnerJoinFields[i]);
query.Append(",");
}
itemPurchaseAccountOffset = innerJoinOffset;
innerJoinOffset = itemPurchaseAccountOffset + RHAccountManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemInventoryAccount:
for (int i = 0; i <= RHAccountManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_InventoryAccount.");
query.Append(RHAccountManager.InnerJoinFields[i]);
query.Append(",");
}
itemInventoryAccountOffset = innerJoinOffset;
innerJoinOffset = itemInventoryAccountOffset + RHAccountManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemTax:
for (int i = 0; i <= RHTaxTypeManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_Tax.");
query.Append(RHTaxTypeManager.InnerJoinFields[i]);
query.Append(",");
}
itemTaxOffset = innerJoinOffset;
innerJoinOffset = itemTaxOffset + RHTaxTypeManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
case DojoSeminarOptionFlags.ItemSalesIncomeAccount:
for (int i = 0; i <= RHAccountManager.InnerJoinFields.GetUpperBound(0); i++)
{
query.Append("Item_SalesIncomeAccount.");
query.Append(RHAccountManager.InnerJoinFields[i]);
query.Append(",");
}
itemSalesIncomeAccountOffset = innerJoinOffset;
innerJoinOffset = itemSalesIncomeAccountOffset + RHAccountManager.InnerJoinFields.GetUpperBound(0) + 1;
break;
}
}
}
//
// Remove trailing comma
//
query.Length--;
if (optionFlags != null)
{
query.Append(" FROM ");
//
// Start INNER JOIN expressions
//
for (int x = 0; x < optionFlags.Length; x++)
{
query.Append("(");
}
query.Append("kitTessen_SeminarOptions AS DojoSeminarOption");
}
else
{
query.Append(" FROM kitTessen_SeminarOptions AS DojoSeminarOption");
}
//
// Finish INNER JOIN expressions
//
if (optionFlags != null)
{
for (int x = 0; x < optionFlags.Length; x++)
{
switch (optionFlags[x])
{
case DojoSeminarOptionFlags.Item:
query.Append(" LEFT JOIN RH_Items AS Item ON DojoSeminarOption.ItemID = Item.RHItemID)");
break;
case DojoSeminarOptionFlags.ItemParentItem:
query.Append(" LEFT JOIN RH_Items AS Item_ParentItem ON Item.ParentItemID = Item_ParentItem.RHItemID)");
break;
case DojoSeminarOptionFlags.ItemPurchaseVendor:
query.Append(" LEFT JOIN RH_Vendors AS Item_PurchaseVendor ON Item.PurchaseVendorID = Item_PurchaseVendor.RHVendorID)");
break;
case DojoSeminarOptionFlags.ItemPurchaseAccount:
query.Append(" LEFT JOIN RH_Accounts AS Item_PurchaseAccount ON Item.PurchaseAccountID = Item_PurchaseAccount.RHAccountID)");
break;
case DojoSeminarOptionFlags.ItemInventoryAccount:
query.Append(" LEFT JOIN RH_Accounts AS Item_InventoryAccount ON Item.InventoryAccountID = Item_InventoryAccount.RHAccountID)");
break;
case DojoSeminarOptionFlags.ItemTax:
query.Append(" LEFT JOIN RH_TaxTypes AS Item_Tax ON Item.TaxID = Item_Tax.RHTaxTypeID)");
break;
case DojoSeminarOptionFlags.ItemSalesIncomeAccount:
query.Append(" LEFT JOIN RH_Accounts AS Item_SalesIncomeAccount ON Item.SalesIncomeAccountID = Item_SalesIncomeAccount.RHAccountID)");
break;
}
}
}
//
// Render where clause
//
if (whereClause != string.Empty)
{
query.Append(" WHERE ");
query.Append(whereClause);
}
//
// Render sort clause
//
if (sortClause != string.Empty)
{
query.Append(" ORDER BY ");
query.Append(sortClause);
}
//
// Render final semicolon
//
query.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
#if DEBUG
try
{
r = database.ExecuteReader(dbCommand);
}
catch (Exception e)
{
string msg = e.Message;
throw(new Exception(msg + " --- Query: " + query.ToString()));
}
#else
r = database.ExecuteReader(dbCommand);
#endif
dojoSeminarOptionCollection = new DojoSeminarOptionCollection();
while (r.Read())
{
DojoSeminarOption dojoSeminarOption = ParseFromReader(r, 0, 1);
// Fill Item
if (itemOffset != -1 && !r.IsDBNull(itemOffset))
{
RHItemManager.FillFromReader(dojoSeminarOption.item, r, itemOffset, itemOffset + 1);
// Fill
if (itemParentItemOffset != -1 && !r.IsDBNull(itemParentItemOffset))
{
RHItemManager.FillFromReader(dojoSeminarOption.item.ParentItem, r, itemParentItemOffset, itemParentItemOffset + 1);
}
// Fill Vendor
if (itemPurchaseVendorOffset != -1 && !r.IsDBNull(itemPurchaseVendorOffset))
{
RHVendorManager.FillFromReader(dojoSeminarOption.item.PurchaseVendor, r, itemPurchaseVendorOffset, itemPurchaseVendorOffset + 1);
}
// Fill Purchase Account
if (itemPurchaseAccountOffset != -1 && !r.IsDBNull(itemPurchaseAccountOffset))
{
RHAccountManager.FillFromReader(dojoSeminarOption.item.PurchaseAccount, r, itemPurchaseAccountOffset, itemPurchaseAccountOffset + 1);
}
// Fill Asset Account
if (itemInventoryAccountOffset != -1 && !r.IsDBNull(itemInventoryAccountOffset))
{
RHAccountManager.FillFromReader(dojoSeminarOption.item.InventoryAccount, r, itemInventoryAccountOffset, itemInventoryAccountOffset + 1);
}
// Fill
if (itemTaxOffset != -1 && !r.IsDBNull(itemTaxOffset))
{
RHTaxTypeManager.FillFromReader(dojoSeminarOption.item.Tax, r, itemTaxOffset, itemTaxOffset + 1);
}
// Fill
if (itemSalesIncomeAccountOffset != -1 && !r.IsDBNull(itemSalesIncomeAccountOffset))
{
RHAccountManager.FillFromReader(dojoSeminarOption.item.SalesIncomeAccount, r, itemSalesIncomeAccountOffset, itemSalesIncomeAccountOffset + 1);
}
}
dojoSeminarOptionCollection.Add(dojoSeminarOption);
}
// Microsoft DAAB still needs to close readers.
r.Close();
if (cacheEnabled)
{
cacheStoreCollection(hashcode, dojoSeminarOptionCollection);
}
return(dojoSeminarOptionCollection);
}
