public void SortirajPoImenu(bool reverse) { // - SotrirajPoImenu(): SeznamOseb sortira po imenu SeznamOseb.Clear(); using (SQLiteConnection conn = new SQLiteConnection("data source= imenik.db")) { conn.Open(); using (SQLiteCommand com = new SQLiteCommand(conn)) { com.CommandText = "SELECT o.ime, o.priimek, o.naslov, o.telefonska, o.email FROM osebe o INNER JOIN imeniki i ON i.id = o.imenik_id WHERE i.ime='" + ime + "' ORDER BY o.ime ASC;"; SQLiteDataReader reader = com.ExecuteReader(); while (reader.Read()) { Oseba o = new Oseba(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); SeznamOseb.Add(o); } com.Dispose(); } conn.Close(); } if (reverse) { SeznamOseb.Reverse(); } }
public void DodajOsebo(Oseba o) { // - DodajOsebo(novaOseba): v podatkovno bazo doda (v izbrani imenik) novo osebo using (SQLiteConnection conn = new SQLiteConnection("data source=imenik.db")) { conn.Open(); using (SQLiteCommand com = new SQLiteCommand(conn)) { com.CommandText = "INSERT INTO osebe(ime,priimek, naslov,telefonska,email,imenik_id) VALUES ('" + o.ime + "','" + o.priimek + "','" + o.naslov + "','" + o.telefonska + "','" + o.email + "'," + "(SELECT id FROM imeniki WHERE ime='" + ime + "'))"; com.ExecuteNonQuery(); } } }
public void PosodobiOsebo(string _ime, string _priimek, Oseba o) { // - PosodobiOsebo(ime, priimek, spremenjenaOseba): posodobi osebo (v izbranem imeniku) s podanim imenom in priimkom using (SQLiteConnection conn = new SQLiteConnection("data source=imenik.db")) { conn.Open(); using (SQLiteCommand com = new SQLiteCommand(conn)) { com.CommandText = "UPDATE osebe SET ime='" + o.ime + "', priimek='" + o.priimek + "', naslov='" + o.naslov + "', telefonska='" + o.telefonska + "'," + " email='" + o.email + "' WHERE ime='" + _ime + "' AND priimek='" + _priimek + "' AND imenik_id=(SELECT id FROM imeniki WHERE ime='" + ime + "')"; com.ExecuteNonQuery(); } } }
public OsebaForm(Oseba o, Imenik i, Form1 f) { InitializeComponent(); textBox_ime.Text = o.ime; textBox_priimek.Text = o.priimek; textBox_naslov.Text = o.naslov; textBox_email.Text = o.email; textBox_tel.Text = o.telefonska; button_add.Text = "Spremeni"; spreminjaj = true; os = o; im = i; f1 = f; }
private void button_add_Click(object sender, EventArgs e) { Oseba o = new Oseba(textBox_ime.Text, textBox_priimek.Text, textBox_naslov.Text, textBox_tel.Text, textBox_email.Text); if (spreminjaj) { im.PosodobiOsebo(os.ime, os.priimek, o); } else { im.DodajOsebo(o); } f1.RefreshList(im); this.Close(); }
public void OdpriImenik(string _ime) { SeznamOseb = new List <Oseba>(); // /* - OdpriImenik(imeImenika): iz podatkovne baze prebere osebe za podani imenik in jih shrani v SeznamOseb using (SQLiteConnection conn = new SQLiteConnection("data source= imenik.db")) { conn.Open(); using (SQLiteCommand com = new SQLiteCommand(conn)) { com.CommandText = "SELECT o.ime, o.priimek, o.naslov, o.telefonska, o.email FROM osebe o INNER JOIN imeniki i ON i.id = o.imenik_id WHERE i.ime='" + _ime + "';"; SQLiteDataReader reader = com.ExecuteReader(); while (reader.Read()) { Oseba o = new Oseba(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); SeznamOseb.Add(o); } com.Dispose(); } conn.Close(); } }
public Oseba VrneOsebo(string _ime, string _priimek) { // - VrnoOsebo(ime, priimek): vrne osebo (v izbranem imeniku) s podanim imenom in priimkom Oseba o = new Oseba("null", "null"); using (SQLiteConnection conn = new SQLiteConnection("data source=imenik.db")) { conn.Open(); using (SQLiteCommand com = new SQLiteCommand(conn)) { com.CommandText = "SELECT o.ime, o.priimek, o.naslov, o.telefonska, o.email FROM osebe o INNER JOIN imeniki i ON i.id = o.imenik_id" + " WHERE o.ime = '" + _ime + "' AND o.priimek='" + _priimek + "' AND i.ime = '" + ime + "'"; SQLiteDataReader reader = com.ExecuteReader(); while (reader.Read()) { o = new Oseba(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); } } } return(o); }
private void VpisVBazo() { try { if (action == 4) { if (AddPhoneBookTextBox.Text != "" || AddPhoneBookTextBox.Text != null) { PhoneBook = AddPhoneBookTextBox.Text; } else { PhoneBook = ""; } } else { if (NameTextBox.Text != "" || NameTextBox.Text != null) { FirstName = NameTextBox.Text; } else { FirstName = ""; } if (SurnameTextBox.Text != "" || SurnameTextBox.Text != null) { LastName = SurnameTextBox.Text; } else { LastName = ""; } if (HomeAddressTextBox.Text != "" || HomeAddressTextBox.Text != null) { HomeAdress = HomeAddressTextBox.Text; } else { HomeAdress = ""; } if (PostTextBox.Text != "" || PostTextBox.Text != null) { Post = Convert.ToInt32(PostTextBox.Text); } else { Post = 0000; } if (CityTextBox.Text != "" || CityTextBox.Text != null) { City = CityTextBox.Text; } else { City = ""; } if (PhoneNumberTextBox.Text != "" || PhoneNumberTextBox.Text != null) { PhoneNumber = PhoneNumberTextBox.Text; } else { PhoneNumber = "000000000"; } if (eMailTextBox.Text != "" || eMailTextBox.Text != null) { eMailAddress = eMailTextBox.Text; } else { eMailAddress = ""; } } } catch (Exception ex) // If... if somethings goes wrong { MessageBox.Show(Convert.ToString(ex)); } Oseba newOseba = new Oseba(UserID); Oseba newOseba1 = new Oseba(UserID, FirstName, LastName, HomeAdress, Post, City, PhoneNumber, eMailAddress, PhoneBook_id); Oseba newOseba2 = new Oseba(FirstName, LastName, HomeAdress, Post, City, PhoneNumber, eMailAddress, PhoneBook_id); Imeniki newImenik = new Imeniki(PhoneBook_id, PhoneBook); switch (action) { case 1: //Zatakne se tlele //MessageBox.Show("ShowUp"); Database DodajOsebo = new Database(); if (DodajOsebo.AddOseba(newOseba2) == true) { Display(); //MessageBox.Show("Entery Successful!"); } // stavek za klic insert funkcije baze break; case 2: Database UrediOsebo = new Database(); if (UrediOsebo.UpdateOseba(newOseba1) == true) { Display(); //MessageBox.Show("Edit Successful!"); } // stavek za klic update funkcije baze break; case 3: Database izbrisOsebe = new Database(); if (izbrisOsebe.DeleteOseba(newOseba) == true) { Display(); //MessageBox.Show("Removal Successful!"); } break; case 4: Database DodajImenik = new Database(); if (DodajImenik.AddImenik(newImenik) == true) { Dropdown(); //MessageBox.Show("Entery Successful!"); } break; } refresh(); }