private void LoadClienti()
{
var query = "SELECT * FROM Clienti";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
var command = new SQLiteCommand(query, connection);
connection.Open();
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
long id = (long)reader["ID"];
string nume = (string)reader["Nume"];
string prenume = (string)reader["Prenume"];
string telefon = (string)reader["Telefon"];
string adresa = (string)reader["Adresa"];
string serieBuletin = (string)reader["SerieBuletin"];
string dataNasterii = (string)reader["DataNasterii"];
String cnp = reader["CNP"].ToString();
long.TryParse(cnp, out long CNP);
Clienti local = new Clienti(id, nume, prenume, adresa, CNP, serieBuletin, dataNasterii, telefon);
listaClienti.Add(local);
}
}
}
}
private void AddClient(Clienti clienti)
{
string sql = "INSERT INTO Clienti(Nume, Prenume, Adresa, SerieBuletin,CNP,Telefon,DataNasterii) "
+ " VALUES(@nume,@prenume,@adresa,@telefon,@cnp,@serieBuletin,@dataNasterii);" + " SELECT last_insert_rowid();";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
var command = new SQLiteCommand(sql, connection);
command.Parameters.AddWithValue("@nume", clienti.Nume);
command.Parameters.AddWithValue("@prenume", clienti.Prenume);
command.Parameters.AddWithValue("@adresa", clienti.Adresa);
command.Parameters.AddWithValue("@telefon", clienti.Telefon);
command.Parameters.AddWithValue("@cnp", clienti.CNP);
command.Parameters.AddWithValue("@serieBuletin", clienti.SerieBuletin);
command.Parameters.AddWithValue("@dataNasterii", clienti.DataNasterii);
connection.Open();
long id = (long)command.ExecuteScalar();
clienti.ID = id;
try
{
listaClienti.Add(clienti);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btAsigurare_Click(object sender, EventArgs e)
{
if (lvClienti.CheckedItems.Count != 1)
{
MessageBox.Show("Va rugam sa bifati doar o inregistrare", "Avertisment");
}
else
{
Clienti client = listaClienti.ElementAt(lvClienti.CheckedIndices[0]);
AsigurareForm asigurare = new AsigurareForm(client);
asigurare.ShowDialog();
}
}
private void btLBEdit_Click(object sender, EventArgs e)
{
if (listBox.SelectedItems.Count != 0)
{
local = listaClienti.ElementAt(listBox.SelectedIndices[0]);
uc1.tbNume.Text = local.Nume;
tbPrenume.Text = local.Prenume;
tbAdresa.Text = local.Adresa;
tbTelefon.Text = local.Telefon;
tbCNP.Text = local.CNP.ToString();
dtpNastere.Text = local.DataNasterii;
tbSerieBuletin.Text = local.SerieBuletin;
}
}
private void btSalveaza_Click(object sender, EventArgs e)
{
int.TryParse(tbNrNod.Text, out int loc);
Clienti local = localList.ElementAt(loc - 1);
local.Adresa = tbAdresa.Text;
local.Nume = tbNume.Text;
local.Prenume = tbPrenume.Text;
local.SerieBuletin = tbSerieBuletin.Text;
local.Telefon = tbTelefon.Text;
long.TryParse(tbCNP.Text, out long CNP);
local.CNP = CNP;
populareTV();
}
public int CompareTo(object obj)
{
if (obj == null)
{
return(-1);
}
else
{
Clienti persoana = obj as Clienti;
if (persoana.Nume != null)
{
return(this.Nume.CompareTo(persoana.Nume));
}
else
{
throw new ArgumentException("Object ul nu este client");
}
}
}
public object Clone()
{
Clienti c = new Clienti();
c.Nume = this.Nume;
c.Prenume = this.Prenume;
c.SerieBuletin = this.SerieBuletin;
c.DataNasterii = this.DataNasterii;
c.CNP = this.CNP;
c.Telefon = this.Telefon;
c.listaAsigurari = new List <Asigurari>();
c.Adresa = this.Adresa;
foreach (Asigurari each in this.listaAsigurari)
{
c.listaAsigurari.Add(each);
}
return(c);
}
private void panel1_DragDrop(object sender, DragEventArgs e)
{
string[] filePath = e.Data.GetData(DataFormats.FileDrop, false) as string[];
foreach (String path in filePath)
{
string[] content = File.ReadAllLines(path);
localList.Clear();
foreach (String line in content)
{
string[] token = line.Split(new String[] { " | " }, StringSplitOptions.None);
Clienti local = new Clienti();
local.Nume = token[0];
local.Prenume = token[1];
local.SerieBuletin = token[2];
local.Telefon = token[3];
local.Adresa = token[4];
long.TryParse(token[5], out long cnp);
local.CNP = cnp;
local.DataNasterii = token[6];
localList.Add(local);
}
dataGridView1.Rows.Clear();
foreach (Clienti each in localList)
{
dataGridView1.Rows.Add(new String[] {
each.Nume,
each.Prenume,
each.Adresa,
each.Telefon,
each.CNP.ToString(),
each.SerieBuletin,
each.DataNasterii
});
}
}
}
private void btAdauga_Click(object sender, EventArgs e)
{
bool OK = true;
foreach (Clienti each in listaClienti)
{
if (each.CNP.ToString() == tbCNP.Text)
{
OK = false;
}
}
if (OK == true)
{
String nume = uc1.tbNume.Text;
String prenume = tbPrenume.Text;
String adresa = tbAdresa.Text;
String serieBuletn = tbSerieBuletin.Text;
long.TryParse(tbCNP.Text, out long CNP);
String telefon = tbTelefon.Text;
String dataNasterii = dtpNastere.Text;
Clienti local = new Clienti(nume, prenume, adresa, CNP, serieBuletn, dataNasterii, telefon);
var op = new Operation();
var dition = new Addition();
local.add += op.OnOperation;
local.add += dition.OnOperation;
local.OnOperation();
//listaClienti.Add(local);
AddClient(local);
populareLV();
}
else
{
MessageBox.Show("Clientul exista deja in lista", "Avertisment");
}
}
private void btEditare_Click(object sender, EventArgs e)
{
if (lvClienti.CheckedItems.Count != 1)
{
MessageBox.Show("Va rugam sa bifati doar o inregistrare", "Avertisment");
}
else
{
bool OK = false;
while (OK == false)
{
Clienti client = listaClienti.ElementAt(lvClienti.CheckedIndices[0]);
EditareClientiForm editare = new EditareClientiForm(client);
editare.ShowDialog();
OK = true;
foreach (Clienti each in listaClienti)
{
if (each != client)
{
if (each.CNP == client.CNP)
{
OK = false;
}
}
}
if (OK == true)
{
populareLV();
}
else
{
MessageBox.Show("CNP identic cu al altui client, va rugam modificati", "Avertisment");
}
}
}
}
public AsigurareForm(Clienti c)
{
InitializeComponent();
local = c;
populareListViewAsigurari();
}
public EditareClientiForm(Clienti c)
{
InitializeComponent();
local = c;
}
public void OnOperation(Clienti clienti)
{
Console.WriteLine("Clientul " + clienti.ID + " " + clienti.Nume + " " + clienti.Prenume + " a fost asigurat\n");
}
public void OnOperation(Clienti clienti)
{
Console.WriteLine("Clientul " + clienti.Nume + " " + clienti.Prenume + " se asigura");
Console.WriteLine("Please wait...");
Thread.Sleep(3000);
}