C# Class Stardust.Manager.Helpers.CreateSqlCommandHelper

ファイルを表示 Open project: Teleopti/Stardust Class Usage Examples

Public Methods

Method	Description
CreateDeleteFromJobQueueCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateDeleteJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateDoesJobDetailItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateDoesJobItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateDoesJobQueueItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateGetAllExecutingJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateGetAllJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateGetJobQueueItemByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateInsertIntoJobCommand ( JobQueueItem jobQueueItem, string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateInsertIntoJobDetailCommand ( System.Guid jobId, string detail, System.DateTime created, SqlConnection sqlConnection ) : SqlCommand
CreateInsertIntoJobQueueCommand ( JobQueueItem jobQueueItem, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelect1JobQueueItemCommand ( SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelectAllAliveWorkerNodesCommand ( SqlConnection sqlConnection ) : SqlCommand
CreateSelectAllItemsInJobQueueCommand ( SqlConnection connection ) : SqlCommand
CreateSelectJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateSelectJobDetailByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
CreateSelectJobThatDidNotEndCommand ( string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateSelectWorkerNodeCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateUpdateCancellingResultCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
CreateUpdateResultCommand ( System.Guid jobId, string result, System.DateTime ended, SqlConnection sqlConnection ) : SqlCommand

Method Details

CreateDeleteFromJobQueueCommand() public method

public CreateDeleteFromJobQueueCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateDeleteJobByJobIdCommand() public method

public CreateDeleteJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateDoesJobDetailItemExistsCommand() public method

public CreateDoesJobDetailItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateDoesJobItemExistsCommand() public method

public CreateDoesJobItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateDoesJobQueueItemExistsCommand() public method

public CreateDoesJobQueueItemExistsCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateGetAllExecutingJobsCommand() public method

public CreateGetAllExecutingJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateGetAllJobsCommand() public method

public CreateGetAllJobsCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateGetJobQueueItemByJobIdCommand() public method

public CreateGetJobQueueItemByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobCommand() public method

public CreateInsertIntoJobCommand ( JobQueueItem jobQueueItem, string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobQueueItem	Stardust.Manager.Models.JobQueueItem
sentToWorkerNodeUri	string
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobDetailCommand() public method

public CreateInsertIntoJobDetailCommand ( System.Guid jobId, string detail, System.DateTime created, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
detail	string
created	System.DateTime
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateInsertIntoJobQueueCommand() public method

public CreateInsertIntoJobQueueCommand ( JobQueueItem jobQueueItem, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobQueueItem	Stardust.Manager.Models.JobQueueItem
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateSelect1JobQueueItemCommand() public method

public CreateSelect1JobQueueItemCommand ( SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateSelectAllAliveWorkerNodesCommand() public method

public CreateSelectAllAliveWorkerNodesCommand ( SqlConnection sqlConnection ) : SqlCommand
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateSelectAllItemsInJobQueueCommand() public method

public CreateSelectAllItemsInJobQueueCommand ( SqlConnection connection ) : SqlCommand
connection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateSelectJobByJobIdCommand() public method

public CreateSelectJobByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateSelectJobDetailByJobIdCommand() public method

public CreateSelectJobDetailByJobIdCommand ( System.Guid jobId, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand

CreateSelectJobThatDidNotEndCommand() public method

public CreateSelectJobThatDidNotEndCommand ( string sentToWorkerNodeUri, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
sentToWorkerNodeUri	string
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateSelectWorkerNodeCommand() public method

public CreateSelectWorkerNodeCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateUpdateCancellingResultCommand() public method

public CreateUpdateCancellingResultCommand ( System.Guid jobId, SqlConnection sqlConnection, SqlTransaction sqlTransaction ) : SqlCommand
jobId	System.Guid
sqlConnection	System.Data.SqlClient.SqlConnection
sqlTransaction	System.Data.SqlClient.SqlTransaction
return	System.Data.SqlClient.SqlCommand

CreateUpdateResultCommand() public method

public CreateUpdateResultCommand ( System.Guid jobId, string result, System.DateTime ended, SqlConnection sqlConnection ) : SqlCommand
jobId	System.Guid
result	string
ended	System.DateTime
sqlConnection	System.Data.SqlClient.SqlConnection
return	System.Data.SqlClient.SqlCommand