C# Класс Engage.Dnn.Booking.AppointmentSqlDataProvider

A SQL implementation of data access for the Appointment and related types

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
AcceptAppointment ( int appointmentId, int revisingUserId ) : void	Accepts or declines the Appointment with the given appointmentId.
ApproveByKey ( System.Guid actionKey ) : IDataReader	Accepts or declines an Appointment via the given actionKey.
ClearQueuedEmail ( int queueId ) : void	Clears a queued email.
DeclineAppointment ( int appointmentId, int revisingUserId ) : void	Accepts or declines the Appointment with the given appointmentId.
DeleteAppointment ( int appointmentId ) : void	Deletes the appointment with the given appointmentId.
DeleteAppointmentType ( int appointmentTypeId ) : void	Deletes the type of the appointment.
GetAppointment ( int appointmentId ) : IDataReader	Gets the appointment with the given appointmentId.
GetAppointmentType ( int appointmentTypeId, int moduleId ) : IDataReader	Gets the appointment type with the given appointmentTypeId and moduleId.
GetAppointments ( int moduleId, bool isAccepted, string sortExpression, int pageSize, int pageIndex ) : IDataReader	Gets a page of the appointments for a given moduleId.
GetAppointments ( int moduleId, string sortExpression, int pageSize, int pageIndex ) : IDataReader	Gets a page of the appointments for a given moduleId.
GetAppointmentsByDateRange ( int moduleId, System.DateTime startDateTime, System.DateTime endDateTime ) : DataTable	Gets all appointments within a given date range.
GetConcurrentAppointments ( int moduleId, System.DateTime startDateTime, System.DateTime endDateTime ) : IDataReader	Gets the concurrent appointments.
InsertAppointment ( Appointment appointment, int revisingUserId ) : IDataReader	Inserts the given appointment into the ol' database.
InsertAppointmentType ( AppointmentType appointmentType, int revisingUserId, int moduleId ) : void	Inserts an appointmentType into SkyNet Central Repository (The database)
QueueEmail ( int portalId, string toList, string subject, string body, string attachment ) : void	Queues an email.
UpdateAppointment ( Appointment appointment, int revisingUserId ) : void	Updates the given appointment's record.
UpdateAppointmentType ( AppointmentType appointmentType, int revisingUserId ) : void	Updates the type of the appointment.

Приватные методы

Метод	Описание
GetAppointmentTypes ( int moduleId ) : IDataReader
GetQueuedEmails ( ) : IDataReader

Описание методов

AcceptAppointment() публичный статический Метод

Accepts or declines the Appointment with the given appointmentId.

public static AcceptAppointment ( int appointmentId, int revisingUserId ) : void
appointmentId	int	The ID of the to accept or decline.
revisingUserId	int	The ID of the user setting the acceptance the .
Результат	void

ApproveByKey() публичный статический Метод

Accepts or declines an Appointment via the given actionKey.

public static ApproveByKey ( System.Guid actionKey ) : IDataReader
actionKey	System.Guid	The key the corresponds to accepting or declining a specific .
Результат	IDataReader

ClearQueuedEmail() публичный статический Метод

Clears a queued email.

public static ClearQueuedEmail ( int queueId ) : void
queueId	int	The queueId.
Результат	void

DeclineAppointment() публичный статический Метод

Accepts or declines the Appointment with the given appointmentId.

public static DeclineAppointment ( int appointmentId, int revisingUserId ) : void
appointmentId	int	The ID of the to accept or decline.
revisingUserId	int	The ID of the user setting the acceptance the .
Результат	void

DeleteAppointment() публичный статический Метод

Deletes the appointment with the given appointmentId.

public static DeleteAppointment ( int appointmentId ) : void
appointmentId	int	The ID of the appointment to delete.
Результат	void

DeleteAppointmentType() публичный статический Метод

Deletes the type of the appointment.

public static DeleteAppointmentType ( int appointmentTypeId ) : void
appointmentTypeId	int	The appointment type id.
Результат	void

GetAppointment() публичный статический Метод

Gets the appointment with the given appointmentId.

public static GetAppointment ( int appointmentId ) : IDataReader
appointmentId	int	The ID of the appointment to retrieve.
Результат	IDataReader

GetAppointmentType() публичный статический Метод

Gets the appointment type with the given appointmentTypeId and moduleId.

public static GetAppointmentType ( int appointmentTypeId, int moduleId ) : IDataReader
appointmentTypeId	int	The ID of the appointment type.
moduleId	int	The module id.
Результат	IDataReader

GetAppointments() публичный статический Метод

Gets a page of the appointments for a given moduleId.

public static GetAppointments ( int moduleId, bool isAccepted, string sortExpression, int pageSize, int pageIndex ) : IDataReader
moduleId	int	The ID of the module to which the appointments belong.
isAccepted	bool	/// true to retrieve only accepted appointments, /// false to retrieve only declines appointments, /// or null to retrieve only those appointments which have been neither accepted nor declined. /// Use to retrieve appointments without regard to the IsAccepted field. ///
sortExpression	string	A comma-delimited list of the columns by which to sort.
pageSize	int	Size of the page, or null to retrieve all appointments.
pageIndex	int	Index of the page, or null to retrieve all appointments.
Результат	IDataReader

GetAppointments() публичный статический Метод

Gets a page of the appointments for a given moduleId.

public static GetAppointments ( int moduleId, string sortExpression, int pageSize, int pageIndex ) : IDataReader
moduleId	int	The ID of the module to which the appointments belong.
sortExpression	string	A comma-delimited list of the columns by which to sort.
pageSize	int	Size of the page, or null to retrieve all appointments.
pageIndex	int	Index of the page, or null to retrieve all appointments.
Результат	IDataReader

GetAppointmentsByDateRange() публичный статический Метод

Gets all appointments within a given date range.

public static GetAppointmentsByDateRange ( int moduleId, System.DateTime startDateTime, System.DateTime endDateTime ) : DataTable
moduleId	int	The ID of the module to which the appointments belong.
startDateTime	System.DateTime	The beginning datetime of the range.
endDateTime	System.DateTime	The ending datetime of the range.
Результат	System.Data.DataTable

GetConcurrentAppointments() публичный статический Метод

Gets the concurrent appointments.

public static GetConcurrentAppointments ( int moduleId, System.DateTime startDateTime, System.DateTime endDateTime ) : IDataReader
moduleId	int	The module id.
startDateTime	System.DateTime	The start date time.
endDateTime	System.DateTime	The end date time.
Результат	IDataReader

InsertAppointment() публичный статический Метод

Inserts the given appointment into the ol' database.

public static InsertAppointment ( Appointment appointment, int revisingUserId ) : IDataReader
appointment	Appointment	The appointment to insert.
revisingUserId	int	The ID of the user inserting.
Результат	IDataReader

InsertAppointmentType() публичный статический Метод

Inserts an appointmentType into SkyNet Central Repository (The database)

public static InsertAppointmentType ( AppointmentType appointmentType, int revisingUserId, int moduleId ) : void
appointmentType	AppointmentType	The appointment type.
revisingUserId	int	The revising user id.
moduleId	int	The module id.
Результат	void

QueueEmail() публичный статический Метод

Queues an email.

public static QueueEmail ( int portalId, string toList, string subject, string body, string attachment ) : void
portalId	int	The current portalId.
toList	string	The comma-or-semicolon-delimited list of email address(es) to which the email should be sent.
subject	string	The subject.
body	string	The HTML body.
attachment	string	The attachment.
Результат	void

UpdateAppointment() публичный статический Метод

Updates the given appointment's record.

public static UpdateAppointment ( Appointment appointment, int revisingUserId ) : void
appointment	Appointment	The appointment to update.
revisingUserId	int	The ID of the user making this update.
Результат	void

UpdateAppointmentType() публичный статический Метод

Updates the type of the appointment.

public static UpdateAppointmentType ( AppointmentType appointmentType, int revisingUserId ) : void
appointmentType	AppointmentType	Type of the appointment.
revisingUserId	int	The revising user id.
Результат	void