public static DataRow GetCRCManager() { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCManager_Get")); } }
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 GetCRCUserByResetPasswordToken(string token) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCUserByResetPasswordToken_Get", new SqlParameter("@Token", token))); } }
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 GetAffiliate(long affiliateId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_Affiliate_Get", new SqlParameter("@AffiliateId", affiliateId))); } }
public static DataRow GetCRCUser(long userId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCUser_Get", new SqlParameter("@UserId", userId))); } }
public static DataRow GetProgramFormatType(long programFormatTypeId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_ProgramFormatType_Get", new SqlParameter("@ProgramFormatTypeId", programFormatTypeId))); } }
public static DataRow GetBand(long bandId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_Band_Get", new SqlParameter("@BandId", bandId))); } }
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 GetCarriageType(long carriageTypeId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CarriageType_Get", new SqlParameter("@CarriageTypeId", carriageTypeId))); } }
/// <summary> /// Returns the email template record with the specified name. /// </summary> public static DataRow GetEmailTemplateByName(string templateName) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_InfEmailTemplateByName_Get", new SqlParameter("@TemplateName", templateName))); } }
public static DataRow GetCRCUserByEmail(string email) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCUserByEmail_Get", new SqlParameter("@Email", email))); } }
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 DataRow GetCRCUserByLogin(string email, string password) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCUserByLogin_Get", new SqlParameter("@Email", email), new SqlParameter("@Password", password))); } }
public static DataRow SaveCRCUserPasswordReset(string email, long?lastUpdatedUserId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_CRCUserPasswordReset_Save", new SqlParameter("@Email", email), new SqlParameter("@LastUpdatedUserId", lastUpdatedUserId))); } }
public static DataRow GetSchedule(long scheduleId, long userId) { using (var sqlHelper = new InfSqlHelper()) { return(sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_Schedule_Get", new SqlParameter("@UserId", userId), new SqlParameter("@ScheduleId", scheduleId))); } }
public static string GetTextContent(string parentName, string contentName) { using (var sqlHelper = new InfSqlHelper()) { var dataRow = sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_InfTextContentByName_Get", new SqlParameter("@ParentName", parentName), new SqlParameter("@ContentName", contentName)); if (dataRow == null) { return(string.Format(CultureInfo.InvariantCulture, "WARNING: No content found for parent name = \"{0}\" and content name = \"{1}\".", parentName, contentName)); } else { return(dataRow["ContentText"].ToString()); } } }
public static InfDocument GetDocument(long infDocumentId) { using (var sqlHelper = new InfSqlHelper()) { var dataRow = sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_InfDocument_Get", new SqlParameter("@InfDocumentId", infDocumentId)); if (dataRow != null) { var document = new InfDocument(); dataRow.MapTo(document); return(document); } else { return(null); } } }
public static InfDocument GetDocument(string parentName, string documentFileName) { using (var sqlHelper = new InfSqlHelper()) { var dataRow = sqlHelper.ExecuteDataRowProcedure( "dbo.PSP_InfDocumentByName_Get", new SqlParameter("@ParentName", parentName), new SqlParameter("@DocumentFileName", documentFileName)); if (dataRow != null) { var document = new InfDocument(); dataRow.MapTo(document); return(document); } else { return(null); } } }