private IQueryable <Datasources.VIPMember> GetVIPs() { var code = Request.QueryString["code"]; var db = new Conference2018.Datasources.PSUPICEntities1(); //Get distinct vip code. IQueryable <string> vipCode2018s = db.VIPMembers.Where(v => v.ConferenceAcronym.ToLower() == "psupic2018") .Select(au => au.VIPCode).Distinct(); //Specify vip code IQueryable <string> selectedCodes = (string.IsNullOrWhiteSpace(code)) ? vipCode2018s : vipCode2018s.Where(c => c.ToLower() == code.ToLower()); //Get vip Info. IQueryable <Datasources.VIPMember> result = null; if (selectedCodes != null && selectedCodes.Count() > 0) { result = db.VIPMembers.Where(v => selectedCodes.Contains(v.VIPCode)); } return(result); }
private IEnumerable <Models.Author> GetAuthors() { var authorCode = Request.QueryString["code"]; var db = new Conference2018.Datasources.PSUPICEntities1(); //Get distinct author code. IQueryable <string> authorCode2018s = db.Authors .Where(au => au.Submission.Area.ConferenceAcronym.ToLower() == "psupic2018") .Select(au => au.Code).Distinct(); //Specify author code IQueryable <string> selectedCodes = (string.IsNullOrWhiteSpace(authorCode)) ? authorCode2018s : authorCode2018s.Where(c => c.ToLower() == authorCode.ToLower()); //Get Author Info. List <Models.Author> result = null; if (selectedCodes != null && selectedCodes.Count() > 0) { result = new List <Models.Author>(); foreach (var code in selectedCodes) { result.Add( db.Authors.Where(au => au.Code == code).Select(au => new Models.Author() { Country = au.Country, Email = au.Email, FullName = au.FullName, ID = au.Code, Organization = au.Organization, QRCodePath = au.QRCodePath } ).FirstOrDefault()); } } //IQueryable<Models.Author> author2018 = db.Authors // .Where(au => au.Submission.Area.ConferenceAcronym.ToLower() == "psupic2018") // .Select(au => new Models.Author() // { // ID = au.Code, // Email = au.Email, // FullName = au.FullName, // }).Distinct(); //List<Models.Author> author2018 = new List<Models.Author>(); //List<Models.Author> authors = null; //if (string.IsNullOrWhiteSpace(authorCode)) //{ // authors = author2018.ToList(); //} //else //{ // authors = author2018.Where(c => c.ID.ToLower() == authorCode.ToLower()).ToList(); //} return(result); }