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