private void LoadData() { //initializing the list for the storage to delete List <string> lstStorages = new List <string>(); comboStorage.Items.Clear(); //list for all manufacturer in "add a bottle" and "remove a bottle" lstStorages = req.GetListStorages(); for (int i = 0; i < lstStorages.Count; i++) { comboStorage.Items.Add(lstStorages[i].ToString()); } List <string> lstTab = new List <string>(); dvgStorageBoxes.ColumnCount = 2; //option for display dvgStorageBoxes.ColumnHeadersDefaultCellStyle.BackColor = Color.Navy; dvgStorageBoxes.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dvgStorageBoxes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dvgStorageBoxes.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; dvgStorageBoxes.CellBorderStyle = DataGridViewCellBorderStyle.Single; dvgStorageBoxes.GridColor = Color.Black; //columns name dvgStorageBoxes.Columns[0].Name = "Nom du casier"; dvgStorageBoxes.Columns[1].Name = "Emplacement - description"; dvgStorageBoxes.Columns[0].Width = 130; dvgStorageBoxes.Rows.Clear(); List <StorageBoxes> lstBox = StorageBoxes.ShowAllBoxes(); foreach (StorageBoxes box in lstBox) { string[] row = { box.Name, box.Description }; dvgStorageBoxes.Rows.Add(row); } }
private void BottlesManagementfrm_Load(object sender, EventArgs e) { grpDel.Visible = false; btnDel.Visible = false; LoadData(); /** * load all lists for the drop down fields, to be able to add bottles */ //initializing the lists for the dropdown field List <string> lstManufacturers; List <string> lstColors; List <string> lstVarieties; List <double> lstVolumes; List <string> lstStorages; List <string> lstWines; List <int> lstYears; //list for all manufacturer in "add a bottle" and "remove a bottle" lstManufacturers = req.GetListManufacturers(); for (int i = 0; i < lstManufacturers.Count; i++) { comboManufacturer.Items.Add(lstManufacturers[i].ToString()); comboManufacturerOUT.Items.Add(lstManufacturers[i].ToString()); } //list for all colors in "add a bottle" lstColors = req.GetListColors(); for (int i = 0; i < lstColors.Count; i++) { comboColor.Items.Add(lstColors[i].ToString()); } //list for possible volumes in "add a bottle" and "remove a bottle" // fixed -> to enable other volumes, it has to be added in the list lstVolumes = new List <double>() { 0.2, 0.375, 0.5, 0.75, 1.0, 1.5, 3 }; for (int i = 0; i < lstVolumes.Count; i++) { comboVolume.Items.Add(lstVolumes[i].ToString()); comboVolumeOUT.Items.Add(lstVolumes[i].ToString()); } /** * list for all varieties in "add a bottle" * there are 3 dropdown fields with the same list, so all are initialized at the same time */ lstVarieties = req.GetListVarieties(); for (int i = 0; i < lstVarieties.Count; i++) { comboVariety1.Items.Add(lstVarieties[i].ToString()); comboVariety2.Items.Add(lstVarieties[i].ToString()); comboVariety3.Items.Add(lstVarieties[i].ToString()); } //list for all storageBoxes in "add a bottle" lstStorages = req.GetListStorages(); for (int i = 0; i < lstStorages.Count; i++) { comboStorage.Items.Add(lstStorages[i].ToString()); } //list for all years in "remove a bottle" lstYears = req.GetListDistinctYears(); for (int i = 0; i < lstYears.Count; i++) { comboYearOUT.Items.Add(lstYears[i].ToString()); } lstWines = req.GetListWines(); for (int i = 0; i < lstWines.Count; i++) { comboWine.Items.Add(lstWines[i].ToString()); } }