protected virtual void ClientSearch(object sender, System.EventArgs e)
{
try {
string sql = "SELECT * FROM clients WHERE id>=0 ";
if (this.EntryClientName.Text!="") sql+=" AND name='"+this.EntryClientName.Text+"'";
if (this.EntryClientSurname1.Text!="") sql+=" AND surname1='"+this.EntryClientSurname1.Text+"'";
if (this.EntryClientSurname2.Text!="") sql+=" AND surname2='"+this.EntryClientSurname2.Text+"'";
Console.WriteLine(sql);
IDbCommand dbcmd = dbcon.CreateCommand();
dbcmd.CommandText = sql;
reader = dbcmd.ExecuteReader();
Client client;
int i=0;
while(reader.Read()) {
client=new Client((int)reader["id"],(string)reader["name"],(string)reader["surname1"],(string)reader["surname2"]);
searchResult.Add(i++,client);
Console.WriteLine(client.nomComplet());
}
if (i>0) {
Console.WriteLine("Client finded");
ClientWindow cw = new ClientWindow (dbcon,searchResult);
cw.Show ();
Console.WriteLine("Client finded 2");
this.Destroy();
}
reader.Close();
} catch (Exception ex) {
Console.WriteLine("ClientSearch: "+ex.Message);
reader.Close();
}
}
private void SetValue(int i)
{
client=(Client)clientList.GetByIndex(i);
client.name=this.EntryClientName.Text;
client.surname1=this.EntryClientSurname1.Text;
client.surname2=this.EntryClientSurname2.Text;
changed=false;
}
private void GetValue(int i)
{
client=(Client)clientList.GetByIndex(i);
this.EntryClientName.Text=client.name;
this.EntryClientSurname1.Text=client.surname1;
this.EntryClientSurname2.Text=client.surname2;
changed=false;
}
