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