private async void OnApiConnectionError(AppListViewModel viewModel)
{
if (await DisplayAlert("Connection error", "Cannot connect to Mobile Center API.", "Configure key", "Cancel"))
{
await Navigation.PushAsync(new SettingsPage());
}
}
public IActionResult Index()
{
AppListViewModel vm = _appBiz.Initialize().Data;
vm.Search.CategoryList = new SelectList(_appBiz.GetCategory().Data, "Category", "Category_Name");
return(View(vm));
}
public AppEventTriggerViewModel(AppEventTrigger trigger) : base(trigger)
{
Option = new OptionViewModel(trigger, nameof(trigger.Option));
Device = new DeviceListViewModel(trigger, DeviceListViewModel.DeviceListKind.DefaultPlayback);
App = new AppListViewModel(trigger, AppListViewModel.AppKind.Default);
Attach(Option);
Attach(Device);
Attach(App);
}
/// <summary>
/// 第一次web 載入預設收尋
/// </summary>
/// <returns></returns>
public TResult <AppListViewModel> Initialize()
{
List <AppListItem> appListItem = _appListService.InitGetAppList();
AppListViewModel viewModel = new AppListViewModel
{
Search = new AppListSearchRequest(),
AppList = appListItem
};
return(TResult <AppListViewModel> .OK(viewModel, "OK"));
}
public SetAppMuteActionViewModel(SetAppMuteAction action) : base(action)
{
_action = action;
Option = new OptionViewModel(action, nameof(action.Option));
App = new AppListViewModel(action, AppListViewModel.AppKind.EveryApp | AppListViewModel.AppKind.ForegroundApp);
Device = new DeviceListViewModel(action, DeviceListViewModel.DeviceListKind.DefaultPlayback);
Attach(Option);
Attach(App);
Attach(Device);
}
/// <summary>
/// search 條件
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public TResult <AppListViewModel> SearchAppList(AppListSearchRequest request)
{
string sqlAppendStr = "";
DynamicParameters parameters = new DynamicParameters();
//AppName
if (!string.IsNullOrEmpty(request.AppName))
{
sqlAppendStr += @"AND LOWER(apList.AppName) LIKE LOWER(@AppName) ";
parameters.Add(@"@AppName", "%" + request.AppName.ToLower().Trim() + "%", DbType.String);
}
//Category
if (!string.IsNullOrEmpty(request.Category))
{
if (request.Category != "All" && request.Category != "None")
{
sqlAppendStr += @"AND apList.Category = @Category ";
parameters.Add(@"@Category", request.Category.Trim(), DbType.String);
}
}
//Version
if (!string.IsNullOrEmpty(request.Version))
{
sqlAppendStr += @"AND apOs.Version LIKE @Version ";
parameters.Add(@"@Version", "%" + request.Version.Trim() + "%", DbType.String);
}
//Status
if (!string.IsNullOrEmpty(request.Enable))
{
if (request.Enable != "All" && request.Enable != "None")
{
sqlAppendStr += @"AND apOs.Status =@Status ";
parameters.Add(@"@Status", request.Enable.Trim(), DbType.String);
}
}
//同時傳入這兩個參數 StartDate & EndDate 才要組這串 between 條件
if (!string.IsNullOrEmpty(request.StartDate?.ToString()) && !string.IsNullOrEmpty(request.EndDate?.ToString()))
{
sqlAppendStr += @"AND(apOs.CreateDT >= @StartDate AND apOs.CreateDT <= @EndDate) ";
parameters.Add(@"@StartDate", request.StartDate, DbType.DateTime);
parameters.Add(@"@EndDate", request.EndDate.Value.AddHours(23).AddMinutes(59).AddSeconds(59).AddMilliseconds(999), DbType.DateTime);
}
else
{
if (!string.IsNullOrEmpty(request.StartDate?.ToString()))
{
sqlAppendStr += @"AND apOs.CreateDT >= @StartDate ";
parameters.Add(@"@StartDate", request.StartDate, DbType.DateTime);
}
if (!string.IsNullOrEmpty(request.EndDate?.ToString()))
{
sqlAppendStr += @"AND apOs.CreateDT <= @EndDate ";
parameters.Add(@"@EndDate", request.EndDate.Value.AddHours(23).AddMinutes(59).AddSeconds(59).AddMilliseconds(999), DbType.DateTime);
}
}
sqlAppendStr += @" ORDER BY apList.IsTop DESC, apOs.CreateDT DESC, apList.AppID DESC ";
List <AppListItem> appListItem = _appListService.GetAppList(sqlAppendStr, parameters);
AppListViewModel viewModel = new AppListViewModel
{
Search = request,
AppList = appListItem
};
return(TResult <AppListViewModel> .OK(viewModel, "OK"));
}
