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; } } }