public static DataSet getAllUserShowDetailsDS(int ShowID)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.UserShows us = new Data.UserShows(moduleSettings);
     return us.getAllUserShowDetails(ShowID);
 }
        public static List<ShowEntry> getAllUserShowDetails(int ShowID)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.UserShows us = new Data.UserShows(moduleSettings);
            var list = new List<ShowEntry>();
            var ds = us.getAllUserShowDetails(ShowID);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                list.Add(new ShowEntry
                {
                    UserShowId = Convert.ToInt32(row["UserShowsID"]),
                    UserName = row["Name"].ToString(),
                    ContactDate = (row["ContactDate"] == DBNull.Value ? DateTime.MinValue: Convert.ToDateTime(row["ContactDate"])),
                    ContactStatus = Convert.ToInt32(row["ContactStatus"]),
                    EntryStatus = Convert.ToInt32(row["Status"])
                });
            }

            return list;
        }