public List <LogUserLoginDTO> GetListWithModel(LogUserLoginDTO searchModel)
        {
            log.MethodStart();

            List <LogUserLoginDTO> objList = new List <LogUserLoginDTO>();

            //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);

            using (var trans = _db.Database.BeginTransaction())
            {
                try
                {
                    objList = _db.LogUserLoginDTOs.FromSqlRaw <LogUserLoginDTO>("sp_GET_LogUserLogin {0}, {1}, {2}", searchModel.log_usr_id, searchModel.log_login_timestamp, (searchModel.log_logout_timestamp?.AddDays(1).AddMilliseconds(-1))).ToList();

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    // TODO: Handle failure
                    trans.Rollback();
                }
                finally
                {
                    trans.Dispose();
                }
            }

            log.MethodFinish();

            return(objList);
        }
예제 #2
0
        public async Task <List <LogUserLoginDTO> > GetListByModelAsync(LogUserLoginDTO searchData)
        {
            List <LogUserLoginDTO> objList = new List <LogUserLoginDTO>();

            objList = await _apiHelper.GetDataListByModelAsync <LogUserLoginDTO, LogUserLoginDTO>("loginlog_api/Get_ListByModel", searchData);

            return(objList);
        }
        public IEnumerable <LogUserLoginDTO> Get_ListByModel([FromBody] LogUserLoginDTO searchModel)
        {
            var objReturn = _service.GetListWithModel(searchModel);

            return(objReturn);
        }