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); } } }