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());
}
private void ReportGearTotalLoad()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("Gear");
dt.Columns.Add("gear_id");
dt.Columns.Add("name");
dt.Columns.Add("manufacturer_name");
dt.Columns.Add("category");
dt.Columns.Add("description");
dt.Columns.Add("size");
dt.Columns.Add("total");
ds.Tables.Add(dt);
List <gear_detailed> gears =
GearDAO.getAllDetailed();
foreach (var gear in gears)
{
DataRow dr = ds.Tables[0].NewRow();
dr["gear_id"] = gear.gear_id;
dr["name"] = gear.name;
dr["manufacturer_name"] = gear.manufacturer_name;
dr["category"] = gear.gear_category_name;
dr["description"] = gear.description;
dr["size"] = gear.size_value;
dr["total"] = gear.quantity;
ds.Tables[0].Rows.Add(dr);
}
rptGearTotal1.SetDataSource(ds);
rptGearTotal1.SetParameterValue("pDateFrom", dateFrom.ToString("dd.MM.yyyy."));
rptGearTotal1.SetParameterValue("pDateTo", dateTo.ToString("dd.MM.yyyy."));
rptGearTotal1.SetParameterValue("pDatum", DateTime.Now.ToString("dd.MM.yyyy."));
crystalReportViewer.ReportSource = rptGearTotal1;
crystalReportViewer.Refresh();
}