public override bool DeleteConditionType(ICoreConditionType conditionType)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ConditionType", "DeleteConditionType");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", conditionType.Id));
command.ExecuteNonQuery();
var result = command.ExecuteNonQuery();
return(result == 0);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public override ICoreConditionType UpdateConditionType(ICoreConditionType conditionType)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ConditionType", "UpdateConditionType");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", conditionType.Id));
command.Parameters.Add(CreateParameter("@name", conditionType.Name));
command.Parameters.Add(CreateParameter("@retro", conditionType.Retro));
command.Parameters.Add(CreateParameter("@retroDistr", conditionType.RetroDistr));
command.Parameters.Add(CreateParameter("@rku", conditionType.Rku));
command.Parameters.Add(CreateParameter("@rkuDistr", conditionType.RkuDistr));
command.ExecuteScalar();
return(conditionType);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public bool DeleteConditionType(ICoreConditionType conditionType)
{
throw new NotImplementedException();
}
public ICoreConditionType UpdateConditionType(ICoreConditionType conditionType)
{
throw new NotImplementedException();
}
public bool DeleteConditionType(ICoreConditionType conditionType)
{
return(_mapper.DeleteConditionType(conditionType));
}
public ICoreConditionType UpdateConditionType(ICoreConditionType conditionType)
{
return(_mapper.UpdateConditionType(conditionType));
}
public abstract bool DeleteConditionType(ICoreConditionType conditionType);
public abstract ICoreConditionType UpdateConditionType(ICoreConditionType conditionType);
