public async Task <PagedResultDto <MenuListDTO> > GetMenuList(GetMenuListInput data) { try { IQueryable <Menu.Menu> q = null; if (!string.IsNullOrEmpty(data.FilterText)) { q = _menuRepository.GetAll().Where(t => t.Name.Contains(data.FilterText) && t.IsDeleted == false); } else { q = _menuRepository.GetAll().Where(t => t.IsDeleted == false); } var c = await q.CountAsync(); var x = await q.OrderBy(data.Sorting).PageBy(data).ToListAsync(); var r = new PagedResultDto <MenuListDTO>(c, x.MapTo <List <MenuListDTO> >()); return(r); } catch (Exception ex) { throw ex; } }
public async Task <List <MenuDto> > GetListAsync(GetMenuListInput input) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { if (conn.State == ConnectionState.Closed) { await conn.OpenAsync(); } var menus = await conn.QueryAsync <Menu>(sql : "dbo.Menu_Search", param : new { input.Name, input.Type }, commandType : CommandType.StoredProcedure); return(ObjectMapper.Map <List <MenuDto> >(menus)); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Error: " + ex); throw new UserFriendlyException("No data to show"); } }
public async Task <List <MenuDto> > GetFullMenu(GetMenuListInput input) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { if (conn.State == ConnectionState.Closed) { await conn.OpenAsync(); } var menus = await conn.QueryAsync <MenuDto>(sql : "dbo.Menu_Search", param : new { input.Name, input.Type }, commandType : CommandType.StoredProcedure); //var menuQuery = menus.AsQueryable(); foreach (var item in menus) { var num = item.Num; if (num.Contains('.')) { item.NumBeforeComma = int.Parse(num.Split('.')[0]); item.NumAfterComma = int.Parse(num.Split('.')[1]); } else { item.NumBeforeComma = int.Parse(num); item.NumAfterComma = 0; } } var god = new MenuDto(); var menuMap = ObjectMapper.Map <List <MenuDto> >(menus); return(menuMap); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Error: " + ex); throw new UserFriendlyException("No data to show"); } }