private PrevisionBapteme GetPrevision(IDataReader dr)
{
PrevisionBapteme m = new PrevisionBapteme();
i = i + 1;
m.Num = i;
m.Id = Convert.ToInt32(dr["Id"].ToString());
m.Noms = dr["Noms"].ToString();
m.Sexe = dr["Sexe"].ToString();
m.DateNaissance = Convert.ToDateTime(dr["DateNaissance"].ToString());
m.LieuNaiss = dr["LieuNaissance"].ToString();
m.Lieu = dr["Lieu"].ToString();
m.DateCelebration = Convert.ToDateTime(dr["DateCelebration"].ToString());
m.Pasteur = dr["Pasteur"].ToString();
return(m);
}
public void SaveDatas(PrevisionBapteme d)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_PREVISION_BAPTEME";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@idModif", 5, DbType.Int32, d.Id));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refmembre", 5, DbType.Int32, d.RefMembre));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refbapteme", 5, DbType.Int32, d.RefBapteme));
cmd.ExecuteNonQuery();
if (d.Id > 0)
{
MessageBox.Show("Modification effectuer avec succès", "Mofification", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
