public void insertStock(ClsStock cb) { try { innitialiseConnect(); if (!con.State.ToString().ToLower().Equals("open")) { con.Open(); } cmd = new SqlCommand("exec InsertSI @Article,@Quantite,@DateStock", con); setParameter(cmd, "@Article", DbType.String, 20, cb.RefArticle1); setParameter(cmd, "@Quantite", DbType.String, 500, cb.Quantite); setParameter(cmd, "@DateStock", DbType.DateTime, 20, cb.DateSock); cmd.ExecuteNonQuery(); con.Close(); //MessageBox.Show("Message Envoyé "); } catch (Exception ex) { //MessageBox.Show(ex.Message); } }
public void InsertArticleSI() { bool teste = true; ClsStock cb = new ClsStock(); innitialiseConnect(); if (!con.State.ToString().ToLower().Equals("open")) { con.Open(); } SqlCommand cmd = new SqlCommand("select codeArt,quantiteArt from tArticle", con); SqlDataReader dr; dr = cmd.ExecuteReader(); int count = 0; while (dr.Read()) { cb.RefArticle1 = int.Parse(dr["codeArt"].ToString()); cb.Quantite = double.Parse(dr["quantiteArt"].ToString()); cb.DateSock = DateTime.Now; insertStock(cb); //count += 1; } //if (count == 1) //{ // teste = true; //} //else //{ // teste = false; //} //return teste; }