public NewOwner(Form1 form1) { InitializeComponent(); helper = form1; OwnerTableHandler ownerTableHandler = new OwnerTableHandler(); owners = ownerTableHandler.Select(); }
public void DeleteDatas(string number) { if (cb_OwnORAni.SelectedIndex == 0) { OwnerTableHandler ownerTableHandler = new OwnerTableHandler(); string deletedrecordnumber = ownerTableHandler.Delete(number).ToString(); ////////////////6-------------------------------- MessageBox.Show(deletedrecordnumber + "rekord sikeresen törölve!"); owners = ownerTableHandler.Select(); ownerTableHandler.Delete(number); Initializedgv_table(); UpdateDgv_table(); } }
public void DataSet() { OwnerTableHandler ownerTableHandler = new OwnerTableHandler(); foreach (Owners owners in ownerTableHandler.Select()) { if (owners.OwnerId == ID) { switch (cb_Set.SelectedIndex) { case 0: ownerTableHandler.Update(ID, "familyName", tb_NewSet.Text, OracleDbType.Varchar2); break; case 1: ownerTableHandler.Update(ID, "surName", tb_NewSet.Text, OracleDbType.Varchar2); break; case 2: ownerTableHandler.Update(ID, "zipCode", tb_NewSet.Text, OracleDbType.Varchar2); break; case 3: ownerTableHandler.Update(ID, "city", tb_NewSet.Text, OracleDbType.Varchar2); break; case 4: ownerTableHandler.Update(ID, "address", tb_NewSet.Text, OracleDbType.Varchar2); break; case 5: ownerTableHandler.Update(ID, "phonenumber", tb_NewSet.Text, OracleDbType.Varchar2); break; case 6: ownerTableHandler.Update(ID, "email", tb_NewSet.Text, OracleDbType.Varchar2); break; default: break; } break; } } }
public void UpdateDgv_table() { dgv_table.Rows.Clear(); if (cb_OwnORAni.SelectedIndex == 0) { OwnerTableHandler ownerTableHandler = new OwnerTableHandler(); foreach (Owners o in ownerTableHandler.Select()) { dgv_table.Rows.Add(new object[] { o.OwnerId, o.FamilyName, o.Surname, o.BirthDate.ToString("yyyy.MM.dd") }); } } }
private void Updatelb_Datas(string Id) { OwnerTableHandler ownerTableHandler = new OwnerTableHandler(); foreach (Owners o in ownerTableHandler.Select()) { if (o.OwnerId == Id) { lbl_ownerid.Text = o.OwnerId.ToString(); lbl_familyname.Text = o.FamilyName; lbl_surname.Text = o.Surname; lbl_birthdate.Text = o.BirthDate.ToString("yyyy.MM.dd"); lbl_zipcode.Text = o.ZipCode; lbl_city.Text = o.City; lbl_address.Text = o.Address; lbl_phonenumber.Text = o.PhoneNumber; lbl_email.Text = o.Email; } } }