public List <model_client> ViewClient(String cmnd)
{
List <model_client> data = new List <model_client>();
SqlCommand req = new SqlCommand();
openconx();
req.Connection = cnn;
req.CommandType = CommandType.Text; // Changer le type de la requete en text (non pas procedure)
req.CommandText = cmnd;
req.Parameters.Clear();
datareader = req.ExecuteReader();
while (datareader.Read())
{
model_client item = new model_client();
item.Ref = int.Parse(datareader.GetValue(0).ToString());
item.Code_client = int.Parse(datareader.GetValue(1).ToString());
item.Nom_client = datareader.GetValue(2).ToString();
item.Adress_client = datareader.GetValue(3).ToString();
item.Numerophone_client = datareader.GetValue(4).ToString();
item.Email_client = datareader.GetValue(5).ToString();
item.Fax = datareader.GetValue(6).ToString();
data.Add(item); // data.Add(new article_model((int)datareader.GetValue(0), (String)datareader.GetValue(1),(String) datareader.GetValue(2),(String) datareader.GetValue(3), (String)datareader.GetValue(4), (String)datareader.GetValue(5),(float) datareader.GetValue(6), (int)datareader.GetValue(7), (DateTime)datareader.GetValue(8),(byte[]) datareader.GetValue(9)));
}
return(data);
}
public add_success(model_client client)
{
prgf = @"code Client:" + client.Code_client + "NOM de client :" + client.Nom_client
+ "adress de client :" + client.Adress_client + "Email de client" + client.Email_client + "numero teliphone de client" + client.Numerophone_client;
InitializeComponent();
}
public void update(model_client item)
{
SqlCommand macommende = new SqlCommand();
openconx();
macommende.Connection = cnn;
macommende.CommandType = CommandType.Text;
macommende.CommandText = @"UPDATE Client SET code = @code, nom = @nom, phone = @phone,adress=@adress,Email=@Email
WHERE ref=" + item.Ref;
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@code", SqlDbType.VarChar, 40);
param[0].Value = item.Code_client;
param[1] = new SqlParameter("@nom", SqlDbType.VarChar, 40);
param[1].Value = item.Nom_client;
param[2] = new SqlParameter("@phone", SqlDbType.VarChar, 40);
param[2].Value = item.Numerophone_client;
param[3] = new SqlParameter("@adress", SqlDbType.VarChar, 40);
param[3].Value = item.Adress_client;
param[4] = new SqlParameter("@Email", SqlDbType.VarChar, 40);
param[4].Value = item.Email_client;
param[5] = new SqlParameter("@fax", SqlDbType.VarChar, 40);
param[5].Value = item.Fax;
macommende.Parameters.AddRange(param);
macommende.ExecuteNonQuery();
}
private void update_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
progresbar.Hide();
model_client model = ((model_client)e.Result);
add_success add_Success = new add_success(model);
add_Success.ShowDialog();
}
private void update_DoWork(object sender, DoWorkEventArgs e)
{
model_client model = ((model_client)e.Argument);
sqlcn sql = new sqlcn();
sql.update(model);
e.Result = model;
}
private void gunaGradientButton1_Click(object sender, EventArgs e)
{
progresbar.Show();
model_client item = new model_client();
item.Code_client = int.Parse(code_client.Text);
item.Nom_client = nom.Text;
item.Adress_client = adress_client.Text;
item.Numerophone_client = numero_client.Text;
item.Email_client = email_client.Text;
item.Fax = faxclient.Text;
if (!background_ajoute.IsBusy)
{
background_ajoute.RunWorkerAsync(item);
}
}
private void background_ajoute_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
progresbar.Hide();
List <object> parameters = e.Result as List <object>;
int i = int.Parse(parameters[0].ToString());
model_client item = (model_client)parameters[1];
if (i == -1)
{
MessageBox.Show("errure d'ajouter");
}
else
{
units.Controls_clear(ajoute);
add_success add_Success = new add_success(item);
add_Success.ShowDialog();
}
}
private void view_data_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
progresbar.Show();
DataGridViewCellCollection a = view_data.Rows[e.RowIndex].Cells;
string value = a[2].Value.ToString();
model_client model = new model_client();
model.Ref = int.Parse(a[0].Value.ToString());
model.Code_client = int.Parse(a[1].Value.ToString());
model.Nom_client = a[2].Value.ToString();
model.Email_client = a[3].Value.ToString();
model.Adress_client = a[4].Value.ToString();
model.Numerophone_client = a[5].Value.ToString();
model.Fax = a[6].Value.ToString();
if (!update.IsBusy)
{
update.RunWorkerAsync(model);
}
}
