public virtual async Task <IActionResult> GetAll( [FromQuery] int page = 1, [FromQuery] string searchQuery = null, [FromQuery] string orderBy = null, [FromQuery] string orderType = null) { PaginatedList <TEntityViewModel> entitiesResult = await this.GetAllEntitiesPaginatedAsync( page, searchQuery, this.InterceptOrderProperty(orderBy), orderType); TableViewViewModel model = new TableViewViewModel(); model.SingleEntityName = StringFunctions.SplitWordsByCapitalLetters(typeof(TEntity).Name); model.Title = model.SingleEntityName.ToPluralString(); this.ViewData[BreadcrumbPageTitlePlaceholder] = model.Title; model.Table = EntityTableMapper.Map(entitiesResult, this.BuildTableViewActions()?.ToArray()); model.Table.SetPaginationRedirection(this.AreaName, this.ControllerName, this.ActionName); this.ViewData.Add("SearchQuery", searchQuery); this.ViewData.Add("OrderProperties", this.GetOrderProperties()); this.ViewData.Add("OrderBy", orderBy); this.ViewData.Add("OrderType", orderType); this.InitializeNavigationActions(this.BuildTableViewNavigationActions()); return(this.GetAllView(model)); }
public void GetDdlTest4() { var dbVm = new DbViewModel(); var table = new TableViewViewModel("SNOW_LINE", "SELECT CITY, STATE, ALTITUDE FROM CITIES WHERE ALTITUDE > 5000"); dbVm.Tables.Add(table); var col1 = new ColumInfo("CITY", new FieldType(8, null, null, null, null), new ConstraintsInfo(ConstraintsKind.Primary), "SARARY", false); table.Colums.Add(new ColumViewMoodel(col1)); var col2 = new ColumInfo("STATE", new FieldType(37, null, 100, null, null), new ConstraintsInfo(ConstraintsKind.Primary), "NAME", false); table.Colums.Add(new ColumViewMoodel(col2)); var col3 = new ColumInfo("SNOW_ALTITUDE", new FieldType(35, null, null, null, null), new ConstraintsInfo(ConstraintsKind.None), "RDB$3", false); table.Colums.Add(new ColumViewMoodel(col3)); table.GetDdl(dbVm).Is( "CREATE VIEW SNOW_LINE (CITY, STATE, SNOW_ALTITUDE) AS" + Environment.NewLine + "SELECT CITY, STATE, ALTITUDE FROM CITIES WHERE ALTITUDE > 5000"); }
public async Task LoadDatabase(DatabaseInfo dbInf) { _dbInfo = dbInf; var table = new List<ITableViewModel>(); await Task.Run(() => { using (var con = new FbConnection(_dbInfo.ConnectionString)) { con.Open(); foreach (var item in _dbInfo.GetTables(con)) { var vm = new TableViewModel(item.TableName); foreach (var colums in item.GetColums(con)) { vm.Colums.Add(new ColumViewMoodel(colums)); } foreach (var trigger in item.GetTrigger(con)) { vm.Triggers.Add(new TriggerViewModel(trigger)); } foreach (var idx in item.GetIndex(con)) { vm.Indexs.Add(new IndexViewModel(idx)); } table.Add(vm); } foreach (var item in _dbInfo.GetViews(con)) { var vm = new TableViewViewModel(item.ViewName, item.Source); foreach (var colums in item.GetColums(con)) { vm.Colums.Add(new ColumViewMoodel(colums)); } table.Add(vm); } } }); Tables = table; AdditionalInfo = new AdditionalDbInfoControl(this); RaisePropertyChanged(nameof(Tables)); RaisePropertyChanged(nameof(AdditionalInfo)); }
public void GetDdlTest4() { var dbVm = new DbViewModel(); var table = new TableViewViewModel("SNOW_LINE", "SELECT CITY, STATE, ALTITUDE FROM CITIES WHERE ALTITUDE > 5000"); dbVm.Tables.Add(table); var col1 = new ColumInfo("CITY", new FieldType(8, null, null, null, null, 4), new ColumConstraintsInfo(ConstraintsKind.Primary), "SARARY", false, true, ""); table.Colums.Add(new ColumViewMoodel(col1)); var col2 = new ColumInfo("STATE", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.Primary), "NAME", false, true, ""); table.Colums.Add(new ColumViewMoodel(col2)); var col3 = new ColumInfo("SNOW_ALTITUDE", new FieldType(35, null, null, null, null, 8), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$3", false, true, ""); table.Colums.Add(new ColumViewMoodel(col3)); table.GetDdl(dbVm).Is( "CREATE VIEW SNOW_LINE (CITY, STATE, SNOW_ALTITUDE) AS" + Environment.NewLine + "SELECT CITY, STATE, ALTITUDE FROM CITIES WHERE ALTITUDE > 5000"); }
/// <summary> /// Build action result to table view. /// </summary> /// <param name="model"></param> /// <returns></returns> protected virtual IActionResult GetAllView(TableViewViewModel model) { return(this.View("EntityViews/GetAll", model)); }