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