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