public List <tMvtCompte> GetListeNvtParCompte(string NumCompte) { using (SqlConnection Conn = new SqlConnection(ClassVaribleGolbal.seteconnexion)) try { Conn.Open(); List <tMvtCompte> _list = new List <tMvtCompte>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string s = "select * from tMvtCompte where NumCompte = @a"; SqlCommand objCommand = new SqlCommand(s, Conn); objCommand.Parameters.AddWithValue("@a", NumCompte); SqlDataReader _Reader = objCommand.ExecuteReader(); while (_Reader.Read()) { tMvtCompte objCust = new tMvtCompte(); objCust.NumRef = Convert.ToInt32(_Reader["NumRef"]); objCust.NumOperation = Convert.ToInt32(_Reader["NumOperation"]); objCust.NumCompte = _Reader["NumCompte"].ToString(); objCust.Entree = Convert.ToDouble(_Reader["Entree"]); objCust.Sortie = Convert.ToDouble(_Reader["Sortie"]); objCust.DateMvt = Convert.ToDateTime(_Reader["DateMvt"]); objCust.Interet = Convert.ToDouble(_Reader["Interet"]); _list.Add(objCust); } return(_list); } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
public int EnregistrerMouvement(tMvtCompte tbl) { using (SqlConnection con = new SqlConnection(ClassVaribleGolbal.seteconnexion)) { con.Open(); string query = "INSERT INTO tMvtCompte(NumOperation,NumCompte,Entree,Sortie,DateMvt,Interet) VALUES (@a,@b,@c,@d,@e,@f)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@a", GetDerniereOperation()); cmd.Parameters.AddWithValue("@b", tbl.NumCompte); cmd.Parameters.AddWithValue("@c", tbl.Entree); cmd.Parameters.AddWithValue("@d", tbl.Sortie); cmd.Parameters.AddWithValue("@e", DateTime.Now.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@f", tbl.Interet); return(cmd.ExecuteNonQuery()); } }