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)); }
//-------------------- 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)); }