/// <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 void DeleteStationAffiliates(long stationId)
{
using (var sqlHelper = new InfSqlHelper())
{
sqlHelper.ExecuteScalarProcedure(
"dbo.PSP_StationAffiliate_Del",
new SqlParameter("@StationId", stationId));
}
}
public static long?ReverseLookup(string lookupTableName, string lookupColumnName, string lookupValue)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure(
"dbo.PSP_InfReverseLookup_Get",
new SqlParameter("@LookupTableName", lookupTableName),
new SqlParameter("@LookupColumnName", lookupColumnName),
new SqlParameter("@LookupValue", lookupValue)) as long?);
}
}
public static long SaveMetroMarket(long metroMarketId, string marketName, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_MetroMarket_Save",
new SqlParameter("@MetroMarketId", metroMarketId),
new SqlParameter("@MarketName", marketName),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveRepeaterStatus(long repeaterStatusId, string repeaterStatusName, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_RepeaterStatus_Save",
new SqlParameter("@RepeaterStatusId", repeaterStatusId),
new SqlParameter("@RepeaterStatusName", repeaterStatusName),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveSalutation(long salutationId, string salutationName, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Salutation_Save",
new SqlParameter("@SalutationId", salutationId),
new SqlParameter("@SalutationName", salutationName),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static T LookupById <T>(string lookupTableName, long id, string valueColumnName)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <T>(
"dbo.PSP_InfLookupById_Get",
new SqlParameter("@LookupTableName", lookupTableName),
new SqlParameter("@Id", id),
new SqlParameter("@ValueColumnName", valueColumnName)));
}
}
public static bool ValidateAffiliateCodeIsUnique(long?affiliateId, string affiliateCode)
{
using (var sqlHelper = new InfSqlHelper())
{
var isUnique = sqlHelper.ExecuteScalarProcedure <string>(
"dbo.PSP_AffiliateValidateCodeIsUnique_Get",
new SqlParameter("@AffiliateId", affiliateId),
new SqlParameter("@AffiliateCode", affiliateCode));
return(isUnique.Equals("Y", StringComparison.OrdinalIgnoreCase));
}
}
public static long SaveState(long stateId, string stateName, string abbreviation, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_State_Save",
new SqlParameter("@StateId", stateId),
new SqlParameter("@StateName", stateName),
new SqlParameter("@Abbreviation", abbreviation),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveTimeZone(long timeZoneId, string timeZoneCode, string displayName, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_TimeZone_Save",
new SqlParameter("@TimeZoneId", timeZoneId),
new SqlParameter("@TimeZoneCode", timeZoneCode),
new SqlParameter("@DisplayName", displayName),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveDMAMarket(long stationId, long dmaMarketId, string dmaMarketRank, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_DMAMarket_Save",
new SqlParameter("@DMAMarketId", stationId),
new SqlParameter("@DMAMarketId", dmaMarketId),
new SqlParameter("@DMAMarketRank", dmaMarketRank),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static bool ValidateEmailIsUnique(long?userId, string email)
{
using (var sqlHelper = new InfSqlHelper())
{
var uniqueInd = sqlHelper.ExecuteScalarProcedure <string>(
"dbo.PSP_CRCUserValidateEmailIsUnique_Get",
new SqlParameter("@UserId", userId),
new SqlParameter("@Email", email));
return(uniqueInd.Equals("Y", StringComparison.OrdinalIgnoreCase));
}
}
public static bool IsValueUnique(object value, string tableName, string columnName, long?id)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <string>(
"dbo.PSP_InfIsValueUnique_Get",
new SqlParameter("@Value", value),
new SqlParameter("@TableName", tableName),
new SqlParameter("@ColumnName", columnName),
new SqlParameter("@Id", id))
.Equals("Y", StringComparison.OrdinalIgnoreCase));
}
}
public static long SaveBand(long?bandId, string bandName, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Band_Save",
new SqlParameter("@BandId", bandId),
new SqlParameter("@BandName", bandName),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveCarriageType(long?carriageTypeId, string carriageTypeName, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_CarriageType_Save",
new SqlParameter("@CarriageTypeId", carriageTypeId),
new SqlParameter("@CarriageTypeName", carriageTypeName),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static bool ValidateCallLettersIsUnique(long?stationId, string callLetters, long?bandId)
{
using (var sqlHelper = new InfSqlHelper())
{
var isUnique = sqlHelper.ExecuteScalarProcedure <string>(
"dbo.PSP_CallLettersIsUnique_Get",
new SqlParameter("@StationId", stationId),
new SqlParameter("@BandId", bandId),
new SqlParameter("@CallLetters", callLetters));
return(isUnique.Equals("Y", StringComparison.OrdinalIgnoreCase));
}
}
public static long UpdateStationAQHCume(string callLetters, string band, long aQH, long cume, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_StationAQHCume_Update",
new SqlParameter("@CallLetters", callLetters),
new SqlParameter("@Band", band),
new SqlParameter("@AQH", aQH),
new SqlParameter("@Cume", cume),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveMinorityStatus(long?minorityStatusId, string minorityStatusName, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_MinorityStatus_Save",
new SqlParameter("@MinorityStatusId", minorityStatusId),
new SqlParameter("@MinorityStatusName", minorityStatusName),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long UpdateDMAMarket(string callLetters, string band, string dmaMarket, string dmaMarketRank, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_DMAMarket_Update",
new SqlParameter("@CallLetters", callLetters),
new SqlParameter("@Band", band),
new SqlParameter("@DMAMarket", dmaMarket),
new SqlParameter("@DMAMarketRank", dmaMarketRank),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long CreateSchedule(long stationId, int month, int year, int?monthToCopy, int?yearToCopy, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_ScheduleCreate_Save",
new SqlParameter("@StationId", stationId),
new SqlParameter("@Month", month),
new SqlParameter("@Year", year),
new SqlParameter("@MonthToCopy", monthToCopy),
new SqlParameter("@YearToCopy", yearToCopy),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveAffiliate(long?affiliateId, string affiliateName, string affiliateCode, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Affiliate_Save",
new SqlParameter("@AffiliateId", affiliateId),
new SqlParameter("@AffiliateName", affiliateName),
new SqlParameter("@AffiliateCode", affiliateCode),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveMemberStatus(long?memberStatusId, string memberStatusName, bool nprMembershipInd, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_MemberStatus_Save",
new SqlParameter("@MemberStatusId", memberStatusId),
new SqlParameter("@MemberStatusName", memberStatusName),
new SqlParameter("@NPRMembershipInd", (nprMembershipInd == true ? "Y" : "N")),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveStationNote(long?stationNoteId, long stationId, string NoteText, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_StationNote_Save",
new SqlParameter("@StationNoteId", stationNoteId),
new SqlParameter("@StationId", stationId),
new SqlParameter("@NoteText", NoteText),
new SqlParameter("@DeletedDate", disabledDate),
new SqlParameter("@DeletedUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveProgramFormatType(long?programFormatTypeId, string programFormatTypeName, string programFormatTypeCode, long majorFormatId, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_ProgramFormatType_Save",
new SqlParameter("@ProgramFormatTypeId", programFormatTypeId),
new SqlParameter("@ProgramFormatTypeName", programFormatTypeName),
new SqlParameter("@ProgramFormatTypeCode", programFormatTypeCode),
new SqlParameter("@MajorFormatId", majorFormatId),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
/// <summary>
/// Saves an email attachment.
/// </summary>
public static long SaveEmailAttachment(
long InfEmailId,
string attachmentName,
byte[] attachmentBytes,
long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_InfEmailAttachment_Insert",
new SqlParameter("@InfEmailId", InfEmailId),
new SqlParameter("@AttachmentName", attachmentName),
new SqlParameter("@AttachmentBytes", attachmentBytes),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveSchedule(long scheduleId, long stationId, int year, int month, DateTime submittedDate, long submittedUserId, DateTime acceptedDate, long acceptedUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Schedule_Save",
new SqlParameter("@ScheduleId", scheduleId),
new SqlParameter("@StationId", stationId),
new SqlParameter("@Year", year),
new SqlParameter("@Month", month),
new SqlParameter("@SubmittedDate", submittedDate),
new SqlParameter("@SubmittedUserId", submittedUserId),
new SqlParameter("@AcceptedDate", acceptedDate),
new SqlParameter("@AcceptedUserId", acceptedUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveStation(long?stationId, string callLetters, long?bandId, string frequency, long?repeaterStatusId, long?flagshipStationId, long?memberStatusId, long?minorityStatusId, DateTime?statusDate, long?licenseeTypeId, string licenseeName, string addressLine1, string addressLine2, string city, long?stateId, string county, string country, string zipCode, string phone, string fax, string email, string webPage, string tsaCume, string tsaaqh, long?metroMarketId, int?metroMarketRank, long?dmaMarketId, int?dmaMarketRank, long?timeZoneId, int?hoursFromFlagship, int?maxNumberOfUsers, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Station_Save",
new SqlParameter("@StationId", stationId),
new SqlParameter("@CallLetters", callLetters),
new SqlParameter("@BandId", bandId),
new SqlParameter("@Frequency", frequency),
new SqlParameter("@RepeaterStatusId", repeaterStatusId),
new SqlParameter("@FlagshipStationId", flagshipStationId),
new SqlParameter("@MemberStatusId", memberStatusId),
new SqlParameter("@MinorityStatusId", minorityStatusId),
new SqlParameter("@StatusDate", statusDate),
new SqlParameter("@LicenseeTypeId", licenseeTypeId),
new SqlParameter("@LicenseeName", licenseeName),
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("@Email", email),
new SqlParameter("@WebPage", webPage),
new SqlParameter("@TSACume", tsaCume),
new SqlParameter("@TSAAQH", tsaaqh),
new SqlParameter("@MetroMarketId", metroMarketId),
new SqlParameter("@MetroMarketRank", metroMarketRank),
new SqlParameter("@DMAMarketId", dmaMarketId),
new SqlParameter("@DMAMarketRank", dmaMarketRank),
new SqlParameter("@TimeZoneId", timeZoneId),
new SqlParameter("@HoursFromFlagship", hoursFromFlagship),
new SqlParameter("@MaxNumberOfUsers", maxNumberOfUsers),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveProducer(long?producerId, long?salutationId, string firstName, string middleName, string lastName, string suffix, string role, string email, string phone, DateTime?disabledDate, long?disabledUserId, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_Producer_Save",
new SqlParameter("@ProducerId", producerId),
new SqlParameter("@SalutationId", salutationId),
new SqlParameter("@FirstName", firstName),
new SqlParameter("@MiddleName", middleName),
new SqlParameter("@LastName", lastName),
new SqlParameter("@Suffix", suffix),
new SqlParameter("@Role", role),
new SqlParameter("@Email", email),
new SqlParameter("@Phone", phone),
new SqlParameter("@DisabledDate", disabledDate),
new SqlParameter("@DisabledUserId", disabledUserId),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
public static long SaveScheduleProgram(long scheduleProgramId, long scheduleId, long?programId, string startTime, string endTime, string sundayInd, string mondayInd, string tuesdayInd, string wednesdayInd, string thursdayInd, string fridayInd, string saturdayInd, long lastUpdatedUserId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteScalarProcedure <long>(
"dbo.PSP_ScheduleProgram_Save",
new SqlParameter("@ScheduleProgramId", scheduleProgramId),
new SqlParameter("@ScheduleId", scheduleId),
new SqlParameter("@ProgramId", programId),
new SqlParameter("@StartTime", startTime),
new SqlParameter("@EndTime", endTime),
new SqlParameter("@SundayInd", sundayInd),
new SqlParameter("@MondayInd", mondayInd),
new SqlParameter("@TuesdayInd", tuesdayInd),
new SqlParameter("@WednesdayInd", wednesdayInd),
new SqlParameter("@ThursdayInd", thursdayInd),
new SqlParameter("@FridayInd", fridayInd),
new SqlParameter("@SaturdayInd", saturdayInd),
new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId)));
}
}
