private void insertclient() { if (NomTextBox.Text == "" || PrenomTextBox.Text == "") { messageContent.Text = "Merci De Remplir Tous Les Champs"; animateBorder(borderMessage); } else { try { if (imageName != null) { FileStream fs = new FileStream(imageName, FileMode.Open, FileAccess.Read); byte[] imgByte = new byte[fs.Length]; fs.Read(imgByte, 0, Convert.ToInt32(fs.Length)); fs.Close(); cn.Open(); cmd.Connection = cn; cmd.CommandText = "insert into Clients(nom, prenom, Tel, img) values('" + NomTextBox.Text.Replace("'", "''") + "','" + PrenomTextBox.Text.Replace("'", "''") + "','" + TelTextBox.Text.Replace("'", "''") + "',@img)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("img", imgByte); cmd.ExecuteNonQuery(); cmd.CommandText = "select MAX(IdClient) from Clients"; int id = int.Parse(cmd.ExecuteScalar().ToString()); cmd.CommandText = "insert into SportClients values ('" + id + "','" + ConnectedSalle + "','" + ConnectedSport + "')"; cmd.ExecuteNonQuery(); //string msg = "Client ajouté avec success"; //MessageForm m = new MessageForm(msg); //m.ShowDialog(); messageContent.Text = "Client Bien Ajouté"; animateBorder(borderMessage); } else { FileStream fs = new FileStream(System.IO.Path.Combine(Environment.CurrentDirectory, @"../../Resource/avatar.png"), FileMode.Open, FileAccess.Read); byte[] imgByte = new byte[fs.Length]; fs.Read(imgByte, 0, Convert.ToInt32(fs.Length)); fs.Close(); cn.Open(); cmd.Connection = cn; cmd.CommandText = "insert into Clients(nom, prenom, Tel, img) values('" + NomTextBox.Text.Replace("'", "''") + "','" + PrenomTextBox.Text.Replace("'", "''") + "','" + TelTextBox.Text.Replace("'", "''") + "',@img)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("img", imgByte); cmd.ExecuteNonQuery(); cmd.CommandText = "select MAX(IdClient) from Clients"; int id = int.Parse(cmd.ExecuteScalar().ToString()); cmd.CommandText = "insert into SportClients values ('" + id + "','" + ConnectedSalle + "','" + ConnectedSport + "')"; cmd.ExecuteNonQuery(); //string msg = "Client ajouté avec success"; //MessageForm m = new MessageForm(msg); //m.ShowDialog(); messageContent.Text = "Client Bien Ajouté"; animateBorder(borderMessage); } } catch (Exception ex) { string msg = ex.Message; MessageForm m = new MessageForm(msg); m.ShowDialog(); } finally { cn.Close(); NomTextBox.Text = null; PrenomTextBox.Text = null; TelTextBox.Text = null; image.Source = new BitmapImage(new Uri("/Resource/avatar.png", UriKind.Relative)); dade.MainFrame.Navigate(new ClientsPage(dade, ConnectedSalle, ConnectedSport)); } } }