public FdpFeature FdpFeatureSave(FdpFeature feature) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@ProgrammeId", feature.ProgrammeId.GetValueOrDefault(), DbType.Int32); para.Add("@Gateway", feature.Gateway, DbType.String); para.Add("@FeatureCode", feature.FeatureCode, DbType.String); para.Add("@FeatureGroupId", feature.FeatureGroupId, DbType.Int32); para.Add("@FeatureDescription", feature.BrandDescription, DbType.String); retVal = conn.Query <FdpFeature>("dbo.Fdp_Feature_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public TakeRateDataItem() { Notes = Enumerable.Empty<TakeRateDataItemNote>(); History = Enumerable.Empty<TakeRateDataItemAudit>(); Model = new EmptyFdpModel(); Feature = new EmptyFdpFeature(); HasUncommittedChanges = false; }
public TakeRateDataItem() { Notes = Enumerable.Empty <TakeRateDataItemNote>(); History = Enumerable.Empty <TakeRateDataItemAudit>(); Model = new EmptyFdpModel(); Feature = new EmptyFdpFeature(); HasUncommittedChanges = false; }
private void InitialiseMembers() { Feature = new EmptyFdpFeature(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty <Programme>(); Gateways = Enumerable.Empty <Gateway>(); CarLines = Enumerable.Empty <CarLine>(); ModelYears = Enumerable.Empty <ModelYear>(); CurrentAction = FeatureAction.NotSet; }
private static async Task <FdpFeature> HydrateCurrentFeature(IDataContext context, TakeRateViewModel takeRateModel) { FdpFeature feature = new EmptyFdpFeature(); if (takeRateModel.CurrentTakeRateDataItem.FeatureId.HasValue) { feature = takeRateModel.Document.Vehicle.AvailableFeatures.First(f => f.Id == takeRateModel.CurrentTakeRateDataItem.FeatureId.Value); } else if (takeRateModel.CurrentTakeRateDataItem.FdpFeatureId.HasValue) { feature = takeRateModel.Document.Vehicle.AvailableFeatures.First(f => f.FdpFeatureId == takeRateModel.CurrentTakeRateDataItem.FdpFeatureId.Value); } takeRateModel.CurrentTakeRateDataItem.Feature = feature; return(await Task.FromResult(feature)); }
public FdpFeature FdpFeatureGet(FeatureFilter filter) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpFeatureId", filter.FeatureId.GetValueOrDefault(), DbType.Int32); retVal = conn.Query <FdpFeature>("dbo.Fdp_Feature_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpFeature FdpFeatureDelete(FdpFeature featureToDelete) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@FdpFeatureId", featureToDelete.FdpFeatureId.GetValueOrDefault(), DbType.Int32); retVal = conn.Query <FdpFeature>("dbo.Fdp_Feature_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public FdpFeature FdpFeatureSave(FdpFeature feature) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@ProgrammeId", feature.ProgrammeId.GetValueOrDefault(), DbType.Int32); para.Add("@Gateway", feature.Gateway, DbType.String); para.Add("@FeatureCode", feature.FeatureCode, DbType.String); para.Add("@FeatureGroupId", feature.FeatureGroupId, DbType.Int32); para.Add("@FeatureDescription", feature.BrandDescription, DbType.String); retVal = conn.Query<FdpFeature>("dbo.Fdp_Feature_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpFeature FdpFeatureGet(FeatureFilter filter) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpFeatureId", filter.FeatureId.GetValueOrDefault(), DbType.Int32); retVal = conn.Query<FdpFeature>("dbo.Fdp_Feature_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpFeature FdpFeatureDelete(FdpFeature featureToDelete) { FdpFeature retVal = new EmptyFdpFeature(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@FdpFeatureId", featureToDelete.FdpFeatureId.GetValueOrDefault(), DbType.Int32); retVal = conn.Query<FdpFeature>("dbo.Fdp_Feature_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
private static async Task<FdpFeature> HydrateCurrentFeature(IDataContext context, TakeRateViewModel takeRateModel) { FdpFeature feature = new EmptyFdpFeature(); if (takeRateModel.CurrentTakeRateDataItem.FeatureId.HasValue) { feature = takeRateModel.Document.Vehicle.AvailableFeatures.First(f => f.Id == takeRateModel.CurrentTakeRateDataItem.FeatureId.Value); } else if (takeRateModel.CurrentTakeRateDataItem.FdpFeatureId.HasValue) { feature = takeRateModel.Document.Vehicle.AvailableFeatures.First(f => f.FdpFeatureId == takeRateModel.CurrentTakeRateDataItem.FdpFeatureId.Value); } takeRateModel.CurrentTakeRateDataItem.Feature = feature; return await Task.FromResult(feature); }
private void InitialiseMembers() { Feature = new EmptyFdpFeature(); IdentifierPrefix = "Page"; Programmes = Enumerable.Empty<Programme>(); Gateways = Enumerable.Empty<Gateway>(); CarLines = Enumerable.Empty<CarLine>(); ModelYears = Enumerable.Empty<ModelYear>(); CurrentAction = FeatureAction.NotSet; }