private static async Task<TrimViewModel> GetFullAndPartialViewModelForTrim(IDataContext context, TrimFilter filter) { var model = new TrimViewModel() { PageIndex = filter.PageIndex.HasValue ? filter.PageIndex.Value : 1, PageSize = filter.PageSize.HasValue ? filter.PageSize.Value : Int32.MaxValue, Configuration = context.ConfigurationSettings }; var trim = await context.Vehicle.GetFdpTrim(filter); var programmeFilter = new ProgrammeFilter() { ProgrammeId = trim.ProgrammeId, Gateway = trim.Gateway }; HydrateModelWithCommonProperties(model, context, programmeFilter); if (!(trim is EmptyFdpTrim)) { trim.Programme = model.Programmes.FirstOrDefault(p => p.Id == trim.ProgrammeId); } model.Trim = trim; return model; }
private static TrimViewModel GetFullAndPartialViewModel(IDataContext context, TrimFilter filter) { var model = new TrimViewModel(SharedModelBase.GetBaseModel(context)) { Configuration = context.ConfigurationSettings, }; HydrateModelWithCommonProperties(model, context); return model; }
public IEnumerable<FdpTrimMapping> ModelTrimOxoTrimGetMany(TrimFilter filter) { filter.PageSize = 0; var trim = FdpTrimMappingGetMany(filter); if (trim == null || trim.CurrentPage == null || !trim.CurrentPage.Any()) { return Enumerable.Empty<FdpTrimMapping>(); } return trim.CurrentPage.Where(d => !d.FdpTrimMappingId.HasValue); }
public static async Task<TrimViewModel> GetModel(IDataContext context, TrimFilter trimFilter) { TrimViewModel model = null; if (trimFilter.Action == TrimAction.Delete || trimFilter.Action == TrimAction.Trim) { model = await GetFullAndPartialViewModelForTrim(context, trimFilter); } else if (trimFilter.Action == TrimAction.TrimLevels) { model = await GetFullAndPartialViewModelForTrims(context, trimFilter); } else { model = GetFullAndPartialViewModel(context, trimFilter); } if (trimFilter.Action != TrimAction.NotSet) { model.IdentifierPrefix = Enum.GetName(trimFilter.Action.GetType(), trimFilter.Action); } return model; }
public async Task<PagedResults<FdpTrim>> ListFdpTrims(TrimFilter filter) { return await Task.FromResult(_trimDataStore.FdpTrimGetMany(filter)); }
public async Task<FdpTrim> GetFdpTrim(TrimFilter filter) { return await Task.FromResult(_trimDataStore.FdpTrimGet(filter)); }
public IEnumerable<FdpTrimMapping> ListOxoTrim(TrimFilter filter) { filter.PageSize = 0; return _trimDataStore.ModelTrimOxoTrimGetMany(filter); }
public IEnumerable<FdpTrimMapping> ListTrim(TrimFilter filter) { return _trimDataStore.ModelTrimGetMany(filter); }
private static async Task<TrimViewModel> GetFullAndPartialViewModelForTrims(IDataContext context, TrimFilter filter) { var baseModel = SharedModelBase.GetBaseModel(context); var model = new TrimViewModel() { PageIndex = filter.PageIndex.HasValue ? filter.PageIndex.Value : 1, PageSize = filter.PageSize.HasValue ? filter.PageSize.Value : Int32.MaxValue, Configuration = context.ConfigurationSettings, CurrentUser = baseModel.CurrentUser, CurrentVersion = baseModel.CurrentVersion }; var programmeFilter = new ProgrammeFilter() { ProgrammeId = filter.ProgrammeId, Gateway = filter.Gateway }; HydrateModelWithCommonProperties(model, context, programmeFilter); model.Trims = await context.Vehicle.ListFdpTrims(filter); model.TotalPages = model.Trims.TotalPages; model.TotalRecords = model.Trims.TotalRecords; model.TotalDisplayRecords = model.Trims.TotalDisplayRecords; foreach (var trim in model.Trims.CurrentPage) { trim.Programme = model.Programmes.FirstOrDefault(p => p.Id == trim.ProgrammeId); } return model; }
public PagedResults<FdpTrimMapping> FdpTrimMappingGetMany(TrimFilter filter) { PagedResults<FdpTrimMapping> retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); var totalRecords = 0; var totalDisplayRecords = 0; if (!string.IsNullOrEmpty(filter.CarLine)) { para.Add("@CarLine", filter.CarLine, DbType.String); } if (!string.IsNullOrEmpty(filter.ModelYear)) { para.Add("@ModelYear", filter.ModelYear, DbType.String); } if (!string.IsNullOrEmpty(filter.Gateway)) { para.Add("@Gateway", filter.Gateway, DbType.String); } para.Add("@DocumentId", filter.DocumentId, DbType.Int32); if (!string.IsNullOrEmpty(filter.Dpck)) { para.Add("@DPCK", filter.Dpck, DbType.String); } if (filter.IncludeAllTrim) { para.Add("@IncludeAllTrim", filter.IncludeAllTrim, DbType.Boolean); } if (filter.OxoTrimOnly) { para.Add("@OxoTrimOnly", filter.OxoTrimOnly, DbType.Boolean); } if (filter.IgnoreBMC) { para.Add("@IgnoreBMC", filter.IgnoreBMC, DbType.Boolean); } if (filter.PageIndex.HasValue) { para.Add("@PageIndex", filter.PageIndex.Value, DbType.Int32); } if (filter.PageSize.HasValue) { para.Add("@PageSize", filter.PageSize.HasValue ? filter.PageSize.Value : 10, DbType.Int32); } if (filter.SortIndex.HasValue) { para.Add("@SortIndex", filter.SortIndex.Value, DbType.Int32); } if (filter.SortDirection != SortDirection.NotSet) { var direction = filter.SortDirection == SortDirection.Descending ? "DESC" : "ASC"; para.Add("@SortDirection", direction, DbType.String); } para.Add("@TotalPages", dbType: DbType.Int32, direction: ParameterDirection.Output); para.Add("@TotalRecords", dbType: DbType.Int32, direction: ParameterDirection.Output); para.Add("@TotalDisplayRecords", dbType: DbType.Int32, direction: ParameterDirection.Output); var results = conn.Query<FdpTrimMapping>("dbo.Fdp_TrimMapping_GetMany", para, commandType: CommandType.StoredProcedure); if (results.Any()) { totalRecords = para.Get<int>("@TotalRecords"); totalDisplayRecords = para.Get<int>("@TotalDisplayRecords"); } retVal = new PagedResults<FdpTrimMapping> { PageIndex = filter.PageIndex.HasValue ? filter.PageIndex.Value : 1, TotalRecords = totalRecords, TotalDisplayRecords = totalDisplayRecords, PageSize = filter.PageSize.HasValue ? filter.PageSize.Value : totalRecords }; var currentPage = results.ToList(); retVal.CurrentPage = currentPage; } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public PagedResults<FdpTrim> FdpTrimGetMany(TrimFilter filter) { PagedResults<FdpTrim> retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); var totalRecords = 0; var totalDisplayRecords = 0; if (!string.IsNullOrEmpty(filter.CarLine)) { para.Add("@CarLine", filter.CarLine, DbType.String); } if (!string.IsNullOrEmpty(filter.ModelYear)) { para.Add("@ModelYear", filter.ModelYear, DbType.String); } if (!string.IsNullOrEmpty(filter.Gateway)) { para.Add("@Gateway", filter.Gateway, DbType.String); } if (filter.PageIndex.HasValue) { para.Add("@PageIndex", filter.PageIndex.Value, DbType.Int32); } if (filter.PageSize.HasValue) { para.Add("@PageSize", filter.PageSize.HasValue ? filter.PageSize.Value : 10, DbType.Int32); } if (filter.SortIndex.HasValue) { para.Add("@SortIndex", filter.SortIndex.Value, DbType.Int32); } if (filter.SortDirection != SortDirection.NotSet) { var direction = filter.SortDirection == SortDirection.Descending ? "DESC" : "ASC"; para.Add("@SortDirection", direction, DbType.String); } if (filter.ProgrammeId.HasValue) { para.Add("@ProgrammeId", filter.ProgrammeId, DbType.Int32); } if (!string.IsNullOrEmpty(filter.Gateway)) { para.Add("@Gateway", filter.Gateway, DbType.String); } para.Add("@TotalPages", dbType: DbType.Int32, direction: ParameterDirection.Output); para.Add("@TotalRecords", dbType: DbType.Int32, direction: ParameterDirection.Output); para.Add("@TotalDisplayRecords", dbType: DbType.Int32, direction: ParameterDirection.Output); var results = conn.Query<FdpTrim>("dbo.Fdp_Trim_GetMany", para, commandType: CommandType.StoredProcedure); if (results.Any()) { totalRecords = para.Get<int>("@TotalRecords"); totalDisplayRecords = para.Get<int>("@TotalDisplayRecords"); } retVal = new PagedResults<FdpTrim> { PageIndex = filter.PageIndex.HasValue ? filter.PageIndex.Value : 1, TotalRecords = totalRecords, TotalDisplayRecords = totalDisplayRecords, PageSize = filter.PageSize.HasValue ? filter.PageSize.Value : totalRecords }; var currentPage = new List<FdpTrim>(); foreach (var result in results) { currentPage.Add(result); } retVal.CurrentPage = currentPage; } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }
public FdpTrim FdpTrimGet(TrimFilter filter) { FdpTrim retVal = new EmptyFdpTrim(); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@FdpTrimId", filter.TrimId.GetValueOrDefault(), DbType.Int32); retVal = conn.Query<FdpTrim>("dbo.Fdp_Trim_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return retVal; }