public IQueryable <Article> GetArticles()
{
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Article> query = _db.Articles.OrderByDescending(d => d.DatePosted).Take(3);
return(query);
}
public IQueryable <Models.Member> GetMember([QueryString("email")] string email)
{
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Models.Member> query = _db.Members;
if (email != "")
{
query = query.Where(p => p.Email == email);
}
else
{
query = null;
}
return(query);
}
public IQueryable <Article> GetArticle([QueryString("articleID")] int?articleId)
{
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Article> query = _db.Articles;
if (articleId.HasValue && articleId > 0)
{
query = query.Where(p => p.ArticleID == articleId);
}
else
{
query = null;
}
return(query);
}
public IQueryable <Member> GetMemberByAcceptanceStatus([QueryString("acceptanceStatus")] string acceptanceStatus)
{
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Member> query = _db.Members;
if (acceptanceStatus != "")
{
query = query.Where(p => p.AcceptanceStatus == acceptanceStatus);
}
else
{
query = null;
}
return(query);
}
public IQueryable <Article> GetArticles()
{
string title = Search.Text;
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Article> query = _db.Articles.OrderByDescending(d => d.DatePosted);
if (String.IsNullOrEmpty(title))
{
}
else
{
query = query.Where(p => p.Title == title);
}
return(query);
}
public IQueryable <Member> GetMember()
{
string email = Context.User.Identity.GetUserName();
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Member> query = _db.Members;
if (email != "")
{
query = query.Where(p => p.Email == email);
}
else
{
query = null;
}
return(query);
}
public IQueryable <Member> GetMember()
{
string email = "*****@*****.**";
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Member> query = _db.Members;
if (email != "")
{
query = query.Where(p => p.Email == email);
}
else
{
query = null;
}
return(query);
}
public IQueryable <Member> GetMembers()
{
string firstname = Search.Text;
var _db = new IIIBF_BUK_ALUMNI.Models.ApplicationDbContext();
IQueryable <Member> query = _db.Members.OrderBy(d => d.FirstName);
if (String.IsNullOrEmpty(firstname))
{
query = query.Where(p => p.AcceptanceStatus == "Accepted");
}
else
{
query = query.Where(p => p.AcceptanceStatus == "Accepted" && p.FirstName == firstname);
}
return(query);
}
