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