/*==================================================================================================================================
        * Public Methods
        *=================================================================================================================================*/

        #region LIST
        //----------------------------------------------------------------------------------------------------------------------------------
        // LIST
        //----------------------------------------------------------------------------------------------------------------------------------
        public questStatus List(out PortalRequestsListViewModel portalRequestsListViewModel)
        {
            // Initialize
            questStatus status = null;

            portalRequestsListViewModel = null;


            // Get query options from query string
            QueryOptions    queryOptions    = null;
            BaseListModeler baseListModeler = new BaseListModeler(this.HttpRequestBase, new UserSession());

            status = baseListModeler.ParsePagingOptions(this.HttpRequestBase, out queryOptions);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }

            // List
            status = List(queryOptions, out portalRequestsListViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            return(new questStatus(Severity.Success));
        }
        public ActionResult List(PortalRequestsListViewModel portalRequestsListViewModel)
        {
            questStatus status = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(portalRequestsListViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Get list of items.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            PortalRequestsListViewModel portalRequestsListViewModelNEW = null;
            PortalRequestsListModeler   portalRequestsListModeler      = new PortalRequestsListModeler(this.Request, this.UserSession);

            status = portalRequestsListModeler.List(out portalRequestsListViewModelNEW);
            if (!questStatusDef.IsSuccess(status))
            {
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return result view model or as Excel
            *---------------------------------------------------------------------------------------------------------------------------------*/
            if (portalRequestsListViewModel.bExportToExcel)
            {
                string filename = "PortalRequestsLog_" + DateTime.Now.ToString();
                Response.ClearContent();
                Response.AddHeader("content-disposition", "atachment;filename=" + filename + ".xls");
                Response.AddHeader("Content-Type", "application/vnd.ms-excel");
                writeTsv(portalRequestsListViewModelNEW, Response.Output);
                Response.Flush();
                Response.End();
                return(new EmptyResult());
            }
            else
            {
                status = new questStatus(Severity.Success);
                portalRequestsListViewModelNEW.questStatus = status;
                return(Json(portalRequestsListViewModelNEW, JsonRequestBehavior.AllowGet));
            }
        }
        public ActionResult Next(PortalRequestsListViewModel portalRequestsListViewModel)
        {
            questStatus status = null;


            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                status = new questStatus(Severity.Success);
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(portalRequestsListViewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                status = new questStatus(Severity.Success);
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Get list of items.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            // TODO.
            PortalRequestsListViewModel portalRequestsListViewModelNEW = null;
            PortalRequestsListModeler   usersListModeler = new PortalRequestsListModeler(this.Request, this.UserSession);

            status = usersListModeler.List(out portalRequestsListViewModelNEW);
            if (!questStatusDef.IsSuccess(status))
            {
                status = new questStatus(Severity.Success);
                portalRequestsListViewModel.questStatus = status;
                return(Json(portalRequestsListViewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return view
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = new questStatus(Severity.Success);
            portalRequestsListViewModelNEW.questStatus = status;
            return(Json(portalRequestsListViewModelNEW, JsonRequestBehavior.AllowGet));
        }
        //----------------------------------------------------------------------------------------------------------------------------------
        // Options
        //----------------------------------------------------------------------------------------------------------------------------------
        #endregion


        #region Validations
        //----------------------------------------------------------------------------------------------------------------------------------
        // Validations
        //----------------------------------------------------------------------------------------------------------------------------------
        #endregion


        #region Commands
        //----------------------------------------------------------------------------------------------------------------------------------
        // Commands
        //----------------------------------------------------------------------------------------------------------------------------------
        public questStatus Clear(PortalRequestsListViewModel portalRequestsListViewModel)
        {
            // Initialize
            questStatus status = null;


            PortalRequestLogsMgr portalRequestLogsMgr = new PortalRequestLogsMgr(this.UserSession);

            status = portalRequestLogsMgr.Clear();
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            return(new questStatus(Severity.Success));
        }
        public ActionResult Clear(PortalRequestsListViewModel viewModel)
        {
            questStatus status = null;

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Log Operation
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = LogOperation();
            if (!questStatusDef.IsSuccess(status))
            {
                viewModel.questStatus = status;
                return(Json(viewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Authorize
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = Authorize(viewModel._ctx);
            if (!questStatusDef.IsSuccess(status))
            {
                viewModel.questStatus = status;
                return(Json(viewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Perform operation.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            PortalRequestsListModeler portalRequestsListModeler = new PortalRequestsListModeler(this.Request, this.UserSession);

            status = portalRequestsListModeler.Clear(viewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                viewModel.questStatus = status;
                return(Json(viewModel, JsonRequestBehavior.AllowGet));
            }

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Return result.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            status = new questStatus(Severity.Success, "PortalRequest log successfully cleared");
            viewModel.questStatus = status;
            return(Json(viewModel, JsonRequestBehavior.AllowGet));
        }
        public questStatus List(QueryOptions queryOptions, out PortalRequestsListViewModel portalRequestsListViewModel)
        {
            // Initialize
            questStatus status = null;

            portalRequestsListViewModel = null;


            // List
            QueryResponse queryResponse = null;
            List <Quest.Functional.Logging.PortalRequestLog> portalRequestLogList = null;
            PortalRequestLogsMgr portalRequestLogsMgr = new PortalRequestLogsMgr(this.UserSession);

            status = portalRequestLogsMgr.List(queryOptions, out portalRequestLogList, out queryResponse);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }

            // Sort
            portalRequestLogList.Sort(delegate(Quest.Functional.Logging.PortalRequestLog i1, Quest.Functional.Logging.PortalRequestLog i2) { return(i2.Created.CompareTo(i1.Created)); });


            // Transfer model.
            // TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsViewModel.
            portalRequestsListViewModel = new PortalRequestsListViewModel(this.UserSession);
            QueryResponseViewModel queryResponseViewModel = null;

            status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            portalRequestsListViewModel.QueryResponse = queryResponseViewModel;
            foreach (Quest.Functional.Logging.PortalRequestLog portalRequestLog in portalRequestLogList)
            {
                PortalRequestLineItemViewModel portalRequestLineItemViewModel = new PortalRequestLineItemViewModel();
                BufferMgr.TransferBuffer(portalRequestLog, portalRequestLineItemViewModel);
                portalRequestsListViewModel.Items.Add(portalRequestLineItemViewModel);
            }
            return(new questStatus(Severity.Success));
        }
        public questStatus Page(out PortalRequestsListViewModel portalRequestsListViewModel)
        {
            // Initialize
            questStatus status = null;

            portalRequestsListViewModel = null;


            // Set up query options.
            // TEMPORARY: OPTIMIZE THIS
            List <SearchField> searchFieldList = new List <SearchField>();

            SearchOptions searchOptions = new SearchOptions();

            searchOptions.SearchFieldList = searchFieldList;

            QueryOptions queryOptions = new QueryOptions(100, 1);

            queryOptions.SearchOptions = searchOptions;
            QueryResponse queryResponse = null;


            // List
            List <Quest.Functional.Logging.PortalRequestLog> portalRequestLogList = null;
            PortalRequestLogsMgr portalRequestLogsMgr = new PortalRequestLogsMgr(this.UserSession);

            status = portalRequestLogsMgr.List(queryOptions, out portalRequestLogList, out queryResponse);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }

            // Transfer model.
            portalRequestsListViewModel = new PortalRequestsListViewModel(this.UserSession);
            foreach (Quest.Functional.Logging.PortalRequestLog portalRequestLog in portalRequestLogList)
            {
                PortalRequestLineItemViewModel portalRequestLineItemViewModel = new PortalRequestLineItemViewModel();
                BufferMgr.TransferBuffer(portalRequestLog, portalRequestLineItemViewModel);
                portalRequestsListViewModel.Items.Add(portalRequestLineItemViewModel);
            }
            return(new questStatus(Severity.Success));
        }
        /*==================================================================================================================================
        * Private Methods
        *=================================================================================================================================*/

        #region Export Routines
        //----------------------------------------------------------------------------------------------------------------------------------
        // Export Routines
        //----------------------------------------------------------------------------------------------------------------------------------
        private void writeTsv(PortalRequestsListViewModel portalRequestsListViewModel, TextWriter output)
        {
            PropertyInfo[] propertyInfos = typeof(PortalRequestLineItemViewModel).GetProperties();
            foreach (PropertyInfo pi in propertyInfos)
            {
                output.Write(pi.Name); // header
                output.Write("\t");
            }
            output.WriteLine();
            foreach (PortalRequestLineItemViewModel lineItem in portalRequestsListViewModel.Items)
            {
                foreach (PropertyInfo pi in propertyInfos)
                {
                    object _value = pi.GetValue(lineItem);
                    string value  = _value == null ? "(null)" : _value.ToString().Replace("\t", " ").Replace("\r", " ").Replace("\n", " ");
                    output.Write(value);
                    output.Write("\t");
                }
                output.WriteLine();
            }
        }