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