private void btnAddApartement_Click(object sender, EventArgs e) { try { MyConnexion.open(); Apartements A = new Apartements(); A.IdApartment = int.Parse(idApartmentTextBox.Text); A.Price = float.Parse(priceTextBox.Text); A.AparAddress = aparAddressTextBox.Text; A.Aparfloor = int.Parse(aparfloorTextBox.Text); A.NbrRooms = int.Parse(nbrRoomsTextBox.Text); officeSales.AddApartement(A); OfficeSalesApartList.Add(A); idApartmentTextBox1.Enabled = false; idApartmentTextBox1.Text = idApartmentTextBox.Text; MyConnexion.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// ////////// /// </summary> /// <param name="Apartement"></param> public void AddApartement(Apartements Apartement) { MyConnexion.ExecuteNonQueryMyC("insert into Apartements values(" + Apartement.IdApartment + "," + Apartement.Price + ",'" + Apartement.AparAddress + "'," + Apartement.Aparfloor + "," + Apartement.NbrRooms + ");"); }