private void populateGearTable()
{
DataTable gearTable = new DataTable();
gearTable.Columns.Add("ID", typeof(int));
gearTable.Columns.Add("Naziv", typeof(string));
gearTable.Columns.Add("Proizvođač", typeof(string));
gearTable.Columns.Add("Kategorija", typeof(string));
gearTable.Columns.Add("Opis", typeof(string));
gearTable.Columns.Add("Veličina", typeof(string));
gearTable.Columns.Add("Ukupno", typeof(int));
gearTable.Columns.Add("Dostupno", typeof(int));
allGear = GearDAO.getAllDetailed();
foreach (var g in allGear)
{
gearTable.Rows.Add(g.gear_id,
g.name,
g.manufacturer_name,
g.gear_category_name,
g.description,
g.size_value,
g.quantity,
g.available
);
}
dataGridViewGear.DataSource = gearTable;
cBoxGearSearchCategory.Items.AddRange(GearDAO.getAllCategories().ToArray());
}
private void AddGearForm_Load(object sender, EventArgs e)
{
manufacturers = GearDAO.getAllManufacturers();
categories = GearDAO.getAllCategories();
gearSizes = GearDAO.getAllSizes();
gearItemsDetailed = GearDAO.getAllDetailed();
cBoxGearName.Items.AddRange(gearItemsDetailed.ToArray());
cBoxGearCategory.Items.AddRange(categories.ToArray());
cBoxGearManufacturer.Items.AddRange(manufacturers.ToArray());
cBoxGearSize.Items.AddRange(gearSizes.ToArray());
}