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");
}
}
