public static DataTable GetPrograms()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_Programs_Get"));
}
}
public static DataTable GetStationAllList()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_StationListAll_Get"));
}
}
public static DataTable GetNPRNewscastProgram()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("PSP_ProgramMulticast_Get"));
}
}
public static DataTable GetMonthsList()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_MonthsList_Get"));
}
}
public static DataTable GetPrograRegularMulticast()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("PSP_ProgramRegularMulticast_Get"));
}
}
public static DataTable GetStationListForGrid(long userId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationListForGrid_Get", new SqlParameter("@UserId", userId)));
}
}
public static DataTable GetCarriageTypesEnabled()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_CarriageTypeEnabled_Get"));
}
}
public static DataTable GetMinorityStatuses()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MinorityStatuses_Get"));
}
}
public static DataTable GetMetroMarkets()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MetroMarkets_Get"));
}
}
public static DataTable GetCities()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationCity_Get"));
}
}
public static DataTable GetMemberStatusEnabled()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MemberStatusEnabled_Get"));
}
}
public static DataTable GetAllTextContent()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_InfTextContentAll_Get"));
}
}
public static DataTable UpdatePrimaryUserStatus(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_UpdateStationPrimaryId",
new SqlParameter("@StationId", stationId)));
}
}
public static DataTable GetStationLinkPrimaryUser(long?stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationLinkPrimaryUser_Get",
new SqlParameter("@StationId", stationId)));
}
}
public static DataTable Get_CallLetters(long?StationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_CallLetters_Get",
new SqlParameter("@StationId", StationId)));
}
}
/// <summary>
/// Gets all the unsent emails from the queue that have fewer than the specified number of retry attempts.
/// </summary>
public static DataTable GetQueuedEmails(int maxRetryAttempts)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_InfEmailUnsent_Get",
new SqlParameter("@MaxRetryAttempts", maxRetryAttempts)));
}
}
public static DataTable GetProgramProducersByProgramId(long programId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_ProgramProducersByProgramId_Get",
new SqlParameter("@ProgramId", programId)));
}
}
public static DataTable StationActiveSearch(string searchTerm)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationActiveSearch_Get",
new SqlParameter("@SearchTerm", searchTerm)));
}
}
/// <summary>
/// Gets the attachments for the specified email.
/// </summary>
public static DataTable GetAttachmentsForEmail(long InfEmailId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_InfEmailAttachmentsForEmail_Get",
new SqlParameter("@InfEmailId", InfEmailId)));
}
}
public static DataTable GetStationAffiliates(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationAffiliates_Get",
new SqlParameter("@StationId", stationId)));
}
}
public static DataTable GetScheduleYearsList(int futureYears)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_ScheduleYearsList_Get",
new SqlParameter("@FutureYears", futureYears)));
}
}
public static DataTable GetScheduleNewscasts(long scheduleId, char gridInd)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_ScheduleNewscasts_Get",
new SqlParameter("@ScheduleId", scheduleId),
new SqlParameter("@GridInd", gridInd)));
}
}
public static DataTable GetRepeaterStationReport(string stationEnabled, string bandSpan)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_RepeaterStationReport_GET",
new SqlParameter("@StationEnabled", stationEnabled),
new SqlParameter("@BandSpan", bandSpan)));
}
}
public static DataTable GetProgramsByName(string programName, bool startsWithInd)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_ProgramsByName_Get",
new SqlParameter("@ProgramName", programName),
new SqlParameter("@StartsWithInd", startsWithInd)));
}
}
public static DataTable RemoveUserStationLink(long userId, long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_UserStationLink_DELETE",
new SqlParameter("@UserId", userId),
new SqlParameter("@StationId", stationId)));
}
}
public static DataTable GetStationsForUserId(long userId)
{
using (var sqlHelper = new InfSqlHelper())
{
DataTable dt = sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationsForUserId_Get",
new SqlParameter("@UserId", userId));
return(dt);
}
}
public static DataTable GetStationAssociates(long stationId, string hdFlag)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationAssociates_Get",
new SqlParameter("@StationId", stationId),
new SqlParameter("@HDFlag", hdFlag)));
}
}
public static DataTable SearchProgramProducers(long?programId, long?producerid)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_ProgramProducerSearch_Get",
new SqlParameter("@ProgramId", programId),
new SqlParameter("@ProducerId", producerid),
new SqlParameter("@DebugInd", "N")));
}
}
public static DataTable GetLookupList(string tableName, string idColumnName, string displayColumnName)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_InfLookupList_Get",
new SqlParameter("@TableName", tableName),
new SqlParameter("@IdColumnName", idColumnName),
new SqlParameter("@DisplayColumnName", displayColumnName)));
}
}
public static DataTable GetStationList_LILO(string band, string stationEnabled, string memberStatus)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationListAsMemberBand_LILO_Get",
new SqlParameter("@BandSpan", band),
new SqlParameter("@StationEnabled", stationEnabled),
new SqlParameter("@MemberStatusId", memberStatus)));
}
}
