public List <tAchat> GetListeAchatNonValides(string index) { using (SqlConnection Conn = new SqlConnection(ClassVaribleGolbal.seteconnexion)) try { Conn.Open(); List <tAchat> _list = new List <tAchat>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string s = "select * from tAchat where valider = 0"; SqlCommand objCommand = new SqlCommand(s, Conn); SqlDataReader _Reader = objCommand.ExecuteReader(); while (_Reader.Read()) { tAchat objCust = new tAchat(); objCust.idAchat = Convert.ToInt32(_Reader["idAchat"]); objCust.compte = _Reader["compte"].ToString(); objCust.numero = _Reader["numero"].ToString(); objCust.montant = Convert.ToDouble(_Reader["montant"]); objCust.valider = Convert.ToInt32(_Reader["valider"]); objCust.type = _Reader["type"].ToString(); objCust.interet = Convert.ToDouble(_Reader["interet"]); objCust.date = Convert.ToDateTime(_Reader["date"]); objCust.motif = _Reader["motif"].ToString(); _list.Add(objCust); } return(_list); } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
public int NouveauAchat(tAchat tbl) { using (SqlConnection con = new SqlConnection(ClassVaribleGolbal.seteconnexion)) { con.Open(); string query = "INSERT INTO tAchat(compte,numero,montant,valider,type,interet,date,motif) VALUES (@a,@b,@c,@d,@e,@f,@g,@h)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@a", tbl.compte); cmd.Parameters.AddWithValue("@b", tbl.numero); cmd.Parameters.AddWithValue("@c", tbl.montant); cmd.Parameters.AddWithValue("@d", tbl.valider); cmd.Parameters.AddWithValue("@e", tbl.type); cmd.Parameters.AddWithValue("@f", tbl.interet); cmd.Parameters.AddWithValue("@g", DateTime.Now.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@h", tbl.motif); return(cmd.ExecuteNonQuery()); } }