public static List <Configuration> GetConfigurationByApplicationId(Application application)
{
List <Configuration> configurations = new List <Configuration>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.SERVICE_VIEW_GET_APPLICATION_CONFIG;
command.Parameters.AddWithValue(ConfigurationDAO.AT_CONFIG_ID, application.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
configurations.Add(new Configuration(reader,
Configuration.View.GetApplicationConfiguration));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "getConfigurationByApplicationId(Application application)", application.id.ToString());
}
}
return(configurations);
}
public static Acknowledgement insertIntoAcknowledgement(Acknowledgement ack)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.POST_ACKNOWLEDGEMENT_PROCEDURE;
command.Parameters.AddWithValue(AcknowledgementDAO.AT_MESSAGE_ID, ack.messageId);
command.Parameters.AddWithValue(AcknowledgementDAO.AT_ACKNOWLEDGEMENT_TYPE_ID, ack.acknowledgementTypeId);
command.Parameters.AddWithValue(AcknowledgementDAO.AT_RAW, ack.raw);
command.Parameters.AddWithValue(AcknowledgementDAO.AT_CREATED_DTTM, ack.createdDttm);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ack = new Acknowledgement(reader);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "insertIntoAcknowledgement(Acknowledgement ack)", ack.messageId.ToString());
}
}
return(ack);
}
private static List <MessageGroupInstance> getSingleMessageGroupInstance(MessageGroupInstance messageGroupInstance)
{
List <MessageGroupInstance> messageGroupInstances = new List <MessageGroupInstance>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.GET_SINGLE_MESSAGE_GROUP_INSTANCE;
command.Parameters.AddWithValue(MessageGroupInstanceDAO.AT_ID, messageGroupInstance.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
messageGroupInstances.Add(new MessageGroupInstance(reader));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "getSingleMessageGroupInstance(MessageGroupInstance MessageGroupInstance)", messageGroupInstance.id.ToString());
}
}
return(messageGroupInstances);
}
private static bool deleteMessageGroupInstance(MessageGroupInstance messageGroupInstance)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.DELETE_MESSAGE_GROUP_INSTANCE;
command.Parameters.AddWithValue(MessageGroupInstanceDAO.AT_ID, messageGroupInstance.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
messageGroupInstance.id = DAOUtility.GetData <int>(reader, MessageGroupInstanceDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "DeleteMessageGroupInstance()", messageGroupInstance.id.ToString());
}
}
return(true);
}
private static List <WebserviceObject> getSingleWebserviceObject(WebserviceObject webserviceObject)
{
List <WebserviceObject> webserviceObjects = new List <WebserviceObject>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.GET_SINGLE_WEBSERVICE_OBJECT;
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_ID, webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webserviceObjects.Add(new WebserviceObject(reader));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "getSingleWebserviceObject(WebserviceObject WebserviceObject)", webserviceObject.id.ToString());
}
}
return(webserviceObjects);
}
private static bool deleteWebserviceObject(WebserviceObject webserviceObject)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.DELETE_WEBSERVICE_OBJECT;
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_ID, webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webserviceObject.id = DAOUtility.GetData <int>(reader, WebserviceObjectDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "DeleteWebserviceObject()", webserviceObject.id.ToString());
}
}
return(true);
}
public static bool UpdateProcessedFlagAndMessageLog(MessageHeaderInstance messageHeaderInstance,
Message message,
bool isReprocess = false)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
// set the flag which determines the reprocess
bool isProcessed = false;
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.UPDATE_MESSAGE_HEADER_INSTANCE_PROCESS;
command.Parameters.AddWithValue(MessageBucketDAO.AT_ID, messageHeaderInstance.id);
command.Parameters.AddWithValue(MessageBucketDAO.AT_MESSAGE_ID, message.id);
command.Parameters.AddWithValue(MessageBucketDAO.AT_ISREPROCESS, isReprocess);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
isProcessed = DAOUtility.GetData <bool>(reader, MessageBucketDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "MessageHeaderInstance messageHeaderInstance, Message message",
messageHeaderInstance.id.ToString() + "|" + message.id.ToString());
ErrorLogger.LogError(new Exception("Message UpdateProcessedFlagAndMessageLog Retry"),
"MessageHeaderInstance messageHeaderInstance, Message message", messageHeaderInstance.id.ToString() + "|" + message.id.ToString());
isProcessed = UpdateProcessedFlagAndMessageLog(messageHeaderInstance, message, isReprocess);
}
}
return(isProcessed);
}
private static bool reprocessMessage(int messageHeaderInstanceId, string messageControlId)
{
if (messageHeaderInstanceId == Convert.ToInt32(ZERO) && messageControlId == BLANK)
{
throw new ArgumentNullException("There is no message header instance id or message control id, can't reprocess");
}
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
// set the flag which determines the reprocess
bool isProcessed = false;
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.UPDATE_MESSAGE_HEADER_INSTANCE_FOR_REPROCESS;
command.Parameters.AddWithValue(MessageBucketDAO.AT_ID, messageHeaderInstanceId);
command.Parameters.AddWithValue(MessageBucketDAO.AT_MESSAGE_CONTROL_ID, messageControlId);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
isProcessed = DAOUtility.GetData <bool>(reader, MessageBucketDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "reprocessMessage(int messageHeaderInstanceId, string messageControlId)", messageHeaderInstanceId.ToString() + "|" + messageControlId);
}
}
return(isProcessed);
}
private static Broker postUpdateBroker(Broker broker)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_BROKER;
command.Parameters.AddWithValue(BrokerDAO.AT_INTERFACE_STATUS_ID, broker.interfaceStatusId);
command.Parameters.AddWithValue(BrokerDAO.AT_COMMUNICATION_ID, broker.communicationId);
command.Parameters.AddWithValue(BrokerDAO.PROCESS_ID, broker.processId);
command.Parameters.AddWithValue(BrokerDAO.LAST_MESSAGE_ID, broker.lastMessageId);
command.Parameters.AddWithValue(BrokerDAO.QUEUE_COUNT, broker.queueCount);
command.Parameters.AddWithValue(BrokerDAO.LAST_MESSAGE_DTTM, broker.lastMessageDTTM);
command.Parameters.AddWithValue(BrokerDAO.AT_ID, broker.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
broker.id = DAOUtility.GetData <int>(reader, BrokerDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateBroker()", broker.id.ToString());
}
}
return(broker);
}
private static DatabaseInstance postUpdateDatabaseInstance(DatabaseInstance databaseInstance)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_DATABASE_INSTANCE;
command.Parameters.AddWithValue(DatabaseInstanceDAO.COMMUNICATION_ID, databaseInstance.communicationId);
command.Parameters.AddWithValue(DatabaseInstanceDAO.CREDENTIAL_ID, databaseInstance.credentialId);
command.Parameters.AddWithValue(DatabaseInstanceDAO.NAME, databaseInstance.name);
command.Parameters.AddWithValue(DatabaseInstanceDAO.SERVER, databaseInstance.server);
command.Parameters.AddWithValue(DatabaseInstanceDAO.IP_ADDRESS, databaseInstance.ipAddress);
command.Parameters.AddWithValue(DatabaseInstanceDAO.AT_ID, databaseInstance.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
databaseInstance.id = DAOUtility.GetData <int>(reader, DatabaseInstanceDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateDatabaseInstance()", databaseInstance.id.ToString());
}
}
return(databaseInstance);
}
private static ColumnSet postUpdateColumnSet(ColumnSet columnSet)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_COLUMN_SET;
command.Parameters.AddWithValue(ColumnSetDAO.AT_DATABASE_TABLE_ID, columnSet.databaseTableId);
command.Parameters.AddWithValue(ColumnSetDAO.AT_NAME, columnSet.name);
command.Parameters.AddWithValue(ColumnSetDAO.AT_MESSAGE_GROUP_INSTANCE_ID, columnSet.messageGroupInstanceId);
command.Parameters.AddWithValue(ColumnSetDAO.AT_IS_PRIMAR_KEY, columnSet.isPrimaryKey);
command.Parameters.AddWithValue(ColumnSetDAO.AT_COLUMN_DATA_TYPE, columnSet.columnDataType);
command.Parameters.AddWithValue(ColumnSetDAO.AT_ID, columnSet.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
columnSet.id = DAOUtility.GetData <int>(reader, ColumnSetDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateColumnSet()", columnSet.name);
}
}
return(columnSet);
}
private static Interface postUpdateInterface(Interface _interface)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_INTERFACE;
command.Parameters.AddWithValue(InterfaceDAO.AT_COMMUNICATION_ID, _interface.communicationId);
command.Parameters.AddWithValue(InterfaceDAO.AT_CREDENTIAL_ID, _interface.credentialId);
command.Parameters.AddWithValue(InterfaceDAO.AT_IP_ADDRESS, _interface.ipAddress);
command.Parameters.AddWithValue(InterfaceDAO.AT_PORT, _interface.port);
command.Parameters.AddWithValue(InterfaceDAO.AT_MAX_CONNECTIONS, _interface.maxConnections);
command.Parameters.AddWithValue(InterfaceDAO.AT_ID, _interface.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_interface.id = DAOUtility.GetData <int>(reader, InterfaceDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateInterface()", _interface.id.ToString());
}
}
return(_interface);
}
private static ApplicationSetting postUpdateApplicationSetting(ApplicationSetting applicationSetting)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_APPLICATION_SETTING;
command.Parameters.AddWithValue(ApplicationSettingDAO.AT_APPLICATION_ID, applicationSetting.applicationId);
command.Parameters.AddWithValue(ApplicationSettingDAO.AT_COMMUNICATION_ID, applicationSetting.communicationId);
command.Parameters.AddWithValue(ApplicationSettingDAO.AT_DISABLED, applicationSetting.disabled);
command.Parameters.AddWithValue(ApplicationSettingDAO.AT_AUTOSTART, applicationSetting.autoStart);
command.Parameters.AddWithValue(ApplicationSettingDAO.AT_ID, applicationSetting.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
applicationSetting.id = DAOUtility.GetData <int>(reader, ApplicationSettingDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateApplicationSetting()", applicationSetting.id.ToString());
}
}
return(applicationSetting);
}
public static List <MessageBucket> GetProcessedMessageHeaderInstancesByApplication(Application application)
{
List <MessageBucket> brokerMessages = new List <MessageBucket>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
// set process flag
bool isProcessed = true;
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.SERVICE_VIEW_GET_MESSAGE_HEADER_INSTANCES;
command.Parameters.AddWithValue(MessageBucketDAO.AT_MHI_SENDING_APPLICATION, application.name);
command.Parameters.AddWithValue(MessageBucketDAO.AT_MHI_PROCESSED, isProcessed);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
brokerMessages.Add(new MessageBucket(reader,
MessageBucket.View.GetMessageHeaderInstances));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "GetProcessedMessageHeaderInstancesByApplication(Application application)", application.id.ToString());
}
}
return(brokerMessages);
}
private static WebservicePropertySet postUpdateWebservicePropertySet(WebservicePropertySet webservicePropertySet)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_WEBSERVICE_PROPERTY;
command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_WEBSERVICE_OBJECT_ID, webservicePropertySet.webserviceObjectId);
command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_NAME, webservicePropertySet.name);
command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_MESSAGE_GROUP_INSTANCE_ID, webservicePropertySet.messageGroupInstanceId);
command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_COLUMN_DATA_TYPE, webservicePropertySet.columnDataType);
command.Parameters.AddWithValue(WebservicePropertySetDAO.AT_ID, webservicePropertySet.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webservicePropertySet.id = DAOUtility.GetData <int>(reader, WebservicePropertySetDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateWebservicePropertySet()", webservicePropertySet.name);
}
}
return(webservicePropertySet);
}
private static MessageHeaderInstance updateMessageHeaderInstanceToProcessed(MessageHeaderInstance messageHeaderInstance,
Message message,
bool isReprocess = false)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.UPDATE_MESSAGE_HEADER_INSTANCE_PROCESS;
command.Parameters.AddWithValue(MessageHeaderInstanceDAO.AT_ID, messageHeaderInstance.id);
command.Parameters.AddWithValue(MessageHeaderInstanceDAO.AT_MESSAGE_ID, message.id);
command.Parameters.AddWithValue(MessageHeaderInstanceDAO.AT_ISREPROCESS, isReprocess);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
messageHeaderInstance.id = DAOUtility.GetData <int>(reader, MessageHeaderInstanceDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "updateMessageHeaderInstanceToProcessed()", messageHeaderInstance.id.ToString());
}
}
return(messageHeaderInstance);
}
private static Communication postUpdateCommunication(Communication communication)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_COMMUNICATION;
command.Parameters.AddWithValue(CommunicationDAO.AT_DIRECTION_TYPE_ID, communication.directionTypeId);
command.Parameters.AddWithValue(CommunicationDAO.AT_COMMUNICATION_TYPE_ID, communication.communicationTypeId);
command.Parameters.AddWithValue(CommunicationDAO.AT_APPLICATION_ID, communication.applicationId);
command.Parameters.AddWithValue(CommunicationDAO.AT_ID, communication.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
communication.id = DAOUtility.GetData <int>(reader, CommunicationDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateCommunication()", communication.id.ToString());
}
}
return(communication);
}
private static MessageGroup postUpdateMessageGroup(MessageGroup messageGroup)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_MESSAGE_GROUP;
command.Parameters.AddWithValue(MessageGroupDAO.AT_MESSAGE_GROUP_INSTANCE_ID, messageGroup.messageGroupInstanceId);
command.Parameters.AddWithValue(MessageGroupDAO.AT_MESSAGE_PART_ID, messageGroup.messagePartId);
command.Parameters.AddWithValue(MessageGroupDAO.AT_POSITION, messageGroup.position);
command.Parameters.AddWithValue(MessageGroupDAO.AT_ID, messageGroup.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
messageGroup.id = DAOUtility.GetData <int>(reader, MessageGroupDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateMessageGroup()", messageGroup.id.ToString());
}
}
return(messageGroup);
}
private static Credential postUpdateCredential(Credential credential)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_CREDENTIAL;
command.Parameters.AddWithValue(CredentialDAO.AT_CREDENTIAL_TYPE_ID, credential.credentialTypeId);
command.Parameters.AddWithValue(CredentialDAO.AT_USERNAME, credential.username);
command.Parameters.AddWithValue(CredentialDAO.AT_PASSWORD, credential.password);
command.Parameters.AddWithValue(CredentialDAO.AT_ID, credential.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
credential.id = DAOUtility.GetData <int>(reader, CredentialDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateCredential()", credential.id.ToString());
}
}
return(credential);
}
private static DatabaseTableRelation postUpdateDatabaseTableRelation(DatabaseTableRelation databaseTableRelation)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_DATABASE_TABLE_RELATION;
command.Parameters.AddWithValue(DatabaseTableRelationDAO.SOURCE_DATABASE_TABLE_ID, databaseTableRelation.sourceDatabaseTableId);
command.Parameters.AddWithValue(DatabaseTableRelationDAO.TARGET_DATABASE_TABLE_ID, databaseTableRelation.targetDatabaseTableId);
command.Parameters.AddWithValue(DatabaseTableRelationDAO.REQUIRES_IDENTITY, databaseTableRelation.requiresIdentity);
command.Parameters.AddWithValue(DatabaseTableRelationDAO.AT_ID, databaseTableRelation.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
databaseTableRelation.id = DAOUtility.GetData <int>(reader, DatabaseTableDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateDatabaseTableRelation()", databaseTableRelation.id.ToString());
}
}
return(databaseTableRelation);
}
private static void updateProcessIdentity(Broker broker)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
try
{
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
SqlCommand command = new SqlCommand();
conn.Open();
command.Connection = conn;
command.CommandText = das.UPDATE_PROCESS_IDENTITY;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(BrokerDAO.AT_PROCESS_ID, broker.processId);
command.Parameters.AddWithValue(BrokerDAO.AT_ID, broker.id);
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex, "BrokerDAO.updateProcessIdentity(Broker broker", broker.id.ToString());
}
}
private static Application postUpdateApplication(Application application)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_APPLICATION;
command.Parameters.AddWithValue(ApplicationDAO.AT_NAME, application.name);
command.Parameters.AddWithValue(ApplicationDAO.AT_DESCRIPTION, application.description);
command.Parameters.AddWithValue(ApplicationDAO.AT_ID, application.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
application.id = DAOUtility.GetData <int>(reader, ApplicationDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateApplication()", application.name);
}
}
return(application);
}
private static MessagePart postUpdateMessagePart(MessagePart messagePart)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_MESSAGE_PART;
command.Parameters.AddWithValue(MessagePartDAO.AT_NAME, messagePart.name);
command.Parameters.AddWithValue(MessagePartDAO.AT_DELIMITER, messagePart.delimiter);
command.Parameters.AddWithValue(MessagePartDAO.AT_ID, messagePart.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
messagePart.id = DAOUtility.GetData <int>(reader, MessagePartDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateMessagePart()", messagePart.id.ToString());
}
}
return(messagePart);
}
