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

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

            bulkUpdatesListViewModel = 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 bulkUpdatesListViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            return(new questStatus(Severity.Success));
        }
        public ActionResult List(BulkUpdatesListViewModel bulkUpdatesListViewModel)
        {
            questStatus status = null;

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

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

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Get list of items.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            BulkUpdatesListViewModel bulkUpdatesListViewModelNEW = null;
            BulkUpdatesListModeler   bulkUpdatesListModeler      = new BulkUpdatesListModeler(this.Request, this.UserSession);

            status = bulkUpdatesListModeler.List(out bulkUpdatesListViewModelNEW);
            if (!questStatusDef.IsSuccess(status))
            {
                bulkUpdatesListViewModel.questStatus = status;
                return(Json(bulkUpdatesListViewModel, JsonRequestBehavior.AllowGet));
            }

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


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

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

            /*----------------------------------------------------------------------------------------------------------------------------------
            * Get list of items.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            // TODO.
            BulkUpdatesListViewModel bulkUpdatesListViewModelNEW = null;
            BulkUpdatesListModeler   usersListModeler            = new BulkUpdatesListModeler(this.Request, this.UserSession);

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

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


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


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


            BulkUpdateLogsMgr bulkUpdateLogsMgr = new BulkUpdateLogsMgr(this.UserSession);

            status = bulkUpdateLogsMgr.Clear();
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            return(new questStatus(Severity.Success));
        }
        public ActionResult Clear(BulkUpdatesListViewModel 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.
            *---------------------------------------------------------------------------------------------------------------------------------*/
            BulkUpdatesListModeler bulkUpdatesListModeler = new BulkUpdatesListModeler(this.Request, this.UserSession);

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

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

            bulkUpdatesListViewModel = null;


            // List
            QueryResponse queryResponse = null;
            List <Quest.Functional.Logging.BulkUpdateLog> bulkUpdateLogList = null;
            BulkUpdateLogsMgr bulkUpdateLogsMgr = new BulkUpdateLogsMgr(this.UserSession);

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

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


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

            status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
            if (!questStatusDef.IsSuccess(status))
            {
                return(status);
            }
            bulkUpdatesListViewModel.QueryResponse = queryResponseViewModel;
            foreach (Quest.Functional.Logging.BulkUpdateLog bulkUpdateLog in bulkUpdateLogList)
            {
                BulkUpdateLineItemViewModel bulkUpdateLineItemViewModel = new BulkUpdateLineItemViewModel();
                BufferMgr.TransferBuffer(bulkUpdateLog, bulkUpdateLineItemViewModel);
                bulkUpdatesListViewModel.Items.Add(bulkUpdateLineItemViewModel);
            }
            return(new questStatus(Severity.Success));
        }
        public questStatus Page(out BulkUpdatesListViewModel bulkUpdatesListViewModel)
        {
            // Initialize
            questStatus status = null;

            bulkUpdatesListViewModel = 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.BulkUpdateLog> bulkUpdateLogList = null;
            BulkUpdateLogsMgr bulkUpdateLogsMgr = new BulkUpdateLogsMgr(this.UserSession);

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

            // Transfer model.
            bulkUpdatesListViewModel = new BulkUpdatesListViewModel(this.UserSession);
            foreach (Quest.Functional.Logging.BulkUpdateLog bulkUpdateLog in bulkUpdateLogList)
            {
                BulkUpdateLineItemViewModel bulkUpdateLineItemViewModel = new BulkUpdateLineItemViewModel();
                BufferMgr.TransferBuffer(bulkUpdateLog, bulkUpdateLineItemViewModel);
                bulkUpdatesListViewModel.Items.Add(bulkUpdateLineItemViewModel);
            }
            return(new questStatus(Severity.Success));
        }
        /*==================================================================================================================================
        * Private Methods
        *=================================================================================================================================*/

        #region Export Routines
        //----------------------------------------------------------------------------------------------------------------------------------
        // Export Routines
        //----------------------------------------------------------------------------------------------------------------------------------
        private void writeTsv(BulkUpdatesListViewModel bulkUpdatesListViewModel, TextWriter output)
        {
            PropertyInfo[] propertyInfos = typeof(BulkUpdateLineItemViewModel).GetProperties();
            foreach (PropertyInfo pi in propertyInfos)
            {
                output.Write(pi.Name); // header
                output.Write("\t");
            }
            output.WriteLine();
            foreach (BulkUpdateLineItemViewModel lineItem in bulkUpdatesListViewModel.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();
            }
        }