private void SubmitButton_New()
{
string color = colorcmb.Text;
bool valid = true;
mDatabaseController = new DatabaseController();
List <ColorTable> colors = mDatabaseController.GetColor();
for (int i = 0; i < colors.Count; i++)
{
if (colors[i].color.ToLower() == color.ToLower())
{
MessageBox.Show("The database already contains '" + color + "' and blocked the duplicate entry.", "Duplicate Object Blocked");
return;
}
}
if (null == color || "" == color)
{
valid = false;
}
if (valid)
{
Submit(color, "na", "na");
this.Close();
}
else
{
MessageBox.Show("Data Error");
}
}
public AddColorForm()
{
InitializeComponent();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=N:\Receiving and current inventory\Inventory.mdb; Persist Security Info=False;";
// fill vendors
List <VendorsTable> vendors = mDatabaseController.GetVendors();
for (int i = 0; i < vendors.Count; i++)
{
vendorcmb.Items.Add(vendors[i].vendor);
}
// fill colors
List <ColorTable> colors = mDatabaseController.GetColor();
List <string> ColorList = new List <string>();
List <string> TypeList = new List <string>();
for (int i = 0; i < colors.Count; i++)
{
string color = colors[i].color;
string type = colors[i].type;
if (!ColorList.Contains(color))
{
ColorList.Add(color);
colorcmb.Items.Add(colors[i].color);
}
if (!TypeList.Contains(type))
{
TypeList.Add(type);
typecmb.Items.Add(colors[i].type);
}
}
vendorcmb.Sorted = true;
colorcmb.Sorted = true;
typecmb.Sorted = true;
}
private void fillColorComboBox()
{
colorcmb.Items.Clear();
DatabaseController dc = new DatabaseController();
List <ColorTable> colors = dc.GetColor();
colors.Sort();
for (int i = 0; i < colors.Count; i++)
{
if (!colorcmb.Items.Contains(colors[i].color))
{
colorcmb.Items.Add(colors[i].color);
}
}
}
