public ActionResult Index() { var listdata = new List <SpGetprospectinglistforclient_Result>(); string username = User.Identity.Name; if (username != "") { var data = context.UserProspectingLists.Where(x => x.UserId == username).FirstOrDefault(); listdata = context.SpGetprospectinglistforclient(username).ToList(); if (data != null) { List <int> listIds = data.listid.Split(',').Select(int.Parse).ToList(); listdata = listdata.Where(x => x.Userid.ToUpper() == username.ToUpper() || listIds.Contains(x.listid)).ToList();// (from d in listdata where (d.Userid.ToUpper() == username.ToUpper()) || (listIds.Contains(d.listid)) select d).ToList(); } else { listdata = listdata.Where(x => x.Userid.ToUpper() == username.ToUpper()).ToList(); } } return(View(listdata)); }