public ActionResult BatchList(string FILENAME, string SERVICENAME, string HASERROR, string TYPE, int?page) { WebView.WebService._base myWebService; myWebService = new WebService._base(); WebService._base.BiBatch BiBatchMain = new WebService._base.BiBatch(); if (FILENAME != null || SERVICENAME != null) { if (FILENAME.Equals("Select") && SERVICENAME.Equals("Select") && HASERROR.Equals("false") && TYPE.Equals("Select")) { BiBatchMain = myWebService.GetBatch(0, 100000, null, null, null, null); } else { BiBatchMain = myWebService.GetBatch(0, 100000, FILENAME, SERVICENAME, HASERROR, TYPE); } } else { BiBatchMain = myWebService.GetBatch(0, 100000, null, null, null, null); } 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; using (EntitiesNetworkElement ctxData = new EntitiesNetworkElement()) { //filter FILENAME List <SelectListItem> list3 = new List <SelectListItem>(); var queryFILENAME = from p in ctxData.BI_BATCH select new { Text = p.INSTANCE_ID, Value = p.INSTANCE_ID }; list3.Add(new SelectListItem() { Text = "", Value = "Select" }); foreach (var a in queryFILENAME.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list3.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.FILENAME = list3; //filter servicename List <SelectListItem> list2 = new List <SelectListItem>(); var querySERVICENAME = from p in ctxData.BI_BATCH select new { Text = p.SERVICE_NAME, Value = p.SERVICE_NAME }; list2.Add(new SelectListItem() { Text = "", Value = "Select" }); foreach (var a in querySERVICENAME.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list2.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.SERVICENAME = list2; List <SelectListItem> list1 = new List <SelectListItem>(); list1.Add(new SelectListItem() { Text = "", Value = "Select" }); list1.Add(new SelectListItem() { Text = "INBOUND", Value = "INBOUND" }); list1.Add(new SelectListItem() { Text = "OUTBOUND", Value = "OUTBOUND" }); ViewBag.TYPE = list1; if (HASERROR == "true") { ViewBag.HASERROR = "true"; } else { ViewBag.HASERROR = "false"; } } int pageSize = 15; int pageNumber = (page ?? 1); ViewBag.FILENAME_1 = FILENAME; ViewBag.SERVICENAME_1 = SERVICENAME; ViewBag.HASERROR_1 = HASERROR; ViewBag.TYPE_1 = TYPE; return(View(BiBatchMain.bacthList.ToPagedList(pageNumber, pageSize))); }