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