private void OneSemaine(int id)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "SELECT_DETAILS_SEMAINE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, id));
IDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
DateTime dateco, datefin = new DateTime();
dateco = Convert.ToDateTime(dr["Date_Debut"].ToString());
datefin = Convert.ToDateTime(dr["Date_Fin"].ToString());
InstantSemaine.GetInstance().IdSemaine = Convert.ToInt32(dr["Id"].ToString());
InstantSemaine.GetInstance().DateDebut = Convert.ToDateTime(dr["Date_Debut"].ToString());
InstantSemaine.GetInstance().DateFin = Convert.ToDateTime(dr["Date_Fin"].ToString());
InstantSemaine.GetInstance().NomComplet = dr["Nom_Complet"].ToString();
lblDebut.Text = string.Format("{0}", dateco.ToString("dd/MM/yyyy"));
lblFin.Text = string.Format("{0}", datefin.ToString("dd/MM/yyyy"));
lblNom.Text = dr["Nom_Complet"].ToString();
}
dr.Dispose();
}
OneInfoSemaine();
dn.retreivePhoto2("Photo", "Affichage_Details_Semaine", "Id", InstantSemaine.GetInstance().IdSemaine.ToString(), pictureBox3);
//return semaine;
}