Exemple #1
0
        private List <RoosterItem> ReadTables(DataTable dataTable)
        {
            List <RoosterItem> roosterItems = new List <RoosterItem>();

            foreach (DataRow dr in dataTable.Rows)
            {
                RoosterItem roosterItem = new RoosterItem()
                {
                    Description = (String)dr["Description"].ToString(),
                    First_Name  = (String)dr["First_Name"].ToString(),
                    Last_Name   = (String)dr["Last_Name"].ToString(),
                    StartTime   = (TimeSpan)dr["startTime"],
                    EndTime     = (TimeSpan)dr["endTime"],
                    Date        = (DateTime)dr["Date"]
                };
                roosterItems.Add(roosterItem);
            }
            return(roosterItems);
        }
        public List <RoosterItem> GetRoosterItems()
        {
            try
            {
                List <RoosterItem> roosterItems = activity_db.Db_Get_All_RoosterItems();
                return(roosterItems);
            }
            catch (Exception)
            {
                // something went wrong connecting to the database, so we will add a fake student to the list to make sure the rest of the application continues working!
                List <RoosterItem> roosterItems = new List <RoosterItem>();
                RoosterItem        a            = new RoosterItem();
                a.Description = "Fout";
                a.First_Name  = "Fout";
                a.Last_Name   = "Fout";
                a.StartTime   = TimeSpan.MinValue;
                a.EndTime     = TimeSpan.MinValue;
                a.Date        = DateTime.Now;

                return(roosterItems);
            }
        }