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