//private void GenerateID() //{ // Conn obcon = new Conn(); // SqlConnection ob = new SqlConnection(obcon.strCon); // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = new SqlCommand(); // da.SelectCommand.Connection = ob; // SqlCommand cmd = da.SelectCommand; // cmd.CommandText = "Select isnull(max(ID),0)+1 as ID from Cabin"; // cmd.CommandType = CommandType.Text; // DataTable dt = new DataTable(); // da.Fill(dt); // if (dt.Rows.Count > 0) // { // idTextBox.Text = dt.Rows[0]["Id"].ToString(); // } //} private void CabinSetup_Load(object sender, EventArgs e) { Floor defaultFloor = new Floor(); defaultFloor.FloorName = "--Select--"; defaultFloor.Id = -1; List <Floor> floors = new List <Floor>(); floors.Add(defaultFloor); floors.AddRange(aFloorManager.GetAllFloors()); floorComboBox.DisplayMember = "FloorName"; floorComboBox.ValueMember = "Id"; floorComboBox.DataSource = floors; Category defaultCategory = new Category(); defaultCategory.CategoryName = "--Select--"; defaultCategory.Id = -1; List <Category> categories = new List <Category>(); categories.Add(defaultCategory); categories.AddRange(aCategoryManager.GetAllCategories()); categoryComboBox.DisplayMember = "CategoryName"; categoryComboBox.ValueMember = "Id"; categoryComboBox.DataSource = categories; PopulateCabinListView(); Control buttonControl = new ButtonPermissionAccess().UserButton(this.groupBox1, this.Name); //GenerateID(); //GetAllFloor(); //GetAllCategory(); }
private void BedSetup2_Load(object sender, EventArgs e) { Floor defaultFloor = new Floor(); defaultFloor.FloorName = "--Select--"; defaultFloor.Id = -1; List <Floor> floors = new List <Floor>(); floors.Add(defaultFloor); floors.AddRange(aFloorManager.GetAllFloors()); floorComboBox.DisplayMember = "FloorName"; floorComboBox.ValueMember = "Id"; floorComboBox.DataSource = floors; Category defaultCategory = new Category(); defaultCategory.CategoryName = "--Select--"; defaultCategory.Id = -1; List <Category> categories = new List <Category>(); categories.Add(defaultCategory); categories.AddRange(aCategoryManager.GetAllCategories()); categoryComboBox.DisplayMember = "CategoryName"; categoryComboBox.ValueMember = "Id"; categoryComboBox.DataSource = categories; Ward defaultWard = new Ward(); defaultWard.WardName = "--Select--"; defaultWard.Id = -1; List <Ward> wards = new List <Ward>(); wards.Add(defaultWard); wards.AddRange(aWardManager.GetAllWards()); wardComboBox.DisplayMember = "WardName"; wardComboBox.ValueMember = "Id"; wardComboBox.DataSource = wards; Room defaultRoom = new Room(); defaultRoom.RoomName = "--Select--"; defaultRoom.Id = -1; List <Room> rooms = new List <Room>(); rooms.Add(defaultRoom); rooms.AddRange(aRoomManager.GetAllRooms()); roomComboBox.DisplayMember = "RoomName"; roomComboBox.ValueMember = "Id"; roomComboBox.DataSource = rooms; PopulateItemsListView(); editButton.Enabled = false; deleteButton.Enabled = false; }
private void LoadFloor() { Floor defaultFloor = new Floor(); defaultFloor.FloorName = "--Select--"; defaultFloor.Id = -1; List <Floor> floors = new List <Floor>(); floors.Add(defaultFloor); floors.AddRange(aFloorManager.GetAllFloors()); floorComboBox.DisplayMember = "FloorName"; floorComboBox.ValueMember = "Id"; floorComboBox.DataSource = floors; }