public Guid InsertOrUpdateTag(TagDTO tag)
{
string spName = "apt_code.SmsAppointmentService.createUpdateTag";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleParameters = TemplateTagQueryParamsHelper.getQPForCreateORUpdateTag(tag);
var newGuid = UpdateAndReturnKey(spName, "l_tagID", oracleParameters, connection);
return(newGuid);
}
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex)
{
s_log.ErrorException("InserOrUpdateATag Fails(Error from Oracle)", ex);
throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex);
}
catch (DBOperationException e)
{
s_log.WarnException("Error Occured in InserOrUpdateATag", e);
throw;
}
catch (Exception ex)
{
s_log.ErrorException("InserOrUpdateATag Fails", ex);
throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex);
}
}
public List <TagDTO> SelectTagsOn(long?departmentId, string keyword, bool active, bool hospitalLevel, long hospitalId)
{
const string spName = "apt_code.SmsAppointmentService.searchTag";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleparams = TemplateTagQueryParamsHelper.GetQPForSearchTagsMoreOptions(departmentId, keyword, active, hospitalLevel, hospitalId);
var resultSet = connection.Query(spName, oracleparams, commandType: CommandType.StoredProcedure);
if (resultSet == null)
{
s_log.Error("searchTag returned empty or null result.");
throw new DBOperationException("searchTag returned empty or null result.", GlobalOptions.DBExceptionScenarios.DBReturnedEmptyOrNullDataSet);
}
var tags = new List <TagDTO>();
foreach (var result in resultSet)
{
var resultDictionary = result as IDictionary <string, object>;
tags.Add(MapToTagDTO(resultDictionary));
}
return(tags);
}
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex)
{
s_log.ErrorException("SelectTagsOn Fails(Error from Oracle)", ex);
throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex);
}
catch (DBOperationException e)
{
s_log.WarnException("Error Occured in SelectTagsOn", e);
throw;
}
catch (Exception ex)
{
s_log.ErrorException("SelectTagsOn Fails", ex);
throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex);
}
}
public TagDTO SelectTagBy(Guid tagId)
{
const string spName = "apt_code.SmsAppointmentService.getTagDetails";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleparams = TemplateTagQueryParamsHelper.GetQPForGetTagByID(tagId);
var resultSet = connection.Query(spName, oracleparams, commandType: CommandType.StoredProcedure);
if (resultSet == null)
{
s_log.Error("getTagDetails returned empty or null result.");
throw new DBOperationException("getTagDetails returned empty or null result.", GlobalOptions.DBExceptionScenarios.DBReturnedEmptyOrNullDataSet);
}
var tags = new List <TagDTO>();
foreach (var result in resultSet)
{
var resultDictionary = result as IDictionary <string, object>;
tags.Add(MapToTagDTO(result));
}
return(tags.FirstOrDefault());
}
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex)
{
s_log.ErrorException("SelectTagBy(Guid tagId) Fails(Error from Oracle)", ex);
throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex);
}
catch (DBOperationException e)
{
s_log.WarnException("Error Occured in SelectTagBy(Guid tagId)", e);
throw;
}
catch (Exception ex)
{
s_log.ErrorException("SelectTagBy(Guid tagId) Fails", ex);
throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex);
}
}