public void DeleteOrganisationKey(OrganisationKey organisationKey)
{
try
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter(OrganisationKeyParameter.ID, GetDBValue(organisationKey.Id))
};
string sqlQuery = string.Format("DELETE FROM {0} WHERE {1} = {2}", TableName,
OrganisationKeyColumn.ID,
OrganisationKeyParameter.ID);
using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(sqlQuery, sqlParameters,
connectionString))
{
mssqlDbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string eMessage = string.Format("Error encountered when executing {0} function in OrganisationKeyRepositoryMsSql. Error\n{1}",
"Delete-OrganisationKey", exception.Message);
WriteErrorLog(eMessage);
throw;
}
}
public void DeleteDispatch(MessageDispatch dispatch)
{
try
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter(MessageDispatchParameter.ID, GetDBValue(dispatch.Id))
};
string sqlQuery = string.Format("DELETE FROM {0} WHERE {1} = {2}", TableName,
MessageDispatchColumn.ID,
MessageDispatchParameter.ID);
using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(sqlQuery, sqlParameters,
connectionString))
{
mssqlDbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string message = string.Format("Error encountered when executing {0} function in MessageDispatchRepositoryMsSql. Error\n{1}",
"Deletedispatch", exception.Message);
WriteErrorLog(message);
throw;
}
}
public void UpdateOrganisationKey(OrganisationKey organisationKey)
{
try
{
Tuple <string, SqlParameter[]> query = GetUpdateOrganisationKeyQuery(organisationKey);
using (MssqlDbEngine dbEngine = GetMssqlDbEngine(query.Item1, query.Item2,
connectionString))
{
dbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string message = string.Format("Error encountered when executing {0} function in OrganisationKeyRepositoryMsSql. Error\n{1}",
"Update-OrganisationKey", exception.ToString());
WriteErrorLog(message);
throw;
}
}
public void UpdateAccess(Access access)
{
try
{
QueryBody query = GetUpdateAccessQuery(access);
using (MssqlDbEngine dbEngine = GetMssqlDbEngine(query.Query, query.Parameters,
connectionString))
{
dbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string message = string.Format("Error encountered when executing {0} function in AccessRepositoryMsSql. Error\n{1}",
"Update-Access", exception.ToString());
WriteErrorLog(message);
throw;
}
}
public void UpdateMessage(Message message) // Tuple<string, TParameter[]> query where TParameter : IDbDataParameter
{
try
{
Tuple <string, SqlParameter[]> query = GetUpdateQuery(message);
using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(query.Item1, query.Item2,
connectionString))
{
mssqlDbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string eMessage = string.Format("Error encountered when executing {0} function in MessageRepositoryMsSql. Error\n{1}",
"UpdateMessage", exception.Message);
WriteErrorLog(eMessage);
throw;
}
}
public void DeleteAuthorisation(Authorisation authorisation)
{
try
{
QueryBody query = GetDeletionAuthorisationQuery(authorisation);
using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(query.Query, query.Parameters,
connectionString))
{
mssqlDbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string message = string.Format("Error encountered when executing {0} in AuthorisationRepositoryMsSql. Error\n{1}",
"Delete-Authorisation",
exception.ToString());
WriteErrorLog(message);
throw;
}
}
public void UpdateDispatch(MessageDispatch dispatch) // Tuple<string, IDbDataParameter[]> query where TParameter : IDbDataParameter
{
try
{
QueryBody queryBody = GetDefaultDispatchUpdateQuery(dispatch);
using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(queryBody.Query, queryBody.Parameters,
connectionString))
{
mssqlDbEngine.ExecuteQuery();
}
}
catch (Exception exception)
{
string message = string.Format("Error encountered when executing {0} function in MessageDispatchRepositoryMsSql. Error\n{1}",
"Updatedispatch", exception.Message);
WriteErrorLog(message);
throw;
}
}