public ActionResult BOQ_MAIN_List(string searchNo, string searchIDNo, string searchType, string searchIDType, string searchExc, string searchIDExc, string searchYear, string searchIDYear) { WebView.WebService._base myWebService; myWebService = new WebService._base(); WebService._base.OSPBOQ_MAIN BOQ_MAIN = new WebService._base.OSPBOQ_MAIN(); if (searchNo != null && searchType != null && searchExc != null && searchYear != null) { if (searchNo.Equals("") && searchType.Equals("") && searchExc.Equals("") && searchYear.Equals("")) { BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, null, null, null, null, null, null, null, null); } else { BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, searchNo, searchIDNo, searchType, searchIDType, searchExc, searchIDExc, searchYear, searchIDYear); ViewBag.searchNo = searchNo; ViewBag.searchType = searchType; ViewBag.searchExc = searchExc; ViewBag.searchYear = searchYear; } } else { BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, null, null, null, null, null, null, null, null); ViewBag.searchNo = ""; ViewBag.searchType = ""; ViewBag.searchExc = ""; ViewBag.searchYear = ""; } ViewData["data2"] = BOQ_MAIN.BOQ_MAINList; using (Entities ctxData = new Entities()) { var query = from p in ctxData.WV_BOQ_DATA orderby p.SCH_NO ascending select new { Text = p.SCH_NO, Value = p.SCH_NO }; List <SelectListItem> list = new List <SelectListItem>(); list.Add(new SelectListItem() { Text = "Select", Value = "Select" }); foreach (var a in query.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.x_SCH_NO = list; } using (Entities ctxData = new Entities()) { var query = from p in ctxData.WV_BOQ_DATA orderby p.SCH_TYPE ascending select new { Text = p.SCH_TYPE, Value = p.SCH_TYPE }; List <SelectListItem> list = new List <SelectListItem>(); list.Add(new SelectListItem() { Text = "Select", Value = "Select" }); foreach (var a in query.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.x_SCH_TYPE = list; } using (Entities ctxData = new Entities()) { var query = from p in ctxData.WV_BOQ_DATA orderby p.EXC_ABB ascending select new { Text = p.EXC_ABB, Value = p.EXC_ABB }; List <SelectListItem> list = new List <SelectListItem>(); list.Add(new SelectListItem() { Text = "Select", Value = "Select" }); foreach (var a in query.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.x_EXC_ABB = list; } using (Entities ctxData = new Entities()) { var query = from p in ctxData.WV_BOQ_DATA orderby p.YEAR_INSTALL ascending select new { Text = p.YEAR_INSTALL, Value = p.YEAR_INSTALL }; List <SelectListItem> list = new List <SelectListItem>(); list.Add(new SelectListItem() { Text = "Select", Value = "Select" }); foreach (var a in query.Distinct().OrderBy(it => it.Value)) { if (a.Value != null) { list.Add(new SelectListItem() { Text = a.Text.ToString(), Value = a.Value.ToString() }); } } ViewBag.x_YEAR_INSTALL = list; } return(View()); }