private bool saveValues()
{
DatabaseHelper dbAccess = new DatabaseHelper();
if (basicTypes.Contains(this.type))
{
//should this be outisde this if?
if(this.DescriptionTextBox.Text.Trim() == "")
{
MessageBox.Show(this.DescriptionTextBox.Name + " cannot be blank.");
return false;
}
return dbAccess.insertRecord(typeInBasicTypes());
}
if (this.type == "fittings" || this.type == "supports")
{
return dbAccess.insertRecord(fittingsOrSupports());
}
//type contained in finishes
return dbAccess.insertRecord(typeInFinishes());
}
private void SupportsComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if(this.SupportsComboBox.SelectedItem == null)
{
this.SupportTypeComboBox.DataSource = null;
return;
}
DatabaseHelper createdb = new DatabaseHelper();
this.SupportTypeComboBox.DataSource =
createdb.selectSupportTypeName(this.SupportsComboBox.SelectedItem.ToString());
this.SupportTypeComboBox.SelectedItem = null;
}
//Fill comboboxes. Pass in 'all' to fill all
private void fillComboBox(string type)
{
DatabaseHelper createdb = new DatabaseHelper();
switch (type)
{
case "heads":
this.HeadComboBox.DataSource = createdb.selectHeadName();
this.HeadComboBox.SelectedItem = null;
break;
case "shells":
this.ShellComboBox.DataSource = createdb.selectShellName();
this.ShellComboBox.SelectedItem = null;
break;
case "fittings":
this.FittingsComboBox.DataSource = createdb.selectFittingName();
this.FittingsComboBox.SelectedItem = null;
break;
case "supports":
this.SupportsComboBox.DataSource = createdb.selectSupportName();
this.SupportsComboBox.SelectedItem = null;
break;
case "internals":
this.InternalsComboBox.DataSource = createdb.selectInternalsName();
this.InternalsComboBox.SelectedItem = null;
break;
case "interiorPrep":
this.InteriorPrepComboBox.DataSource = createdb.selectSurfacePrepInterior();
this.InteriorPrepComboBox.SelectedItem = null;
break;
case "exteriorPrep":
this.ExteriorPrepComboBox.DataSource = createdb.selectSurfacePrepExterior();
this.ExteriorPrepComboBox.SelectedItem = null;
break;
case "exteriorPaint":
this.ExteriorPaintComboBox.DataSource = createdb.selectExteriorPaint();
this.ExteriorPaintComboBox.SelectedItem = null;
break;
case "interiorPaint":
this.InteriorPaintComboBox.DataSource = createdb.selectInteriorPaint();
this.InteriorPaintComboBox.SelectedItem = null;
break;
case "all":
this.HeadComboBox.DataSource = createdb.selectHeadName();
this.ShellComboBox.DataSource = createdb.selectShellName();
this.FittingsComboBox.DataSource = createdb.selectFittingName();
this.SupportsComboBox.DataSource = createdb.selectSupportName();
this.InternalsComboBox.DataSource = createdb.selectInternalsName();
this.InteriorPrepComboBox.DataSource = createdb.selectSurfacePrepInterior();
this.ExteriorPrepComboBox.DataSource = createdb.selectSurfacePrepExterior();
this.ExteriorPaintComboBox.DataSource = createdb.selectExteriorPaint();
this.InteriorPaintComboBox.DataSource = createdb.selectInteriorPaint();
this.HeadComboBox.SelectedItem = null;
this.ShellComboBox.SelectedItem = null;
this.FittingsComboBox.SelectedItem = null;
this.SupportsComboBox.SelectedItem = null;
this.InternalsComboBox.SelectedItem = null;
this.InteriorPrepComboBox.SelectedItem = null;
this.ExteriorPrepComboBox.SelectedItem = null;
this.ExteriorPaintComboBox.SelectedItem = null;
this.InteriorPaintComboBox.SelectedItem = null;
break;
}
}
/* Fill additional combobox on value change of other */
private void FittingsComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.FittingsComboBox.SelectedItem == null)
{
this.FittingTypesComboBox.DataSource = null;
}
else
{
DatabaseHelper createdb = new DatabaseHelper();
this.FittingTypesComboBox.DataSource =
createdb.selectFittingTypeName(this.FittingsComboBox.SelectedItem.ToString());
this.FittingTypesComboBox.SelectedItem = null;
}
}
