public void OneSemaine(int id)
{
InstantSemaine ist = new InstantSemaine();
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())
{
ist.IdSemaine = Convert.ToInt32(dr["Id"].ToString());
ist.DateDebut = Convert.ToDateTime(dr["Date_Debut"].ToString());
ist.DateFin = Convert.ToDateTime(dr["Date_Fin"].ToString());
ist.NomComplet = dr["Nom_Complet"].ToString();
}
dr.Dispose();
}
//return semaine;
}
public static InstantSemaine GetInstance()
{
if (inst == null)
{
inst = new InstantSemaine();
}
return(inst);
}
private InstantSemaine GetSemaine(IDataReader dr)
{
InstantSemaine ist = new InstantSemaine();
ist.IdSemaine = Convert.ToInt32(dr["Id"].ToString());
ist.DateDebut = Convert.ToDateTime(dr["Date_Debut"].ToString());
ist.DateFin = Convert.ToDateTime(dr["Date_Fin"].ToString());
ist.NomComplet = dr["Nom_Complet"].ToString();
return(ist);
}
