public ActionResult PlanUnit_List(string searchKey, string billrate, string searchUOM, int?page) { WebView.WebService._base myWebService; myWebService = new WebService._base(); WebService._base.OSPPlanUnit PlanUnit = new WebService._base.OSPPlanUnit(); //if (billrate == null) //{ // billrate = "Select"; //} //if (UOM == null) //{ // UOM = "Select"; //} if (searchKey != null || billrate != "Select" || searchUOM != null) { if (searchKey == "" && billrate == "Select" && searchUOM.Equals("Select")) { System.Diagnostics.Debug.WriteLine("Controller 1 " + " Search key : " + searchKey + " | search UOM : " + searchUOM + " search bill : " + billrate); PlanUnit = myWebService.GetOSPPlanUnit(0, 100000, null, null, null); ViewBag.searchKey = ""; ViewBag.billrate2 = "Select"; ViewBag.UOM2 = "Select"; } else { System.Diagnostics.Debug.WriteLine("Controller 2 " + " Search key : " + searchKey + " | search UOM : " + searchUOM + " search bill : " + billrate); PlanUnit = myWebService.GetOSPPlanUnit(0, 100000, searchKey, billrate, searchUOM); ViewBag.searchKey = searchKey; ViewBag.billrate2 = billrate; ViewBag.UOM2 = searchUOM; } } else { System.Diagnostics.Debug.WriteLine("Controller 3 " + " Search key : " + searchKey + " | search UOM : " + searchUOM + " search bill : " + billrate); PlanUnit = myWebService.GetOSPPlanUnit(0, 100000, null, null, null); ViewBag.searchKey = ""; ViewBag.billrate2 = "Select"; ViewBag.searchUOM = "Select"; } ViewData["data7"] = PlanUnit.PlanUnitList; string input = "\\\\adsvr"; //string input = "\\\\server\\d$\\x\\y\\z\\AAA"; string output = String.Format("http:{0}", input.Replace("\\d$\\x\\y", String.Empty).Replace("\\", "/")); ViewBag.output = output; List <SelectListItem> list = new List <SelectListItem>(); list.Add(new SelectListItem() { Text = "", Value = "Select" }); list.Add(new SelectListItem() { Text = "D", Value = "D" }); list.Add(new SelectListItem() { Text = "N", Value = "N" }); list.Add(new SelectListItem() { Text = "P", Value = "P" }); list.Add(new SelectListItem() { Text = "W", Value = "W" }); ViewBag.billrate = list; using (Entities ctxData = new Entities()) { var query = (from q in ctxData.WV_PU_MAST select new { Text = q.PU_UOM, Value = q.PU_UOM }); List <SelectListItem> list2 = new List <SelectListItem>(); list2.Add(new SelectListItem() { Text = "", Value = "Select" }); foreach (var a in query.Distinct().OrderBy(it => it.Value)) { list2.Add(new SelectListItem() { Text = a.Text, Value = a.Value }); } ViewBag.UOM = list2; } //return View(); int pageSize = 10; int pageNumber = (page ?? 1); return(View(PlanUnit.PlanUnitList.ToPagedList(pageNumber, pageSize))); }