public void ForecastComparisonTrimDelete(IForecast forecastToSave,
ForecastTrimMapping mappingToDelete,
IDbConnection connection,
IDbTransaction transaction)
{
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ForecastId", forecastToSave.ForecastId, DbType.Int32);
para.Add("@SystemUser", CurrentCDSID, DbType.String, size: 16);
//para.Add("@ForecastVehicleTrimId", mappingToDelete.ForecastVehicleTrimId, dbType: DbType.Int32);
//para.Add("@ComparisonVehicleProgrammeId", mappingToDelete.ComparisonVehicleProgrammeId, dbType: DbType.Int32);
connection.Execute("Fdp_ForecastComparisonTrim_Delete", para, commandType: CommandType.StoredProcedure, transaction: transaction);
}
catch (Exception ex)
{
AppHelper.LogError("ForecastDataStore.ForecastComparisonTrimDelete", ex.Message, CurrentCDSID);
throw;
}
}
}
public void ForecastComparisonTrimSave(IForecast forecastToSave,
ForecastTrimMapping mappingToSave,
IDbConnection connection,
IDbTransaction transaction)
{
using (DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ForecastId", forecastToSave.ForecastId, DbType.Int32);
para.Add("@SystemUser", CurrentCDSID, DbType.String, size: 16);
//para.Add("@ForecastVehicleTrimId", mappingToSave.ForecastVehicleTrimId, dbType: DbType.Int32);
//para.Add("@ComparisonVehicleProgrammeId", mappingToSave.ComparisonVehicleProgrammeId, dbType: DbType.Int32);
//para.Add("@ComparisonVehicleTrimId", mappingToSave.ComparisonVehicleTrimId.Value, dbType: DbType.Int32);
para.Add("@ForecastComparisonTrimId", null, DbType.Int32, ParameterDirection.Output);
connection.Execute("Fdp_ForecastComparisonTrim_Save", para, commandType: CommandType.StoredProcedure, transaction: transaction);
//if (!mappingToSave.Id.HasValue)
//{
// mappingToSave.Id = para.Get<int>("@ForecastComparisonTrimId");
//}
}
catch (SqlException sqex)
{
AppHelper.LogError("ForecastDataStore.ForecastComparisonTrimSave", sqex.Message, CurrentCDSID);
throw new ApplicationException("Data store error", sqex);
}
catch (ApplicationException ex)
{
AppHelper.LogError("ForecastDataStore.ForecastComparisonTrimSave", ex.Message, CurrentCDSID);
throw;
}
}
}
