private Baptiser GetBaptiser(IDataReader dr)
{
Baptiser m = new Baptiser();
i = i + 1;
m.Num = i;
m.Id = Convert.ToInt32(dr["Id"].ToString());
m.Noms = dr["Noms"].ToString();
m.Sexe = dr["Sexe"].ToString();
m.DateBapteme = Convert.ToDateTime(dr["DateBapteme"].ToString());
if (procedure != "SELECT_ALL_MEMBRE_BAPTISER")
{
m.LieuBapteme = dr["Lieu"].ToString();
m.Pasteur = dr["Pasteur"].ToString();
}
return(m);
}
public void SaveDatas(Baptiser d)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_BAPTISER";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@idModif", 5, DbType.Int32, d.Id));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@datebapteme", 5, DbType.Date, d.DateBapteme));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refprevision", 5, DbType.Int32, d.RefPrevision));
cmd.ExecuteNonQuery();
if (d.Id > 0)
{
MessageBox.Show("Modification effectuer avec succès", "Mofification", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
