public Shows(int id)
: base()
{
_shows = new Fpp.WebModules.Data.Shows(_moduleSettings);
try
{
DataSet ds = _shows.GetShow(id);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
LoadFromRow(ds.Tables[0].Rows[0]);
}
}
catch (Exception e )
{
AppException.LogEvent("Shows:" + e.Message);
}
}
public Shows(DataRow row)
{
_shows = new Fpp.WebModules.Data.Shows(_moduleSettings);
LoadFromRow(row);
}
public DataSet GetAllShows()
{
Data.Shows shows = new Data.Shows(ModuleSettings);
return shows.GetAllShows(ID);
}
public Shows()
: base()
{
_shows = new Fpp.WebModules.Data.Shows(_moduleSettings);
}
public void ToggleRingPlannerLock()
{
String moduleSettings = ModuleConfig.GetSettings();
Data.Shows shows = new Data.Shows(moduleSettings);
RingPlannerLock = !RingPlannerLock;
shows.RingPlannerLock(ID, RingPlannerLock);
}
public Shows(DataRow row)
{
_shows = new Data.Shows(ModuleSettings);
LoadFromRow(row);
}
public static void SetGenerated(int showId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.Shows shows = new Data.Shows(moduleSettings);
shows.SetGenerated(showId);
}
public void setStatus(SHOW_STATUS status)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.Shows shows = new Data.Shows(moduleSettings);
shows.setStatus(ID, (int)status);
}
public Shows()
: base()
{
_shows = new Data.Shows(ModuleSettings);
}
public static List<Shows> GetUnpublishedShows()
{
String moduleSettings = ModuleConfig.GetSettings();
List<Shows> showsList = new List<Shows>();
try
{
Data.Shows shows = new Data.Shows(moduleSettings);
DataSet ds;
ds = shows.GetUnpublishedShows();
foreach (DataRow row in ds.Tables[0].Rows)
{
showsList.Add(new Shows(row));
}
}
catch (Exception e)
{
AppException.LogEvent("getPublishedShows:" + e.Message);
throw e;
}
return showsList;
}
public static List<Shows> GetShowsForUser(int userId)
{
var moduleSettings = ModuleConfig.GetSettings();
var shows = new Data.Shows(moduleSettings);
var ds = shows.GetShowsForUser(userId);
return (from DataRow row in ds.Tables[0].Rows select new Shows(row)).ToList();
}
public static List<Shows> GetShowForNow(int days)
{
String moduleSettings = ModuleConfig.GetSettings();
List<Shows> showsList = new List<Shows>();
try
{
Data.Shows shows = new Data.Shows(moduleSettings);
DataSet ds;
ds = shows.GetShowForNow(days);
foreach (DataRow row in ds.Tables[0].Rows)
{
showsList.Add(new Shows(row));
}
}
catch (Exception e)
{
AppException.LogEvent("GetShowForNow:" + e.Message + " " + e.StackTrace);
throw e;
}
return showsList;
}
public static List<ShowDocuments> getShowDocuments(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.Shows shows = new 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;
}
public static List<Shows> getPublishedShows(int UserID)
{
String moduleSettings = ModuleConfig.GetSettings();
List<Shows> showsList = new List<Shows>();
try
{
Data.Shows shows = new Data.Shows(moduleSettings);
DataSet ds;
if (UserID > -1)
{
ds = shows.GetAllNotEnteredShows(UserID);
}
else
{
ds = shows.GetAllPublishedShows();
}
foreach (DataRow row in ds.Tables[0].Rows)
{
showsList.Add(new Shows(row));
}
}
catch (Exception e)
{
AppException.LogEvent("getPublishedShows:" + e.Message);
throw e;
}
return showsList;
}
public static List<ConfiguredShowDto> GetConfiguredShow()
{
var moduleSettings = ModuleConfig.GetSettings();
var showsList = new List<ConfiguredShowDto>();
try
{
var shows = new Data.Shows(moduleSettings);
var ds = shows.GetConfiguredShows();
showsList.AddRange(from DataRow row in ds.Tables[0].Rows select new ConfiguredShowDto
{
ShowId = Convert.ToInt32(row["ShowId"]),
ShowName = Convert.ToString(row["Name"]),
ShowDetailsId = Convert.ToInt32(row["ShowDetailId"]),
ShowDate = Convert.ToDateTime(row["ShowDate"])
});
}
catch (Exception e)
{
AppException.LogEvent("GetConfiguredShow:" + e.Message + " " + e.StackTrace);
throw;
}
return showsList;
}
