public static DataTable GetPrograRegularMulticast()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("PSP_ProgramRegularMulticast_Get"));
}
}
public static DataTable GetNPRNewscastProgram()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("PSP_ProgramMulticast_Get"));
}
}
public static DataTable GetPrograms()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_Programs_Get"));
}
}
public static DataSet GetLeadInLeadOutReport(string programType, string ProgramEnabled, string ProgramID, string fromMonth, int fromYear, string toMonth, int toYear, string ReportFormat, string Band, string StationEnabled, string MemberStatus, string StationId, string City, string StateId, string day, string StartTime, string EndTime)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataSetProcedure("dbo.PSP_LeadInLeadOutReport_GET",
new SqlParameter("@programType", programType),
new SqlParameter("@ProgramEnabled", ProgramEnabled),
new SqlParameter("@ProgramID", ProgramID),
new SqlParameter("@fromMonth", fromMonth),
new SqlParameter("@fromYear", fromYear),
new SqlParameter("@toMonth", toMonth),
new SqlParameter("@toYear", toYear),
new SqlParameter("@ReportFormat", ReportFormat),
new SqlParameter("@Band", Band),
new SqlParameter("@StationEnabled", StationEnabled),
new SqlParameter("@MemberStatusId", MemberStatus),
new SqlParameter("@StationId", StationId),
new SqlParameter("@City", City),
new SqlParameter("@StateId", StateId),
new SqlParameter("@Day", day),
new SqlParameter("@StartTime", StartTime),
new SqlParameter("@EndTime", EndTime)
));
}
}
/// <summary>
/// Saves an email to the email queue.
/// </summary>
public static long SaveEmail(
string fromAddress,
string toAddress,
string ccAddress,
string bccAddress,
string priority,
string subject,
string body,
bool isBodyHtml,
long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_InfEmail_Insert",
new SqlParameter("@FromAddress", fromAddress),
new SqlParameter("@ToAddress", toAddress),
new SqlParameter("@CcAddress", ccAddress),
new SqlParameter("@BccAddress", bccAddress),
new SqlParameter("@Priority", priority),
new SqlParameter("@Subject", subject),
new SqlParameter("@Body", body),
new SqlParameter("@HtmlInd", isBodyHtml ? "Y" : "N"),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveCRCUser(long?userId, string email, long?salutationId, string firstName, string middleName, string lastName, string suffix, string jobTitle, string addressLine1, string addressLine2, string city, long?stateId, string county, string country, string zipCode, string phone, string fax, bool administratorInd, bool crcManagerInd, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_CRCUser_Save",
new SqlParameter("@UserId", userId),
new SqlParameter("@Email", email),
new SqlParameter("@SalutationId", salutationId),
new SqlParameter("@FirstName", firstName),
new SqlParameter("@MiddleName", middleName),
new SqlParameter("@LastName", lastName),
new SqlParameter("@Suffix", suffix),
new SqlParameter("@JobTitle", jobTitle),
new SqlParameter("@AddressLine1", addressLine1),
new SqlParameter("@AddressLine2", addressLine2),
new SqlParameter("@City", city),
new SqlParameter("@StateId", stateId),
new SqlParameter("@County", county),
new SqlParameter("@Country", country),
new SqlParameter("@ZipCode", zipCode),
new SqlParameter("@Phone", phone),
new SqlParameter("@Fax", fax),
new SqlParameter("@AdministratorInd", administratorInd ? "Y" : "N"),
new SqlParameter("@CRCManagerInd", crcManagerInd ? "Y" : "N"),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static DataTable GetStationAllList()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_StationListAll_Get"));
}
}
public static DataTable GetMonthsList()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure("dbo.PSP_MonthsList_Get"));
}
}
public static DataTable GetAllTextContent()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_InfTextContentAll_Get"));
}
}
public static DataTable GetCarriageTypesEnabled()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_CarriageTypeEnabled_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 GetMetroMarkets()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MetroMarkets_Get"));
}
}
public static DataTable GetMinorityStatuses()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MinorityStatuses_Get"));
}
}
public static DataTable GetMemberStatusEnabled()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_MemberStatusEnabled_Get"));
}
}
public static DataRow GetCRCManager()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_CRCManager_Get"));
}
}
public static DataTable GetCities()
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationCity_Get"));
}
}
public static DataRow GetMinorityStatus(long minorityStatusId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_MinorityStatus_Get",
new SqlParameter("@MinorityStatusId", minorityStatusId)));
}
}
public static DataRow GetDMAMarket(long dmaMarketId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_DMAMarket_Get",
new SqlParameter("@DMAMarketId", dmaMarketId)));
}
}
public static DataRow GetScheduleNewscast(long scheduleNewscastId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_ScheduleNewscast_Get",
new SqlParameter("@ScheduleNewscastId", scheduleNewscastId)));
}
}
public static DataRow GetTimeZone(long timeZoneId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_TimeZone_Get",
new SqlParameter("@TimeZoneId", timeZoneId)));
}
}
public static DataRow GetRepeaterStatus(long repeaterStatusId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_RepeaterStatus_Get",
new SqlParameter("@RepeaterStatusId", repeaterStatusId)));
}
}
public static void DeleteStationAffiliates(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
sqlHelper.ExecuteScalarProcedure(
"dbo.PSP_StationAffiliate_Del",
new SqlParameter("@StationId", stationId));
}
}
public static DataRow GetAffiliate(long affiliateId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_Affiliate_Get",
new SqlParameter("@AffiliateId", affiliateId)));
}
}
public static void DeleteSchedule(long scheduleId)
{
using (var sqlHelper = new InfSqlHelper())
{
sqlHelper.ExecuteNonQueryProcedure(
"dbo.PSP_Schedule_Del",
new SqlParameter("@ScheduleId", scheduleId));
}
}
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 GetStationLinkPrimaryUser(long?stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationLinkPrimaryUser_Get",
new SqlParameter("@StationId", stationId)));
}
}
public static DataTable StationActiveSearch(string searchTerm)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationActiveSearch_Get",
new SqlParameter("@SearchTerm", searchTerm)));
}
}
public static DataTable GetStationAffiliates(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataTableProcedure(
"dbo.PSP_StationAffiliates_Get",
new SqlParameter("@StationId", stationId)));
}
}
public static DataRow GetStationDetail(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_StationDetail_Get",
new SqlParameter("@StationId", stationId)));
}
}
public static DataRow GetProgramFormatType(long programFormatTypeId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataRowProcedure(
"dbo.PSP_ProgramFormatType_Get",
new SqlParameter("@ProgramFormatTypeId", programFormatTypeId)));
}
}