public ImportQueue ProcessTakeRateData(ImportQueue importQueue)
{
TakeRateSummary takeRateFile = new EmptyTakeRateSummary();
using (var conn = DbHelper.GetDBConnection())
{
using (var tran = conn.BeginTransaction())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportId", importQueue.ImportId, DbType.Int32);
var results = conn.Query <TakeRateSummary>("dbo.Fdp_ImportData_ProcessTakeRateData", para,
commandType: CommandType.StoredProcedure, commandTimeout: 600, transaction: tran);
var takeRateSummaries = results as IList <TakeRateSummary> ?? results.ToList();
if (results != null && takeRateSummaries.Any())
{
takeRateFile = takeRateSummaries.First();
}
tran.Commit();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
}
var retVal = ImportQueueGet(importQueue.ImportQueueId.GetValueOrDefault());
retVal.TakeRateId = takeRateFile.TakeRateId;
return(retVal);
}
private void InitialiseMembers()
{
TakeRate = new EmptyTakeRateSummary();
TakeRates = new PagedResults <TakeRateSummary>();
Statuses = Enumerable.Empty <TakeRateStatus>();
CurrentTakeRateDataItem = new EmptyTakeRateDataItem();
CurrentAction = TakeRateDataItemAction.NotSet;
IdentifierPrefix = "Page";
Document = new EmptyTakeRateDocument();
MarketReviewStatus = MarketReviewStatus.NotSet;
}
public ImportQueue ImportQueueBulkImportProcess(ImportQueue importQueue)
{
TakeRateSummary takeRateFile = new EmptyTakeRateSummary();
using (var conn = DbHelper.GetDBConnection())
{
using (var tran = conn.BeginTransaction())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportId", importQueue.ImportId, DbType.Int32);
//para.Add("@FdpVolumeHeaderId", null, DbType.Int32, ParameterDirection.Output);
if (importQueue.LineNumber.HasValue)
{
para.Add("@LineNumber", importQueue.LineNumber, DbType.Int32);
}
var results = conn.Query<TakeRateSummary>("dbo.Fdp_ImportData_Process", para,
commandType: CommandType.StoredProcedure, commandTimeout: 600, transaction: tran);
var takeRateSummaries = results as IList<TakeRateSummary> ?? results.ToList();
if (results != null && takeRateSummaries.Any())
{
takeRateFile = takeRateSummaries.First();
}
tran.Commit();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
}
var retVal = ImportQueueGet(importQueue.ImportQueueId.GetValueOrDefault());
retVal.TakeRateId = takeRateFile.TakeRateId;
return retVal;
}
public TakeRateSummary FdpTakeRateHeaderGet(TakeRateFilter filter)
{
TakeRateSummary retVal = new EmptyTakeRateSummary();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
var results = conn.Query<TakeRateSummary>("dbo.Fdp_TakeRateHeader_Get", para, commandType: CommandType.StoredProcedure);
var takeRateDocumentHeaders = results as IList<TakeRateSummary> ?? results.ToList();
if (takeRateDocumentHeaders.Any())
{
retVal = takeRateDocumentHeaders.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public TakeRateSummary FdpTakeRateDataClone(TakeRateFilter filter)
{
TakeRateSummary retVal = new EmptyTakeRateSummary();
using (var conn = DbHelper.GetDBConnection())
{
using (var tran = conn.BeginTransaction())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@SourceFdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
para.Add("@DestinationDocumentId", filter.DocumentId, DbType.Int32);
para.Add("@Comment", filter.Comment.Trim(), DbType.String);
var results = conn.Query<TakeRateSummary>("dbo.Fdp_TakeRateData_Clone",
transaction: tran,
param: para,
commandType: CommandType.StoredProcedure);
if (results != null && results.Any())
{
retVal = results.First();
}
tran.Commit();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
}
return retVal;
}
private void InitialiseMembers()
{
TakeRate = new EmptyTakeRateSummary();
TakeRates = new PagedResults<TakeRateSummary>();
Statuses = Enumerable.Empty<TakeRateStatus>();
CurrentTakeRateDataItem = new EmptyTakeRateDataItem();
CurrentAction = TakeRateDataItemAction.NotSet;
IdentifierPrefix = "Page";
Document = new EmptyTakeRateDocument();
MarketReviewStatus = MarketReviewStatus.NotSet;
}
public FdpOxoDoc()
{
Header = new EmptyTakeRateSummary();
Document = new EmptyOxoDocument();
}
public FdpOxoDoc()
{
Header = new EmptyTakeRateSummary();
Document = new EmptyOxoDocument();
}