public Boolean addHeadquarter(Headquarter h) { String query = "INSERT INTO headquarter(building_name, rooms, rent, country, city, street, number, postal_code) VALUES('" + h.Building_name + "', '" + h.Rooms + "', '" + h.Rent + "', '" + h.Country + "', '" + h.City + "', '" + h.Street + "', '" + h.Number + "', '" + h.Postal_code + "')"; try { headquarter.Insert(query); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
public void GetHeadquartersData() { Headquarter hq = new Headquarter(); hqList = db1.getHeadquarterList(); comboBox1.DataSource = new BindingSource(hqList, null); comboBox1.DisplayMember = "Building_name"; comboBox1.ValueMember = "Id"; if (this.projectId != 0) { comboBox1.SelectedValue = result.Headquarters_Id; } }
private void button1_Click(object sender, EventArgs e) { Headquarter hqAdd = new Headquarter(); hqAdd.Building_name = BuildingName.Text; hqAdd.Rooms = Int32.Parse(Rooms.Text); hqAdd.Rent = Int32.Parse(Rent.Text); hqAdd.Country = Country.Text; hqAdd.City = City.Text; hqAdd.Street = Street.Text; hqAdd.Number = Int32.Parse(Number.Text); hqAdd.Postal_code = PostalCode.Text; if (db1.addHeadquarter(hqAdd)) { this.Close(); } else { MessageBox.Show("Headquarter couldn't be added!"); } }
public AddEditEmployee(int employeeBsn) { this.employeeBsn = employeeBsn; InitializeComponent(); if (employeeBsn != 0) { GetEmployeeData(employeeBsn); } Headquarter hq = new Headquarter(); hq.Id = 2; hq.Building_name = "Harvard"; comboBox1.DataSource = new BindingSource(db1.getHeadquarterList(), null); comboBox1.DisplayMember = "Building_name"; comboBox1.ValueMember = "Id"; degreeListBox.DataSource = new BindingSource(db1.getSingleUserDegree(employee_id), null); degreeListBox.DisplayMember = "course"; degreeListBox.ValueMember = "id"; //residenceListbox.DataSource = new BindingSource() //comboBox1.Items.Add(hq); }