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;
}
}
}
