Пример #1
0
        public ActionResult AdvancedSearch(ContractAdvancedSearchViewModel AdvancedSearchViewModel)
        {
            if (db.ContractStatuses != null)
            {
                AdvancedSearchViewModel.ContractStatuses = new SelectList(db.ContractStatuses, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractStatuses = new SelectList(new[] { "No Status" });
            }


            if (db.ContractTypes != null)
            {
                AdvancedSearchViewModel.ContractTypes = new SelectList(db.ContractTypes, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractTypes = new SelectList(new[] { "No Type" });
            }


            if (db.ContractSubTypes != null)
            {
                AdvancedSearchViewModel.ContractSubTypes = new SelectList(db.ContractSubTypes, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractSubTypes = new SelectList(new[] { "No ContractSubType" });
            }


            if (db.ContractKinds != null)
            {
                AdvancedSearchViewModel.ContractKinds = new SelectList(db.ContractKinds, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractKinds = new SelectList(new[] { "No Kind" });
            }
            if (db.Departments != null)
            {
                AdvancedSearchViewModel.Departments = new SelectList(db.Departments, "Id", "DepartmentName");
            }
            else
            {
                AdvancedSearchViewModel.Departments = new SelectList(new[] { "No Department" });
            }
            if (db.CostCenters != null)
            {
                AdvancedSearchViewModel.CostCenters = new SelectList(db.CostCenters, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.CostCenters = new SelectList(new[] { "No CostCenter" });
            }
            if (db.CostKinds != null)
            {
                AdvancedSearchViewModel.CostKinds = new SelectList(db.CostKinds, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.CostKinds = new SelectList(new[] { "No CostKind" });
            }



            var    search       = new ContractSearchLogic();
            string CmdQueryText = search.GenerateQuery(AdvancedSearchViewModel);

            search.GetContracts(CmdQueryText, AdvancedSearchViewModel);

            return(View(AdvancedSearchViewModel));
        }
Пример #2
0
        //-------------------- Moses ------------------
        // GET: Contract/AdvancedSearch
        public ActionResult AdvancedSearch()
        {
            var AdvancedSearchViewModel = new ContractAdvancedSearchViewModel();

            if (db.ContractStatuses != null)
            {
                AdvancedSearchViewModel.ContractStatuses = new SelectList(db.ContractStatuses, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractStatuses = new SelectList(new[] { "No Status" });
            }


            if (db.ContractTypes != null)
            {
                AdvancedSearchViewModel.ContractTypes = new SelectList(db.ContractTypes, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractTypes = new SelectList(new[] { "No Type" });
            }


            if (db.ContractSubTypes != null)
            {
                AdvancedSearchViewModel.ContractSubTypes = new SelectList(db.ContractSubTypes, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractSubTypes = new SelectList(new[] { "No ContractSubType" });
            }


            if (db.ContractKinds != null)
            {
                AdvancedSearchViewModel.ContractKinds = new SelectList(db.ContractKinds, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.ContractKinds = new SelectList(new[] { "No Kind" });
            }
            if (db.Departments != null)
            {
                AdvancedSearchViewModel.Departments = new SelectList(db.Departments, "Id", "DepartmentName");
            }
            else
            {
                AdvancedSearchViewModel.Departments = new SelectList(new[] { "No Department" });
            }
            if (db.CostCenters != null)
            {
                AdvancedSearchViewModel.CostCenters = new SelectList(db.CostCenters, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.CostCenters = new SelectList(new[] { "No CostCenter" });
            }
            if (db.CostKinds != null)
            {
                AdvancedSearchViewModel.CostKinds = new SelectList(db.CostKinds, "Id", "Description");
            }
            else
            {
                AdvancedSearchViewModel.CostKinds = new SelectList(new[] { "No CostKind" });
            }



            return(View(AdvancedSearchViewModel));
        }