Beispiel #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="idrubric"></param>
        /// <returns></returns>
        public static List <Subject> GetSujetsByCategorieID(int idrubric)
        {
            DataTable dt = SubjectDAO.GetSujetsByCategorieID(idrubric);

            if (dt.Rows.Count >= 1)
            {
                List <Subject> _Sujets = new List <Subject>();

                // parcours des toutes lignes de notre table
                foreach (DataRow row in dt.Rows)
                {
                    Subject subject = new Subject(int.Parse(row["ID_SUBJECT"].ToString()), row["SUBJECT_TITLE"].ToString(), row["SUBJECT_DESCRIPTION"].ToString(), DateTime.Parse(row["SUBJECT_DATE"].ToString()), GetUserByID(int.Parse(row["ID_UTILISATEUR"].ToString())), GetRubricByID(int.Parse(row["ID_RUBRIC"].ToString())));
                    _Sujets.Add(subject);
                }
                return(_Sujets);
            }
            return(null);
        }