public TakeRateParameters()
{
Action = TakeRateDataItemAction.NotSet;
Changeset = new EmptyFdpChangeset();
MarketReviewStatus = MarketReviewStatus.NotSet;
Mode = TakeRateResultMode.PercentageTakeRate;
}
public TakeRateParameters()
{
Action = TakeRateDataItemAction.NotSet;
Changeset = new EmptyFdpChangeset();
MarketReviewStatus = MarketReviewStatus.NotSet;
Mode = TakeRateResultMode.PercentageTakeRate;
}
public FdpChangeset FdpChangesetRevert(TakeRateFilter filter)
{
FdpChangeset retVal = new EmptyFdpChangeset();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@DocumentId", filter.DocumentId, DbType.Int32);
para.Add("@CDSID", CurrentCDSID, DbType.String);
var results = conn.QueryMultiple("dbo.Fdp_Changeset_Revert", para, commandType: CommandType.StoredProcedure);
var firstResultSet = results.Read<FdpChangeset>();
if (firstResultSet == null)
{
return retVal;
}
retVal = firstResultSet.First();
var secondResultSet = results.Read<DataChange>();
if (secondResultSet == null)
{
return retVal;
}
retVal.Changes = secondResultSet.ToList();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpChangeset FdpChangesetSave(TakeRateFilter filter, FdpChangeset changeSetToSave)
{
FdpChangeset retVal = new EmptyFdpChangeset();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@FdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
para.Add("@MarketId", filter.MarketId, DbType.Int32);
var results = conn.Query<FdpChangeset>("dbo.Fdp_Changeset_Save", para, commandType: CommandType.StoredProcedure);
var fdpChangesets = results as IList<FdpChangeset> ?? results.ToList();
if (fdpChangesets.Any())
{
retVal = fdpChangesets.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpChangeset FdpLatestUnsavedChangesetByUserGetMany(TakeRateFilter filter)
{
FdpChangeset retVal = new EmptyFdpChangeset();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
para.Add("@MarketId", filter.MarketId, DbType.Int32);
para.Add("@CDSID", CurrentCDSID, DbType.String);
para.Add("@IsSaved", false, DbType.Boolean);
// First resultset is the header information
var results = conn.QueryMultiple("dbo.Fdp_Changeset_GetLatestByUser", para, commandType: CommandType.StoredProcedure);
var firstResultSet = results.Read<FdpChangeset>();
var fdpChangesets = firstResultSet as IList<FdpChangeset> ?? firstResultSet.ToList();
if (firstResultSet == null || !fdpChangesets.Any())
{
return retVal;
}
retVal = fdpChangesets.First();
// Second resultset contains the data changes themselves
var secondResultSet = results.Read<DataChange>();
if (secondResultSet != null)
{
retVal.Changes = secondResultSet.ToList();
}
// Third dataset contains the model mix
var thirdResultSet = results.Read<AllModelMix>();
if (thirdResultSet != null && thirdResultSet.Any())
{
retVal.ModelMix = thirdResultSet.ToList().First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpChangeset FdpChangesetGet(FdpChangeset changesetToGet)
{
FdpChangeset retVal = new EmptyFdpChangeset();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpChangesetId", changesetToGet.FdpChangesetId, DbType.Int32);
// First resultset is the header information
var results = conn.QueryMultiple("dbo.Fdp_Changeset_Get", para, commandType: CommandType.StoredProcedure);
var firstResultSet = results.Read<FdpChangeset>();
var fdpChangesets = firstResultSet as IList<FdpChangeset> ?? firstResultSet.ToList();
if (firstResultSet == null || !fdpChangesets.Any())
{
return retVal;
}
retVal = fdpChangesets.First();
// Second resultset contains the data changes themselves
var secondResultSet = results.Read<DataChange>();
if (secondResultSet != null)
{
retVal.Changes = secondResultSet.ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
