private Mandataire GetAllMandataire(IDataReader rd)
{
Mandataire m = new Mandataire();
m.Id = Convert.ToInt32(rd["Id"].ToString());
m.Noms = rd["Noms"].ToString();
m.Contat = rd["Contact"].ToString();
m.Profession = rd["Profession"].ToString();
m.Age = Convert.ToInt32(rd["Age"].ToString());
return(m);
}
public void Enregistrer(Mandataire m)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_MANDATAIRE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@noms", 100, DbType.String, Noms));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@contact", 100, DbType.String, Contat));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@profession", 100, DbType.String, Profession));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@date_naiss", 10, DbType.Date, DateNaiss));
cmd.ExecuteNonQuery();
//MessageBox.Show("Enregistrement reussie", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
