private void buttonValiderClient_Click(object sender, EventArgs e)
{
if (isModif == false)
{
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1TableAdapters.clientTableAdapter intervetionAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
clientAdaptater.Insert(denominationClient.Text);
MessageBox.Show("Client crée avec succès");
client_initialize();
denominationClient.Text = "";
//ToggleFormClient();
groupBoxClient.Enabled = false;
}
else
{
int selectedrowindex = dataGrid_Listing_Client.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGrid_Listing_Client.Rows[selectedrowindex];
int idClient = Convert.ToInt32(selectedRow.Cells[0].Value);
SqlCommand cmd = connection.CreateCommand();
string name = denominationClient.Text;
//cmd.CommandText = "UPDATE client SET name = "+ name +" WHERE id_client = "+idClient;
cmd.CommandText = "UPDATE client SET name = @name WHERE id_client= " + idClient;
cmd.Parameters.AddWithValue("name", name);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
client_initialize();
MessageBox.Show("Client modifié avec avec succès");
isModif = false;
// ToggleFormClient();
denominationClient.Text = "";
groupBoxClient.Enabled = false;
}
}
private void buttonValiderClient_Click(object sender, EventArgs e)
{
if (isModif == false)
{
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1TableAdapters.clientTableAdapter intervetionAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
clientAdaptater.Insert(denominationClient.Text);
MessageBox.Show("Client crée avec succès");
client_initialize();
denominationClient.Text = "";
//ToggleFormClient();
groupBoxClient.Enabled = false;
}
else
{
int selectedrowindex = dataGrid_Listing_Client.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGrid_Listing_Client.Rows[selectedrowindex];
int idClient = Convert.ToInt32(selectedRow.Cells[0].Value);
SqlCommand cmd = connection.CreateCommand();
string name = denominationClient.Text;
//cmd.CommandText = "UPDATE client SET name = "+ name +" WHERE id_client = "+idClient;
cmd.CommandText = "UPDATE client SET name = @name WHERE id_client= " + idClient;
cmd.Parameters.AddWithValue("name", name);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
client_initialize();
MessageBox.Show("Client modifié avec avec succès");
isModif = false;
// ToggleFormClient();
denominationClient.Text = "";
groupBoxClient.Enabled = false;
}
}
