public FdpSpecialFeatureMapping FdpSpecialFeatureMappingDelete(FdpSpecialFeatureMapping featureMappingToDelete) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", featureMappingToDelete.FdpSpecialFeatureMappingId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var results = conn.Query <FdpSpecialFeatureMapping>("Fdp_SpecialFeatureMapping_Delete", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpSpecialFeatureMapping FdpSpecialFeatureMappingCopy(FdpSpecialFeatureMapping featureMappingToCopy, int targetDocumentId) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", featureMappingToCopy.FdpSpecialFeatureMappingId, DbType.Int32); para.Add("@TargetDocumentId", targetDocumentId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var rows = conn.Execute("Fdp_SpecialFeatureMapping_Copy", para, commandType: CommandType.StoredProcedure); retVal = FdpSpecialFeatureMappingGet(new SpecialFeatureMappingFilter { SpecialFeatureMappingId = featureMappingToCopy.FdpSpecialFeatureMappingId }); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpSpecialFeatureMapping FdpSpecialFeatureMappingGet(SpecialFeatureMappingFilter filter) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", filter.SpecialFeatureMappingId.GetValueOrDefault(), DbType.Int32); var results = conn.Query <FdpSpecialFeatureMapping>("Fdp_SpecialFeatureMapping_Get", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
private void InitialiseMembers() { SpecialFeatureMapping = new EmptyFdpSpecialFeatureMapping(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty <Programme>(); Gateways = Enumerable.Empty <Gateway>(); CarLines = Enumerable.Empty <CarLine>(); ModelYears = Enumerable.Empty <ModelYear>(); CurrentAction = SpecialFeatureMappingAction.NotSet; }
public FdpSpecialFeatureMapping FdpSpecialFeatureMappingDelete(FdpSpecialFeatureMapping featureMappingToDelete) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", featureMappingToDelete.FdpSpecialFeatureMappingId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var results = conn.Query<FdpSpecialFeatureMapping>("Fdp_SpecialFeatureMapping_Delete", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpSpecialFeatureMapping FdpSpecialFeatureMappingGet(SpecialFeatureMappingFilter filter) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", filter.SpecialFeatureMappingId.GetValueOrDefault(), DbType.Int32); var results = conn.Query<FdpSpecialFeatureMapping>("Fdp_SpecialFeatureMapping_Get", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpSpecialFeatureMapping FdpSpecialFeatureMappingCopy(FdpSpecialFeatureMapping featureMappingToCopy, int targetDocumentId) { FdpSpecialFeatureMapping retVal = new EmptyFdpSpecialFeatureMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpSpecialFeatureMappingId", featureMappingToCopy.FdpSpecialFeatureMappingId, DbType.Int32); para.Add("@TargetDocumentId", targetDocumentId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var rows = conn.Execute("Fdp_SpecialFeatureMapping_Copy", para, commandType: CommandType.StoredProcedure); retVal = FdpSpecialFeatureMappingGet(new SpecialFeatureMappingFilter { SpecialFeatureMappingId = featureMappingToCopy.FdpSpecialFeatureMappingId }); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
private void InitialiseMembers() { SpecialFeatureMapping = new EmptyFdpSpecialFeatureMapping(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty<Programme>(); Gateways = Enumerable.Empty<Gateway>(); CarLines = Enumerable.Empty<CarLine>(); ModelYears = Enumerable.Empty<ModelYear>(); CurrentAction = SpecialFeatureMappingAction.NotSet; }