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