コード例 #1
0
        public static async Task <List <InmateAccountDto> > LoadInmateAccounts(GetInmateArgs args)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.AddSqlParam("@Search", args.Search);
            parameters.AddSqlParam("@FacilityFilters", args.SiteIds);

            return((await SqlHelper.InvokeStoredProcAsync <InmateAccountDto>(ConfigurationManager.ConnectionStrings["ScidynDbConnection"].ToString(),
                                                                             "uspSearchInmateForTypeahead",
                                                                             parameters)).ToList());
        }
        public async Task <IHttpActionResult> LoadInmates(GetInmateArgs args)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    List <InmateAccountDto> result = await DbAccessor.LoadInmateAccounts(args);

                    return(Ok(result));
                }

                return(BadRequest(ModelState));
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Failed to load ");
                return(InternalServerError(ex));
            }
        }