public FdpTrimMapping FdpTrimMappingGet(TrimMappingFilter filter) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", filter.TrimMappingId.GetValueOrDefault(), DbType.Int32); var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Get", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpTrimMapping FdpTrimMappingCopy(FdpTrimMapping trimMappingToCopy, IEnumerable <string> gateways) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", trimMappingToCopy.FdpTrimMappingId, DbType.Int32); para.Add("@Gateways", gateways.ToCommaSeperatedList(), DbType.String); para.Add("@CDSId", CurrentCDSID, DbType.String); var rows = conn.Execute("Fdp_TrimMapping_Copy", para, commandType: CommandType.StoredProcedure); retVal = FdpTrimMappingGet(new TrimMappingFilter { TrimMappingId = trimMappingToCopy.FdpTrimMappingId }); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpTrimMapping FdpTrimMappingDelete(FdpTrimMapping trimMappingToDelete) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", trimMappingToDelete.FdpTrimMappingId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Delete", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
private void InitialiseMembers() { TrimMapping = new EmptyFdpTrimMapping(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty <Programme>(); Gateways = Enumerable.Empty <Gateway>(); CarLines = Enumerable.Empty <CarLine>(); ModelYears = Enumerable.Empty <ModelYear>(); CurrentAction = TrimMappingAction.NotSet; }
public FdpTrimMapping TrimMappingSave(FdpTrimMapping trimMapping) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (var conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@ImportTrim", trimMapping.ImportTrim, DbType.String); para.Add("@DocumentId", trimMapping.DocumentId, DbType.Int32); para.Add("@ProgrammeId", trimMapping.ProgrammeId, DbType.Int32); para.Add("@Gateway", trimMapping.Gateway, DbType.String); if (trimMapping.TrimId.HasValue) { para.Add("@TrimId", trimMapping.TrimId.Value, DbType.Int32); } if (trimMapping.FdpTrimId.HasValue) { para.Add("@FdpTrimId", trimMapping.FdpTrimId, DbType.Int32); } var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Save", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
private void InitialiseMembers() { TrimMapping = new EmptyFdpTrimMapping(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty<Programme>(); Gateways = Enumerable.Empty<Gateway>(); CarLines = Enumerable.Empty<CarLine>(); ModelYears = Enumerable.Empty<ModelYear>(); CurrentAction = TrimMappingAction.NotSet; }
public FdpTrimMapping FdpTrimMappingCopy(FdpTrimMapping trimMappingToCopy, IEnumerable<string> gateways) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", trimMappingToCopy.FdpTrimMappingId, DbType.Int32); para.Add("@Gateways", gateways.ToCommaSeperatedList(), DbType.String); para.Add("@CDSId", CurrentCDSID, DbType.String); var rows = conn.Execute("Fdp_TrimMapping_Copy", para, commandType: CommandType.StoredProcedure); retVal = FdpTrimMappingGet(new TrimMappingFilter { TrimMappingId = trimMappingToCopy.FdpTrimMappingId }); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpTrimMapping FdpTrimMappingGet(TrimMappingFilter filter) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", filter.TrimMappingId.GetValueOrDefault(), DbType.Int32); var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Get", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpTrimMapping FdpTrimMappingDelete(FdpTrimMapping trimMappingToDelete) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimMappingId", trimMappingToDelete.FdpTrimMappingId, DbType.Int32); para.Add("@CDSId", CurrentCDSID, DbType.String); var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Delete", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpTrimMapping TrimMappingSave(FdpTrimMapping trimMapping) { FdpTrimMapping retVal = new EmptyFdpTrimMapping(); using (var conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@ImportTrim", trimMapping.ImportTrim, DbType.String); para.Add("@DocumentId", trimMapping.DocumentId, DbType.Int32); para.Add("@ProgrammeId", trimMapping.ProgrammeId, DbType.Int32); para.Add("@Gateway", trimMapping.Gateway, DbType.String); if (trimMapping.TrimId.HasValue) { para.Add("@TrimId", trimMapping.TrimId.Value, DbType.Int32); } if (trimMapping.FdpTrimId.HasValue) { para.Add("@FdpTrimId", trimMapping.FdpTrimId, DbType.Int32); } var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Save", para, commandType: CommandType.StoredProcedure); if (results.Any()) { retVal = results.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }