public List <Trader> GetAssignedUnAssignedUsers(int favOwner) { var traderFav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == favOwner); var res = (from t in _context.Traders where t.TypeFlag == 1 && t.IsActive && t.ID != favOwner select t).ToList(); if (traderFav != null) { foreach (var v in res) { _context.Entry(v).Collection(fl => fl.FavoriteList).Query() .Where(a => a.TraderFavoriteId == traderFav.Id) .Load(); } } return(res); }
public List <TraderPrices> FindByTrader(int traderId) { DateTime today = DateTime.Now.Date; return (context.Set <TraderPrices>() .Where(p => p.TraderID == traderId && p.priceDate >= today) .Select(p => p) .ToList()); }
public BaseRepo() { db = new GoldStreamerContext(); table = db.Set <T>(); }
public BasketPrices FindByBasketId(int basketId) { var basketPrices = _context.Set <BasketPrices>() .SingleOrDefault(x => x.BasketID == basketId && x.IsCurrent && x.PriceDate.Year == DateTime.Now.Year && x.PriceDate.Month == DateTime.Now.Month && x.PriceDate.Day == DateTime.Now.Day); return(basketPrices); }
public List <RolePermission> GetAllRolePermisions() { return(_context.Set <RolePermission>().ToList()); }
public IEnumerable <Prices> GetAllPrices(int traderId, bool fromFavScreen = false) { List <Trader> traderList; if (fromFavScreen == false) { traderList = _context.Set <Trader>().Where(x => x.TypeFlag == 1 && x.IsActive).OrderBy(x => x.SortOrder).ToList(); } else { TraderFavorites traderFav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == traderId); traderList = (_context.Traders.Join(_context.FavorateList, trd => trd.ID, fav => fav.SuperTraderId, (trd, fav) => new { trd, fav }) .Where(@t => @t.fav.TraderFavoriteId == traderFav.Id && @t.trd.IsActive) .Select(@t => @t.trd)).ToList(); } return(GetTraderAllPrice(traderId, traderList)); }
public List <NewsMainCategory> GetNewsMainCatetoryList(string searchText) { return(_context.Set <NewsMainCategory>() .Where(b => b.MainCategoryName.Contains(searchText) || (b.MainCategoryOrder.ToString().Contains(searchText)) || string.IsNullOrEmpty(searchText)).ToList()); }
public List <Feedback> GetAll() { return(_context.Set <Feedback>().ToList()); }
public List <Basket> GetAllBaskerts() { return(_context.Set <Basket>().Where(b => b.IsDeleted == false).ToList()); }
public List <News> GetBySubCategory(int?subCategoryId) { if (subCategoryId == null) { return(_context.Set <News>().OrderByDescending(n => n.Date).ToList()); } return(_context.Set <News>().Where(n => n.CategoryId == subCategoryId).OrderByDescending(n => n.Date).ToList()); }
public Trader FindTraderById(int id) { return(_context.Set <Trader>().AsNoTracking().SingleOrDefault(x => x.ID == id)); }
//public void DeleteAll() //{ // _context.Set<Question>().RemoveRange(GetAll()); //} public List <Question> GetAll() { // return _context.Set<QuestionGroup>().Select(q => q.Questions).Any().ToList(); return(_context.Set <Question>().ToList()); }
public bool HasFavorite(int favoriteOwner) { var fav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == favoriteOwner); return(fav != null); }
public void DeleteBasketUsers(int basketId) { _context.Set <BasketTraders>().RemoveRange(GetBasketUsers(basketId)); }
public BaseRepo(GoldStreamerContext db) { this.db = db; table = db.Set <T>(); }
public virtual IEnumerable <T> Search(Expression <Func <T, bool> > predicate) { return(db.Set <T>().Where(predicate)); }
public List <NewsCategory> GetByMainCategory(int mainCategory) { return(_context.Set <NewsCategory>().Where(c => c.MainCategoryId == mainCategory).ToList()); }
public List <Users> GetByTraderId(int TraderId) { return(_context.Set <Users>().Where(x => x.TraderId == TraderId).ToList()); }
public List <QuestionGroup> GetQuestionGroupList(string searchText) { return(_context.Set <QuestionGroup>() .Where(b => b.GroupName.Contains(searchText) || (b.GroupOrder.ToString().Contains(searchText)) || string.IsNullOrEmpty(searchText)).ToList()); }
public List <TraderPricesChart> getALLPrices() { return(_context.Set <TraderPricesChart>().Include("Trader").ToList()); }
public List <Subscribe> GetAllSubscribes() { return(_context.Set <Subscribe>().Where(b => b.IsSubscribe == true).ToList()); }