public FdpImportErrorExclusion FdpImportErrorExclusionGet(IgnoredExceptionFilter filter)
{
FdpImportErrorExclusion retVal = new EmptyFdpImportErrorExclusion();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorExclusionId", filter.IgnoredExceptionId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query <FdpImportErrorExclusion>("Fdp_ImportErrorExclusion_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpImportErrorExclusion FdpImportErrorExclusionDelete(FdpImportErrorExclusion fdpImportErrorExclusion)
{
FdpImportErrorExclusion retVal = new EmptyFdpImportErrorExclusion();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorExclusionId", fdpImportErrorExclusion.FdpImportErrorExclusionId.GetValueOrDefault(), DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
// Skip the first dataset which is the import queue from a child sproc
var multiple = conn.QueryMultiple("Fdp_ImportErrorExclusion_Delete", para, commandType: CommandType.StoredProcedure);
//multiple.Read();
var results = multiple.Read <FdpImportErrorExclusion>();
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
IgnoredException = new EmptyFdpImportErrorExclusion();
IdentifierPrefix = "Page";
Documents = Enumerable.Empty <OXODoc>();
Programmes = Enumerable.Empty <Programme>();
Bodies = Enumerable.Empty <ModelBody>();
Engines = Enumerable.Empty <ModelEngine>();
Transmissions = Enumerable.Empty <ModelTransmission>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = IgnoredExceptionAction.NotSet;
}
private void InitialiseMembers()
{
IgnoredException = new EmptyFdpImportErrorExclusion();
IdentifierPrefix = "Page";
Documents = Enumerable.Empty<OXODoc>();
Programmes = Enumerable.Empty<Programme>();
Bodies = Enumerable.Empty<ModelBody>();
Engines = Enumerable.Empty<ModelEngine>();
Transmissions = Enumerable.Empty<ModelTransmission>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = IgnoredExceptionAction.NotSet;
}
public FdpImportErrorExclusion FdpImportErrorExclusionGet(IgnoredExceptionFilter filter)
{
FdpImportErrorExclusion retVal = new EmptyFdpImportErrorExclusion();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorExclusionId", filter.IgnoredExceptionId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query<FdpImportErrorExclusion>("Fdp_ImportErrorExclusion_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpImportErrorExclusion FdpImportErrorExclusionDelete(FdpImportErrorExclusion fdpImportErrorExclusion)
{
FdpImportErrorExclusion retVal = new EmptyFdpImportErrorExclusion();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorExclusionId", fdpImportErrorExclusion.FdpImportErrorExclusionId.GetValueOrDefault(), DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
// Skip the first dataset which is the import queue from a child sproc
var multiple = conn.QueryMultiple("Fdp_ImportErrorExclusion_Delete", para, commandType: CommandType.StoredProcedure);
//multiple.Read();
var results = multiple.Read<FdpImportErrorExclusion>();
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
