public DataSet GetAllShows()
 {
     Data.Shows shows = new Fpp.WebModules.Data.Shows(_moduleSettings);
     return shows.GetAllShows(_id);
 }
 public void setStatus(SHOW_STATUS status)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.Shows shows = new Fpp.WebModules.Data.Shows(moduleSettings);
     shows.setStatus(_id, (int)status);
 }
        public static List<Shows> getPublishedShows(int UserID)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.Shows shows = new Fpp.WebModules.Data.Shows(moduleSettings);
            DataSet ds;

            if (UserID > -1)
            {
                ds = shows.GetAllNotEnteredShows(UserID);
            }
            else
            {
                ds = shows.GetAllPublishedShows();
            }

            List<Shows> showsList = new List<Shows>();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                showsList.Add(new Shows(row));
            }
            return showsList;
        }
 public static List<ShowDocuments> getShowDocuments(int ShowID)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.Shows shows = new Fpp.WebModules.Data.Shows(moduleSettings);
     List<ShowDocuments> showDocs = new List<ShowDocuments>();
     DataSet ds = shows.getShowDocuments(ShowID);
     foreach (DataRow doc in ds.Tables[0].Rows)
     {
         showDocs.Add(new ShowDocuments(doc));
     }
     return showDocs;
 }
 // update the news identified by the specified ID
 public bool Update(String showName, String showDate, String closingDate, String venue, String venuePostcode)
 {
     Data.Shows showDetails = new Fpp.WebModules.Data.Shows(_moduleSettings);
     return showDetails.Update(_id, showName, showDate, closingDate, venue, venuePostcode);
 }