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