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